Database Solutions Architect

We are seeking an experienced Database Solutions Architect to join our team at Impyrian. As a key member of our engineering team, you will be responsible for designing and implementing scalable data infrastructure solutions that meet the evolving needs of our business.

The Senior Database Engineer will play a critical role in architecting and optimizing data infrastructures while leading data engineering projects, mentoring junior engineers, and enhancing our ability to meet 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.

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

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

Estimated Salary: $120,000 - $180,000 per year.

This position is located in Northern Virginia / Remote. We offer a comprehensive benefits package, including competitive salary, dental, medical, PTO, disability, paid family leave, and 401(k) with matching.

Impyrian is an equal employment opportunity employer. We value diversity and encourage all qualified candidates, including minorities, females, veterans, and individuals with disabilities, to apply.