Description
Job Description:The Senior Database/Java Developer will be responsible for database design, data model, configuration, and development as well as some Java related development work to build a mission critical enterprise risk platform, which supports various portfolio risk management needs within Western Asset. The person will implement tasks required for database design & development, Java application related implementation, and continuing operation of the enterprise risk management system as well as support other databases in risk management team. He/she will also work closely with Quant/SAS developers, QA engineers, and business analysts through out project life cycle under minimum supervision of project manager.
Responsibilities/Duties:
§ Work with quantitative/SAS developer, business analyst, DBA, System Administrator, and QA engineer to architect data model, design and implement database as well as write Java program required for the enterprise risk system.
§ Design and/or customize logical data model and build physical database supporting computational intensive database.
§ Propose proper database features for best design, customization, and user experience. Oracle (10g+) and MS SQL knowledge preferred.
§ Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
§ Optimize performance by analysing query patterns and building appropriate indexing and partition mechanisms.
§ Manage database artifacts in source code management system and deploy to DEV, QA, and Production environments.
§ Analyze issues & fix defects during SDLC, troubleshoot production issues, and respond to business users data inquiries.
§ Produce database design documents, test plans, and system requirements.
§ Understand complex data requirements such as Terms and Conditions, market, position and price data of vast Fixed Income and derivative securities.
Competencies:
§ Minimum 5 years intensive hands-on data modelling and database design experience for enterprise applications.
§ Minimum 5 years of intensive SQL and PL/SQL programming experience.
§ Minimum 2 years experience with performance turning - query optimization, indexing, partitioning etc.
§ Minimum 2 years of hands on Java development experience.
§ Familiar with Oracle 10g or 11g features.
§ Familiar with UNIX and Windows development environments and various Scripting languages eg PERL and Autosys.
§ Familiar with source code management and deployment tools such as SVN, CVS, Ant, and Ant Hill Pro.
§ Familiar with IT SDLC methodology and best practices.
§ Prior hands on experience with Oracle utilities/packages, MS SQL database, and Sybase is plus.
§ Prior hands on experience with J2EE, XML, industry popular frameworks, libraries, and application Servers is plus.
§ Prior experience with Fixed Income business and implementation of risk management system is a huge plus.
§ Highly self-motivated, results oriented, and capable of independent and critical thinking and problem solving
Academic Qualifications (minimum requirements):
§ B.S. or equivalent education in computer science or engineering is required. Advanced degree is preferred.