Job Description :
Location: Basking Ridge, NJ

Job Description:

What are the top 5-10 responsibilities for this position? (Please be detailed as to what the candidate is expected to do or complete on a daily basis)

Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
Create, Modify and Support various SSIS Packages - including deployment and troubleshooting.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
What software tools/skills are needed to perform these daily responsibilities?

7+ years MS SQL Server Administration experience required
3+ years of complex SSIS development experience required
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience in supporting multiple SQL Server instances in a farm and in AWS environment.
Experience working with Windows server, including Active Directory
What skills/attributes are a must have?

Experience with Sql Server Stored Procedures, Functions, etc., Performance Tuning Experience with Development and Design of SSIS Packages

What skills/attributes are nice to have?

Knowledge of High Availability (HA), DR setup Experience supporting multiple SQL Server instances in a farm or in AWS enviornment

Where is the work to be performed? (Please list preferred UHG facility, if other please specify i.e. remote work, rural, etc Basking Ridge, NJ