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, 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. Database knowledge includes, OFA, Space, Memory, Resource and users management, Backup and Recovery Manager, Grid control, 12c EM Express. He is knowledgeable with Oracle Database/Physical Standby /RAC/Data Guard architecture, 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. He is experienced with Oracle database and Application system 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 SKILLS:

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

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

Tools: TFS/Source control, POWERBUILDER 5.x/6.x/7.x. TOAD9.x/10, SQL*Loader, CRM, Data pump Import-Export, DBMS Packages, Grid control, RMAN, ETL, SQLJ,ODBC, J2EE, Data Guard, Golden Gate, VisioLanguages: Bourne, C Korn, C shell, SQL, PL/SQL, Java, XML, ASP, JSP, JavaScript, XML

Hardware: 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, NetBackup, Laptops and Printers.

Operating systems: Windows2008/2012R1/2 REDHATS3/4/5x, HP-UX10.2/11.11, Solaris2.6/7/8/9/10/ AIX-UX4.1/4.2Apps/Others: REMS, Delphi, eDMS DOCUMENTUM 7.1, Dashboard, Tableau, FAACTS,GTS, PRISM APEX,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.\

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 to host All Oracle Databases and various Applications. Provide Oracle software products installation and configuration in compliance with FAA Standards
• Design and built a Development, QA, and UAT servers in support to production system.
• Migrate OS and Oracle Database and Application servers from AGL to MMAC data center
• Successfully lead Oracle Database migration from 10g to 11g and 12c
• Designed, implemented AVAMAR servers backup and recovery procedure using RMAN.
• Fine tune Oracle Production database server to achieve maximum uptime and reliability.
• Design and implement AVAMAR backup and recovery strategies using RMAN
• Install and establish Network connectivity between Oracle Database and heterogeneous Applications sources.
• Install, configure the TFS/Source control server and client layer for team members.
• Generate and design directory structure for DBA, developers and programmers, SOP’s…etc.
• Maintain Codes change for Database administration, development, web developers and Application developers and processes documentation
• Participate in (CC) Change Control meeting, schedule and deploy all Database production code changes.

Confidential

Application Support

Responsibilities:

• Assist in designing eDMS and Tableau Applications
• Provide technical guidance for Oracle Database and Application Lease process flow.
• Work with Documentum engineer and Tableau developers for design and configuration.
• Provide Oracle database architecture design to engineer and developers for metadata.
• Setup, configure eDMS and Tableau backend and network connectivity and support.
• Design and create eDMS and Tableau database objects such as Tablespaces, schema, tables, views, Mviews, triggers and procedures.
• Design and create eDMS and Tableau database jobs in support to applications
• Design and create daily and weekly backup jobs and generate monthly Reports.

Confidential

ETL-Interface Support

Responsibilities:

• Responsibilities include setting up Golden Gate and providing day to day monitoring and control of Delphi to database transfer, DR and various Application data replicat
• Working with Delphi production team and application team to resolve all interface issues to include Dephi system 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 and configure GoldenGate software in support to standby Reporting/DR and MSDB flatfile server synchronization in integrated or classic mode.
• Work with Application owner in planning data replication and implementation.
• Monitor and support Data Extract and apply process from Delphi system to Oracle Database
• Create cron job to backup Goldengate Home Directory

Confidential

Customer Support

Responsibilities:

• Provide support to development team in designing and creating instances and Database objects, install and configure Oracle client software and establish network connectivity.
• Resolve above 95% Database and Application Helpdesk tickets.
• Deploy Oracle Database CR (Customer Request) in Production system.
• Monitor, check and validate all Database system refresh jobs.
• Refresh Development, QA, and UAT environment from Production on demand.

Confidential

Database Security Support

Responsibilities:

• 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)
• Setup Scan user account base on scan Application requirements.
• Analyze the monthly Oracle database scan Report
• Find solutions to mitigate identified security rick for Oracle database categorized in High Medium and Low.

Confidential

Dashboard/Tableau Application Support

Responsibilities:

• 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 DBA/Consultant

Confidential, Adelphi, MD

Responsibilities:

• Responsibilities included and not limited to installing Sun, Database 10g/11g and Application server software.
• Design, install, configure database on Sparc x 86 64 bit and network connectivity.
• Install and configure Grid control and management agents on all servers. Support APEX Applications and databases and troubleshooting.
• Work with Oracle support to install to configure EXADATA v2 and CDC stream implementation.
• Analyze and provide Capacity planning for database and backup storage and strategies. Install and configure and upgrade recovery catalog to 11g.
• Develop scripts for RMAN, hot backup and data pump for Confidential on primary site and is providing outstanding services in configuring oracle products to meet customer requirements.
• Client server and web base environment setup and troubleshooting. Perform Patch installation and maintenances in all Development, QA and production standalone and RAC environments. Provide management with oracle database best practice and documentations

Sr. Oracle and Apps DBA

Confidential, Laurel, MD

Responsibilities:

• Build Linux Red Hat AS 5.3 Linux x 86 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 x 86 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 sqltrace, 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 WSSC users groups
• Clone and patch All WSSC 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 WSSC 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 WSSC 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 WSSC 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 x 86 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
• 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.
• Configure 9i/10g databases. Configure 10g Grid control and monitoring Services.