Description
Duties- Responsible for the architecture, implementation, and support of enterprise-wide databases of 500+ GB in size.
- Create functional and scalable applications from design and development through implementation.
- Ensure database integrity as well as usability utilizing knowledge in database (Oracle) design, tuning, modelling methods in multiple computing environments (Unix, Linux, AIX) as well as Oracle PL/SQL programming.
- Code complex PL/SQL packages, functions and procedures.
- Evaluate and seek solutions to production issues as well as new projects while working closely with application developers in solving production issues.
- Prepare short and long term plans to address infrastructure projects as well as support to and technical leadership for internally/externally sponsored company projects.
- Recommend schedules for database upgrades; assist in the planning and implementation of major software upgrades.
- Ensure all database projects and processes are fully documented.
- Perform in a distributed environment, the modifications and operations for Oracle database (10g DB, 10g AS, 10g CS and 10g DS), and Server (2000) environments.
Requirements
- Bachelor's degree or foreign equivalent in Computer Information Systems, Computer Science, Information Technology, or related field and 3 years of progressive experience as software developer.
- Experience must include data modelling and OLAP technology, SQL*Loader, TOAD and Korn Shell programming.