Experienced Oracle DBA with Secret Clearance specializing in database administration and development using Oracle. Broad experience in Oracle Database Administration DBA , and data integration using various data formats. Experienced in the maintenance and administration of relational databases, Dataguard architecture, and business applications.

• Specialized Knowledge
• Database - Oracle RDMS 7 11g, Oracle 11i, MS SQL Server, and DB2
• Hadoop BigData -
• HDFS, Hive, Pig, Flume, Hue, Datameer, Oozie, Zookeeper, MapReduce, Sqoop, Talend
• Operating Systems - AIX/Sun/HP Unix, Redhat Linux, Windows
• Middleware - Weblogic, Oracle AS, Apache Tomcat,
• Software - Oracle RDBMS, Oracle Enterprise Manager, Oracle Designer, CA ErwinERP, Informatica Power Center 5.1/6.2/7.1.2
• Certifications: Security
• Relevant Work Experience

Confidential

• Working as the primary DBA in the DB support team, get involved in the daily On-Call to support the mission critical OLTP and OLAP production databases.
• Working as one key member of the technical resources pool to support the Front Line Support on call team according emergence requirements and issues.
• Installed, configured and maintained Hadoop clusters - MapReduce, HDFS, Hbase, zookeeper, Oozie, Hive, Cassandra, Sqoop, Pig, Flume, Datameer and Qlikview.
• Worked with DevOps team in Hadoop cluster planning and installation.
• Application DBA for a large number of tuning projects. Working with Third party developers on SQL code review and quality control.
• Experienced in troubleshooting any Oracle EBS issues including performance, WorkFlow, forms, reports and concurrent programs and processes.
• Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Stats pack, and OEM Performance Manager.
• Setting Up High Availability Oracle Golden Gate OGG systems on Oracle 11gR2 RAC environments.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis.
• Established database backup/recovery strategy for different databases.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle data pump utilities and SQL Loader.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Daily Oracle DBA tasks such as Oracle network trouble shooting, table space usage monitoring, and rebuild index / tables.
• Provide support to different levels of Environments including Development, SQA, Performance Testing and Production.
• Configured Oracle 11gR2 11.2.0.3 Physical Standby Database Data Guard and Active Data Guard by using RMAN duplicate.
• Responsible for performing SRR Scans/STIG fixes to Oracle 11g environments.
• Migrated Database from file systems to ASM using RMAN. Moved data files between different ASM disk groups.
• Configured RMAN Incremental level 0 and level 1 Backups and trouble shouted Job Failures.

Confidential

Responsibilities:

• Strong expertise in RMAN, setting up and installing Oracle Application Server.
• Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords security .
• Involved in installation, configuration, supporting and managing Hadoop clusters.
• Involved in Hadoop Cluster administration that includes commissioning and decommissioning of data node, capacity planning, slots configuration, performance tuning, cluster monitoring and troubleshooting.
• Used Informatica for ETL Extraction Transformation and Loading in a Data Warehousing Environment.
• Working on the implementation of Oracle E-Business Suite R12 system.
• Removing row chaining for better performance.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Table spaces.
• Database Sizing, Table space management and Rollback Table space management, Transaction Management, and Security Administration.
• Created Dataguard physical standby database as DR Solution for production database using RMAN.
• create standby database command, also setup Data Guard Broker to manage data guard environment.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Defragmentation of database using export import.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting for automating startup/shutdown of databases.
• Provided Oracle Patch installation.
• Performed Large Terabyte size Database Backup including Physical backup through Hot Backup/Cold Backup of Oracle Database on Raw Devices using compress and Logical backup using multiple streams Export / Import on UNIX.
• Provide On-Call support to production Databases on rotation basis.
• Setup, Configured Oracle Data Guard using physical standby database.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Oracle 10g/11g installation and Configuration.
• Led creation of the Oracle 10g physical standby database.
• Implement the standby to read only mode for reporting purpose during business hours and switch torecovery mode at night to apply the logs.
• Design, document, implement and maintain all Disaster Recovery procedures.
• Migrating Oracle 10g database to Oracle 11g.
• Installing Oracle Patch. Migrating production database to new server.
• Designing the security and database access strategies.
• Performing backups and recoveries using RMAN/ conventional hot backups.
• Cloning databases for development and testing.
• Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and
• ADDM reports for the Better performance.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Installed and configured WebLogic Servers, Domains, Clusters on Solaris, and wrote shell scripts for automation of WebLogic startup, and for log maintenance.
• Building both web and J2EE applications using ant scripts and the source from SVN.
• Performed WebLogic installation, domain configuration, load balancing and performance tuning.

Confidential

Responsibilities:

• Migration of Databases to oracle 11g in Sun Solaris environment.
• Applying Patches. Troubleshooting when required. Formulation and Implementation of Backup and recovery strategies for Oracle Database.
• Analyzing the schema periodically, Database growth check, Database cloning for uat and development server.
• Oracle EBS Database Administrator responsible for numerous implementations and upgrades.
• Improve the performance of database through Memory optimization.
• Create new database user and managing database schemas.
• Handling Development releases to production Database Implementing change request for production database.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicatedenvironments utilizing GoldenGate.
• Managing Standby database, Testing of DR site databases for failover and switch over.
• Managing Schema roles of the database and its integrity according to Business needs.
• Deploying application changes in Oracle Application Server.
• Coordinated the administration of Oracle Application Servers.
• Designed, develop and implemented the standby database/data guard strategy not only for failover but also for the backup purpose.
• Install, configure and maintain Oracle 10g Portal environments on RedHat Linux Enterprise.
• Deploy applications into Oracle Portal.
• Administer the Oracle databases and Application Servers using Grid Control.
• Installed and administered two-node Oracle 11g RAC Real Application Clusters Database.
• Setup, configured and administered the Oracle RMAN Recovery Manager policies of all the Oracle databases.
• Setup and administered Oracle Grid Control. Administered the Oracle Dataguard Database for Disaster Recovery purposes.

Confidential

Supporting the FDA Food and Drug Administration data migration initiative with Hewlett-Packard.

My Responsibilities:

• Essential Communication with Development, Requirements, and Application Specific Teams.
• Setup RMAN solutions for all Oracle Databases - wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques - restore and recovery.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in cron, creation of users, schemas, tablespaces and other database objects.
• Taking backup of the database on a periodic basis hot/cold/RMAN and checking the validity of the backup by restoring on a separate server.
• Installation and maintenances of 2-node Oracle Real Application ClusterDatabases RAC with ASM for Oracle 10g.
• Performing Node Addition to the existing RAC Database and conversion of SingleInstance to RAC databases.
• Installed, configured and administered different Oracle products includingOracle server, Enterprise manager OEM , RAC and ASM.
• Cloned/Refreshed databases from Production database using RMAN and hotbackups.
• Day-to-day user requests and troubleshooting the database related problems,requests.
• Worked on cross platform migrations for oracle databases between differentoperating systems.
• Working with management on database Sizing and Infrastructure requirements.
• Resolution of issues through Oracle Support, TAR, and Metalink.
• Writing shell scripts and SQL scripts to monitor and maintain the OracleApplications database.

Confidential

Responsibilities:

• Create SQL and SH shell scripts to convert table spaces with dictionary extent management to local extent management with a uniform size as well as tablespace level defrag releases for very large partitioned and non-partitioned objects.
• Configuring Server Side Daemons, Listeners, Routers and Services on Sun Solaris environment.
• Experience in installing, configuring and administering Oracle Databases and also in RAC Real Application Cluster on Solaris environment.
• Installation of OEM grid control, configuration and installing agents on all database servers.
• Proficient in scheduling jobs, patches, alerting for databases, hosts and also database administration through OEM grid control.
• Installation and administration of web tools like Oracle APEX.
• The Oracle RAC and Data Guard were implemented for OLTP and OLAP.
• Database Design and configuration, patching, cloning, migration, upgrades, Applications System/Database administrations, Backup and Recovery, Performance Tuning,customization and load balancing.
• Upgrade the OEM grid control console database from 10.2.0.3 to 10.2.0.5 and apply latest CPU patches /PSU db patches. Also applied CPU patches on OMS oracle home.
• Install OEM grid agent 10.2.0.5 on all servers and configure them.
• Monitoring and supporting day today activities of the production and development databases and work on urgent issues when fired by pager.
• Monitor database alert log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues deadlocks, I/O, memory, and CPU .

Confidential

Functional and Physical Oracle DBA to support Oracle 8, 9 and 10G on many environments, Windows, Sun Solaris, and Linux. Support in-house applications, Troubleshooting, resolving issues and working with Oracle support. Installing all versions of Oracle, creating databases, applying applicable patches and migrating/upgrading Oracle to current versions. Pro-active Monitoring by writing and implementing scripts inSQLPlus. Database recovery including full database, data files, table spaces, and imports. SQL Tuning explain plan, and tracing. Exporting/importing tables importing data with SQLLoader. Rebuilding tables and indexes moving datafiles for I/O performance changing init.ora parameters as needed. Migrated legacy Oracle 8i database to Oracle 10g. Developed new database design for future development. Oracle 10g with ArcSDE on Solaris to provide data to ArcInfo, ArcIMS, and ArcView clients on both Windows and Solaris. Extensive experience in integrating and configuring Oracle like 10gR2 or 9i database with ArcGIS like software. Managed Oracle Real Application Cluster database with two nodes. Performed UNIX, and Oracle administration and performance tuning. Designed and created 9i databases, and analyzed and tuned SQL statements, procedures, packages and functions. Installed and configured Solaris 9 and Oracle 9i. Designed and implemented backup architecture with RMAN.

Confidential

• Oracle Database Administration: Data warehousing, creating roles and users Oracle 8i, Oracle 9i, and 10g .
• Oracle Database Administration: Installations Upgrades, Performance Tuning, Backup Recovery, Systems Monitoring, Problem Resolution/Troubleshooting, Organization Management Security, Database Refreshes, Oracle Replications, Oracle Monitoring Products, and Transparent Gateway OLTP and Data warehousing Oracle 8i, Oracle 9i, and 10g
• UNIX Oracle Server Administration: Installation, Tuning, and administration.
• Installing, administering and troubleshooting Windows 2003 Server.
• Used Symantec Ghost and Acronis imaging software for Windows server imaging.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Used InformaticaPowerCenter 6.2 for migrating data from various OLTP servers/databases to the data mart.
• Created, updated and maintained ETL technical documentation.
• Configured SQLServer 2000 and created Databases, extracted data, schemas, and procedures.
• Worked with Oracle Spatial that extended Oracle Locator to support GIS applications.
• Integration and Maintaining connectivity of ArcSDE with Oracle10g and Oracle 9i databases respectively.

Confidential

• Installed configured Oracle 8i, and 9i on Sun Netra Server Solaris 8 OS.
• Oracle database administrator: Planed, prepared, installed and tuned Oracle 8, Oracle Application Server version 2.7.1.8 administrator, Tuned SQL queries, Designed logical/physical database Erwin and Oracle Designer , created stored procedures, functions, triggers using PL/SQL and implementing them in Oracle Forms 6.0.
• Setup and maintained Oracle Hot Standby environment.
• Participated in failover testing.
• Extensive experience with designing and implementing Oracle databases, including systems architect, project management, data warehouse administration, implementation and tuning.
• Managed, built, and deployed a data warehouse, operational data store, and metadata repository.

Confidential

• Install and configure Oracle Database server with Enterprise Manager including Storage Manager, Instance Manager, Security Manager etc . Defined or altered databases, table spaces, instances and profiles. Created users and grant access to user tables, defined constraints, archive logs, familiar with pl/sql scripts and DDL/DML. Creating Data Dictionary views, maintaining control files, redo log files, rollback segments, Managing Tablespaces and data files, indexes, Managing audit, roles and User privileges. Database instance/profile setup, triggers, pl/sql loaders etc.
• Installed and configured Linux and Apache Web server for Lab, writing Linux Unix shell scripts.

Confidential

Configuration/Release Engineer

• Fidelity Investment's OMT project is an online trading system for its brokers. OMT was developed to be used by the traders from all over the world. The OMT is written in Visual Basic 6.0 and Java in the front-end and Oracle Database on the back-end running under Unix platform. As a build engineer my responsibilities include:
• Supported proposals and customer evaluations requiring CMM Level 3 processes.
• The code complies with the requirements.
• Making sure the code compiles before making an actual build.
• Wrote Unix shell scripts.
• Mixed NT/Unix environment with integration into ClearCase. Over 100 users and multiple projects were under ClearCase control.
• Created build/release and configuration management procedures.
• Automating the tasks required to write, release, and maintain quality software.
• Using InstallShield to create files, file groups, components, and setup types.
• Building use case using Rational Requisite Pro.