Senior Database Administrator

Senior Database Administrator

As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also include cross-functional collaboration with software development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.

Essential Functions and Responsibilities:

Development responsibilities include data modeling and analysis, schema design, and database object creations (tables, stored-procedures, triggers, functions, and jobs, etc.)

Identify, assess, and evaluate technologies, products, and tools for building enterprise architecture services

Analyze archiving approaches, propose solution(s) and assist in implementation of chosen approach

Review and revise existing tables and indexing strategies to improve storage efficiency and access

Responsible for performance tuning assistance on all data pull/queries and working with end-users

Responsible for learning the data within the Data Warehouse and how Policy, Quotes, Claims and Billing are integrated

Pro-actively identify issues and coordinate resolutions

Assist programmers during development by responding to questions and providing guidance when necessary.

Responsible for user direction/support on all data queries

Analyze problems and propose, present and propagate solutions or practices to meet architectural challenges

Participating in unit, system, user and performance testing

User level familiarity with version control

Installation, maintenance, and on-call support

Qualifications and Education:

Hands on experience with designing, implementing, and maintaining Snowflake, and Fivetran is required. Certification preferred

5+ years hands on database work DB2/UDB, SQL Server

Hands on experience with AWS RDS, DocumentDB, DynamoDB, and Redis databases

An understanding of proper indexing and experience with query tuning

Knowledge of DB2 Range Partitioning, MDC and MQT

Knowledge of UDB/AIX utilities such as backup, reorg, runstats and rebind is required

Knowledge of Oracle and MS SQL Server reorg, update stats

Experience with AWS DMS

Excellent communication (verbal and written) and interpersonal skills

Experience using a Software Development Life Cycle (SDLC) methodology

Ability to analyze existing configuration and recommend hardware/software improvements

Demonstrated ability to meet business needs with sound technical approaches

Self motivated, task oriented, and capable of working independently on multiple projects simultaneously

Knowledge of the Property and Casualty Insurance industry is a plus

Experience in designing and developing BI objects, Data Mining, Big Data areas.

Knowledge of Perl desired.

Knowledge of Embarcadero Rapid SQL.

Knowledge of replication desired.

Informatica knowledge a plus.

About the Company:

The Plymouth Rock Company and its affiliated group of companies write and manage over $2.0 billion in personal and commercial auto and homeowner’s insurance throughout the Northeast and mid-Atlantic, where we have built an unparalleled reputation for service. We continuously invest in technology, our employees thrive in our empowering environment, and our customers are among the most loyal in the industry. The Plymouth Rock group of companies employs more than 2,000 people and is headquartered in Boston, Massachusetts. Plymouth Rock Assurance Corporation holds an A.M. Best rating of “A-/Excellent”.

#LI-DNI