Database Administrator

About the position

Utica Mutual Insurance Company, with a commitment to service excellence, provides valuable support to internal system users, including employees, agents, and insureds across various regions. Utica's mission is to ensure timely, quality interactions, enhancing customer satisfaction and achieving high first-call resolution rates.

Responsibilities

• Manage, maintain, and optimize Oracle and SQL Server databases.
• Perform regular database patching and updates to ensure optimal performance and security.
• Conduct database performance reviews and provide suggestions for query optimizations.
• Develop and implement automation solutions to streamline database management tasks.
• Monitor database health and performance metrics, responding proactively to any issues.
• Perform regular backup and recovery operations to safeguard data integrity.
• Implement disaster recovery plans and ensure data availability in case of systems failures.
• Create and maintain comprehensive documentation of database configurations, processes, and procedures.
• Provide technical guidance and support to application development staff as needed.
• Work closely with development teams, IT staff, and other stakeholders to support database-related needs and projects.

Requirements

• Education: Bachelor's Degree- Computer Science or related field preferred.
• Experience: 2-4 years required. 3-8 years of experience as a Database Administrator, with a focus on Oracle and/or SQL Server preferred.
• Strong understanding of database patching, security protocols, and performing tuning.
• Experience with database upgrade processes and migrations.
• Proficiency in SQL and PL/SQL for Oracle, and T-SQL for SQL Server.
• Familiarity with automation tools (Ansible) and scripting languages (Bash, PowerShell) to enhance database operations.
• Excellent problem-solving skills and attention to detail.
• Experience developing and managing SSIS packages for data integration.
• Strong communication and collaboration skills.

Nice-to-haves

• Experience with SolarWinds DPA and the IDERA Suite preferred.

Benefits

• Medical and Prescription Drug Benefit
• Dental Benefit
• Vision Benefit
• Life Insurance and Disability Benefits
• 401(k) Profit Sharing and Investment Plan (Includes annual Company financial contribution and discretionary Profit Sharing contribution based upon annual company financial results)
• Health Savings Account (HSA)
• Flexible Spending Accounts
• Tuition Assistance, Training, and Professional Designations
• Company-Paid Family Leave
• Adoption/Surrogacy Assistance Benefit
• Voluntary Benefits - Group Accident Insurance, Hospital Indemnity, Critical Illness, Legal, ID Theft Protection, Pet Insurance
• Student Loan Refinancing Services
• Care.com Membership with Back-up Care, Senior Solutions
• Business Travel Accident Insurance
• Matching Gifts program
• Paid Volunteer Day
• Employee Referral Award Program
• Wellness programs