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
