Senior Database Administrator

4 weeks ago

Woodbridge Township, United States Plymouth Rock Assurance Full time

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

  • Senior Database Administrator

    1 week ago

    Woodbridge, New Jersey, United States Plymouth Rock Assurance Full time

    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...

  • Senior Database Administrator

    4 weeks ago

    Woodbridge, United States Plymouth Rock Assurance Full time

    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...

  • Senior Database Administrator

    4 weeks ago

    Woodbridge, United States Plymouth Rock Assurance Full time

    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...

  • Senior Database Administrator

    2 weeks ago

    Woodbridge, United States Plymouth Rock Assurance Full time

    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...

  • AWS RedShift Database Expert

    3 days ago

    Woodbridge Township, United States Randstad Digital Full time

    we are working on a major project to replace our client presentation package system, and one of the key components of the stack in an AWS RedShift database.It’s fairly new technology to us, and we are looking at bringing in an additional external consultant to help out. We would need someone with deep expertise in RedShift, performance tuning and...

  • AWS RedShift Database Expert

    2 days ago

    Woodbridge, United States Randstad Digital Full time

    we are working on a major project to replace our client presentation package system, and one of the key components of the stack in an AWS RedShift database.It’s fairly new technology to us, and we are looking at bringing in an additional external consultant to help out. We would need someone with deep expertise in RedShift, performance tuning and...

  • Director, Traffic

    1 month ago

    Mount Laurel Township, United States NFL Full time

    Overview / Objective Responsible for planning, directing, and overseeing the operational procedures of the Commercial Traffic department, including log scheduling, program formats, brand assignments and copy instructions. Work closely with Advertising Sales, Network Promotions, Programming and Operations to ensure the accuracy of the on-air...

  • Director, Traffic

    4 weeks ago

    Mount Laurel Township, United States NFL Full time

    Overview / Objective Responsible for planning, directing, and overseeing the operational procedures of the Commercial Traffic department, including log scheduling, program formats, brand assignments and copy instructions. Work closely with Advertising Sales, Network Promotions, Programming and Operations to ensure the accuracy of the on-air...

  • Senior Java Software Engineer

    4 weeks ago

    Woodbridge Township, United States Cybernetic Search Full time

    A leading specialty group focused on settlement-risk of the global marketplace is recruiting for a Senior Java Developer (AVP) to support their critical application suite. These applications help to reduce counterparty risk, improve liquidity management, and support the bedrock of the global economy. The Senior Java Developer should be well-equipped to...

  • Senior Java Software Engineer

    2 months ago

    Woodbridge Township, United States Cybernetic Search Full time

    A leading specialty group focused on settlement-risk of the global marketplace is recruiting for a Senior Java Developer (AVP) to support their critical application suite. These applications help to reduce counterparty risk, improve liquidity management, and support the bedrock of the global economy. The Senior Java Developer should be well-equipped to...

  • Database Architect

    2 weeks ago

    Hamilton Township, United States New York Technology Partners Full time

    Job title: Database ArchitectLocation: Plaza Hamilton, NJPosition: Long term contractNote: Hybrid role 3 days onsite in a week.Interview: In-PersonJob Description:Design and develop database systems that are efficient, scalable, and secure.Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience...

  • Database Architect

    3 weeks ago

    Township of Hamilton, United States Datasys Consulting & Software Inc Full time

    **Title: Database Architect** **Location: Hamilton, NJ(Hybrid)** **Job Type: Contract (C2C & W2)** - Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views,...

  • Practice Administrator

    4 weeks ago

    Pequannock Township, United States Cedar Crest Village by Erickson Senior Living Full time

    Location:Cedar Crest Village by Erickson Senior LivingCedar Crest is a beautiful 130-acre continuing care retirement community nestled in the Ramapo Mountains in Pompton Plains, a neighborhood of Morris County, New Jersey. We’re part of a growing network of communities developed and managed by Erickson Senior Living, a national provider of senior living...

  • Database Modeler-Developer

    3 weeks ago

    Hamilton Township, United States Rose International Full time

    Date Posted: 06/10/2024 Hiring Organization: Rose International Position Number: 465575 Job Title: Database Modeler-Developer Job Location: Hamilton, NJ, USA, 08619 Work Model: Hybrid Employment Type: Temporary Estimated Duration (In Weeks): 5 Min Hourly Rate ($): 55.00 Max Hourly Rate ($): 63.00 Must Have Skills/Attributes: AWS, Data...

  • Administrative Assistant

    2 weeks ago

    Woodbridge, United States Prince William County Service Authority Full time

    **Position Summary**: **Hiring Range Min** **Hiring Range Max** **Minimum Requirements** - Administrative Assistant I- $22.24- $28.16- Possess at least two years of experience performing general administrative work.- Administrative Assistant II- $25.38- $33.31- At least four years of progressively responsible experience performing more advanced...

  • Contract - Database Architect

    3 weeks ago

    Township of Hamilton, United States Datasys Consulting & Software Inc Full time

    **Title**: Database Architect **Location**: Hamilton, NJ(Hybrid) **Job Type**:Contract - Design and develop database systems that are efficient, scalable, and secure. Required to determine the appropriate database architecture, data storage, and indexing techniques. Hands-on experience in building new relational data models, tables, views, functions,...

  • Administrative Assistant

    1 month ago

    Woodbridge, United States VOLUNTEERS OF AMERICA CHESAPEAKE AND CAROLINAS, INC. Full time

    The Administrative Assistant is responsible for all office and clerical functions of the program, assisting the program staff with sending reports and maintaining client files, monitoring the activities of residents to ensure compliance with program rules, and ensuring the safety and appearance of the facility. The Administrative Assistant is also...

  • Administrative Assistant

    4 weeks ago

    Woodbridge, United States VOLUNTEERS OF AMERICA CHESAPEAKE AND CAROLINAS, INC. Full time

    The Administrative Assistant is responsible for all office and clerical functions of the program, assisting the program staff with sending reports and maintaining client files, monitoring the activities of residents to ensure compliance with program rules, and ensuring the safety and appearance of the facility. The Administrative Assistant is also...

  • Administrative Assistant Senior Representative

    4 weeks ago

    West Bloomfield Township, Michigan, United States The Cigna Group Full time

    The job profile for this position is Administrative Assistant Senior Representative, which is a Band 2 Professional Career Track Role.Excited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you...

  • Administrative Assistant Senior Representative

    1 week ago

    West Bloomfield Township, Michigan, United States The Cigna Group Full time

    The job profile for this position is Administrative Assistant Senior Representative, which is a Band 2 Professional Career Track Role.Excited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you...