Oracle DBA

6 days 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, Automatic Workload Repository and Automatic Database Diagnostic Monitor.

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.

At least three years of working knowledge of Oracle Real Application Clusters (Oracle RAC), Oracle Enterprise Manager (Oracle OEM/Grid Control), Oracle Automatic Storage Management (Oracle ASM) and Oracle Automatic Storage Management Cluster File System, Oracle Recovery Manager (RMAN), Oracle Data Guard and Oracle Database Security.

Good organizational and communication skills with the ability to handle multiple priorities.

Experience in handling and supporting enterprise, high profile, mission critical and dynamic 24x7 large-scale Oracle environments with high availability and scalable performance requirements.

Proven experience in Performance Tuning of Database and SQL.

Knowledge of Backup and Recovery - RMAN including exposure to plan and strategize backup and recovery operations. Proven experience in Database backups and restores using RMAN.

Experience in supporting both Development and Production Database environments.

The candidate must be able to drive Product issues to resolution and register all steps in document following ITIL processes.

Ability to provide L3 support.

Working knowledge of operating systems such as Windows Server, Unix, Linux, AIX, etc.

Preferred Skills:

Oracle Certified Expert (RAC/ Performance Tuning).

Knowledge of applicable data privacy practices and laws.

Ability to conduct research into database issues, standards, and products as required.

Ability to effectively prioritize and execute tasks in a high-pressure environment.

Good written and oral communication skills.

Strong technical documentation skills.

Good interpersonal skills.

Willingness to work a flexible schedule and be "on call" to accommodate project deadlines and business requirements.

Job Specification

Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions and upgrades.

Drive upgrade and management of large, complex Oracle databases currently running on Oracle 11g/12c environments on Linux and Exadata to Oracle 19c with features for PDB/CDB, data compression, partitioning, RAC, RMAN, Data Guard.

Lead analysis of business and application requirements to translate into new or modified database or data capabilities.

Requirements analysis, data architecture, integrated database design, data security, performance tuning, back-up and recovery specifications.

Consult for optimal design of DB environments, analyzing complex distributed production deployments, and making recommendations to optimize performance.

Assist with the evaluation and implementation of new product features to tailor solutions for database requirements.

Use optimization techniques such as projections and partitioning.

IT compliance and risk management requirements (e.g., security, privacy, SOX, etc.).

Respond to and resolve database access and performance issues.

Crash/Recovery of Databases.

Database Performance Analysis & Developing Tuning Approach.

Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Documenting any Bad SQL Queries and support Application team for fine tuning.

Participate in Change Management Process.

Preparing Backup and Restore Strategy and implementation.

DR Plan, Implementation and Management.

Consultancy (if required) developers in optimizing SQL query and support to application development team during the development, testing, pre-production and post-production phase.

Create, or support creation of, required reports in response to business user needs.

Communicate with external teams including the biz clients on various issues and resolutions thereof to provide best customer experience.

Develop, implement, and maintain change control and testing processes for modifications to databases.

Analyze database system details within the database, including stored procedures and execution time, and implement efficiency improvements.

Consultancy for DB Upgrades and Enhancement.

Security Compliance Preparation and Implementation plan.

Perform database transaction and security audits.

#J-18808-Ljbffr

  • Oracle DBA

    6 days 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...

  • DBA Specialist

    4 days ago

    Lahore, Punjab, Pakistan Devsinc 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...

  • Enterprise Oracle DBA

    6 days ago

    Lahore, Punjab, Pakistan Driodmoister Full time

    Job DescriptionThe successful candidate will have extensive experience in Oracle 19c implementations, upgrades, conversions, and consolidations on Exadata and Oracle Cloud Platform. A strong understanding of physical data modeling, tuning large instances, PDB/CDB, resource management, data replication, and backup/recovery techniques is essential.You will...

  • Database Administrator Lead

    6 days ago

    Lahore, Punjab, Pakistan DroidMeister Full time

    Job OverviewWe are seeking an experienced Oracle DBA to lead our database team and drive the implementation of high-performance databases.

  • High-Performance Database Engineer

    6 days ago

    Lahore, Punjab, Pakistan DroidMeister Full time

    RequirementsTo be successful in this role, you will need:A bachelor's degree in computer science or a related field.At least 5 years of experience as an Oracle DBA.Hands-on experience with Oracle 19c implementations, upgrades, conversions, and consolidation projects on Exadata and Oracle Cloud Platform.Excellent troubleshooting and performance tuning...

  • Oracle Database Administrator

    3 weeks ago

    Lahore, Punjab, Pakistan Techaccess Pakistan Full time

    Job Responsibilities:Installing and maintaining required database software versions on different platforms.Installation capabilities of single instance and Oracle Real Application Cluster.Creating storage database structures with high-level security features.Altering storage structures to meet the evolving needs of the company.Training users on how to access...

  • M.i.s. Manager For Lahore

    3 weeks ago

    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...

  • Production Systems Integration Expert

    3 days ago

    Lahore, Punjab, Pakistan Naveena Exports Full time

    About UsNaveena Exports is seeking an experienced Oracle ERP Specialist For Manufacturing Sector to join our team in Lahore. The ideal candidate will have functional and technical knowledge of Oracle ERP 11i and at least 5 years of hands-on experience in designing, developing, and implementing integrated ERP systems in a manufacturing...

  • Digital Transformation Leader

    3 days ago

    Lahore, Punjab, Pakistan Naveena Exports Full time

    Job DescriptionWe are looking for a Production Systems Integration Expert to join our team in Lahore. The successful candidate will have extensive knowledge of Oracle ERP 11i and at least 5 years of hands-on experience in designing, developing, and implementing integrated ERP systems in a manufacturing environment.Key ResponsibilitiesDesign and develop...

  • Enterprise IT Project Manager

    3 days ago

    Lahore, Punjab, Pakistan Naveena Exports Full time

    Job OverviewWe are seeking an experienced Enterprise IT Project Manager to lead the implementation of integrated ERP systems in a manufacturing environment. The ideal candidate will have functional and technical knowledge of Oracle ERP 11i and at least 5 years of hands-on experience in designing, developing, and implementing ERP systems.Key...

  • Database Specialist

    6 days ago

    Lahore, Punjab, Pakistan Driodmoister Full time

    About the RoleWe are seeking a highly skilled Database Specialist to join our team at Driodmoister. As an Enterprise Oracle DBA, you will be responsible for designing, implementing, and maintaining large-scale Oracle databases.Your primary focus will be on ensuring high availability, scalability, and performance of our database environments. You will work...

  • Oracle DBA Consultant

    6 days ago

    Lahore, Punjab, Pakistan DroidMeister Full time

    ResponsibilitiesAnalyze business requirements and translate them into technical specifications for database design and development.Lead the analysis, design, and implementation of database solutions to meet business needs.Collaborate with cross-functional teams to ensure seamless integration of database systems with other applications.Develop and implement...

  • Database Administrator

    2 hours ago

    Lahore, Punjab, Pakistan TheHiringl Full time

    Job Summary:We are seeking a skilled and detail-oriented Database Administrator (DBA) to join our team. The DBA will be responsible for the performance, integrity, and security of our databases. The ideal candidate will also be involved in the planning and development of databases, as well as troubleshooting any issues on behalf of the users.Key...

  • Data Storage Specialist

    4 days ago

    Lahore, Punjab, Pakistan Devsinc Full time

    In this role, you will be responsible for managing and maintaining our database systems to ensure they meet the highest standards of performance, security, and availability.You will work closely with our development teams to support application development and data management initiatives.Key responsibilities include installing, configuring, and monitoring...

  • Database System Manager

    4 days ago

    Lahore, Punjab, Pakistan Devsinc Full time

    Devsinc is a leading technology company seeking an experienced IT professional to join our team as a Database System Manager.This role involves overseeing the design, implementation, and maintenance of our database systems to ensure optimal performance, security, and availability.We are looking for someone with strong technical skills in database management...