SUMMARY:

• Certified Oracle production/application DBA, database architect and programmer analyst, data warehouse DBA on Unix and Linux operating system with the ability to learn and apply technical knowledge quickly and strong troubleshooting and problem - solving skills Seeking a challenging, position in the information systems field where my motivation and diverse skills will help an organization reach its goals I am a US Citizen open to all permanent and contract positions and willing to travel
• Around 15+ years of experience in IT and 13+ experience as Oracle Database Administration on 7i, 8i, 9i, 10g, 11g, and 12c
• 5+ Years of experience in designing solution using Oracle Golden Gate
• Installation & Configuration of Oracle & large databases on Sun Solaris, AIX, HP-UX and Windows 2000/NT
• Proficient in SQL application Tuning and Performance and maintaining large volume of data includes oracle database and Data Mart
• Migration and maintenance of Oracle Databases (11g,10g, 9i, 8ix)
• Implemented Table partitioning and parallel processing
• Excellent command in creating Backups & Recovery procedures and RMAN
• Logical & Physical database design and data Modeling for logical and physical database
• Strong experience in OEM (Oracle Enterprise Manager)
• Strong working experience in SQL* Net, SQL * Loader and SQL*PLUS, OEM, Connection manager
• Complete knowledge of VERITAS Volume Manager, Veritas cluster, Veritas File system,
• Administered Windows 2000/NT/98/95Proficient in writing Shell, Korn scripts to automate business process and taking daily backup
• Database performance tuning using OEM, STATSPACK, and Stored Outlines and Materialized View
• Tuning Shared Pool and Buffer Cache Application tuning using session trace file and TKPROF utility -Financial11i experience
• Knowledge on how to develop automation process using NT or Unix Shell script programming or applicable languages
• USED Materialized view to optimize the data and SQL/PLSQL code
• Managed the Tables and Index to provide statistics for tunings

TECHNICAL SKILLS:

Operating Systems: AIX, HP-UX 90/HP-UX 10x, 11x, SUN Solaris 9/8/27/26/251, SUN-OS 551, LINUX 6x, 7x, Windows NT Server & Workstation (40/351), Windows NT, Red Hat Linux Advanced Server VERSION 30

High availability: Oracle failsafe server, database clustering server, advance replication server, Oracle recovery manager (rman), hot standby databases and data guard, Oracle 9i/10g/11g RAC

Databases: Oracle 10g/9i/8i/7x,/v 11/v 12, db2, MySQL, MS access, ldap server, xml, SQL server 2000

Language: C, C++, Java, J2ee, Shell Script, PL/SQL, SQL

Networks: Novell, Banyan, Microsoft NT, MS Exchange, MS Workgroups for Windows, Windows 2000

Modeling/Data Warehouse: COGNOS, MS VISIO, some IBM Rational Rose; Utilization of UML Case Use and Process Modeling Techniques. CMMI Level 5 Confidential ained on current software project at AFOSR

Network Protocols: TCP/IP

Software Development, CAD and Network Tools: FTP, SFTP, Oracle Designer 2000, OPNET IT Guru, Oracle Developer 2000,ORACLE CASE, Oracle Enterprise Manager, Winrunner 2000, TestDirector, TOAD, Oracle Recovery Manager (RMAN), TELNET, Oracle Pro*C, Oracle Pro*Cobol, PowerBuilder, Quest Instance Monitor/Spotlight, Quest Space Manager, Oracle Discoverer

Desktop Software: Microsoft Office 2003/XP suite of Desktop products (Word, Access, Excel, etc.), Microsoft Project, Microsoft PowerPoint, Microsoft Outlook, Xwindows, ACTIVEX

Servers: IBM AIX, Compaq (Proliant Series), Confidential - Confidential, Wang VS, Sun, Dell

Oracle s: Oracle 10g Certified Professional (OCP), Oracle 10g Certified Associate (OCA), Confidential ended Oracle 10g Administration Workshop at Oracle University, Columbia, Maryland, Confidential ended Oracle 11g Administration Workshop at Oracle University, University of Baltimore, Maryland

EMPLOYMENT HISTORY:

Confidential /State of Indiana

Senior Oracle Consultant

• Upgraded Oracle database from 11.2.0.4 to 12.2.0.1
• Manually created Oracle 12.2.0.1 Multitenant Databases using response file
• Created and configured keystore in 12c database
• Deployed 12 c OEM agent on Windows and Migrated targets from oracle grid control to cloud control
• Created, administered, and provisioned Oracle Databases in virtual environment using Delphix
• Installed and configured Oracle Fail Safe
• Created and configure Oracle database 11g and 12c on Exadata
• PSU Patched Oracle 12c databases using Opatch and datapatch - verbose Utilities
• Used Golden Gates to replicate Oracle Database 11g.
• Administered RAC databases on Windows, Linux and AIX Platforms
• Administered Databases, schedule jobs, set up OEM users, credentials in Grid Control and Cloud Control
• Set up Data Guard using RMAN Duplicate command
• Upgraded Oracle Database 12c from standard to enterprise edition using OUI
• Set up an oracle job to mine alert log and send out notifications of database errors and issues
• Configured LDAP for active directory users connections to Oracle 12c database

Confidential, Cincinnati, OH

Senior Oracle Consultant/Technical lead

• Oracle Consultant/Oracle DBA/Oracle Software Developer/Oracle 10G Application Servers
• Installed and configured 12C pluggable databases
• As L3 Oracle DBA in charge of all the performances issues at GE Aviation, I used precise tools to monitor and troubleshot 1000 of GE databases, including 8i, 9i, 10g, 11g, and 12c
• As a technical lead for the GE Archiving services, I built XDB Databases, extracted, transformed, and loaded Oracle Databases as well as SQL server databases into the EMC XDB Documentum databases
• Set up, configured, managed and troubleshot Oracle Golden Gate
• Developed XQuery from SQL, developed search form, develop reports to output archived data
• Used JDBC - enabled tools such as Squirrel, Easysoft bridge to connect to Oracle and SQL server databases

Confidential, Cincinnati, OH

Senior Oracle Database Administrator

• Worked on three TCS’ projects including Boeing and Freddie Mac
• Created and administered 4-node Oracle 11g RAC and a physical standby Databases
• Installed and configured Oracle 11g grid infrastructures
• Documented known database issues and solutions in WIKI
• Set up and configured Oracle Golden Gate
• Configured database monitoring and Monitored Oracle Databases via CACTI and OEM
• Configured and Managed ASSIGRA to backup database to tape
• Restored production Oracle Databases from ASSIGRA tape Backup to a test database
• Used RMAN duplicate command to clone primary database for standby database
• Configured and managed ASM instances
• Moved data from larger ASM disks luns to smaller ASM disk luns to improve database I/O performance
• Wrote bash scripts to monitor various databases benchmarks and automate RMAN backups
• Setup Database Backup strategy that include full database, i Confidential emental level 0-1, archivelog backup schedules
• Troubleshot database issues including RAC and Data guard issues such as 11g bug that corrupts standby database
• Used scn I Confidential emental backups from primary to recover physical standby database after corruption caused huge gaps between primary and standby databases
• Migrated Oracle 11 g database from Linux servers to Linux servers using both RMAN and EXPDP
• Upgraded RAC and non-RAC Databases from 11.2.0.1 to 11.2.0.3 using Database Upgrade Assistant (DBUA)
• Applied PSU patches
• Provided Weekly and Monthly Database reports to client (Freddie Mac), including ASM disk space usage, volume and types of transactions etc.
• Transferred Oracle Database Knowledge to other team members
• Planned oracle database migration from Terremark cloud environment (third party) to Freddie MAC environment (client)
• Improved Oracle Database performance by troubleshooting bad performing SQL via appropriate indexes creation and hints and by moving and rebalancing database from larger ASM disks to smaller ASM disks
• Created and configured SYBASE database and migrated data into it
• Read thoroughly about SQL database for a new project
• Configured Oracle 11g RAC database e Confidential yption and SSL authentication using OWA and NETMGR

Confidential, Washington, DC

Senior Oracle Consultant

• Oracle Consultant/Oracle DBA/Oracle Software Developer/Oracle 10G Application Servers
• Created and administered standby databases for disaster recovery
• Created and administered about 40 RAC clusters
• Installed and configured 11g database
• Managed the ASM file system
• Installed and managed OID and SSO servers and troubleshot issues

Confidential, Largo, MD

Senior Oracle Consultant

• Oracle Consultant/Oracle DBA/Oracle Software Developer/Oracle 10G Application Servers
• Created and administered standby databases for disaster recovery
• Created and administered about 40 RAC clusters
• Installed and configured 11g database
• Managed the ASM file system
• Installed and managed OID and SSO servers and troubleshot issues
• Installed, configured and administered Oracle application components including portal, j2ee, bpel, sso/oid
• Applied baselines regularly
• Installed and configured Grid Control in 4 different environments to manage about 120 database servers and other targets
• Created various customized jobs using grid control
• Installed and administered streams replication using dba capture, dba propagation, dba apply and other views
• Used svrctl, crs stat and other commands to administered Real Application Clusters
• Used asmcmd to check and administered ASM file System
• Used opmnctl to administer application server’s components
• Patched Streams, database, as well as application servers
• Tuned the performance of the standby databases and application servers
• Monitored the DPC2, IT2, IT1 Environments daily
• Checked the Health of all Databases Servers
• Checked the Health of All Application Servers
• Checked the status of all scheduled DB jobs in DPC2
• Validated daily backups
• Managed +ASMs space for all Clusters
• Configured and Monitored Grid Control Server
• Wrote various DDL and DML as well as procedures and functions to manipulate data

Confidential, Annapolis, MD

Senior Oracle Consultant

• Oracle Technical Lead/Oracle DBA/Oracle Software Developer/Oracle 10G Application Servers and Portal Developer
• Upgraded Confidential databases from 9.2.0.6 to 9.2.0.7
• Applied Patchset and critical patches to 9i and 10 g databases
• Upgraded 10.2.0.1 database to 10.2.0.3
• Successfully set up automatic online backup to the flash recovery area via Oracle Enterprise Manager Database Control
• Created a 9i database from scratch in the 6850 servers
• Wrote a comprehensive backup and recovery strategy documentation for Confidential databases
• Restored jdaws production on 6850 several times
• Troubleshot several oracle errors in production, development, and testing environment
• Transferred knowledge of Oracle Enterprise Manager usage to SAs
• Advised the Confidential IT team on Daylight Saving Time issues and made patches recommendations
• Migrated data from current production database to new production database on 6850 servers
• Created new objects in test, development and production databases and deployed newly created applications to existing databases
• Assisted in loading EOB and SCS data
• Performed block recovery several times using RMAN command
• Recovered a whole production database using RMAN
• Installed and Configured Databases in a Polyserve Matrix of 2 nodes for high availability
• Configured RMAN features for backup and recovery purpose
• Used Flashback query, flashback drop tables, and flashback database features for recovery purpose

Confidential

Independent Consultant DBA

• Under sub-contract with Irus Group Sterling Virginia at Defense Logistics Agency Richmond Virginia
• Performed as a senior consultant, application design architect and Oracle 10G Portal software developer for the Defense Supply Center in Richmond Virginia, which reports to the headquarters of Defense Logistics Agency at Fort Belvoir Virginia
• Developed and maintained Oracle Portal applications written in PL/SQL using Oracle Web Tool Kit, J2EE, Business Intelligence, JDeveloper, ADF and BPEL technologies, tools and APIs
• Configuration Management is supported by Computer Associate’s Harvest suite of CM tools. Software Change Requests (SCR) and Trouble Resolution are managed by Remedy’s latest helpdesk software Magic
• Provide Oracle consulting to the worldwide Defense Logistic Agency Enterprise Information System (DLA EIS) and is involved in the current modernization effort to migrate DLA EIS to Oracle 10G Release 2 as well as implementation of a new Business Enterprise Systems which will utilize Oracle Applications
• Worked on a day-to-day basis with primarily Sun Solaris and HP UNIX application/database servers as well as OID, Discoverer and Database servers on a variety of OS platforms
• Built portal page group, page, portlets using PL/SQL generator, as well as providers
• Built various oracle 10g components including reports, forms, loves, calendar, dynamic pages, portlets, providers
• Set up portal access control, and creates transport sets for migration from oracle portal 9.2 to oracle portal 10g
• Wrote portlets using java portlets wizards, and uses strut technology to build applications
• Created application installation scripts for portal migration
• Primary programming languages on site are PL/SQL, HTML, DHTML, XML, Unix Shell scripting language, JavaScript, Dynamic SQL and SQL*Plus

Confidential, Oklahoma City, OK

Senior Oracle DBA Consultant

• Designed a 4-server Oracle 10g RAC architecture for the Airforce Logistics Centers
• Configured Oracle Connection Manager for the ALC environment
• Tuned PL/SQL stored modules used to query views using TOAD
• Wrote Shell Scripts for the daily backup of the Air Force Confidential databases
• Used Cognos Powerplay to design, build, deploy and analyze cubes
• Created reports using Cognos impromptu
• Used Manugistics WebWorks Foundation to manage Supply and Demand for U.S Airforce aircraft engine spare parts

Confidential, Jacksonville, FL

Senior Oracle DBA consultant

• Performed Oracle 9i health check
• Checked database layout and configuration
• Run statspack scripts, analyzed and interpreted the results of the statspack report
• Made recommendations for database optimization

Confidential, Anniston, AL

Senior Oracle High Availability DBA consultant

• Configured the disk system for Oracle 10g RAC installation on RedHat Linux Advanced Server version 3
• Installed Oracle Cluster Filesystem (OCFS) and configured OCFS drives
• Configured the network for RAC installation
• Patched the RedHat Linux kernels
• Configured Linux kernel parameters for RAC installation
• Configured the 4-node Linux/RAC cluster
• Installed the Cluster Ready Service (CRS)
• Verified a valid path name on all four nodes
• Installed oracle database 10g with Real application Cluster
• Backup the 4-instances database using VERITAS net backup
• Assisted in configuring the SAN for shared storage

Confidential, Port Charlotte, FL

Senior Oracle DBA

• Installed and configured Oracle 9i database server on RedHat Linux Advanced server Version 3
• Gathered information on source and target systems
• Identified O/S required packages and patches for RedHat installation on Oracle server
• Analyzed the database post installation and verified the control files, datafiles, and redolog files location on the database server (Raid setup)
• Generated the backup procedures for the Oracle production database
• Resolved issues related to the backup of the database
• Tuned the database using required parameters and implemented the table partitions
• Created the statspack tuning scripts to track database performance
• Analyzed the Oracle database including the tablespaces with the tuning scripts
• Optimized & troubleshot the Oracle database and completed knowledge transfer with Charlotte County Tax Collector staff
• Verified and validated the application
• Identified potential database bottlenecks and Application server parameters for database performance
• Monitored production database using tuning scripts
• Checked data files, control files and Redo log files configuration on server (Raid setup)
• Checked database log files and provided parameter change recommendations
• Monitored mid-tier application server parameters
• Provided recommendations for production database backup processes
• Tested front-end application against tuned production database and mid-tier application server

Confidential / City of Virginia

Senior Oracle DBA

• Setup and configure oracle 9i database instances
• Provide configuration recommendations to the client
• Patch separate Oracle RDBMS to required/supported levels
• Configure Oracle Networking Software
• Set up standard backup and recovery for failover purposes
• Install and configure Microsoft Cluster Server
• Set up high availability solution by installing and configuring Oracle Failsafe version 331 on two nodes hosting Microsoft Windows 2000
• Create a group on failsafe node and add a stand-alone database to the group
• Verify the Cluster, the group, and the failsafe database
• Troubleshoot performance issues encountered
• Backup database using Veritas NetBackup
• Integrate Oracle Failsafe Manager with Oracle Enterprise Manager 10G
• Load data on the failsafe database using SQL LOADER
• Perform logical and Cold Backup of 9201 databases
• Provide mentoring to client staff
• Web-enable oracle olap applications using oracle 9i web agent
• Migrate to oracle web agent from oracle express web agent
• Customize oracle 9i web agent using HTML templates
• Upgrade Oracle Web Agent/OES to Oracle Web Agent/ 9i OLAP
• Set up Tomcat 412 as internet server for oracle web agent 9i

Confidential

Senior Oracle DBA

• Provided support to production and QA database9i and 10g to provide performance support for clients
• Configured the disk system for Oracle 10g RAC installation
• Installed the Cluster Ready Service (CRS)
• Stamped the logical drive for Automatic Segment Management (ASM)
• Installed oracle database 10g with Real application Cluster
• Verified a valid path name on both nodes
• Reviewed the installation in Oracle Enterprise Manager Database Control
• Performed and end-to-end analysis of performance of the database
• Analyzed the current configuration and provided recommendations for fine-tuning and performance improvement
• Analyzed SQL queries and provided recommendations for optimization
• Assisted the team in setting up the stress testing environment and conducting stress and performance testing of the application
• Assisted in the development of a final report with the findings on the performance of the existing application and recommendations for improvement
• Assisted in intranet Oracle 10g Portal/App Server setup and configuration for the USDA purchase card management system employee
• Reviewed and suggested configuration enhancements
• Assisted in setup and configuration of Oracle 10g Portal to allow employees of the USDA purchase card management system to analyze data and generate report using discoverer
• Assisted in installation/configuration of Oracle Portal’s Wireless Option
• Assisted in setting up web caching capabilities
• Provided support to solve the stress test done over the provided database and take the steps according to them Solution to the error like 00060, 00600, 12542, 01000, 00154 etc. supports to undo tablespace for long and high-volume transaction, Temp tablespace for sort segment
• Provided SQL statement tuning, indexes, cluster, histogram, trace session stored outline and materialized view Reorganize the tables and analyze the tables and indexes
• Created database9i and have created replication to have support for production
• Used RMAN to provide faster backup and recovery strategy for high volume database
• Used exp/imp to export and import from production database and testing database
• Provided solution to the buffer problem, sharepool, and redolog problem
• Created standby database, migration, cloning and replication database
• Created users, tablespace, roll and assign the privileges to them
• Have done cold backup, hot backup to provide support to the instance crash and recovery purpose
• Used statspack, tkprof, SQL trace to gather the statistics to solve the WAR-ROOM problem for the production server
• Developed Per script to verify to different files data and redirect to third file

Environment: Oracle 9i version 92040, AIX 51, SUN Solaris 92, Sunfire V880 Servers, HP-UX 11x PL/SQL, SQL, Shell Scripts, VERITAS /SUN Enterprise Volume Manager 2x, 3x, DNS, DHCP, IBM HCMP disk array cluster for fail-over, Oracle 9ias Application server running at the web server, Oracle Forms version 9023, Oracle Reports Server, Oracle discoverer, IBM S80 Unix, DMZ, f5 Load Balancing Switch