Talent.com
PostgreSQL Database Developer

PostgreSQL Database Developer

ConfidentialMumbai
30+ days ago
Job description

PostgreSQL Database Developer

Our dynamic and growing company is actively seeking an experienced PostgreSQL Database Developer to join our team. As a PostgreSQL Database Developer, you will play a crucial role in designing, implementing, and maintaining our database systems. The ideal candidate should have a strong background in database development, performance optimization, and data modeling.

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.

    • Skills Required

    Database Development, Postgresql, Sql, Data Migration, Scripting Languages, Data Modeling

    Create a job alert for this search

    Database Developer • Mumbai