Senior SQL Server DBA
neshent technologiesAstoria, NY
Senior SQL Server DBA
L5
neshent technologiesAstoria, NYtoday
Industries
Computer Systems Design ServicesOther Computer Related ServicesCustom Computer Programming ServicesWe are looking for an experienced Senior SQL Server DBA with strong hands-on experience in SQL Server administration, engineering, and production support. The candidate will be responsible for managing business-critical SQL Server environments, performance tuning, database maintenance, troubleshooting, automation, and High Availability/Disaster Recovery (HA/DR) solutions.
Key Responsibilities & Required Skills
Install, configure, administer, patch, upgrade, and maintain SQL Server environments across production and non-production systems.
Strong hands-on experience with T-SQL, stored procedures, views, triggers, indexing, query optimization, and execution plan analysis.
Perform database monitoring, health checks, integrity checks, backup/recovery, index maintenance, and SQL Server Agent job management.
Troubleshoot production incidents, blocking, deadlocks, performance issues, failed jobs, and database connectivity problems.
Develop, support, and troubleshoot SSIS packages and ETL processes.
Design, implement, and support SQL Server HA/DR solutions, including Always On Availability Groups (AOAG), Windows Server Failover Clustering (WSFC), and Log Shipping.
Experience with multi-node/multi-datacenter configurations, synchronous/asynchronous commit modes, quorum, File Share Witness, and Cloud Witness.
Conduct DR drills, failover/failback testing, and maintain recovery runbooks based on RPO/RTO requirements.
Strong experience supporting SQL Server on Windows Server, including service accounts, Active Directory authentication, ports, and firewall configurations.
Work with infrastructure and network teams to troubleshoot connectivity issues.
Develop automation scripts using PowerShell, T-SQL, and Windows Batch.
Support database deployments, application releases, post-release validation, and production stabilization.
Maintain technical documentation and collaborate with application, development, QA, and infrastructure teams.
Highly Preferred Skills
Direct hands-on experience with INGRES-to-SQL Server migration.
Knowledge of INGRES SQL, database objects, schemas, and data types.
Experience with schema/object migration, dependency analysis, data migration, reconciliation, and post-migration validation.
Experience supporting migration testing, cutover, and post-production stabilization.
Utilities / Transmission & Distribution (T&D) domain experience.
Strong data modeling and database design knowledge, including logical/physical models, relationships, keys, constraints, and normalization.
Experience with database source control/version control tools.
Apply now (opens in a new tab)
Level
SeniorL5
Location
Astoria, NY
Occupation
Database Administrators
Industry
Computer Systems Design Services
Posted
today
To get sharper similar jobs, create your profile using the link below.