Oracle DBA

Job Description

Job Title Oracle Database Admin – L3

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

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