Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

Senior PostgreSQL and Snowflake Developer

Karnataka, India (On-site)

Senior PostgreSQL and Snowflake Developer

1 Month ago • 9-12 Years • DevOps

About the job

12 skills required for this role

Add these skills to join the top 1% applicants for this job

ci-cd

mongodb

azure

load-balancing

aws

sql

data-science

mysql

postgresql

scalability

oracle

cross-functional

Job Description

This Senior PostgreSQL and Snowflake Developer role requires 9-12 years of experience in database design, development, performance tuning, and cloud-based data warehousing. Responsibilities include database architecture and design, development and optimization of queries and stored procedures, data integration using tools like AWS Glue and Apache Airflow, performance tuning, ensuring data security and compliance, leveraging cloud platforms (AWS, Azure, GCP), automating database processes, and collaborating with cross-functional teams. The ideal candidate will have expertise in PostgreSQL and Snowflake, strong SQL and PL/pgSQL skills, and experience with ETL processes and real-time data streaming. Mentoring junior engineers is also a key responsibility.

Must have:

9-12 years PostgreSQL & Snowflake experience
Data modeling, query optimization
Database administration
SQL & PL/pgSQL proficiency
Cloud platform experience (AWS, GCP, Azure)
ETL processes and data streaming
DevOps & CI/CD familiarity
Data security & compliance

Good to have:

Experience with MySQL, Oracle, MongoDB
PostgreSQL, Snowflake, cloud certifications
Data science/machine learning experience

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

Upload your resume, increase your shortlisting chances by 80%

About The Company

Luxoft

1110 Active Jobs

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.