Sr. Database/Data Warehouse Administrator at Virtue Group LLC
woodbridge, NJ
About the Job
*NOTE: Must be ONSITE 4 days a week
*NOTE: Must be ONSITE 4 days a week
*NOTE: Must be ONSITE 4 days a week
Position: Sr. Database/Data Warehouse Administrator
Duration: 6-12 Months contract
Location: Woodbridge, NJ (Hybrid - 4 days a week)
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:
Maintain a Snowflake data warehouse, and data replication from various sources and work with data warehouse team to implement ETLs
Set up and maintain security and access control in Snowflake
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:
Working experience in ETL/ELT Products in development, setup, integration, and security [Active Directory/SSO etc.]; Example : Fivetran / DBT / Informatica etc.
Working experience in managing data warehouse, 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 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