Lead Oracle DBA - Diverse Linx

Lead Oracle DBA

Location: O'Fallon, MO (Onsite)

Fulltime
Need Lead exp 4years with total 9+Years exp
Tech Expertise:

• RAC Clusters
• Golden Gate
• Data Guard

Required Skills:

• • • 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

Technical Skills

• 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

Secondary Skill

• OS - Solaris/Linux/AIX/Client UNIX & Windows
  Database - MySQL/MS SQL & Windows OS / Sybase /
• DB2 / PostgreSQL/MongoDB/SAP HANA