Database Developer - PostgreSQL

Database Developer - PostgreSQL

PostgreSQL Database Developer

Job Responsibilities

• Database Schema Management:

  You'll design, implement, and maintain database schemas in PostgreSQL, performing data modeling to ensure efficiency, reliability, and scalability.

• Performance Optimization:

  You'll optimize and tune SQL queries for improved performance, as well as identify and resolve performance bottlenecks in database systems.

• Data Migration & Integration:

  You'll manage data migration and integration processes between different systems, ensuring data consistency and integrity throughout the migration.

• Stored Procedures & Functions:

  You'll develop and maintain stored procedures, functions, and triggers to support application requirements, implementing business logic within the database layer.

• Database Security:

  You'll implement and maintain database security policies and manage user roles, permissions, and access control within the database.

• Backup & Recovery:

  You'll implement and oversee database backup and recovery processes, ensuring data availability and reliability.

• Cross-functional Collaboration:

  You'll collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements.

• Documentation:

  You'll create and maintain documentation related to database design, processes, and best practices.

Qualifications

• Education:

  Bachelor's degree in Computer Science, Information Technology, or a related field.

• PostgreSQL Expertise:

  Proven experience as a Database Developer with a focus on PostgreSQL.

• Database Design:

  In-depth knowledge of database design principles, normalization, and data modeling.

• SQL Proficiency:

  Strong proficiency in writing and optimizing SQL queries.

• Performance Tuning:

  Experience with performance tuning and query optimization techniques.

• Security Best Practices:

  Familiarity with database security best practices and access control.

• Data Migration:

  Hands-on experience with data migration, integration, and ETL processes.

• Scripting:

  Proficiency in scripting languages (e.g., Python, Bash) for automation tasks.

• Backup & Recovery Knowledge:

  Knowledge of backup and recovery processes.

• Communication:

  Excellent communication and collaboration skills.

• Teamwork:

  Ability to work independently and as part of a team.

Preferred Skills

• Experience with

  PostgreSQL replication and clustering

  .
• Familiarity with

  NoSQL databases

  .
• Knowledge of

  cloud database solutions

  (e.g., AWS RDS, Azure Database for PostgreSQL).
• Understanding of

  DevOps practices and tools

  .