Database Administrator (DBA) — Job Description

Summary

• Responsible for installation, configuration, maintenance, performance, security, backup/recovery, and availability of database systems to support applications and business operations.

Key responsibilities

• Installation & configuration: Install and configure database software (e.g., Oracle, SQL Server, MySQL, PostgreSQL, MongoDB), patches, and upgrades.
• Database design & implementation: Collaborate with architects and developers on schema design, normalization, indexing strategies, partitioning, and data modeling.
• Performance tuning: Monitor and tune database performance (queries, indexing, caching, resource allocation); analyze execution plans and optimize SQL.
• Capacity planning: Forecast growth, manage storage, configure tablespaces/volumes, and plan hardware/cluster scaling.
• Backup & recovery: Design and test backup, restore, and disaster recovery procedures; maintain RTO/RPO targets.
• High availability & replication: Implement and manage clustering, replication, mirroring, failover, and load-balancing solutions.
• Security & compliance: Manage user access, roles, authentication, encryption, auditing, and data masking; ensure compliance with standards/regulations.
• Maintenance & housekeeping: Schedule and perform maintenance tasks (statistics, reindexing, purging, patching), automate routine jobs, and manage maintenance windows.
• Monitoring & alerting: Set up monitoring, alerts, and dashboards for health, latency, errors, and resource usage; respond to incidents and troubleshoot outages.
• Data migration & ETL support: Plan and execute migrations, upgrades, data loads, and support ETL/ELT processes and data pipelines.
• Backup documentation & runbooks: Maintain documentation, runbooks, change logs, and standard operating procedures.
• Capacity & cost optimization: Optimize licensing, cloud resource usage, and storage to control costs.
• Collaboration & support: Work with developers, ops, security, and product teams to support deployments, schema changes, and performance issues; participate in on-call rotations.
• Automation & scripting: Create scripts and automation for provisioning, monitoring, maintenance, and deployments (e.g., Bash, PowerShell, Python, SQL).
• Testing & QA: Support staging/test environments, perform failover/recovery drills, and validate backups and restores.

Qualifications & skills

• Degree in Computer Science, Information Systems, or equivalent experience.
• Typically 3–7 years DBA experience (adjustable by seniority).
• Strong experience with one or more RDBMS and/or NoSQL systems (Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, MongoDB, Cassandra, etc.).
• Proficiency in SQL, performance tuning, indexing, and query optimization.
• Experience with backup/recovery tools (RMAN, pg_basebackup, mysqldump, Persona XtraBackup), HA solutions, and clustering.
• Familiarity with cloud databases and managed services (AWS RDS/Aurora, Azure SQL, Google Cloud SQL, DynamoDB).
• Experience with monitoring tools (Prometheus, Grafana, Datadog, CloudWatch), and APM integration.
• Scripting/automation skills (Python, Bash, PowerShell, Ansible, Terraform).
• Knowledge of security best practices, access controls, encryption, and compliance (SOC2, GDPR, HIPAA where applicable).
• Strong troubleshooting, problem-solving, and communication skills.
• Experience with CI/CD, database change management, and schema migration tools (Flyway, Liquibase) preferred.
• Certifications desirable: Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate, AWS Database Specialty, or relevant vendor certs.

Pay: $9,167.24 – $12,231.10 per month

Benefits:

• Dental insurance
• Health insurance
• Salary packaging

Work Location: On the road