SUMMARY:

• A database administrator over 10 years of I.T. experience on Oracle, MS SQL Server, Sybase ASE, DB2, Postgres, Cache, Greenplum, Teradata, Informix and Netezza databases, integration, configuration, implementation and troubleshooting.
• 4 years’ experience as a Netezza DBA and 2 years GP DBA for EDW projects at a retail, utility and Confidential corporation.
• Experience with UNIX/Linux/Window system/application administration on a variety of platforms.
• Experience in managing 24/7 multi - terabyte databases and systems for 2000 plus users in multiple industries.
• Experience in database backup, disaster and recovery procedures for large, medium and small database servers.
• Experience on operating system administration, backup and recovery, performance tuning, high availability, reverse engineering and effective system implementation.
• Motivated and very responsible and skilled in solving complex problems.

TECHNICAL SKILLS:

Database System: Netezza 6.0/7.2, Greenplum 3-5.3, Oracle 7.3-12c, Sybase ASE 11-15,7, MS SQL 7.0-2017, Postgres 8.3-9.1, Informix 10-11, DB2 6-10.2, Teradata 8-14.0, MySQL 5.5

Web and Cloud servers: Apache-Tomcat, Microsoft IIS, AWS, Azure

LANGUAGES: SQL, Bash, CSH, T-SQL, PL, C, Perl, Python

ERP System: Oracle EBS 11i/R12, PeopleSoft 7.0-9.0, SAP R3/ECC 6

Operating System: RHEL 4.0-7.0, SLES 10-11.0, Solaris 8/9/10, AIX 4.3-7.0, HPUX 10.2-11.0, Windows NT-2012, Mac OSX 10

WORK EXPERIENCE:

Confidential

Remote Netezza/Postgres DBA/Linux Administrator

Responsibilities:

• Administer and monitor six Netezza systems - TF12 TF48, MAKO. Database refreshes on demand to dev, UAT, and prod for all databases
• Test and implement batch processes from DEV to Productions. Worked with autosys.
• Wrote functions, bash shell script for automation administration.
• Review and implement schema changes dev, uat and prod environments with data architect's direction. Wrote shell scripts, monitor and support batch processes on autosys.
• Automated administration, DDL extracts and statistics via shell scripts and python.
• Capacity planning and resource reporting on all Netezza appliance.
• Apply fix packs and firmware upgrades, hardware failures on dev and prod environment working with hardware support.
• Migrated from Twinfin and Stripers to MAKO environment upgrade. Upgraded all appliances to NPS version 7.2.1.7.
• Configure TSM client for Netezza backups.
• Support and maintained Netezza replication 7.2.17.
• Backup support for Azure SQL Server 2017 Linux and Postgres databases.
• Administer and support AWS Redshift for data migration.

Confidential, Dallas, Texas

Linux Administrator

Responsibilities:

• Administer, maintain and support production support of DCA2, DCA3.
• Migrated database system from DCA1 to DCA3 using gptransfer.
• Test and implement batch processes from DEV to Productions. Worked with autosys.
• Monitor and troubleshoot hardware problems in DCA v1, v2 and v3.
• Run dca setup for firmware updates, RSA keys, etc.
• Wrote functions, bash shell script for automated administration.
• Support ETL scripts running on gpfdist, gpmigrate, and gpload. Installed PLR, encryption, and madlib.
• Upgraded 4.3.12 on dev and production environment.
• Run explain plans on problematic queries.
• Installed, upgrade, and manage multiple GP command center.
• Backup support for in house Oracle and Postgres databases.

Confidential

Greenplum/Hadoop Admin/Sybase DBA

Responsibilities:

• Administer, maintain and monitor three DCA 2.0 appliances (18 nodes each - 30 TB system). Administer, maintain and support Hadoop (15 nodes - 30 TB) via Ambari.
• Database refreshes on demand to DEV and NON-PROD for all database environment. Monitor system backup at the data domain.
• Troubleshoot and maintenance of Hadoop and GP commodity servers.
• Run queries on HAWQ. Create GP external tables for Hadoop. Data lake(HDFS). Resource management using YARN.
• Troubleshoot hardware issues that come up from the Nagios monitor. Monitor GP and Hadoop processes using Nagios,
• Run explain plans on SQL queries and test custom functions created by developers. Test queries on new ORCA optimizer.
• Apply fixes and upgrades on GP software and extensions (PostGIS, PL/python).
• Wrote documentations for knowledge transfer.
• Implemented data definition and manipulation changes on production once pass QA.
• Tested standby fail-over for disaster recovery purposes (prod and dev).
• Capacity planning by reporting and purging 3-year-old partitions.
• Understanding business batch processes which needs to be run.
• Supporting MySQL and Postgres database for Pivotal Hadoop. Support Sybase as the source data.

Confidential, Reston, VA

Remote Netezza/Oracle/Sybase DBA

Responsibilities:

• Administer and monitor six Netezza systems - TF 96, TF-120
• Database refreshes on demand to DEV, QA and UAT for all database environment. Support on Golden Gate and Sybase replication.
• Monitor system backup and participate on the disaster recovery.
• Review and implement schema changes on all DEV, QA and UAT environments with data architect's direction. Refreshes Netezza, Oracle and Sybase databases on demand per department's requests.
• Write shell scripts for database maintenance and query.
• Monitor and support source databases - Oracle and Sybase replication servers. Monitor and support metadata Oracle databases for Informatica and Business Objects.
• Mentor level one DBA since my role is between L2/L3 DBA.
• Support and maintenance of Exadata X3 system.

Confidential, Charlotte, NC

Remote Netezza/Teradata DBA

Responsibilities:

• Administer and monitor Netezza systems - TF 48 and 96(300 TB)
• Database refreshes on demand to DEV, QA and UAT NZ environment.
• Monitor system backup and participate on the disaster recovery.
• Review and test code changes on UAT and QA before implementing to production. Create and maintain shell scripts for backup schemas, refreshes, genstats, nzmigrate, and groom. Maintain, administer and support NZ contingency systems.
• Create, maintain and support users and groups access.
• Work with data architect for physical implementation of database objects
• Apply NZ fix patches and firmware upgrades.
• Backup support on Teradata 13.

Confidential, Seattle, WA

Oracle RAC/Sybase DBA

Responsibilities:

• Maintain, patch and support Oracle 10g RAC on HPUX 11i systems 24/7 for our online container tracking system.
• Perform annual disaster recovery procedure for application and databases.
• Frequent implementation of schema and code changes on Oracle RAC and Sybase database systems with change control management. Implement production code changes and review codes in DEV environment. Manage proof of concept Greenplum appliance.

Confidential, Everett, WA

Oracle/SAP/SQL Server Architect

Responsibilities:

• Administer, maintain and clone Oracle/SQL Server databases from production to test, training and development.
• Perform annual disaster recovery procedure for Oracle, SQL Server, and SAP.
• Maintain, patch and support all in house databases - Oracle, and SQL Server.
• Maintain and support Oracle/SQL Server/Informatica nightly batch processes.
• Manage and maintain Oracle 11g Data guard for disaster recovery. Support and maintain Oracle 11g database used by SCADA system.
• Administer and support Informatica on AIX for our ELT developers. Reconstruct ELT loading from Oracle to SAP/SQL Server.