Oracle DBA

Qualifications 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
• Confidential 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, Oracle corporation as a principle consultant, Bank Of America, IRS, State Department, Allen Bradley Rockwell , Deloitte Consulting, 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.

Core Competencies

• Oracle Related: Real Application Cluster RAC , Failover, Clustering, DSS Data Warehouse, OLTP DBA, Oracle ACTIVE SECURITY PLUS CERTIFICATION
• 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 Management,
• Symmetric 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,
• 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

Oracle Database Administrator

• Primary Responsibilities include
• Installation, configuration and administration of Oracle Weblogic which includes:
• Deployment of application EAR files
• Deployment and support of Oracle Forms and Reports
• Oracle OID LDAP configuration and installation.
• Oracle OAM Oracle Access Manager configuration
• Configuration of SSL for Web server and https maintenance.
• PL/SQL development to support OID interface
• Support developers with coding and access issues.
• Installed and Configured new RAC installation on Linux Redhat 5.
• Ability to work cohesively in a team and with different functional groups and clients
• Oracle RMAN backup and Recovery
• Oracle Real Application Clusters RAC
• Oracle Enterprise Manager Grid implementations
• Very strong capabilities troubleshooting database issues
• Effective and clear communication, independent worker, and leadership skills are key.
• 7 years database design and administration experience with Oracle 10g, 11g on Linux or
• Solaris and at least 5 years experience with Oracle RAC.
• Upgraded 11g database to 12C and deployed 12C OEM.

Confidential

Oracle Database Administrator

Primary Responsibilities include

• Supported performance tuning efforts with bench mark testing based off IRS requirements.
• Utilized new 11g tuning features such as:
• SQL TUNING ANALYZER to identify bad sql statements and recommended better queries.
• SQL ACCESS ANALYZER to identify tables which would benefit from new indexes.
• Created performance base-lines with the establish measurable objectives.
• Supported data loading effort with the objective to move as much data as possible in limited time window.
• Supported developers with writing better SQL queries to improve performance and resolve problems.
• Migrated code using IBM Rational Rose into production.
• Supported documentation of new functionality and testing of new code.

Confidential

Oracle Database Administrator

Primary Responsibilities include:

• Installed configured 11gRel2 Oracle OEM Grid on Linux
• Installed and configure OBIEE 11.1.1.6
• Upgraded all application from 10g to 11g.
• Configured and deployed 11.1.1.4 Fusion Middleware.
• Configured, ASM, VIP and RAC on 2 node Linux cluster.
• Configured, 3rd NODE to cluster using Cluster Verification Utility.
• Used Cluster Verification Utility CVU to confirm installation at all phases.
• Configured 11.2.0.2 database to support oracle APEX web application.
• Deployed and Configured Web logic 10.3.4. and http server.
• Used ETL to load large amounts of data into database. Used method to improve load time.
• Configured OEM Grid and all Agents.
• Setup backup strategy using Oracle OEM best practice.
• Wrote PL/SQL programs to load Oracle BLOB into database
• Applied current CPU/PSU patch

Confidential

Oracle Database Administrator

Primary Responsibilities include:

• 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.
• Utilize Oracle Grid Control OEM to monitor and manage Oracle and Unix targets
• Monitor Alert Logs, Backups, Oracle Objects and File Server Space.
• Perform RMAN Database Backup Recovery
• Install, upgrade maintain Oracle 10g RDBMS on Unix Windows
• Installed and configured Weblogic 3.2 on Linux86 64
• Support database environment utilizing Oracle 11g RAC configurations and administration,
• including 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 effienct 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.
• ORACLE 11g ADVISOR USAGE:
• 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

Oracle Database Administrator

Primary Responsibilities include:

• Experience with Oracle 11g on Solaris/Linux servers SQL tuning and PL/SQL scripting Experience as Database Design/Physical Logical Modeling Experience with various partitioning of tables Experience as an Oracle production and development DBA skills on UNIX in 24X7 environments Experience in performance tuning and troubleshooting - drill down approach with O/S, database and application Experience in UNIX shell scripting Experience 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.
• 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.
• Created schema objects, such as tables, triggers, partitions and indexes defined in the design step
• Created the physical database and storage structures, such as tablespaces, associated with Data mart
• Designing and implementing data extraction, data load, and database synchronization routines and functions including modifications to existing procedures. Assists in specification and implementation of tables, views, indexes, integrity, security, and business rules using DDL, DCL, DML, and PL/SQL functions, procedures, and packages.
• Develops and modfies stored procedures, triggers, and batch job scripts that automate the backend processing of transaction in an OLTP environment.
• Maintains and corrects batch and automation jobs using Windows, database, and OEM schedulers.
• Performs and manages database schema changes.

Confidential

Oracle Database Administrator

Responsible for supporting 9i Oracle databases. Working under a tight deadline as part of development team. Perform data modeling, build and load database tables, recommend and implement performance-tuning strategies, develop and maintain database schema, objects and database dictionary. Implement disaster recovery procedures, and perform backups, restores, and data recovery. Ensure that system performance is robust. Apply analytical techniques when developing procedures to resolve system problems. Configured RMAN with Catalog. Install catalog as required. Registered target database with RMAN. Wrote scripts to perform COLD/HOT backups and archive logs. 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 dataload 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

Confidential

Oracle Database Administrator

BANK OF AMERICA Oracle 7.3, 805, 8i Unix Solaris, OEM, Oracle Financials PRIORITY: Configuring and Tuning 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.