Senior Database Administrator - Woodbridge Township, United States - Plymouth Rock Assurance

Plymouth Rock Assurance Woodbridge Township, United States

2 weeks ago

Insurance

Description

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

Database Administrators

1 week ago

Fusion Plus Solutions Inc. Edison, United States

Database Administrators · - Contact UsEdison NJ · Wed, 15 May 2024 · Job Overview · Responsible for Database designing, Data modeling, Application Server, Oracle, DB-2, SQL, PL/SQL packages, procedures, functions and triggers using Oracle 11g/12c. Server, Sybase, OEM, BMC-PATROL, ...
Database Administrator

2 weeks ago

PSEG Newark, United States

**Requisition**: 78499 · **PSEG Company**: PSEG Services Corp. · **Salary Range**: $ 88,400 - $ 140,000 · **Incentive**: PIP 10% · **Work Location Category**: Remote Local · PSEG operates under a Flexible Work Model where flexible work is offered when job requirements allow. In s ...
Database Administrator

2 weeks ago

Spectrum Dynamics Jersey, United States

The Information Technology Service Center of the Statutory Health Insurance (ITSG) supports the digitization of the health and social sector. We develop and operate specialized applications as a full-service provider, simplifying and accelerating electronic data exchange between ...
Database Administrator Is Needed

1 week ago

Linden Pharma Inc Brooklyn, United States

**Database Administrator is needed to perform the following duties**: · - Working with a database requires the administrator to understand complex systems, and how a minor error can cause major problems. · - Resolve issues within the company's database and secure all company data ...
Director of Database Administration

1 week ago

NYC Careers Manhattan, United States

**DIRECTOR OF DATABASE ADMINISTRATION**: · - Apply**DIRECTOR OF DATABASE ADMINISTRATION**: · - Agency: HRA/DEPT OF SOCIAL SERVICES · - Posted on: 05/21/2024- Job type: Full-time · Location · MANHATTAN · - Title Classification: No exam required · Department · DSS ACCOUNTABILITY OF ...
HR Database Administrator

2 weeks ago

Canon Business Process Services, Inc. New York, United States

Canon currently has an opening for a **HR Database Administrator** **This role will be based at our Corporate Office (261 Madison Ave) in New York City. You will be required to be in the office on Tuesdays and Wednesdays. **Canon Business Process Services ("Canon") provides on-si ...
Director, Database Administration

4 days ago

Fiserv, Inc. Berkeley Heights, United States

**Calling all innovators - find your future at Fiserv.** · We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants, and consumers to one another millions of ...
Senior Database Administrator

2 weeks ago

Phoenix Innovations Manville, United States

Come join the SHL Group and share with us the passion for telemedical healthcare. Through our work, we strengthen the self-management of many people's health and thus improve their quality of life. Our services complement traditional medical care and enable a safer approach to he ...
DB2 Database Administrator

3 weeks ago

Diverse Lynx Iselin, United States

Job Title :: DB2 Database Administrator · Location :: Plano, TX (Onsite Rotational) · Job Description : · Skills Needed - DB2, Production Support, Monitoring, L1, L2, L3, DB Joins, LEW Offer DBA DB2 support for application development team. · Ensure integrity, availability and ...
database administrator

2 weeks ago

Palvai Global Services, Inc. South Plainfield, United States

DATABASE ADMINISTRATOR - Palvai Global Services, Inc. - South Plainfield, NJ South Plainfield, NJ & various unanticipated locations throughout the U.S.: Instal, confgur, maintan, upgrd & migrt databs servrs. Crt, modfy & mang usrs, grups, conections, asign rols & privilgs & secur ...
Database Administrator

1 day ago

GOMIAPP, LLC Defunct Piscataway, United States

Install, Configure, Administer and Troubleshoot Microsoft SQL server, Oracle and other enterprise level database servers. Tune, Optimize and Load balance the database server, monitor various code used for stored procedures and functions and coordinate with network team for high p ...
Administrator of Donor Database and Engagement

4 days ago

Everytown for Gun Safety New York, United States

and deadline-oriented individual. · **In this role, you will**: · Process donations · - including, but not limited to: · - Entering wire transfer information · - Entering stocks transfer information · - Manual transaction over the phone · - Processing Direct Mail reply mail · - U ...
Database Administrator

2 weeks ago

Rutgers University New Brunswick, United States

Rutgers, The State University of New Jersey, is seeking a Database Administrator for the Division of Institutional Planning & Operations (IP&O). The position will join IP&O ITs Application Development team to provide Oracle and SQL Server database a Database Administrator, Databa ...
Database Administrators

3 weeks ago

RightTalents LLC New York, United States

Title: Database Administrators · Location: New York, NY (Onsite) · Duration: 12 Months · Working Hours Per Day: 7.5hrs · Note: Looking for candidates to work on our W2 · JOB SPECIFICATIONS: · Database technical design, storage configuration, space management, backup and recovery, ...
Database Administrator

3 weeks ago

Dexian New York, United States

Oracle Database Administrator · Remote · Long Term Contract · Job Description · Proficiency in **Oracle Database Administration** and understanding of its architecture. · - Experience with **Oracle Cloud Infrastructure** and **Autonomous Database**. · - Knowledge of **migration ...
Database Administrators

3 weeks ago

RightTalents LLC New York, United States

Title: Database Administrators · Location: New York, NY (Onsite) · Duration: 12 Months · Working Hours Per Day: 7.5hrs · Note: Looking for candidates to work on our W2 · JOB SPECIFICATIONS: · Database technical design, storage configuration, space management, backup and rec ...
Database Administrator

13 hours ago

PSEG Newark, United States

Requisition : 78499 · PSEG Company: PSEG Services Corp. · Salary Range : $ 88,400 - $ 140,000 · Incentive : PIP 10% · Work Location Category : Remote Local · PSEG operates under a Flexible Work Model where flexible work is offered when job requirements allow. In support of t ...
Database Administrator

2 weeks ago

CyberTec New York, United States

Role: Database Administrator / Analyst · Client: MTA · Location: New York City · Experience: up to 3 years · Rate : $40/HR C2C · The Safety & Security Department of the MTA IT is seeking the service of Database Administrator / Analyst "Counter" consultant.The Analyst/Counter ...
Database Administrator

1 day ago

automotiveMastermind Inc. New York, United States

Our organization is seeking a skilled and experienced Database Administrator. This position will be an instrumental member of the team, helping to ensure the security, availability, and performance of our databases. Ideally, candidates will possess a drive for thinking creatively ...
Database Administrator

13 hours ago

City of New York New York, United States

Company Description · Job Description · THE AGENCY · The Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and ...