RIT Solutions, Inc.
Senior Database Administrator
RIT Solutions, Inc., Woodbridge, New Jersey, us, 07095
Title- Senior Database AdministratorClient- Plymouth Rock AssuranceLocation-Woodbridge, NJ or Boston, MA
Must have - Snowflake, DB2, DBT, FiveTran
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.
Essential Functions and Responsibilities:Maintain a Snowflake data warehouse, and data replication from various sources.This will include production deployments vi dev/ops procedure as well as monitoringthe health and well-being of the environment.
Set up and maintain security and access for production.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 servicesAnalyze archiving approaches, propose solution(s) and assist in implementation of chosen approachReview and revise existing tables and indexing strategies to improve storage efficiency and accessResponsible for performance tuning assistance on all data pull/queries and working with end-usersPro-actively identify issues and coordinate resolutionsAssist programmers during development by responding to questions and providing guidance when necessary.Responsible for user direction/support on all data queriesAnalyze problems and propose, present and propagate solutions or practices to meet architectural challengesParticipating in unit, system, user and performance testingUser level familiarity with version control toolsInstallation, maintenance, and on-call support
Qualifications and Education:
Working experience in setup, integration, and security [Active Directory/SSO etc.] with anySAAS applicationsKnowledge & ideally working experience, data lake, data modelling on Snowflake, AWS S3, GlueWorking experience in setting up security and access controls in Snowflake5+ years hands on database work DB2/UDB, SQL ServerHands on experience with AWS RDS, DocumentDB, DynamoDB, and Redis databasesAn understanding of proper indexing and experience with query tuningKnowledge of DB2Knowledge of UDB/AIX utilities such as backup, reorg, runstats and rebind is requiredKnowledge of Oracle and MS SQL Server reorg, update statsExperience with AWS DMSExcellent communication (verbal and written) and interpersonal skillsExperience using a Software Development Life Cycle (SDLC) methodologyAbility to analyze existing configuration and recommend hardware/software improvementsDemonstrated ability to meet business needs with sound technical approachesSelf-motivated, task oriented, and capable of working independently on multiple projects simultaneouslyKnowledge of the Property and Casualty Insurance industry is a plusKnowledge of replication desired.Prior experience migrating databases from on premise data center to the cloud is preferred.
Must have - Snowflake, DB2, DBT, FiveTran
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.
Essential Functions and Responsibilities:Maintain a Snowflake data warehouse, and data replication from various sources.This will include production deployments vi dev/ops procedure as well as monitoringthe health and well-being of the environment.
Set up and maintain security and access for production.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 servicesAnalyze archiving approaches, propose solution(s) and assist in implementation of chosen approachReview and revise existing tables and indexing strategies to improve storage efficiency and accessResponsible for performance tuning assistance on all data pull/queries and working with end-usersPro-actively identify issues and coordinate resolutionsAssist programmers during development by responding to questions and providing guidance when necessary.Responsible for user direction/support on all data queriesAnalyze problems and propose, present and propagate solutions or practices to meet architectural challengesParticipating in unit, system, user and performance testingUser level familiarity with version control toolsInstallation, maintenance, and on-call support
Qualifications and Education:
Working experience in setup, integration, and security [Active Directory/SSO etc.] with anySAAS applicationsKnowledge & ideally working experience, data lake, data modelling on Snowflake, AWS S3, GlueWorking experience in setting up security and access controls in Snowflake5+ years hands on database work DB2/UDB, SQL ServerHands on experience with AWS RDS, DocumentDB, DynamoDB, and Redis databasesAn understanding of proper indexing and experience with query tuningKnowledge of DB2Knowledge of UDB/AIX utilities such as backup, reorg, runstats and rebind is requiredKnowledge of Oracle and MS SQL Server reorg, update statsExperience with AWS DMSExcellent communication (verbal and written) and interpersonal skillsExperience using a Software Development Life Cycle (SDLC) methodologyAbility to analyze existing configuration and recommend hardware/software improvementsDemonstrated ability to meet business needs with sound technical approachesSelf-motivated, task oriented, and capable of working independently on multiple projects simultaneouslyKnowledge of the Property and Casualty Insurance industry is a plusKnowledge of replication desired.Prior experience migrating databases from on premise data center to the cloud is preferred.