Manager Management

Stephen Fangyen

Oracle DBA - Corporate Express

Riverdale, MD 20737

acs2ur@r.postjobfree.com - 240-***-****

• Over 4 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g.

• Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.

• Monitored physical I/O and Proper sizing of rollback segments.

• Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

• Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.

• Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.

• Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

• Created Users, Roles and Profiles, Privilege management with role-based security.

• Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.

• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

• Upgraded Oracle 10g database version to 11g

• Upgraded Oracle 11g database version to 12c version

• Provided database related services to their development & QA environments.

• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.

• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.

• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.

• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.

• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.

• Wrote scripts to inform the DBA team on the status, performance and space management of the database

• Participated in planning and implementation of off-site Disaster-Recovery planning and testing

• Worked with development and operations staff in resolving problems quickly and efficiently

• Resolve the bottlenecks in all the database environments.

• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.

• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.

• Experience in Logical backup using and full/ partial export/import and Data Pump.

• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity

• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours. TECHNICAL ENVIRONMENT

Willing to relocate: Anywhere

Authorized to work in the US for any employer

WORK EXPERIENCE

Oracle DBA

Corporate Express - Broomfield, CO - May 2014 to Present Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

• Installation of oracle 11g databases in production, development and test environments depending on project requirements.

• Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database

• Refreshing development/test database from production using Export/Import & RMAN backups.

• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.

• Managing database security.

• Creating and assigning appropriate roles and privileges to users depending on the user activity.

• Defragmentation of tables and indexes for improved performance and effective space management.

• Have touch-point calls with offshore team and make sure all issues happens in off business hours are addressed with sense of urgency.

• Setup the unidirectional replication on oracle 11g databases using Goldengate.

• Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.

• Successfully upgraded the databases from 11g to non CDB 12c.

• Successfully migrated 12c Non CDB databases to pluggable databases.

• Created Oracle Wallets and implemented Tablespace level TDE security.

• Managed Database Maintenance Activities to achieve optimum database uptime.

• Configuration of Listener and Tnsnames.

• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.

• Created database link between two databases to access the table data from one local database to remote database using distributed database feature.

• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

• Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

• Designed Logical and physical database for business transaction functionality.

• Provide production support for the deployed project till it is stabilized.

• Written SQL scripts to create database objects like tables, views and sequences.

• Created procedures and functions using PL/SQL.

• Preparation of High Level & Low Level Design documents. Oracle DBA

TCF Bank - Chicago, IL - August 2012 to April 2014 Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.

• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.

• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.

• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.

• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.

• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.

• Responsible for all database activities such as User management, space management, database security management.

• Implemented the resizing the online redo logs in production and in standby database.

• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.

• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.

• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)

• Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.

• Refresh/Cloning of Database from production environment to test environment and application of patches.

• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers

• Experienced of managing and administering 24 X 7 running databases and support

• Applied bug patches according to the Oracle Critical Patch alerts.

• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.

• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.

• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

• Maintained the data integrity and security using integrity constraints and database triggers.

• Provided 24X7 support for all the production and development databases. Unix Administrator/Junior Oracle DBA

Allstate Insurance - January 2011 to July 2012

Environment: RHEL 3.X, 4.X; Windows NT 2000/2003; Oracle 10g; LPARS; VMware ESX Server; Veritas Volume Manager; HP DL320, DL330, DL380; EMC Celerra NS; Hitachi; IBM arrays. Responsibilities:

• Configuration & Administration of Red Hat Linux 3.X/ 4.X at various client servers and service provider's servers.

• Install FTP/TFTP/SFTP Server and set up network connections.

• Configure RAID control partitions.

• Install RPM packages for all the above mentioned modules on servers at client site as well as the service provider's site.

• Install and execute health monitoring module and dial up connection reporting module on client sub systems and monitor the communication failures etc.

• Configure servers to use HTTP, DNS, NFS, NetBackup, Storage Disk configuration.

• Diagnose and correct boot failures arising from boot loader, module, and file system errors on Red hat Linux.

• General Network issues troubleshooting related to network outages.

• CRON tab entry experience.

• Use ILO/HMC for remote access of servers on Red hat Linux/AIX respectively.

• Troubleshoot hardware, software and Operating system related errors on Red hat Linux and AIX.

• Performed system-monitoring tools like TOPAS, SAR, VMSTAT, IOSTAT to report systems usage and performance.

• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

• Worked closely with Application Developers to design/create new Oracle databases/create new schemas/ database objects, as well as making database changes from DEV to PROD, via TST following requests/ demands from the development team.

• Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

• Maintain & troubleshoot Storage Disks from HITACHI, NetApp and EMC Celerra Storage arrays. EDUCATION

Prince George's Community College

COMP.DBAS.CT Database Systems, Certificate

CERTIFICATIONS

Oracle Certified Associate

ADDITIONAL INFORMATION

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP RDBMS: Oracle 11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM WEB TOOLS: HTML, XML

Contact this candidate