Required Skills- Snowflake, FiveTran, DB2/UDB/AIX, SQL Server
They’re looking for someone who has the Administrator skills, not so much an ETL Engineer.
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.
· Prior experience migrating databases from on premise data centers to the cloud is preferred.