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.
Note to recruiters and employment agencies: We will not pay for unsolicited resumes from recruiters and employment agencies unless we have a signed agreement and have required assistance, in writing, for a specific opening.
Skills Required
- Bachelor's or master's degree in computer science or related field
- 10+ years of relevant experience in high volume transactional and reporting databases
- Minimum 5 years of relevant experience
- Minimum 2-3 years experience in any cloud environment (Azure)
- Experience maintaining SQL Server (IaaS, Azure SQL Managed Instance, Azure SQL DB) and PostgreSQL
- Experience with SQL Server upgrades, migrations, installations, patching
- Experience in production support and project support (24x7 environment, on-call rotation)
- Design and manage backup/restore strategies including Full/Differential/Log and point-in-time recovery
- Configure and manage High Availability solutions (Always On Availability Groups, Failover Clustering)
- Advanced troubleshooting and performance tuning (query optimization, execution plans, deadlock resolution)
- Automate routine DBA tasks using scripting languages such as PowerShell or Python
- Experience using tools such as Commvault, Avamar, Spotlight, and ticketing systems
- Experience with DevOps CI/CD and configuration management tools like GitHub, Jenkins
- Knowledge of database security: access control, encryption, and auditing
- Change management skills and ability to operate in a fast-paced environment
- Excellent written and verbal communication skills
- Microsoft certification
What We Do
Coherent Laser India Pvt. Ltd. manages the Indian business interests of Coherent Inc. USA and Rofin. It provides a wide range of optimized laser solutions, including complete system solutions for marking, cutting, and medical device manufacturing, as well as various OEM laser sources from UV to infrared for diverse industrial applications.
