Senior Oracle SQL Developer (Level 5)

Senior Oracle SQL Developer  (Level 5)

The Senior Oracle SQL Developer reports to the Manager, Information Systems and is responsible for designing, scripting and implementing SQL script based solutions to support CSI’s on-line and back office systems. The role includes data modeling and day to day support, while working with team members to advise on database solutions.

What you will achieve in this role:

·         Capturing requirements, conducting analysis, producing and documenting data models for corporate and project specific initiatives

·         Analyzing and evaluating alternative data architecture solutions to meet business requirements and to comply with corporate data architectures, strategies and frameworks, including enterprise data warehouse activities

·         Designing, developing and maintaining Logical and Physical Data Models;

·         Defining data conversion mappings and ETL requirements between different data source and data targets

·         Developing and implementing PL/SQL and SQL procedures/scripts/packages that will ensure the accuracy, completeness, and timeliness of data stored in the database;

·         Identifying and documenting database content and structure, and developing/maintaining the data dictionary

·         Assisting with configuration control of the database

·         Performing and/or coordinating updates to the database design

·         Assisting with development and implementation of security procedures for the database, including access and user account management, as required.

·         Defining and documenting standards and best practices for data modeling activities

·         Providing technical assistance, guidance and direction in terms of Database Modeling and data issues and the efficient use of data, to the team throughout the system development cycle.

·         Assisting in troubleshooting and debugging database bottle-necks and providing performance metrics using database monitoring tools in both development and production environments

·         Assisting with the identification and implementation of performance and maintenance improvements for the current database design and application interactions in both development and production environments

·         Assisting in system upgrades, when required

What you will bring to this role:

• University degree and/or College diploma in a related discipline.
• 5+ years experience developing with PL/SQL on Oracle10g.
• Technically fluent in database programming languages, including T-SQL and PL/SQL
• 2+ years of experience analyzing and evaluating alternative data architecture solutions for large enterprise projects;
• Expert knowledge and extensive experience with building, administering, and maintaining Oracle
• Experience in Data Modeling using the Entity Relationship Model
• Hands-on database performance tuning and troubleshooting experience and expert knowledge with performance analysis tools
• Experience in at least one project designing data models for Data Warehouse systems would be  an asset
• Expert knowledge in Unix scripting, cron jobs, etc.
• Strong leadership and interpersonal skills to lead and guide other team members in database development & coding
• Strong written and verbal communication skills
• Strong time management and multitasking skills, as well as excellent initiative and adaptability
• Professional, friendly and courteous in all interactions with team members and business users.
• Team player and adaptable to a changing environment.
• Strong problem solving abilities

If this sounds like you or someone you know, contact us. 

E-mail a resume, with the subject line of “Senior Oracle SQL Developer” to resume@csi.ca.