Description

  • Maintain a Snowflake data warehouse, and data replication from various sources.

This will include production deployments via a dev/ops procedure as well as monitoring the environment.

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

  • Working experience in setup, integration, and security [Active Directory/SSO etc.] with any
  • SAAS applications
  • 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 DB2/UDB, 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

Key Skills
Education

Any Gradute

Back To Jobs