DB2 Technical SME
DB2 Technical SME100% Remote Project Name: Payer-Tech Digital Transformation
Duration: 4 months
Description:
- Candidate must be able to build stored procedures from scratch and convert the code from one system to another in specific from Netezza to db2 luw.
- Able to handle full system built in functions, procs in db2Develop/modify udf's and uda's from scratch/existing
- Performance tuning techniques over db2Good understanding of database concepts normalizations/de-normalizations, schemas, table spaces, buffer pools, temporary tables, views, materialized views, indexes, sequences, partitioning, UDF and Triggers etc
- Having strong usage of db2 utilities like dbsql, dbload, import/export etc...Ability to analyze existing code and modify them w.r.t. db2 with strong background in database programming using DB2/SQL, stored procedures, functions, triggers and packages.
- Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
- Working experience in database security, primarily on Encryption and decryption concepts is plus.
- IBM DB2 Stored Procedures – Create, Research, gather and analyze information.
- Strong experience with performance tuning for PLSQL coding.
- Ability to translate business requirements into technical design documents.
- Good knowledge of UDF's/UDA's, cursors, functions, views, materialized views indexes, collections, triggers.
Required Skills:
PL/SQL Programming (IBM DB2), Unix..IBM DB2 Stored ProceduresUDF's/UDA's, cursors, functions, views, materialized views indexes, collections, triggers. PL/SQL Performance TuningData Analysis