Pl/SQL (Or Postgres) Developer (Calgary)

Pl/SQL (Or Postgres) Developer (Calgary)

16 Nov
|
Utility Network E Partners
|
Calgary

16 Nov

Utility Network E Partners

Calgary

ABOUT US

POSITION

RESPONSIBILITIES

- Design and develop PL/SQL (or Postgres) database solutions that meet business requirements.
- Write complex SQL queries and create database triggers, functions, and procedures.
- Develop, maintain and enhance database schemas, tables, views, and indexes.
- Develop stored procedures, packages, and other database objects.
- Optimize database performance by identifying and resolving issues related to database design, indexing, and query performance.
- Create and maintain documentation related to database architecture, design, and implementation.
- Work collaboratively with cross-functional teams to ensure high-quality code delivery.
- Provide production support for database systems, troubleshoot and resolve database-related issues.
- Ensure adherence to database security and data integrity standards.
- Analysis, design, support, maintenance, and implementation of all aspects of Oracle systems to meet various marketing and operational requirements of the company.
- Develop technical specifications for systems development, design, and implementation from business interactions.
- Ensure the Oracle database is properly set up and maintained to enable optimal query plans and execution.
- Continually take the initiative to learn, and implement/share new ideas and learnings with the team.

REQUIREMENTS / QUALIFICATIONS

- Bachelor's or Master's degree in Computer Science, Information Technology or a related field.
- Strong proficiency in PL/SQL (or Postgres) database development.
- Experience in database design, development, and performance tuning.
- Expertise in SQL, including complex queries, optimization techniques, and debugging.
- Ability to develop stored procedures, packages, and triggers.
- Strong understanding of database security, data integrity, and backup and recovery procedures.
- Excellent problem-solving, debugging, and troubleshooting skills.
- Ability to work effectively in a team environment.
- Excellent communication and documentation skills.




- Minimum of five years of experience in software development.
- Minimum five years of experience with PL/SQL.
- Relevant experience with relational databases, database design, data modelling, data cleansing, and performance tuning.
- Solid written and oral communication skills in English.
- Highly self-motivated and self-directed.
- Keen attention to detail.
- Post-secondary degree/diploma in Computer Science or related field, or equivalent experience.
- Reside in Calgary.

SKILLS

- Experience with Oracle PL/SQL and/or MySQL.
- Experience with NoSQL databases.
- Familiarity with data analytics and reporting tools such as Tableau or Power BI.
- Experience with cloud-based database solutions such as AWS RDS or Azure SQL Database.
- Experience with version control systems such as Git.
- Working knowledge of SQL and DML.
- Working knowledge of Oracle dictionary and DDL.
- Proficiency in leveraging AI tools and technologies to improve productivity, automate routine tasks, and support data-driven decision-making.
- Experience evaluating AI-generated outputs for quality, accuracy, relevance, and alignment with business objectives.
- Adherence to programming best practices.
- Excellent analytical and debugging skills.
- Excellent organizational and self-management skills.
- Excellent accuracy, decision-making, problem-solving, and critical thinking skills.
- Proven interpersonal and collaborative skills with the ability to work as part of a team in an open-concept office space.
- Knowledge of Jira/SVN/Confluence/Tortoise is an asset.

Pay: $85,000.00-$90,000.00 per year

Flexible language requirement:

- French not required

Ability to commute/relocate:

- Calgary, AB T2G 0T3: reliably commute or plan to relocate before starting work (preferred)

Education :

- Bachelor's Degree (preferred)

Experience :

- Software development: 5 years (preferred)
- Oracle PL/SQL and/or MySQL: 1 year (preferred)
- NoSQL databases: 1 year (preferred)
- cloud-based database solutions: 1 year (preferred)
- version control systems: 1 year (preferred)

Work Location: In person

📌 Pl/SQL (Or Postgres) Developer (Calgary)
🏢 Utility Network E Partners
📍 Calgary

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: pl/sql (or postgres) developer (calgary) / calgary

Subscribe to this job alert:

Get the latest job offers by email for: pl/sql (or postgres) developer (calgary) / calgary