Database Administrator (DBA) — Job Description

Position summary

Design, implement, maintain, and optimize database systems to ensure availability, integrity, security, and performance for applications and analytics.

Key responsibilities

• Database design &* implementation:* Model schemas, implement databases (OLTP/OLAP), create indexes, partitions, and optimize data structures.
• Installation &* configuration:* Install, configure, and upgrade database servers and related tools (RDBMS/NoSQL) per best practices.
• Performance tuning: Monitor and tune queries, indexes, memory, I/O, and storage to optimize performance and reduce latency.
• Backup &* recovery:* Develop and maintain backup, restore, and disaster recovery strategies; test restores regularly.
• High availability &* replication:* Configure and manage clustering, replication, failover, and HA solutions (e.g., Always On, Patroni, Galera).
• Security &* access control:* Implement authentication, authorization, encryption, auditing, and compliance controls.
• Capacity planning &* provisioning:* Forecast growth, manage storage, and plan resource provisioning and scaling.
• Maintenance &* automation:* Schedule maintenance tasks, automate routine operations, and manage patching.
• Incident response &* troubleshooting:* Diagnose and resolve production incidents, outages, and data corruption issues.
• Data migrations &* upgrades:* Plan and execute migrations, upgrades, and schema changes with minimal downtime.
• Monitoring &* observability:* Implement monitoring, alerting, and performance dashboards; analyze trends and KPIs.
• Documentation &* policies:* Create runbooks, SOPs, and documentation for operational procedures and standards.
• Collaboration &* support:* Work with developers, SRE/DevOps, security, and product teams to support application needs and schema design.
• Compliance &* audits:* Support data governance, privacy, and audit requirements; participate in audits.

Required qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
• 3+ years of DBA experience (varies by seniority) with at least one major RDBMS (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
• Strong SQL skills and experience with query optimization and indexing strategies.
• Experience with backup/recovery, HA/replication, and disaster recovery planning.
• Familiarity with Linux administration and scripting (Bash, Python, PowerShell).
• Knowledge of security best practices for databases.

Preferred qualifications

• Experience with cloud-managed databases and services (Amazon RDS/Aurora, Cloud SQL, Azure Database).
• Experience with NoSQL/datastore technologies (MongoDB, Cassandra, Redis) and data warehousing solutions (Snowflake, Redshift, BigQuery).
• Experience with containerized environments and orchestration (Docker, Kubernetes).
• Familiarity with Infrastructure as Code (Terraform, CloudFormation) and CI/CD integration.
• Certifications (e.g., Oracle, Microsoft, AWS Database Specialty) desirable.

Pay: $5,830.73 – $7,068.88 per month

Work Location: In person