Luxoftis a trusted partner for the design and delivery of effective, scalable, outcome-based software solutions for mission-critical processes. Drawing on our extended partnership ecosystem and broad domain knowledge, we drive technology performance, operational efficiency, and continuous innovation in multiple industries.
Languages Seniority BCM Industry
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 Snowflakes 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
English: B2 Upper Intermediate
Senior
Refer a Friend
Positive work environments and stellar reputations
attract and retain top talent. Find out why Luxoft
stands apart from the rest.
Recommend a friend
Related jobs
View all vacancies
Solutions Architect
Data Architecture
India
Bengaluru
Data Architect
Data Architecture
Canada
Toronto
Gurgaon, India
Req. VR-108851
Data Architecture
26/11/2024
Req. VR-108851
Apply for Senior PostgreSQL and Snowflake Developer in Gurgaon
*
NA
Similar jobs
Role & responsibilities: NA NA NA NA Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people... Expand NA
... Expand
About The Role :
Minimum 8 Years of exp as a Pega BA
Must be CPBA Certfified and had work exp on .X, 8,x... Expand