Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Sr. SQL Server Administrator - Onsite NYC

$70 per hour
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 View email address on 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.

Vacancy posted 5 hours ago
Similar jobs that could be interesting for youBased on the Sr. SQL Server Administrator - Onsite NYC in New York, NY vacancy
  • $65 per hour

    Sponsorship not available, NO C2CLocated in NYC (3 days per week onsite) | Up to $65/hr | 6-Month CTH We're looking for a hands-on Salesforce professional who combines strong administration skills with enough development experience to support and enhance a complex Salesforce... 
    Suggested
    Contract work
    Temporary work
    3 days per week

    TEKsystems

    New York, NY
    3 days ago
  • $65 per hour

    Sponsorship not available, NO C2CLocated in NYC (3 days per week onsite) | Up to $65/hr | 6-Month CTH We're looking for a hands-on Salesforce professional who combines strong administration skills with enough development experience to support and enhance a complex Salesforce... 
    Suggested
    Contract work
    Temporary work
    3 days per week

    TEKsystems

    New York, NY
    4 days ago
  •  ...-Party Measurement Manager for an entertainment company in NYC. This freelance, onsite role runs through July 2027 with a strong potential to extend...  ..., and support Joint Industry Committees. Proficiency in SQL and data visualization tools is required, with a Master’s degree... 
    Suggested
    Freelance
    Work at office
    Monday to Friday

    Solomon Page

    New York, NY
    4 days ago
  •  ...infrastructure. You will build pipelines, partner with hiring managers, and drive a streamlined interview process to deliver strong candidate experiences in a fast-paced, growth-focused environment. This onsite role is based in NYC's SoHo office, 4 days a week. #J-18808-Ljbffr
    Senior
    Work at office

    Alaffia Health

    New York, NY
    1 day ago
  •  ...current trends. Collaborate with Designers, Merchandising and Product Development to adapt licensed artwork while maintaining brand integrity. Manage multiple projects and present colorways for approvals, with onsite NYC work and some Fridays from home. #J-18808-Ljbffr... 
    Senior
    Seasonal work
    Work from home

    6 Degrees Search

    New York, NY
    1 day ago
  •  ...experienced Full Stack Java with Angular engineer to join our onsite team. You will design and deliver enterprise applications using...  ...ideal candidate has 7+ years in enterprise app development, strong SQL Server/DB2, Docker and Kubernetes experience, and a track record... 
    Senior

    Capgemini

    New York, NY
    3 days ago
  • A boutique recruiting firm in Midtown NYC seeks a Senior Recruiter for a full desk role combining recruiting, sales, and business development...  ..., strong communication skills, and the ability to work onsite. This position offers a base salary plus commission, comprehensive... 
    Senior
    Base plus commission

    The Phoenix Group

    New York, NY
    1 day ago
  • $180k - $240k

     ...Product Management: Agent Product Manager - ONSITE NYC or SF NY/CA — NYC/SF Full time Location NY/CA — NYC/SF Employment type Full...  ...background preferredBasic understanding of LLMs, APIs, JSON, SQL, and SaaS platformsDeep technical acumen — able to map customer... 
    Full time

    Jobleads-US

    New York, NY
    4 days ago
  •  ...US staffing Inc. is seeking a Senior Search Engineer with deep expertise in Apache SOLR and Lucidworks for our New York, NY onsite team. The role requires around 8+ years of experience in designing, implementing, and optimizing search solutions to deliver fast, relevant... 
    Senior

    US Staffing Inc

    New York, NY
    1 day ago
  •  ...Selby Jennings is seeking an onsite Data Analyst in New York to develop and maintain batch and real-time data pipelines using Python and SQL. You will ingest, cleanse, validate, and normalize diverse datasets while building data quality controls and anomaly detection.... 

    Selby Jennings

    New York, NY
    2 days ago
  •  ...Cleartech Recruiting is seeking an on-site Senior IT Infrastructure Administrator for a leading global hedge fund in NYC or CT. You will manage Active Directory, Entra ID, Microsoft 365, VMware, networks, and data governance while mentoring junior staff. Reqs: 7+ years... 
    Senior
    Casual work

    Cleartech Recruiting

    New York, NY
    22 hours ago
  •  ...board governance, contract processes and fund operations while partnering with internal teams and external counsel. The position is onsite five days a week at Aquarian's New York City office, offering exposure to a broad range of financial services matters in a fast-... 
    Senior
    Contract work
    Work at office

    Aquarian LLC

    New York, NY
    2 days ago
  •  ...RecSkills seeks a Senior Product Engineer in New York City, onsite, full-time. You will own features end-to-end from customer conversations to architecture to QA, with 8–15 years of experience in high-quality software and a product mindset. The role emphasizes building... 
    Senior
    Full time

    RecSkills

    New York, NY
    3 days ago
  •  ...Developer for S&P Dow Jones Indices. Hybrid role with 2 days onsite weekly in NYC or Princeton, NJ, and the rest remote. Lead, design, and support...  ...in Java development, strong J2EE/JMS/EJB skills, and solid SQL. Preferred expertise includes CI/CD, AWS, and QA automation.... 
    Senior
    Remote work

    S&P Global

    New York, NY
    1 day ago
  • $178k - $250k

     ...A leading AI marketing platform is seeking a Senior Frontend Engineer to shape user-facing experiences for onsite growth products. You will design and build performant web interfaces, collaborating with product, design, and backend teams. The ideal candidate has over... 
    Senior

    Attentive

    New York, NY
    3 days ago
  •  ...upsell opportunities in collaboration with Sales and support teams. The role is client-facing, regionally embedded, and based on-site in NYC with potential travel for meetings and events. You will manage health of accounts post-sale and coordinate across product, marketing,... 
    Senior

    Gohyred

    New York, NY
    2 days ago
  • Apex Systems is seeking a Technical Support professional for onsite work in New York, NY. The role centers on laptop support across Windows, Mac, and mobile devices, with a strong emphasis on customer service and effective communication. You will contribute to site readiness... 
    Senior

    Apex Systems

    New York, NY
    3 days ago
  •  ...York MTA, leading commercial strategy, controls, and risk across pre-award, construction, and post-award phases. This full-time onsite role reports to the National Commercial Management Practice Lead and collaborates with legal, finance, and project teams to protect... 
    Senior
    Full time

    Jobleads-US

    New York, NY
    1 day ago
  •  ...Job Description Job Description ~5+ years of hands-on experience as a SQL Server Database Administrator. ~ Bachelor's degree in Computer Science, IT, or equivalent experience. ~ Expert knowledge in Windows Server, SQL Server, Azure cloud platform and specifically... 
    Senior

    The Dignify Solutions, LLC

    New York, NY
    14 days ago
  •  ...optimizing virtual meetings. Candidates must have 5-8 years of relevant experience and possess superior communication skills. This is an onsite position, crucial for supporting live events across various New York locations, ensuring high-quality audiovisual experiences for... 
    Senior

    Sun Technologies

    New York, NY
    3 days ago
  •  ...The NYC Department of Correction IT Division seeks a Genetec & Windows Server Administrator (Consultant) to manage enterprise Windows Server infrastructure and the Genetec Security Center platform across facilities. Onsite work in East Elmhurst, NY, with remote 2 days... 
    Remote work
    2 days per week

    Tsu Defunct

    New York, NY
    1 day ago
  •  ...includes working Weekends and Holidays Onsite In The NYC Area. Be Part of the Team Behind the...  ...versatile, Swiss Army Knife Network Systems Administrator to support enterprise-class data...  ...candidate will be proficient in supporting server and cloud environments but should also... 
    Hourly pay
    Contract work
    Local area
    Shift work
    Night shift

    Blue Mantis

    New York, NY
    2 days ago
  •  ...Location: New York, NY (fully onsite 5 days) Please note: We are unable to sponsor or take over sponsorship of employment visas at...  ....js, typescript, graphql, nest.js, gcp, google pubsub, postgres sql, etc. Benefits: Generous UNLIMITED PTO (and we mean... 
    Local area

    Neara

    New York, NY
    1 day ago
  • $150k - $180k

     ...services organization seeking a technically strong Senior Server Administrator to maintain and improve their core technology infrastructure...  ...independently resolving complex technical issues. This role is onsite 5 days a week for the first 3 months, with the potential to... 
    Senior
    Hourly pay
    Permanent employment
    Full time

    Atrium

    New York, NY
    2 days ago
  •  ...Title: Snowflake Data Engineer Platform Optimization Location: NYC, NY | Remote | Contract We are seeking an experienced...  ...Catalog. Strong hands-on experience with the Snowflake platform, SQL, workload management, and query performance tuning. Experience... 
    Senior
    Remote job
    Contract work
    For contractors

    Suncap Technology, Inc.

    New York, NY
    14 days ago
  •  ...globally. We’re looking for a sales leader who thrives on the front lines — someone who drives a high-performing team, shapes the mid-market motion, and turns strategy into revenue. This is a hybrid onsite role with 4 days in our NYC headquarters. #J-18808-Ljbffr
    Senior

    Cervin

    New York, NY
    3 days ago
  • $65k - $80k

     .../commute to Lower Manhattan, NYC (Downtown). Minimum 3+ years...  ...the ability to support users onsite in a professional client-...  ...repair, maintenance, network administration, and test tasks for items including...  ...to: Network Equipment (servers, firewalls, routers, wifi,... 
    Local area
    Remote work
    Shift work
    Night shift

    Inspiroz

    New York, NY
    4 days ago
  •  ...modeling for Fixed Income products. The role is Hybrid – 3 days onsite in Midtown NYC and offers a six+ month rolling engagement. The candidate...  ..., VaR analysis, and model validation in line with Firm policies. Strong SQL and Python skills are required. #J-18808-Ljbffr

    Yablon & Associates

    New York, NY
    4 days ago
  •  ...Job Description Title: Java Developer Location: NYC | Hybrid: 3-Days Onsite | Contract What You'll Do Design and develop a scalable...  ...solutions to support real-time processing. Develop and optimize SQL-based data models and queries for high-volume transactional... 
    Contract work
    For contractors

    Suncap Technology, Inc.

    New York, NY
    14 days ago
  • Soap Creek Resources is seeking a seasoned graphic designer to develop seasonal artwork for Toddler Girls Walmart licensed apparel. You will create original graphics, prints, and embellishments aligned with brand guidelines and current trends, adapting licensed artwork...
    Senior

    Soap Creek Resources

    New York, NY
    22 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Sr. SQL Server Administrator - Onsite NYC. Be the first to apply!