Job Summary
">
* The SQL Server Database Administrator plays a crucial role in ensuring the performance, integrity, and security of databases.
* This position involves ensuring database systems are available, implementing backup and recovery strategies, and optimizing database performance.
Key Responsibilities:
">
1. Database Management
* Install, configure, and upgrade SQL Server instances and databases.
2. Performance Tuning
* Monitor and optimize database performance, including query optimization and indexing strategies.
3. Backup and Recovery
* Implement and manage backup and recovery procedures to ensure data integrity and availability.
4. Security Management
* Manage database security, including user access and permissions, to protect sensitive data.
5. Troubleshooting
* Diagnose and resolve database issues, including performance bottlenecks and connectivity problems.
6. Maintenance
* Perform regular maintenance tasks, such as database integrity checks and updates to database statistics.
7. Documentation
* Maintain up-to-date documentation of database configurations, procedures, and policies.
8. Automation
* Automate SQL server tasks to ensure consistent and repeatable executions.
9. Collaboration
* Work with application developers to design and optimize database schemas and queries.
10. Disaster Recovery
* Develop and implement disaster recovery plans for database systems.
11. Compliance
* Ensure compliance with data governance and regulatory requirements.