SUMMARY:

• To obtain Oracle DBA position and contribute more than 15 years experience and expertise in IT industry
• More than 15 years of experience as Oracle DBA (Plan, Build, Operate) with oil, gas, CAD/CAM, printed circuit board assembly, manufacturing, telecommunication, health, government, financial and online travel experience

TECHNICAL SKILLS:

Database: Oracle 12c (12.1.0.2.0 ), Oracle 11g R2 (11.2.0.4.0 ), Oracle 10g R2, Oracle Real Application Clusters (Oracle RAC), Oracle Automatic Storage Management (Oracle ASM), Oracle Data Guard (standby database), Oracle Recovery Manager (RMAN), Oracle GoldenGate, Data Pump, export and import utilities, Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0), SQLPLUS, PL/SQL, AWR, Disaster Recovery, Oracle SQL Developer, TOAD, Quest Central, OLTP (Online transaction processing), OLAP (Online Analytical Processing), data replication technologies and Cross - platform Database/Data migration;

OS: UNIX (HP-UX, SunOS, Sun Solaris, Confidential AIX, Oracle Linux (5.6, 5.9, 6.5, 6.8), Redhat Linux (5.9, 6.8), CentOS 5.5, 6.2, 6.5;

Hardware: HP ProLiant DL380 G7, Dell PowerEdge R920, SUN, Amazon Web Services (AWS);

Languages, tools and software: C, SED, AWK, vi, UNIX shell scripts, html, SSL (Secure Sockets Layer), VMware, Oracle VirtualBox, BMC Remedy, KRON, C Shell

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Oracle patching, upgrades, installs, incident troubleshooting on large environments.
• Supports on an on-call basis (24x7) the daily operations
• Performs day-to-day maintenance of databases and monitors database statistics; ensures that sufficient back ups are taken by operations to recover from any situation
• Carries out capacity planning and monitoring for the databases to ensure that disk space is adequate
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Implements regular and ad hoc changes in production to code, database or data by job process request
• Schedules and performs preventative maintenance of re-indexing of the databases (e.g. defragmentation of the disk space); monitors the databases for system resources, space usage and plans for growth
• Oracle Golden Gate

Environment: Oracle 12c (12.1.0.2), 10gR2, 11gR2 (11.2.0.4), Oracle Real Application Clusters (Oracle RAC), Oracle Data Pump, Oracle Enterprise Manager 12c, Oracle Enterprise Manager Cloud Control 13c Release 1 (13.1.0.0), Oracle Golden Gate, Oracle Data Guard, Red Hat Linux 6.5, Confidential AIX, Sun OS, Linux SUSE

Oracle DBA

Confidential, Bothell, WA

Responsibilities:

• Database upgrade
• Release deployments
• Index rebuild, table reorganize
• Database backups/restore processes
• Disaster Recovery
• Very Large Database support, 2+ Terabytes
• Oracle Golden Gate

Environment: Oracle 10gR2, 11gR2 (11.2.0.4.0 ), 9i, Oracle Real Application Clusters (Oracle RAC), Oracle Data Pump, Oracle Enterprise Manager 12c, Oracle Golden Gate (Unidirectional replication, Bidirectional replication), Red Hat Linux 6.5, Confidential AIX, Oracle Solaris

Senior Database Administrator

Confidential, Bellevue, WA

Responsibilities:

• Oracle Linux administration for testing and development environments
• Design, set up, install, administer, patch, upgrade and support Oracle 10gR2, 11gR2, 12c database, Oracle Data Guard, Oracle Enterprise Manager 12c for production, testing and development environments about the applications, such as Confidential Netcool Network Management, HP Network Automation and BMC Capacity Optimization
• Upgrade BMC Remedy database from Oracle 10gR2 RAC to11gR2.
• Migrate the database for Google Double Click from MS SQL Server to Oracle 11g R2
• Monitoring space usage, diagnosing errors, and developing automated backup procedures.
• Tools development for database monitoring to ensure uptime and performance. Shell Scripting
• Responsible for all phases of database administration on production, testing and development environment.
• Installation and configuration of multi-datacenter MySQL Replication, with both Master-Slave and Master-Master replication.
• Work with database developers and engineers to analyze and resolve database performance issues.
• Performing Linux OS sysadmin tasks (CentOS/Redhat) and shell scripting.
• Manage MySQL single instances, MySQL replication, MySQL Cluster in production/QA/dev environments including installation, configuration, backup, recovery, upgrades, schema changes, etc.
• Perform database health monitoring and diagnostics. Implement monitoring, auditing, and alert systems for MySQL databases.
• Troubleshoot and resolve problems with MySQL. Design, implement, maintain and automate the appropriate backup and recovery architecture required.
• Architect, design, implement and maintain site-to-site data replication for MySQL database.
• Work with various teams for performance tuning and optimization
• Perform capacity planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application needs.
• Schema design and review. Create processes to ensure data integrity and identify potential data errors.
• Document and update procedures and processes.

Environment: MySQL (5.5, 5.6) single instances and master-slave replication MySQL Cluster (7.3), MySQL mysqldump, Percona Xtrabackup, MySQL Workbench, MongoDB, BMC Remedy, Amazon Web Services (AWS)

Oracle DBA

Confidential, Bellevue, WA

Responsibilities:

• Responsible for ensuring availability and performance of the databases that support the BlackBerry production and testing system
• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
• To proactively monitor the database systems to ensure secure services with minimum downtime
• Responsible for providing trend analysis to enable the group to make informed decisions regarding resource management
• Responsible for improvement and maintenance of the databases to include rollout and upgrades
• Responsible for recommending configuration and database
• Participate in 24x7 on-call rotation
• Install, administer and support Oracle 10gR2, 11gR2 server and Oracle Data Guard (Physical and logical standby database) with large data amounts for production (60%), testing (20%) and development (20%) environments.
• Migrate production databases from HP-UX platform to Red Hat Enterprise Linux 5 platform with Oracle GoldenGate (Unidirectional replication, Bidirectional replication)

Environment: Oracle Real Application Clusters (Oracle RAC), Oracle Automatic Storage Management (Oracle ASM), Oracle Data Guard (Physical and logical standby database) for Oracle 10g R2 and Oracle 11g R2, Oracle GoldenGate, Oracle 10g R2, Oracle 11g R2, Oracle Data Pump, Oracle partitioning, HP UX, SunOS 5.10(Solaris 10), Windows XP Professional, Oracle Enterprise Manager, Grid Control, TOAD, VMware, Very large databases (VLDB, Terabytes), Oracle Database 11g Enterprise Edition Release 11G.R2 - 64bit Production, Oracle Enterprise Linux 5, Redhat Linux 5, SuSE Linux, Oracle Streams Replication, Oracle Advanced Compression, Windows Server 2008, BMC Remedy

Database Administrator, Senior

Confidential

Responsibilities:

• Provides database support services to resolve emergency problems (e.g. system/database failures, exceeding system capacity)
• Supports on an on-call basis (24x7) the daily operations related to Fidelity databases
• Performs day-to-day maintenance of databases and monitors database statistics; ensures that sufficient back ups are taken by operations to recover from any situation
• Carries out capacity planning and monitoring for the databases to ensure that disk space is adequate
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Implements regular and ad hoc changes in production to code, database or data by job process request
• Schedules and performs preventative maintenance of re-indexing of the databases (e.g. defragmentation of the disk space); monitors the databases for system resources, space usage and plans for growth
• Executes disaster recovery tests of all database production instances (Oracle 10g Physical Standby Database)
• Maintains secure database environments by Fidelity corporate standards
• Upgrading the Oracle databases from Oracle9i to Oracle10g on Confidential AIX and Sun Solaris platform.
• Install, administer and support Oracle 10gR2 server and Oracle Data Warehouse with large data amounts for production (60%), testing (20%) and development (20%) environments.

Environment: Oracle Data Guard for Oracle 10g (Physical Standby Database), Grid Control, Very large databases (VLDB, Terabytes), Oracle partitioning, data warehouse, Oracle9i (9.2.0.6.0), Oracle 10g R2, Confidential AIX (5L 5.2), SunOS 5.10(Solaris 10), Windows XP Professional, Oracle Enterprise Manager (OEM) for production, testing and development, VMware, Oracle Streams Replication, Windows Server 2003, BMC Control-M, BMC Remedy

Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Space and account management
• Physical database design
• Database monitoring and reporting
• Application and database performance tuning
• Database backup and recovery
• Defining processes, procedures, and guidelines
• Managing and monitoring database usage

Environment: Oracle9i (9.2.0.6.0), Oracle 10g R2, Confidential AIX (5L 5.2), Windows XP Professional, Very large databases (VLDB, Terabytes), Table partitioning, Oracle Enterprise Manager (OEM) for production, testing and development, ERwin, MS Access

Oracle DBA

Confidential, Bothell, WA

Responsibilities:

• Creating/supporting pre-production environment for Convergys billing system.
• New Environment setup. Setting up/Configuring Oracle Environment
• Database specific tasks. Database copy. Application installation. Third environment monitoring.
• Tool development for database monitoring to ensure uptime and performance. Shell Scripting.
• Database refresh. Production extracts specific tasks. Data import specific tasks. Loading data into various sources.
• Backup management. Configure and execute online/offline DB backup. Ensure application level backups as per environment requirements. Installation, monitoring, upgrade and troubleshooting of extracts.

Environment: Convergys billing system, Oracle9i (9.2.0.5.0), Oracle Database 10g Release 2, Oracle® Streams Replication, Oracle Advanced Replication, Oracle9i Data Guard (standby database), SunOS 5.8(Solaris 8), HP-UX (11.0), Windows XP Professional, Oracle Metalink

Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Supporting Oracle databases on HP-UX and Sun Solaris platform
• Working with data analysts and developers to transform logical data models into physical database designs tuning and recovering databases
• Upgrading the Oracle databases from Oracle 8 (8.0.6.3) to Oracle8i (8.1.7.4) on Sun Solaris platform.

Environment: Oracle9i (9.2.0.5.0), Oracle8i (8.0.6.3, 8.1.7.4), Oracle7 (7.3.4), Very large databases (VLDB, Terabytes), Table partitioning, Oracle Enterprise Manager (OEM) for production, testing and development; HP9000 Server, HP-UX (11.0), SunOS 5.8(Solaris 8), Windows XP Professional, Oracle Metalink

Oracle DBA

Confidential

Responsibilities:

• Operational DBA support for systems that are in production operations (40 databases with more than 400 GB hard disk), as well as supporting development projects throughout the life cycle, including all phases of application testing;
• Design, install, upgrade, patch, clone and implement database solutions. Participate with project architects and clients on solution design issues;
• Managing the operation and administration of databases, including backup and recovery, optimization and tuning, and relational table maintenance; Writing and maintaining database scripts; Design and implement systems of tools.
• Troubleshooting database-related system problems and creating solutions;
• Consulting with other team members and consultants on architectural and design issues
• Set up and implement advanced replication for the Oracle databases on SunOS 5.8 (Sun Solaris) platform.
• Install Oracle9i (9.2) on HP-UX (11.0), SunOS 5.8 (Sun Solaris) and Windows 2000 Advanced Server platform. Upgrading, migrating and reorganizing the databases from Oracle7 (7.3.4), Oracle8 (8.0.6) and Oracle8i (8.1.6) to Oracle8i (8.1.7) on HP-UX (11.0) and Windows 2000 Advanced Server platform for Department of Health and Wellness, Business New Brunswick, Government of New Brunswick and NB Power. Transfer data between Oracle and MS Access.

Environment: Oracle9i (9.2, 9.0.1), Oracle8i (8.0.6, 8.1.6, 8.1.7.4), Oracle7 (7.3.4), Oracle Application Server (9iAS), Microsoft SQL Server 2000; Oracle Shared Server (Multi-Threaded Server or MTS), Oracle Forms, Oracle Connection Manager, Oracle Advanced Replication, Oracle Data Guard (standby database), Oracle Enterprise Manager (OEM), Oracle Recover Manager (RMAN), SQLPLUS, PL/SQL, STATSPACK, export and import utilities, TOAD, HP9000 Server, HP-UX (11.0), SunOS 5.8(Solaris 8), Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, Windows XP Professional, SSL (Secure Sockets Layer), VPN (Virtual Private Network), Data Warehouse, MS Access, Oracle Metalink, SQL Server

Database Administrator

Confidential, Issaquah, Washington

Responsibilities:

• Oracle and Ingres database (Amdocs billing system) administration in 24X7 production and mass storage environments (20 databases for Cellular One and Voice Stream PCS) as well as HP-UX Systems administration in testing and development environments;
• Migrate database from Ingres to Oracle8i
• Installation, upgrading and modification of database servers and application tools;
• Participate in 24x7 on-call rotation
• Creation, modification and allocation of current and future system storage requirements;
• Controlling, monitoring, tuning and optimizing of user access; backup, recovery, high availability and overall performance of databases; Provide user access management.
• Development of applications for disaster backup and restoration of databases. Transfer data between Ingres and MS Access; Supporting Amdocs billing system.

Environment: Oracle8i (8.0.6, 8.1.6, 8.1.7), Oracle7 (7.3.4), Oracle Enterprise Manager (OEM), Oracle Transparent Gateway, SQLPLUS, PL/SQL, PRO*C, TOAD, Oracle Recover Manager (RMAN), Ingres 6.4,HP9000 Server, HP-UX (10.0, 11.0), SunOS, Windows 2000, Confidential AIX, ERwin, VPN (Virtual Private Network), MS Access, WRQ Reflection X, Oracle Metalink

Team Leader, Oracle DBA/HP-UX Administrator/Software Engineer

Confidential

Responsibilities:

• Project Team Leader and programmer in CIM (Computer Integrated Manufacturing) for PCBA (Printed Circuit Board Assembly) responsible implementation, testing, verification and maintenance of CIM system
• Physical and logical database design
• Consolidate detailed users' requirements. Designed and developed Oracle tables and applications such as data collection, data reports and real time charts using HP-UX, Oracle7 Server (7.1.4, 7.2.3), C, shell, Oracle Developer/2000, SQLPLUS, PL/SQL, PRO*C, MONITROL real time database, FTP PC/TCP
• Testing applications and implement them to production in Singapore and Malaysia branch of Confidential
• Provide vendor management and SQL tuning
• Design, set up, install, administer, patch, upgrade and support Oracle7 (7.1.4, 7.2.3) on HP-UX (10.0, 11.0) platform. Troubleshoot and resolve system failures
• Lead Oracle DBA and UNIX SA to provide 24x7 Oracle database, HP-UX systems administration and performance tuning, network support.
• Designed and implemented automatic and disaster backup and recovery for Oracle databases and HP-UX systems

Environment: HP9000/700 Workstation, Oracle7 Server (7.1.4, 7.2.3), C, shell, Oracle Forms, Oracle Developer/2000(Forms, Report, Graphics), SQLPLUS, PL/SQL, PRO*C, MONITROL real time database, HP-UX (9.2, 10.0), MS-Windows, FTP PC/TCP, WRQ Reflection X