DAVID HUANG

**-** ** ** ***, Apt *A, Corona, NY**368

718-***-****

adzpr3@r.postjobfree.com

OBJECTIVE: Bright candidate with experience of Oracle, Sybase, DB2 and SQL server DBA and Hadoop, Python in most phases seeks challenging computer position with opportunities where proven skills and talents in computer applications programming and database system development will be mutual benefit.

COMPUTER Languages Operating System Database

SKILLS: Python VAX/VMS Oracle 8//9i/10g/11g/12c/19c

C/C++, SAS MS DOS Hadoop

COBOL, Perl Windows 2000,XP Sybase 12.5. 15,16,

Visual Basic, SQL UNIX DB2/UDB v8.v9.v10

JAVA,HTML,XML SQL Server 20000 SQL Server 2005, 2008. 2012

EXPERIENCE:

Database Administrator

IBM Global Business Service NY, NY 07 to 2023

Work on Government Contract, maintain CWGT database. In 9I, 10g, 11g,12c RAC environment

Work on Carlson project, maintain 80 database with some of some are terabytes

Install & configure Oracle 9i and 10G on UNIX HP and Windows platform

Execute diagnostics periodically to guarantee database integrity

Formulate plan for database implementation/conversion strategy

Monitors databases on a daily basis

Develop and design SQL, PL/SQL, designing function, stored procedure, trigger and package.

Write PL/SQL, SQL using Toad tool.

Provide on-call support for database.

Perform data modeling using ERWIN.

Supporting or deploying large scale Oracle Applications 11i environments and Global single instance experience.

Work on Discoverer Administrator, Plus & Viewer (9i and 10g).

Work on XML, XML Publisher.

Use Oracle Toad, Reports & Forms, Portal.

Take responsibility for architecting the Oracle 10g Business Intelligence platform to support reporting and analytical requirements, designing OLAP solutions, creating reports, ad hoc queries and dashboard environments.

Create, maintain, and enhance complex Data Warehousing and OLAP reports.

Support production database in 24 X 7 environment.

Using snapshots to perform distributed database data replication

Create and configure advanced replication sever. Implement data replication in high transaction environment.

Configure Oracle Logminer and Flashback.

Implement Oracle Data Guard, configure physical standby and logical standby.

Using SQL loader to transform the data

Work on Storage Area Network:( SAN) and Network Attached Storage (NAS).

Backup, recovery and tuning oracle database

Install, configure and use Oracle Enterprise Manager (OEM).

Make installation and configuration Oracle Real Application Cluster (RAC) 9I and 10g

Perform RAC administration and management

Perform RAC troubleshooting.

Coordinate development and installation of database technology with the Apps DBA.

Interact with Apps DBA, Development and Infrastructure teams.

Work as Apps DBA.

Support user global wise

Create and maintain the data warehouse in Sybase.

Deign the application, building the application, testing the application, deploying the application and maintain the application.

Performing Sybase application partitioning.

Install m Stand Configure Sybase ASE 12.5.4 and 15, 16 on UNIX

Configure Warm Standby on Sybase ASE 12.5, 12.6

Installing and configuring Sybase Replication Server 11.5,12.0,12.5, 12.6and 15 on

UNIX

Using DBCC with Sybase SQL Server Manager.

Write Transact-SQL programming

Using Sybase SQL Server Manager to Create a procedure.

Perform application partitioning.

Using the configure Sybase servers Utility.

Use Sybase Central

Configure Sybase replication server 12.5,15, 16

Create comprehensive reports using SQR, Sydperl/Report Writer.

Perform stored procedure review and optimization based on actual performance observation

Do performance testing for new versions of Sybase and/or hardware/OS/ Sybase configurations

Design a track record in responding to typical Sybase errors (1105,605, Log folds)

Resolve reporting issues in Sybase and Sybase CASE environment.

Manage Sybase database server

Manage Sybase Data replication

Work on Sybase non-Stop IQ

Perform service delivery implementation.

Configure Data Center engineers

Manage and monitor Sybase performance.

Use DBArtisan

Configure Sybase replication server

Migration data from Sybase database to Oracle database, using SwisSQL –Sybase to Oracle Migration Toll 3.1

Use AutoSys Job Management to support enterprise-wide mission-critical applications

Provide off-hours on-call support for critical Sybase issues

Using snapshots to perform distributed database data replication

Create and configure advanced replication sever. Implement data replication in high transaction environment.

Install, upgrade and maintain DB2 UDB V8,V9 and V10 in UNIX platform

Work as DB2 DBA managing very large database (7 to 8 TB and above)

Design Grid Control, parallel data synchronization and high availability

Perform database performance monitoring and fine-tuning

Conduct real time production support

Working in onsite/offshore model preferred

Work in an intense, dynamic, and multi-tasking environment, while being sensitive to deadlines

Ability to adapt quickly and effectively to a changing environment

Track, document, and communicate work status to the Middleware Lead

Using ETL tools such as Informatics

Database Administrator

Kforce Inc New York NY 04-07

Design, develop, and implement of complex physical Oracle databases across multiple platforms, technologies and computing environments.

Take responsibility of monitoring performance, tuning for optimization, planning system capacity consulting on information architecture, implementing support and management tools and generating project status reports.

Work as Sr. Data Architect experienced in developing data components with a strong grasp of data integration issues, treatment of reference data

Establish technical components for an enterprise data warehouse handling large volumes of data.

Implementing Cognos, database and web services.

Provide solution from a performance, sizing, availability, backup/recovery, and security considerations.

Interact with client senior systems folks and database administrators.

Coordinate activities across data analysts, data modelers, and DBAs.

Perform overall database design, and physical and logical data modeling in a large-scale data warehouse.

Lead various data integration efforts and ensure compliance with overall enterprise data strategy and standards; maintaining the standards; Leading the development of Data warehouse metadata repository.

Designing and implementing a optimized data architecture; database modeling; SQL query and store procedure development

Write PL/SQL, SQl using Toad tool.

Use ETL, time series data management and retention.

Designing, developing and implementing data warehouses using Informatica PowerCenter 6.2

Designing and coding end-to-end ETL solutions relating to data warehouse development

Use tools such as Oracle Warehouse Builder V10.2, NSF Gateway Coalition, ERWIN, Prism, Sagent and Apertus to do data warehouse designing.

Provide assistance to other developers in the delivery of warehouse solutions to meet the needs of multiple customer groups

Work closely with Project & Development Managers to ensure overall project timelines are met or exceeded

Create and contribute to project documentation and deployment activities,

Create and maintain Sybase database on Sybase system 11.9.2,12.0,12.5

Manage Sybase database server

Installing Sybase on UNIX and Windows NT server.

Perform 24 x 7 support of applications/ Sybase interface and performance including pager duty

Installation planning in conjunction with development and application administration management

Using the Performance Options of Sybase’s ODBC Driver.

Testing a connection through ODC to Sybase.

Performing Sybase application partitioning.

Installing and configuring Sybase Replication Server 11.5,12.0,12.5

Using DBCC with Sybase SQL Server Manager.

Write Transact-SQL programming

Using Sybase SQL Server Manager to Create a procedure.

Perform application partitioning.

Using the configure Sybase servers Utility.

Configure Sybase replication server

Configure Veritas Clustering

Work on AutoSys to support applications

Create comprehensive reports using SQR, Sydperl/Report Writer.

Write and modify Crystal Report

Developer/DBA

WMA Securities Inc New York, NY 97 to 04

Act as project leader for designing application, building application, testing the application, deploying the application and maintaining the application. Coordinate

With programmer and business analysts.

Design data warehousing database create snowflake schema and star schema for data

warehousing

Develop and design SQL, PL/SQL, designing function, stored procedure, trigger and package.

Developing PL/SQL libraries

Write PL/SQL, SQl using Toad tool.

Designs, develops and enhances Oracle database and applications. developer2000, PL/SQL, reports and forms designing.

Implements Open database Connectivity (ODBC) to allow MS Excel database to access Oracle compliant data sources

Generates academic reports using Oracle Reports Developer 9i

Provides guidance on creating an oracle Data Warehouse

Use tools NSF Gateway Coalition, ERWIN, Apertus and Oracle Warehouse Builder V10.2

to do data warehouse designing

Generates, upgrades and converts Oracle Forms 5 and Oracle Forms Developer 9i,

Work on Oracle Discover

Design text indexing and search.

Develop a search and retrieval application using RDBMS with text document data.

Migrate a MS access database to an oracle database using Oracle migration tool for MS Access

Establishes procedures and Graphical User Interface(GUI) standards to be used for Software development and testing.

Creating and maintaining Oracle database in development, test and production environments Using Oracle 8I and 9i.

Develop and maintain multiple Oracle database in development, test and production environments Using Oracle 8.05, Oracle 8.16 and Oracle 9i.

Install & configure Oracle 8I and 9i on UNIX platform

Install & configure Oracle 8i and 9I, NT /windows 2000 and Windows XP platform.

Work on and configure Oracle9iAS: Build and deploy J2EE, web Services and internet Applications, extract Business Intelligence, Integrate Users, Applications and Business, Manage and Secure Web Infrastructure.

Configure Oracle9iAS Reports Services, deploy reports in Oracle9iAS Reports Services.

Configure Oracle 9i webserver.

Install, configure and work on Oracle Designer 2000.

Performance backup and recovery.

Do performance tuning.

Configure and setup standby database.

Design a project using JAVA programming to trace the online trading of mutual fund and stock.

Work on J developer on 9i using Oracle Portal.

Develop EJB Session Beans.

Creating classes and applications in JAVA.

Design JSP application.

Develop Applets.

Designing project using JDBC.

Design Real Time Stock Portfolio Tracking System., using Interface Design with AWT and Interface Design with Swing.

Perform JAVA event handling, Perform GUIs in the Stock Portfolio Tracking project, such as stock table, stock price. etc.

Perform JAVA project assembly and debugging.

Using JAVA Enabled Web Server Setup.

Using JAVA Servlet.

Design JAVA Beans.

Using JAVA Server Pages

Design and develop J2EE applications.

Write C/C++ programming.

Using XML with SQL Server 2000.

As part of team of Web developer, design HTML, DHTML, XML, ASP,Weblogic.

Write JAVA Script.

Write VB Script.

Participate in developing a comprehensive financing software application using VB 6.0

Design and develop an inventory control system for the company using VB 6.0

Using RDO, ODBC and OLE technologies in window NT

Participate in designing and developing company’s intranet using Microsoft Front Page, HTML, VB Script, ActiveX, Active Server Pages, ADO, InterDev 1.0 and SQL 6.5

Develop and implement a customer information and invoice tracking system for the company, using visual basic 4.0 DAO and access 2.0

Design and develop C program

Implement and design Pro*C applications.

Perform logical and physical table and database design

Perform data modeling using EWRIN.

Support production database in 24 X 7 environment..

Design and develop Oracle financial applications using Oracle Financial 10 and 11 package.

Install Oracle patches.

Migration from Oracle 8i to Oracle 9i, upgrading Oracle from 8.0 to 8i.

Oracle Web designing, using Cold Fusion software and through Oracle Web server.

Perform problem resolution in support of customers

Execute day to day DBA duties in multi-instance production and development environments

Write UNIX shell scripts, including Korn shell and C shell programming.

Write AWK, Nawk, Gwak scripting language in SVR4.

Develop T-SQL programming

Maintain SQL server 7.0 and SQL server 2000, backup and tuning SQL server, perform technical support.

Install and configure PeopleSoft

Maintain and tuning PeopleSoft, Training users to use PeopleSoft.

Installing Perl on a Unix system.Installing Perl for windows.

Write report using Cognos

Using different debuggers to debug Perl.

Using Perl modules from CPAN (Comprehensive Perl Archive Network)

Importing Modules, symbols and Tags in Perl.

Creating and using subroutines.

Working with files and I/O in Perl.

Database Administrator/Developer

Compu21 Technology, Inc New York, NY 94 to 97

Installed Oracle 8.0.5 in NT and UNX platform

Creating and designing Oracle database using Oracle 7.3 and Oracle 8.05

Create Oracle objects such as tablespaces, tables, indexes, views and user accounts

following defined standards and scripting procedures.

Perform problem resolution in support of customers

Installing and upgrading the Oracle 7 server and application tools.

Installing and upgrading the RDBMS and work with Oracle networking configurations.

Creating primary database storage structures.

Allocating system storage and planning future storage requirements for the database system

Modifying the database

Using snapshots to perform distributed database data replication

Controlling and monitoring user access to the database

Backing up and recovering database.

Maintaining system security

Optimizing database performance.

Writing UNIX scripts

Design and maintain Sybase database, perform backup and recovery, do performance tuning

Developed and designed JAVA program.

Served as SQL Server 6.5 administrator.

Installed SQL server 6.5, backup and tune the SQL sever database.

Maintaining and tuning PeopleSoft.

Maintained DB2 database to support COBOl programming, designed COBOL project.

Develop Sybase applications.

Create and maintain Sybase database

Installing Sybase on UNIX and Windows NT server.

Using the Performance Options of Sybase’s ODBC Driver.

Testing a connection through ODC to sybase.

Performing Sybase application partitioning.

Installing Sybase Replication Server

Using DBCC with Sybase SQL Server Manager.

Prudential Insurance Company Boston, MA 93 to 94

Financial Analyst

Analysis insurance,mutual fund, and a variety of investments.

Conducted stock research and updated various transactions.

Contacted potential clients and assisted in establishing a client base

Implemented procedures for the organizations of the client holdings.

EDUCATION: Central Connecticut State University, New Britain, CT

MA in Mathematics Concentration: Computer Sciences, May,1998,

GPA 3.50

University of Hartford, Barney School of Business West Hartford,

CT

MIS, GPA 3.47

Shanghai Academy of Social Sciences Shanghai

MA in Economics,, GPA 3.85

Fudan University Shanghai

B.A. in CS, GPA 3.85

Contact this candidate