Postgres Developer - Udaipur/Hybrid Advaiya Solutions, Inc

  • company name Advaiya Solutions, Inc
  • working location Office Location
  • job type 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.,