Database Administrator

Nayatel; Islamabad; On-site; PKR 1,200,000 - 2,400,000; Full time

Job summary

Nayatel is seeking a Database Administrator to independently install, configure, and manage PostgreSQL, Oracle, and MySQL in a Linux environment. You will implement replication (Streaming Replication/Hot Standby) and Data Guard, manage backups, perform failovers, and optimize performance for large-scale databases.

Ideal candidates have 1–2 years of relevant experience, a BS in CS/Software Engineering, and a solid understanding of database design and NoSQL concepts.

Qualifications

• BS CS/Software Engineering or equivalent degree.
• 1–2 years of relevant experience.
• Understanding of database design and modelling.
• Understanding of NoSQL databases.

Responsibilities

• Install, configure, and manage PostgreSQL, Oracle, and MySQL.
• Plan, install, and configure database systems.
• Manage database users and permissions.
• Implement PostgreSQL replication and Oracle Data Guard.
• Backup and restore using pg_dump/pg_basebackup and RMAN/Data Pump.
• Perform failover/switchover activities.
• Monitor and tune performance of databases.
• Write and optimize SQL queries for reporting.
• Ensure security, integrity, and high availability.
• Maintain databases on Linux environments.
• Troubleshoot database issues.
• Routine maintenance like vacuuming and reindexing.
• Manage and support large-scale databases.

Skills

Database design

NoSQL concepts

Linux administration

Performance tuning

SQL writing

Education

BS CS/Software Engineering

Tools

PostgreSQL

Oracle

MySQL

Job description

Job Description:

• Independently install, configure, manage and maintain PostgreSQL, Oracle, MySQL.
• Planning, installation, and configuration of database systems.
• Database user management and administration.
• Implementation and management of PostgreSQL replication (Streaming Replication / Hot Standby).
• Implementation and management of Oracle Data Guard (Active/Standby).
• Backup and recovery management: PostgreSQL (pg_dump, pg_basebackup, pg_fdw) and Oracle (RMAN, Data Pump).
• Execution of failover and switchover activities.
• Monitoring and performance tuning of databases (queries, indexing, configuration).
• Writing and optimizing SQL queries for reporting and analysis.
• Ensuring database security, integrity, and high availability.
• Managing databases in Linux environments.
• Troubleshooting and resolving database issues independently.
• Performing routine maintenance (vacuuming, reindexing, statistics updates).
• Managing and supporting large-scale databases.

Requirements:

• BS CS/Software Engineering or any other relevant degree
• 1-2 years of relevant experience
• Understanding of database design and modelling.
• Understanding of NoSQL databases.

Why Nayatel?

We provide:

• Challenging environment
• Open door policy
• Respect, dignity, and protection
• Training, mentoring, and coaching in soft and hard skills to transform you as a future leader
• Representation in external forums (University lecturers, advisory boards, etc.)
• Excellent rewards for out of the box thinker, doers, and implementers
• Equal opportunity, merit, and no Safarish culture

Hiring Procedure:

• CV shortlisting
• Technical Test
• Initial Interview
• IQ/Personality Assessment Tests
• Final interview
• Medical Screening
• Joining