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.
* 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.
* Responsible for performance of existing databases and ensuring databases are available per published up times
* Proactively monitor the global database systems to ensure secure services with minimum downtime
* Ensure that the applicable hardware resources are allocated to the databases to ensure high availability and optimum performance.
* Provide database expertise for the design and implementation of SAN infrastructure as it relates to global databases.
* Responsible for providing trend analysis to the infrastructure management team to enable them to make informed decisions regarding resource management.
* Lead the design and implementation of new databases and/or the improvement of existing databases.
* Responsible for problem escalation to Application Development team and third parties as appropriate.
* Setup and maintain security procedures that ensure appropriate authorized access by users to databases and the information therein.
* Responsible for incoming ServiceDesk tickets to Database group.
* Provide assistance and support to the local Help Desks in identifying root cause issues, corrective action and closing tickets.
* Provide technical expertise to all I.T. groups as needed.
* Assist in the maintenance of I.T. systems' documentation for all production applications in accordance with ISO/FDA/SOX standards.
* Assist in the development, maintenance and implementation of a Disaster Recovery Plan for all global applications
* Provide database support on-site or by phone as required for all shifts
* Interface as a technical contact with Microsoft support as it relates to solving Microsoft service requests
* Maintain awareness of technological developments in computer hardware and software systems
* Provide timely and concise summaries of project status to manager
Project Execution
* Communicates and applies project standards.
* Consistently delivers high-quality services to the user community.
* Plan and lead testing, implementation, training, support and documentation activities for Database-related projects
* 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
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:
* Excellent written, oral, and interpersonal communication skills.
* Excellent time management
* Highly self-motivated, self-directed, and attentive to detail.
* Ability to effectively prioritize and execute tasks in a high-pressure environment.
* 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