Mid Database Administrator

Sojojobfull-timeMid LevelNegotiableon-siteKathmandu Bagmati NepalSkills RequiredJob DescriptionAbout The RoleWe are looking for an experienced PostgreSQL Database Administrator (DBA) with 3+ years of hands-on experience managing PostgreSQL environments. The ideal candidate will be responsible for ensuring database reliability, security, and performance, while supporting mission-critical applications across on-premises and cloud-based systems.Key ResponsibilitiesInstall, configure, and maintain PostgreSQL databases across development, testing, and production environments.Monitor database performance, identify bottlenecks, and optimize queries and configurations.Implement and manage database backup, recovery, replication, and high-availability solutions (e.g., clustering, failover).Ensure database security through proper access control, user management, and auditing.Perform routine maintenance tasks such as vacuum, analyze, and reindex to maintain database health.Troubleshoot and resolve database issues related to performance, locking, and connectivity.Automate recurring administrative tasks using scripting languages like Bash or Python.Collaborate with application and development teams on schema design, query tuning, and stored procedure optimization.Implement and maintain monitoring tools such as pgAdmin, Nagios, Grafana, or Prometheus for proactive database management.Stay up-to-date with PostgreSQL advancements, tools, and best practices to continuously enhance database operations.RequirementsBachelor’s degree in Computer Science, Information Technology, or a related discipline.Minimum 3 years of proven experience as a PostgreSQL Database Administrator.In-depth knowledge of PostgreSQL architecture, internals, indexing, partitioning, and query planner.Strong experience with replication (logical/physical), clustering, and high availability setups.Proficiency in SQL and PL/pgSQL, with strong database design and query optimization skills.Hands-on experience with Linux/Unix systems administration.Familiarity with cloud-based PostgreSQL services (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL).Experience using backup and recovery tools such as pg_dump, pgBackRest, or Barman.Excellent analytical, troubleshooting, and problem-solving skills.Strong communication and documentation abilities.Preferred QualificationsExperience with Infrastructure-as-Code (IaC) tools like Terraform or Ansible.Exposure to containerized environments (Docker, Kubernetes).Understanding of CI/CD pipelines and database migration automation.Other Jobs at sojojobSEE ALLMid Finance OfficerSojojobfull-timeon-siteSenior UI/UX DesignerSojojobfull-timeon-siteMid Database AdministratorSojojobfull-timeon-siteSenior Laravel DeveloperSojojobfull-timeremoteMid System AdministratorSojojobfull-timeon-siteSenior Cloudflare Developer PlatformSojojobfull-timehybridDevops EngineerSojojobfull-timeon-siteSenior Software ArchitectSojojobfull-timeon-sitePython Backend DeveloperSojojobfull-timeon-siteR&D and Delivery LeaderSojojobfull-timeon-siteFront Desk OfficerSojojobfull-timeon-siteAnalystSojojobfull-timeon-site