Text copied to clipboard!
Title
Text copied to clipboard!SQL Server Database Administrator
Description
Text copied to clipboard!
We are looking for a skilled SQL Server Database Administrator to join our dynamic IT team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server database systems, ensuring the availability and consistent performance of our corporate applications. This role requires a highly motivated individual who can work independently and collaboratively with other IT professionals to ensure database integrity, security, and performance.
The SQL Server Database Administrator will be responsible for the development and sustainment of SQL Server databases, ensuring operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. You must be capable of working independently and collaboratively.
You will be responsible for managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. You will configure and maintain database servers and processes, including monitoring system health and performance, to ensure high levels of performance, availability, and security. You will apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
The successful candidate will independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end. You will refine and automate regular processes, track issues, and document changes. You will assist developers with complex query tuning and schema refinement, providing 24x7 support for critical production systems. You will perform scheduled maintenance and support release deployment activities after hours.
You must have a strong understanding of database structures, theories, principles, and practices. You should have experience with database performance tuning and optimization, using native monitoring and troubleshooting tools. You must have experience with backups, restores, and recovery models, as well as knowledge of high availability (HA) and disaster recovery (DR) options for SQL Server.
The ideal candidate will have excellent written and verbal communication skills, strong analytical and problem-solving skills, and the ability to work effectively in a team environment. You should be detail-oriented, organized, and able to manage multiple tasks simultaneously. You must be proactive in identifying potential issues and implementing solutions to prevent downtime and data loss.
We offer a collaborative and supportive work environment, opportunities for professional growth, and competitive compensation packages. If you are passionate about database administration and want to contribute to the success of our organization, we encourage you to apply.
Responsibilities
Text copied to clipboard!- Install, configure, and maintain SQL Server databases and related software.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- Ensure database security, integrity, stability, and system availability.
- Perform database backups, restores, and disaster recovery planning.
- Assist developers with query tuning, schema refinement, and indexing strategies.
- Develop and maintain documentation related to database administration processes.
- Automate routine database tasks and proactively identify potential issues.
Requirements
Text copied to clipboard!- Bachelor's degree in Computer Science, Information Technology, or related field.
- Proven experience as a SQL Server Database Administrator or similar role.
- Strong knowledge of SQL Server database management, performance tuning, and optimization.
- Experience with database backup, restore, and recovery procedures.
- Familiarity with high availability (HA) and disaster recovery (DR) solutions.
- Excellent problem-solving, analytical, and communication skills.
- Ability to work independently and collaboratively in a team environment.
Potential interview questions
Text copied to clipboard!- Can you describe your experience with SQL Server performance tuning and optimization?
- What strategies do you use to ensure database security and integrity?
- How do you approach database backup and disaster recovery planning?
- Can you provide an example of a challenging database issue you resolved?
- What tools and techniques do you use for monitoring SQL Server databases?
