Loading...

MS SQL server DBA

Derex Technologies Inc

MS SQL server DBA Overview

Company Name Derex Technologies Inc
Job Role MS SQL server DBA
Qualifications Not specified
Category I
Job Type Full Time
Location New York City, NY, United States

Job Description

Position: MS SQL server DBA

5 day onsite

Location: Local to NJ or NY city

MS SQL server DBA

NY City, 5 days onsite

Exp: 8+ years

OPEN TO GC/USC/GC EAD/H4 EAD/H1B (they must be local)

Interview: In-person

Must-have:

  • Strong Microsoft SQL Server administration and engineering
  • Install, configure, maintain, patch, and upgrade Microsoft SQL Server environments across production and non-production systems
  • Build and configure new SQL Server environments and provide ongoing administration and support for existing business-critical databases
  • Strong stored procedures, views, triggers and query troubleshooting
  • Performance tuning, indexing and execution-plan analysis
  • Security, logins, roles/permissions and database access management
  • Develop, Support, and troubleshoot SSIS and ETL processes, including failed jobs, connectivity problems, data processing issues, and performance problems.
  • Ongoing maintenance of existing databases: monitoring, health checks, index and statistics maintenance, integrity checks, SQL Server Agent jobs, and capacity/storage management
  • Troubleshooting and resolving database incidents, outages, blocking/deadlocks, failed jobs and performance issues, including root-cause analysis
  • Supporting SQL Server on Windows Server across internal networks, including service accounts, Windows/Active Directory authentication, ports and firewall rules
  • Working with network and infrastructure teams to resolve firewall and connectivity issues between users, application servers and database servers
  • Develop and maintain backup and recovery strategies using full, differential, and transaction log backups
  • Design, implement, administer, support, and troubleshoot SQL Server High Availability and Disaster Recovery (HA/DR) solutions
  • Implement and support SQL Server Always On Availability Groups (AOAG) and Windows Server Failover Clustering (WSFC)
  • Support multi-node and multi-datacenter Availability Group architectures, including synchronous and asynchronous commit modes
  • Understand and support WSFC quorum configurations, including File Share Witness and Cloud Witness
  • Support and troubleshoot log shipping and other SQL Server disaster recovery technologies where applicable
  • Conduct periodic DR exercises, failover testing, and failback testing to validate database recoverability and operational readiness
  • Develop, test, maintain, and improve detailed HA/DR procedures and disaster recovery runbooks
  • Understand business requirements for Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and ensure database recovery strategies support those requirements
  • Scripting with PowerShell, T-SQL and batch to automate and maintain databases and applications on servers (maintenance, deployments, monitoring and alerts)
  • Supporting application releases, including database changes, deployment and post-release checks
  • Documenting database designs, configurations, support procedures and runbooks
  • Working closely with application, development and testing teams on defect triage and fixes

Regards,

Manoj Goud

Derex Technologies INC

Contact: 973-834-5005 Ext 206

Additional Information

All your information will be kept confidential according to EEO guidelines.


Confirm with the Employer

To apply for this job please visit jobs.smartrecruiters.com.