SQL Server Database Administrator I
D.R. Horton
About the Role
D.R. Horton, Inc. is seeking a SQL Server Database Administrator I to maintain the company's Microsoft SQL Server database environment to ensure smooth operation 24/7, facilitating a seamless flow of information by managing backend data structure and frontend accessibility.
Key Responsibilities
- Perform daily monitoring and analysis of Microsoft SQL Server databases and instances for operational continuity.
- Conduct Microsoft SQL Server performance analysis and tuning, focusing on sizing, throughput, scalability, and dependability.
- Ensure database security.
- Perform regular backups of Microsoft SQL Server databases and servers.
- Execute restorations of backups in instances of system failure or data loss.
- Review changes to production databases to prevent negative impacts on performance or reliability.
- Collaborate with software developers on implementing new SQL Server database schemas, stored procedures, user-defined functions, SQL Server Integration Services (SSIS) packages, SQL Server Agent jobs, and other database solutions.
- Promote database changes through the software development lifecycle.
- Adhere to development standards for naming conventions and user interfaces.
- Migrate data between Microsoft SQL Server databases.
- Conduct business professionally and ethically.
- Participate in on-call rotation.
- Work overtime as needed.
- Travel overnight as required.
Requirements & Tech Stack
- Microsoft SQL Server
- SQL Server Management Studio (SSMS)
- T-SQL querying
- Database maintenance
- Backup and recovery concepts
- SQL Server Integration Services (SSIS)
- SQL Server Agent jobs
Qualifications
- High school diploma or GED.
- Zero to two years of experience supporting production Microsoft SQL Server environments as a Database Administrator, Junior Database Administrator, or Database Administrator Intern.
- Strong verbal communication skills.
- Strong written documentation skills.
- Proficiency with MS Office and email.
- Associate degree or equivalent from a two-year college or technical school (preferred).
- Ability to multi-task.
- Attention to detail.
- Basic understanding of SQL Server high availability and disaster recovery concepts.