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

Contact : Ext 206

Additional Information :

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

Remote Work :

No

Employment Type :

Full-time