We provide IT Staff Augmentation Services!

Infrastructure Specialist - Database Services Resume

EXPERIENCE SUMMARY:

  • Having more than 16.09 years of experience in Oracle Database Administration including Oracle Apps 11i/R12 E - Business Suite administration mostly in operations
  • Managed the operations and build work, preparing documents, meetings, reviews & discussions, process improvements and providing RCAs.
  • Involved in various solution, designing and architectural work.
  • Hands-On experience in 10g/11g/12c RAC Installation & Management.
  • Worked on OEM Grid Control.
  • Worked on RMAN to perform backup & recovery operations.
  • Knowledge in Database Administration concepts as well as oracle architecture.
  • Worked on Database Performance Tuning.
  • Oracle Database Migration or Backups using Export/Import.
  • Oracle Database Up-gradation.
  • Worked on Oracle RAC, Data-guard, Streams and Clone databases.
  • Worked on Oracle 11i Apps administration for around 2.0 years.
  • Installing, Cloning, patching & upgrade Oracle 11i Apps.
  • Automation using scripting in Shell, Batch and Ansible.
  • Worked on MySql/Mariadb, DB2 databases.
  • Basic idea in TimesTen In-memory database, Oracle VM, Oracle Golden gate, Oracle Exa-data.
  • AWS cloud understanding and Knowledge of Ansible, Python, Chef & Docker.
  • Microsoft Certified Azure Fundamentals. (AZ 900).
  • Microsoft Certified Azure Solution Architect Expert. (AZ 303 & AZ 304).

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c.

Operating Systems: Windows, Linux, IBM AIX, HP-UX, Solaris.

Automation: Ansible, Shell & Batch script.

Tools: OEM Grid control, SQL-Developer, TOAD.

ERP: Oracle Apps 11i/R12 E business suite.

Cloud: Microsoft Azure Cloud.

PROFESSIONAL EXPERIENCE:

Confidential

Infrastructure Specialist - Database services

OS: Linux VM

Database: Oracle 12c/18c/19c/20c.

Automation: Using Shell scripting .

Responsibilities:

  • Installation & Configuration, PSU patch, Up-gradation from 12/18c to 19c.
  • Managing all backups, restore & recovery operations.
  • Creating and managing standbys databases for DR & HA.
  • Performing DR test switch-over & rollback across all the clients individually.
  • Involve in whole transition and handover to BAU after project go-Live.
  • Involve in automation through Shell for Monitoring standby gaps, health check, backups.
  • Performing multiple cloning, trouble shooting and resolving all issues.
  • Providing solution for replication/cloning as Snapshot Standby DBs.
  • Providing solutions and designing of Oracle pluggable databases and its up-gradation from Non CDBs/PDBs.
  • Automation of DR Testing Switch over and rollback -with shell scripting and integration with Anisble.
  • Part of Azure Guild -Preparing Use cases in Azure Cloud-
  • Azure Sql Server, Data Factory, Data Lake, Synapse, Cosmosdb.
  • Managed Data Security in Azure sql server.
  • VM creation and Virtual Networks.
  • Connectivity between two Vnets using NSG.
  • Log Analytic.

Confidential

Infrastructure Architect - Database services

OS: Linux & Windows VM

Database: Oracle 11g/12c.

Automation: Using Ansible, Shell and Batch script.

Responsibilities:

  • Supporting IMI Regulatory clients
  • Installation & Configuration of Oracle 11g/12c database, PSU patch.
  • Managing all Maria-db databases with Galera Cluster.
  • Involve in whole transition and handover for BAU and new projects.
  • Involve in Automation through Ansible-Playbooks for Installation/ patching / health check, Cassandra-setup etc.
  • Involve in automation through Shell/Batch for health check and backups.
  • Execution of Handover to US team.
  • Involved in DR and compliance activity with respect to audit, managing all NCIs & RCPs.

Confidential

Oracle Database Subject Matter Expert (SME)

OS: Linux VM

Database: Oracle 11g/12c.

Application: Oracle EBS 11i/R12

Responsibilities:

  • Supporting Off-site to Confidential.
  • Installation & Configuration of Oracle 11g/12c database, PSU patch.
  • Installation of IBM DB2.
  • Involved in Migration of Oracle EBS from 11i to R12 and DB from 11g to 12c.
  • Automation through Shell- Created MEF extractors tool in Shell for fetching all user id for user access management, extractors are uploaded in IBM W3.

Confidential

Oracle Database Subject Matter Expert (SME)

OS: IBM-AIX, Linux VM

Database: Oracle 11g & 12c RAC.

Responsibilities:

  • Installation & Configuration of Oracle RAC 11g/12c, around more than 40 RAC installations & PSU patch completed in Server Build Team.
  • Implementing GSD/security as per SA&D process.
  • Support in process improvement in SA&D and server build.
  • Patching RAC Databases.
  • Up-gradation of RAC (GI & DB) databases.
  • Installing and configuring Standby-DR & BCV for production databases.
  • Support in Operation team within 24*7 support as and when required and being on standby.
  • Resolving various Sev-1 issues in operations like B&R, Block corruption/recovery, Hung & Slowness issues, CRS timeout etc.
  • Support in backup strategies, OEM reporting and scheduling & maintaining alerts etc.

Confidential

Sr. Oracle DBA

OS: IBM-AIX, Sun Solaris, Windows etc

Database: Oracle 8i, 9i, 10g, 11g, 12c.

Responsibilities:

  • Designing of a database for NPD & Finnonepro Projects.
  • Migration of databases. (Oracle9i to Oracle10g, Oracle10g to Oracle11g, 12c etc.)
  • Solving daily database requests, installation, creation, up-gradations, trouble shooting, Performance tuning of databases.
  • Installation, configuration & troubleshooting of Oracle SQL-Developer.
  • Knowledge of Oracle Streams implementation.
  • Knowledge of Oracle VPD implementation.
  • Oracle 11g, 12c installation & configuration, overview of new features.
  • Other focus areas:-
  • Oracle TimesTen In-memory Database installation & configuration.
  • Oracle VM (server & manager) installation.
  • Oracle Golden Gate installation & configuration.

Confidential

Oracle Apps DBA

OS: IBM-AIX 5.2

Database: Oracle 9i (9.2.0.6 & 9.2.0.7) RAC (3-Nodes)

Application: Oracle 11i (11.5.8 & 11.5.10) Multi Node

Modules: CRM, Finance, HRMS, OLM etc.

Responsibilities:

  • Managing Oracle databases and Oracle 11i applications on IBM-AIX
  • Managing, Hot & Cold user managed Backups.
  • Building & Maintaining Standby database for CRM application and Oracle E-mail
  • SQL Tuning, checking Explain - Plans, creating Trace files, running TKPROF.
  • House Keeping activities like Gather Statistics, Index rebuilding, Table Re-organizing.
  • Responsible for implementing RFC’s.
  • Working with adpatch, adadmin, adctrl, adsplice and opatch utility.
  • Administrating, starting & stopping Concurrent Managers, Forms & Report Server etc.
  • Changing/Monitoring Concurrent Manager Work Shifts etc.
  • Changing APPLSYS, Oracle User and Application User password through FNDCPASS.
  • Compiling procedures, packages, function and forms (f60gen) etc.
  • Responsible for all User Access activities and involved in solving application related problems.
  • Changing System and User Profiles at different level in Application.
  • Registering Printers and solving Printer problems at Application and OS level.
  • Applying patches according to and as per the requirement.
  • Doing Log Mining of archives.
  • Oracle CRM and financial cloning.

Confidential

Sr. Support Executive

OS: HP-UX

Database: Oracle 9i (9.2.0.6) Standalone

Application: Oracle 11i (11.5.8).

Modules: Finance & HRMS.

Responsibilities:

  • Managing Oracle database and Oracle 11i application on HP-UX.
  • Doing RMAN, Hot & Cold user managed Backup, Recovery & Restorations.
  • Making backup & recovery policies.
  • Transferring and verifying backups on tape through HP-UX SAM GUI tool.

Hire Now