Description
We are seeking a highly skilled Senior SQL Server Database Administrator to manage and optimize our SQL Server databases. The ideal candidate will have extensive experience in database administration, performance tuning, and security management, contributing to the overall success of our data management strategy.
Responsibilities
- Designing, implementing, and maintaining SQL Server databases for optimal performance and reliability.
- Monitoring database performance and implementing tuning strategies to enhance efficiency.
- Ensuring data security and integrity through proper database management practices.
- Creating and managing backup and recovery strategies to safeguard data.
- Troubleshooting database-related issues and providing effective solutions in a timely manner.
- Collaborating with development teams to design and optimize database schemas and queries.
- Performing routine database maintenance, including updates, migrations, and patching.
- Documenting database configurations, processes, and procedures for future reference.
Skills and Qualifications
- 8-16 years of experience as a SQL Server Database Administrator.
- Strong proficiency in T-SQL, including writing complex queries, stored procedures, and triggers.
- In-depth knowledge of SQL Server architecture and database design principles.
- Experience with SQL Server Performance Tuning and Optimization techniques.
- Familiarity with backup, restore, and recovery methodologies for SQL Server databases.
- Proficient in managing SQL Server security features and user permissions.
- Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Ability to work with cloud-based database solutions, especially Azure SQL Database.
- Strong analytical and problem-solving skills with attention to detail.