SUMMARY

• Experience in configuring and managing Oracle Real Application Cluster (RAC) with ASM, Data Guard for Oracle High Availability.
• Experience upgrading Oracle databases from 9iR2 to 10gR2, 9iR2 to 11gR2 and 10gR2 to 11gR 2 11.2.0.2.2 on RHEL, AIX and Solaris 10 SPARC 64 - bit systems.
• Experience in Oracle Patching for 9i, 10G and 11G.
• Experience as Oracle security DBA- worked extensively in rolling out auditing across a wide environment.
• Real time experience in remediating all the Oracle DBs to comply with industry security standards.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Proficient in tools like Teradata Administration , Performance Monitoring/Tuning using tools such as Teradata Manager, Viewpoint, TASM, TD Administrator, TDWM, PMON, DBQL and other TD tools
• Error handling and trouble shooting of Teradata load/unload utilities like FastLoad, MultiLoad, FastExport, Tpump, Arc/Restore. Working closely with DEV team and assisting them in data modeling
• Proficient with concepts of Postgresql database
• Experience in migrating databases from Teradata to PostgreS
• Configuration and Management of Data Guard.
• Experience creating and configuring databases using oracle 12c for both CDB and PDB .
• Experience Creating databases using oracle 12c non CDB architecture .
• Experience upgrading databases from 11g to 12c
• Experience creating Pluggable databases (PDB) and attach them to Containers (CDB)
• Experience in performing Mongo DBA operational routines.
• Experience migrating data from different RDBMS databases to Mongo DB
• Experience querying data using JSON in Mongo DB
• Configuring Oracle Golden Gate for replications.
• Experience in using Golden Gate during Disaster Recovery scenario
• Experience in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1 from 11.2 to 12.1.2.1.0
• Experience in setting up DDL/Bi-directional replication between source and target databases. Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1.
• Deep understanding on various features of oracle Exadataand its Architecture
• Experience in configuring Exadata to meet internal security requirements
• Have Relative Professional Experience on Oracle Siebel Architecture.
• Worked extensively on Very Large Databases (VLDB) ranging from 200 GB to 8 TB
• Migrating databases from cross platforms windows, Solaris and Linux.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Planning and scheduling Backups using RMAN (hot, cold and incremental backups)
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Extensively worked on BEA WebLogic 8.x, 9.x, 10.x,11 Server, Apache http Server, Apache Tomcat Server as administrator for Server Installations, Configuration, Application components deployment, performance tuning including troubleshooting and maintenance.
• Excellent working knowledge in configuring multiple Weblogic domains including machines, manage servers, node managers and cluster environments.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX & Windows Environments.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, and SQL TRACE.
• Built and supported Microsoft Azure databases as PAAS (platform as a service) and IAAS (infrastructure as a service).
• Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
• Implemented and administered PostgreSQL databases in Azure/AWS, Private Cloud.
• Solid experience with architecture and Installation of AWSfor RDBMSinstances
• Experience in working with Core AWS Architecture
• Experience working with Aurora DB( AWS RDS) and managing Instances .
• Solid experience in using AWS migration service to migrate RDBMS instances to AWS
• Implementation of Flashback Technology.
• Having experience with Data dictionary.
• Managed Database Structures, Converted Logical data to Physical data, Storage Allocation, Table/Index segments, Rollback and undo segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
• Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience using Erwin as a Data Modeling tool & Designing the ETL processes
• Experienced in loading data from flat files into database tables using SQL*Loader and ETL Tools like Informatica, Dataflux, Data Stage
• Expert in the functional and technical aspects of Oracle E-Business Suite/ Applications 9i, 10g and 11i deployment Requirements, Coding/Development, Customizations, Testing, and Functional User Training.
• Oracle EBS Database Administrator responsible for numerous implementations and upgrades
• Experience in Installing R12.2 Multi node Env for Linux Platforms .
• Work closely with Development, QA teams to recommend appropriate changes to applications and coordinate down time for the conversion.
• Experience in UNIX Shell Scripting for automating the DBA tasks.
• Strong Understanding on Priciples of Dataware Housing.
• Hands on Experience working with Database Resource Management and capacity planning.
• Participated in 24 X 7 on-call rotation, off-hour production problem resolution activities.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.

TECHNICAL SKILLS:

DATABASES: Installation, Implementation, Administration, Upgrading and Troubleshooting of Oracle 8i, 9i, 10g RAC, 11g RAC,11gR2 grid control RAC

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Netca, Netmgr, Oracle Data Guard, Oracle Golden Gate, OEM (GC),Tivoli, RMAN, ASM, Clusterware, Shareplex, EXADATA, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, MobaXterm, ERwin, Enterprise Architecture (EA), TOAD Data Modeler, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM BEA WebLogic Server 8.1/9.2/10.3, 11, Apache Server 2.0.x/2.2.x, JBoss Server 3.x/4.x/5.x, Oracle E-Business Suite

WEB TOOLS: HTML, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

LANGUAGES: SQL, PL/SQL, T-SQL, C, C++, UNIX Shell Scripting, Ksh, bash Scripting, C#, ASP.NET.

OPERATING SYSTEMS: Sun Solaris 5.8, 9, 10, Oracle Applications 11i (11.5.10) on HP-UX, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

PROFESSIONAL EXPERIENCE:

Confidential

Database Analyst

Roles and Responsibilities :

• Experience supporting Oracle R12 E-BusinessSuiteapplication
• Experience in Installation/Migration of OracleE-BusinessSuite 12.2.x....
• Participated in analysis and designing of EXADATA server for production database
• Experience in Installation/Migration of OracleE-BusinessSuite 12.2.x....
• Participated in analysis and designing of EXADATA server for production database
• Worked on implementing PROFILE REDEMEDIATION for database users as a part of compliance team works.
• Responsible for setting up a RMAN report that details all RMAN backups happened to databases for different time intervals
• Have installed and setup Oracle 12c databases on test servers to test the multi tenancy and other new features
• Have Upgraded several 11g databases to 12c for both Non CDB and Multi tenancy Architectures
• Have configured several Container Databases (CDB) and attached some Pluggable Databases (PDB)
• Have setup a physical standby database using oracle data guard 11g.
• Responsible in installing and setting-up Golden Gate from source to target to provide active data replication
• Configured DDL - only replication for down streams using Goldengate DDL specific parameters
• Experience in setting up DDLONLY REPLICATION between source and target databases(downstream oracle databases).
• Experience in configuring Integrated Extract and Co-ordinated Replicat after upgrading Golden gate software to 12.1
• Responsible for Patch upgrades, performance monitoring, responding to Alerts, tuning, creating appropriate Indexes, and creating Incidents with Teradata and assistance/follow up with the CSR for POC environment .
• Involved in installing/testing/documenting the Golden Gate for replication for Teradata systems across the globe
• Created, migrated and managed most Teradatabases using MPP tools .
• Involved in Migrating Teradatadases on POC to PostgreSql databases as a part of POC migrations
• Managed PostgreS database and provided admin support for the same .
• Created EC2 instances for AWS architecture and installed VPC and RDS on top of them
• Migrated Oracle RDBMS instance to AWS architecture and also to aurora RDS using Amazon migration services .
• Responsible for managing AWS architecture services like RDS, VPC and EC2
• Implemented AWSarchitecuture for POC and Installed Dynamo DB to implement No Sql database architecture for POC environment .
• Along with regular Production support work, also participated in 24*7 oncall rotation shifts and off-hour production problem tickets and change requests (CRs)
• Work closely with System Administrators to recommend appropriate Hardware Changes (Server Level mostly for disk spaces) while providing support for both NON-PROD and PRODUCTION environments.
• Participated in various deployments to both non prod and PROD environments
• Expertise in migration and up gradation of Weblogic Server and updating JDK versions, applying patches and installing service packs for Weblogic server.
• Experience supporting Oracle R12 E-BusinessSuiteapplication
• Participated in quarterly release deployments to PROD environment
• Participated in off release deployments to PFX and PROD environments to give support as a DBA.
• Used EXCEED software to address issues related to ASM disk management across all environmets
• Used TOAD as a third party software for analyzing the database issues and generating result sets in xls formats.
• Regular Data Refresh from Production to Test and Development environments using RMANDuplicate Database

Environment: Oracle E-Business suite 12.2.x,Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, OEM-12C,Mongo DB, RMAN, RAC, Grid, Data guard, Azure, Golden Gate,Exa-data, Control-m Job Scheduling, BMC Remedy Ticketing system, SVC EMC Data Domain, Net-Backup, Team quest tool.

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Upgraded Hyperion databases to the latest 11g patch set (11.2.0.4.1 ) and also setup/document the DR Strategy plan using SVC (SAN volume controller) flash copies methodology.
• Setup a 2-node 11g RAC instance using cluster ware and ASM . Also done an ASM Disk rebalancing activity on a production instance.
• Extensively worked on wide platforms including IBM AIX, SunOS and LinuxRHEL.
• Experience with Oracle E-Business Suite (12.1.3, 12.2.x)
• Performed installation, upgrades, backups and restores for Oracle EBS - Oracle E-Business Suite, Oracle Financial Applications r12
• Maintain and monitor around 200 RAC and Non-RAC Production instances.
• Have setup DB instances for Net cool monitoring
• RMAN cloning of a 11g production DB instance.
• Responsible for migrating regular RDBMS instances to AWS to implement cloud architecture in POC and DEV environments.
• Responsible in configuring Integrated Extract (to support Compressed table extraction) and Co-ordinated replicat after upgrading Golden Gate to 12.1
• Responsible in synching up the data between Oracle to Non-oracle (Tandem, SQL Server) by performing History-pull using Golden Gate.
• Administering Teradata database (5 different MPP Systems) using Teradata Manager, Teradata Administrator and other Teradata internal tools.
• Performance tuning of Teradata SQL, ETL jobs. This demands good knowledge in understanding the parameters like Teradata Explain, Stats Collection, Multi value Compression, Skewing etc.
• Involved in Performance monitoring the different TD servers using tools like PMON, Dashboard, TD Alert and other Barclay's specific internal monitoring/alerting tools.
• Responsible in implementing Oracle’s Transparent Data Encryption (TDE) in production/lab instances and performing relevant changes to support Golden Gate.
• Responsible in synching up the data between Oracle to Non-oracle (Tandem, SQL Server) by performing History-pull using Golden Gate.
• Worked With Team that involved in Installing Oracle Siebel crm.
• Worked with the application team, System administrators in load testing of the Hyperion production environment.
• Create and execute of roll plan for the QA/Test database refresh activities from the production environments on a change request process initiated manner.
• Worked on setting up the OEM 12C and deploying the agents and adding the target hosts and database for all the production and non-prod instances.
• On-call support on a rotational basis and weekend activities like Planned DR tests, Production maintenance tasks like index rebuilding, gather stats, dump and reload activities.
• Have setup a physical standby database using oracle data guard 11g.
• Worked closely with the application teams, Unix Teams to work on performance issues, DB bottlenecks, I/O contention issues.
• Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN
• Apply patches and CPU regularly to keep the databases in current version.
• Follow up of Critical Sev-1 tickets with Oracle support- providing the request dumps and trace logs
• Worked with SVC technology with global mirrors and flash copy methodology for High availability and fast recovery techniques.
• Taking up special requests of backups using RMAN, logical (Expdp/ impdp), Netback up procedures, Net filers on Linux operating systems.
• Daily regular work includes handling work requests/tickets based on SLA using remedy ticketing tool.
• Monitoring backup jobs using control-m tool.
• Regular work like creation of users, granting roles and privileges to users, table space management, setting CRON jobs.

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, OEM-12C, RMAN, RAC, Grid, Data guard, Mongo DB, Azure,Exa-data, Control-m Job Scheduling, BMC Remedy Ticketing system, SVC EMC Data Domain, Net-Backup, Team quest tool.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Responsible for the overall management and maintenance of Oracle e-Business Suite R12/R12.1 applications
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) Grid Control.
• I was responsible for constructing RIS FDW a Data warehousing Project that provide RIS (Retirement and Investor Services)
• Install Oracle audit scripts across all high profile and low profile categorized servers over GMRT region (Global Markets and research technology).
• Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
• Applied patches and CPU regularly to keep the databases in current version.
• Work with oracle support to report and resolve issues in production databases.
• Handling Tickets assigned via remedy queue and Oracle severity for critical DB Applications.
• Configured and maintained Oracle Goldengate instances for replication of database.
• Responsible in installing and setting-up Golden Gate from source to target to provide active data replication
• Responsible in configuring Golden Gate using User Exit and Voltage encryption to encrypt the data before being delivered into Golden Gate Trail file.
• Worked on very wide environments including Linux, Sun Solaris, and IBM AIX.
• Installed and rolled out auditing on over more than 1000 oracle instances including RAC/Non RAC.
• Configure the initialization parameters and later bounce the production DBs during weekends and during weekdays for Dev/QA/UAT and staging databases.
• Use Fog-light monitoring system to address issues relating to the file system growth, database health status and acknowledge/resolve the alerts raised.
• On-call Production support for the Oracle issues severity 1 & 2.
• Ensure that the OS level and DB level backups are configured correctly via the BMS (Backup management system).
• Configure and schedule backups using RMAN and setting up EMC data domain deduplicationbackup storage on certain critical applications.
• Work with the Banks oracle engineering team in making changes to scripts and identifying the compatibility on all different versions of oracle systems.
• Setup Audit maintenance Jobs across in cleanup up the audit logs created in the adump dir.
• Studying the impact of auditing on DB performance and log generation activity by performing load testing .
• Creating links for any low space Unix/Linux file systems and this is used for future log scooping.
• Apply patch updates using the BBDA tool - BMC Blade logic database automation tool.
• Setup Jobs over the Autosys instances using the AutosysiXp tool and setup crontab jobs on some legacy Merrill Lynch servers.
• Work closely with System Administrators to recommend appropriate Hardware Changes (Server Level) during the implementation of the Real Application Cluster
• Work closely with Development, QA teams to recommend appropriate changes to applications and coordinate down time for the conversion
• Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
• Responsible for creating shell script to export and import schemas from production to development

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5 Tikanga, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC, Golden gate, Grid, Data guard, Fog-light monitoring, AutoSys Job Scheduling, BMC Bladelogic Automation tool, EMC Data Domain, Net-Backup, Nexus Ticketing System

Confidential, MEMPHIS,TN

ORACLE DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Configured GOLDENGATE unidirectional in classic capture mode on LINUX
• Installed, Configured and monitored GOLDENGATE replication and installed VERIDATA tool forcomparing data synchronization between SOURCE and TARGET
• Responsible in upgrading Golden Gate from v9.5 to v10.4 and from v10.4 to v11.1
• Responsible in configuring/setting up Golden Gate from scratch in non-prod and deployed the same in production environment
• Installed and monitored STREAMS one-way replication
• Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration projects Extensively using Data pump and Rman utilities
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
• Excellent in writing SQL scripts using SPOOL command
• Expertin using Data pump
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM andTKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP,FTPand SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Troubleshooting ORA errors when occurred
• ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMANshellScripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Confidential, Brooklyn, NY

Oracle DBA

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup &recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names.
• Involved in designing logical and physical data models using Erwin.
• Created indexes to facilitate easy user interface implementation and tuning.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and configuration of oracle database 8i (8.1.7), 9i (9.0.2) on various OS platforms like HP-UX, Linux and Windows NT, 2000.
• Creating and Maintaining of databases.
• Creating table spaces, tables, indexes, data files etc.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Perform capacity planning required to create and maintain database environments.
• Helping to the developing team and data warehousing team.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Writing complex queries and procedures using sql *plus and toad.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring the background processes activity, setting the appropriate number of DBWR processes, changing the init.ora parameters etc.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk I/O
• Managing archive logs, DB-links, partitions.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Maintain Oracle schemas and SGA region.
• Guiding and leading warehousing team for better performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 8i/9i, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Import/Export and Linux, HP-UX, Windows NT/2000