We are looking for a skilled Database Engineer with a strong background in database management and optimization, particularly with PostgreSQL. The ideal candidate will have experience in database archival and data lifecycle design. In addition, experience in data warehousing and ETL is highly desirable. As a Database Engineer, you will play a crucial role in ensuring our data is efficiently managed, to optimize the performance of our digital products.
Responsibilities:
• Design, deploy, and maintain database systems, with a primary focus on PostgreSQL, to ensure optimal performance, reliability, and scalability.
• Implement database monitoring, alerting, and optimizations to improve system efficiency and response times.
• Develop strategies and procedures for data lifecycle management, and data retention policies to meet business requirements.
• Collaborate with cross-functional teams to understand data requirements and ensure database solutions align with the organization’s data strategy.
• Troubleshoot database-related issues, identify bottlenecks, and proactively implement solutions to enhance database performance.
• Implement and maintain security measures to protect sensitive data and ensure compliance with data protection regulations.
• Develop and maintain documentation related to database design, architecture, and best practices.
• Stay up-to-date with industry trends, tools, and best practices related to database management and data engineering.
• Maintains scalable data pipelines and builds out new API integrations to support continuing increases in data volume and complexity.
Qualifications:
• Bachelor’s Degree in Information Technology, or a related field.
• Proven experience as a Database Engineer, Database Administrator, or similar role with a focus on PostgreSQL optimization.
• In-depth knowledge of database design, administration, and performance tuning.
• Expert-level SQL skills, and familiarity with scripting languages.
• Experience with database archival and data lifecycle design.
• Strong problem-solving and troubleshooting skills.
• Excellent communication and teamwork skills.
• Understanding of data security and compliance with data protection regulations.
Nice-To-Have:
• Familiarity with modern data warehousing platforms such as Redshift, Snowflake, BigQuery.
• Data orchestration experience with tools such as Airflow, Prefect, or Dagster.
• Knowledge of data modeling within a data warehouse: dimensional, data vault, etc.
• Experience with data integration tools such as Airbyte, Stich, FiveTran, etc.
• Experience with Django / Python
