Apply For This Job

Close

Job Description

Soft Consults is Pakistan’s leading provider of a complete ERP automation solution.

Position Overview

Oracle Database Administrator is responsible for ensuring the availability, integrity, accessibility and performance of all corporate databases.

Responsibilities

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

  • Should be able to do constant R&D and making an effective roadmap related to databases for products.
  • 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, integrity checks, configuration, statistics.

Required Skills

  • 2+ years of experience required as a database administrator.
  • Analysis of the Database design, deployment and optimization.
  • 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.
  • T-SQL, Business Intelligence, Query Optimization, Performance Tuning, DATA MODELING.

Job Details

Total Positions:
3 Posts
Job Shift:
First Shift (Day)
Job Type:
Job Location:
Gender:
No Preference
Minimum Education:
Bachelors
Degree Title:
Oracle Certified DBA
Career Level:
Experienced Professional
Minimum Experience:
2 Years (Candidate must have served in same position for at least 2 years.)
Apply Before:
Jan 31, 2021
Posting Date:
Dec 31, 2020
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

SoftConsults

Information Technology · 11-50 employees - Islamabad, 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 Database Administrator

MTBC, Rawalpindi, Pakistan
Posted Apr 12, 2021

Database Administrator

Posted Apr 10, 2021

Database Administrator

Laser Light Skin Care, Karachi, Pakistan
Posted Apr 19, 2021
View All