SUMMARY

• Oracle certified professional wif 9 years and 6 months of technical experience as Oracle Core DBA, specialized in 24/7 support on Production, Development and implementations on Oracle 9i / 10g / 11g and 12 c databases on various platforms.
• Experience in implementing EXADATA.
• Assisted in management and database administration of Oracle database applications on Exadata platform.
• Experience in migrating databases to EXADATA.
• Experience in managing SAP databases wif BRTOOLS.
• Experience in refreshing SAP databases from production to non - prod databases.
• Experience in creating and managing databases wif ASM.
• Experience in upgrading and migrating databases from non-ASM to ASM.
• Strong experience as an Oracle Applications DBA worked in multiple platforms like Linux, AIX, HP-UX and SUN Solaris and flavors of UNIX.
• Strong experience in supporting and managing PROD, DEV, TEST, SIT & UAT instances and Oracle Applications environments of varied complexity.
• OEM 11g & 12c Installation and configuration
• Backup/recovery methods using RMAN/user-managed.
• Export/Import and DataPump.
• Oracle GlodenGate installation and configuration.
• Experience in Installation, Configuration, Maintenance, Administration, Node addition and Troubleshooting Oracle Real Application Cluster (RAC).
• Experience in Oracle security advanced features like TDE using encrypted tablespaces and oracle wallet.
• Experience in converting Non-RAC to RAC database.
• Experience in Configuration, Maintenance, Administration & Troubleshooting Oracle Dataguard.
• Oracle Database migration from windows to Linux.
• Experience in Implementation, upgrades, Production support, Acquisition and De-commission databases.
• Complete knowledge of the oracle tables and database objects
• Oracle Certified 11g Database Administration (OCP)
• RAC, Data Guard setup and Configuration Expertise
• Installing, Configuration and Maintenance of OEM and Grid
• Experience on SQL Scripting, PL/SQL Programming
• Experience in setting up and troubleshooting on Oracle Gloden Gate Replication.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Shell scripting to automate general maintenance activities.
• Strong experience in preparing DBA related documentation.
• Experience in working wif 12c Databases like installations, migrations and RAC 12c Installations
• Scheduling/Monitoring of jobs/processes/logs files and running processes on priority.
• Having 5+ years of experience in Database Administration for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005/2000.
• Experience in Installing and configuring SQL server 2008, 2008 R2 and 2012.
• Good technical background along wif the ability to write effective documentation and specifications.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Worked extensively on Clustering and server consolidation.
• Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server wif minimum privileged access.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2014/2012 migration from SQL Server 2008/2005.
• Maintained individual service accounts for SQL Server services on cluster wif different Security groups to raise security mark.
• Experience in Batch processes, Import/Export, Backup, Database Monitoring tools and Application support.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support
• Having 3+ years of experience in Oracle EBS Application (11i & R12.1,12.2) Installation, Configuration, patching, cloning, upgrade and system administrator responsibilities.
• AD utilities like adpatch, adadmin, adctrl, adconfig, adident...etc.
• Patching 11i & R12 Applications using "adptach".
• Patching Oracle Database using "opatch".
• Online Patching Oracle Application 12.2 using “adop”.
• Cloning of Oracle EBS 11i & R12 Applications and its Databases.
• Strong experience in Oracle Applications 11i & R12 System Administration tasks.
• Experience in providing front-end Application support and backend Database support.
• Code migrations using FNDLOAD.
• Excellent knowledge in generic tools, Oracle Metalink and Service Request Process
• Troubleshoots post production issues.
• Experience in performance tuning of EBS Applications and Databases.
• Very flexible to adapt the new environment and quick learner.
• Excellent work allocation and team management skills
• Good demonstration skills and Strong verbal, written and interpersonal communication skills.
• Good Domain knowledge on core banking.

TECHNICAL SKILLS

Oracle Application: 11i, R12.1, 12.2

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

Languages: SQL, PL/SQL

TOOLS: TOAD, SQL Developer, BRTOOLS

Operating Systems: UNIX, Linux, Solaris 7/8, HP-UX, AIX, Windows NT/2000

Hardware: HP ProLiant servers, IBM Blade servers & Oracle Exadata

Data Analysis: MS Word, MS Excel, MS PowerPoint

Other RDBMS: SQL Server & PostGre SQL

PROFESSIONAL EXPERIENCE

Confidential, BILLERICA, MA

Sr. DBA

Environment: Oracle Exadata X5-2, RHEL 4, 5, 6, Oracle 9i, 10g, 11g, 12c, SQL Server 2005, 2008 & 2010, Gloden gate 11g, SAP databases (BRTOOLS), Oracle EBS R12, 11i.

Responsibilities:

• Installation and maintenance of Oracle Application EBS R12 on Linux Servers for Production, Development and QA Environments.
• Converted EBS Standalone database to RAC and configured DR.
• Installed 11g R2 3 Node RAC and configured single node DR for the same.
• Installed 12c 2 node RAC and configured databases in the cluster.
• Managing Databases wif ASM.
• Upgraded and migrated databases from non ASM to ASM.
• Participated in migrating databases to Exadata system using oracle active standby.
• Trained in managing Exadata servers.
• Applying ASM rolling patches.
• Implemented TDE using Oracle Wallet and created tablespaces wif encryption for couple of clients in Parexel.
• Upgrading the Application databases by applying interoperability patches
• Applied various types of patches for Oracle Applications
• Cloning of Oracle E-business suite using rapid clone
• Administration of concurrent managers and troubleshooting issues related to Concurrent Managers
• Implemented the Custom module in Oracle Applications
• Maintained Oracle Application Instances using utilities like adadmin, adctrl, adconfig, admerge, adpatch, adrelink
• Daily health checks of Application Tier Services and Database for availability
• Relinking the executables, generating forms, jar files, validating apps schema, compiling the invalids by using adadmin
• Managing various schemas passwords by using FNDCPASS
• Setting up the gloden gate 11.2 for uni-directional replication.
• Adding tables to the existing gloden gate setup.
• Setting up the IDR (Informatica Data Replication) to extract data in the flat files in intervals.
• Installed, configured and utilized Oracle Enterprise Manager for monitoring events
• Creating Application Users, Managing apps password, application user passwords and schema passwords
• Performing day-to-day activities such as creating users/roles/schemas/tables/views/indexes and running the scripts given by the clients
• Virtually lead Operational/offshore DBA team, assessing their skillset and assigning appropriate work to the team.
• Managed SAP databases wif BRTOOLS.
• General administration tasks on SAP databases.
• Tables re-org using BRTOOLS, tablespace management using BRTOOLS etc.
• Responsible for taking regular backups including cold / hot backups, Export / Import of database, using RMAN, and recovery in case of disasters.
• Installed and configured SQL server 2008, 2012.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases.

Confidential

Sr. Oracle DBA

Environment: IBM AIX, SUSE Linux, HP-UX, Oracle 9i, 10g & 11g R2 RAC. Glodengate 11g

Responsibilities:

• Upgraded DB from 10.2.0.1 to 10.2.0.4 and 10.2.0.4 to 11.2.0.3
• Monitoring and configuring RAC Environment using by SRVCTL.
• Implemented oracle high availability solution using oracle 11g PHYSICAL STANDBY.
• Setup RMAN catalog for all the Oracle databases.
• Implemented Gloden gate bi-directional replication on couple of schemas by analyzing the requirement.
• Troubleshooting on capture & replication process on Gloden gate
• Implemented 2 nodes RAC 11g release 2 on SUSE Linux servers for Production setup.
• Installed Oracle 11g R2 and created databases on SUSE Linux Servers for development and Quality setup.
• Performing database Refresh from Prod to DEV/QA/TEST servers using hot backups and schema refreshed wif EXPDP/IMPDP.
• Monitoring Alerts of all the databases.
• Monitoring the jobs to ensure the jobs are running in time and troubleshooting long running jobs.
• Space Management of Databases.
• Restoration Mock Drills to ensure the backup stability.
• Capacity Planning depending upon the periodic growth of the database.
• Backups Validation and rectifying the issues in the failed backup scripts.
• Applying CPU patches on the databases.
• Table re-orgs to gain the space and performance of the database.
• SQL Query tuning.
• Implemented a shell script to refresh non ASM development database from ASM production DB and scheduled the same for every week.
• Automated purging old data by embedding PLSQL procedure wif shell script.
• Implemented streams for couple of tables across the data centers.
• Participated in regular DR Drills to ensure proper working of standby databases.

Confidential, SANTA CLARA, CA

Oracle Apps & Core DBA

Environment: RHEL 5, HP-UX, Oracle 81, 9i, 10g. Oracle EBS 11i

Responsibilities:

• Checking Alert log, Apache log, and Concurrent Manager log files daily
• Converting Single Instance to Oracle 2 Node RAC 11g and upgrading databases
• Worked wif various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install, FNDCPASS, f60gen, CONCSUB.
• Troubleshooting various issues during day-to-day activities
• Administering and maintaining Oracle databases (Production, Test and Development)
• Clone the Test and DEV instance monthly once for resolving PROD issues and applying patches
• Administrating and responding to Oracle Tar’s
• Performing system administration Activities
• Memory and SQL Query tuning of the database.
• Managed SAP databases using BRTOOLS.
• Tablespace management, segments reorg etc.
• Performed many SAP database refreshes from prod to non-prod databases on a monthly basis.
• Managed around 100 SAP databases dat includes prod and non-prod databases.
• Managed Table Spaces for user data, temporary data and undo according to business needs
• Installed and managed SQL server 2005, 2008.
• Migrated all databases from HP-UX to Linux wif minimal downtime.
• Backups Validation and rectifying the issues in the failed backup scripts
• Database/Schema refreshes using data pump.

Confidential

Oracle Core DBA

Environment: RHEL 4 & 5, Oracle 10g wif RAC.

Responsibilities:

• Installation of Oracle Software, Creation, Configuration and Administration of Oracle databases for Oracle 10g.
• Responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities
• Implemented 2 nodes RAC 10g release 2 on Linux servers for Production setup
• Database upgrade from 10.2.0.1 to 10.2.0.4.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY
• Cloning & Refreshes wif RMAN
• Space Management of Databases
• Managing Oracle databases through Oracle 10g.
• Partitioned the tables for better performance and maintainability
• Database performance tuning using AWR, ADDM and ASH reports
• Query tuning using EXPLAIN PLAN and TKPROF
• Configured and monitored RAC Environment using by SRVCTL
• Refresh development and test database on demand
• User Management which includes user creations, profiles, roles and privileges.

Confidential

Oracle Core DBA

Environment: RHEL 4 & 5, Oracle 10g

Responsibilities:

• Database Refresh from Prod to DEV/QA/TEST servers using hot backups and schema refreshed wif EXPDP/IMPDP.
• Restoration Mock Drills to ensure the backup stability.
• Capacity Planning depending upon the periodic growth of the database.
• Backups Validation and rectifying the issues in the failed backup scripts.
• Apply CPU patches on the databases.
• Table re-orgs to gain the space and performance of the database.
• Memory and SQL Query tuning of the database.
• Performance tuning by updating statistics, Index rebuild, AWR and ADDM reports.
• Implemented Automatic Data Archival process.
• Implemented Physical Standby Database.
• Implemented some shell scripts for some regular maintenance activities.
• Implemented Reports Database using streams replication.

Confidential

Oracle Core DBA

Environment: RHEL 4 & 5, Oracle 10g

Responsibilities:

• Installed Linux OS and Oracle 10g on the OEM Servers, created database and all the logical objects required for application
• Data Conversion, Data Mapping, Data Extraction, Data Modeling, from Legacy System to ORACLE Database
• Extensively involved in Database cloning manually as well as using RMAN Duplicate
• Created indexes and partitions as the part performance tuning the SQL queries
• Setup RMAN catalog for all the Oracle databases
• User creations, performance issues, connectivity issues and access issues.
• Upgraded the databases from 10.2.0.1 to 10.2.0.4
• Configured Client-server communication using the Oracle network
• Implemented Backup and recovery strategies using various tools like logical backups, cold backups and RMAN
• Studied and analyzed legacy system database objects and there by migrated data from UMS system wif SQL Scripts using DB links
• Application Build and change Management