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 IT team. The successful candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a 'hands-on' position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.
Responsibilities
Text copied to clipboard!- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities
Requirements
Text copied to clipboard!- 3+ years MS SQL Server Administration experience required
- Experience with Performance Tuning and Optimization (PTO)
- Experience with backups, restores and recovery models
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Experience working with Windows server, including Active Directory
- Excellent written and verbal communication
- Flexible, team player, 'get-it-done' personality
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- MCTS, MCITP, and/or MVP certifications a plus
Potential interview questions
Text copied to clipboard!- What is your experience with SQL Server Administration?
- Can you describe a time when you improved database performance?
- How do you handle disaster recovery?
- What is your experience with High Availability (HA)?
- How do you handle data security?