Database Operations Engineer - SQL

Job Title:

Database Operations Engineer – SQL

Experience:

2 - 4 Years

Work Location:

Trivandrum

Job Responsibilities:

We are seeking a  Senior Database Operations Engineer – SQL  with  2+ years of experience  in  database administration, performance tuning, and SQL query optimization . The ideal candidate will be responsible for  managing, monitoring, and optimizing SQL databases  to ensure  high availability, security, and performance .

Key Responsibilities:

As a  Database Operations Engineer , you will work with  development teams, system administrators, and security teams  to support  database operations, troubleshoot performance issues, and automate database tasks .

1. Database Administration & Operations

Manage and maintain  SQL Server, MySQL, Postgre

SQL, or Oracle databases  in  on-premises and cloud environments .
Perform  database installations, upgrades, patching, and backups  to ensure data integrity and security.
Configure and manage  high availability (HA) solutions , including  replication, failover clustering, and Always On availability groups .
Troubleshoot and resolve  database connectivity, performance, and locking/blocking issues .

2. SQL Performance Tuning & Optimization

Analyze and optimize  SQL queries, stored procedures, and indexing strategies  to improve performance.
Monitor  query execution plans, disk I/O, and memory usage  to ensure efficient database performance.
Implement  database tuning techniques , including partitioning, caching, and indexing best practices.
Work with development teams to review and optimize  SQL code and database designs .

3. Database Security & Compliance

Implement and enforce  database security policies , including  user roles, access control, and encryption .
Ensure compliance with  data protection regulations (GDPR, HIPAA, PCI-DSS, ISO 27001) .
Regularly review and audit  database access logs, authentication mechanisms, and privilege escalation risks .
Implement  disaster recovery (DR) plans , ensuring reliable database backups and recovery strategies.

4. Automation & Scripting

Develop and maintain  Power Shell, Python, or Bash scripts  to automate  database backups, monitoring, and maintenance .
Automate routine database tasks using  SQL Server Agent, cron jobs, or cloud automation tools .
Integrate databases with  ITSM platforms (Service Now) and monitoring tools (New Relic, Prometheus, or Datadog) .

5. Troubleshooting & Incident Management

Investigate and resolve  database-related incidents, slow query performance, and connection failures .
Work with  SOC teams to analyze database logs and security alerts .
Document  issue resolutions, troubleshooting steps, and database operational procedures .

6. Collaboration & Continuous Improvement

Work closely with  application developers, Dev Ops teams, and infrastructure teams  to support database needs.
Participate in  database migration projects, cloud deployments, and modernization initiatives .
Stay updated on  SQL advancements, database automation tools, and emerging database technologies .

Required Qualifications & Skills

Must-Have

2+ years of experience  in  SQL database administration, operations, and performance tuning .
Hands-on experience with  SQL Server, MySQL, Postgre

SQL, or Oracle .
Strong knowledge of  SQL query optimization, indexing strategies, and execution plans .
Experience in  database backup, recovery, replication, and high availability (HA) configurations .
Basic scripting skills in  Power Shell, Python, or Bash  for automation.
Understanding of  database security principles, role-based access control (RBAC), and encryption .

Good-to-Have

Certifications :

Microsoft Certified:
Azure Database Administrator Associate
Oracle Certified Associate (OCA) – Database Administration
MySQL Database Administrator Certification
AWS Certified Database – Specialty

Experience with  cloud-based database solutions (Azure SQL, AWS RDS, Google Cloud SQL) .
Familiarity with  No

SQL databases (Mongo

DB, Redis, Dynamo

DB) and hybrid database architectures .
Exposure to  Dev Ops practices, CI/CD pipelines, and database-as-a-service (DBaaS) platforms .

Education

Bachelor’s degree  in  Computer Science, Information Technology, or a related field  (or equivalent work experience).