What are the responsibilities and job description for the SQL Server DBA position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, SYSTEM SOFT TECHNOLOGIES LLC, is seeking the following. Apply via Dice today!
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.
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.
- 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
- Cloud Platform experience (SQL Database)
- PowerShell Scripting and Automation
- Database planning, scaling, and capacity planning
- RedGate
- Powershell
