Title- Snowflake DBA

Location- Boston, MA or Woodbridge, NJ- 4 days/week onsite

Rate- $ $70/hr on C2C

Duration: 12 months CTH

Client- boston-technology

Visa – Open

Exp Level: 14+ years

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, DocumentDB, DynamoDB, Redis databases.

• Experience working with large scale databases.

• An understanding of proper indexing and experience with query tuning.

• Knowledge of DB2 Range Partitioning, MDC and MQT.

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

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

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

• Responsible for learning the data within the Data Warehouse and how Policy, Quotes, Claims and Billing are integrated.

• Proactively identify issues and coordinate resolutions

• Provide assistance to programmers during development, 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

• Installation, 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 is a plus.

Spear Staffing jobs

Snowflake DBA