Oracle Database Admin L3

Job Description

Job Title Oracle Database Admin – L3

Proposed Grade B3

Primary Skill (Technical Skill) Oracle DBA

Secondary Skill (Optional) OS -  Solaris/Linux/AIX/HP UNIX & Windows Database - MySQL/MS SQL & Windows OS / Sybase / DB2 / PostgreSQL/MongoDB/SAP HANA

Educational Qualifications B.E. / B.Sc. / Diploma

Experience Level 5 – 8 Years

Role & Responsibilities:

Handled large database estates and managed TB size of databases 

· Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers 

· Design and implement the high availability solutions (RAC, Golden Gate and Dataguard) · Install, configure and manage ASM instances in oracle 

· Plan and execute major migrations and upgrades

 · Define and configure the disk and diskgroups in ASM and troubleshoot 

· 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 

· Install, Administer, manage and troubleshoot 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

 · Ensure the reduction of repeated errors through implementation of necessary checkpoints · Contribute towards evaluation of tools, products and software selection 

· SLA tracking and reporting to Higher management 

· Prepare and Maintain Standard Operating Procedure for all activities 

· Proactive identification of risks and mitigation of the same 

· Technical presentation on emerging technologies. 

· Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager. 

· Implement and Periodical check on Automation 

· Implement and Periodical check on DB Security 

· Identify, document and track Technology related risks and mitigation plan in the project · Technical and Process guidance to L2 and L1 DBA 

· Provide 24x7 and on call support for critical application databases

Skills Must have Nice to Have:

Technical Skills

(Core & Top-Up) · Strong database administration 

· Database upgrades on multiple versions and releases 

· High availability (RAC) setup and administration 

· Disaster recovery design, planning, setup and administer the Dataguard (standby) 

· Install, configure, maintain and troubleshooting on Golden Gate 

· Knowledge on ExaData 

· OEM Configuration and management 

· Automation through scripting 

· Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views 

· Experience on OS, Storage, Network and Virtualization activities 

· Certification on Primary Technology

 · Handled database estate of various technologies

Process & Tools 

· Service Request and Incident, Problem, Change managements 

· Configuration, Capacity planning and Knowledge management 

· Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool

 · Identify the service improvement plan 

· ITIL Foundation certified

Behavioral Skill · Strong verbal and written communication skills · Team management and motivation · Flexibility, good attitude · Manage the global infrastructure customer and projects