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 of
experience 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 production implementation.
Coordinate maintenance windows with…