Oracle DBA

3 days ago


Lahore, Punjab, Pakistan DroidMeister Full time

Qualifications:

  1. Bachelor's degree in a relevant IT field.
  2. At least 5 years' experience as an Oracle DBA (10g, 11g, 12c, 19c).
  3. Hands-on experience with Oracle 19c implementations, upgrades, conversions, and consolidation projects on Exadata and Oracle Cloud Platform.
  4. Excellent troubleshooting and performance tuning skills, with knowledge of tuning features like SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository, and Automatic Database Diagnostic Monitor.
  5. Strong knowledge of Oracle 19c and technical database concepts such as physical data modeling, tuning large instances, PDB/CDB, resource management, data replication, and backup/recovery techniques.
  6. Minimum three years of working knowledge of Oracle RAC, Oracle Enterprise Manager, Oracle ASM, Oracle RMAN, Oracle Data Guard, and Oracle Database Security.
  7. Good organizational and communication skills to handle multiple priorities.
  8. Experience supporting enterprise, high-profile, mission-critical, and dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements.
  9. Proven experience in database and SQL performance tuning.
  10. Knowledge of RMAN backup and recovery strategies, with experience in database backups and restores using RMAN.
  11. Experience supporting both development and production database environments.
  12. Ability to drive product issues to resolution following ITIL processes and provide Level 3 support.
  13. Working knowledge of operating systems such as Windows Server, Unix, Linux, AIX, etc.
  14. Preferred skills include Oracle Certified Expert (RAC/Performance Tuning).
  15. Knowledge of data privacy laws and practices.
  16. Ability to conduct research into database issues, standards, and products.
  17. Effective prioritization and execution skills in high-pressure environments.
  18. Excellent written and oral communication skills, with strong technical documentation skills.
  19. Good interpersonal skills and willingness to work flexible hours, including being on call.

Job Responsibilities:

  1. Analyze and execute end-to-end database consolidation, migration, conversion, and upgrade projects.
  2. Lead the upgrade and management of large Oracle databases on Linux and Exadata to Oracle 19c, utilizing features like PDB/CDB, data compression, partitioning, RAC, RMAN, Data Guard.
  3. Translate business and application requirements into database designs and capabilities.
  4. Perform requirements analysis, data architecture design, data security, performance tuning, and backup/recovery planning.
  5. Consult on optimal database environment design, analyze complex deployments, and recommend performance improvements.
  6. Evaluate and implement new product features tailored to database needs.
  7. Use optimization techniques such as projections and partitioning.
  8. Ensure IT compliance and risk management, including security and privacy standards.
  9. Establish database access controls and respond to access and performance issues.
  10. Manage database crash recovery and performance analysis, including SQL query tuning.
  11. Document issues and support application teams in fine-tuning SQL queries.
  12. Participate in change management processes and develop backup, restore, and disaster recovery strategies.
  13. Support development teams during various phases of application lifecycle.
  14. Create reports and communicate with external teams to ensure optimal database performance and security.
  15. Implement change control and testing processes for database modifications.
  16. Conduct database transaction and security audits.

Location: Lahore, Pakistan

#J-18808-Ljbffr

  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Summary:We are looking for an experienced Oracle DBA to work on various projects. The ideal candidate will have a strong understanding of Oracle 9i, 10g, and 11g databases, as well as SQL in Linux and Windows environments.The successful candidate will be responsible for designing and implementing database solutions, including performance tuning and...

  • Oracle DBA

    2 weeks ago


    Lahore, Punjab, Pakistan DroidMeister Full time

    Bachelor's degree in relevant IT departments.At least 5 years' experience as Oracle DBA (10g, 11g, 12c, 19c).Hands-on experience with Oracle 19c implementations, upgrades, conversions, and consolidation projects on Exadata and Oracle Cloud Platform.Excellent troubleshooting and performance tuning skills. Demonstrated knowledge and skills using tuning...

  • Oracle DBA

    2 weeks ago


    Lahore, Punjab, Pakistan Driodmoister Full time

    At least 8 years' experience as Oracle DBA (10g, 11g, 12c, 19c).Hands on experience with Oracle 19c implementations, upgrades, conversions and consolidation projects on Exadata and Oracle Cloud Platform.Excellent troubleshooting and performance tuning skills. Demonstrated knowledge and skills using tuning features like SQL Tuning Advisor, SQL Access Advisor,...

  • DBA Specialist

    2 weeks ago


    Lahore, Punjab, Pakistan Devsinc, LLC Full time

    Devsinc is seeking a talented DBA Specialist to join our dynamic IT team. In this role, you will be responsible for managing, maintaining, and optimizing our database systems to ensure the highest levels of performance, availability, and security. You will work closely with various teams to support application development and data management initiatives.Key...

  • Assistant DBA

    6 days ago


    Lahore, Punjab, Pakistan Azgard9 Denim Full time

    - Oracle 9i & 10g performance tuning, job scheduling, shell scripting, automation scripting.- Oracle Partitioning, RMAN, patching, db up-gradation.- Building databases in different environments, multi-nodes in Linux/Unix/Windows.- Oracle RAC, Data Guard and/or Grid Control is preferred.- Oracle Backup/Recovery Methodologies and Strategies.Job Specification-...


  • Lahore, Punjab, Pakistan Naveena Exports Full time

    Ideal Candidate having Functional & Technical Knowledge of Oracle ERP 11i.5+ Years hands-on experience involved in the designing, development, and Implementation of integrated ERP systems in a manufacturing environment.Job SpecificationExtensive knowledge of Oracle DB, SQL, PL/SQL, Developer 6i (Forms & Reports). Ability to manage Operation Teams. M.Cs. / 4...


  • Lahore, Punjab, Pakistan Naveena Exports Full time

    Ideal Candidate having Functional & Technical Knowledge of Oracle ERP 11i with 5+ years hands-on experience involved in the designing, development, and implementation of integrated ERP systems in a manufacturing environment.Job SpecificationExtensive knowledge of Oracle DB, SQL, PL/SQL, Developer 6i (Forms & Reports). Will be able to manage Operation Teams...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Description:We are seeking an experienced Oracle DBA to work on various projects. The ideal candidate will have a strong understanding of Oracle databases, SQL, and Linux/Unix/Windows environments.The successful candidate will be responsible for building databases in different environments, including multi-nodes, and providing excellent troubleshooting...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    Job Overview:We are seeking an experienced Oracle DBA to join our team. The ideal candidate will have a strong background in performance tuning, job scheduling, and automation scripting.The successful candidate will be responsible for building databases in different environments, including Linux, Unix, and Windows. Experience with Oracle Partitioning, RMAN,...


  • Lahore, Punjab, Pakistan beBee Careers Full time

    A motivated and experienced DBA Specialist is required to manage and maintain our database systems.This individual will be responsible for ensuring high performance, availability, and security of the database systems.Close collaboration with various teams to support application development and data management initiatives.Key Responsibilities:Manage database...