Apply For This Job


Job Description

Key duties will include the analysis of the existing databases in terms of design, deployment and optimization.


  • Design, development and administration of Oracle databases.
  • Reviewing and tuning SQL and PL/SQL code.
  • Designing database packages and procedures.
  • Provide assistance to development team in the design, development, testing, tuning and implementation of database applications
  • Create and maintain SQL queries and routines.
  • Write ad-hoc queries based on schema knowledge for object relational database mapping and various reporting requirements.
  • Should be able to identify and plan trainings for different development teams for database related best practices in terms of coding.
  • Design, build and maintain high-volume relational databases for company’s applications and systems
  • Design and support Database backup solutions which can include hot/cold backups, exports, imports and RMAN
  • Control and review all security standards employed on the databases
  • Performance tuning and write code for database access, modifications, and constructions including stored procedures, views and triggers
  • Support database platforms and help define strategies for data acquisition, recovery, migration and archiving
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using native monitoring and troubleshooting tools.
  • Ability to detect and troubleshoot the issues.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, and Replication.
  • Expert experience in implementing operational automation.
  • Strong knowledge of indexes, index management, and integrity checks, configuration, statistics.

Skills Required:

  • Complete knowledge of Oracle database with production support experience in a multi-project environment. 
  • In-depth knowledge of SQL and PL/SQL including tuning. 
  • Good working knowledge of job scheduling and monitoring tools. 
  • Experience of working with multiple projects/tasks and the ability to deliver quality work. 
  • Familiarity with Oracle specific tools and utilities.
  • 2+ years of experience as a database administrator.
  • Very strong communication (written and verbal)
  • Good knowledge of Oracle database installation, maintenance and recovery.
  • Excellent problem solving and analytical skills, and outstanding oral and written communication skills.
  • Good experience with Oracle9i, Oracle10g databases and utilities on Solaris, Linux and Windows Servers.

Job Details

Total Positions:
1 Post
Job Shift:
First Shift (Day)
Job Type:
Full Time/Permanent
Job Location:
No Preference
Minimum Education:
Career Level:
Experienced Professional
Minimum Experience:
2 Years
Apply Before:
Oct 25, 2017
Posting Date:
Sep 26, 2017
Show fewer details Read full job description

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


Information Technology · 11-50 employees - Lahore

SoftConsults, is providing ERP solutions since 1998. We provide time-saving innovative solutions resulting improving the staff efficiency, minimizing data processing time and reducing the payroll cost. We have the largest ERP deployed client list covering RIAZ MSB Limited, Minerva Payment Services ...Read More

Similar Job Titles

Oracle Apps DBA

InfoTech Pvt Ltd, Karachi, Pakistan
Posted Sep 03, 2018

Oracle DBA

Hero Group, Hyderabad, Pakistan
Posted Sep 12, 2018