Genpact
Location
Hyderabad | India
Job description
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 [Lead Consultant/ Principal Consultant], [PROD DBA Engineers]! In-depth knowledge on Microsoft SQL SERVER database Administration 2014,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, analysing 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. 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 Temp DB behavior SQL Server Agent, working with Agent Jobs, MSX • Good to have : Change Data Capture (CDC), Query store Good to have : T-SQL development & Query optimization, PowerShell scripting Good to have : Cloud exposure and multi Database technologies(Oracle\MongoDB\Postgres..etc) Qualifications we seek in you! Minimum Qualifications · Bachelor’s/ master’s in computer science or related disciplines. · 4+ years of relevant experience for Lead Consultant · 8+ years of relevant experience for Principal Consultant · Excellent oral and written communication is a must. · Ability to understand business requirements and translate them into technical requirements. 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.Job tags
Salary
