remote
Senior Database Engineer - IRTH SOLUTIONS
Software Engineer
Senior Database Engineer responsible for designing, implementing, and optimizing high‑performance relational and cloud databases, ensuring data integrity and scalability for enterprise SaaS platforms.
About the role
Key Responsibilities
- Design and architect robust relational database solutions, primarily PostgreSQL, to support mission‑critical SaaS applications.
- Develop, maintain, and optimize complex SQL queries, stored procedures, and data pipelines for high‑volume data ingestion and analytics.
- Implement ETL processes and data integration workflows, ensuring data quality, consistency, and timely availability across environments.
- Collaborate with software engineers, data scientists, and product teams to define data models that meet functional and performance requirements.
- Manage database performance tuning, capacity planning, backup/recovery strategies, and security compliance in cloud environments (AWS).
Requirements
- 5+ years of hands‑on experience with PostgreSQL or comparable relational databases, including schema design and query optimization.
- Strong proficiency in SQL and experience building/maintaining ETL pipelines.
- Solid understanding of cloud infrastructure (AWS) and related services such as RDS, Aurora, and IAM.
- Experience with data modeling, indexing strategies, and performance tuning for large‑scale, high‑throughput systems.
- Excellent problem‑solving skills and ability to work cross‑functionally in an agile development environment.