Thomas Lao

ac74qj@r.postjobfree.com

646-***-****

Senior DBA

Senior Database Administrator with more than 11 years of experience in high volume/availability environments. Expertise in testing, production and development settings. Great problem solving skills. Thorough understanding of backup & recovery, database cloning and refreshing, security and monitoring configuration using Oracle enterprise manager, golden gate, RAC, performance tuning, PL SQL, data guard, FSFO in data guard & Oracle STREAMS. Extensive experience as an Enterprise Manager (cloud control) administrator. Worked closely with Unix administrators and application developers. Superb communication, interpersonal and leadership skills. Sharp problem solving abilities and goal-oriented attitude.

US Citizen. Authorized to work in the US for any employer.

Work Experience

Oracle Database Administrator

Home Depot– Jersey City, NJ

June 2017 – Dec. 2018

Expericence in Golden Gate 12c setup and Troubleshooting

Point in time recover and conflict handling

Oracle PL/SQL programming and data analysis

Dataguard Disaster Recovery (DR) setup, test administration and monitoring. Worked with Fast Start Failover (FSFO) in DATA GUARD

Golden Gate Setup, administration, monitoring with hands on Patch testing, vulnerability management, product upgrade, integration testing s and performance testing.

Experience with Data Encryption solutions (Database, NAS/Server File System, SAM, Data Transmission etc.) build Data Lakes.

Experience on 24*7 environment including on call support as per requirement. Handled tickets. Conversant in handling requests within SLA.

Have migrated Oracle databases to AWS EC2 and RDS. Migration from Oracle RAC to Exadata experience.

Experience with upgrading OEM from 11G to 12C, Integration of OEM 12c with Exadata, Monitoring of Exadata using OEM 12c, upgraded and patched infiniband switches.

Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA).

Experience & knowledge on Exadata architecture & features like Storage Index, Flash cache, HCC and IORM Solid exposure of hardware, updated & patched Software and firmware maintenance of the Exadata storage servers

Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.

Experience and knowledge of logical and physical database design, performance monitoring tools, Unix shell scripting, Perl/Python.

Used some leading programming language, like Python, Java, C++ to develop and used Python for machine learning.

Experience with Oracle Auto Service Request (ASR), ASR implementation, configuration and Administration

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, Design of DB objects, partitioning, Data modeling, DML(select, insert, update, delete, merge, call, explain plan, lock table), DDL(create, alter, drop, truncate, comment, rename), DCL(grant, revoke), TCL(commit, rollback, savepoint, set transaction) operation (SQL commands)

Work closely with other database administrators/developers, OS engineer and subject matter experts to ensure the success of migration of 40T data warehouse from single instance 11gR2 to 12c RAC database by DataGuard; and the integrity and availability of databases and their accompanying application softwares, such as Anthill Pro, NDM and Autosys, building blocks of Supply Chain Management

Hands-on Oracle database administration experience with 12c and 11g; both in Unix and Windows environments. Install new versions of the Oracle RDBMS and its tools and any other tools to access the Oracle database, backup and recovery database. Used AVAMAR/DDBOOST, RMAN & CRON.

Oracle 12c RAC/Clustering architecture, installation for standalone and multi-node and troubleshooting, perform product evaluation analysis

Security check for database by SQL scripts and provide remediation suggestions to meet data security and compliance requirements, interdependencies between Oracle security and Linux security.

Oracle Advanced Concepts experience like Parallel Execution, Using Optimizers, Flash Recovery, Advanced Compression

Experience with setting Oracle 12c Golden Gate Replication

Automated job scheduling with Oracle SQL and/or PL/SQL.

Oracle 12c Data guard experience with Oracle 12c CDB with multiple instances and using ASM

Experience with MS Office productivity tools, and good knowledge of AIX and/or Linux operating systems, Oracle Enterprise Manager Cloud Control, Cisco (AppDynamics) & Kibana, azure

Supported and cooperated with App team/development team.

Oracle Database Administrator

Frontier Communications - Bangor, PA

June 2015 to June 2017

Responsibilities:

•Installed Grid Infrastructure Software on new Linux Servers for 2 node RAC and Failover environments and Oracle Grid Control 11g Installation. Removal and Adding nodes to the Oracle Rac.

•Experienced in Installing OEM agent and hooking up to the grid.

•Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.

•Worked in troubleshooting RAC and implemented ASM features. Removal and Adding nodes to the Oracle Rac.

•ETL Tool with appropriate data warehouse tasks like process of extracting data from simple operational data sources or external data sources, transforming basic data which includes cleansing.

•Install and configure Golden Gate for Teradata, Set up Oracle Golden Gate for propagating information from various databases to Teradata, review of infrastructure components and technologies based on input from Customer/Business group.

•Aggregation, summarization, integration, as well as basic transformation, and loading the data into some form of the data warehouse using s Tolls. Supply Chain Management Building Blocks.

•Used AWS (Redshift, DMS), Client Data Centers, new Client dedicated cloud to support development of products, built Data Lake

•Extensively worked in setting up Oracle physical standby database using Data guard. Worked with Fast Start Failover (FSFO) in DATA GUARD

•Worked with Client’s division and business unit, application team to perform product maintenance activities

•Resolving the issues in conflicts between the target and source database in golden gate.

•Supporting migration and upgrades using Oracle Active Data guard environment using Oracle Data guard Broker, Monitor and fix plans for sub-optimal SQL queries.

•Implemented Bi-Directional replication in golden gate

•Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases.

•Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and Disaster Recovery(DR) databases.

•Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA). Migration from Oracle RAC to Exadata.

•Viewing Exadata Database Machine Topology, Drilling Down to Individual Targets, Viewing Exadata Database Machine Alerts, Viewing Exadata Database Machine Metrics, Adding Exadata Components Manually. Know about Luns, Cell Disk and Grid disk and CELLCLI and DCLI, cellsrv process. Implementation & troubleshooting.

•Applied necessary Patches during installation and also in up-gradation of databases.

•Handy in utilizing data pump tool for exporting and importing the data between databases. Implements security for the Oracle Databases.

•Used E-billing as ant script for creating the Oracle Self-Service E-Billing database.

•Involved and Upgraded Analytical Databases from 10g to 11g, or 12c.

•Installation and configuration of Golden Gate on 11g database for the replication, perform product evaluation analysis

•Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query.

•Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.

•Experience with Data Encryption solutions (Database, SAN, NAS/Server File System, Data Transmission etc.)

•Well Experienced in taking Cold Backup for a very huge 64-Tb Database.

•Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN. Used AVAMAR/DDBOOST & CRON.

•Experience of logical and physical database design, performance monitoring tools

•Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.

•Oracle PL/SQL programming and data analysis

•Weekly Data Refresh from Production to QA, Development and Test environments using Data Pump export/import, backup and recovery DB.

•Having good exposure in user management, Table space Management, Session Management, undo Management issues.

•Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level, Unix shell scripting, or Python, other database issues like dead lock, abnormal application lock, contention.

•Automate database administration used shell scripts

•Used RDBMS to connect Oracle DB and good knowledge of AIX and/or Linux operating systems, azure

•Experience with peregrine ticketing tools for resolving the tickets.

Oracle Database Administrator

AT&T - Dallas, TX

June 2013 to June 2015

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including Golden gate 12c, ASM and CRS.

• Performed upgrades from Oracle 10g to 11g and applied patches, Software and firmware maintenance

• Proficient in managing Oracle Instance, database storage structure, schema objects.

• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.

• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC and 11G RAC on a test basis.

• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures, Disaster Recovery(DR) databases.

• worked on Oracle GOLDEN GATE for transferring data between 10g and 11g and exadata, upgraded & patched the InfiniBand switches in the Database machine

• Involved in Base migration from 10g to 11g in production databases, 11g to 12c in QA and test environment. Knowledge & experience of logical and physical database design, performance monitoring tools, migrated DB to AWS.

• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).

• Worked on Features: Data Pump, ASM, AVAMAR/DDBOOST, CRON and RMAN. Data Base Recovery (complete & Incomplete).

• Installing ASM environment and migrating database from NON-ASM to ASM. Unix shell scripting,

• Experience in Planning Database, Sizing table space, create database, scripts(Shell, Perl/Python, SQL), monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support. Handled tickets. Experience in data warehouse, Oracle PL/SQL programming and data analysis

• Installation of Oracle database 10g software with RAC using Oracle Cluster-ware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control. Worked with Fast Start Failover (FSFO) in DATA GUARD

• Install and configure Golden Gate for Teradata, Set up Oracle Golden Gate for propagating information from various databases to Teradata

• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage

• Created Cluster-database, Cloning of Cluster database on Linux, start and stop Cluster database services.

• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM (Oracle Enterprise Manager), Import-Export, Auditing, RMAN. Implements and enforces security for all of the Oracle Databases.

• Generating Stats pack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.

• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements

ORACLE DBA

TRAVISA CORP - San Francisco, CA

June 2011 to June 2013

Responsibilities:

• Installation and configuration of Oracle Database Software 10g and 11g R2.

• Maintain 190 databases which range from Oracle 9i to 11g R2 single and RAC on Linux, Solaris and Windows platforms on a 24x7 environment.

• Developed RMAN and logical export backup scripts and scheduled from OEM 10g Grid Control.

• Member of Infrastructure team and performed Upgrade of Oracle 10gR2 to Oracle 11gR2 and Migrate from Sun Solaris to Linux platforms using transportable tablespaces.

• Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.

• Installed OEM 10g grid agent on servers and configured to OEM 10g Grid Control.

• Administer RAC Database servers using SRVCTL, VIPCA, OEM Grid control, V$/GV$ views and System wide tuning using UTLBSTAT and UTLESTAT.

• Monitor database performance using OEM Grid Control and run ADDM, ASH, AWR reports.

• Experience with Unix Shell scripting, SQL, PL/SQL and upload data using SQL*Loader and exadata.

• Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.

• Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology. Worked with Fast Start Failover (FSFO) in DATA GUARD

• Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack for best performance.

• Restore and point-in-time Recovery of database using RMAN techniques.

• Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

• Preparing cluster, configuring and Installation of clusterware and Oracle RAC on RHEL.

• Oracle Documentation and knowledge transfer. Oracle Cluster ware installed to provide infrastructure for RAC in production, testing databases and configured 4 node Oracle 11g/10g RAC with ASM.

• Upgrade of database from 10.2.0.4 to 11g R2 and 11g R2 and applied CPU/PSU patches on Solaris and Linux on Legacy and DBaaS environments for all business streams.

• Utilized RMAN for backup and Recovery strategy and even performed cloning of database.

• Monitoring, identifying areas that need to be improved in the database using AWR, ADDM, Grid Monitoring and Administering RAC databases running on Cluster File system.

• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.

• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.

• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH.

• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.

• 24x7 on-call production database support, handled tickets.

Oracle DBA

UBI Investments- Houston, TX

June 2009 to June 2011

Responsibilities:

• Migrating applications from non-clustered oracle 8i/9i/10g databases to new

• Monitoring and supporting Applications using OEM 10g Grid Control

• Registering Databases to Oracle 10g GRID

• Registering Databases to RMAN Catalog

• Created PARTIONING of its types like Range, List & Hash by the specific use.

• Implemented Oracle Streams for Replication and applying patches

• Implemented schema level, table level and bidirectional oracle streams.

• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments.

• Performance tuning, Schema creation, maintenance, and troubleshooting. Administers, maintains, develops and implements policies and procedures for ensuring the security.

• Implementing data models and database designs, data access and table maintenance codes; resolves database performance issues both relational and dimensional.

• Database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database.

• Planning and scheduling Backups, RMAN, taking Logical Backups.

• Experience in Export/Import and Data pump. Worked with Fast Start Failover (FSFO) in DATA GUARD

• Setup and manage RAC environments for our customers.

• Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.

• Implement physical database changes, testing, and performance tuning by reviewing database activity, progress, and performance reports.

• Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning.

• Implement Production Control and Change Management.

• Used Smart scan leverage allowing bloom filters in EXADATA machines for oracle.

• Worked on RAC performance tuning by improving Interconnect Performance, Session waiting while suggesting OS tuning and Application Tuning.

• Provides best practices on new technologies and implementations, including Goldgate

• Provides expertise and makes recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle DB.

• Ability to pro-actively understand and manage end user/customer expectations.

• Worked on EXADATA machine with oracle database and Tuning the database along with SQL.

• Performance issues (track and trend overall database performance and database area, index, and drive performance).

Oracle DBA

HSBC-HONGKONG

June 2007 to June 2009

Responsibilities:

• Design and Create new databases based on requirements of the application / project

• Responsible for all the database related jobs for all the instances, performance tuning, backup and recovery, managing users & privileges, resource limits. Administration of database objects such as indexes, tables, views, constraints, and stored procedures.

• Developed RMAN backup scripts and automating the RMAN backup scripts.

• Implement partitioning and indexing strategies

• Create users, roles and profiles with different security levels. Grant and revoke privileges.

• Migrate changes to Oracle database objects and monitor/administer existing databases security with Oracle database environment.

• Handled day-to-day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software. Scheduling maintenance and health check of the applications and databases

• Performed database tuning using explain plan, TKPROF, stats pack and other custom utilities

• Installed, configured 10gRAC on two-node cluster, created databases in both in standalone and RAC environment.

• Analyzing the schemas and individual tables Expert in Oracle Backend programming in SQL and PL/SQL, Writing Stored Packages, Procedures, and triggers in a Multi tier environment.

• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.

• Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and up-gradations.

• Provide DBA support to developers, developed stored procedures and triggers. Also Provide 24x7 on call support related to Oracle DBA activities, handled tickets.

• Taking reviews of physical database models. Develop procedures to troubleshoot issues.

• Cloned or refreshed the databases from production to development and test environments.

• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications.

Education

Master degree in Administration, Dalhousie University, 2007

Contact this candidate