EC- Plymouth Rock Assurance

TItle- Senior Database Administrator

Rate- $70/hr to $75/hr

Visa- NO H1B

MOI- Skype & F2F

Location- Woodbridge, NJ or Boston, MA(HYBRID & Strictly LOCAL)

Duration- 12 Months

Must have – Snowflake, DB2, DBT, FiveTran

1st Round Virtual & 2nd F2F

Qualifications and Education:

• Working experience in setup, integration, and security [Active Directory/SSO etc.] with any
• SAAS applications
• Knowledge & ideally working experience, data lake, data modelling on Snowflake, AWS S3, Glue
• Working experience in setting up security and access controls in Snowflake
• 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
• 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
• Knowledge of replication desired.
• Prior experience migrating databases from on premise data center to the cloud is preferred.
• Senior Database Administrator
• As a senior member of a skilled database administrator team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran HVR Replication Tool, 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 are required