SUMMARY:

• Highly motivated, results driven Oracle Database Administrator with 10+ years of solid experience both as both application and production dba, supporting development, testing and production environments in diversified domains on various versions of UNIX/LINUX and windows operating systems for a variety of applications. To seek an Oracle Database Administrator position to support enterprise databases and applications.
• Solid experience as Oracle DBA in database administration, application development, production support, installation, configuration, upgrades, performance tuning, backup and recovery, clone/duplication, migration, space management, troubleshooting, and database security, on premise, virtualized, cloud, hybrid environments, on different Linux( RedHat Enterprise Linux, Oracle Enterprise Linux, Suse Enterprise Linux, Centos etc.), Sun Solaris, HP - UX, Tru64, AIX, and Windows Platforms for different applications
• Solid installation, configuration, upgrade, tuning and troubleshooting experience in Oracle 10g/11g/12c RAC (Real Application Cluster), Oracle Restart(Single Instance on ASM), etc. on filesystem or ASM, on single tenant or multitenant, on physical hosts and virtualized environments
• Solid Experience in support application design/architecture/development/QA/UAT/production deployment using SDLC methodology. Database schema/objects change management, including tables/partitions/sub-partitions, indexes, constraints, views, materialized view, sequences, triggers, synonym, roles, grant, package, and stored procedures etc. using SQL, PL/SQL and Unix shell script, reference data/seed data change management and version control, SQL Baseline Plan Management, Build/deploy database change kit from version management repository and propagate from dev, to QA, testing and production deployment per SDLC.
• Extensive database upgrade experience from 9i to 10g, 10g to 11g, 11g to 12c, and patchset upgrade between major releases. Extensive patching experience using OPatch/MOPatch. Perform PSU apply process to the DEV/QA/UAT/PROD databases to meet security standard. Using script for database install/upgrade/configuration/patching for automation to improve efficiency.
• Solid experience in database migration of databases within and across hardware/os platform, from non-Exadata to Exadata, within and cross data center, between on premise and cloud (AWS, Azure etc.). Extensive experience in design and implement different migration technology/methodology for migrating databases, using RMAN/Data Guard, Golden Gate, transportable tablespace, data pump, external table etc, depending on database size, down-time requirement etc.
• Solid Hands on experience in performance tuning using Automatic Workload Repository (AWR), Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM), SQL Tuning Advisor, Explain Plan, SQLT, SQL Baseline Management, SQL Profile etc.
• Solid Experience in design and implement different Backup and recovery strategies using Data Pump (Expdp and Impdp), RMAN( RMAN to disk, and RMAN to tape library/backup appliance integrated with third-party MML layer/commercial backup software like TSM, Netbackup, Commvault, Data Domain/DD Boost etc.), SAN replication based backup strategy etc.
• Configuration, installation and maintenance of Oracle Data Guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Solid knowledge in database related storage, like SAN, NAS, NFS, ACFS etc. Extensive experience in forecasting database growth, and provision SAN space and design SAN LUN sizes. Format/Partition LUN, and configure LUNs using udev or oracle asm lib with and without multipathing to present LUNs to Oracle ASM. Add LUNs to existing ASM diskgroup and rebalance. Create new ASM diskgroup using sql or asmca, support on ASM/ACFS for SAN array migration.
• Solid experience managing database security and authorization(user, role, profile, object and system privileges etc.) for application and human users; Transparent Data Encryption(TDE) and wallet management etc. Solid experience in SQL, PL/SQL, RMAN, exp/imp. expdp/impdp, SQL*Loader, Autosys JIL, Unix Shell( Korn, Borne Shell ), windows batch scripting. Experience in OEM/Grid control installation/configuration, discovery, OEM monitoring for system, network, database operations, application, and other system components in Grid environment.
• Expensive experience in Initiating, interacting with Oracle support/Oracle ACS, working through Oracle SRs (Oracle metalink TAR), root cause analysis, implementing resolution for successful resolutions. Document, communicate status/changes with team and management in a timely manner. Experience working with/coordinating/communicating with internal and external customers/teams in different time zone, including off-shore. Participate in on-call rotation, manage expectations and commitments with stake holders, including application and IT teams

TECHNICAL SKILLS:

Operating System: UNIX (Solaris, HP-UX(PA-RISC and Itanium), AIX, Tru64), Linux (RedHat Enterprise Linux, SuSE Enterprise Linux, Oracle Enterprise Linux etc), Windows (3.0, 95, 98, NT, 2000, XP, 2003, 2008, 2012, 2016 server), DOS

Database: Oracle (8~12c, including 8, 8i, 9i, 9i RAC, 10gR1, 10gR2, 10g RAC, 10g RAC ClusterWare, 11gR1, 11gR2, 11g RAC, 11g Oracle Grid Infrastructure, 12c, 12c RAC, in-memory, multitenant etc), Oracle Exadata, Oracle ASM/GRID/RAC, Oracle Partitioning, SQL Server 7, 2012, 2014, MangoDB, SAP Hana

Cloud Computing: Amazon AWS, EC2, EBS, S3, Oracle on EC2, RDS

VIRTUALIZTION: Vmware VSphere/Esxi, Oracle VM, Oracle VirtualBox, HP-UX Virtual Partitions (vPars)

WORKLOAD AUTOMATION/JOB SCHEDULING: CA Autosys, Autosys Adapter for SAP, Unix/Linux cron/crontab, Windows Task Scheduler, DBMS SCHEDULER, DBMS JOB

Programming and Scripting Language: SQL, PL/SQL, UNIX Shell Scripting (Korn, Borne Shell), DOS/NT/2000 Batch Scripting, PowerShell, Autosys JIL (Job Information Language), Oracle Utility Scripting (RMAN, Import/Export, data pump export/import, SQL*Loader, RMAN, EM CLI etc.), HTML, DHTML, XML, JavaScript etc.

Cluster Software/Shared File System/Storage: Oracle Grid Infrastructure, Oracle Clusterware, OCFS, OCFS 2, Oracle ASM Cluster File System(ACFS), HP Tru64 TruCluster, Veritas Storage Foundation, Veritas Storage Foundation for Oracle RAC, HP Service Guard

ThirdParty Backup Tool: NetBackup, CommVault Simpana, Data Domain, Data Domain DD Boost, IBM Tivoli Storage Manager (TSM), Tivoli Data Protection for Oracle(TDPO)Application: SAP, Oracle E-Business Suites, SCT Banner, FICO, Confidential /Clarify Billing/CRM, Vertex, Pitney Bowes Spectrum, Ventyx (formerly MDSI/Advantex) Mobile Workforce Management, ILog JRules and many other commercial and in-house developed applications etc.

Web/Application Server: Apache Web Server, Oracle Fusion Middleware/Weblogic, Oracle Application Server, Tomcat, SUN Java Web Server, Microsoft IIS, SAP ABAP/JAVA Web Application Server(SAP WAS)

Protocol/Networking: TCP/IP, UDP, Tsunami UDP, FTP, HTTP, HTTPS, LDAP, IP/Port forwarding, proxy, reverse proxy, DMZ, httpwatch

Case/Modeling Tool: Oracle Designer, Toad, Oracle SQL Developer, ERWin, SAP Sybase Power Designer/S designer, Enterprise Architect, UML/Rational RoseDatabase Replication/Migration/other utility: RMAN, Oracle Golden Gate, Data Guard, Transportable Tablespace, Data Pump, exp/imp, SQL*Loader, DB link, Storage-Based replication/HA/DR

Version Management/Software Control: PVCS, CVS, Perforce, Clearcase, subversion

Editor: vi/vim, Lemmy, Notepad, Notepad++, TextPad, UltraEdit

Tools: /Utilities/Others: Putty, SecruCRT, telnet, ssh, ftp, sftp, scp, Exceed, Reflection, MobaXterm, xming, Remote Desktop, VNC server/viewer, PC Anywhere, Timbuktu Oracle RAC/ASM, Oracle Enterprise Manager, Oracle OEM database control/Grid Control, Oracle Clusterware/Oracle Grid Infrastructure, Oracle AWR Warehouse, Oracle Gateway, SQLPlus, Oracle client, Oracle instant Client, dbca, dbua, Oracle Universal Installer, Oracle Universal Installer Slient Mode, OPatch, SAP MOPatch, SQL*Loader, Import/Export, Data Pump, logminer, Materialized View, Oracle Advanced Compression, Oracle Advanced Security, data archiving, RMAN, AWR/ASH/ADDM, SQLT(SQLTXPLAIN), STASPACK, tkprof, ASM, gsdctl, srvctl, crsctl, lsnrctl, tfactl, sapctl, Data Guard/Standy, DB link, transportable tablespace, Oracle Partitioning, Oracle Migration Workbench, Oracle Warehouse Builder TOAD, SQL Server Enterprise Manager/Management Studio, SQL Tool, SQL Tool+, SQL Developer, DBArtisan, SQL Navigator, PL/SQL Developer Service-Now, Remedy/PAC2000, Clarity/Clarify, Focus, magic, heat, HP Quality Center Adobe Document Service, Adobe Acrobat, Dreamweaver, Microsoft office suite (Word, Excel, Access, Outlook, PowerPoint, Visio, Project, Frontage etc), Microsoft Office Communicator/Microsoft Lync, Keon/Boks

PROFESSIONAL EXPERIENCE:

Confidential

Lead Database Administrator/Architect/Consultant

Responsibilities:

• Provide application and database support for different applications on Unix/Linux and Windows, which include more than 500 Linux/Windows servers/virtual machines, over 300 Oracle/MS SQL databases, NDM, F5 load balancer(GTM/LTM), SAN storage array and SAN Storage array based replication, Hitachi, Netbackup/RMAN, Data Guard, Oracle Golden GateSAP, FileNet, NDM, NAS, apache reverse proxy etc.
• Tasks/projects include, but not limited to: Infrastructure planning, work with Unix, Network, SAN/NAS Storage teams for Requirement analysis/Infrastructure design, System/Application/Database Sizing, Architecture and Infrastructure Design, Implementation/Migration Strategies, DR/Business Continuity Planning, Database migration strategy, System/Tech Refresh, development and testing support, production go-live support, ongoing application/database support etc.
• Data Modeling, data mapping, logical and physical database design, creating database and its objects such as tables/partitions/sub-partitions, indexes, constraints, views, materialized view, sequences, triggers, synonym, grant, packages, and stored procedures using SQL, PL/SQL and Unix shell script. SQL, PL/SQL tuning. Partition/Sub Partition management/maintenance. Provide database/sql related input to application design/code review.
• Application and database performance monitor/tuning and sql tuning using AWR, AWR SQL report, ASH, ADDM, SQL Tuning Advisor, SQL Profile, SQL baseline management, SQLT, OEM/Toad etc.
• Design/Develop/Initiate infrastructure tasks work request, problem tickets, root cause analysis etc. for server, OS, storage/SAN/NAS, networking, databases, applications etc. with different teams.
• Design and Implement POC for Oracle database running on AWS EC2. Migrate Databases to EC2 using different strategies according to database size and down-time window.
• Hardware design and operating system configuration for technical refreshes and capacity planning such as specifications for memory, processor speed, sockets, storage, backups, BCP, etc.
• Support for application install into Oracle ASM disk group directly. Support for Oracle 11.2.0.2 to 11.2.0.4 upgrade and 11g to 12c upgrade for single instance and Oracle RAC(for both Grid Infrastructure, RDBMS software and database.) Database migration from blade server to Exadata.
• Support for SAN/Storage based replication technology for BCP event. Coordinate quarterly BCP event with different application, OS, EDM, SAN teams. Fail-over/switch application and databases between prod and BCP data centers. Support/Monitor database backups via Oracle RMAN/Autosys and solve issue/problem tickets to meet SLA.
• Provide database sizing estimate due to business growth. Request/support SAN addition to OS file system and Oracle ASM disk group, support for SAN array migration. Support OS team for Hitachi HORCM configure for SAN LUN set up/configuration. Work with SAN/OS team to add SAN LUNs to production, BCP sites and add SAN LUNs to filesystems and Oracle ASM.
• Implement Transparent Data Encryption(TDE) and wallet management. Implement multiple listeners. Design application and database host Virtual host name/Virtual IP address. Research support and work through DMT requests.
• Initiate/participate/work through triage and EACO calls for production issue and critical non-prod issue and facilitate multiple teams to solve issue quickly.
• Develop patch strategy for applications and databases, application/database upgrade etc. Support and remediate vulnerabilities scan(Qualys), HPSA Security Scan(file ownership, orphans, sticky bits etc.), penetration testing, and audits including OS, DB, middleware and applications etc for safety and soundness initiative.
• Initiate, work through Oracle SRs (Oracle metalink TAR), support ticket etc. with Oracle, Redhat and other third party vendor support. Evaluate, test, and recommend fixes, new technology/feature and tools. Document fixes/processes/procedures/new features and perform knowledge transfer/cross-training as needed.

Confidential

Lead Database Administrator/Consultant

Responsibilities:

• Provide application and database administration, backup and recovery support for Oracle, SQL Server etc. different database platforms. Lead, design and implement backup and recovery strategy using CommVault and RMAN, EMC isilon and Data Domain etc and improved backup/restore/recovery window by 50%.
• Tasks/projects include, but not limited to: Infrastructure planning, Unix, Network, SAN/NAS Storage teams for Requirement analysis, Oracle RMAN integration with CommVault, Commvault agent install/upgrade/configuration, storage/schedule policy set up/configuration. Database backup automation, Performance tuning of Database backup, restore and recovery. Design and test database backup into cloud ( AWS) directly.

Confidential

Database Administrator/Consultant

Responsibilities:

• Provide application and database support for the Fortune 100 retailer. Tasks/projects include, but not limited to: Requirement analysis, System/Database Sizing, Architecture and Infrastructure Design, Implementation Strategies, backup/recovery/HA strategy, System Copy/refresh coupled with Oracle RMAN strategy, Production, development and testing support, Performance tuning, Business Continuation Planning/testing, go-live check/support, post go-live support, ongoing basis/database administration/support etc.
• Data Modeling, data mapping, logical and physical database design, creating database and its objects such as packages, tables/partitions/sub-partitions, indexes, views, materialized view, sequences, triggers, synonym, grant, and stored procedures using SQL, PL/SQL and Unix shell script. Partition/Sub Partition management/maintenance. SQL, PL/SQL tuning. Database change and reference data management. Application and database performance monitor and sql tuning using AWR, AWR SQL report, ADDM, SQL Tuning Advisor, SQLT, OEM/Toad etc. Provide database/sql related input to application designer/devloper/code review.
• Oracle single instance on file system, Oracle single instance on ASM, and Oracle RAC installation/configuration/upgrade on both file system and Oracle ASM. Install Oracle GRID infrastructure, Oracle RDBMS software, perform patch/upgrade to both Oracle GRID infrastructure and Oracle RDBMS software. Database instance creation onto Oracle Grid Infrastructure and Oracle ASM disk group directly. Document workbook/runbook Oracle GRID, RDBMS and CPU install/configuration process/procedure. Database migration from blade server to Oracle Exadata machine. Database migration between different data centers and from on premise and cloud.
• Check and implement application vendor suggested database parameters. Configure/schedule Oracle statistics update job, include system and data dictionary stats. Collect Oracle Exadata system statistics. Gather Oracle system stats on Exadata with Exadata mode.
• Database sizing and scale up. Add/Format/Configure disk/luns using fdisk, udev rules/asmlib etc., to present the LUNs to Oracle ASM. Oracle ASM disk udev configuration for disks/luns with and without multipath. Add/Manage disks to Oracle ASM diskgroups and new Oracle ASM instance/diskgroup creation. Support ASM and ACFS for SAN array migration.
• Working with Linux team to perform Oracle Grid Infrastructure and RDBMS software relink, include Oracle RAC, Oracle Restart( single instance on ASM), single instance non-ASM, to support Linux OS/kernel upgrade.
• RMAN backup install/configuration and integration with third-party MML layer/commercial backup software like Commvault, Data Domain/DD Boost etc. Support for Oracle Golden Gate based replication and its integration with RMAN.
• Oracle database upgrade to 11.2.0.4 and 11.2.0.4 to 12c upgrade. Upgrade/Migrate into Oracle multitenant architecture. Oracle instance client and oracle client upgrade on app servers. Oracle DataGuard fail-over/switch-over testing with applications.
• Oracle 12c upgrade analysis and set up with in-memory, multi-tenant option using container DB ad Pluggable DB.
• Oracle OEM Grid Control/emrep/OMS install/configuration and target discovery/promotion. Participate in on-call support rotation and provide 24x7 support as needed. Initiate, lead, work through Oracle SRs (Oracle Metalink TAR) for timely resolution and root cause analysis.

Confidential

Sr. Subject Matter Expert/Database Specialist

Responsibilities:

• Provide application and database full life cycle implementation and ongoing production support for external and internal customers for a variety of application and databases, which include 24*7*365 mission-critical large scale multi-terabytes production systems and high volume high demand testing and development environments as well.
• Tasks/projects include, but not limited to:
• Application and database support for multiple system landscapes. Extensively Design/Implement application system landscape for internal and external customers, including related databases on different OS/Platforms, including Unix/Linux/Windows. Application/Database user/security administration.
• Data Modeling, data mapping, logical and physical database design, creating database and its objects such as packages, tables/partitions/sub-partitions, indexes, views, materialized view, sequences, triggers, synonym, grant, and stored procedures using SQL, PL/SQL and Unix shell script. Database change and reference data management. SQL, PL/SQL tuning. Application and database performance monitor and sql tuning using AWR, AWR SQL report, ADDM, SQL Tuning Advisor, SQL Profile, outline, SQLT, OEM/Toad etc. Partition/Sub Partition management/maintenance. Provide database/sql related input to application design/code review.
• Extensive database support/migration/upgrade/backup/restore/cloning, including single instance database, Oracle RAC, Oracle Clusterware/Oracle Grid Infrastructure on Unix/Linux/Windows etc platform.
• Work closely with application owner/customer, os/storage/network teams for server/database/storage design/implementation/consolidation/migration to ensure maximum availability and performance to external and internal customers, within hardware/OS platform, across hardware/OS platform, with same storage array, across storage array, within same data center, across-centers. Capacity planning, trend analysis, growth anticipation, sizing and disk/SAN space estimate. Design/Install/Implement applications/databases using virtualization technology.
• Oracle database administration for multi-terabytes databases. Oracle single instance and Oracle RAC install/configuration/upgrade. Write shell script to use Oracle universal installer with silent mode using response to install/patch Oracle software untended to improve efficiency. Review, test Oracle Patch Set Updates(PSU)/CPU (Critical Patch Update), patch set and on-time patches and their dependencies if any.
• Convert/Migrate single instance oracle database to Oracle RAC database after initial application installation with single database instance to improve performance, throughput and high availability. Convert/Migrate non-ASM databases into ASM. Design, test and implement database replication using Oracle DataGuard. Design, test and implement comprehensive database backup/recovery strategies/solutions including using Oracle's RMAN and integrate with commercial backup software to improve functionality and performance. Support and monitor backup implementations by performing daily or regular database health checks and regularly test restore/recovery from backups.
• Extensive homogenous and heterogeneous migration/clone/replication/reorg/refresh at different database/schema/table/partition level. Design and Implement database disaster recovery/ Business Continuity Planning strategy. Database migration/switch-over across data centers. Database health check, monitoring, performance tuning. Migrate/upgrade databases between different OS/hardware platforms using RMAN and Transportable Tablespace. Dictionary managed tablespace to local managed tablespace migration. Migrate/move user objects between different tablespaces. Oracle data type conversion/migration from LONG to LOBs. Partition large tables using partitioning to improve performance and data movement/archiving.