Job Description

Key Responsibilities: Database Design and Development: Design, implement, and manage complex PostgreSQL databases. Develop, test, and optimize stored procedures, functions, and triggers. Create and maintain data models and database schemas. Cron JOBS Database Management: Perform routine database maintenance, including backups, restores, and disaster recovery. Ensure database security, performance tuning, and optimization. Monitor database health and troubleshoot performance issues. Data Manipulation: Develop and optimize SQL queries for data retrieval, insertion, and updates. Implement data migration and transformation tasks. Ensure data integrity and consistency. Collaboration and Support: Work closely with application developers to optimize database performance. Provide database support and troubleshooting for development and production environments. Mentor and guide junior database developers and administrators. Required Skills and Experience: 2+ years of experience working with PostgreSQL databases. Proficiency in writing and optimizing complex SQL queries, stored procedures, functions, and triggers. Extensive experience with database updates, inserts, and data manipulation. Proven experience managing and optimizing large-scale databases. Strong understanding of database design principles and data modeling. Experience with database performance tuning and optimization. Familiarity with database backup, recovery, and security practices. Excellent problem-solving and analytical skills. Strong communication and teamwork skills. Preferred Qualifications: Knowledge of database replication and clustering. Experience with cloud-based database services (e.g., AWS RDS, Azure Database for PostgreSQL). Familiarity with DevOps practices and tools