https://onecontact.com.mk/job/detail/remote-postgresql-senior-dba

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.
• Collaborate with application development teams to design and implement structured database migration processes that align with best practices and minimize disruptions.
• 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
• Impactful Work: Be part of a team that plays a critical role in the reliability and scalability of our application platform.
• 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