Tax Technology - Postgress DB Developer - TAX

Deloitte

4 - 6 years

Delhi

Posted: 9/9/2024

Job Description

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:

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.


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.


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.


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.


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.


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.


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

About Company

Deloitte is a global professional services firm that provides a wide range of services, including audit and assurance, consulting, tax, risk management, and financial advisory. With a presence in over 150 countries and a network of member firms, Deloitte serves clients across various industries, helping them solve complex business challenges, improve operations, and innovate. Known for its expertise in management consulting, technology solutions, and strategy, Deloitte is one of the Big Four accounting firms and is recognized for its commitment to quality, integrity, and making an impact in the marketplace.

Services you might be interested in

One-Shot Campaign

Reach out to ideal employees in one shot!

The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).