Principal Consultant, Data Base Administrator MS SQL (ITO083948)

Job Description - Principal Consultant, Data Base Administrator MS SQL (ITO083948)

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 Principal Consultant, Data Base Administrator MS SQL

Responsibilities

1. Responsible for managing and operating Microsoft SQL Server database instances; optimizing configuration settings, performing database backups & restores, developing and running optimization tasks, composing automation scripts for repetitive tasks, etc.
2. Should be experienced with the most recent releases of SQL Server including the related products of Integration Services, Reporting Services, and Analysis Services.
3. Excellent communication skills, work well in a team, and are dedicated to providing outstanding customer service.
4. Working independently with minimal supervision.
5. Individually execute and deliver on day-to-day activities.
6. Perform research of viable technical and/or non-technical solutions.
7. Share knowledge with the Team.
8. Leverage internal networks in role and viewed by stakeholders as skilled specialist.

Minimum Qualifications / Skills

1. Bachelor’s degree in computer science, Information Technology, or a related field (or equivalent work experience).
2. Experience in managing SQL Server databases, T-SQL programming, knowledge of third form normalization design principles and indexing best practices.
3. Strong communication and written skills.
4. Experience creating technical documentation.

Preferred Qualifications/ Skills

1. Solid MS SQL Server DBA experience (SQL 2012-2019).
2. Expertise in SQL Statement Tuning.
3. Experience with native transactional Data Replication.
4. Experience in configuring Always-On Availability Groups (incl. Windows Clustering).
5. Experience with deploying and managing Cloud Database Services (AWS/Azure preferred) like AWS DynamoDB, AWS RDS, Azure SQL, Azure Cosmos DB.
6. Experience with Cloud automation deployment (e.g., Terraform for SQL RDS).
7. Good understanding of networking concepts in cloud (VPCs, Subnets, Security Groups, etc).
8. Strong T-SQL Programming capabilities.
9. PowerShell and/or Python scripting capabilities.
10. Familiarity with Oracle Database technology (versions 11g, 12c, 18c, and 19c) a plus.
11. Familiarity with Datadog as a monitoring and analytics tool.
12. Familiarity with MySQL and PostgreSQL a plus.
13. Maintain Server and DB Auditing.
14. Excellent troubleshooting and problem-solving abilities.

The approximate annual base compensation range for this position is ($60,000 to $75,000). The actual offer, reflecting the total compensation package plus benefits, will be determined by a number of factors which include but are not limited to the applicant’s experience, knowledge, skills, and abilities; geographic location; and internal equity.

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.