{"schemaVersion":"jobsearcher.job.v1","id":"2d2b3c3b34ec754b6c5ebc69","url":"https://jobsearcher.com/jobs/2d2b3c3b34ec754b6c5ebc69","canonicalUrl":"https://jobsearcher.com/jobs/2d2b3c3b34ec754b6c5ebc69","title":"Senior Database Engineer","description":"Senior Database Engineer (PostgreSQL Focus) The Space Telescope Science Institute (STScI), operated by the Association of Universities for Research in Astronomy (AURA), is NASA's science operations center for missions including the Hubble Space Telescope and the James Webb Space Telescope.We are seeking a hands-on Senior Database Engineer with deep expertise in PostgreSQL to help design, build, and maintain performant databases. You will work as part of a team supporting reliable, high-performance data flow for analytics, reporting, and science applications using Python and Apache Airflow. Some experience with AWS is required to efficiently support our growing data volumes.This role will also involve working with others to optimize our Massively Parallel Processing (MPP) database system and help deliver fast, reliable data access for the Mikulski Archive for Space Telescopes (MAST) - one of the world's most advanced public astronomical data archives.This position supports hybrid work (approximately twice per quarter on site). Candidates must reside in or be willing to relocate to our local market (MD, DE, VA, PA, DC, or WV). U.S. Citizenship or Permanent Residence is required to meet ITAR requirements.This is a technical individual contributor role, with opportunities to mentor junior database engineers and contribute to ongoing improvements of the data platform.Key ResponsibilitiesAct as the PostgreSQL subject matter expert: design efficient database schemas, optimize complex queries, implement advanced indexing strategies, and lead performance tuning, replication, partitioning, and high availability solutionsDesign, develop, optimize, and maintain data pipelines using Apache Airflow for orchestration and schedulingWork with AWS services to deploy and scale cloud-based data infrastructureParticipate in documentation, write clean and maintainable code, and engage in code reviewsMentor junior data engineers on best practices for PostgreSQL, Python, and AirflowRequired QualificationsStrong PostgreSQL experience, including schema design, partitioning, advanced SQL, query optimization, indexing, vacuuming, and EXPLAIN analysisStrong Python skills, with experience writing production-grade scripts for data processing and automation; familiarity with libraries such as pandas, SQLAlchemy, and psycopg2Apache Airflow experience in production environments, including DAG development, scheduling, operators, sensors, and dependency managementBachelor's or Master's degree in Computer Science, Computer Engineering, Information Technology, or a related field8+ years of professional experience in Linux-based environments, with deep expertise in data engineering, data management, and scalable distributed data architecturesOur excellent benefits include:Employer retirement contribution – direct STScI contribution of 10% of your salary from your first day12 days sick leave, up to 24 days' vacation, and 10 paid holidaysFlexible work schedule with healthy work/life balanceComprehensive medical/dental/vision/prescription plans, and more!Salary range is $135,000 - $150,000. Final compensation is based on experience, skills, internal equity, and market conditions.","company":"Stsci","rawCompany":"stsci","city":"Baltimore","state":"MD","isRemote":false,"isActive":false,"createdAt":"2026-08-06T23:45:10.232Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Database Engineer","description":"Senior Database Engineer (PostgreSQL Focus) The Space Telescope Science Institute (STScI), operated by the Association of Universities for Research in Astronomy (AURA), is NASA's science operations center for missions including the Hubble Space Telescope and the James Webb Space Telescope.We are seeking a hands-on Senior Database Engineer with deep expertise in PostgreSQL to help design, build, and maintain performant databases. You will work as part of a team supporting reliable, high-performance data flow for analytics, reporting, and science applications using Python and Apache Airflow. Some experience with AWS is required to efficiently support our growing data volumes.This role will also involve working with others to optimize our Massively Parallel Processing (MPP) database system and help deliver fast, reliable data access for the Mikulski Archive for Space Telescopes (MAST) - one of the world's most advanced public astronomical data archives.This position supports hybrid work (approximately twice per quarter on site). Candidates must reside in or be willing to relocate to our local market (MD, DE, VA, PA, DC, or WV). U.S. Citizenship or Permanent Residence is required to meet ITAR requirements.This is a technical individual contributor role, with opportunities to mentor junior database engineers and contribute to ongoing improvements of the data platform.Key ResponsibilitiesAct as the PostgreSQL subject matter expert: design efficient database schemas, optimize complex queries, implement advanced indexing strategies, and lead performance tuning, replication, partitioning, and high availability solutionsDesign, develop, optimize, and maintain data pipelines using Apache Airflow for orchestration and schedulingWork with AWS services to deploy and scale cloud-based data infrastructureParticipate in documentation, write clean and maintainable code, and engage in code reviewsMentor junior data engineers on best practices for PostgreSQL, Python, and AirflowRequired QualificationsStrong PostgreSQL experience, including schema design, partitioning, advanced SQL, query optimization, indexing, vacuuming, and EXPLAIN analysisStrong Python skills, with experience writing production-grade scripts for data processing and automation; familiarity with libraries such as pandas, SQLAlchemy, and psycopg2Apache Airflow experience in production environments, including DAG development, scheduling, operators, sensors, and dependency managementBachelor's or Master's degree in Computer Science, Computer Engineering, Information Technology, or a related field8+ years of professional experience in Linux-based environments, with deep expertise in data engineering, data management, and scalable distributed data architecturesOur excellent benefits include:Employer retirement contribution – direct STScI contribution of 10% of your salary from your first day12 days sick leave, up to 24 days' vacation, and 10 paid holidaysFlexible work schedule with healthy work/life balanceComprehensive medical/dental/vision/prescription plans, and more!Salary range is $135,000 - $150,000. Final compensation is based on experience, skills, internal equity, and market conditions.","datePosted":"2026-08-06T23:45:10.232Z","dateModified":"2026-08-06T23:45:10.232Z","hiringOrganization":{"@type":"Organization","name":"Stsci","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Baltimore","addressRegion":"MD","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"2d2b3c3b34ec754b6c5ebc69"},"url":"https://jobsearcher.com/jobs/2d2b3c3b34ec754b6c5ebc69"}}