Lead Consultant - MS SQL DBA

Genpact; Hyderabad; On-site; INR 9,00,000 - 12,00,000; Full time

Job summary

Join a forward-thinking company as a Lead Consultant - MS SQL DBA, where your expertise in database administration will shape the future of data management. In this dynamic role, you will be responsible for monitoring and optimizing database performance, ensuring robust backup and recovery solutions, and enhancing disaster recovery processes. Collaborate with diverse teams to implement improvements and maintain documentation, all while contributing to a culture that values innovation and inclusion. If you are passionate about leveraging your skills to drive impactful changes, this opportunity is perfect for you.

Qualifications

• Bachelor's Degree required, preferably in Computer Science or related field.
• Good communication skills are essential.

Responsibilities

• Manage database refreshes and monitor database performance.
• Conduct periodic backups and ensure recovery solutions are valid.
• Oversee database security and disaster recovery processes.

Skills

MS SQL Database Administration

Database Performance Monitoring

Backup Management

Disaster Recovery

Communication Skills

Education

Bachelor's Degree in Computer Science

Degree in Information Systems

Job description

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 - MS SQL DBA.

Responsibilities:

1. Refresh of DBs in all environments to support development/change activities (QA/UAT/TRN/PROD).
2. Summarized Reports on Database growth and table space usage Periodic Object and Extent growth reports.
3. Monitor objects reaching max extents; check database is up and running.
4. Check Database services & its listener status.
5. Check for locks on database.
6. Monitoring the free space on table spaces which are reaching threshold value; Monitor file system usage and validating free space.
7. Basic cleaning up of unwanted files in dump upon approval of relevant personnel.
8. Monitor inactive database connections.
9. Killing inactive database sessions based on agreed time of inactive sessions.
10. Periodic backups of database and ensuring the validity of backups and recovery solutions.
11. Backup management and scheduled backup weekly, monthly, and daily.
12. Check database for runaway processes and remediation.
13. Monitoring of all scheduled jobs, report failed jobs, remediation of failed jobs.
14. Monitoring database processes and identify processes which are consuming CPU, virtual memory, disk I/O, other parameters that are higher than threshold values, providing monthly trend reports.
15. Database performance trending and capacity planning.
16. Database Patching and Upgrades.
17. Patching of SQL Server environments.
18. Supporting applications teams in maintenance/upgrade events in relation to DBA activities.
19. Other Database activities.
20. Creation of users, roles, privileges etc.
21. Support for applications DBA activities.
22. Planning & performing minor database upgrades, instance creation for trial upgrades.
23. Project based activities related to major DB upgrades and infrastructure shifts or movements.
24. Database Security reviews and action in relation to deficiencies whether system or user access related.
25. Disaster Recovery.
26. Monitoring, management, remediation, and improvement of disaster recovery components and processes relating to DB infrastructure.
27. Assisting other IT Support and Project teams with DBA related needs.
28. Identifying improvements in process and practices used inclusive of keeping documentation current.

Qualifications we seek in you!
Minimum Qualifications / Skills:
• Bachelor's Degree required. Preferably in Computer Science, Information Systems, or related field.

Preferred Qualifications/ Skills:
• Good Communication skills.

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.