What are the responsibilities and job description for the Snowflake Database Architect/Engineer || 4 days onsite in Boston, MA or Woodbridge, NJ || F2F interview required position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, 1 Point System, is seeking the following. Apply via Dice today!
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:
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
- 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