Postgres Developer - Udaipur/Hybrid Advaiya Solutions, Inc
Advaiya Solutions, Inc
Office Location
Full Time
Experience: 6 - 6 years required
Pay:
Salary Information not included
Type: Full Time
Location: Rajasthan
Skills: PostgreSQL, Data Modeling, Performance tuning, containerization, azure data factory, Azure Synapse Analytics, Schema Analysis, CICD implementation, SQL programming, Collaboration Skills
About Advaiya Solutions, Inc
Job Description
Location: Udaipur/Hybrid Key Responsibilities Database Development: Design, develop, and maintain PostgreSQL databases within Kubernetes and Dockerized environments. Data Pipeline Management: Implement and manage data pipelines using Azure Data Factory and Azure Synapse Analytics. Performance Optimization: Optimize and maintain stored procedures, functions, views, and indexes for efficient data access and performance. Data Modeling: Develop and document logical and physical data models including Star and Snowflake schemas for enterprise-scale solutions. Schema Analysis: Analyze existing schemas and create ER diagrams and technical documentation for future-state database designs. Collaboration: Collaborate with application developers and customer teams to understand data requirements and translate them into scalable database solutions. CI/CD Implementation: Implement CI/CD pipelines and manage infrastructure as code (IaC) to automate environment provisioning and deployment. Performance Tuning: Conduct performance tuning and apply best practices for database optimization and high availability. Requirements: Experience: 6-8 years of experience in database development with a strong focus on PostgreSQL. Enterprise Implementation: Proven experience working on enterprise-level implementations. Containerization: Hands-on experience with PostgreSQL in containerized environments (Kubernetes/Docker). Azure Services: Proficient in Azure services, especially Azure Synapse, Data Factory, and related data solutions. SQL Programming: Strong SQL programming skills with expertise in writing complex stored procedures and functions. Performance Tuning: Experience in database performance tuning, indexing strategies, and query optimization. CI/CD Tools: Understanding CI/CD tools and infrastructure automation using scripts or tools like Terraform, ARM templates, etc. Collaboration Skills: Ability to work collaboratively and independently, with strong problem-solving and communication skills.,