Job Title:  Deputy Manager | Postgress DB Developer | Gurgaon | TTC - DOMESTIC

Job Title: Deputy Manager - PostgreSQL DB Developer 

Location:  

Job Type: Full-time 

Experience Required: 7-10 years 

Job Summary: 

We are seeking a skilled and experienced Deputy Manager - PostgreSQL DB Developer with 7 to 10 years of experience to join our dynamic team. The ideal candidate will possess in-depth knowledge of PostgreSQL development, database design, and optimization. As a Deputy Manager, you will be responsible for designing, implementing, and maintaining robust database solutions, ensuring high performance, and collaborating with cross-functional teams to deliver high-quality data solutions. 

Key Responsibilities: 

1. Database Development: 

• Design, develop, and maintain PostgreSQL database schemas, tables, views, and stored procedures. 
• Write efficient and optimized SQL queries to support application requirements. 
• Develop and maintain database functions, triggers, and indexes to ensure data integrity and performance. 

1. Database Design and Optimization: 

• Collaborate with application developers to design scalable and efficient database structures. 
• Conduct database performance tuning and optimization to improve query execution times. 
• Implement indexing, partitioning, and other techniques to enhance database performance. 

1. Data Integration and ETL Processes: 

• Design and implement ETL processes to extract, transform, and load data from various sources. 
• Ensure data consistency, quality, and integrity throughout the data integration process. 
• Automate data loading and transformation processes to streamline workflows. 

1. Database Security and Compliance: 

• Implement and enforce database security policies and best practices to protect sensitive data. 
• Conduct regular security audits and vulnerability assessments. 
• Ensure compliance with industry standards and regulations for data security and privacy. 

1. Automation and Scripting: 

• Develop and maintain scripts and automation tools for database administration and development tasks. 
• Automate routine maintenance, monitoring, and alerting processes to improve efficiency. 
• Implement Infrastructure as Code (IaC) practices for database provisioning and management. 

1. Collaboration and Communication: 

• Work closely with application developers, data engineers, and other stakeholders to support database-related needs. 
• Provide technical guidance and support to team members and stakeholders. 
• Communicate effectively with team members and stakeholders, providing regular updates on database status and performance. 

1. Continuous Improvement: 

• Stay up-to-date with the latest trends and technologies in database development and PostgreSQL. 
• Identify opportunities for process improvement and implement best practices to enhance productivity and efficiency. 
• Participate in knowledge-sharing activities and contribute to the development of the team’s expertise. 

Qualifications: 

• Bachelor's degree in Computer Science, Information Technology, or a related field. 
• 4-6 years of professional experience in PostgreSQL database development. 
• Strong understanding of database design, optimization, and performance tuning. 
• Proficiency in SQL and experience with database query optimization. 
• Experience with database backup, recovery, and disaster recovery planning. 
• Knowledge of database security practices and data protection regulations. 
• Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and related services. 
• Strong scripting skills in languages such as Python, Bash, or PowerShell. 
• Excellent problem-solving skills and attention to detail. 
• Strong communication and interpersonal skills. 

Preferred Qualifications: 

• Relevant certifications (e.g., PostgreSQL Certified Professional). 
• Experience with other database management systems (e.g., MySQL, Oracle, SQL Server). 
• Knowledge of containerization and orchestration technologies (e.g., Docker, Kubernetes). 
• Familiarity with DevOps practices and tools. 
• Experience with data warehousing and big data technologies.