Principal Consultant-PROD DBA Engineer

Genpact

Noida, Uttar Pradesh
Permanent
Full-time

26 days ago

With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we’re calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing., People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.
Welcome to the relentless pursuit of better.Inviting applications for the role of Principal Consultant, Production Support Database Administrator Engineers!Responsibilities
o Senior Production Support Database Administrator Engineers
Key Technical Skills:

SQL Server Management Studio – Mandatory
Good T-SQL coder/developer skills - Basic
Command line – Basic
Powershell – Basic
NewRelic - Good to have

MSSQL Database administration:

In-depth knowledge on Microsoft SQL SERVER database Administration2014,2016,2017,2019
Installation (Standalone, Always On, Distributed AGs)
SQL Server Security Management – Windows & SQL Authentication, Creating Logins, Database Users, Server roles, Database roles, Permissions – Server level, DB level, Object level,working with Managed Service Accounts (SMA), Server Principal Names (SPNs)
Implementing and managing the Database backup and restore strategies, including third party Backup tools, example: Rubrik,TSM
Skills in Performance Tuning, troubleshooting\Root Cause Analysis (Perf. Monitor/SQL Server Profiler/Database tuning advisor/Extended events)
Good Knowledge on Indexes, Statistics, analyzing the execution plan, deadlocks, blockings, Parameter sniffing, lock escalation, MAX DOP, Cost threshold Parallelism
Good knowledge on memory concepts – buffer pool, procedure cache, PLE, memory grants pending…etc

Application Performance Monitoring (APM) :

Good knowledge on Observability tools Diagnostic tools (ex : New Relic ), monitoring Database health components ( Eyes on Glass)
Good knowledge on Always On, Distributed availability Groups configuration and troubleshooting sync issues.
Good understanding on TempDB behavior
SQL Server Agent, working with Agent Jobs, MSX

Good To Have :

Change Data Capture (CDC), Query store
T-SQL development & Query optimization, PowerShell scripting
Cloud exposure and multi Database technologies(Oracle\MongoDB\Postgres..etc)

Key Soft Skills:

Pattern Recognition

o Pattern recognition is a data analysis method that uses machine learning algorithms to automatically recognize patterns and regularities in data. This data can be anything from text and images to sounds or other definable qualities.

Being Proactive
Being Curious
Being Resourceful

o Resourcefulness is defined as the ability and creativity to cope with difficult situations, or unusual problems. It is about problem-solving and getting things done in the face of obstacles and constraints.

THINKING skills
TROUBLESHOOTING skills
A "systems" view of things (maybe comparing a mechanic to a driver)
Patience

o Patience (or forbearance) is the ability to endure difficult circumstances. Patience may involve perseverance in the face of delay; tolerance of provocation without responding with disrespect or anger; forbearance when under strain, especially when faced with longer-term difficulties.Qualifications we seek in you!
Minimum Qualifications

Bachelor’s/ Master’s in computer science or related disciplines.
Relevant experience for Lead Consultant
Relevant experience for Principal Consultant
Excellent oral and written communication is a must.
Ability to understand business requirements and translate them into technical requirements

Preferred Qualifications/ Skills

Same as Minimum qualifications

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. For more information, visit . Follow us on Twitter, Facebook, LinkedIn, and YouTube.
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.

Genpact

Apply Now