Principal Consultant, Data Base Administrator MS SQL

$60,000 - $75,000/Yr

Genpact - Antioch, CA

Full-time - Principal

Antioch, CA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Principal Consultant, Data Base Administrator MS SQL at Genpact is responsible for managing and operating Microsoft SQL Server database instances. This role involves optimizing configuration settings, performing database backups and restores, developing and running optimization tasks, and composing automation scripts for repetitive tasks. The position requires excellent communication skills, the ability to work independently, and a dedication to providing outstanding customer service.

Responsibilities

• Manage and operate Microsoft SQL Server database instances.
• Optimize configuration settings for SQL Server databases.
• Perform database backups and restores.
• Develop and run optimization tasks for database performance.
• Compose automation scripts for repetitive tasks.
• Research viable technical and non-technical solutions.
• Share knowledge with the team and leverage internal networks.

Requirements

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

Nice-to-haves

• Solid MS SQL Server DBA experience (SQL 2012-2019).
• Strong database design skills.
• Expertise in SQL statement tuning.
• Experience with native transactional data replication.
• Experience in configuring Always-On Availability Groups (including Windows Clustering).
• Experience with deploying and managing Cloud Database Services (AWS/Azure preferred).
• Familiarity with Oracle Database technology (versions 11g, 12c, 18c, and 19c).
• Familiarity with Datadog as a monitoring and analytics tool.
• Familiarity with MySQL and PostgreSQL.

Benefits

• Competitive salary range of $60,000 to $75,000 per year.
• Equal Opportunity Employer with a commitment to diversity and inclusion.