Lead Consultant - SQL Server DBA with Azure administration

*

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Lead Consultant, SQL Server DBA with Azure administration
This profile requires strong SQL DBA experience with strong azure cloud knowledge.

Responsibilities
Extensive experience in managing SQL Server Databases in Production environment with good exposure on Azure Cloud.
Azure DevOps Experience in (pipelines, deployments, etc.,)
Hybrid cloud (Azure + on Prem)
Azure portal knowledge
SQL Tuning
Good SSIS knowledge
Lead requirements gathering, analysis and solution development for Database Administration and migration projects.
Lead projects, remotely, in a hands-on role driving database, cloud migration/adoption from inception to production.
Partner with project teams, functional architects, systems specialists, and other technical resources and customers
Design and implement relational database models.
Apply expertise in Microsoft SQL Server internals, optimizer, and tools.
Administer large, high-volume production database environments.
Optimize performance.
Ensure cross-platform schema synchronization.
Perform regular log reviews and health checks.
Diagnose and correct errors.

Qualifications we seek in you
Minimum Qualifications / Skills
Experience leading cloud migration projects from MS SQL Server to Azure SQL
Experience in SQL Server architecture and Production Support DBA.
Current knowledge of Microsoft SQL Server 2012 2019 Suite including (SSMS, SSIS, Query Profiler)
Expert knowledge of Relational Database Modeling and SQL Server Internals
Extensive understanding of relational database design, common table expressions (CTEs), and Test-Driven Development (TDD)
Expert knowledge of DMVs, System Stored Procedures, User Defined Functions, and Custom Types
Advanced knowledge of SQL Servers Always OnAvailability Group feature
Expert knowledge in OLTP and Linked Servers including how to secure them.
Expert understanding of SQL Server security at both server and database levels.
Advanced knowledge and demonstrated ability in Query / Index tuning using Performance monitor statistics.
Sound knowledge of database migration best practices for low risk and minimum downtime
Excellent communication and organizational skills

Preferred Qualifications/ Skills
In-depth knowledge of backing up, restoring, and moving SQL databases along with the ability to plan and implement sophisticated Disaster Recovery strategies.
Database Design, Maintenance, Security, Management and Analysis.
Experience using SQL Sentry to monitor, troubleshoot and resolve performance issues.
High-level knowledge of Windows and Windows security and how they affect SQL Server.
Possess a strong understanding of database theories, principles, and best practices.
Excellent analytical and problem-solving skills.
Excellent written and verbal communication skills.
Be self-motivated, able to work independently as well as in a collaborative.
PowerShell scripting.
Experience and knowledge of SQL Server Reporting Services and T-SQL development.
Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit, paying to apply, or purchasing equipment or training.