Database Administrator

Key Responsibility & Requirements

Database Deployment and Configuration
Design and provision databases in Azure using:o Azure SQL Database o Azure Database for PostgreSQL / MySQLo Azure Managed Instance for SQL Servero Azure VM-based Oracle installations (IaaS)Install, configure, and upgrade on-prem and cloud-hosted SQL Server, Oracle, PostgreSQL databases.Performance Tuning and OptimizationAnalyze query performance using Query Store, Extended Events (SQL Server), AWR/ASH (Oracle), or pg_stat_statements (PostgreSQL).Index tuning, query rewriting, execution plan analysis.Resource governance and workload balancing.High Availability & Disaster Recovery (HA/DR)Implement HA/DR solutions in Azure:o Always On Availability Groups (SQL Server)o Oracle Data Guard (for Oracle on Azure VMs)o PostgreSQL HA (Patroni, Azure Flexible Server zones)Configure and manage backups using:o Azure Backupo Native tools (RMAN, pg_dump, mysqldump)o Point-in-time restore in Azure SQL and PostgreSQLSecurity and ComplianceImplement database-level and instance-level security:o TDE (Transparent Data Encryption)o Data maskingo Row-Level Security / Label SecurityManage Azure AD integration with databasesHandle audit logging and compliance checks for ISO, PCI, HIPAAMonitoring and MaintenanceSet up and maintain health checks and job automation (via Azure Automation, cron, SQL Server Agent).Monitor with:o Azure Monitoro Log Analyticso Custom dashboards (Grafana + Azure Logs, Kibana)Proactive capacity planning and anomaly detectionDatabase Migration and ReplicationPlan and execute migrations to Azure using:Minimal downtime cutovers and rollback strategiesAutomation and DevOps IntegrationDevelop automation scripts for:o Backup verificationo Index/statistics maintenanceo Resource scalingCollaboration and DocumentationWork closely with developers, cloud engineers, and application support teams.Maintain SOPs, runbooks, migration plans, security documentation.Participate in incident and change management (ITIL-aligned).Professional Certifications (If Any) Microsoft Certified: Azure Database Administrator AssociateOracle Database Administrator Certified Associate / ProfessionalPostgreSQL Certified Professional (optional but valuable)