Database Administrator

Position: Database Administrator

Experience:
5+ Years Role: Managed IT Services / Infrastructure Support Employment Type: Full-time

Location:
Remote Position Overview We are looking for an experienced Database Administrator (DBA) with 5+ years ofexperience in database administration, production database operations, performance management, security, backup, recovery, and disaster-recovery activities. The DBA will be responsible for ensuring the availability, performance, security, integrity, and recoverability of enterprise databases. The role will work closely with the System Administrator, Application, Infrastructure, Security, and Development teams to maintain stable and resilient database environments. A key responsibility will be collaborating with the System Administrator on backup, disaster recovery, business continuity, and infrastructure-related database operations.

Key Responsibilities
1. Database Administration and Operations Install, configure, upgrade, patch, and maintain database servers and database management systems. Perform day-to-day administration of production, staging, development, and test database environments. Monitor database availability, health, capacity, and performance. Manage database instances, databases, users, roles, permissions, and configurations. Ensure databases remain highly available and meet defined operational SLAs. Perform routine maintenance, housekeeping, and database health checks. Support database migrations, upgrades, and technology refresh initiatives.2. Database Performance and Optimization Monitor and analyze database performance, resource utilization, and capacity. Identify and resolve performance bottlenecks. Analyze execution plans and optimize SQL queries, indexes, stored procedures, and database configurations. Perform indexing and database maintenance activities. Monitor CPU, memory, storage, I/O, connections, and transaction performance. Establish performance baselines and proactively identify potential issues.3. Backup and Recovery Design, implement, and monitor database backup strategies. Ensure regular full, incremental/differential, and transaction-log backups, as applicable. Monitor backup jobs and investigate failures. Perform database restoration and recovery activities when required. Regularly validate backups through restore testing. Maintain appropriate backup retention and recovery procedures. Work closely with the System Administrator to ensure backup infrastructure and storage are aligned with database recovery requirements.4. Disaster Recovery and Business Continuity Support the development and maintenance of Database Disaster Recovery (DR) strategies. Participate in DR planning, implementation, testing, and periodic exercises. Support database replication, failover, and recovery mechanisms. Ensure databases meet defined RPO and RTO requirements. Participate in business continuity and disaster-recovery drills. Document recovery procedures and maintain up-to-date DR runbooks. Coordinate with System Administration, Infrastructure, Network, Security, and Application teams during DR events.5. High Availability Implement and maintain appropriate database high-availability solutions. Monitor replication, clustering, mirroring, Always On, log shipping, or equivalent technologies depending on the database platform. Perform planned failover and failback activities. Investigate database availability incidents and minimize service disruption. Ensure appropriate redundancy for critical database workloads.6. Security and Access Management Manage database security, authentication, authorization, roles, and privileges. Implement the principle of least privilege for database access. Review and manage privileged database accounts. Support database access provisioning and deprovisioning processes. Monitor database security events and suspicious activities. Support vulnerability remediation and database security hardening. Ensure database configurations align with organizational security policies.7. Monitoring and Incident Management Implement and maintain database monitoring and alerting. Proactively identify database failures, capacity issues, performance degradation, and other operational risks. Troubleshoot and resolve database incidents and service requests. Participate in incident, problem, and change-management processes. Perform root-cause analysis for recurring database issues. Maintain incident records and technical documentation.8. Capacity and Storage Management Monitor database growth, storage consumption, and resource utilization. Forecast future database capacity requirements. Coordinate with System Administrators and Infrastructure teams for storage expansion. Implement database archiving and housekeeping strategies. Identify opportunities to optimize storage utilization and database performance.9. Database Upgrade and Maintenance Plan and execute database version upgrades, patches, and security updates. Perform testing and validation before