SUMMARY:

• Charles Young is an Oracle DBA currently studying for his 11g . 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)
• Charles Young is an accomplished Information Systems consultant who studied Computer Science and Business Development at Kent State University in Kent, Ohio and has been employed in numerous industries gaining a good solid understanding of many business processes and markets. For example, Charles has over 20 years experience in information technology. He has worked in Banking, Health Care, Government, Engineering Process control, Network Communications, Accounting systems, Web Application deployment, a major newspaper, Confidential as a principle consultant, Bank Of America, IRS, State Department, Allen Bradley (Rockwell), Confidential, EDS and KEANE as a lead project manager and many other businesses with an I/T infrastructure. 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.

TECHNICAL SKILLS:

Oracle Related: Real Application Cluster (RAC), Failover, Clustering, DSS Data Warehouse, OLTP DBA, Oracle ACTIVE SECURITY PLUS (Security Plus)

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 Management

Architecture: VMWARE, Network topology, Firewall, System Architecture, System Capacity planning, VPN, AWS S3 services

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

PROFESSIONAL EXPERIENCE:

Confidential

Support Engineer/Database Administrator

Responsibilities:

• Hangcheck timer, split brain, RAC recovery, ASM,
• OCR corruptions, Voting disk loss etc
• Troubleshoot performance issues for the RAC instances (GC events)
• 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.

Confidential

Cloud Solutions Engineer/Database Administrator

Responsibilities:

• 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 Ellucian 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.

Confidential, New Carrollton, MD

Oracle Database Administrator

Responsibilities:

• 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

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 Confidential 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.

Confidential

Principal Oracle Database Administrator

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.