SUMMARY:

• Over 24 years of hands - on experience of application/database development, database administration and data warehouse design/implementation. Proficiency in
• Application development in Python/Java/SQL with Agile methodologies
• Statistical programming in SAS (SAS Certified)
• Performance optimization of database and data warehouse systems
• Database design and data modeling in relational and star schemas
• Data lifecycle management for VLDB and big data systems
• In-depth business knowledge of investment banking industry

SOFTWARE:

Programming Languages: Python, Java, SAS, Unix/Linux Shells, Perl, C/C++

Software Development Tools: Eclipse, PyCharm, Maven, Git/Perforce, Jenkins

Database Products: Microsoft SQL Server, SAP Sybase ASE/Replication/IQ, Oracle, IBM UDB

Database Design Tools: ERWin, PowerDesigner

Database Development Tools: DBArtisan, RapidSQL, Aqua Studio, Microsoft SSMS, IBM Data Studio

Enterprise Scheduling Tools: Autosys, Control-M, Tidal

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

EXPERIENCE:

Sr. Developer and Database Performance Specialist

Confidential

Responsibilities:

• Application development (SQL/Java/SAS/Python/Perl)
• Database troubleshooting and performance tuning
• Design and build database performance monitoring infrastructure
• Design and build database security model to support the firm’s entitlement-driven policy
• Data modeling and data warehouse design (relational and star schema)
• Design and implement the strategy of data lifecycle management
• Capacity planning on database related technology assets

Sr. Developer and Application DBA

Confidential

Responsibilities:

• Architectural design of the migration roadmap in all database-related aspects ranging from logical/physical database re-design to server hardware specifications
• Planning and implementation of the cross-platform database technology migration
• Technical guidance for application-level migration
• Database troubleshooting and performance tuning

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 SA

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 and configure the host machine(Sun E4500) with Solaris operating system.
• Install and configure 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.

Sr. Developer

Confidential

Responsibilities:

• Logical and physical database design
• Application development (SQL, C/C++)
• Database troubleshooting and performance tuning