.Job Title: SQL Server ConsultantCompany: InfosysRequisition ID: 125074BRAs a consultant, you will anchor the engagement effort for Implementation, Configuration, and administration for SQL-based Business Infrastructure for different applications and Databases. You will work with client/offshore teams based out of India to provide support services.You should be experienced in SQL administration, Database Architecture Designs Solutions, Migrations, and using high-level functional systems design, HA configurations, documentation, and implementation methodologies on problems which require in-depth knowledge of the subject matter for effective implementation and operational needs.Qualifications BasicCandidate must be located within Mexico or be willing to relocate to the area. An Associate or Bachelor's degree or foreign equivalent is required from an accredited institution. We will also consider three years of progressive experience in the specialty in lieu of every year of education.8 years of experience in Microsoft SQL Server 2012 to 2022 Database Administration.Microsoft certified in AZURE fundamentals and SQL DBA.Proficiency in configuration, implementation, administration, and troubleshooting.SkillsInstallation and Configuration of different versions of SQL servers.Upgradation and Migration of SQL server from lower to higher versions.SQL Access management process, including creation of login and user access.Database refresh activity from production to non-production servers.Knowledge of Performance troubleshooting (Server, Query, and database level).Database health monitoring using IDERA tool.Database backup and restore using recovery models (Backup tool: Cohesity).Knowledge of T-SQL scripts and stored procedures.Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.Knowledge in database migration from on-premises to cloud (IAAS, PAAS models).Alerts configurations and troubleshooting on Azure MI and SQL VM.Capacity planning and monitoring database growth.Experience working with Windows server, including Active Directory.ResponsibilitiesManage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.Refine and automate regular processes, track issues, and document changes.Assist developers with complex query tuning and schema refinement.Provide 24x7 support for critical production systems