Database Engineer

ExcelsiorAlbany, NY
2d

About The Position

The Database Engineer will design, implement, and maintain robust database systems while actively supporting enterprise integration initiatives. This role bridges database administration and integration engineering, ensuring seamless data flow across platforms and applications. The ideal candidate combines strong database expertise with experience in integration technologies, ETL processes, and API-driven data exchange. Database Management Design, configure, and maintain relational databases (PostgreSQL, SQL Server, Oracle, MySQL). Perform performance tuning, optimization, backup, and recovery. o Implement security measures to meet compliance standards (FERPA, HIPAA, SOC 2). o Monitor database health and troubleshoot issues proactively. Integration Support Collaborate with the Integration team to develop and maintain data integration frameworks. Build and manage ETL pipelines for Change Data Capture (CDC) and incremental data loads. Support API-based integrations and middleware solutions for enterprise applications. Ensure interoperability between systems during migrations and upgrades. Automation & CI/CD Develop scripts and jobs to automate database operations and integration tasks. Participate in CI/CD pipeline development for database and integration deployments. Documentation & Collaboration Create and maintain technical documentation for database and integration processes. Work closely with developers, system architects, and business analysts to align solutions with organizational goals. Duties and Responsibilities: Database Management Design, configure, and maintain relational databases (PostgreSQL, SQL Server, Oracle, MySQL). Perform performance tuning, optimization, backup, and recovery. Implement security measures to meet compliance standards (FERPA, HIPAA, SOC 2). Monitor database health and troubleshoot issues proactively. Integration Support Collaborate with the Integration team to develop and maintain data integration frameworks. Build and manage ETL pipelines for Change Data Capture (CDC) and incremental data loads. Support API-based integrations and middleware solutions for enterprise applications. Ensure interoperability between systems during migrations and upgrades. Automation & CI/CD Develop scripts and jobs to automate database operations and integration tasks. Participate in CI/CD pipeline development for database and integration deployments. Documentation & Collaboration Create and maintain technical documentation for database and integration processes. Work closely with developers, system architects, and business analysts to align solutions with organizational goals. Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Bachelor’s degree in Computer Science, Information Technology, or related field. 3+ years of experience in database engineering or administration Hands-on experience with PostgreSQL and at least one other major RDBMS. Familiarity with integration tools (e.g., Boomi, Pentaho, Informatica, CData Sync, Striim Data Integration) and ETL concepts. Proficiency in SQL, scripting languages (Python, Shell), and source control (Git). Understanding of cloud platforms (AWS, Azure) and database migration strategies. Preferred Qualifications: Experience with CI/CD tools (Jenkins, GitLab CI). Knowledge of API development and RESTful services. Exposure to data warehousing and business intelligence environments. Strong analytical and problem-solving skills with attention to detail. The hiring salary range for this position is $100,00.00 - $113,000.00. The hiring salary range above represents the University's good faith estimate at the time of posting

Requirements

  • Bachelor’s degree in Computer Science, Information Technology, or related field.
  • 3+ years of experience in database engineering or administration
  • Hands-on experience with PostgreSQL and at least one other major RDBMS.
  • Familiarity with integration tools (e.g., Boomi, Pentaho, Informatica, CData Sync, Striim Data Integration) and ETL concepts.
  • Proficiency in SQL, scripting languages (Python, Shell), and source control (Git).
  • Understanding of cloud platforms (AWS, Azure) and database migration strategies.

Nice To Haves

  • Experience with CI/CD tools (Jenkins, GitLab CI).
  • Knowledge of API development and RESTful services.
  • Exposure to data warehousing and business intelligence environments.
  • Strong analytical and problem-solving skills with attention to detail.

Responsibilities

  • Database Management Design, configure, and maintain relational databases (PostgreSQL, SQL Server, Oracle, MySQL).
  • Perform performance tuning, optimization, backup, and recovery.
  • Implement security measures to meet compliance standards (FERPA, HIPAA, SOC 2).
  • Monitor database health and troubleshoot issues proactively.
  • Integration Support Collaborate with the Integration team to develop and maintain data integration frameworks.
  • Build and manage ETL pipelines for Change Data Capture (CDC) and incremental data loads.
  • Support API-based integrations and middleware solutions for enterprise applications.
  • Ensure interoperability between systems during migrations and upgrades.
  • Automation & CI/CD Develop scripts and jobs to automate database operations and integration tasks.
  • Participate in CI/CD pipeline development for database and integration deployments.
  • Create and maintain technical documentation for database and integration processes.
  • Work closely with developers, system architects, and business analysts to align solutions with organizational goals.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service