Snowflake Database Administrator

2 weeks ago


Boston, United States firstPRO, Inc Full time

Long term contract

Onsite in Boston 4 days per week


Activities will include working with other teams including development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments is required.

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, DocuemtnDB, DynamoDB, Redis databases.
  • Experience working with large scale databases
  • An understanding of proper indexing and experience with query tunning
  • 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.
  • Pro-actively 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 a plus.



  • Boston, United States Diverse Lynx Full time

    Role: Snowflake Administrator Location: Boston, MA (Hybrid- Onsite) Duration: 6-12 Months * Hands-on experience on Snowflake development including Snowpipes, Snowshare, Task, Streams, UDFs and Procedures * Develop, build & maintain mission critical centralized data platform using Snowflake * Diagnose and troubleshoot Snowflake database errors * Implement...

  • Sr. Snowflake DBA

    2 days ago


    Boston, United States Saxon Global Full time

    Client: The Commonwealth of MA Center of Health Information and Analysis (CHIA) is looking for a very high Level Snowflake DBA/Consultant. Title: Sr. Snowflake DBA Location 501 Boylston Street, Suite 5100, Boston, MA 02116 Must be local and Hybrid in Boston, MA Duration: 1 year + renewals Rate is in the $85+/hr, let me know what you are seeing. ...


  • Boston, United States Compunnel Inc. Full time

    As a member of the Executive Office of Health and Human Services Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for MassHealth users. They will also be responsible for standardization, maintenance, configuration, and support...

  • Database Administrator

    17 hours ago


    Boston, United States Compunnel Inc. Full time

    As a member of the Executive Office of Health and Human Services Data Management & Engineering, the Data Platform Administrator will be responsible for the administration, configuration, and support of IT platform applications and tools for MassHealth users. They will also be responsible for standardization, maintenance, configuration, and support...


  • Boston, United States SeaHill Consulting Group Full time

    Job DescriptionA skilled software developer with over 5 years of experience in backend server solutions development, specializing in enterprise-grade database servers, ideally within a small team and full-stack development setting. The candidate should excel at designing solution architectures in the context of business process automation. Proficiency in...

  • Snowflake Data Architect

    17 minutes ago


    Boston, United States ASB Resources Full time

    Job DescriptionJob DescriptionRESPONSIBILITIESLead the migration of databases from Oracle to Snowflake, ensuring minimal disruption to business operationsDesign and implement identity management protocols within Snowflake to ensure secure access to dataDevelop and enforce cluster permissioning strategies to maintain data integrity and complianceOrganize and...

  • Snowflake DBA

    1 week ago


    Boston, United States Boston Technology Corporation Full time

    8+ years hands on database work DB2/UDB, SQL Server.Hands on experience with AWS RDS, DynamoDB, Redis databases. DB2 Range Partitioning, MDC and MQTUDB/AIX utilities such as backup, reorg, runstats and rebind is requiredOracle and MS SQL Server reorg, update stats Snowflake DBA


  • Boston, United States Amaze Systems Inc. Full time

    Job DescriptionJob DescriptionRole: DB developer with experience in Snowflake/ DatabricksLocation: Boston, MA onsiteDuration: Long TermJD:Looking for someone solid DB developer with experience in Snowflake/ Databricks.


  • Boston, United States Harbourvest Full time

    Job Description Summary For over forty years, HarbourVest has been home to a committed team of professionals with an entrepreneurial spirit and a desire to deliver impactful solutions to our clients and investing partners. As our global firm grows, we continue to add individuals who seek a collaborative, open-door culture that values diversity and innovative...


  • Boston, United States Mondo Full time

    Job DescriptionJob DescriptionApply now: DBA, this is a 100% remote opportunity. The start date is ASAP for this long-term contract positio nJob Title: DBALocation-Type: 100% Remote or Local to Boston AreaStart Date Is: ASAPDuration: ContractCompensation Range: $60-68 Per Hour W2 The estimate above represents the candidate's typical compensation range at...


  • Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....


  • Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....


  • Boston, United States WiseHire Recruitment Full time

    WiseHire are seeking a Senior Data Engineer, specializing in Snowflake, skilled at addressing the most intricate technical challenges and driving substantial business growth. This position involves direct collaboration with clients to comprehend needs, develop strategic assessments and implement and optimize the Snowflake platform for all their data needs....

  • Snowflake Developer

    1 month ago


    Boston, United States Diverse Lynx Full time

    Detailed JD good hands-on Data application developer with excellent experience on Databricks, Snowflake, Airflow, Kubernetes, Kafka, lake houses, Delta lake, Object stores like AWS s3/ Azure blob. Job Responsibilities Developing latest reusable data processing component & libraries based on Data mesh design pattern Designing & implement a modern highly...


  • Boston, United States Jobrino Full time

    The client of ours in the public sector is seeking a Database Administrator with CPT to help with a large scale database migration task as well as extra task work as necessary. This particular person will be working closely with the majority of the DBA staff other Technology Services energy as well as likely software vendors. There might be some little...


  • Boston, Massachusetts, United States Jobrino Full time

    The client of ours in the public sector is seeking a Database Administrator with CPT to help with a large scale database migration task as well as extra task work as necessary. This particular person will be working closely with the majority of the DBA staff other Technology Services energy as well as likely software vendors. There might be some little...


  • Boston, United States Diverse Lynx Full time

    JD- • Looking for a strong ETL developer with hands-on experience in developing large scale Data engineering pipelines for financial services • Minimum 7 years of related experience in building and maintaining large scale Data warehouse applications in cloud • Minimum 3 years of experience in Talend ETL tool as a developer, developing complex ETL...


  • Boston, United States Motion Recruitment Full time

    Job Title: Principal Data Engineer Location: Downtown Boston, MA - You bus already live in Massachusetts no relocation is available  Company Overview: Join a prestigious asset management firm in the heart of Boston, boasting over $1 trillion in assets under management. Our firm is renowned for its innovative investment strategies and commitment to...


  • Boston, United States Fidelity Investments Full time

    Job Description: Position Description: ***Applicants are permitted to work from at-home worksite anywhere in the United States*** Provides end-to-end support of physical database design, deployment, data replication, performance tuning and security using Db2 on z/OS, Oracle, and Kafka. Deploys and maintains the database virtualization environment across the...

  • Senior BI Architect

    1 week ago


    Boston, United States American Technology Consulting LLC Full time

    Senior BI ArchitectBoston, MA (Hybrid)Contract Job Description: The Senior BI Architect will also research and recommend a new enterprise level BI tool, work with business teams to gain consensus on that tool and help train users on how to use it.ResponsibilitiesTo be considered for this position, the candidate must demonstrate specific experience in:Leading...