Database Administrator (DBA)

Description

Summary: A Database Administrator (DBA) manages and maintains reliable, secure, performant, and available database systems, handling administration, tuning, backup/recovery, and lifecycle support. Highlights: 1. Manage and maintain reliable, secure, and performant database systems 2. Perform performance tuning and ensure high availability 3. Troubleshoot incidents and ensure data integrity **Database Administrator (DBA) — Job Description** **Overview** A Database Administrator (DBA) manages and maintains database systems to ensure they’re reliable, secure, performant, and available. They handle administration tasks, performance tuning, backup/recovery, user access, and database lifecycle support. **Key Responsibilities** * Install, configure, and administer database servers and environments (dev/test/prod). * Manage users, roles, permissions, and security settings. * Write and maintain SQL jobs, stored procedures, views, and maintenance scripts (as needed). * Monitor database health: storage, CPU/memory, locks, long\-running queries, replication/HA status. * Perform performance tuning: indexes, query optimization, execution plans, capacity sizing. * Ensure availability and resilience: clustering/replication, failover testing (if applicable). * Manage backup, restore, and disaster recovery processes; test recovery periodically. * Apply patches, upgrades, and maintenance releases with change control and downtime planning. * Manage data integrity and constraints; support schema changes and migrations (in coordination with developers). * Troubleshoot incidents and provide root cause analysis and remediation steps. * Enforce standards for auditing, logging, and compliance requirements (if applicable). * Document procedures, runbooks, and database architecture; support audits and reviews. **Required Qualifications** * Hands\-on experience administering at least one major database platform (e.g., Oracle, SQL Server, PostgreSQL, MySQL, MongoDB—depends on employer). * Strong SQL skills and fundamentals (indexes, transactions, isolation levels, query plans). * Experience with backup/restore and recovery concepts; comfort with restore testing. * Competence in performance monitoring and troubleshooting. * Knowledge of Linux/Windows administration basics and networking fundamentals (as relevant). * Strong problem\-solving skills and clear technical communication. **Preferred Qualifications** * Experience with high availability and disaster recovery (e.g., replication, clustering, log shipping). * Scripting/automation skills (Python, PowerShell, Bash, SQL). * Familiarity with cloud\-managed databases or cloud platforms (AWS/Azure/GCP). * Experience with data migration tools and practices. * Database certifications (e.g., Oracle, Microsoft, PostgreSQL) and/or DevOps collaboration experience. * Familiarity with compliance standards and audit logging requirements (SOC 2, ISO, HIPAA—if relevant). Pay: RO1,394\.590 \- RO1,849\.220 per month Work Location: In person