Senior Oracle Database Consultant Resume
Piscataway, NJ
PROFESSIONAL SUMMARY:
- Over Eight years of extensive experience in the IT industry and throughout worked as an Oracle Database Administrator with EBS and Non - EBS environments. Involved with the databases and EBS implementation projects with ideas in deployment, architecture, designing as per the customer’s environment and need. Activities include installations/patching/upgrading, support to applications & working with Oracle Support; creating SRs/escalations (as needed), proactive space management, backup/recovery & cloning, networking, monitoring & managing of users, performance tuning of databases & applications, worked on almost all the different variants of Oracle databases; 12c/11g/10g/9i; and Oracle EBS; 11i/ 12.0/12.1/12.2 .
- Have hands on SQL, PL/SQL, SQL*Plus, Sql Developer, RAC, Data Guard/ Standby Database (Physical/Logical), DataPump, Oracle Enterprise Manager, OMS & Oracle Grid, Installation, Patching, Cloning, Upgrade, Personalization, Customization, Data Loading, Interfaces, Shared Application File System, PCP.
- Strong Understanding of different flavors of UNIX/Linux; OEL/RH, HP UNIX, AIX, Sun Solaris.
- Team player with excellent communication and problem solving skills; helps to bridge the gaps, between all the relevant parties; IT on-site/off-site, or even non-IT-business/management/leadership
- Experienced in designing, implementing, managing & conducting; al sessions, & mentoring DBAs, junior DBAs/developers, end users, as well as clients too.
TECHNICAL SKILLS:
Databases: Oracle 12c, 11g, 10g, 9i, MS SQL Server
Languages/Scripting: SQL, PL/SQL, Linux/Unix Shell
Oracle Products: OEM, RAC, Data Guard with and without DG Broker, LogMiner, CDC/Streams, Fine Grained Access Control, Data Pump, Sql Developer, Oracle Applications 11i/ 12.0/12.1/12.2, ASM, Grid, Oracle Diagnostics and Tuning Pack, Enterprise Manager/Grid Control, RMAN, AWR, SQL* Loader
OS: Oracle Linux, AIX, HP UNIX, Solaris, Windows, ESXi
Designing tools: Form Builder, Report Builder
Other Applications: TOAD, Exceed, TeamViewer, PLSQL Developer, VNC, Putty
Hardware: OVM, Dell, IBM Blade Servers, SUN Sparc
s: OCE 11gR2 RAC & Grid, OCP DBA 11gR2/10g/9i, OCP Apps-DBA R12
Milestones: Multiple Full Life Cycle of EBS R12 Implementations, EBS Database Upgrade from 9.2.0.8 to 11.2.0.4, EBS Platform Migration from Windows to Linux, Multiple Database High Availability Deployments, Backup/Recovery Planning for different clients.
PROFESSIONAL EXPERIENCE:
Confidential, Piscataway, NJ
Senior Oracle Database Consultant
Responsibilities:
- Oracle EBS 12.1 and 12.2 Vision Instances.
- Deployment of MS SQL Server 2008 Databases.
- Migrated Oracle Database 11gR2 from 32-bit to 64-bit.
Confidential, Boston MA
Oracle Financials Applications DBA
Responsibilities:
- Install 12c Single Instance database for Oracle Instantis Enterprise Track v9.
- Install 12c 2-node RAC Instance database for Oracle Instantis Enterprise Track v9.
- OATM Migration in Oracle EBS 11i Instance.
- Scheduled RMAN backup jobs.
- Monitor jobs status.
- Upgraded Oracle EBS 11i database from 9.2.0.8 to 11.2.0.4.
- Configured Oracle Database for Oracle Instantis Enterprise Track.
- Provide technical support of oracle database and EBS environments.
- Technical-DBA support in Oracle Instantis Implementation.
- Configure Single instance and RAC environments.
- Maintaining daily DB jobs for Oracle Instantis-Database.
Confidential
Oracle Applications DBA
Responsibilities:
- Provide Production Support for all the Oracle EBS and Oracle Database Instances.
- Provided technical support of oracle to 28 business units of the group.
- Configured Oracle EBS R12 environment with back-end database 11gR2 Real Application Cluster.
- Deployed backup plan using RMAN.
- Migrated 2 companies from 11i environment to new R12 environment.
- Managed DB backup using NetApp and HP EVA storage backup feature.
- Managed Oracle VM Servers.
Confidential
Senior Oracle Support Analyst
Responsibilities:
- Regular monitoring of the whole deployed Oracle Database/Application environment.
- Provide Production Support for clients for their Oracle EBS and Oracle Database Instances.
- Configure Oracle Database 10g Dataguard with EBS 11i application.
- Migrate Oracle Database 10g 4k block size to 8k.
Confidential
Oracle Applications DBA
Responsibilities:
- Supported 1 complete Full Life Cycle of EBS R12 Implementation.
- Handle Production system support, covering a wide range of services to user assistance, configuration and system monitoring and continuous improvement.
- Supported Production issue for the Interface Programs between Oracle and SQL Server database.
Confidential
Oracle Applications DBA
Responsibilities:
- Supported 3 complete Full Life Cycle of EBS R12 Implementation.
- Handle Production system support, covering a wide range of services to user assistance, configuration and system monitoring and continuous improvement.
- Monitoring and resolving the issues on critical daily transaction interfaces.
- Migrated EBS 11i Database 9i 32-bit to 10g 64-bit.
- Migrated EBS 11i Database 10g from Windows to linux.
- Migrated EBS 11i Application from Windows to Linux.
- Migrated EBS 11i Application and Database from Single-Node to Multi-Node environments.
- Configuration, system monitoring and continuous improvement in Oracle EBS Production environment.
- Monitoring and resolving the issues on critical daily transaction interfaces.
- Upgraded their Oracle ERP Application from 11.5.8 to 11.5.10.2