Midas Health Services is a leading healthcare Information system solution provider in Nepal. Our system solution sustains and enhances healthcare services in Nepal. It’s backed by over 20 years of experienced team members, many of whom are expert domain consultants and accomplished professionals with extensive work experience in healthcare ERP system solutions. We focus on improving outcomes of our healthcare partners and redefine patient care. ...
View Company ProfilePostgreSQL Database Administrator (DBA)
Job summary
-
No. of Vacancy
: 1 -
Job Type
: Full Time -
Offered Salary
: Negotiable -
Gender
: Both -
Career Level
: Mid Level -
Experience
: 3 Years -
Apply Before
: 2024-11-03 (3 Days Left) -
Skills
:ETLOracleSQLAWS
Job Description:
We are looking for an experienced PostgreSQL Database Administrator with at least 3 years of professional expertise in database management, including hands-on experience with Oracle. The ideal candidate will also have experience managing databases in a microservices architecture. This role involves ensuring the performance, availability, and security of PostgreSQL databases while providing support for legacy Oracle systems and assisting in database migrations.
- Administer, maintain, and optimize PostgreSQL databases for high performance, availability, and security.
- Design and manage databases for microservices architectures, ensuring proper data partitioning, consistency, and scaling.
- Collaborate with development teams to design and maintain optimal database schemas, specifically suited to microservices environments.
- Plan and implement database schema changes, migrations, upgrades, and backups.
- Monitor system performance, troubleshoot issues, and resolve incidents to minimize downtime.
- Write scripts for automation of routine database tasks (e.g., backups, monitoring).
- Ensure database security through access control, encryption, and auditing.
- Tune database queries and optimize database performance in distributed microservices environments.
- Conduct regular capacity planning and resource allocation to meet future demands.
- Provide technical support and expertise for Oracle databases, especially in hybrid environments.
- Assist in the migration of Oracle databases to PostgreSQL and manage hybrid systems.
- Maintain comprehensive documentation for database processes, microservices data management, and procedures.
Required Knowledge, Skills, and Abilities:
- Experience with Oracle DBA tasks, including database setup, maintenance, backups, and performance tuning.
- Expertise in managing databases for microservices architectures, including distributed data management, schema design, and transaction handling.
- Proficiency in writing SQL queries, PL/pgSQL, and PL/SQL.
- Strong understanding of database design, indexing, replication, and partitioning techniques, especially in a microservices context.
- Experience with database performance tuning and optimization in both PostgreSQL and Oracle environments.
- Familiarity with PostgreSQL extensions like PostGIS, logical replication, and BDR is a plus.
- Experience with automation tools and scripting languages (e.g., Bash, Python).
- Knowledge of microservices database management patterns like CQRS, eventual consistency, and data sharding.
- Experience with cloud-based database services (e.g., AWS RDS, Azure Database for PostgreSQL) and containerized databases in environments like Kubernetes or Docker.
- Strong understanding of backup strategies and disaster recovery procedures for distributed systems.
- Strong communication and collaboration skills.
- Ability to work in a fast-paced, distributed environment and manage multiple priorities.
- Analytical mindset with the ability to troubleshoot and solve complex issues, particularly in microservices ecosystems.
Education + Experience:
- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- 3+ years of experience as a PostgreSQL DBA.
Benefits:
- Gratuity: 8.33% of your basic salary will be contributed towards your gratuity fund.
- Unused Leave Encashment: Unused leave will be encashed based on your salary at the time of retirement.
- Medical Insurance: Coverage of NPR 100,000 per year, fully covered by the company.
- Accidental Insurance: Coverage of NPR 700,000 per year, fully covered by the company.
- We provide a proper meal or lunch, which will be fully covered by the company.
- We offer various recreational activities, such as weekly futsal or cricket, which promote physical health and team bonding.
- We regularly organize inter-company programs to engage employees and encourage networking in corporate settings.
Apply Instruction:
Interested candidates fulfilling the mentioned criteria are encouraged to Apply using the Easy Apply button below. Registered candidates may also apply using Apply Now Button.