Role : Oracle Database Admin

Location : Pune (Hybrid)

Experience : 5 - 6 Years

Primary Skill (Technical Skill) : Oracle DBA and Goldengate

Secondary skills :

OS : Solaris/Linux/AIX/HP UNIX & Windows

Database : MySQL/MS SQL & Windows OS / Sybase / DB2 / PostgreSQL/MongoDB/SAP HANA

Must Have :

- 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

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

- Experience on OS, Storage, Network and Virtualization activities

- Certification on Primary Technology

JD :

- 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