Application and Infrastructure Analyst II Job Listing at City of Edmonton in Edmonton, AB (Job ID 52160)

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