




Job Summary: We are seeking a professional with a solid foundation in relational concepts and experience in PostgreSQL database administration, operational maintenance, and security, with an emphasis on problem-solving and teamwork. Key Highlights: 1. PostgreSQL database administration experience 2. Focus on operational maintenance and security 3. Problem-solving skills and teamwork TECHNICAL KNOWLEDGE \-\> Solid understanding of relational concepts, installation, basic configuration, user administration, backups, and fundamental SQL knowledge. \-\> Focus on operational maintenance and security. \-\> Installation and Configuration: Knowledge of installing PostgreSQL on Linux and Windows operating systems. \-\> Configuration File Administration: Understanding and editing postgresql.conf (memory and connection parameters) and pg\_hba.conf (authentication and access control). \-\> Security and Users: Creation and management of roles/users, assignment of permissions (GRANT/REVOKE), and schemas. \-\> Backup and Recovery (Backup/Restore): Use of basic tools such as pg\_dump, pg\_dumpall, and pg\_restore for logical backups. \-\> Basic Monitoring: Monitoring disk space, CPU/memory usage, and service status (start, stop, restart). \-\> Intermediate SQL: Handling complex queries, JOINs, subqueries, views, and basic functions. \-\> Normalization: Understanding relational database design. \-\> Transactions: Management of COMMIT and ROLLBACK. \-\> Linux/Unix: Basic command-line knowledge (Bash), file and permission administration in Linux, where PostgreSQL commonly runs. \-\> Client Tools: Proficiency with psql (terminal) and graphical tools such as pgAdmin. OTHER SKILLS \-\> Problem Solving: Ability to identify root causes of connection errors or slow queries. \-\> Teamwork and Communication: Collaboration with developers to optimize queries. \-\> Documentation: Recording configuration changes and security procedures. Employment Type: Full-time, Project-based or Fixed-term Contract Duration: 6 months Salary: $15,000\.00 \- $20,000\.00 per month Benefits: * Salary increases * Maternity leave exceeding statutory requirements * Paternity leave exceeding statutory requirements * Company parking Education: * Completed Bachelor's degree (Preferred) Work Location: On-site


