As a Database Administrator, you will provide 24x7 support for complex SQL Server environments, ensuring high availability (HA), disaster recovery (DR), and optimal performance. You will follow DTMB and industry standards, manage installations, patches, upgrades, and serve as a liaison between Agency Services and external consultants.
Responsibilities:
Database Maintenance & Optimization:
- Monitor and manage space allocation, fragmentation, and disk space requirements across databases.
- Modify DBMS parameters based on capacity needs and performance tuning.
- Configure and execute database integrity checks and troubleshoot issues.
- Install and maintain SQL Server software, patches, and service packs in dev/test environments.
High Availability & Disaster Recovery:
- Support clustered environments, replication, and backup solutions.
- Ensure database recoverability by monitoring backups and resolving failures.
- Implement Transparent Data Encryption (TDE) for security compliance.
