SQL DBA

Coherent Corp.; Hyderabad; Hybrid; INR 3,500,000 - 5,500,000; Full time

Job summary

Coherent Corp. in Hyderabad seeks an experienced DBA to manage SQL Server and PostgreSQL environments across on-prem and cloud. You will install, upgrade, patch, and migrate databases, optimize queries, implement indexing, and handle DR and HA strategies.

The role includes monitoring, automation, and 24x7 production support in a hybrid office setting. Candidates should have 5+ years of relevant experience, strong scripting skills, and familiarity with cloud services and DevOps tools.

Qualifications

• Bachelor’s or master’s degree in computer science or related field.
• Minimum 5 years of relevant experience in database administration and production support.
• Experience with SQL Server/Azure SQL and PostgreSQL environments.

Responsibilities

• Perform database installations, upgrades, patching, and migrations.
• Manage database provisioning and environment setup.
• Analyze and optimize slow-running queries and execution plans.
• Design, implement, and maintain indexing strategies.
• Resolve performance bottlenecks, blocking, and deadlocks.
• Backup, restore, and disaster recovery planning and testing.
• Monitor, automate DBA tasks with scripting, and ensure security/compliance.

Skills

Database administration

Performance tuning

Cloud experience

DevOps CI/CD

Scripting (PowerShell/Python)

Change management

Communication skills

High availability & DR

Education

Bachelor’s or master’s degree in computer science

Tools

Commvault

Avamar

Spotlight

Ticketing tools

GitHub

Jenkins

Job description

Job Description

• Perform database installations, upgrades, patching, and migrations.
• Manage database provisioning and overall environment setup.
• Analyze and optimize slow-running queries and execution plans.
• Design, implement, and maintain effective indexing strategies.
• Resolve complex performance bottlenecks, blocking issues, and deadlocks.

Primary Duties & Responsibilities

Administration

• Maintain SQL Server (IaaS SQL Instance, Azure SQL Managed Instance, Azure SQL DB) and PostgreSQL databases.
• Perform database installations, upgrades, patching, and migrations.
• Manage database provisioning and overall environment setup.
• Analyze and optimize slow-running queries and execution plans.
• Design, implement, and maintain effective indexing strategies.
• Resolve complex performance bottlenecks, blocking issues, and deadlocks.

Backup, Restore & Disaster Recovery

• Design and manage comprehensive backup strategies (Full, Differential, Log).
• Perform database restores and precise point-in-time recovery (PITR).
• Implement and routinely validate Disaster Recovery (DR) strategies
• High Availability (HA)
• Configure and manage Always On Availability Groups and Failover Clustering.

Monitoring & Automation

• Alerting: Implement proactive monitoring and alerting solutions.
• Scripting: Automate routine DBA tasks using scripting languages like PowerShell or Python.

Security & Compliance

• Access Control: Manage database security protocols, including logins, roles, and granular permissions.
• Data Protection: Implement robust encryption and comprehensive auditing policies.

Education & Experience

• Bachelor’s or master’s degree in computer science, or related fields.
• Minimum 5 years of relevant experience

Skills

• 10+ years of relevant experience in high volume transactional and reporting databases.
• Minimum experience of 2-3 years in any cloud environment.
• SQL Server database upgrade and migration experience is highly desired
• Experience in Production support, Project Support is must.
• Experience in using tools such as (Commvault, Avamar, Spotlight, Any ticketing tools)
• Experience in any DevOps CI/CD and configuration management tools like GitHub, Jenkins etc. is preferred
• Microsoft certification a plus
• Change management skills and ability to operate effectively in fast paced environment.
• Excellent written & verbal communication skills
• The role involves advanced troubleshooting, performance tuning, cloud database management, and ensuring high availability and disaster recovery for production environments.

Working Conditions

• Team Player and comfortable working in 24X7 Production support environment with On-Call rotation.
• We are in hybrid work model. i.e. 3 days at office.

Culture Commitment

Ensure adherence to company’s values (ICARE) in all aspects of your position at Coherent Corp.:

• Integrity – Create an Environment of Trust
• Collaboration – Innovate Through the Sharing of Ideas
• Accountability – Own the Process and the Outcome
• Respect – Recognize the Value in Everyone
• Enthusiasm – Find a Sense of Purpose in Work

Coherent Corp. is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.

Finisar India (Subsidiary of Coherent Corp) is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to gender identity, sexual orientation, race, color, religion, national origin, disability, or any other characteristic protected by law.

About Us

Coherent is a global leader in lasers, engineered materials and networking components. We are a vertically integrated manufacturing company that develops innovative products for diversified applications in the industrial, optical communications, military, life sciences, semiconductor equipment, and consumer markets. Coherent provides a comprehensive career development platform within an environment that challenges employees to perform at their best, while rewarding excellence and hard-work through a competitive compensation program. It's an exciting opportunity to work for a company that offers stability, longevity and growth. Come Join Us!