Role Summary:
The DBA is responsible for the administration, performance tuning, and security of enterprise databases across on-premises and cloud environments. This role ensures data integrity, availability, and disaster recovery readiness while supporting development and infrastructure teams.
Key Responsibilities:
- Install, configure, and maintain relational databases (Oracle, SQL Server, PostgreSQL).
- Perform backup, recovery, and disaster recovery planning. Create and manage backups of databases and develop recovery plans to minimize data loss in case of system failures.
- Monitor database performance and tune queries and indexes, monitor database performance, identify bottlenecks, and optimize queries to ensure efficient data retrieval.
- implement security measures to protect sensitive data, including user access control, encryption, and auditing.
- Automate routine DBA tasks using scripting (Python, Bash, PowerShell).
- Support cloud-based database services (RDS, Azure SQL, Oracle Cloud DB).
- Collaborate with infrastructure teams on storage (ZFS, DELL, HP), OS (Linux, Windows), and virtualization (VMware, Nutanix).
- Scripting for Automation: Proficiency in Bash, Python, or PowerShell for automating DBA tasks.
- Security Best Practices: Knowledge of database encryption, role-based access control (RBAC), and auditing.
- Monitor database performance, identify bottlenecks, and optimize queries, indexes, and execution plans.
- Perform backups, restores, and disaster recovery operations to ensure data integrity and business continuity.
- Implement and manage High Availability (HA) and Disaster Recovery (DR) solutions (Always On Availability Groups, Failover Clustering, Log Shipping).
- Apply security patches, updates, and hardening measures to comply with industry standards.
- Diagnose and resolve database-related issues, including performance problems, errors, and security breaches.
- Provide support to database users, including granting access, troubleshooting issues, and providing training.
- Implement monitoring using OEM, Zabbix, and New Relic.
- Ensure compliance with ITIL processes and security standards.
Required Skills:
- Good experience in database administration.
- Strong technical skills in database management systems (DBMS) like Oracle, SQL Server, MySQL, or PostgreSQL.
- Strong SQL Knowledge: Expertise in writing, optimizing, and debugging complex SQL queries.
- DBMS Administration: Hands-on experience with at least one major RDBMS (Microsoft SQL Server or Oracle).
- Performance Monitoring & Tuning: Familiarity with tools like EXPLAIN ANALYZE, Query Store, AWR Reports, or Performance Schema.
- Backup & Recovery: Experience with backup tools (MySQL dump, pg_dump, RMAN, SQL Server Backup) and point-in-time recovery strategies.
- Basic Linux/Windows Administration: Ability to manage database services in Linux (systemd, cron) or Windows Server environments.
- Expertise in backup & recovery (RMAN), performance tuning (AWR, SQL Tuning Advisor), and HA solutions (RAC, Data Guard).
- Proficient in PL/SQL scripting and database troubleshooting.
- Knowledge of Oracle Enterprise Manager (OEM) and Grid Control.
- Hands-on experience with Oracle Cloud Infrastructure (OCI) Database services (Autonomous DB, Exadata Cloud).
- Familiarity with AWS RDS for Oracle, Azure Database for Oracle, or multi-cloud DB setups.
- Understanding of OCI networking (VCN, FastConnect) and security (IAM, WAF, Network Security Groups).
- Scripting skills in Shell (Bash), Python, or PowerShell for automation.
- Deploy, configure, and manage Azure SQL Database, Managed Instance, and Elastic Pools.
- Optimize cloud database performance using Azure Monitor, Query Store, and Automatic Tuning.
- Implement cost optimization strategies (reserved capacity, auto-pause, scaling).
- Integrate on-prem SQL Server with Azure Hybrid Cloud (Azure Arc, Data Sync, Linked Servers).
- Automate database deployments using Azure DevOps Pipelines, ARM Templates, or Terraform.
- Configure Row-Level Security (RLS), Dynamic Data Masking (DDM), and Always Encrypted.
- Manage authentication (Azure AD, SQL Logins) and authorization (RBAC, SQL permissions).
- Ensure compliance with GDPR, HIPAA, or industry-specific regulations (auditing, vulnerability assessments)." Experience with cloud and hybrid database environments.
- Familiarity with automation and IaC tools is a plus
- Understanding security principles and best practices is crucial for protecting sensitive data.
Education: Bachelor’s Degree
Certifications (Preferred)
- Oracle Database Administration I (1Z0-082)
- Oracle Database SQL Certified Associate
- OCI Foundations
- Oracle Linux: System Administration
- Microsoft Certified: Azure Data Fundamentals (DP-900)
- Microsoft Certified: Azure Database Administrator Associate
- IBM Certified Database Associate – DB2
- MongoDB Certified Developer Associate
Soft Skills: Strong analytical and problem-solving skills to diagnose and resolve database issues.
Communicate effectively with users, other IT professionals, and management.
Language Proficiency: English – B2 (Upper-Intermediate) to C1 (Advanced)