PostgreSQL / Database Developer

JOB DESCRIPTIONS / RESPONSIBILITIES

• Design, develop, and maintain PostgreSQL database objects for the HR platform.
• Develop tables, views, functions, stored procedures, queries, and database scripts.
• Translate application and data requirements into optimized database structures.
• Optimize SQL queries, indexes, database performance, and data-access patterns.
• Support data integrity, transaction management, database security, and standards.
• Support backend, ETL, reporting, and integration teams with database requirements.
• Analyze and resolve database performance issues and defects.
• Support database migration, deployment, versioning, backup, and recovery activities.

QUALIFICATIONS

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 3-4 years of database development experience, preferably with PostgreSQL.
• Strong SQL, relational database design, normalization, and data-modeling skills.
• Experience with PostgreSQL functions, procedures, views, indexes, and complex queries.
• Good understanding of query optimization and performance tuning.
• Understanding of transactions, locking, concurrency, security, and data integrity.
• Familiarity with database migration/versioning, Git, and CI/CD is preferable.
• Strong analytical, troubleshooting, collaboration, documentation, and English skills.