HMontreal, QCPL/SQL Developer (Unix & DB2)
Context
A client in Montreal is looking for a database developer for a contract of six months or more. The work centres on Oracle and DB2 databases running on Unix and Linux systems.
What you'll do
- Develop and maintain PL/SQL code on Oracle and DB2 UDB databases
- Tune SQL queries and optimize database performance
- Write and maintain Bash or Korn shell scripts on Unix and Linux
- Schedule and monitor batch jobs with AutoSys or Control-M
- Troubleshoot production issues and analyze root causes
Profile
- Strong experience with Oracle PL/SQL and DB2 UDB
- Solid knowledge of Unix/Linux and shell scripting (Bash or Korn shell)
- Experience with SQL performance tuning and query optimization
- Working knowledge of Python or Perl and scheduling tools such as AutoSys or Control-M
- Strong troubleshooting and analytical skills