DB2 / Security: RCAC data masking and FIELDPROC data encryptionExtJs & ValenceJSONEmbedded SQLService Programs

Programming:- Maintain and extend our existing ERP (mostly RPG and CL) using ILE and SQL when appropriate (and fixed format, native I/O and DDS where appropriate).- Maintain and upgrade existing Tradestone application (Java and WebSphere).- Maintain and develop data interfaces with 3rd party software, EDI provider, and between internal applications (some FTP interfaces, and some internal Java based interfaces between systems).- Beginner/Intermediate Java SE 7, PHP, HTML, and CSS skills.Database: - DDL (tables, views, indices) and DML (embedded SQL in RPG and CL)- Stored Procedures including returning result sets to RPG - UDFs (User Defined Functions) and UDTFs (User Defined Table Functions)- Database normalization (and denormalization where appropriate)- Performance and tuning; creating and refreshing MQTs (Materialized Query Tables), indexing strategy, and redesign of poorly performing programs.Analysis/Architecture: - System analysis, design and integration of new applications.- Requirements gathering for database and applications.- Defining technical standards; developing and teaching modern ILE coding, creating code review checklists and processes, developing and promoting a library of reusable modules/procedures.

RPG IV, ILE, SQLRPGLESQLCL (CLP, CLLE)SubfilesService ProgramsBatch processingAnalysis, Solution Design, Development