Snowflake Database Architect/Engineer || 4 days onsite in Boston, MA or Woodbridge, NJ || F2F interview required

Title ; Snowflake Database Architect/Engineer 

Boston, MA or Woodbridge, NJ – 4 days/week onsite

F2F interview required

Snowflake Database Architect/Engineer 

You will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms

Activities will also include cross-functional collaboration with software development, security, and data warehouse teams.

Essential Functions and Responsibilities:

• Maintain a Snowflake data warehouse, and data replication from various sources.
• 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 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
• 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 tools
• Installation, maintenance, and on-call support

Qualifications and Education:

• 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 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