Sr. SQL Server Database Administrator

Nuvance Health; Village of Victor (NY); On-site; USD 113,000 - 152,000; Full time

Job summary

A healthcare innovator seeks an SQL Server Database Administrator responsible for managing SQL databases, optimizing performance, ensuring data integrity, and supporting business-critical operations. Ideal candidates will possess extensive experience with cloud environments, troubleshooting, and maintaining high availability across database systems. Join a team committed to excellence in a collaborative environment.

Qualifications

• 10+ years' experience in Database Administration.
• 5 years of experience with cloud-based SQL Server environments.
• Familiarity with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

Responsibilities

• Responsible for administration of enterprise-wide application databases.
• Proactively monitor global database systems for performance.
• Lead the design and implementation of new databases.

Skills

SQL Server

Azure SQL Database

Database Management

Troubleshooting

Monitoring

PowerShell Scripting

Education

Bachelor's degree in Computer Science, IT, Engineering

Tools

Microsoft Office Suite

Job description

JOB DESCRIPTION

CooperVision, a division of CooperCompanies (NASDAQ:COO), is one of the world's leading manufacturers of soft contact lenses. The Company produces a full array of daily disposable, two-week and monthly contact lenses, all featuring advanced materials and optics. CooperVision has a strong heritage of solving the toughest vision challenges such as astigmatism, presbyopia and childhood myopia; and offers the most complete collection of spherical, toric and multifocal products available. Through a combination of innovative products and focused practitioner support, the company brings a refreshing perspective to the marketplace, creating real advantages for customers and wearers. For more information, visit www.coopervision.com.

Job Summary:

We are seeking an experienced SQL Server Database Administrator to join our team. The ideal candidate will have hands-on experience managing SQL databases, including Microsoft Azure SQL Databases, while ensuring optimal database performance, security, and availability. This role requires a strong understanding of database management systems, best practices, and effective troubleshooting techniques. The successful candidate will be responsible for maintaining data integrity, security, availability, and performance across our systems to support business-critical operations.

RESPONSIBILITIES

1. Responsible for administration of all enterprise-wide application databases and data file structures. This includes but is not limited to controlling disk space and device allocation, validation checks, database design/changes, developing logical and physical data models in complex, multi-application environments including enterprise or corporate level as well as project level models for end user reporting.
2. Responsible for performance of existing databases and ensuring databases are available per published up times
3. Proactively monitor the global database systems to ensure secure services with minimum downtime
4. Ensure that the applicable hardware resources are allocated to the databases to ensure high availability and optimum performance.
5. Provide database expertise for the design and implementation of SAN infrastructure as it relates to global databases.
6. Responsible for providing trend analysis to the infrastructure management team to enable them to make informed decisions regarding resource management.
7. Lead the design and implementation of new databases and/or the improvement of existing databases.
8. Responsible for problem escalation to Application Development team and third parties as appropriate.
9. Setup and maintain security procedures that ensure appropriate authorized access by users to databases and the information therein.
10. Responsible for incoming ServiceDesk tickets to Database group.
11. Provide assistance and support to the local Help Desks in identifying root cause issues, corrective action and closing tickets.
12. Provide technical expertise to all I.T. groups as needed.
13. Assist in the maintenance of I.T. systems' documentation for all production applications in accordance with ISO/FDA/SOX standards.
14. Assist in the development, maintenance and implementation of a Disaster Recovery Plan for all global applications
15. Provide database support on-site or by phone as required for all shifts
16. Interface as a technical contact with Microsoft support as it relates to solving Microsoft service requests
17. Maintain awareness of technological developments in computer hardware and software systems
18. Provide timely and concise summaries of project status to manager

Project Execution

1. Communicates and applies project standards.
2. Consistently delivers high-quality services to the user community.
3. Plan and lead testing, implementation, training, support and documentation activities for Database-related projects
4. Assist other DBA's, both internal and external as needed

CooperVision's management team is committed to the development of and implementation of the quality management system and maintaining its effectiveness by communicating to the organization the importance of meeting customer as well as statutory and regulatory requirements.

Travel Requirements:

• 15% or less

QUALIFICATIONS

Knowledge, Skills and Abilities:

• 5 years of Experience with cloud-based SQL Server environments (Azure SQL, AWS RDS, etc.).
• Experience with SQL Server AlwaysOn and Microsoft Failover Cluster
• Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Practical experience in monitoring and tuning a database to provide a high availability service.
• Experience managing multiple RDBMS on large systems
• Proficiency in Microsoft Office Suite.
• Familiarity with PowerShell scripting for database automation.
• Experience with Microsoft Dynamics 365 is helpful
• Other desirable skills Include:
  1. Excellent written, oral, and interpersonal communication skills.
  2. Excellent time management
  3. Highly self-motivated, self-directed, and attentive to detail.
  4. Ability to effectively prioritize and execute tasks in a high-pressure environment.
  5. Extensive experience working in a team-oriented, collaborative environment
• Ability to produce exceptional quality output

Work Environment:

• Normal office environment.
• Occasional exposure to manufacturing environments for the purpose of managing or training in software applications.

Experience:

• 10+ years' experience in Database Administration of SQL Server databases.
• Must be proficient with Microsoft Office and Microsoft Project

Education:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related experience.

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

For U.S. locations that require disclosure of compensation, the starting base pay for this role is between $113,441.00 and $151,255.00 per year and may include cost of living adjustments. The actual base pay includes many factors and is subject to change and modification in the future. This position may also be eligible for other types of compensation and benefits.

#LI-RK1