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
