Job Description :


Location: Little Rock, AR (Permanent remote)
Note: What we are looking for on this role is more of a PL/SQL DB2 developer as opposed to a DBA. We need an expert with performance tuning and running queries in PL/SQL. Someone who has an expert level of understanding of database partitioning in DB2
POSITION OVERVIEW : DB2 Expert
POSITION GENERAL DUTIES AND TASKS :
5+ years of DB2 Database experience
Experience in performance tuning
Good understanding of database concepts i.e. normalizations/de-normalizations, schemas, table spaces, temporary tables, views, indexes, sequences, partitioning etc. is required.
SQL 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.
Expertise in Physical Database design
Disaster Recovery implementation and Testing
HADR support
Performance tuning
Security Hardening
Backup and restore scripts
SQL analysis
Run stats and reorgs
Unix Shell Scripting
Powershell scripting

             

Similar Jobs you may be interested in ..