Postgress DB Developer

Job Title: PostgreSQL Database Developer

4-9 years

Job

We are seeking a skilled and experienced - PostgreSQL Database Developer with 3-5 years of experience to join our dynamic team. The ideal candidate will have extensive expertise in PostgreSQL development, database design, optimization, and performance tuning.

In this role, you will be responsible for designing, implementing, and maintaining robust database solutions, ensuring high performance, and collaborating with cross-functional teams to deliver reliable and scalable data solutions.

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 Optimization

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

1. Data Integration 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 workflows to improve efficiency.

1. Database Security 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 related to data security and privacy.

1. Automation Scripting

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

1. Collaboration Communication

Work closely with application developers, data engineers, and other stakeholders to support database-related requirements. Provide technical guidance and mentoring to team members. Communicate database status, performance updates, and recommendations to stakeholders.

1. Continuous Improvement

Stay updated with the latest PostgreSQL features, database technologies, and industry trends. Identify opportunities for process improvements and implement best practices. Participate in knowledge-sharing initiatives and contribute to the teams technical growth. Required

Bachelors degree in Computer Science, Information Technology, or a related field. 3-5 years of professional experience in PostgreSQL database development. Strong understanding of:

• Database design
• Performance tuning
• Query optimization

Advanced proficiency in SQL. Experience with:

• Database backup and recovery
• Disaster recovery planning

Knowledge of database security best practices and data protection regulations. Familiarity with cloud platforms such as:

• AWS
• Microsoft Azure
• Google Cloud Platform (GCP)

Strong scripting skills in Python, Bash, or PowerShell. Excellent analytical, problem-solving, and troubleshooting skills. Strong communication and interpersonal skills.

PostgreSQL Certified Professional or equivalent certification. Experience with other database management systems, including:

• MySQL
• Oracle
• Microsoft SQL Server
• Knowledge of containerization and orchestration technologies such as:
• Docker
• Kubernetes

Familiarity with DevOps practices and tools. Experience with data warehousing and big data technologies.