Scribd
Upload
154 views

Database (Oracle) DBA Admin - L3

The job description is for an Oracle Database Administrator with 5-8 years of experience. The role involves managing large Oracle databases, installing and administering Oracle software, designing and implementing high availability solutions, and providing 24x7 support for critical application databases. Responsibilities include database upgrades, backups, performance tuning, scripting, and coordinating with vendors for issue resolution. The ideal candidate has strong experience with Oracle database and ASM administration, high availability setups, disaster recovery planning, and performance analysis tools.

Uploaded by

rajiv_ndpt8394
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
154 views

Database (Oracle) DBA Admin - L3

The job description is for an Oracle Database Administrator with 5-8 years of experience. The role involves managing large Oracle databases, installing and administering Oracle software, designing and implementing high availability solutions, and providing 24x7 support for critical application databases. Responsibilities include database upgrades, backups, performance tuning, scripting, and coordinating with vendors for issue resolution. The ideal candidate has strong experience with Oracle database and ASM administration, high availability setups, disaster recovery planning, and performance analysis tools.

Uploaded by

rajiv_ndpt8394
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

Job Description

Job Title Oracle Database Admin – L3


Proposed Grade Band B2 / B3
Primary Skill (Technical Skill) Oracle DBA
Secondary Skill (optional) MS SQL / Sybase / UDB DB2
Educational Qualifications B.E. / B.Sc. / Diploma
Experience Level 5 – 8 Years
Location of Posting

Role &  Handled large database estates and managed TB size of databases
Responsibilitie  Installation and administration of Oracle 11gR2, 10g, 9i on UNIX (AIX/Linux/Solaris) and
s Windows servers
 Design and implement the high availability solutions (RAC, Golden Gate and Dataguard)
 Install, configure and manage ASM instances
 Define and configure the disk and diskgroups in ASM
 Manage and administer the databases on Exadata machine
 Plan the database upgrade, migration and patching
 Plan and implement the backup/recovery on need basis
 Hardware tech refresh (host to host database move)
 Coordinate and work with database vendors for resolution on major incidents
 Database refresh, re-org, backup using RMAN and 3rd party tools
 Install and configure grid control database monitoring tools
 Administer and manage Oracle grid control
 Define performance benchmarks and metrics
 Periodic database instance performance review and tuning recommendation
 Proactive database analysis and suggestion to application team / business
 Write and troubleshoot shell scripting, SQL and PL/SQL scripts
 Primarily role is supporting the production and non-prod database environments
 Provide 24x7 and on call support for critical application databases

Skills Must have Nice to Have


Technical Skills  Strong database and ASM administration experience on  Oracle certified
(Core & Top-Up) Oracle 11gR2 professional (OCP)
 Database upgrade to 11gR2 and migration experience  Handled database estate
 High availability (RAC) setup and administration of various technologies
 Disaster recovery design, planning , setup and administer (Oracle, MS SQL, Sybase,
the Dataguard (standby) MySQL, UDB DB2)
 Install, configure, maintain and troubleshooting on
Golden Gate
 Strong performance analysis on AWR, ADDM, SQL Profile,
ASH and advisory views
 Co-ordinate and execute the PSU quarterly critical patches
Process & Tools  Service Request and Incident, Problem, Change  ITIL Foundation certified
managements
 Configuration, Capacity planning and Knowledge
management
 Experience on ITIL Tools like Remedy, Peregrine
 Identify the service improvement plan
Behavioral Skill  Strong verbal and written communication skills  Manage the global
 Team management and motivation infrastructure customer
 Flexibility, good attitude and projects

GIS Competency Group Page 1


Wipro Limited

You might also like