Jobs
>
Étreux

    Snowflake Database Administrator - Boston, United States - The Cranberry Country Chamber of Commerce

    The Cranberry Country Chamber of Commerce
    The Cranberry Country Chamber of Commerce Boston, United States

    2 weeks ago

    Default job background
    Description
    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.

    #J-18808-Ljbffr


  • BigRio Boston, United States

    Database Administrator · Location: Remote · Duration: 6+ Months · About BigRio: · is a technology consulting firm empowering data to drive innovation and advanced analytics. We specialize in cutting-edge Big Data, Machine Learning, and Custom Software strategy, analysis, archit ...


  • BigR Boston, United States

    Database Administrator · Location: Remote · Duration: 6+ Months · Skills, Experience, Qualifications, If you have the right match for this opportunity, then make sure to apply today. · About BigRio: · is a technology consulting firm empowering data to drive innovation and ...


  • Jobs for Humanity Boston, United States

    Company Description · Jobs for Humanity is collaborating with FIS Global to build an inclusive and just employment ecosystem. We support individuals coming from all walks of life. · Company Name: FIS Global · Job Description · Position Type : · Full time · Type Of Hire : ...


  • SeaHill Consulting Group Boston, United States

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


  • Saxon Global Boston, United States

    Company : UBS Financial Services Company · Title: SQL Database Administrator · Location :, Boston, MA Days onsite, 2 remote (Relocation) · Duration : 12+ month ongoing contract · Rate: $70/hr. on C2C · Visa: No H1 · Interview : 2 Rounds · Purpose of Role: · A professional ...


  • Harbourvest Boston, United States

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


  • Fidelity TalentSource LLC Boston, United States

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


  • Diverse Lynx Boston, United States

    Job Title: DBA (Database Administrator) · Location: Boston MA (Onsite) · Type : Full Time Employment · Job Description: · Responsibilities · Experience in Database Administrator (Oracle, Postgres & AWS Redshift). · Experience in Performance tuning. · Strong troubleshooting a ...


  • Fidelity Investments Boston, United States

    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, Or ...


  • FirstPRO Boston, United States

    6+ Months · Oracle and DBA Services (Logical and Physical DBA) - · Provide managed services to support our client's Oracle database environments. · Oracle database DBA support. · Maintenance and support of all Oracle environments: · Number of Databases: Approximately 10-12 Produc ...


  • FirstPRO Boston, United States

    6+ Months · Oracle and DBA Services (Logical and Physical DBA) - · Provide managed services to support our client's Oracle database environments. · Oracle database DBA support. · Maintenance and support of all Oracle environments: · Number of Databases: Approximately 10-12 Produc ...


  • Fidelity TalentSource LLC Boston, United States

    · 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, Ora ...


  • Fidelity Investments Boston, United States

    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, Ora ...


  • Fidelity TalentSource LLC Boston, United States

    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, Ora ...


  • Fidelity TalentSource LLC Boston, United States

    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, a ...


  • The Boston Beer Company Boston, United States

    Job Description · We are currently hiring a Sr. Database Administrator in Boston, MA (*Hybrid). · *A Hybrid position at Boston Beer requires that our coworkers reside within commuting distance to be onsite according to their teams' weekly schedule. · The primary purpose of the ...


  • firstPRO, Inc Boston, United States

    firstPRO is now accepting resumes for a Snowflake Database Administrator in Boston, MA. This is a 6+ month contract and onsite 4 days per week. · Knowledge, Skills and Education Required · Hands on experience with designing, implementing, and maintaining Snowflake, and fiveTran i ...


  • JobRialto Boston, United States

    Perform the tasks of migrating databases from a data center environment to AWS environments with SQL running on EC2. · Perform Database Administration for MS SQL Server and other database tools. · Troubleshoot and resolve database issues. · Tuning and Optimization using Native ...


  • firstPRO, Inc Boston, United States

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


  • The Cranberry Country Chamber of Commerce Boston, United States

    Oracle DBA/ Infrastructure Engineer · Chestnut Hill, MA (Hybrid) · 6+Month Contract · The role requires expertise in Oracle and SQL Server databases, as well as proficiency in infrastructure management and automation. · Responsibilities: · Manage Oracle RAC versions 12c and above ...