Senior SQL Server DBA Job at Neshent Technologies, New York, NY

  • Neshent Technologies
  • New York, NY

Job Description

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

Job Tags

Contract work

Similar Jobs

Wilson Services

Septic Truck Driver - CDL Class B Required Job at Wilson Services

 ...Job Description Job Description Full job description Overview: We are seeking a skilled and reliable Truck Driver to join our team. As a Truck Driver, you will be responsible for residential and commercial septic pumping and disposal of non-hazardous waste and... 

MedPro Healthcare Staffing

PICU Registered Nurse Job at MedPro Healthcare Staffing

 ...PICU Registered NurseMedPro Healthcare Staffing, a Joint Commission-certified staffing agency, is seeking a quality PICU Registered Nurse (RN) for a travel assignment with one of our top healthcare clients.RequirementsEighteen months of recent experience in an Acute Care... 

Disneyland Resort

Parks Signature Fine Dining Culinary - Demi Chef - Full Time Job at Disneyland Resort

 ...theDisneyland Resort! Our Fine Dining restaurants offer incredible growth opportunities to develop your skills as a professional chef, culinarian, and craftsman. With access to the best ingredients, our award-winning restaurants at Carthay Circle and Club 33 set the... 

The UPS Store The Shops At Yale #5105

The UPS Store Center Associate Job at The UPS Store The Shops At Yale #5105

 ...outstanding customer service to walk-in customers and telephone inquiries* Continuously practices good listening skills with customers, UPS Store team members, and leadership* Takes ownership of the customer's shipping needs and offers viable solutions* Takes action to... 

Western Express

Dry Van CDL-A Truck Driver - Home Weekly Entry Level Job at Western Express

 ...WITH A SEATING SPECIALIST NOW!***NEW PAY INCREASE Announced!*** Miss less. Earn...  ...ENTRY LEVEL Class-A truck drivers in our high-paying, HOME WEEKLY Dry Van Regional! (...  ...Rider policies ~ Paid Vacation ~ NO EXPERIENCE NECESSARY ! ALL YOU NEED IS YOUR CDL-A!...