Database Operations & Support

- Manage and support production database instances across MSSQL, Oracle, PostgreSQL, and MySQL, including day-to-day operations, incident and problem management (L2 escalations from L1), and RCA within defined SLAs.
- Perform database installation, configuration, patching, and version upgrades including compatibility checks, rollback strategy, and minimizing downtime during upgrades.
- Monitor database health, performance, and capacity, tablespace/datafile growth, transaction log usage, connection pools, and resource utilization.
- Manage backup and recovery strategy across all database engines (native backup tools, RMAN, pg_dump/pg_basebackup, mysqldump/XtraBackup), including scheduling, validation, and restore testing.
- Configure and manage high availability and replication, Always On/Failover Clustering (MSSQL), Data Guard/RAC (Oracle), Streaming Replication/Patroni (PostgreSQL), and Replication/Group Replication (MySQL).
- Perform routine maintenance activities, index rebuilds/reorgs, statistics updates, vacuuming (PostgreSQL), and job/scheduler management.

Troubleshooting

- Diagnose and resolve performance issues slow-running queries, blocking/locking, deadlocks, and execution plan regressions across all four database engines.
- Troubleshoot connectivity issues listener/service failures, connection pool exhaustion, authentication errors, and network-related timeouts.
- Debug replication and high-availability failures replication lag, broken Always On/Data Guard sync, failover issues, and split-brain scenarios.
- Investigate storage and capacity issues tempdb/undo/redo growth, tablespace/datafile exhaustion, disk latency, and log/WAL file bloat.
- Troubleshoot job/scheduler failures — SQL Agent jobs, Oracle scheduler,



cron-based PostgreSQL/MySQL maintenance jobs, and ETL-related database errors.
- Perform root cause analysis for recurring incidents and drive permanent fixes in coordination with L3/Architecture and Application teams.

Security & Access

- Implement and manage database security — user/role management, least-privilege access, and authentication mechanisms (SQL/Windows auth, Oracle wallets, PostgreSQL/MySQL roles).
- Support data encryption (TDE, column-level encryption), auditing, and integration with enterprise secret/credential stores (Vault, Key Vault, CyberArk).
- Manage database-level network security — firewall rules, listener security, and SSL/TLS configuration for database connections.
- Ensure compliance with patch SLAs, vulnerability remediation timelines, data retention policies, and audit/regulatory requirements.

Platform & Automation

- Contribute to platform design decisions — database architecture, capacity planning, HA/DR strategy, and standardization across engines.
- Automate routine DBA tasks using scripting (T-SQL, PL/SQL, PL/pgSQL, Bash/Python) and scheduling tools.
- Work with monitoring and observability tools (SQL Monitor, OEM, pgAdmin/pganalyze, Percona Monitoring, Grafana) for proactive health and performance monitoring.
- Support database provisioning and configuration management for cloud and on-prem environments,



including cloud-managed database services (Azure SQL/Managed Instance, RDS, Cloud SQL) where applicable.
- Document runbooks, SOPs, architecture diagrams, and knowledge base articles for recurring issues.
- Participate in on-call rotation and support during planned maintenance/outages.

Required Skills & Qualifications

- Bachelor's degree in computer science, IT, or related field (or equivalent experience).
- 4 to 8 years of hands-on experience in database administration across MSSQL, Oracle, PostgreSQL, and MySQL (proficiency across multiple engines expected).
- Strong command over database installation, configuration, backup/recovery, and patching across the supported engines.
- Deep troubleshooting experience across query performance, replication/HA, storage, and connectivity.
- Solid understanding of database security concepts, access control, encryption, and auditing.
- Working knowledge of scripting/query languages (T-SQL, PL/SQL, PL/pgSQL) for troubleshooting and automation.

Preferred / Good to Have

- Certifications such as Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Qualified (OCP), or equivalent PostgreSQL/MySQL certifications.
- Experience with database migration and upgrade projects across heterogeneous engines.
- Exposure on cloud-managed database platforms (Azure SQL, AWS RDS/Aurora, GCP Cloud SQL).
- Knowledge of database performance tuning tools and query optimization techniques.
- Experience with containerized/Kubernetes-hosted databases (e.g., PostgreSQL/MySQL operators).
- Familiarity with Infrastructure as Code (Terraform, Ansible) for database provisioning and configuration.

📌 Database Administrator (Tamil Nadu)
🏢 Neurealm
📍 Tamil Nadu