OBJECTIVE:

• With the knowledge in the field of Database coupled with my expertise in Oracle Database 9i, 10g, 11g,12C Database Administrator seeking a long - term career in the field of Database management systems in a professional organization.

SUMMARY:

• Having 10 years of experience in Oracle Database Administration and 18 months of experience in MSSQLSERVER, MYSQL and Postgres. Provided support to 300 plus Production, Test and Development Instance environment.
• Sound understanding of database requirement with a global mindset, and strong quantitative and conceptual abilities with strong database management skills.
• Administrated database of various sizes from 40GB to 110TB.
• In-depth knowledge in Oracle 12c RAC/11g RAC /10g /9i Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery, Patching and cloning.
• Implemented 11g R2 RAC production environment Worked on 11i EBS environment DB upgrade from 10g to 11g R2 and conversion of a single node 11g Database to a 5-node RAC cluster.
• Database migration from non-Exadata to Exadata and MS SQLSERVER to Exadata
• Sound knowledge on Exadata X4-2/X3-8/X3-2/X2-2 Administration.
• Solid understanding of key Exadata features like Hybrid Columnar Compression, Smart Flash Cache, Storage Index, Storage Management & Administration.
• Implemented HCC for Historical tables gain space around 4:40 ratio.
• Hands on experience on quarterly Patching Oracle Exadata X4-2/X3-8/X3-2 Full and Half Rack.
• Installed and configured of Oracle Enterprise Manager Cloud Control 12c for Exadata monitoring
• Experience in Design, Creating and Maintaining the Oracle Database.
• Exposure on managing Tablespace, Rollback segments, Archives.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red-hat Linux AS/ES/4/5/6/7.
• Hand on Experience in 11.2.0.4 GI and DB Upgrade.
• Experience in Performance Tuning of SQL statements and Database using tools/reports like Explain plan, ASH/AWR/ADDM reports, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, and STATSPACK.
• Experience in Capacity Planning and Space Management.
• Expertise in RMAN Configuration with backup servers like TSM, Veritas etc.
• Expertise in Alert Monitoring and Ticketing.
• Installation and configuration of MYSQL and Postgres in AWS.
• Hands on experience on golden gate implementation configured 11g and 10g terminal version non-Exadata and Exadata environment.
• Configured GoldernGate Downstream Mining and integrated component for Active-Passive and Active-Active.
• Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.
• Installing and configuring Oracle GoldenGate agent with OEM GoldenGate Plugin.
• Experience on creating Active stand by and setup Datagaurd for DR setup.
• Hands on experience in Implementing Oracle Revenue Management and Billing(ORMB 2.3).
• Hands on experience in ORMB cloning and patching.
• Hands on Experience on ORMB Coherence upgrade for 2.3 to 2.6.
• Hands on Experience on 11g OBIEE installation and integrated with ORMB.
• Experience on Python scripting.
• Hands on experience on administration of Hadoop in Cloudera.
• Worked on Global Data warehouse, OLTP, OLAP prod and dev environments and maintained and managed various sizes of database ranging from 500 GB to 50 TB on Linux 6.
• Managing and directing offshore team for Project and operation.
• Track record of providing excellent management of workload, strong troubleshooting and problem-solving skills.
• Provided support for implementing and upgrading various new and third party application in client site.
• As a team player with strong communication, relationship management and analytical skills and ability to meet deadlines.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, MSSQLSERVER, MYSQL, Postgres

Platforms: RHEL ES/AS/4/5/6, Sun Solaris 10/9/8, Windows 2012r2/2000/XP

Programming Languages: SQL, PL/SQL, C, C++, Shell Scripting, python

Tools: /Utilities: TOAD, PL/SQL Developer, SQLPLUS, STREAMS, GOLDEN GATE, VERITAS, TKProf, RMAN, Data Pump, tidal, MYSQL workbench, DB visualize, Mobaextra. Backup Tool IBM Tivoli storage Management, Commvault Backup Tool and RMAN

Hadoop Framework: HDFS, Map Reduce, Impala, Hive, Sqoop, zookeeper, Solr, flume, Hue.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Oracle DBA

Environment: Oracle core 11g in Linux 6.

Responsibilities:

• Performing Day to day DBA activities
• Working with Different teams and gathering the requirements for the project.
• Responsible for end to end execution of projects.
• Managing 60 TB of Datawarehouse database exist in Exadata X4-2 half rack.
• Handling 60TB of Datawarehouse db. in Oracle EXADATA X4-2 (DMA with knowledge on Cell Administration).
• Installed and configured 11g Grid Control and database for PROD/QA/DEV environment.
• Installed and configured of Oracle Enterprise Manager Cloud Control 12c for Exadata monitoring.
• Worked on X4-2 RACK consolidation. Combined 2 quarter Rack to half RACK.
• Hands on experience on disk and other component replacement without DB downtime.
• Implemented IORM, DBRM to cap the resource usage on storage/database nodes on EXADATA X4-2.
• Hands on experience on adding new serials to Platinum gateway server.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
• Quarterly CPU patching with detailed patch analysis.
• Automate DB cloning for QA and Dev environment based on the user requirement.
• Implemented Hybrid Columnar Compression for history tables.
• Installation and configuration of oracle transparent gate for MS SQLSERVER.
• Hands on experience on SSIS package creation and transfer date to Oracle from Informix and MSSQLSERVER 2014
• Worked on Oracle RAC implementation in Amazon Web Service(POC).
• Hands on experience in DB restoration in MSSQLSERVER 2014.
• Automated the data transformation from Informix to Oracle
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Handled MYSQL and Postgres Database in ASW.
• Spine-up EC2 instances and used S3 for External storage.
• Installed and configures MYSQL and Postgres in AWS.
• Managing Hadoop in cloudera.
• Import new users through Hue.
• Created scripts for Data ingestion and compaction.
• Hand on experience on python scripting.
• Schedule Data ingestion using spark-submit.
• Configured GoldernGate Downstream Mining and integrated component for unidirectional and Bi-Directional replication.
• Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.
• Monitor and fix GoldenGate Extraction and replication conflict issues
• Hands on experience installing Anaconda 3.5 in Hadoop cluster and created new environment for users.
• Implemented SSIS 2008 ETL processes to load data from source files to target tables
• Created complex SQL views and stored procedures to join multiple tables for contract data interface files.
• Created database link between Oracle 10g and SQL Server 2005.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Worked on configuring SQL Server with minimum privileged access.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008.

Confidential

Sr Oracle DBA

Environment: Oracle core 10g,11g and Oracle Apps 11i and Linux.

Responsibilities:

• Performed DBA functions and handling/managing a team of 12 members
• Worked with highly skilled people, experts in various streams of DBA knowledge
• Installation, configuration, and maintenance of Oracle 10g on RHEL 4,5,6 and 11g on RHEL 5,6.
• Responsible for setup and implementation of 8 node RAC on Oracle 11gr2 and 12c.
• Configured ASM with high redundancy for high availability.
• Implemented and managed Oracle Data Guard on Oracle 10g.
• Upgraded the Oracle 10g to the latest Oracle 11g Release 2 by applied patches. Used both patch sets and interim patches.
• Upgraded databases using DBUA.
• Solid Exposure to Exadata Configurations including X2-8, X3-2, full rack, half rack and Qtr rack and X3-8.
• Solid understanding of key Exadata features including Hybrid Columnar Compression, Exadata Smart Flash Cache, Exadata Storage Index and Exadata Storage Management & Administration.
• Oracle Exadata server & database management (DMA with knowledge on Cell Administration, Linux Administration and management of other Exadata components like InfiniBand).
• Implemented IORM, DBRM to manage resource utilization on EXADATA v2/x2 for ETL jobs and Application usage.
• Applied quarterly Patches on Oracle Exadata X3-8/X3-2 Full and Half Rack.
• Installed and configured GolednGate 11.2.1 and 12.1.2 software.
• Hands on Experience in configuring Golden Gate on Exadata Machines for data Replication..
• Configured GoldernGate Downstream Mining and integrated component for Active-Passive and Active-Active.
• Configured GoldenGate High availability using oracle DBFS and Active DataGuard.
• Experience on Performance tuning of Oracle GoldenGate process to achieve zero lag time.
• Installed and configured GoldenGate Agent to work with OEM GoldenGate Plugin.
• Hands on experience in Implement OEM12.
• Hands on experience in Implementing Oracle Revenue Management and Billing(ORMB 2.3).
• Hands on experience in ORMB cloning and patching.
• Hands on Experience on ORMB Coherence upgrade for 2.3 to 2.6.
• Hands on Experience on OBIEE integration for ORMB.
• Hands on experience in implementing OBIEE installation and creating data source.
• Configured standby solution for Oracle Ebusiness Database and applications.
• Production Support experience in Hyperion.
• Troubleshoot issues which arise during patching.
• Daily health check and proactive monitoring of Production instance.
• Implemented Data Guard on production database.
• Daily Database clone using RMAN duplication and Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process.
• Sysadmin activities like user creation, responsibility assignment, profile value change etc.
• Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc.
• Support to general technical issues faced by developers.
• Support Sev-1 Oracle service requests created for release bugs.

Sr DBA

Confidential

Environment: Oracle core 10g,11g and Oracle Apps 11i and R12,Solaries (Sparc 64).

Responsibilities:

• Quarterly CPU patching with detailed patch analysis.
• Troubleshoot issues which arise during patching.
• Prepared patch impact analysis and execution plan for Min baseline patches (30 products, 100 patches) for Extended Support on E-Business suit 11.5.10.
• Resolve the concurrent manager, concurrent programs issues and performance issues related to concurrent programs
• Daily health check and proactive monitoring of Production instance.
• Monitor the Application System with Oracle Applications Manager (OAM).
• Cloning the oracle apps instances (scheduled or on-demand) from prod to test using rapid cloning process.
• Modify and track customizations on template files during Autoconfig customization.
• Sysadmin activities like user creation, responsibility assignment, profile value change etc.
• Generate diagnostic reports using tools like SQLT, TRACEANALYZER, TOAD, Oracle Diagnostics etc
• Created shell scripts to automate tasks like patch merging, health checks, post-clone steps, directory clean-up etc.
• Support to general technical issues faced by developers.
• Support Sev-1 Oracle service requests created for release bugs.
• Implement Datapump for 11.2.0.2 in UA environment and refresh database using DP backup.
• AWR and ASH report creation for analyze performance issues.

Confidential

DBA

Environment: Oracle 10g, sqldeveloper,linux CentOS,RMAN,Xshell

Responsibilities:

• Installation and configuration of Oracle for production server under Linux CentOS environment.
• Configure datagaurd physical stand by for production database.
• Upgrade quality server using database upgradation assistant from 10.2.0.1 to 10.2.0.4
• Restored PROD database on server crash.
• Test Recovery of Production database twice in a week on quality server .
• Configure Rman backup with remote server
• Applying CPU critical patch update on production server for every 3 months
• SQL tuning for application developer team improve performance of loads.
• Implemented table partitioning both in Mysql and Oracle to improve performance and data management.
• Taking cumulative backup for both the production and quality server.
• Configure streams replication for Horse racing schema on 10g in Quality.

Confidential

Oracle Apps consultant

Environment: Oracle core 9i,10g Toad, Oracle Apps 11i and Linux.

Responsibilities:

• E-Business suite R12 Installation and configuration.
• Installation and configuration E-Business suite and upgraded of Oracle database from 9i to 10g(10.2.0.2).
• Configure datagaurd physical stand by for production database.
• Applied CPU patch for database on quarterly.
• User creation and allocating Quota for the users as per server resource availability .
• Granting specific privileges and roles to the users.
• Implement Datapump for 10.2.0.4 in UA environment and refresh database using DP backup.
• Daily incremental hot backups and weekly cold backups using RMAN.