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, PostgreSQL, 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 PowerShell, 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 (ServiceNow) 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, DevOps 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, PostgreSQL, 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 PowerShell, Python, or Bash for automation.
• Understanding of database security principles, role-based access control (RBAC), and encryption.

Good-to-Have

• Certifications:

1. Microsoft Certified: Azure Database Administrator Associate
2. Oracle Certified Associate (OCA) Database Administration
3. MySQL Database Administrator Certification
4. AWS Certified Database Specialty
5. Experience with cloud-based database solutions (Azure SQL, AWS RDS, Google Cloud SQL).
6. Familiarity with NoSQL databases (MongoDB, Redis, DynamoDB) and hybrid database architectures.
7. Exposure to DevOps practices, CI/CD pipelines, and database-as-a-service (DBaaS) platforms.

Education

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