Senior PostgreSQL and Snowflake Developer
Job Summary
Job Description
- 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
- MySQL, Oracle, MongoDB experience
- PostgreSQL, Snowflake, cloud platform certifications
- Data science/machine learning experience
12 skills required
Job Details
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
Similar Jobs
![BBY India - Senior Software Engineer [T500-14567]](/_next/image?url=https%3A%2F%2Foutscal-lms-data.s3.ap-south-1.amazonaws.com%2Fcompany-image%2Fproduction%2Fbby-india%2Fbby-india_logo_10_06_2024__10_30_51.jpg&w=256&q=50){kind=logo}
ByteDance
Nielsen Holdings
Rackspace Technology
PwC
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
PwC
PlayStation Global
WESURE INSURTECH SERVICES (INDIA) PRIVATE LIMITED
CharacterAI
Get notifed when new similar jobs are uploaded
Jobs in Chennai, Tamil Nadu, India
PwC
Warner Bros Games
Ishan Technologies
Get notifed when new similar jobs are uploaded
DevOps Jobs
Luxoft
Ubisoft
Wargaming
Get notifed when new similar jobs are uploaded
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.
Get notified when new jobs are added by Luxoft
