We are seeking a skilled Oracle PL/SQL Developer or PostgreSQL Database Developer to join our team. The ideal candidate will be responsible for designing, implementing, and maintaining PostgreSQL databases that support our applications and services. This role requires a deep understanding of database design, optimization, and administration, as well as the ability to collaborate with cross-functional teams to deliver high-quality solutions.
Key Responsibilities
Database Design and Development:
Design and develop PostgreSQL databases to meet application requirements.
Create and manage database objects such as tables, indexes, views, stored procedures, and triggers.
Performance Tuning and Optimization:
Analyze and optimize database performance using indexing, query optimization, and normalization techniques.
Troubleshoot and resolve database performance issues.
Data Management and Security:
Implement and maintain database backup and recovery solutions.
Ensure data integrity, security, and compliance with organizational and regulatory standards.
Collaboration and Support:
Work closely with software developers to design and optimize database queries and schemas.
Provide support and guidance on database usage and best practices.
Monitoring and Maintenance:
Monitor database health, capacity, and performance metrics.
Conduct regular maintenance tasks, such as patching and updates.
Automation and Scripting:
Develop and maintain automation scripts for database tasks using SQL and scripting languages (e.g., Python, Bash).
Requirements
Technical Skills:
Expertise in either PL/SQL or PostgreSQL database development, optimization, and administration.
Strong understanding of database design principles and best practices.
Proficiency in writing complex SQL queries, stored procedures, and functions.
Experience with PostgreSQL tools such as pgAdmin, psql, and extensions like PostGIS.
Familiarity with database replication, clustering, and failover techniques.
Knowledge of data modeling tools (e.g., ER/Studio, pgModeler).
Experience with cloud-based databases (e.g., AWS RDS,AuroraDatabase for PostgreSQL) is a plus.
Soft Skills:
Strong analytical and problem-solving abilities.
Excellent communication and teamwork skills.
Ability to manage multiple tasks and projects effectively.