PostgreSQL Database Developer

PostgreSQL Database Developer

PostgreSQL Database Developer

Key Responsibilities

• Database schema design, implementation, and maintenance

  will be performed in PostgreSQL, along with data modeling to ensure efficiency, reliability, and scalability.

• SQL query optimization and tuning

  for improved performance are essential, including identifying and resolving performance bottlenecks in database systems.

• Data migration and integration processes

  between different systems will be managed, ensuring data consistency and integrity during migration.

• Stored procedures, functions, and triggers

  will be developed and maintained to support application requirements and implement business logic within the database layer.

• Database security policies

  will be implemented and maintained, managing user roles, permissions, and access control within the database.

• Database backup and recovery processes

  will be implemented and overseen to ensure data availability and reliability.

• Collaboration with cross-functional teams

  , including application developers, system administrators, and business analysts, is crucial for understanding database requirements.

• Documentation creation and maintenance

  related to database design, processes, and best practices are required.

Technical Skill Requirements

• Proven experience as a

  Database Developer with a focus on PostgreSQL

  is mandatory.
• In-depth knowledge of

  database design principles, normalization, and data modeling

  is essential.
• Strong proficiency in writing and optimizing

  SQL queries

  is required.
• Experience with

  performance tuning and query optimization techniques

  is a must.
• Familiarity with

  database security best practices and access control

  is necessary.
• Hands-on experience with

  data migration, integration, and ETL processes

  is essential.
• Proficiency in

  scripting languages

  (e.g., Python, Bash) for automation tasks is required.
• Knowledge of

  backup and recovery processes

  is necessary.
• Excellent

  communication and collaboration skills

  are vital.
• Ability to

  work independently and as part of a team

  is expected.

Education

• A

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

  is required.
• Any Graduate degree is acceptable.

General Requirements

• Employment Type:

  Permanent, full-time position.

Preferred Skills

• Experience with

  PostgreSQL replication and clustering

  is a plus.
• Familiarity with

  NoSQL databases

  is beneficial.
• Knowledge of

  cloud database solutions

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

  DevOps practices and tools

  is preferred.