> Markdown version of [/jobs/ext/3472993-public-safety-sql-server-engineer-mission-critical-911-systems-brooklyn-hybrid](https://www.wearedevelopers.com/jobs/ext/3472993-public-safety-sql-server-engineer-mission-critical-911-systems-brooklyn-hybrid). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Public Safety SQL Server Engineer - Mission-Critical 911 Systems (Brooklyn, Hybrid) - **Company:** Oz Solutions Group Inc. - **Location:** New York, NY, United States (Remote available) - **Experience:** Expert - **Salary:** $156,000.0 - $187,200.0 - **Contract:** Temporary to permanent - **Skills:** Active Directory, Profiling, Databases, Data Integrity, Relational Databases, Database Queries, Software Design Documents, Disaster Recovery, Domain Name System (DNS), Failover, Failover Clustering, Log Shipping, Microsoft SQL Server, Windows Servers, MongoDB, MySQL, Oracle (Applications), Performance Tuning, Regression Testing, Service Pack, SQL Stored Procedures, SQL Databases, SQL Server Agent, System Availability, Data Analytics, Database Mirroring, Sql Tuning, Vmware - **Published:** September 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=0ae8778162a65b93 ## About the Role * 12+ years hands-on experience as a Microsoft SQL Engineer / DBA - administering SQL Server instances in production, not writing queries against them as a developer or analyst * Advanced SQL querying - complex queries, stored procedures, triggers, and SQL performance optimization through execution plan analysis, indexing strategy, and query rewriting * Proficiency across database administration: creation, configuration, monitoring, backup and recovery, security management, user access control, and optimization * Demonstrated experience implementing and maintaining high availability - Always On Availability Groups, database mirroring, failover clustering, and disaster recovery planning - including hands-on failover execution, not design documents alone * Proven ability to diagnose and troubleshoot database issues using SQL Server Profiler, Dynamic Management Views (DMVs), and Extended Events * Experience patching, upgrading, and migrating production SQL Server estates across versions with minimal downtime * Advanced working knowledge of relational databases and query authoring, with working familiarity across a variety of database platforms, * Knowledge of MySQL, Oracle, or MongoDB * Experience with VMware, Active Directory, and DNS * Prior experience in public safety, emergency communications, healthcare, or another environment where database downtime carries real-world consequences, * Microsoft SQL Server DBA: 10 years (Preferred) ## Description * Review all Microsoft SQL Server databases and identify performance bottlenecks, fragmentation, and inconsistencies - using wait statistics, blocking chains, and query plan analysis to separate symptom from cause * Perform routine maintenance - index rebuilds and reorganizations against fragmentation thresholds, statistics updates (including full-scan where sampling misleads the optimizer), and DBCC CHECKDB integrity checks on a defined cadence * Handle database creation, configuration, and file/filegroup layout; manage tempdb configuration, autogrowth settings, and transaction log sizing * Own monitoring and alerting - SQL Server Agent jobs, operators, alerts, and maintenance windows - so failures surface before users report them * Administer security: logins and database users, role-based least-privilege access, AD group mappings, orphaned user cleanup, encryption at rest, and audit trails High availability and failover * Monitor and maintain Always On Availability Groups across SQL clusters, including synchronous and asynchronous commit replicas, readable secondaries, and listener configuration * Verify synchronization state across replicas - tracking send/redo queue depth, replica lag, and seeding status, and resolving replicas that fall out of sync * Perform scheduled failover testing and execute planned and unplanned failovers during live incidents, including the Windows Server Failover Cluster layer: quorum configuration, node health, and cluster validation * Maintain complementary HA and recovery mechanisms where in use - database mirroring, failover cluster instances, log shipping, and replication Patching and migration * Schedule and perform SQL Server cumulative updates, service packs, and security patching, coordinating with stakeholders to minimize downtime * Execute rolling patch sequences across AG replicas - secondaries first, controlled failover, then former primary - to keep databases available through maintenance * Assess existing applications and databases and work with application owners to plan and execute migrations to SQL Server 2019 * Drive migration mechanics end to end: compatibility assessments, database compatibility levels, collation and configuration parity, and cutover/rollback planning * Ensure compatibility and performance optimization throughout the migration, including regression testing against the newer cardinality estimator and using Query Store to detect and remediate plan regressions after upgrade Consolidation and architecture * Identify opportunities to consolidate SQL servers into shared instances * Evaluate resource utilization and performance impact before and after consolidation - CPU, memory pressure, storage latency, and instance-level resource governance - with capacity baselines to prove the result * Review SQL Server and database requests as part of the build cycle and provide best practice recommendations on schema and index design, performance tuning, and security Backup, recovery, and analysis * Review and optimize SQL backup schedules and technologies across full, differential, and transaction log backups, aligned to recovery models and defined RPO/RTO targets * Implement backup strategies supporting data integrity and disaster recovery readiness, including verification, retention, and offsite/secondary-site copies * Monitor backup jobs, troubleshoot failures, and run periodic recovery tests - including point-in-time restores and full DR exercises that prove the runbook actually works * Perform root cause analysis on internal and external data and processes using SQL Server Profiler, Dynamic Management Views, Extended Events sessions, deadlock graphs, and Query Store history; identify patterns, trends, and anomalies and propose data-driven solutions Project support * Provide project management support for SQL-related initiatives - coordinating tasks, timelines, and resources * Communicate effectively with stakeholders to provide updates and manage expectations * Work within formal change control for production changes on life-safety systems ## Related Videos - [40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs](https://www.wearedevelopers.com/videos/208-40-minutes-to-build-a-serverless-covid-19-rest-and-graphql-apis) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [WebAssembly: The Next Frontier of Cloud Computing](https://www.wearedevelopers.com/videos/972-webassembly-the-next-frontier-of-cloud-computing) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [NoSQL Data Modeling for Front-end Developers](https://www.wearedevelopers.com/videos/297-nosql-data-modeling-for-front-end-developers) - [Generating code with Angular schematics](https://www.wearedevelopers.com/videos/129-generating-code-with-angular-schematics) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers)