Skills & Experience**:Roles and Responsibilities**:
- Manage, optimize, and maintain large **on-premise** **PostgreSQL** deployments to ensure high availability, performance, and reliability.
- Implement montironing metrics and thresholds to ensure database management, performance optimization, and proactive maintenance.
- Lead initiatives to redesign the PostgreSQL database platform with a focus on increasing automation, reliability, and efficiency.
- Develop and implement advanced monitoring and logging strategies to enhance visibility, proactively identify potential issues, and resolve them before they impact operations.
- Utilize configuration management tools (e.g., SaltStack, Ansible, Puppet) and infrastructure as code frameworks (e.g., Terraform, CloudFormation) to automate database infrastructure tasks and ensure consistency.
- Utilize Terraform to define, deploy and manage databases in an on-premise environment which is a private cloud.
- Perform system-level troubleshooting using Linux command line tools to diagnose and resolve system issues efficiently.
- Continuously identify opportunities for process improvements and contribute to the ongoing enhancement of the database infrastructure.
**Job Requirements**:
- 5+ years of experience in Database Administration, Bachelor’s degree in Computer Science, Software Engineering, or a related field.
- Extensive experience managing and supporting large-scale, on-premise PostgreSQL environments, including performance tuning, optimization, and replication, backup, and recovery solutions.
- Strong understanding of data modeling and database schema design principles.
- Demonstrated passion for automation with experience in or willingness to learn configuration management and infrastructure as code practices.
- Proficiency with the Linux command line for system administration and troubleshooting.
- Proven ability to work effectively in a team environment, sharing knowledge and contributing to the success of the team.
- Excellent problem-solving skills with a proactive mindset and the ability to think critically under pressure.
- Experience with scripting languages (e.g., Python, Bash) for automation and tooling is preferred.
- Experience with infrastructure as code frameworks (e.g., Terraform, CloudFormation) is highly desirable.
**What We Offer**
- **100% Remote Work**, Hiring from: North Macedonia, Albania, Bosnia, Kosovo and Pakistan
- **Innovative Environment**: Work on challenging projects that drive innovation and improve our infrastructure.
- **Collaborative Culture**: Join a supportive team that values collaboration, continuous learning, and knowledge sharing.
- **Career Growth**: Opportunities to learn and grow in a dynamic and fast-paced environment
**Working Hours: Monday - Friday 9AM - 5PM EST**
Pay: R$3,000.00 - R$3,500.00 per month