Snowflake Database Architect/Engineer
Boston,
MA or Woodbridge, NJ
F2F
interview required
Pay
Rate - $85/hr c2c (gc/usc )
4
days/week onsite
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
![]()
Regards,
Sandy M | 1Point System LLC
Lead Technical Recruiter
Direct: (803)-828-2974 • Email: sa...@1pointsys.com
• Fax: 803-832-7973 • www.1pointsys.com
115
Stone Village Drive • Suite C • Fort Mill, SC • 29708
LinkedIn
: https://www.linkedin.com/in/sandy-m-74b06b212/
![signature_1667956046]()
An
E-Verified company | An Equal Opportunity Employer