SQL Server DBA

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

• Bachelors or masters 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.

CultureCommitment

Ensure adherence to companys 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.