We are looking for a technically savvy, results-oriented, and quality-focused individual with strong, hands-on Oracle database administration skills to administer, tune, and maintain our OLTP/ Data Warehouse and Back-Office databases. This person will play a key role in ensuring the availability, performance and security of the databases. The responsibilities of this position will include performance monitoring, automation of database related processes; and working with cross-functional teams in a highly collaborative environment. This individual will play an active role in all aspects of database administration and will provide database administration support, review database design and integration of systems, provide backup recovery, and make recommendations regarding enhancements and/or improvements.

Core Responsibilities:

  • Production and Staging Administration
  • Database Performance Tuning
  • Installation, configuration and upgrading of Oracle server software and related products
  • Database Loading
  • Development and Management of SOPs
  • Environment Management
  • Database Health (e.g. monitoring, proactive and reactive responses)
  • Backup and Recovery Strategy Planning and Implementation
  • Database Upgrade Planning
  • The Database Administrator position will require an understanding of the following Oracle products:
  • Oracle Database 10g & 11g
  • Oracle RAC
  • Oracle Grid Control
  • Oracle ASM
  • Oracle Streams
  • Oracle DataGuard
  • Candidates also having hands-on knowledge of Microsoft SQL Server would be preferred.

Performance and Tuning:

  • Review statistics regularly and at pre-defined intervals Proactive tuning of database instance tuning, memory, I/O, and CPU usage.
  • Database instance tuning via interpreting Oracle system internal views.
  • Database tuning for optimal performance
  • Expert understanding of Oracle database administration best practices (e.g., schema management, index optimization, and use of hints)
  • Maintain performance data archive for historical and planning analysis
  • Monitor and evaluate database resource consumption
  • Ability to perform SQL optimization by generating traces and interprets trace results; and is able to offer findings and recommendations

Job Details

Total Positions:
2 Posts
Job Shift:
First Shift (Day)
Job Type:
Job Location:
Gender:
No Preference
Minimum Education:
Masters
Career Level:
Experienced Professional
Minimum Experience:
3 Years
Apply Before:
Oct 21, 2016
Posting Date:
Sep 29, 2016

Punjab Social Security Health Management Company

Healthcare / Hospital / Medical · 301-600 employees - Lahore, Muzaffargarh

It is said that nothing happens, unless there is a dream first. The creation of PSSHMC Hospital was a dream. A dream so powerful, that it helped transform the medical facilities to the industrial workers to an excellent level.

What is your Competitive Advantage?

Get quick competitive analysis and professional insights about yourself
Talk to our expert team of counsellors to improve your CV!
Try Rozee Premium

Similar Job Titles

Database Administrator

Habib Metropolitan Bank Ltd, Karachi, Pakistan
Posted Apr 01, 2024

Database Administrator

Contour Software, Islamabad, Pakistan
Posted Apr 01, 2024

Associate Database Administrator

Pakistan Single Window, Karachi, Pakistan
Posted Apr 09, 2024

Principal Database Administrator

Pakistan Single Window, Karachi, Pakistan
Posted Apr 09, 2024
View All
I found a job on Rozee!