Sr. SQL Server Administrator - Onsite NYC

job summary:

Experience: 8+ years overall, with strong hands-on SQL Server administration and production support experience

Summary: A support-focused senior DBA who sets up, maintains and supports new and existing SQL Server (or equivalent) databases and the Windows servers they run on across internal networks. Must be comfortable using scripts to maintain databases and applications on servers.

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

Highly preferred

Direct INGRES -> SQL Server migration experience

Knowledge of Ingres SQL, database objects and data types

Experience identifying datatype/schema differences between Ingres and SQL Server

Utilities / T&D domain experience

Schema/object migration and database dependency analysis

Data migration, reconciliation and post-migration validation

Experience with large or business-critical legacy database modernization

Experience supporting migration testing, cutover and post-production stabilization

Strong data modeling and database design experience, including logical/physical models, relationships, keys, constraints, and normalization

Database source control

location: New York, New York job type: Contract salary: $70 - 72 per hour work hours: 9am to 6pm education: Bachelors

responsibilities:

Experience: 8+ years overall, with strong hands-on SQL Server administration and production support experience

Summary: A support-focused senior DBA who sets up, maintains and supports new and existing SQL Server (or equivalent) databases and the Windows servers they run on across internal networks. Must be comfortable using scripts to maintain databases and applications on servers.

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

Highly preferred

• Direct INGRES -> SQL Server migration experience
• Knowledge of Ingres SQL, database objects and data types
• Experience identifying datatype/schema differences between Ingres and SQL Server
• Utilities / T&D domain experience
• Schema/object migration and database dependency analysis
• Data migration, reconciliation and post-migration validation
• Experience with large or business-critical legacy database modernization
• Experience supporting migration testing, cutover and post-production stabilization
• Strong data modeling and database design experience, including logical/physical models, relationships, keys, constraints, and normalization
• Database source control

qualifications:

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

Highly preferred

Direct INGRES -> SQL Server migration experience

Knowledge of Ingres SQL, database objects and data types

Experience identifying datatype/schema differences between Ingres and SQL Server

Utilities / T&D domain experience

Schema/object migration and database dependency analysis

Data migration, reconciliation and post-migration validation

Experience with large or business-critical legacy database modernization

Experience supporting migration testing, cutover and post-production stabilization

Strong data modeling and database design experience, including logical/physical models, relationships, keys, constraints, and normalization

Database source control

skills:

Active Directory,backup and recovery strategies,Cloud,connectivity problems,analysis Data,data processing,database recovery,storage management,database designs,database design,database objects,database servers,databases,maintain databases,database,Disaster Recovery,ETL processes,Failover Clustering,firewall rules,firewall,indexing,INGRES,legacy database,log shipping,SQL Server,Microsoft SQL Server,Windows,servers,node,application releases,runbooks,SQL,SQL Server Agent,SSIS,SQL Server administration,stored procedures,Scripting,application servers,defect triage,source control,High Availability,T-SQL,PowerShell,Windows servers,Windows Server,troubleshoot,Troubleshooting,administration,Install,automate,business requirements,data modeling,transaction log,health checks,infrastructure,statistics,maintenance,migration testing,normalization,operational readiness,post-production,production support,production systems,RPO,root-cause analysis,Security,testing

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.