SUMMARY:

Extensive hands - on experiences with application/database development and management.

PROFICIENT IN:

• Core Java application development with Spring Framework
• SQL development for relational and columnar databases
• Database performance tuning and troubleshooting
• Data modeling and Database design
• Management of very large data volume and its lifecycle
• Managing IT deliverables via efficient project management
• In-depth business knowledges of financial industry

SOFTWARE:

Programming Languages: Java, Perl, Unix/Linux Shells

Databases: SAP Sybase Adaptive Server Enterprise (v.4.9.2 ~ v.16), SAP Sybase IQ (v.12.6 ~ v.16), SAP Sybase Replication Server (v.10 ~ v.15.7), Microsoft SQL Server (v.2000 ~ v.2012), IBM UDB (v.8 ~ v.10.5), Oracle (v.9 ~ v.10)

Software Development Tools: Eclipse, Ant/Ivy, Maven, Perforce(version control)

Database Tools: ERWin, DBArtisan, RapidSQL, SSMS

Enterprise Scheduling Tools: Autosys, Control-M

OS-level Technologies: Veritas Clustering, SRDF, Kerberos

OPERATING: SYSTEMS Linux(RHEL), Oracle(SUN) Solaris, MS Windows Server

EXPERIENCE:

Sr. Java Developer / Database Performance SME

Confidential

Responsibilities:

• Application Development Responsibilities
• Develop several dozens of Core Java programs to renovate the ETL processing. The Java programs are built with Spring Framework as part of the firm’s MS Java environment and utilize multi-threading methodologies for performance and scalability purposes.
• Develop a few hundred SQL stored procedures to implement rule-based business logics. Most of those stored procedures rely on complicated SQL queries to achieve their designed functionalities and high-level of efficiency and sustainability.
• Participate in database designs with relational and dimensional models.
• Design and implement VLDB strategies to manage terabyte data volume efficiently.
• Database Performance Responsibilities
• Conduct performance tuning on large number of SQL queries and stored procedures.
• Conduct performance tuning Confidential database and server levels.
• Establish and maintain database performance monitoring infrastructure.

Sr. Java Developer / Database Performance SME

Confidential

Responsibilities:

• Application Development Responsibilities
• Renovate large number of existing Java-based ETL programs for the migration.
• Develop and convert 200+ SQL stored procedures for the migration.
• Enhance the database model on the new database platform.
• Database Performance Responsibilities
• Conduct performance tuning on SQL queries and stored procedures.
• Conduct performance tuning Confidential database and server levels.
• Build database performance monitoring infrastructure.

Sr. DBA

Confidential

Responsibilities:

• Perform logical/physical database design for the data warehouse system.
• Implement the data warehouse with Sybase IQ MPX, ASE and Replication Server.
• Design and implement operational infrastructure of the system such as ETL loads, heterogeneous data replication which establishes bi-directional data replication among Sybase ASE, IQ and Oracle data sources globally.
• Design and implement High Availability & Disaster Recovery solutions for the system.
• Conduct performance tuning and troubleshooting on all the component servers.
• Manage the lifecycle of the data warehouse project and interface with the businesses.
• Provide primary DBA support for Sybase ASE, IQ and Replication Servers.
• Assume the responsibility of 3rd-level DBA support globally.
• Member of the firm-wide Technology Swap Team as a database SME.

Sr. DBA

Confidential

Responsibilities:

• Manage server installation, upgrade, patching and cross-platform migration.
• Design and implement global replication systems between Sybase and Oracle sources.
• Design and implement High Availability & Disaster Recovery solutions.
• Implement and enhance server-side infrastructure for system monitoring.
• Perform troubleshooting and performance tuning for database and replication systems.
• Provide application support in logical/physical database designs and query optimization.
• Manage system infrastructures such as capacity planning, performance benchmarking.
• Manage firm-wide system initiatives such as IT system auditing, SOX-compliance.
• Provide guidance to staff DBAs in the global centralized operations team in APAC.

Sr. DBA

Confidential

Responsibilities:

• Manage server installation, version upgrade, patching and cross-platform migration.
• Design and Implement global replication systems with customized configurations.
• Design and implement High Availability & Disaster Recovery solutions.
• Implement custom monitoring for critical systems on top of firm-wide infrastructure.
• Perform troubleshooting and performance tuning for database and replication systems.
• Provide application support in logical/physical database designs and query optimization.
• Manage system infrastructures such as capacity planning, performance benchmarking.
• Organize firm-wide system initiatives for compliance.

Sr. DBA

Confidential

Responsibilities:

• Responsible for server maintenance such as installation and upgrade.
• Design and implement global replication systems between Sybase and Oracle sources.
• Design and implement High Availability & Disaster Recovery solutions.
• Design and implement server-side infrastructure for system monitoring.
• Perform troubleshooting and performance tuning for database and replication systems.
• Provide application support in logical/physical database designs and query optimization.
• Manage system infrastructures such as capacity planning, performance benchmarking.
• Manage firm-wide system initiatives driven by compliance regulations.

Sr. DBA & Unix(Solaris)

Confidential

Responsibilities:

• Perform architectural design of the system and logical/physical design of the database.
• Implement database schema with SQL coding such as stored procedures and triggers.
• Design and build the database replication system.
• Install/configure Solaris operating system and Sybase database and replication servers.
• Managed the system Confidential both OS and database levels on a daily basis.
• Perform troubleshooting and performance tuning Confidential both OS and database levels.
• Implement the ETL process with shell and Perl programming.

C++ Developer / Application DBA

Confidential

Responsibilities:

• Develop the systems with C++, Sybase Confidential -SQL and Powerbuilder.
• Perform the data analysis and modeling.
• Perform the database design (logical and physical) in relational model.
• Design and build the database replication system.
• Conduct troubleshooting and performance tuning.