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.
- Perform other duties as assigned.
|
Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/v s)? Interview will be by skype and will be conducted by a team of 3 5 developers and/or Project Managers. | Schedule Interview: How soon can you schedule an interview (date / times)? Within 2 weeks of closing |