Database Developer - PostgreSQL

Job Title : Deputy Manager - PostgreSQL DB Developer Location : Job Type : Full-time Experience Required : 4-6 years Job Summary : We are seeking a skilled and experienced Deputy Manager - PostgreSQL DB Developer with 4 to 6 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. 2. 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. 3. 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. 4. 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. 5. 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. 6. 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. 7. 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 teams : - 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. (ref:hirist.tech)

Location: chennai, IN

Posted Date: 11/24/2024