Fimat Banque from as E-trading Engineer and DBA
janvier 2001 - juin 2005
FIMAT is a Broker Firm on derivative and cash markets, it is present in many Capitals cities worldwide: Paris, New York, Chicago, Frankfurt, Madrid, Hong Kong, Sydney, Montreal and London, and provides a heterogeneous E-trading system to several customers (Brokers and dealers).
The System consists of order routing and data markets: GL Trade, Patsytem, Orcsys TTsystem, FIX via Ulllink Bridge, Fimatrade
Duties:
Application, UNIX and Network infrastructure management:
• Provided technical expertise and guidance in areas of system capabilities and design resources.
• Performed the analysis, design, implementation and maintenance of enterprise UNIX servers and network.
• Administered and maintained change management for UNIX systems and network infrastructure.
• Maintained security to ensure system integrity and maximum availability.
• Assisted in the building and configuration of servers, racks, and related server infrastructure equipment.
• Planned, prioritized, controlled and performed functional changes, enhancements and updates to ensure maximum uptime and systems integrity.
• Identified inadequate or inefficient systems and suggested alternatives to reduce cost and/or increase efficiency
• Developed, documented, maintained and performed annual disaster recovery drills to reaffirm documented procedures and minimize downtime in the event of server failure.
• Developed and documented systems maintenance procedures.
• Kept abreast of new developments in technical areas (trends & technology) for possible application within the company
• Researched new systems and technologies required for projects, or as requested.
Oracle, Sybase and MSSQL management:
• Reviewed, developed, and designed data models using standard diagramming techniques, in conjunction with application development teams; created logical data models and translated them into physical database structures that integrated with existing or proposed database structures.
• Monitored relational databases to optimize database performance, resource use, and physical implementations of the databases; addressed a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, planning issues, and new applications.
• Maintained development, test, and production RDBMS environments.
• Monitored and maintained database security and database software, in cooperation with data security administrators.
• Provided advice to application programmers in the effective use of database languages; advised on troubleshooting, exception processing needs, and other data management issues.
• Maintained availability and integrity of databases through multiple access schemes; facilitated sharing of common data by overseeing proper key and index management and data dictionary maintenance.
• Evaluated and recommended testing and evaluation of new procedures, software, and hardware.
• Communicated with the clients and different teams to identify and resolve problems.
• Performed Order routing and data Market Feed management:
• Application Design, implementation, update and migration,
• Provided support of three levels on order routing and data Market,
• Monitored, maintained and tuned application servers for best performance.
• Gathered and analyzed monitored data to foresee possible incidents.
• Resolved incidents related to the system on all sides (front-end, exchange, brokers and providers)
• Developed short-time tools and scripts for monitoring and reporting.
• Escalated detailed reports of all incidents to development team, brokers and providers.
• Maintained availability and integrity of application
• Communicated with the clients and different partners to identify and resolve problems
• Planned and prioritized scheduling tasks.
Colleague and team communication:
• Trained colleagues on all projects which I was in charge of and created detailed documentation.
• Monitored and double checked every change on the active system before and after implementation, especially on back-end, front and middle office systems.
• Double checked every migration rollback documentation procedure and updated it.
• Provided clear reports on all issues and incidents.
• Redirected and helped colleagues on their projects and affected tasks.
• Arranged meetings and conference calls, dealing with all aspects of the systems, and wrote follow up reports.
• Communicated with the management every time when needed and gave them pertinent information concerning the systems and teams.