What are the responsibilities and job description for the SQL Server DBA position at Vista Applied Solutions Group Inc?
DAILY DUTIES / RESPONSIBILITIES:
- Primarily, this position will provide senior-level support and guidance to our Child Care team, including mentoring Child Care developers on schema and query design, execution-plan review/tuning, and security best practices.
- In addition to this, this position will assist (at a senior-level) with the support, maintenance, security, and availability of the agency’s SQL Server environment for other application teams, while prioritizing Child Care commitments.
- Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while ensuring availability, scalability, performance, recoverability, reliability, and security.
- Acts as liaison for SQL Server database performance, integration, migration, upgrade, storage, and replication strategies.
- Performs SQL Server performance tuning: waits/Query Store analysis, index & stats optimization, SARGability fixes, and parallelism tuning.
- Monitors the database systems to ensure secure services with minimum downtime; configures alerts and telemetry for proactive detection.
- Interacts with project management and Agile development teams to develop a strong understanding of project and database development objectives.
- Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
- Documents, tracks and escalates issues as appropriate.
- Participates in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.
- Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
- Performs routine operations and maintenance including installations, upgrades, patching, monitoring, auditing, and issue resolution.
- Manages and prioritizes multiple, diverse tasks simultaneously.
- Must be flexible, independent and self-motivated.
- Work collaboratively to meet team goals/mission.
- Provides after-hours or weekend maintenance as needed.
Required Skills
- 6 years of experience as a Database Administrator
- 6 years of experience with Backup/Recovery
- 6 years of experience with Performance Tuning
- 6 Years SQL Server
Preferred Skills
- Cloud Platform experience (SQL Database)
- PowerShell Scripting and Automation
- Database planning, scaling, and capacity planning
- RedGate
- Powershell
