PROFESSIONAL SUMMARY:

• Certified Oracle Database Professional with over ten years of experience in the information technology industry. Possesses extensive hands on experience in Oracle Real Application Clusters (RAC), Cluster ware, Cluster Ready Services (CRS) on both Microsoft and UNIX based platforms and Microsoft Server.
• Have worked and supported both Development and Production database environments
• Plan, construct and maintain databases for data storage manipulation and retrieval and database security.
• Diagnose and resolve problems in response to customer reported incidents.
• Installation, Configuration and administration of Oracle software and its components.
• An in - depth understanding of the architecture of oracle including RAC, CRS and ASM.
• Backup and Recovery using RMAN, Export data pump, cold backup technologies.
• Monitoring and Performance Tuning of databases and front end applications.
• Data Guard Implementation, administration and VLDB administration and maintenance.
• Highly motivated professional, quick learner, skilled communicator and a team player.
• Result oriented, analytical and self-driven professional seasoned with years of working in a dual role of design and production support.

TECHNICAL SKILLS:

• Oracle 8i
• 9i
• 10g
• 11g
• 12c and 13C Oracle Enterprise Manager (Oracle Expert
• Tuning and Diagnostics Pack)
• Oracle Internet Directory(OID)
• Oracle Exadata
• DELL Open manager Essentials
• SQL Server 2008
• 2012 and 2000
• Unix Shell Scripting (Korn shell ). Erwin3.5.2
• Toad
• spotlight on Oracle (Quest)
• RMAN
• UNIX
• Sunsparc Solaris version 2.6
• 2.7 and 8 (64 - bit)
• Sun Solaris 9-10
• Sun Ultra Sparc E 4500
• HP 9000
• HP-UX 10.2
• 11.0
• HP Tru 64
• HP OpenVMS
• Linux Red Hart
• Legato
• VERITAS
• Netback up
• Windows NT 4.0
• Novell 4.1
• Windows 2000
• XP
• AIX 5.3
• Power 7 and Oracle 12C Cloud Control
• Linux RHEL 7
• VMware.

  PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Worked on the migration of the Public Works Departments IT environment into the Confidential GRID.
• Set up of the RAC environment from Development to Production that is currently serving as the DC Exchange insurance system called DC ACCESS SYSTEM (DCAS) and also stood up server for Disaster Recovery at ODC1 Data Center. Configured Oracle Cloud Enterprise Manager 13c to manage DCHBX installation & database, application at one of the data centers.
• Prepared documentation and a plan of action (including time lines) is setting up the new environment.
• Stood up a 12C Cloud Control system for Confidential new infrastructure.
• Built an entirely new Confidential RAC Infrastructure at ODC1 Data Center and migrated all RAC databases from the Legacy Infrastructure/Consolidation to the new Environment, to support PeopleSoft applications.
• Upgraded PeopleSoft database from 11.2.0.2 to 11.2.0.4.
• Upgraded PeopleSoft database from 11.2.0.4 to 12.1.0.2
• Built a new 11g RAC environment at ODC3 Data Center and created standby databases.
• Configured the new DELL R710 Servers in to open manager essentials for hardware monitoring.
• Migrated 9i, 10g and 11g RAC databases over to a new Linux 6.5
• Carried out yearly Disaster Recovery exercises by switching over to standby databases and testing application connections and switching back to the primary environments.
• Provided day to day support on over 600 MS SQL databases
• Migrated MS SQL databases from a cluster to VMware’s.
• Refreshed MS SQL databases with back up data from production databases.
• Supported the people soft application running on Exadata
• I participated in meetings for capacity planning and the design of the enterprise system.
• Use oracle Real Application Testing (RAC) to validate performance metrics associated with infrastructure changes and as well as new and old database consolidation.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle 11g Grid control
• Migrate PeopleSoft production database from dell oracle grid to Exada X6.
• Upgrade PeopleSoft production database from 11.2.0.4 to 12.1.0.2
• Implement TDE on existing people soft 11.2.0.4 database
• Upgraded RAC databases from 10.2.0.5 to 11.2.0.2 and patched to 11.2.0.3
• Used 11g Oracle grid control to diagnose and fix performance issues
• Migrated RAC databases from VERITAS SFRAC storage system to ASM
• Configured new services for use in accessing RAC databases
• Cloned Verification & Validation (V&V) stand-alone databases to Dev and configured them into RAC databases
• Worked with Database Developers to tune stored PL/SQL CODES
• Upgraded CRS 10g to 11g Grid Infrastructure including all RAC databases.
• Created and managed RAC services.
• Installation and configuration of Oracle Software on UNIX and Windows Servers.
• Created from scripts, export dumps and cloned Oracle databases for development and test projects from production as needed for use by developers for new projects.
• Performed database Refreshes to update data from production to the Development and test environments using Recovery Manger (RMAN) and cold copies.
• Implemented Oracle Advance Security techniques to protect database integrity by masking data, hardening the databases.
• Deploying enterprise user security techniques to minimize and eliminate security threats by implementing password verification functions and encryption.
• Performed daily administration functions, including database management, monitoring, performance tuning, backup & recovery and also general troubleshooting on multiple UNIX platforms and Windows Servers.
• Planned and implemented Oracle CPU patches as required / recommended by Oracle.
• Maintained database backup and recovery infrastructure and performed backup tasks using RMAN

Confidential, Silver Spring, MD

Database Administrator

Responsibilities:

• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database.
• Oracle RAC & ASM installation configuration and administration on AIX 5.3 and LINUX Red Hat 4.3
• Installation and configuration maintenance of oracle 10g (RAC) in Development, Test and Production environments.
• Documented and trained junior DBAs on the Architecture, administration, concepts and troubleshooting techniques of Oracle 10g RAC and ASM.
• Played a supervisory/Lead role on all Database related tasks on the project.
• Install and configure Oracle 9i and 10g on both Windows and UNIX platforms using OFA.
• Create and configure Oracle Databases using Oracle Database Configuration Assistant or manually by using Oracle Database Dictionary, Table spaces, Indexes, Clusters, Tables, Constraints and Systems security using scripts such as CATALOG.SQL, CATPROC.SQL, CATAUDIT.SQL and the organization and easy identification of database files using the OFA database configuration method.
• Set up, configuration and troubleshooting of SQL*Net files
• Install and configure Oracle 9i and 10 Enterprise Manager (OEM) on UNIX and Windows NT platform.
• Supported Programmers in the development, deployment and tuning of PL/SQL CODES, Stored Procedures and triggers.
• Creating database objects Table spaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.
• Reorganizing and restructuring of existing Databases to meet the OFA standards and for optimizing the performance.
• Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention.
• Resizing, cloning, moving, Partitioning and stripping table spaces, Tables, Indexes and rollback/undo segments as the case might be.
• Analyzing Tables, Indexes and Clusters against chained and migrated rows and providing solutions.
• Primary Oracle DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration, troubleshooting & tuning of 10 Oracle databases (all 10g, single instances as well as RAC) all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in operational data store & operational data warehouse ODS & EDW environments).
• Data migrating using Import/Export and import/export data pump, SQL*Loader either interactively or batch mode.
• Set up and configure block change tracking used with RMAN Merged incremental backups.
• Standby/Failover Administration.
• Configure and administer standby databases(data guard),
• Experience with Oracle virtual private databases, partitioning, and replication.
• Configure Flashback recovery area for database, table flashback as needed.
• Make use of the Automatic Work load Repository and Automatic Database Diagnostic Monitor,
• Experience working with versioning tool rational suite clear-case
• Use SQL tuning advisor to run top sql statements for tuning,
• Use SQL access advisor to gather statistics on tables for tuning as needed.
• Providing performance tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Trouble shooting, restructuring, tuning, and tracking database load, fragmentation, contention, and overall performance for optimal performance of the existing database.
• Conducting load balancing procedures to reduce I/O and contention.
• Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADISOR.
• Identified space-bound objects including reviewing of CPU contention, memory, network or disk resources.
• Upgrade existing databases by applying Patches, Oracle Diagnostics and Tuning Packs to various versions of Oracle.
• Analyze data growth trends for capacity and resource planning.
• Designed, tested, implemented and documented database migration procedures including export/import, migration utility.
• Reorganize databases: Defragmenting, turning Archive on/off, rebuilding and/or relocating indexes, and rollback/undo segments, etc.
• Monitoring/managing database space utilization and growth, table space usage and extents, to include allocating and planning disc storage, modifying database structure.
• Designed, tested and implemented backup and recovery solutions including automated daily hot backups and cold backups depending on criticality of the Database. Established backup and recovery procedures and maintenance including hot and cold backups to support point-in-time recovery of the database which includes (Using RMAN and shell scripts.
• Documented the infrastructure of existing and new databases using Erwin 3.5.2 to generate ER diagrams.
• Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle.
• Capacity planning of tables, indexes, table spaces and databases to allow for growth potential.
• As Database Technical Lead, trained and mentored junior team members on the project and communicated to the project manager’s techniques to set client expectations regarding the efforts necessary to achieve change.
• Worked with application developers to address and clarify data requirements to resolve technical and functional issues.
• Enforced corporate business rules through adequate user/resource/object management.
• Security implementation through basic and advance security techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.