MS SQL server DBA

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

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