Oracle DB Production Support Engineer — Performance Tuning

Systems Limited; Lahore; On-site; PKR 1,800,000 - 3,000,000; Full time

Job summary

Systems Limited in Lahore, Pakistan is seeking an Oracle Database Support Engineer with 3–7 years of hands-on experience in production database support, tuning, and data integrity. The role collaborates with application, development, and infrastructure teams to ensure availability, security, and performance.

Responsibilities include incident resolution, monitoring, RMAN backup, and database maintenance, plus deployment support and RCA-driven improvements. AOC/Patch knowledge is valued.

Qualifications

• 3–7 years hands-on Oracle Database administration and production support experience.
• Strong knowledge of Oracle architecture, SQL, performance tuning, query optimization, and troubleshooting.
• Experience with RMAN, backup/recovery, and database monitoring.
• Linux/Unix knowledge, shell scripting, and familiarity with patches/upgrades is a plus.
• Oracle OCP certification and ITIL experience are desirable.

Responsibilities

• Provide production and on-call support for Oracle databases, including incident resolution and troubleshooting.
• Monitor database performance, availability, capacity, and health.
• Perform SQL and database performance tuning, including execution plans, indexing, statistics, and query optimization.
• Troubleshoot slow queries, locking, blocking sessions, deadlocks, wait events, and database errors.
• Maintain data integrity, security, and availability.
• Manage users, roles, privileges, schemas, storage, and routine maintenance.
• Perform RMAN backup, restore, recovery, and disaster recovery activities.
• Support patching, upgrades, migrations, deployments, and configuration changes.
• Conduct root-cause analysis (RCA) and implement preventive actions.
• Collaborate with development, application, and infrastructure teams on database issues and SQL optimization.
• Monitor alerts and proactively identify risks to performance and capacity.
• Follow security, change management, and data governance standards and maintain documentation.

Skills

Oracle Database administration

Production support

SQL performance tuning

Troubleshooting

Backup & recovery

Data integrity

Shell scripting

Linux/Unix

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

RMAN

Oracle RAC

Data Guard

Oracle Cloud OCI

Job description

Systems Limited in Lahore, Pakistan is seeking an Oracle Database Support Engineer with 3–7 years of hands-on experience in production database support, tuning, and data integrity. The role collaborates with application, development, and infrastructure teams to ensure availability, security, and performance.

Responsibilities include incident resolution, monitoring, RMAN backup, and database maintenance, plus deployment support and RCA-driven improvements. AOC/Patch knowledge is valued.