-
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.