Snowflake Database Architect Hybrid
ANKIT VERMA
Snowflake Database Architect Hybrid
Location: Locals only, Boston, MA, or Woodbridge, NJ – 4 days/week onsite
Interview: F2F interview required
Pay Rate - $70/hr. C2C Max
Visa: GC/USC/GC-EAD/H4 only
Duration: 12 months
Client: Plymouth Rock Assurance.
Need 15+ years of experience!!
Snowflake Database Architect !!
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
Best
regards,
Ankit Verma
Sr. Technical IT Recruiter | ALLEGIS IT