Supporting DHS/TSA SQL Server Database Administrator - Administer and maintain SQL Server database environments, including installation, configuration, and patch management.
- Administer and maintain database operational status and performance monitoring.
- Administer and maintain database replication monitoring and fault correction.
- Monitor database performance, identify bottlenecks, and implement optimization strategies to ensure optimal throughput and responsiveness.
- Perform database design, data modeling, and schema management to support application requirements and performance goals.
- Implement and maintain database security measures, including user access controls, data encryption, and auditing mechanisms.
- Conduct database capacity planning and forecasting to accommodate future growth and changing business requirements.
- Develop and maintain database backup and recovery strategies to ensure data availability and integrity.
- Collaborate with development teams to optimize SQL queries, database code, and stored procedures for improved performance.
- Create and maintain documentation related to database configurations, procedures, and troubleshooting guides.
