Senior Database Engineer

Impyrian; New York (NY); Remote; USD 90,000 - 150,000; Full time

Job summary

Join a forward-thinking company as a Senior Database Engineer, where you'll architect and optimize data infrastructures using cutting-edge technologies like Oracle, PostgreSQL, and Databricks. This exciting role involves leading data engineering projects, mentoring junior engineers, and collaborating with cross-functional teams to deliver impactful solutions. You'll play a crucial part in enhancing business operations while ensuring data security and compliance. If you're passionate about data and eager to make a difference, this is the perfect opportunity for you to thrive in a dynamic environment.

Benefits

Comprehensive benefits package

401(k) with matching

Paid family leave

Dental and medical insurance

PTO

Disability insurance

Qualifications

• 7+ years in database engineering with expertise in Oracle and PostgreSQL.
• Advanced proficiency in Databricks for big data processing.
• Strong knowledge of data warehousing principles.

Responsibilities

• Architect and manage complex Oracle and PostgreSQL databases.
• Lead the development of ETL workflows using Informatica.
• Spearhead Databricks initiatives for big data processing.

Skills

Oracle

PostgreSQL

Databricks

Informatica

SQL

PL/SQL

Data Modeling

Data Warehousing

Performance Tuning

Mentoring

Education

Bachelor's degree in Computer Science

Master's degree in Computer Science

Tools

Databricks

Informatica

AWS

Azure

Google Cloud

Job description

CORPORATE OVERVIEW
At Impyrian, our commitment to excellence, client-centric approach, and deep industry expertise set us apart. We strive to be a trusted partner for organizations seeking to embrace digital transformation, bolster cybersecurity, streamline operations, leverage advanced audio-visual technologies, drive successful engineering and construction projects, and harness the power of AI and robotics to stay ahead in today's dynamic business landscape.

Impyrian knows the most important factor in our success is the excellence of our people. We recognize a simple truth: if we take care of our people, our people take care of our clients. This philosophy ensures a work-life balance, competitive compensation and benefits, and opportunities for professional growth, driving our high personnel retention rate.

POSITION SUMMARY
We are looking for a skilled and motivated Senior Database Engineer to join our dynamic team. In this role, you will architect and optimize data infrastructures while leading data engineering projects, mentoring junior engineers, and enhancing our ability to meet evolving business demands. This is a unique opportunity to work with cutting-edge technologies, including Oracle, PostgreSQL, Databricks, and Informatica, while collaborating with cross-functional teams to deliver impactful solutions.

Location: Northern Virginia / Remote

Clearance Requirement:

Must be able to obtain and maintain a Public Trust Level 5 Equivalent Clearance issued by CBP.

US citizenship is required to meet this requirement.

Candidates with current US government-issued clearances are strongly encouraged to apply.

Position Type: Full-Time W-2

RESPONSIBILITIES

• Database Architecture & Development

  • Architect and manage complex Oracle and PostgreSQL databases to support core applications and analytics.
  • Design and optimize database structures for peak performance and scalability.
  • Implement advanced data modeling (conceptual, logical, physical).

• Data Integration & ETL Leadership

  • Lead the development and maintenance of ETL workflows using Informatica.
  • Define best practices for ETL, including data cleansing and quality control.
  • Mentor junior engineers in data integration methods.

• Big Data & Cloud Platform Expertise

  • Spearhead Databricks initiatives for big data processing and preparation.
  • Architect integrations between Databricks, Oracle, and PostgreSQL.
  • Collaborate with architects and engineers on cloud-based data solutions.

• Performance Tuning & Optimization

  • Monitor and optimize database performance, including SQL tuning and indexing.
  • Develop strategies for scalability, capacity planning, and high availability.
  • Maintain data security, backup plans, and compliance standards.

• Leadership & Collaboration

  • Engage with teams to understand data requirements and develop aligned solutions.
  • Document data flows, ETL processes, and designs for transparency.
  • Mentor and guide junior team members, fostering collaboration.

REQUIREMENTS

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field; Master's degree preferred.
• Experience: Minimum of 7 years in database engineering with expertise in Oracle and PostgreSQL.
• Technical Skills:
  • Advanced proficiency in Databricks for big data processing.
  • Strong knowledge of data warehousing principles and data modeling best practices.
  • Proficiency in SQL and PL/SQL with expertise in performance tuning.
  • Experience leading cross-functional data engineering projects.
  • Strong problem-solving, collaboration, and mentoring abilities.

Preferred Qualifications:

• Active DHS Public Trust clearance strongly preferred.
• Expertise in Informatica for ETL and data integration.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Certifications in Oracle, PostgreSQL, Informatica, or Databricks.

PHYSICAL REQUIREMENTS

• Prolonged periods of sitting or standing while working on a computer.
• Ability to participate in video/phone conferences and meetings.
• Manual dexterity for operating standard office equipment.
• Ability to manage multiple tasks in a fast-paced environment.

TRAVEL
Occasional local travel within the DC Metro area may be required.

COMPENSATION & BENEFITS

• Competitive salary based on experience.
• Comprehensive benefits package including dental, medical, PTO, disability, paid family leave, and 401(k) with matching.

EQUAL EMPLOYMENT OPPORTUNITY
Impyrian is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity and Affirmative Action employer and will consider all qualified applicants for employment without regard to race, color, religion, gender, pregnancy, sex, sexual orientation, gender identity, national origin, age, genetic information, protected veteran status, disability, or any other basis protected by local, state, or federal law. Individuals able to obtain and maintain U.S. government security clearances may be required for certain positions.