Overall, this role requires a Senior DBA with extensive experience in various database platforms, particularly Snowflake and Fivetran. Location- Boston Interested candidate's can be shared their resume's at Database Expertise: Hands-on experience designing, implementing, and maintaining Snowflake and Fivetran (certification preferred). 5+ years of experience with DB2/UDB and SQL Server. Experience with AWS RDS, DocumentDB, DynamoDB, Redis databases. Experience working with large-scale databases. Understanding of proper indexing and query tuning. Knowledge of DB2 concepts (Range Partitioning, MDC, MQT). Knowledge of UDB/AIX utilities (backup, reorg, runstats, rebind). Knowledge of Oracle and MS SQL Server reorg and update statistics. Experience with AWS DMS (Data Migration Service). Other Skills: Experience using a Software Development Life Cycle (SDLC) methodology. User-level familiarity with version control systems. Experience with installation, maintenance, and on-call support for databases. Additional Requirements: Excellent communication (written and verbal) and interpersonal skills. Strong analytical and problem-solving skills. Proven leadership and collaboration skills. Ability to analyze existing configurations and recommend improvements. Self-motivated, task-oriented, and able to work independently on multiple projects. Must be a team player. Bonus Skills (Highly Valued): Knowledge of the Property and Casualty Insurance industry. Experience in designing and developing BI objects, Data Mining, and Big Data. Knowledge of Perl programming. Knowledge of Embarcadero Rapid SQL. Knowledge of database replication. Informatica knowledge. Job Types: Full-time, Contract
Pay: $47.17 - $65.00 per hour
Expected hours: 40 per week
Benefits:
Dental insurance Health insurance Paid time off Schedule:
8 hour shift Day shift Experience:
Snowflake and Fivetran: 7 years (Required) DB2/UDB and SQL Server: 6 years (Required) Oracle and MS SQL Serve: 5 years (Required) AWS DMS (Data Migration Service): 5 years (Preferred) Ability to Commute:
Boston, MA (Preferred) Ability to Relocate:
Boston, MA: Relocate before starting work (Required) Work Location: In person