···
Log in / Register
Junior PostgreSQL DBA
$MXN 15,000-20,000/year
Indeed
Full-time
Onsite
No experience limit
No degree limit
Guanajuato 54, Roma Nte., Cuauhtémoc, 06700 Ciudad de México, CDMX, Mexico
Favourites
Share
Some content was automatically translatedView Original
Description

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

Source:  indeed View original post
Juan García
Indeed · HR

Company

Indeed
Juan García
Indeed · HR
Similar jobs

Cookie
Cookie Settings
Our Apps
Download
Download on the
APP Store
Download
Get it on
Google Play
© 2025 Servanan International Pte. Ltd.