Senior Database Administrator

2 weeks 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 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

  • Data Coordinator

    2 weeks ago

    Woodbridge, New Jersey, United States Aston Carter Full time

    DATA COORDINATOR | INTERVIEWS HAPPENING THIS WEEKJob Type: Data CoordinatorLocation: Woodbridge, NJPay: $20+/hrA leading company is seeking an Data Coordinator to join and support their team. This position will primarily focus on reviewing tenant bills and entering claims into the ERP software. The ideal candidate will have 2 years of data entry experience...

  • Clinic Board Certified Behavior Analyst

    2 weeks ago

    Woodbridge, New Jersey, United States First Children Services Full time

    2024 has begun at First Children Services with much excitement. We proudly supported our focus on education in a new partnership with Capella University, where our employees can take advantage of free CEUs and certificates. We continue to focus on quality care through a reduction in caseloads and an increase of supervision with senior clinicians. Come work...

  • Campus Relations and Sourcing Coordinator

    2 weeks ago

    Woodbridge, New Jersey, United States ProSmile Full time

    Job Title: Campus Relations and Sourcing Coordinator Location: Hybrid (located near Woodbridge, NJ) Reports to: Director of Talent Acquisition FLSA Status: Exempt Company Overview ProSmile is a leading dental services organization dedicated to providing high-quality dental care to communities across New Jersey, Virginia, Pennsylvania, Maryland, and District...

  • Licensed Practical Nurse

    3 weeks ago

    Woodbridge, Connecticut, 06525, New Haven County, CT, United States Maplewood at Orange LLC Part time

    Licensed Practical Nurse, LPN Shift Available: Per Diem (ALL SHIFTS) Want to know what makes our employees eager about going to work every day? The people we serve. Being a part of Maplewood requires passion and a desire to help others. Each employee has the ability to touch the hearts of all our seniors and be a part of something bigger than themselves....

  • Senior Database Administrator

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

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

  • Senior Database Administrator

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

  • Senior Database Administrator

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

  • AWS RedShift Database Expert

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

  • AWS RedShift Database Expert

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

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

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

  • Executive Director

    2 weeks ago

    Woodbridge, United States Retirement Unlimited Full time

    Retirement Unlimited is a premier provider of Residential Living, Assisted Living, and Memory Care is seeking an **Executive Director** in Alexandria VA! We are looking for a compassionate and experienced Executive Director with a passion for senior care who wants to make a difference and has the following qualities. - **Passion for Seniors** - Feels strong...

  • Senior Java Software Engineer

    2 months ago

    Woodbridge, 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

    4 weeks ago

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

  • Weekend Concierge

    2 months ago

    Woodbridge, United States Senior Lifestyle Corporation Full time

    Company Description Sat/Sun 7am - 3pm shift $15 and hour plus benefits Do you have HEART? We are looking for individuals who can embrace our mission to purposely brighten and enrich the lives of those we serve with HEART; Hospitality, Excellence, Appreciation, Respect & Teamwork. In this role you will be responsible for providing assistance to residents,...

  • Weekend Concierge

    4 weeks ago

    Woodbridge, United States Senior Lifestyle Corporation Full time

    Company Description Sat/Sun 7am - 3pm shift $15 and hour plus benefits Do you have HEART? We are looking for individuals who can embrace our mission to purposely brighten and enrich the lives of those we serve with HEART; Hospitality, Excellence, Appreciation, Respect & Teamwork. In this role you will be responsible for providing assistance to residents,...

  • Land Development Administrative Coordinator

    1 week ago

    Woodbridge, United States Prince William County Government Full time

    **Introduction**: The Department of Development Services, Land Development Division, is seeking an Administrative Coordinator who is a talented, motivated individual interested in furthering their career in public administration in a team-oriented, challenging, friendly, life-balanced workplace. Prince William County is the 2nd largest county in the...

  • Senior WordPress Developer

    1 month ago

    Woodbridge, United States Eliassen Group Full time

    **Hybrid in Woodbridge, NJ.** Our insurance client is looking for a Senior Wordpress Developer to join their team. Due to client requirement, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance....

  • Senior WordPress Developer

    4 weeks ago

    Woodbridge, United States Eliassen Group Full time

    **Hybrid in Woodbridge, NJ.** Our insurance client is looking for a Senior Wordpress Developer to join their team. Due to client requirement, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance....

  • Senior WordPress Developer

    1 month ago

    Woodbridge, United States Eliassen Group Full time

    **Hybrid in Woodbridge, NJ.**Our insurance client is looking for a Senior Wordpress Developer to join their team.Due to client requirement, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.Pay...