SUMMARY:

• An experienced Oracle DBA (OCP) with 10+ years of IT experience in Oracle Database Administration on various operating systems such as Linux, UNIX (HP UNIX and Solaris), Windows NT, Windows 2000/2003 and SQL Server on Windows 2008 and 2012 Server
• Experience in Development, Test and Production Environments
• Expert in Managing Oracle Databases on Windows, Solaris, Linux, Aix and HP.
• Expert in Performance Tuning, Sql Tuning and Core Oracle Database Administration.
• Expert in DataGuard, Streams, RAC and Grid Control.
• Expert in Oracle Backup and Recovery
• Experience in a 24/7 High Availability and Mission Critical Environments.
• Expert in Database Upgrade, Migration and Patches
• Experience on Confidential System and supported on 24X7 operations
• Design and develop logical and physical database designs from customer requirements.
• Expertise in security, monitoring activity, installation, backup and restores, recovery, tuning and SQL & PL/SQL
• Experience in working as SQL Server DBA as well as Sql Server Integration Package
• Experience in SqlServer Backup/Recovery, Database Administration and Performance Tuning
• In depth knowledge and extensive working experience in Oracle database administration such as database design, performance tuning, system set up and upgrade, backup and recovery.
• Excellent understanding of Oracle architecture and Oracle tunable parameters
• Excellent understanding of Oracle RDBMS 9i through 11g and Oracle data dictionary (On Sun Solaris 2.x, HP UX 10.x/11 and Win NT/ 2000 environment)
• Successfully implemented Oracle11g(R2) RAC: ASM storage devices, RHEL4/3
• Install, Configure, and Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands
• Tuning Linux system level parameters for Oracle RAC such as HugeTLBs(vm.nr hugepages), NFS tcp slot table entries, net.core.rmem max, and net.core.wmem max
• Setup Data Guard for production RAC Database in Physical Standby Architect.
• Hands on experience in Oracle advanced technologies such as 10g, 11g RAC, OEM, Grid Control, Data Guard (both logical and physical), partitioning, RMAN.
• Implemented a standby database operation using Oracle 10g, 11g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance.
• High - volume production database support, Oracle Fail Safe implementation (Data Guard), backup plans and implementation, Performance monitoring and tuning (Statspack)
• Experience in implementing and using of Oracle 11g new features like Data Pump, ASM, Flash Back Technology, Transportable Tablespaces and Automatic Workload Repository
• Planning and scheduling Physical Backups using RMAN and Manual methods and Logical Backups (Full, User, Table)
• Oracle Installation, upgrade and migration (Oracle 9i, 10g and 11g )
• Shell scripting for automating, monitoring and performing routine database jobs.
• PostgreSQL configuration and troubleshooting.
• Vibrant team player with belief in taking positive approach towards issue resolution

TECHNICAL SKILLS:

Platforms: UNIX, Linux(Red Hat, Centos, Fedora, Ubuntu), AIX, HP-UP, Windows (NT/ 2000/2003/2008 )

Databases: Oracle 9i and 10g, 11g, ODA (ORACLE DATABASE APPLIANCE), PostgreSQL, MS SQL Server 2000,2003,2008

Languages: C++, Java Script, Java, HTML, SQL, PL/SQL, UNIX shell scripting

Tools: Microsoft Office Suite (Word, Excel, Outlook), Oracle Enterprise Manager (OEM), SQL-Navigator, Oracle SQL Developer, Toad, Erwin, putty, Grid control, Winscp, RACCheck, OSWatcher and Swing bench

Applications Hardware: PeopleSoft Enterprise Portal 9.0, PeopleTools 8.49, PeopleTools SQR, Tree Manager, Data Mover, Application Designer, Crystal reports, SeeBeyond 5.0, Weblogic, Tuxedo, and Microsoft Dynamics GP (Great Plains) 9.0, Oracle Application server 10gR2, Oracle Identity Management Provisioning Console, Oracle collaboration suite 10gR1, JIRA (Bug & Issue Tracking System), Bugzilla, Frontline ticket system, Kbox Systems Management Appliance IBM Regatta p690+, Colfax CX7200 Blade, Blade Center JS22 Express Blade, ODA (Oracle Database Appliance)

PROFESSIONAL EXPERIENCE:

Confidential, MD

Oracle Consultant

• Install oracle 12C on Test and development environment.
• Created container and pluggable databases.
• Create scripts to monitor all the pluggable databases.
• Implemented weekly refreshes from Prod to Test using Standby Database.
• Clone Prod database to Test for Developer purposes.
• Manager capacity planning for Prod database.
• Implemented data pump using rep map schema, tablespaces. implemented transportable tablespace to migrate database from 11g to 12c
• Implemented and migrate Oracle database in we8mswin1252 to AL32UTF8 character set using DMU on Dev, TEST and PROD
• Plug Non-CDB into a existing CDB database using DBMS PDB Package.
• Research and document space usage on both ASM and OS level for capacity planning.
• Configure and implement oracle SSL wallet on 11gr2
• Migrate all DEV and Test databases from our Texas West coast Data center to Virginia East coast data center
• Reinstall Oracle Grid Infrastructure software without disturbing RDBMS installation
• Apply April Oracle PSU patch 12c on GRID HOME and Oracle RDBMS Home.
• Daily Oracle refresh from PROD to DEV ENV
• Troubleshoot Oracle Clusterware for ASM errors and CRS errors.
• Move OCR and Voting Disk from a diskgroup to another disk group. manage amazon EC2 Oracle 11G instance running Redhat Linux with 11.2.0.3 binaries installed and a running 11g database

Confidential,MD

Oracle DBA

• Provide administration of databases throughout the development and production lifecycles.
• Design and develop logical and physical database designs from customer requirements.
• Complete all database fixes as required
• Provide technical support for all ad-hoc database extracts and reports
• Maintain the Data Dictionary for CMS (Center for Medicare & Medicaid Services) ASET II databases on Linux Platform.
• Implemented Oracle data conversion plan strategy for our legacy database to the new CMS Enterprise database.
• Communicate any questions, concerns to PM or BA
• Maintain the logical model schedule peer reviews as needed
• Maintain the databases in Development and Prod environment
• Update the database in Development as needed for each Release
• Provide final copy of Database deliverables to PM for delivery to CMS/ OESS
• Develop the conversion process as needed for Database changes; execute in Development and validate; refine as necessary
• Perform administration tasks for several Oracle databases on both Windows and Linux platforms
• Modify the database design during system testing
• Document Version Control Procedure
• Execute the final conversion in DEV as part of the PROD deployment; copy the tables to PROD and validate the results
• Provide PM with progress/status reports as needed for assigned project plan tasks
• Provide mentorship to mid and junior level staff.
• Establishes and practices a consistent database backup and recovery practice that complies with the backup and retention policies and business continuity practices.
• Install and configure Oracle Restart 11gR2 on Linux Redhat.
• Refines and manages baseline configurations for the enterprise database environment
• Provide 24x7 operational supports for all databases on a rotating schedule, after hours on-call support and apply production packages during non-peak hours.
• Provide the implementation of replication, virtualization backup tasks.
• Acts as subject matter expert for all database systems
• Maintain, schedule and troubleshoot all RDBMS related software Oracle Enterprise Manager (OEM) Cloud Control 12C on Linux Environment.
• Develops standard process for implementing database and system patches & upgrades
• Adheres to CMS ELDM standards

Confidential,DC

Oracle / SQL SERVER DBA

• In depth knowledge of all aspects of the Oracle environment on the Linux platform. Able to build, troubleshoot, monitor and maintain single instance in a 24x7 environment with minimum downtime.
• Weekly refresh of Prod database to Development database on Linux and Windows platform.
• Performs ongoing tuning for oracle and SQL Server database instances.
• Install and configure PostgreSQL on Linux and window environment.
• Troubleshoot PostgreSQL on both Linux and Windows environment.
• Daily review of RMAN backups and error logs, ASM disk usage, OS Disk utilization
• Plan and implements daily backups and recovery for Oracle 10G and 11G databases.
• Apply PSU Oracle Database Patch to all RDBMS home on both Dev and Production environment.
• Responsible for installation and configuration of SQL server 2012 database on Dell Servers.
• Applied patches and service packs to keep the database at current patch level.
• Developing SQL scripts for maintaining administration tasks.
• Upgrade Microsoft SQL server 2008 to 20012 using SQL Advisor and Installation Wizard.
• Perform different types of backup strategies and demonstrate how to implement each of these types of backups using Enterprise Manager, the graphical user interface (GUI), and Transact SQL (T-SQL) in Microsoft SQL Server 2008 and above.

Confidential,MD

Oracle RAC DBA

• 24/7 management and On Call.
• In depth knowledge of all aspects of the Oracle environment on the Linux platform. Able to build, troubleshoot, monitor and maintain both single instance and multiple instances (RAC Cluster) running 10gR2 (10.2.0.4) in a 24x7 environment with minimum downtime.
• Weekly clone/refresh of Prod database to Development database on Linux platform.
• Performs ongoing tuning of four node cluster database instances running on both 10g and 11g.
• Install new versions of the 11G2 (11.2.0.3) Oracle RDBMS and its tools and any other tools that access the Oracle database on Redhat 5.
• Plan and implements daily backups and recovery for Oracle RAC environments.
• Perform Oracle backup and recovery scenarios exercise for both single instance and RAC environments
• Implements and enforces security for all of the Oracle Databases in all the environments.
• Assists with impact analysis of any changes made to the database objects from Developers.
• Troubleshoot node eviction in 2 node RAC on Production environment.
• Monitor ASM disk usage, utilization and plain for capacity planning.
• Daily review of RMAN backups and error logs, ASM disk usage, OS Disk utilization.
• Troubleshoot Row lock contention using Oracle Grid control 12C.
• Diagnosing Locking Problems using ASH, AWR and SNAPSHOT.
• Use Automatic Database Diagnostic Monitor (ADDM) analyzes data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks .
• Install and configure Oracle Enterprise Manager (OEM) Cloud Control 12C on OEL 6.1 .
• Install and configure Oracle Grid Control Agent 12C using the Push method on all Production and Development servers.

Confidential,Washington,DC

Oracle RAC DBA

• Emergency on call status.
• Install OS Watcher and RACDDT to address and troubleshooting issues on a RAC Database.
• Install and troubleshoot Rac database using raccheck utility.
• Apply PSU 11.2.0.2 Oracle Database Patch to all RDBMS home on both Dev and Production environment.
• Apply PSU patch 11.2.0.2.3 to all Grid infrastructure and Oracle homes on all nodes on the clusterware on both Dev and production environment.
• Upgrade oracle database 11.1.0.7 to 11.2.0.2 residing on Sun Solaris sparc 10 on Test, Dev and Staging environment.
• Install and configure Two node Rac 11gR2 (11.2.0.3) on Oracle Database Appliance (ODA) Release 2.2 for Linux x86-64.
• Install and configure Oracle 11g RAC/ASM two node cluster on Solaris SPARC 64 bits With SAN Storage.
• Added and Deleted Nodes from Oracle RAC 11R2 on both DEV and PROD environment.
• Install and configure Weblogic cluster 10.3 on Sun Solaris SPARC 64 bits
• Install and configure Oracle Enterprise Manager Grid control 11g and added an additional Management Service on Sun Solaris SPARC 64 bits.
• Setup Streams replication using Schema and database bi-directional replication between two nodes cluster database on production
• Added more raw disk to ASM disk group, create and maintain ASM database instances.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installing 10g and 11g databases on SOLARIS and HP-UX
• Upgrade of Databases from 10g to 11g and applying patches whenever required.
• Installed and configured Oracle 10g/11g RAC high availability
• Installation of Oracle clusterware, Configuring public and private network and VIP
• Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented and maintain Physical DATAGUARD (Standby) for high availability/disaster recovery purpose using Rman Duplicate on Solaris SPARC 64 bits.
• Daily Health Check Up of the Database.
• Database cloning from Production to both Test and Development environments.
• Configured and maintained huge OLTP databases.
• Monitoring Tablespaces and extent Growth.
• Job scheduling using crontab.
• Creation of database maintenance plans, rebuild indexes and integrity checks
• Implemented RMAN Backups, Creation of catalog database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performed full and incremental backups using RMAN
• Ensure high availability of Databases at all time.
• Writing UNIX shell scripts for backup and recovery, Import and export procedures
• Installation and configuration of Oracle Identity Management 11g R1 PS2 (11.1.1.3) for Oracle Identity Management (OIM) and Oracle Access Manager (OAM).
• Start and stop Weblogic Server, Oracle Identity Manager, SOA Server
• Troubleshoot and verifying Oracle Internet Directory Identify stores can perform look ups. create and manage organizations, roles, and users
• Understand and use Oracle identity manager consoles (Unauthenticated Self Services console, Identity Administration console, Authenticated self Service Console and Design Console).
• Use Oracle Enterprise Manager Fusion Middleware Control for auditing, Monitoring, and Logging purposes.
• Transfer Oracle Identity Manager Configurations between environments.
• Troubleshoot Identity Manager Server by checking all the log and trace files.

Confidential,Crystal City,VA

Oracle DBA Lead & Systems Administrator

• Performed and maintain 24X7 daily database administration on production and development environments system at the Confidential office location.
• To install configure and tune, various Oracle products for both client side deployments and in-house testing and production, including, but not limited to: Oracle Databases, Oracle Clients, Oracle RAC 11g plus ASM, Oracle Grid Control 11g on RHEL 4, Data Guard (implement both physical and logical standby), Weblogic 11g, Oracle Collaboration Suite, etc on Unix servers (HP, Linux) and Windows servers (Win 2008).
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.
• Responsible for consolidation of several production, test, and development multi-terabyte databases by migrating from UNIX environments to AIX Virtual Partitions (vPars).
• Performed preventative maintenance, applying Oracle database security patches (CPU), patch sets (PSU) for 10g and 11g versions, database upgrades, database migrations and repair any system and operating environment problems.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Interviewed the Confidential customers to gather requirements for JEMS database deployment and implementations.
• Schedule scripts to monitor database growth and gather statistics database deployments.
• Provided performance tuning, maintaining and troubleshoot database problems.
• Perform daily backup and recovery for numerous Oracle 10g and 11g Databases using Physical back (RMAN) and logical backup (export, import and Datapump).
• Used SQL for different implementation such as generate data, queue data, modified, alter, update the database and schedule daily performance techniques.
• Maintain Oracle Collaboration Suite Rel 10G (Web Conference, Files, Calendar, and Email) on Linux Environment.
• Maintain Oracle Application server 10gR1, start, and shutdown and backup all the application containers and patch all the JAVA JDKs and JREs.
• Provide on-site customer assistance, system monitoring and basic maintenance support to JIEDDO users of CLIENT-developed information management system at the Confidential office location.
• Customer assistance includes general user assist, problem diagnosing/troubleshooting, user account management, and incident monitoring and response; system monitoring and basic maintenance support includes daily system health checks, database monitoring, FTP data management, Oracle Internet Directory, and network and security administration support.
• Troubleshoot user issues while maintaining a secure OS computing baseline, analyzing system faults, reviewing audit logs, running diagnostic tests to detect problems, performing preventative maintenance, applying Oracle security patches and patch set updates for 10g and 11g versions, and repairing system and operating environment problems.
• Supporting functional peer Confidential groups including the SAIC JEMS Program Teams, U.S Army’s Information Technology (ITM) Information Management Center (IMCEN), and the U.S Army Acquisition, Logistics & Technology Enterprise System & Services (ALTESS) hosting facility in Radford, Virginia.
• Support top officials at Confidential including United States Army Director Lieutenant General Mike Oates, Vice Director of Joint IED Defeat Organization Ray Fitzgerald, Deputy Director, Rapid Acquisition & Technology Mr. Howell, Senior Enlisted Advisor Joint IED Defeat Organization CSM Todd Burnett and United States Marine Corps Chief of Staff Colonel Thomas Connally.

Confidential,Washington,DC

Oracle DBA

• Installation and configuration of Oracle software and related products such as Oracle 10g and Oracle 11g on both Linux and AIX platform.
• Develop and execute plan to apply Oracle upgrades, maintenance, and security patches.
• Maintain optimum production environments.
• Performed daily database administration on production and development environments.
• Review and implement Oracle Baseline security settings for Oracle environments.
• Establish and maintain sound backup and recovery policies and procedures.
• Perform backup and recovery for numerous Oracle 9i, 10g and 11g databases using RMAN and export and import.
• Installation and configuration of Oracle Enterprise Manager and Oracle Grid Control Server.
• Perform database tuning, performance monitoring using OEM tuning pack, STATSPACK and Automatic Database Diagnostic Monitor (ADDM), and capacity planning.
• Perform database migrations to newer versions of the software as well as migrations from a different platforms to Oracle.
• Develop and implement automated scripts for performance data collection and database Monitoring.
• Perform analytical research of database architecture seeking areas of performance Improvement.
• Perform analysis and troubleshooting of queries, and provide recommendation for Performance improvement.
• Support user administration, appropriate privileges as well as maintaining database security and data migrations.
• Implement database changes and updates for application releases following established Procedures.
• Communicate with customer, server administrators, and developers.
• Setup and maintain database documentation and standards.
• Work in a team environment and provide 7x24 supports as required.
• Respond to problems quickly, determine root cause, and document and recommend Corrective action.
• Perform backup and recovery for SQL Server production databases.
• Manage SQL Server database objects, run scripts for developer and perform action plan for any deployment or implementations.
• Create database with management studio, copy database with Database Wizard as well as restoring from a backup.
• Managing and Monitoring Databases with Management Studio.
• Create SQL Server Authentication Login IDs with Management Studio.

Confidential, VA

Oracle DBA

• Performed daily database administration on production and development environments.
• Installed Oracle 9i, Oracle 10g and Oracle 11g databases including migrating and upgrading databases.
• Applied patches on oracle server to upgrade it from 10.2.0.1 to 10.2.0.3.
• Applied critical CPU patches including 2007 CPU and CPU 2008.
• Performed Database cloning and oracle home cloning.
• Interviewed the customers to gather requirements for database deployment and implementations.
• Created different tablespaces, tables, schemas and users accounts.
• Wrote scripts to monitor database growth and gather statistics.
• Provided performance tuning, maintaining and troubleshoot database problems.
• Perform backup and recovery for numerous Oracle 9i and Oracle 10g Databases using RMAN, export and import.
• Used SQL to generate data, queue data and report data using crystal report.
• Used SQL to modified, alter and update the database.

Confidential,MD

Oracle DBA

• Collaborate with in-house database engineering team on key migration initiatives and providing technical assistance as necessary.
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Conduct storage management activities to maintain data integrity, while maintaining functionality servers.
• Perform backup and recovery for numerous Oracle 9i, and 10G databases using export and import.
• Write scripts for validating raw data files to load data into Oracle databases.
• Create database objects for custom applications.
• Perform SQL Tuning using stats pack.