Info Way Solutions
Senior DBA
Info Way Solutions, Boston, Massachusetts, us, 02298
Role: Senior DBALocation: Boston, MA
This is a Senior DBA position to work as a part of a skilled DBA team in order to assist with migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, and DynamoDB, Data Migration Service (DMS).
Activities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.Knowledge, Skills and Education Required
Hands on experience with designing, implementing, and maintaining Snowflake, and fiveTran is a must. Certification preferred.5+ years hands on database work DB2/UDB, SQL Server.Hands on experience with AWS RDS, DocuemtnDB, DynamoDB, Redis databases.Experience working with large scale databasesAn understanding of proper indexing and experience with query tunningKnowledge of DB2 Range Partitioning, MDC and MQTKnowledge 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 improvements.Strong analytical and problem solving skills.Proven leadership and collaborative skills.Demonstrated ability to meet business needs with sound technical approaches.Self motivated, task oriented and capable of working independently on multiple, simultaneous projects.Must be a team player
Duties and ResponsibilitiesSpecific responsibilities include:
Development responsibilities include: data modeling and analysis, schema design, 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 approach.Review 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-usersResponsible for learning the data within the Data Warehouse and how Policy, Quotes, Claims and Billing are integrated.Pro-actively identify issues and coordinate resolutionsProvide assistance to programmers during development, 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 controlInstallation, maintenance, and on-call support
Other highly valued skills would include:
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.
This is a Senior DBA position to work as a part of a skilled DBA team in order to assist with migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, and DynamoDB, Data Migration Service (DMS).
Activities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.Knowledge, Skills and Education Required
Hands on experience with designing, implementing, and maintaining Snowflake, and fiveTran is a must. Certification preferred.5+ years hands on database work DB2/UDB, SQL Server.Hands on experience with AWS RDS, DocuemtnDB, DynamoDB, Redis databases.Experience working with large scale databasesAn understanding of proper indexing and experience with query tunningKnowledge of DB2 Range Partitioning, MDC and MQTKnowledge 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 improvements.Strong analytical and problem solving skills.Proven leadership and collaborative skills.Demonstrated ability to meet business needs with sound technical approaches.Self motivated, task oriented and capable of working independently on multiple, simultaneous projects.Must be a team player
Duties and ResponsibilitiesSpecific responsibilities include:
Development responsibilities include: data modeling and analysis, schema design, 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 approach.Review 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-usersResponsible for learning the data within the Data Warehouse and how Policy, Quotes, Claims and Billing are integrated.Pro-actively identify issues and coordinate resolutionsProvide assistance to programmers during development, 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 controlInstallation, maintenance, and on-call support
Other highly valued skills would include:
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.