98 Oracle jobs in Pakistan

Start Date: 12/28/2020

• Solid database SQL/PLSQL and Oracle Application Schema.
• Strong knowledge and experience in tables, views, indexes, functions, packages, APIs in Oracle 11g/12c database environment.
• Good knowledge of PL/SQL and SQL using SQL Developer, TOAD, etc.
• Analyze user requirements and convert requirements to design documents.
• Design, develop, and test software to meet user needs.
• Document application processes for future maintenance and upgrades.
• Test software and fix problems.
• Maintain systems once they’re up and running.
• Integrate software components.
• Produce efficient and maintainable code.
• Create complex databases for organizations.
• Solid experience with Oracle Personalization and Forms.
• In-depth experience with Financials, Customer Service, or Supply Chain modules. Experience with Contracts, CRM, and other Oracle modules strongly desired.
• APEX development experience or an interest in learning APEX.
• Strong knowledge of Oracle Forms & Reports 11G.

National Wireless (Private) Limited, Pakistan

Oracle Developer, Experience One Year in development, using Oracle Forms & Reports 6i & above.

Interested candidates are welcome to apply now

Oracle Developer, Experience One Year in development, using Oracle Forms & Reports 6i & above.

Interested candidates are welcome to apply now

Information Technology and Services - Faisalabad, Pakistan

Required Oracle Developer having at least 2 years of hands-on experience in Oracle Forms and Reports 10g and excellent command over SQL / PLSQL.

Candidate must possess BCS/MCS degree.

• Oracle Forms & Reports 10g
• Command over SQL / PLSQL
• Must be able to develop applications independently
• Software Documentation will be an added advantage
• Will be reporting to Manager IT
• Must hold BCS or MCS degree
• Experience in Oracle Apex will be an added advantage
• Must be able to use all Oracle tools like Toad, Knowledge Expert, Query Optimizer etc.
• Be able to maintain existing applications

Please review the job description carefully before submitting your application

Position Summary

The Oracle Database Administrator for Infrastructure team will perform Oracle database Administration for the Customer facing and corporate applications. He/she will provide strong operational support to the internal applications as well as Infrastructure teams. The candidate will participate in the On-Call rotation, troubleshoot problems and take appropriate corrective actions. He/she will keep the managers/team leaders informed of the progress and issues and collaborate with team members and application partners. A strong background in Oracle Database administration and security, ability to work independently and with teams in a fast-paced environment is a must.

Key Accountabilities:

• Initiate, plans, coordinates Oracle Database system upgrades on Linux, Unix and Windows environments
• Manages and supports the core systems that include administrative tasks such as monitoring databases as well as application performance, disk and memory usage, log, and database and application assignments; identifies and documents potential issues, prepares necessary corrective and preventative action plans
• Design, maintain, and document Oracle Database configurations/layouts
• Build and support new lpars (logical partitions) using Power VM virtualization
• Responsible for annual upgrades and patching on additional related core databases including but not limited to application servers
• Troubleshooting Oracle database issues within agreed SLA. Provide data and reporting of KPI’s and trends in ad-hoc, weekly, monthly and as sought
• Develop standard operating procedures and best practices, including written policies and protocols that guide to database administration staffing and vendors
• Installation, configuration and remediation of various security software on the Database environments
• Configuration and Administration of Oracle RAC, ASM, stand-alone instances
• Disk and File Management
• Responsible for monitoring and alerting on all the Oracle databases
• Perform disaster recovery, backup and restore activities
• Work under minimal super vision & take ownership of Oracle incidents end to end
• Assists application and database teams with data purges, data archival, backups and restorations
• Periodic system performance, capacity & resource management
• Review & own technical documentation ensure compliance and accuracy in all documents
• Proven problem solving and analytical skills
• Result driven with a positive can-do attitude
• Excellent collaboration and negotiation skills
• Highly team oriented
• Proficient in monitoring tools – Oracle OEM, SolarWinds & Nagios a plus

Education and Experience:

• 10+ years of experience in operations and project management of Oracle database administration
• Bachelor's in related technology/business areas

Skills and Behaviors:

• Advanced knowledge of Oracle Databases version 12 and 19c and their configuration and protocols, terms and concepts
• Expert level experience in Oracle RAC, ASM, RMAN and OEM
• Excellent understanding of OCI and Exadata
• Excellent understanding of SAN storage technologies
• Experience with writing shell scripts in ksh or any other scripting language
• Ability to adapt to established standards and practices
• Ability to manage multiple projects, activities and tasks simultaneously
• Exposure to Rubrik enterprise backup solutions
• Ability to manage several projects concurrently, assess priorities, and allocate resources
• managed infrastructure operations for 24*7 and on-call support
• Exposure to Microsoft SQL Server, Postgres or DB2 is a strong plus
• Exposure to SAP Hana, AWS Redshift or MongoDB is strongly preferred
• Oracle Cloud/ amazon AWS hands on & experience in transitioning infrastructure into various global cloud hosting providers a plus

• Seniority level Mid-Senior level

• Employment type Full-time

• Job function Information Technology
• Industries Retail

Referrals increase your chances of interviewing at The Children's Place by 2x

Continue with Google Continue with Google

Continue with Google Continue with Google

Lahore District, Punjab, Pakistan 17 hours ago

Lahore District, Punjab, Pakistan 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

Oracle 12/19c administration and support (on-prem or cloud)

Oracle Patch Management Coordination and implementation

Oracle backup and recovery planning/testing

Provide infrastructure support at all levels and after hours support as needed

Coordinate Oracle DB work with other Systems Administrators and IT Teams

Review, recommend, and implement new Oracle services as required

Requirements:

Experience supporting or maintaining the following technologies:

Oracle 12c/19c

Oracle Data Guard

Oracle RAC

Oracle Advanced Security

Oracle Data Masking

Oracle Data Redaction

Oracle Tuning and Diagnostic Pack

Oracle Multi Tenant

RMAN

SQL*Net

Experience supporting Disaster Recovery operations with Oracle Database technologies

Ability to develop and enforce standards and best practices

Ability to interact effectively and professionally with staff

Weekend and after-hours work will be required as needed

Additional Skills:

Oracle certifications or equivalents are a plus

Experience or knowledge of any other database (preferred but not essential)

Financial Services or Banking experience are a plus

College degree preferred with 8+ years of experience in Data Base Administration with 7+ years of experience directly supporting Oracle Database Technologies

Ability to work with a variety of personalities

Information Technology and Services - Karachi, Pakistan

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

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

A 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

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

Information Technology and Services - Chicago, United States