SQL Server Database Systems Engineer
As a SQL Server Database Systems Engineer, you will support and engineer database systems, focusing on analysis, planning, design, development, implementation, and upgrades. Utilizing established architectural and engineering best practices, you'll manage complex systems to achieve strategic objectives related to client needs, infrastructure availability, automation, and database environment security.
Responsibilities include designing solutions, implementing new features, resolving complex incidents, enhancing monitoring and alerts, and consulting with application support and development teams.
You will take charge of build decisions and infrastructure design for complex systems using Agile delivery. As a strategic thinker, you’ll collaborate effectively, helping others grow while learning new technologies and automation practices.
Key Responsibilities:
- Database Administration: Install, configure, and maintain SQL Server databases, ensuring optimal performance, security, and availability, including MSBI components (SSAS, SSIS, SSRS).
- High Availability and Disaster Recovery (HADR): Implement and manage SQL Server Always On Availability Groups (AOAG) and other HADR solutions.
- Automation and Scripting: Develop and maintain automation scripts using PowerShell, Ansible, and other tools to streamline tasks.
- Database Migrations: Plan and execute database upgrades and migrations with minimal downtime.
- Performance Tuning: Optimize database performance through indexing, query optimization, and resource management.
- Backup and Recovery: Establish and implement backup and recovery procedures.
- Security Management: Ensure database security by adhering to best practices and compliance requirements.
- Monitoring and Maintenance: Proactively monitor production databases for performance, storage, and memory utilization; manage automated alerts.
- Collaboration: Work across teams to support application development, deployment, and maintenance.
- Mentorship: Share knowledge and mentor junior team members.
- Incident Response: Troubleshoot and resolve complex database issues.
Qualifications:
- Experience: 10+ years administrating SQL Server databases and MSBI components.
- Technical Skills:
- SQL Server AOAG expertise.
- Advanced scripting (PowerShell, Ansible, etc.).
- Experience with database migrations and upgrades.
- MSBI components proficiency (SSAS, SSIS, SSRS).
- Strong Windows Server administration skills.
Desired Knowledge and Experience:
- Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
- Experience with Hashicorp Vault or CyberArk for SQL Server access.
- Familiarity with Atlassian Jira for Agile feature creation.
- Cloud experience (AWS, Azure) including RDS, Azure SQL Database.
- Experience with database virtualization (Delphix).
- Experience with ELK Stack, Dynatrace, SolarWinds DPA, PowerBI Gateway management.
Additional Skills:
- Strong problem-solving and communication abilities.
- Ability to work both independently and collaboratively.
- Ability to mentor team members and foster continuous learning.
- Ownership and self-direction in ambiguous situations.
Contract-to-Hire Possibility
- Location: Franklin (hybrid schedule M, T, W); not open to remote.
- Length of Contract: Through July 1, 2025 (with potential for permanent placement).
Technical Skills:
- SQL expertise, including upgrades and migrations.
- SQL Server AOAG experience.
- PowerShell, Ansible, and/or Python experience.
Soft Skills: Eagerness to learn, good attitude, and strong interpersonal skills.