Application and Infrastructure Analyst II

City Of Edmonton; Edmonton; Hybrid; CAD 90,000 - 116,000; Full time

Job summary

An established industry player is seeking a Senior Analyst for their POSSE Application Support team. In this pivotal role, you will ensure the reliable operation of the POSSE enterprise application system's Oracle databases. Your expertise in database administration will be crucial for optimizing performance, conducting proactive monitoring, and solving complex technical challenges. This position offers an engaging team environment where your contributions will significantly impact the organization's success. If you're ready to take on a rewarding challenge that values your skills and dedication, this is the opportunity for you.

Benefits

Flexible work arrangement

Diversity and Inclusion initiatives

Comprehensive benefits package

Professional development opportunities

Qualifications

• 4+ years of relevant experience in Oracle Database Administration.
• Strong PL/SQL skills and performance monitoring techniques.

Responsibilities

• Provide operational support for POSSE Oracle Database and troubleshoot performance issues.
• Conduct PL/SQL code reviews and establish best practices.

Skills

Oracle Database Administration

PL/SQL

Performance Monitoring

Problem-Solving

Time Management

Analytical Skills

Communication Skills

Customer Service

Python

ITIL Certification

Education

Degree in Computer Science

Post-secondary Diploma in Software Development

Tools

TOAD

Linux ksh (Korn shell)

Oracle WebLogic

Oracle Fusion Middleware

Job description

Manage the Performance of a Critical System

As a Senior Analyst on our POSSE Application Support team, you'll be at the heart of ensuring the reliable operation and performance of the POSSE enterprise application system’s Oracle databases with a strong focus on Oracle Database Administration. You'll leverage your expertise in database administration and application support to ensure optimal system performance, conduct proactive monitoring, and address complex technical challenges. You will have the opportunity to provide expert technical leadership and solve intricate problems, all the while working in a great team environment. Ready to take on a challenging and rewarding role where your contributions truly matter?

What will you do?

• POSSE Oracle Database Operational Support - You will be required to assist POSSE Developers with troubleshooting system performance issues and with optimizing PL/SQL code, with planning and implementing POSSE upgrades, patches, setting up non-production environments, writing Linux ksh (Korn shell) scripts, accounts administration, daily administrative tasks, and required maintenance
• Performance Monitoring and Tuning - Using tools such as TOAD, you will be responsible for tuning SQL queries, proactive analysis, trending, monitoring and detection of system performance deficiencies in order to remedy and/or implement preventative measures
• Problem Management - Identify and lead efforts to resolve business and technical operational issues to ensure that they are managed in accordance with agreed standards and procedures
• Production Migration - Support development code migration changes and implement database changes, configurations, and optimizations to the POSSE production environment
• Systems Testing - Participate in system testing to validate database changes and ensure system stability
• Systems Audit - Conduct POSSE Developer PL/SQL code reviews, data audits and establish coding, application and database development best practices and protocols
• Systems Documentation - Define and extend the POSSE support library documentation of system architectural designs, definitions, guidelines, best practices, disaster recovery and operational support procedures
• Mentoring - Provide technical and business guidance as well as knowledge transfer to team and support staff

Qualifications

• Degree in a Computer Science from C.I.P.S accredited institution
• Four (4) years relevant experience; OR Post-secondary Diploma in Software Development related fields and five (5) years of relevant experience

Skills required for success:

• Expert experience in Oracle Database Administration, in particular strong PL/SQL skills, performance monitoring and tuning techniques
• Excellent analytical and problem-solving skills, with a strong aptitude for assessing complex technical issues
• Excellent time management, involving the coordination, planning, and monitoring of tasks
• Demonstrated ability to troubleshoot and resolve database-related issues in a timely manner
• Excellent organizational, interpersonal, and communication (both verbal and written) skills, with a strong dedication to great customer service
• Experience with POSSE is an asset
• Experience with Python is an asset
• Experience with installation, patching, and troubleshooting Oracle WebLogic and Oracle Fusion Middleware is an asset
• Experience supporting a computing environment similar to the City of Edmonton's, encompassing multi business user groups, intricate data application integrations, client/server infrastructures, cloud computing, and ERP applications is an asset
• Information Technology Infrastructure Library (ITIL) or other Information Technology Service Management (ITSM) certification is an asset
• Ability to participate in 24/7 on-call technical support

Work Environment:

• Note: This position may be eligible for a hybrid work arrangement with the flexibility to work from both home and the worksite as per the Letter of Understanding between the City of Edmonton and Civic Service Union 52
• The weekly hours of work for this position are currently under review and may change at a future time. Any changes will be made in accordance with the City of Edmonton/Civic Service Union 52 collective agreement and the incumbent will be notified in advance
• Alignment to our Art of Inclusion: Our Diversity and Inclusion Framework
• Alignment to our Cultural Commitments
• Alignment to our Leadership Competencies
• Applicants may be tested

The City of Edmonton values applicants with a diverse range of skills, experiences and competencies, and encourages you to apply. We strive to provide reasonable access and accommodations throughout the recruitment process. To request an accommodation, please contact [e-mail]. Learn more about our benefits https://bit.ly/COEbenefits.

Up to 1 permanent full-time position available

Hours of Work: 33.75 hours per week, Monday - Friday

Salary Range: $51.171 - $65.301 (Hourly); $90,150.51 - $115,044.04 (Annually)

Talent Acquisition Consultant: RD/MZ

Edmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Metis Nation.

Classification Title: Application & Infra Analyst II
Posting Date: Apr 25, 2025
Closing Date: May 9, 2025 11:59:00 PM (MDT)
Number of Openings (up to): 1 - Permanent Full-time
Union: CSU 52
Department: Financial and Corporate Services
Work Location(s): Century Place, 18th Floor, 9803 - 102A Avenue Edmonton T5J 3A3