Hi,
Hope you are doing well.
This is Tahir from Drevol LLC. Please find below the job description for your reference and please let me know if you are interested in this position.
Job Title: Sr. SQL Server Administrator
Location: NYC, NY (Onsite)
Duration: 12 Months
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
