Senior PostgreSQL and Snowflake Developer

2 Weeks ago • 9-12 Years • DevOps

About the job

Summary

This senior-level role requires 9-12 years of experience in PostgreSQL and Snowflake database design, development, performance tuning, and cloud-based data warehousing. Responsibilities include database architecture and design, development and optimization of complex queries, data integration using ETL pipelines, performance tuning, ensuring data security and compliance, leveraging cloud platforms (AWS, Azure, GCP), automation and monitoring, collaboration with cross-functional teams, mentoring junior engineers, and maintaining comprehensive documentation. The ideal candidate will possess in-depth knowledge of PostgreSQL and Snowflake, strong SQL and PL/pgSQL skills, and experience with cloud platforms and data integration tools.
Must have:
  • 9-12 years PostgreSQL & Snowflake experience
  • Data modeling, query optimization, database administration
  • Schema design, indexing, replication strategies (PostgreSQL)
  • Cloud deployment, data warehousing, performance tuning (Snowflake)
  • SQL & PL/pgSQL proficiency
  • Cloud platforms (AWS, GCP, Azure) & data integration tools
  • ETL processes, data migration, real-time data streaming
  • DevOps, CI/CD pipelines
  • Performance issue diagnosis and resolution
  • Data privacy, security protocols, compliance (GDPR, SOC 2)
  • Communication & leadership skills, mentoring
Good to have:
  • MySQL, Oracle, MongoDB experience
  • PostgreSQL, Snowflake, cloud platform certifications
  • Data science/machine learning experience
Not hearing back from companies?
Unlock the secrets to a successful job application and accelerate your journey to your next opportunity.
Project description

We are seeking an experienced and highly skilled Senior PostgreSQL and Snowflake Engineer to join our dynamic team. The ideal candidate will have 9-12 years of hands-on experience in database design, development, performance tuning, and cloud-based data warehousing solutions. You will play a key role in architecting, developing, and optimizing our PostgreSQL and Snowflake environments to support mission-critical data applications.

Responsibilities

Database Architecture & Design: Lead the design and implementation of scalable and efficient PostgreSQL and Snowflake database architectures.

Database Development: Develop and optimize complex queries, stored procedures, and functions for PostgreSQL and Snowflake platforms.

Data Integration: Design and implement ETL pipelines to move data between PostgreSQL, Snowflake, and other systems using modern data engineering tools (e.g., AWS Glue, Apache Airflow).

Performance Tuning: Conduct performance analysis and optimization of databases, including indexing, partitioning, query tuning, and load balancing.

Data Security & Compliance: Ensure data security and privacy in PostgreSQL and Snowflake environments, adhering to company and regulatory standards (e.g., GDPR, SOC 2).

Cloud Expertise: Leverage cloud platforms (AWS, Azure, GCP) to enhance the scalability and performance of database systems, with a focus on Snowflake's cloud-native architecture.

Automation & Monitoring: Automate database processes, implement monitoring solutions, and handle troubleshooting to maintain high availability.

Collaboration & Leadership: Work closely with cross-functional teams including data scientists, software engineers, and product managers to design data solutions that support business goals. Mentor junior engineers in PostgreSQL and Snowflake best practices.

Documentation & Best Practices: Maintain comprehensive documentation for all database-related projects, promoting best practices in database development and management.

Skills

Must have

Experience: 9-12 years of hands-on experience with PostgreSQL and Snowflake, including data modeling, query optimization, and database administration.

In-depth knowledge of PostgreSQL, including schema design, indexing, and replication strategies.

Expertise in Snowflake, including cloud deployment, data warehousing concepts, and performance tuning.

Strong proficiency in SQL and PL/pgSQL programming.

Experience with cloud platforms (AWS, GCP, Azure) and data integration tools (AWS Glue, Apache Airflow).

Experience in ETL processes, data migration, and real-time data streaming technologies.

Familiarity with DevOps practices and CI/CD pipelines.

Analytical & Problem-Solving Skills: Proven ability to diagnose and resolve performance issues in large-scale database environments.

Security & Compliance: Understanding of data privacy, security protocols, and compliance requirements (e.g., GDPR, SOC 2).

Soft Skills: Strong communication and leadership skills with a proven track record of mentoring and leading technical teams.

Nice to have

Experience with additional database systems like MySQL, Oracle, or MongoDB.

Certifications in PostgreSQL, Snowflake, or cloud platforms like AWS, GCP, or Azure.

Exposure to data science or machine learning projects involving big data.

Other

Languages

English: B2 Upper Intermediate

Seniority

Senior

View Full Job Description

About The Company

Luxoft, a DXC Technology Company (NYSE: DXC), is a digital strategy and software engineering firm providing bespoke technology solutions that drive business change for customers the world over. Acquired by U.S. company DXC Technology in 2019, Luxoft is a global operation in 44 cities and 21 countries with an international, agile workforce of nearly 18,000 people. It combines a unique blend of engineering excellence and deep industry expertise, helping over 425 global clients innovate in the areas of automotive, financial services, travel and hospitality, healthcare, life sciences, media and telecommunications.

DXC Technology is a leading Fortune 500 IT services company which helps global companies run their mission critical systems. Together, DXC and Luxoft offer a differentiated customer-value proposition for digital transformation by combining Luxoft’s front-end digital capabilities with DXC’s expertise in IT modernization and integration. Follow our profile for regular updates and insights into technology and business needs.

View All Jobs

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug