How you move is why were here.
Now more than ever.

Get back to what you need and love to do.
The possibilities are endless...

Now more than ever our guiding principles are helping us in our search for exceptional talent - candidates who align with our unique workplace culture and who want to maximizethe abundant opportunities for growth and success.

If this describes you then lets talk!

HSS is consistently among the top-ranked hospitals for orthopedics and rheumatology by U.S. News & World Report. As a recipient of the Magnet Award for Nursing Excellence HSS was the first hospital in New York City to receive the distinguished designation. Whether you are early in your career or an expert in your field you will find HSS an innovative supportive and inclusive environment.

Working with colleagues who love what they do and are deeply committed to our Mission you too can be part of our transformation across the enterprise.

Emp Status

Work Shift

What you will be doing

Position: Senior SQL Database Administrator

Employer: Hospital for Special Surgery

Location: 535 East 70th Street New York NY 10021

Position Description:

Partial telecommuting permitted; must be in office 2 days/week minimum and must be available to work nights/weekends for IT maintenance and to troubleshoot down systems.

Configure and maintain databases and procedures as well as monitor the health and performance of all HSS databases and database management systems (100 databases and 20 enterprise servers). Responsible for full SQL database administration including scripting security and troubleshooting. Setup and support Database replication and high-availability solutions including Always on Clustering and Availability groups Peer-to-Peer Replication DB Mirroring and Log Shipping. Responsible for change management and communication of changes to senior IT management. Create a proactive self-correcting environment with alerts and notifications customized to the specialized needs of HSS. Optimize systems and ensure quality performance at Operating System (OS) and Database levels. Install and configure SQL server in Azure and AWS cloud. Support SQL server and Aurora database in AWS Cloud. Responsible for performance tuning of stored procedure. Review codes before deployment and suggest changes if necessary. Responsible for the design and implementation of database backup strategy.

Minimum Requirements:

Bachelors degree in Electrical Engineering Computer Engineering or a related IT field and 5 years of experience in the job offered or related. Must have 5 years of experience with: MS-SQL server database administration in multiple variants for large database environments of 1 TB; writing and debugging SQL Code and managing SQL server disk performance; driving optimization through automation and SQL scripting stored procedures views tables and functions and adhoc queries; creating technical standards and providing in-depth performance analysis of systems and impact analysis of new requirements in a healthcare environment including producing & implementing recommendations; assisting in the design of relevant infrastructure; and issuing decisions based on company security protocols; monitoring and maintaining capacity of storage and processing; Microsoft Windows server and server support experience of SSRS Deployment SSIS Deployment MDS DQS and SSAS Deployment; database replication and high availability solutions including Always-on Clustering and Availability groups Peer-to-Peer Replication DB Mirroring and Log Shipping; communicating change management to senior IT management; partitioning; Performance Tuning; Backups Restores and Recovery Models; Role based Security Model; Data Protection and Integrity; and Database Capacity Planning. Must have 3 years of experience with an ITIL applied production environment.

Salary Offered: The salary range for this position is $124000 - $211000 / year.

In addition this position will be eligible for additional benets consistent with the role. The salary of the nalist selected for this role will be determined based on various factors including but not limited to: scope of role level of experience education accomplishments internal equity budget and subject to Fair Market Value evaluation.

To Apply: Use Apply link or send resume and cover letter to and reference Senior SQL Database Administrator .

#LI-DNI

Non-Discrimination Policy
Hospital for Special Surgery is committed to providing high quality care and skilled compassionate reliable service to our community in a safe and healing environment. Consistent with this commitment Hospital for Special Surgery provides care admits and treats patients and provides all services without regard to age race color creed ethnicity religion national origin culture language physical or mental disability socioeconomic status veteran or military status marital status sex sexual orientation gender identity or expression or any other basis prohibited by federal state or local law or by accreditation standards.