SUMMARY

• 20+ Years of Information Technology experience with a focus on Database Administration supporting Teradata, Hadoop, DB2 LUW and SQL SERVER. Developed skills and expertise
• Experienced Database Administrator DBA on multiple DBMS environment:
• 7 + years experiences on Teradata database.
• 20 + years experiences on DB2 LUW database
• 15 + years experiences on SQL Server database
• IBM Certified Expert for DB2 UDB for LUW on V9.7 Advanced Administration

PROFESSIONAL EXPERIENCE

Sr. Teradata DBA & Hadoop DBA

Confidential, Kansas City

Responsibilities:

• As Teradata DBA, Manage user access and database security; Manage/Monitor system performance, including workload management and throttling, query performance and tuning, physical node behavior, amp distribution, Skew analysis, PPI, etc.;
• Experienced Teradata tools: TDWM, BTEQ, ARCMAIN, DBQL, PDCR, Viewpoint, Teradata Studio, Teradata SQL Assistance, Datamover, etc; Experienced database & table backup/restore using BAR tools, NetBackup and Quantum Library;
• Expert on Linux/Unix shell and PERL scripting, wrote shell scripts to automatically move data from Prod to DR site via datamover tools when table row count mismatch are found, etc;
• Work with Teradata GSC in resolving RDBMS related incidents, completed Hardware Refresh, moving Teradata database system TEST/QA/Prod from 6700H to Intelliflex new hardware environments, and later database version and patch upgrade from TD version 15.10 to TD version 16.20.32.11 ;
• Coordinated and worked with offshore DBAs. Participate in 24X7 on - call rotation with other DBA team members; Support variety of applications in large scale data platform. Assist other members of IT, such as Application Development, Operations in the resolution of system hardware and/or software problems.
• As Hadoop DBA, manage hadoop services via ambari, HDFS and HIVE database access permissions via ranger; Cooperated with vendor and completed upgrading HDP 2.6 to HDP 3.1.0 and ambari 2.5 to ambari 2.7.3; manage hadoop user login access; performance monitoring and troubleshooting, etc.

Sr. Teradata DBA, SQL Server DBA and DB2 UDB DBA

Confidential

Responsibilities:

• As Teradata DBA, built teradata databases from scratch, responsible for teradata Database/tables maintenance including database/tables backup & restore through Bar, table statistics collection, performance monitoring and troubleshooting via viewpoint, bteq scriptings, perl scripts, and datamover and other tools; database physical & logical design and implementation, database security and access management, etc; writing scripts sending reports for bad queries, p articipated DR exercise, etc.
• As a Sr. DB2 UDB for LUW DBA and IBM Certified Expert for DB2 UDB for LUW on V9.7 Advanced Administration, responsible for Database maintenance including database backup & restore; table and index reorganization and Run statistics; DB2 database system installation and configuration; database version and fixpack upgrade; database physical & logical design and implementation: database security management, etc, on 11 NODEs DPF partitioned database system and single partitioned databases systems; setup and managed HADR cluster and replication, etc. Migrated DB2 database from V8.2, to V9.5, V9.7, V10.5 and V11.1 . Exercised database disaster recovery practice.
• Experienced on Tivoli TSM setup and configuration. Experienced on database performance tuning,monitoring and troubleshooting;
• As a SQL Server DBA, responsible for database maintenance, backup/restore, disaster recovery, performance tuning, database migration from SQL2000 and SQL2005 to SQL 2008, SQL 2012 .
• Expert on multiple NODEs SQL 2008 cluster installation and configuration, expert on “Tivoli Data Protection for SQL” installation and configuration. Proficiently using SQL Profiler, Performance monitor, system stored procedures, SQL explanation and other tools to diagnose slow response problems and tune queries.
• Good on PERL scripting and Unix shell scripting, writing PERL scripts to automatically manage database activities and reorg and Runstatistics, automatically restore some databases from PROD to TEST daily and send completion notification through Email, monitor file system space, CPU and memory utilization, etc, automatically collect information regarding to number of instances, databases, database and table size, etc.
• Participated 24*7 production oncall rotation; Good interpersonal, working hard and nice team player.

Senior DB2 UDB DBA, Senior SQL Server DBA

Confidential

Responsibilities:

• As Sr. DB2 UDB DBA, responsible for Database maintenance including database backup & restore, table and index reorganization, Run statistics, DB2 system installation and configuration, fix pack upgrade, database physical & logical design and implementation, database security management, etc.; Migrated database from DB2 V5.0 to V7.2, to V8.2, to V9.5, moving Databases between different platforms, exercising database disaster recovery practice every quater. Experienced on Tivoli TSM setup and configuration; experienced on database performance tuning and monitoring, troubleshooting, complex SQL query optimization, problem diagnosis.
• Sr. SQL Server DBA, responsible for database maintenance, backup/restore, disaster recovery, performance tuning, database migration from SQL 6.5, SQL 7 to SQL2000, SQL2005. Proficiently used SQL Profiler, Performance monitor, system stored procedures, SQL explanation and other tools to diagnose slow response problems and tune queries. Experience with database tools such as BMC patrol, BMC change manager and Quest products. 24 hours on call production support. Consistently keep up technique knowledge, attending multiple IBM DB2 UDB technique training classes, IBM DB2 conferences and DB2 user group; attending MS SQL Server admin, performance tuning class and MSSQL User group. Got IBM certification of 'IBM Certified Expert for DB2 UDB for LUW on V9.1'. Good interpersonal, hard working and nice team player.