Database Administrator

Oyster Bay, NY

Professional, Scientific, and Technical Services

About the position

CCS is looking for a motivated technical professional to join our team as a Database Administrator! This individual must have a solid IT background with a strong understanding of database theory and the technologies used to build and implement them. As well as the ability to be able to work with a variety of database software products, SQL Server etc., and communicate effectively with our technical staff and end users of the database(s). The DBA, in coordination with IT staff will be responsible for the development, performance, integrity, and security of the various database systems.

Responsibilities

• Maintains 115 SQL Server Databases associated to vendor-based applications and TOB Custom Applications (Web Front End and Access Front End).
• Manages 14 instances among the four Server Clusters - MS SQL 2008R2, 2014, 2019 and 2022.
• Installs new databases on the SQL Server instances.
• Write SQL scripts for each SQL instance to automate the daily and weekly backups.
• Write SQL scripts to manage database index and disk fragmentation.
• Build new Server Clusters and migrate databases from old to new clusters.
• Monitor SQL activity logs across all SQL instances to assure proper database performance levels.
• Verifies load balancing for each of the four Server Clusters.
• Install and Configure SQL Server Reporting (SSRS) for creation and maintenance of Animal Management Shelter Reports.
• Create and maintain the Microsoft SSRS reports.
• Maximo Database subject matter expert.
• Create and maintain Maximo BIRT reports.
• Perform other job-related duties as assigned.

Requirements

• Database certification (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator) - Preferred.
• Proven experience (3+ years) as a Database Administrator or in a similar role.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to work independently and in a team-oriented environment.
• Detail-oriented with a focus on accuracy.

Benefits

• Pay for this position is between $95,000-$125,000 annually.