SUMMARY:

• Confidential is an Oracle DBA currently studying for his 11g Certification. He comes with 17 years’ experience working with 7/8i/9i/10g/11g DBA/System Architect who has experience in the Oracle Grid Control, Oracle 11g Rel2 database server, Real Application Cluster (RAC), Real Application Testing (RAT) FAILOVER, CLUSTERING, DSS Data Warehouse and OLTP DBA, Data Modeling, OBIEE (Forms and Reports) Data Mining, Data Migration (Extraction, Transformation, Loading - ETL), Oracle Application Server 9-10g, IBM WebSphere, Oracle E-Business Suite 11i CRM,ER/WIN data modeling, PL/SQL, ProC, SQL Developer, Oracle Designer 2000, Oracle Workbench Migration tool and Oracle Advanced Security database encryption, Transparent Data Encryption (TDE)
• His skills encompasses, Software development, B2C & B2B E-Commerce, Networking, Disaster Recovery, Data warehousing Database Administration
• His objectives as a Team Lead / System Architect include technological innovation, exploration of technological advantages and application of advanced technology to fulfill the project contractual requirements and deliverables.

CORE COMPETENCIES:

Oracle Related: Real Application Cluster (RAC), Failover, Clustering, DSS Data Warehouse, OLTP DBA, Oracle 9iAS w/ Portal, Oracle Designer, Distributed Configuration Management (DCM), and Oracle E-Business Suite

Database Skills: 11g SQL Performance Analyzer, SQL Tuning Advisor SQL Access Advisor, 11g Database Reply, Cost Base Tuning, Database Upgrade, Data Modeling, Data Mining, Data Migration, Extraction, Transformation, Loading (ETL), OEM tuning pack, explain plan, SQL Analyze, Index Tuning, Oracle Expert, Partitioning, Parallel Query SQL Developer, Toad Spotlight, STATSPACK, Log Miner, RMAN

Database Server: Oracle 12c,11g/10g/9i/8i/7

Operating System: Solaris, Red Hat Linux, Wintel, Windows 2008, VMS, UNIX Solaris 10, Oracle VMware

Process: System Development Life Cycle (SDLC), Build Management, change ManagementSymmetric Remote Data Facility (SRDF), Configuration Management (CM), Version Control, technical support (24x7), PVCS, and CVS

Architecture: VMWARE, Network topology, Firewall, System Architecture, System Capacity planning, VPN, AWS S3 services NAT, system administration, network administration, hardware specification and procurement, UML

Database Tools: Erwin, Toad, Benthic, Oracle Grid Control, SQL Server Management Studio, SQL Server

CHRONOLOGICAL EXPERIENCE:

Confidential

Support Engineer/Database Administrator

Responsibilities:

• Installed and configured 11gRel2 Oracle OEM Grid on Linux Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issuedeinstallation & cleanup of clusterware) Testing and benchmarked the application prior to going into production to determine its effects on GES and GCS with special focus on load testing for interconnect traffic.
• OCR corruptions, Voting disk loss etc
• Troubleshoot performance issues for the RAC instances
• Used Cluster Verification Utility (CVU) to confirm installation at all phases.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware)
• Issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Add or Remove Node from RAC as required.
• Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.

Confidential

Cloud Solutions Engineer/Database Administrator

Responsibilities:

• Install, configure, upgraded, patched and maintained technology stacks and applied Security Best Practices to debug issues related to technology stacks.
• Coordinate physical and logical changes to enterprise databases, enterprise middleware components, and Tomcat. ERP experience in supporting RDBMS, middleware.
• Analytical and Technical Problem Solving Skills; Willingness to Engage in Process. Additional duties included implementation and configuration of application components within Banner Technologies.
• Support database and Weblogic vulnerabilities quarterly patching. Vetted Confidential technology stack such as confirming version and of DB, Weblogic, Tomcat, and JAVA in preparation of AWS migration.
• Migrated databases from local environment to AWS. Due to DB size, 2-6TB, used AWS Snowball where we were provided a local device to store STANDALONE databases which was shipped to AWS database center and made available by AWS engineers. Platform was Linux 6.

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

• Configured SSL for Weblogic installation and https to support APEX 424 deployment.
• PL/SQL development to support OID interface
• Supported developers with coding and access issues.
• Installed and Configured new RAC installation on Linux Redhat 6.
• Ability to work cohesively in a team and with different functional groups and clients
• Used RMAN to restore from previous backup due to data corruption issue.
• Oracle Real Application Clusters (RAC)
• Implemented nightly backups using Oracle Enterprise Manager (Grid)
• Very strong capabilities troubleshooting database issues
• Configured Oracle 11g Data Guard database.
• Could not use DUPLICATION command to create Standby due to 15TB size.
• Used RMAN to RESTORE/RECOVER Primary to Standby server.
• Configured Transport service to bi-directional log file movement.
• Tuned archive log switching by increasing size.
• Used Maximum Performance (asynchronous)
• Used Switch Over to confirm failover.
• Setup DGMGRL to use SHOW CONFIGURATION command to Monitor.

Confidential, Fredericksburg, VA

Oracle Database Administrator

Responsibilities:

• Upgraded all databases from 10.2.0.4 to 11.2.0.2 using Banner application using Oracle recommended best practices.
• Upgraded ebusiness R11.5 to R12 using best practices on Linux 5.
• Applied Oracle Advanced Security using Transparent Data Encryption (TDE) using Oracle Wallet.
• Applied current CPU/PSU patch
• Installed and configured Oracle OEM Grid on Linux Redhat
• Install Oracle APEX and configured with Weblogic
• Upgraded Oracle Forms from 10.1.2.3 to 11.1.0.4 using WebLogic.
• Utilized Oracle Grid Control OEM to monitor and manage Oracle and Unix targets
• Monitor Alert Logs, Backups, Oracle Objects and File Server Space.
• Performed RMAN Database Backup & Recovery
• Install, upgrade & maintain Oracle 10g RDBMS on Unix & Windows
• Installed and configured WebLogic 3.2 on Solaris
• Supported database environment utilizing Oracle 11g RAC configurations and administrationincluding Grid Computing, Clusterware and ASM, in a Solaris 10/Linux 64bit environment.
• Implemented RAC SERVICE configuration for ACTIVE/ASYMMETRIC on a three node cluster to measurement workloads when tuning and more efficient utilization of resources. Configured two physical Standby databases by moving data from PRIMARY to physical STANDBY1 and created another ACTIVE physical Standby STANDBY2 that received REDO from STANDBY1. STANDBY databases were created using OEM 11g Rel 2.
• Utilized Access Advisor to determine index usage or partition.
• Segment Advisor to determine which segments are eligible to be shrunk.
• Utilized SQL Repair Advisor to determine if a patch is required.
• Utilized SQL Tuning Advisor to determine to evaluate Oracle’s rewritten choice and test results.
• Utilized Oracle Recovery Advisor
• Utilized SGA Advisor to determine best size of SGA for throughput gain.
• Tuned databases accordingly using SQL Tuning Advisor
• Utilized UNDO advisory to best size of UNDO based off recent database activity
• Used SPA (SQL Performance Analyzer) to anticipate changes to sql before upgrade or parameter change.
• Duplicated/Clone Oracle Database using RMAN
• Deployed Active Standby database using Grid Control 11.1
• Deployed OBIEE 11g using Weblogic 3.2 as middle tier
• Deployed 11g Agents
• Implemented Oracle Recommended Backups using OEM Grid Control 11.1

Confidential, New Carrollton, MD

Oracle Database Administrator

Responsibilities:

• Experience with Oracle 11g on Solaris/Linux servers
• SQL tuning and PL/SQL scripting
• Assisted with Database Design/Physical & Logical Modeling
• Setup partition tables to improve performance and maintenance .
• Wrote shell scripts in Solaris to perform daily maintenance such as monitoring file system storage, running nightly batch jobs, checking backup status and refreshing data.
• Experienced with OEM
• Lead in database architecture design and implementation for numerous IRS projects such as EFDS which is a major system designed to detect tax fraud.
• Deployed Oracle APEX using Webtier 11.1.0.2 HTTP listener and configured SSL
• Supported Oracle Business Intelligent Forms and Report for installations and deployments.
• Created the physical database and storage structures, such as tablespaces, associated with Data mart
• Created schema objects, such as tables, triggers, partitions and indexes defined in the design step
• Worked with developers on programming interface to database. Identified best data access method to gain best performance. Assist in development of methodology for ongoing assessment of data performance.
• Designed and implemented data extraction, data load, database synchronization routines and functions including modifications to existing procedures. Assisted in specification and implementation of tables, views, indexes, integrity, security, and business rules using DDL, DCL, DML, and PL/SQL functions, procedures, and packages.
• Developed and modified stored procedures, triggers, and batch job scripts that automate the backend processing of transaction in an OLTP environment.
• Maintained and corrected batch and automation jobs using Windows, database, and OEM schedulers.
• Performed and managed database schema changes.

Confidential, McLean, VA

Oracle Database Administrator

Responsibilities:

• Responsible for supporting 9i Oracle databases.
• Working under a tight deadline as part of development team.
• Performed data modeling, recommended and implemented performance-tuning strategies, developed and maintained database schema, objects and data dictionary. Implemented disaster recovery procedures, and performed backups/restores, and data recovery.
• Ensured that system performance is robust.
• Applied analytical techniques when developing procedures to resolve system problems.
• Configured RMAN with Catalog. Install catalog as required. Registered target database with RMAN on Solaris.
• Wrote scripts to perform COLD/HOT backups. Worked with NetBackup engineer to link RMAN with NetBackup apps.
• Installed 9i for production database configuration
• Installed and managed Oracle Designer2000 repository and assisted with modeling the TSA enterprise model.
• Configured Oracle RAC formally OPS to support the Oracle Apps 10i CRM application.
• Migrated legacy data from various systems into Oracle 11i Teleservices application.
• Wrote PL/SQL programs using Oracle's 11i APIs as interface to migrate data. Working knowledge of CLOB and BLOB data type conversion, Dynamite SQL, various packages
• DBMS DDL and Autonomous Transactions.
• Worked on design and configuration of Oracle Data warehouse. Applied range partition, Parallel processing, 9i latest feature Muli-Table Inserts, BULK processing and External Tables to improve data load times, Range Partitions, Resumable Space Management and other features as need.
• Experience with many 9i features and techniques.
• Used Oracle Workbench to migrate data from Microsoft SQL Server to Oracle. Also wrote procedures to transform data. Worked with Oracle corporation engineers to identify APIs necessary to push data from transformed base tables to backend Oracle11i tables. Have good understanding of 11i data structures and foundations. Team was mentored by Tom Kyte, Oracle's leading software engineer specialist on form, function, design and style.
• Working part-time in the evening as an Oracle DBA instructor for Omega Computer Training Institute

Principal Oracle Database Administrator

Confidential, Reston, VA

Responsibilities:

• Supported Oracle Financials performing the following task:
• Increased size of SYSTEM tablespace to support packages and triggers. Set size at 200MB
• Created GL user with own TEMPORARY tablespace to support heavy transaction usage.
• Setup batch routine to periodically truncate interim tables to avoid space usage problems.
• Identified procedure/package usage and PINNED to memory for better performance.
• Worked with SysAdmin to setup CONCURRENT MANAGER to 3 as background process
• Sized SGA to 150MB also increase SHARED POOL SIZE. Block size was increased to 4K.
• Worked with users to identify the heaviest usage tables proactively accommodate for growth.