Technology: UNIX, Linux, Windows, Sybase ASE, Sybase IQ, Oracle, SQL Server, Java, C, C++, T-SQL, PL/SQL, SQR, Shell Script, Perl, Python, PowerShell, FIX, Remedy
- Worked as level 2 application and production support for VALDI order management system for continued maintenance, performance tuning, data analysis with TSQL and PL/SQL, trouble shooting and data recovery for production, UAT testing, QA and development team.
- Maintain and enhance JAVA application for P&L server for VALDI OMS system.
- As a team lead training offshore team for DBA task, FIX on-line interface supporting and back-end system operation. Successfully managed domestic and offshore teams to realize the transition from regular market hour to 24x6 support for international trading system.
- Coordinated with client service team with Remedy tool serve the need from client and to develop ad hoc reports with SQL for client's special need.
- Built billing information database and support billing information collection and analysis for management and accounting.
- Designed and implemented batch component for VALDI NGO system with shell script, Perl and SQL.
- Created global batch management tools and checking system, that reduced the need for operational resource.
- Designed data backup and recovery system for different levels and created data rollback procedure.
- Designed and implemented database monitoring and automated maintenance system.
- Developed automated daylight time switch in database level for the need of international trading system.
- Developed automated trading calendar information loading program that provided trade-day, settlement-day and local holiday info of global more than 180 exchanges for the need of international trading complexes.
- Created reference data loading system with Shell Script that import data of symbol, Cusip, ISIN, Sedol, etc. from vendor, update system's security master and realized dynamic update to back-end servers.
- Created dividend corp-action data loading batch with Python that loaded vendor's source data to production system and update GTC orders in OMS system.
- Created end-of-day market data loading system that parse closing price info and market maker info from central price feed and load data to each OMS complex.
- Created automated system of global data consistency checking and maintenance.
