Sql Server Data Warehouse
Resume:
DAVID HUANG
**-** ** ** ***, Apt *A, Corona, NY**368
************@*****.***
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