OBJECTIVE:

• Secure an Oracle Database Administration contract position using the latest technologies to stay at the cutting edge of information technology.

SUMMARY:

• Confidential has extensive Information Technology experience with over 15 years administrating Oracle databases on multiple platforms including Windows servers, HP - UX, AIX-UX, Sun Solaris, and Linux. He is 8/8i/9i/10g/11g OCP Certified DBA with expert knowledge in Oracle 12c,11g, 10g, 9i, 8i, 8.x and 7.x, in the area of logical and physical database design, networking, development and production. Installation, Configuration, migration and support.
• He has a strong understanding of the various features of Oracle infrastructure and application Servers and Database tiers on Red Hat/Unix and Windows servers with some exposure to Oracle Fusion Middleware 11g WebLogic Suite. Database knowledge includes, OFA, Space, Memory, and Resource and users’ management
• Backup and Recovery Manager, Oracle Enterprise manager (OEM) Grid Control 12c/13c, EM Express. He is knowledgeable with Oracle Database /RAC/ASM/Standby/Golden Gate. He is highly proficient in all phases of Oracle RDBMS and Application support to include resource, user management for multi-user system and database application account and role management. Experienced with tables, indexes, and table-level partition, and Web base Enterprise Applications. Exposure to Public, Private and Hybrid AWS Cloud concepts, Agile and DevOps methodologies He is experienced with Oracle database and
• Application server configuration, upgrade, enhancement and quarterly CPU Patching. He is familiar with triggers, stored procedures, functions and full life Cycle methodology. Experience with TFS/Source control tool. Excellent analytical and problem solving skills, with the ability to diagnose, troubleshoot, and quickly resolve problems. Confidential is an effective team player with excellent communication and interpersonal skills.

TECHNICAL SKILL:

Database: Oracle 12c, 11g, 10g, iasdb, 9i, 8i, 8.x, 7.x, SQL server, MySql, MS Access

Software: REMS, GTS, PRISM, Esri, EBS,ERP, Oracle 11g, 11i, 10IAS, 9i, 8i, 8x, 7x, Net8, Oracle Net.

Tools: TFS/Source control, SolarWinds,Toad9.x/10, SQL*Loader, CRM, Data pump Import-Export, DBMS Pkg, Grid control, RMAN, ETL,ODBC,RAC/ASM, Data Guard, Golden Gate, Visio, Oracle Enterprise manager (OEM) Cloud Control 12c/13c

Languages: Bourne, C Korn, C shell, SQL, PL/SQLHardware: Dell, Red Had 4.x, 5.x, HP9000, Sun Sparc E450/6800, PC/Intel Desktops and Servers, PC's (Solaris 8/9/10), Hard Drives, Tape Drives, EMC, VERITAS, RAID, ASM NetBackup, Laptops and Printers.

Operating systems: Windows2008/2012, Linux6/7, HP-UX10.2/11.11, Solaris2.6/7/8/9/10/ AIX-UX4.1/4.2Apps/Others: REMS, Delphi, Documentum 7.1, Dashboard, Tableau, FAACTS,GTS, PRISM APEX, ERStudio, Oracle OBIEE, Oracle11i,R12, EBS,FIT,CMS, ArcSDE 9.2/9.3/9.3.1, ArcGIS9/10, WAM, NORTEX, EBS, Pramavera, PeopleSoft/8.0/8.5/9.0, METIS, CRM,ERP, REMEDY, Visional, Granite, MS Project, OLTP, DSS, Baths processing, Crystal Reports 9/10/11, 10iAS, Portal, Ultra Search. Oracle NetSuite.

Methodologies: DevOps, Agile, Software Development Lifecycle.

WORK EXPERIENCE:

Sr. Oracle DBA

Confidential, Washington DC

Responsibilities:

• Research and provide client with cutting edge Oracle software products. Responsible for Oracle on Linux and Windows Operating system design and capacity planning.
• Provide Oracle software products installation and configuration in compliance with FAA Standards in Standalone and RAC/ASM.
• Design and built a Development, QA, and UAT servers in support to production system.
• Leading Oracle Database migration from 10g to 11g and 12c Install and configuration
• Designed, implemented AVAMAR servers backup and recovery procedure using RMAN.
• Fine tune Oracle Production database server to achieve maximum uptime and reliability.
• Participate in (CC) Change Control meeting, schedule and deploy all Database production
• Provide support to Application users group and Oracle OBIEE Report Server.
• Installation and configuration of WebLogic in Multiple node and cluster architecture.
• Install and configured Oracle Enterprise manager (OEM) Cloud Control 13cR2 13.2.0.1
• Linux 7 64bit using Oracle Database 12.2.0.1 for OMS
• Install and deployed OMA (Oracle Management Agents) on 10 targets hosts using emcli tool
• Customized parameters thresholds and notification processes events according to response time performance indicators base line.
• Used OEM to monitor, manage and provide infrastructure, Database and Application enterprise level support.
• Diagnose, identify and resolve Database and Application performance problems in Production and Development and Testing environments.
• Provide support to development team in designing and creating instances and Database objects, install, clone, refresh and troubleshoot production and development issues.
• Used ADDM package for System, Database and Application tuning using AWR and ASH
• Clone oracle Database on demand for development and test environment
• Work with Oracle Support (MOS) to resolve testing and production issue
• Resolve above 95% Database, Application and Helpdesk tickets.
• Deploy Oracle Database CR (Customer Request) in Production system.
• Refresh Development, QA, and UAT environment from Production on demand.
• Responsibilities include Data Guard monitoring and troubleshooting.
• Setting up Golden Gate and providing day to day monitoring of Delphi to database transfer,
• Work with Application owner in planning data replication and implementation.
• Support Data Extract and apply process from multiple system to Oracle Database
• Create cron job to monitor logs facilities and sent email error notifications.
• Working with other production team to resolve all ETL interface issues to include user account and password management.
• Set up and configure Oracle database staging and extract process and load.
• Monitor loaded process and resolved any error daily to avoid staggering.
• Install, configure, monitor and troubleshoot GoldenGate software in support to standby DB Reporting/DR and MSDB flat file server synchronization in integrated/classic mode
• Search and Download the Oracle quarterly CPU/PSU patches.
• Plan for Oracle quarterly CPU/PSU patches implementation for all environments.
• Install and configure the Oracle patches in Development, QA, UAT and REMS Production.
• Work with Security team to implement FITS (Federal Information Transfer Standard) to meet
• Implementing Database security procedures/POAM.
• Identified and mitigate security rick for Oracle database categories: High Medium and Low.
• Setup Scan user account base on scan Application requirements.
• Analyze the monthly Oracle database scan Report
• Implementing Database security procedures/POAM.
• Identified and mitigate security rick for Oracle database categories: High Medium and Low.
• Setup TDE user account and wallet key store, Master key
• Create TDE encrypted tablespace and more required risk tables and index into TDE Tablespace.
• Providing Dashboard/Tableau maintenance and coding enhancement.
• Build and configure Dashboard baseline data at a beginning of each fiscal year.
• Provide support for Dashboard and Tableau Development and upgrade

Sr. Oracle Apps DBA

Confidential, Laurel, MD

Responsibilities:

• Build Linux Red Hat AS 5.3 Linux x86 64 bit servers to host Oracle 10g/11g databases servers
• Design and implement Development, QA and Production environment.
• Design and implementation RMAN NetBackup, hot, cold and Export backup for all databases.
• Upgrade all databases from 8.x, 9.x, 10.x to 11g
• Install, configure, administer and monitor Databases and Applications
• Install and configure 2 nodes 10g RAC on Linux Red Hat AS 5.3 Linux x86 64 bit servers.
• Format LUNS and create Disk Groups on SAN shared Disk for voting, ocr and all DB files.
• Install and configured database instance using ASM based storage
• Configured Grid control for Enterprise servers, Databases and application real time monitoring.
• Tuning application using sql trace, TKPROF, PERFSTAT, and OEM (AWR, ASH,ADDM)
• Plan and Migrated FIS, HRMS, GIS, MISC to new DMX system.
• Managing database storage structure, table fragmentation, tuning and partitioning
• Research, download and install required OS, Databases and Application Patches
• Provide tech expertise and support to FIS, HRMS, GIS, DWH, MISC developers, test and users group.
• Build Development, Test and production environment for ERP databases and applications migration
• Install and configure CMS application and database access for Confidential users groups
• Clone and patch All Confidential databases and applications as required by business group
• Install, configured and upgrade WAM application
• Diagnosed problem and Upgrade to resolve NORTEX application issues for FIS users group
• Install, configured FIS, HRMS, GIS, DWH and CMS ODBC connectivity for all users groups
• Design, Install and configured Spatial Oracle Database for development, QA and production system
• Upgrade ArcSDE 9.2 to ArcSDE 9.3 and ArcSDE 9.3.1 for Development, QA and Production system
• Design and build multiple Geodatabases on QA and semi-production for ArcGIS application testing
• Tuned Geodatabase parameters using GIOMGR utility to maximum performance.
• Work with ESRI support to address GIS issue and resolution.
• Maintain and support GIS developers and Confidential users groups.
• Analyzed system and provide capacity planning for database and application SAN space allocation
• Plan and install and configured 11g R2 RAC.
• Participate and coordinate POC for Archival system Tools.
• Participate in all IT projects rolled out to help design high performance database architecture.
• Researching and resolve issues and filing bugs with Oracle Server development team.
• Analyze and tune development, test and production database performance issue.
• Analyze, diagnosing and tune ERP databases and applications in Development, QA and Production
• Work closely with ETL developer to tune and modify application code
• Assist ETL developer in creating new instance and database objects as needed.
• Clone and troubleshoot all Confidential databases as needed
• Refresh database, application schema and tables in support for application development efforts.
• Restore and recover database and objects to keep all up and available to users.
• Work and resolve outstanding issues through TARS with Confidential technical support.
• Design and implementation RMAN NetBackup and Export backup for all databases
• Programming Fire hydrant process codes and testing
• Successfully Deployed Fire Hydrant process and implementation to production
• Setup and monitoring nightly jobs and troubleshooting
• Provide support to all application development team by creating new instances and db objects as needed
• Build testing environment for backup to determine worse case scenario recovery time
• Assist FIS, HRMS and ERP customer as needed
• Participate in project definition and evaluation meeting
• Provide input solution for new system implementation.
• Provide advice for implementation of Oracle Grid control as adequate Oracle monitoring tool.
• Install and configure Oracle Grid Control for Confidential database and SAN storage monitoring
• Configured EMC system plug-in with Oracle Grid control.
• Migrate from base release (10.2.0.3) to latest release (10.2.0.5)
• Download, install and deploy Oracle agent services on monitored EMC DMX Servers
• Install and configured Grid control release (10.2.0.3)
• Provide presentation to team and managers after completing Grid base product configuration
• Upgrading Grid control from release (10.2.0.3) to release (10.2.0.5) in support to SDE, GIS, FIS, ERP, EAM and CRM application hosted by EMC (SAN) server’s for real time performance monitoring,
• Install and successfully configured Oracle Enterprise Manager System Monitoring CLARIION plug-in for SAN real time performance monitoring and reporting.
• Provide daily status Report to IT system support

Sr. Oracle DBA

Confidential, Washington DC

Responsibilities:

• Build Linux Red Hat AS Linux4.x x86 64 bit servers.
• Design and rebuilt NHTSA databases servers to meet industry standards.
• Lead DBA Project efforts and mentor other administrators and end users.
• Ensuring high customer satisfaction rates.
• Implement OFA for all Oracle blade servers ( Windows 2003/ Linux update4)
• Successfully completed all NHTSA Oracle Database Migration from Windows 2003 physical servers to Windows 2003 Blade servers.
• Providing consultation on SQL Server to development teams.
• Installing, configuring, administering and securing clients' production servers.
• Design custom-tailored backup/restore and disaster recovery plans for production servers.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Implementing and administering database replication between SQL Server databases.
• Writing code and creating jobs to automate repetitive tasks.
• Standardization of all NHTSA SQL server/Oracle servers physical layout.
• Lead and implemented all NHTSA Oracle Databases Migration from 9i to 10g.
• Provide assistance to Solaris migration to Linux project.
• Provide assistance to other NHTSA projects migration efforts.
• Recommend implementation of patches when appropriate.
• Implemented CPU critical Patches on all NHTSA Oracle servers.
• Design and implemented naming convention for new NHTSA Applications.
• Design and implement Oracle Linux physical layout standards for NHTSA.
• Reconfigure and move Oracle database servers to comply with new standard architecture
• Design and implement backup strategies for all Oracle Databases on Windows and Linux OS
• Assist in architecture design for all Oracle application and database servers and interact with both the system admin, infrastructure and application teams to successfully carry out the application configuration project plan
• Create appropriate databases and database structures based on application usage
• Provide guide lines for VERITAS Oracle database server backup setup and configurations.
• Work with system administrator to design, implement and troubleshoot VERITAS backups jobs
• Ensure application availability by achieving 99.99 % Production Databases Uptime for critical NHTSA Grants and Procurement system.
• Configure Oracle Enterprise Management server to be used for Oracle database monitoring enterprise wide. Troubleshoot and resolve all oracle products related issues
• Install, configure, upgrade and troubleshoot TOAD for developers and application users.
• Install, configure, upgrade and troubleshoot Crystal Report for procurement application users.
• Assist in Designing and implementing Disaster Recovery site
• Assist in Designing and implementing RAC on Linux.
• Provides support to NTHSA Oracle Application users.
• Stay informed of Oracle patches for bug fixes and recommended
• Constantly keep managers abreast with Oracle Database best practice.

Oracle DBA Engineer

Confidential, Washington DC

Responsibilities:

• Setup OEM and OMS for all instances, Servers monitoring and data collection
• Maintained OEM for Standard Events monitoring and Data collection.
• Troubleshoot and resolve all OEM issues
• Provide Reports and performance metrics to managers and users for troubled issues.
• Proactive local and remote database monitoring and troubleshoot all OEM error notifications
• Monitor table spaces to detect those close to their maximum extent.
• Check memory and table space for fragmentation.
• Manage Schema for multi-user system and database application account and role.
• Check the system table space if containing any user objects.
• Troubleshoot database and application slow performance. Worked with Oracle Support.
• Check Operating file system usage, disk space and take appropriate action.
• Move or rename database instance. Rename log files and temporary table spaces if needed.
• Monitor nightly jobs and archiving for Standby database.
• Packages and procedure in support the development team.
• Maintain all databases up and running and available to users.
• Coordinate migration Operation with user communities.
• Customized all Database and OEM configuration files
• Develop pre-migration scripts such as Table space, DB objects info and validation…
• Upgraded 102 Databases from Oracle version 8.1.7 to 9.2.0.1 and upgrade to 9.2.0.7.
• Apply required and recommended Patches to resolve bugs, security issues and for upgrades
• Performed security audit and resolved all risks as published by Oracle “ Voyager Code”
• Implement Hot and Cold backup in production environment.
• Work with Unix Sys admin to implement backup process for new Servers.
• Clone databases and objects in support to development team.
• Maintained standby site Server, activate or switch over if needed using customized scripts.
• Setup OEM for all database Events system monitoring and notification
• Perform system monitoring using OS tolls such as top, sar, iostat, vmstat…and database
• Report and provide proactive input solution to performance improvements.
• Support application developer in tuning application code. Troubleshoot ORA-error occurrences
• Tune SQL statements. Schedule table and indexes analyze on crontab.
• Checking tables and Indexes for fragmentation and reorganize/rebuild indexes in a regular basis.
• Planned, ordered and install Oracle 9i and 10G software and third party software.
• Use Oracle pre-install script to tune Unix, Linux /Oracle Kernel as pre-install task
• Create database as requested by application users
• Configure OEM on HP Service Guard for enterprise wide monitoring.

Sr. Oracle Database Administrator

Confidential, Lanham MD

Responsibilities:

• Proactive local and remote database monitoring and troubleshooting.
• Develop monitoring scripts, run Jobs and troubleshoot failed jobs.
• Monitor and update statistics on DBA TABLES using DBMS STATS packages.
• Monitor table spaces to detect those close to their maximum extent.
• Check memory and system table space for fragmentation.
• Check Operating file system usage, and take appropriate action.
• Monitor nightly jobs and archive directory.
• Monitor Oracle Alerts and resolve any Oracle error.
• Create database and objects to include tables, indexes, views, sequences, procedure.
• Create and implement multiple backup strategies according to database environment
• Monitored Hot and Cold RMAN backup and resolved error if any.
• Work with Unix Sys admin to implement SHADOW process to nightly refresh Reporting system.
• Develop sequential scripts jobs to be implemented in AUTOSYS.
• Clone databases and create objects in support to development team.
• Perform system monitoring using OS tolls such as top, sar, iostat, vmstat…
• Database statistics gathering using STATSPACK, DBSM STATS and sql scripts.
• Report and provide proactive input solution to performance improvements.
• Support application developer in tuning application code.
• Troubleshoot ORA-error occurrences to include ORA-1000.
• Monitor dba tables and dba indexes to ensure that all tables and indexes have been analyzed.
• Monitor SGA/PGA: database buffer cache and shared pool (library and dictionary) cache hit ratio
• Installation:
• Plan and install multiple Oracle and third party software to include Oracle database server 9i/10g
• Installed 10g Grid control to automate system and Oracle database monitoring enterprise wide.

Oracle Database Administrator

Confidential, Washington DC

Responsibilities:

• Installed 9IAS infrastructure, Application Server and 9i Database in the three-tier architecture.
• Assisted architect team in 9IAS architecture design.
• Configured 9ias infrastructure, 9ias middle-tier and 9i Database tier.
• Configured Ultra Search application to work with Portal.
• Configured OEM web site and OMS in support to database administration environments.
• Configured HTTP Server and Web Cache
• Participated in logical and physical Database design.
• Performed Entities and Attributes mapping.
• Implemented logical Design into physical database design.
• Participated in Oracle workflow to determine the optimal objects template and process flow.
• Performed capacity plan for storage definition prior to database creation and configuration.
• Designed backup and recovery strategy and documentation.
• Implemented backup using scripts, RMAN and Operating system Utilities.
• Created and customized backup scripts.
• Configured RMAN backup policy.
• Recovered database as needed.
• Maintained all databases up and running and available to users.
• Implemented database security policy, create and manage Database user account and privileges
• Created, maintained Ultra Search instances for multiple users.
• Performed Schema analysis from external source prior to ETL data in Oracle database.
• Performed data load using PL/SQL and 9i MERGE new feature.
• Loaded BLOB objects into Object template table in support workflow process.
• Applied required and recommended Patches to resolve bugs issues and for upgrades.
• Maintained iasdb up and running, create portal Groups and Pages.
• URL registration, data source creation, infrastructure and middle-tier components maintenance.
• Assisted management in determining the best practice for database environment.

Principal Oracle Database Administrator

Confidential, Arlington, VA

Responsibilities:

• Proactively monitored all production, development and test databases within the Network.
• Analyze online Error messages to resolve all issues and minimize operation down time.
• Providing input solutions to achieve High Availability.
• Analyzed and reported on poor databases performance, design or inefficient application code.
• Installed and configured latest Oracle software version, patches and tools.
• Physical database design and creation using DBCA or scripts
• Provided input solution for capacity planning.
• Created and maintained hot Database Objects in support to application availability.
• Perform monthly Objects maintenance by Exporting; truncating, coalescing fragmented tables.
• Check for objects growth to detect those close to their max extent limit and provide input solution.
• Monitored primary database, maintain standby database, check and maintain archive destination
• Resolved issues relevant to arch process getting stuck due to space or Database hanging.Performance tuning and monitoring.System statistic gathering and analysis.
• Set up database buffer cache advisory for Database tuning (PGA, SGA)
• Maintained and analyzed tables and rebuild indexes for performances and query optimization.
• Implemented Oracle account password policy in the Network.
• Built a chart to gather all Databases characteristics and OS version as source of information.
• Upgraded/migrated Databases to latest (version 8.1.7.4/9.2.0.2 ) download and apply Patches.
• Worked with Oracle Support to implement security recommendations.
• Resolve any bugs, security patches and updates.
• Analyzed and implemented backup strategy to ensure zero data lost implementation
• Monitor logs transport service, backup process to ensure all Databases are backed up.
• Monitor Cold, Export and RMAN daily Backup
• Report on 180 Servers backups on (UX and NT/2K/XP) hosting more than 250 Databases.
• Maintained and modified database and backup scripts to perform scheduled jobs.