Database Administrator

4 weeks ago


Boston, United States SeaHill Consulting Group Full time

Job Description

A 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 working with relational databases, particularly SQL Server, Postgres, and MySQL, is essential. Familiarity with MongoDB or equivalent noSQL databases is highly desirable. The candidate must demonstrate expertise in cloud-based database technologies.

The ideal candidate should be adept at working within an Agile-based project management framework and possess experience in navigating a standard development pipeline. This includes proficiency in git version control, CI/CD tools, utilizing the VSCode IDE, and participating in dev/stage/prod stand-ups.

Responsibilities

Collaborate with a compact team of developers to conceptualize and develop both prototype and production-ready solutions that exhibit and fulfill the required functionality.

Design and implement efficient database structures to support organizational requirements.

Monitor and maintain database performance, ensuring optimal stability, security, and scalability.

Develop, implement and support backup and recovery strategies, safeguarding critical data assets.

Conduct regular database audits to identify potential issues and maintain data integrity.

Strong communication and collaboration skills: The database administrator should be able to effectively communicate with cross-functional teams, including developers, analysts, and business stakeholders. The candidate must be capable of understanding and translating business requirements into technical solutions and working collaboratively to support data-driven decision-making within the organization.

Perform database capacity planning and forecasting to support future growth and resource allocation.

Implement and maintain database security measures, including user access controls and data encryption.

Spearhead and contribute to all stages of the database implementation within projects, spanning from inception to deployment.

Troubleshoot and resolve database-related issues to minimize downtime and maintain system reliability.

Stay up-to-date with industry best practices and emerging technologies, continuously improving database management techniques.

Provide technical expertise and guidance to team members, fostering a culture of collaboration and knowledge sharing.

Design and implement solution architectures that cater to database-related technical needs of internal tools, leveraging AWS-RDS SQL Server as the primary cloud-based database.

Serve as the Technical Subject Matter Expert for database components of the solution, adapting to evolving business requirements concerning data acquisition from diverse sources, data normalization, aggregation through ETL scripting, and compatibility with BI reporting tools.

Utilize strong SQL skills and expertise in designing and optimizing data models, schemas, and table structures to support efficient querying and data analysis within the Snowflake and other database environment.

Preferred Experience and Attributes

Ability to work autonomously, proactively, and remotely within a cross-functional organization.

Exceptional written and verbal communication skills in English.

Comprehensive experience with database technologies and data modeling concepts, preferably involving leading Big Data Database & Analytics Vendors.

Cloud computing knowledge: Experience working with cloud platforms, such as AWS, Azure, or GCP, is required. The candidate should be comfortable with cloud-based services, storage, and data integration tools that interact with Snowflake.

Proficiency in Database Design Patterns, VS Code IDE, and database technologies is essential. Familiarity with MongoDB/noSQL databases is a plus.

Comprehensive experience with Snowflake Data Warehouse: The candidate must possess a deep understanding of Snowflake's architecture, data loading and unloading, performance tuning, and security features. Familiarity with Snowflake's unique features, such as Time Travel and Zero Copy Cloning, is essential.

The candidate must have experience in designing and implementing data pipelines, including extraction, transformation, and loading (ETL) processes. Familiarity with tools and technologies, such as Apache NiFi, Talend, Informatica, or Matillion, that integrate with Snowflake is highly desirable.

Expertise in complex data analysis, data migrations, system integration, and robust object-oriented programming skills.

Functional programming experience is considered an asset.

Familiarity with Agile working environments.

Management of personal knowledge base tools is advantageous.

Prior experience in a consultative role, handling intricate, customer-facing projects.

Adaptable to learning new technologies and programming languages as needed.

Capable of educating and training small groups.

Requirements

US Citizen

Minimum of 5+ years of experience designing and developing enterprise class application databases & applications.

Bachelor's Degree - ideally in computer science, engineering, or other STEM discipline.

#J-18808-Ljbffr



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


  • Boston, United States Saxon Global Full time

    Company : UBS Financial Services Company Title: SQL Database Administrator Location :, Boston, MA 02109 3 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 SQL Database Administrator (DBA) will keep the database up and running smoothly...


  • Boston, United States Fidelity TalentSource LLC 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...


  • Boston, United States Fidelity TalentSource LLC 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...


  • 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 Diverse Lynx Full time

    Role: Senior Oracle EBS Apps Database Administrator Location: Boston, MA (Onsite) Job Type: ContractRelevant Experience (in Yrs) 15 + yrs Technical/Functional Skills • Must have Oracle EBS R12.2.10 upgrade experience. • ble to troubleshoot the issues without any delays. Experience Required • Perform systems maintenance (Oracle RDMBS, Oracle...


  • Boston, United States FirstPRO Full time

    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 Production, 20 Test, 1 Sandbox. Database backup and recovery for Oracle databases using...

  • Database Engineer

    3 weeks ago


    Boston, United States Fidelity Investments Full time

    Job Description: The Team The team supports Fidelity Brokerage database platform. We handle enabling and onboarding of new applications to cloud based databases, end to end support including physical database design, deployment and data replication, Performance assessment, consultation and tuning and also control access to the database.. The Role The role...


  • Boston, United States The Cranberry Country Chamber of Commerce 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...


  • Boston, United States firstPRO, Inc Full time

    Long term contractOnsite in Boston 4 days per weekActivities 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 RequiredHands on experience with designing, implementing, and maintaining Snowflake, and...


  • Boston, United States firstPRO, Inc Full time

    Long term contractOnsite in Boston 4 days per weekActivities 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 RequiredHands on experience with designing, implementing, and maintaining Snowflake, and...


  • Boston, United States FirstPRO 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,...

  • ONLY W2

    1 day ago


    Boston, United States Yoh, A Day & Zimmermann Company Full time

    Important: Only looking for candidates who can work on W2 basis.If you have GC/US Citizen/EAD and only can work on C2C, please do not apply.If you have H1B and would need H1B transfer, please feel free to apply. We are open for H1B transfer candidates.Candidates need to be onsite in Boston, MA or Merrimack, NH or Smithfield, RI or Westlake, TX or Covington,...

  • ONLY W2

    1 day ago


    Boston, United States Yoh, A Day & Zimmermann Company Full time

    Important: Only looking for candidates who can work on W2 basis.If you have GC/US Citizen/EAD and only can work on C2C, please do not apply.If you have H1B and would need H1B transfer, please feel free to apply. We are open for H1B transfer candidates.Candidates need to be onsite in Boston, MA or Merrimack, NH or Smithfield, RI or Westlake, TX or Covington,...

  • ONLY W2

    2 days ago


    Boston, United States Yoh, A Day & Zimmermann Company Full time

    Important: Only looking for candidates who can work on W2 basis.If you have GC/US Citizen/EAD and only can work on C2C, please do not apply.If you have H1B and would need H1B transfer, please feel free to apply. We are open for H1B transfer candidates.Candidates need to be onsite in Boston, MA or Merrimack, NH or Smithfield, RI or Westlake, TX or Covington,...


  • Boston, United States Boston Pads LLC Full time

    Job DescriptionJob DescriptionCutting edge real estate platform is seeking a front desk/database manager to oversee and assist with technical/database training and orientation for new hires. MA Real Estate Salesperson or Broker License required.Responsibilities:- Assists in the management of landlord call center operations- Answer phone and update property...


  • Boston, United States SDL Search Partners Full time

    About the job Operations Administrator, Data Operations Administrator, Data A global consulting firm based in Boston is looking to add an Operations Administrator, Data to its team. This role will be part of a four-person team and report to a Manager who loves to mentor people. The ideal candidate has a strong skillset working with databases and Excel....


  • Boston, United States Inspire Brands Inc Full time

    The Franchise Administrator will manage full life-cycle contract maintenance processes for the administration of franchise related agreements, amendments, renewals, and terminations for Inspire Brands portfolio companies. Requires interaction and communication with brand franchisees, field and corporate staff, and Inspire and portfolio brand management to...