Job Title:  Tax Technology - Postgress DB Developer - TAX

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 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.