Database Administrator (DBA)

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)