Serving a diverse urban and rural population of more than 430,000, Niagara Region is focused on building a strong and prosperous Niagara. Working collaboratively with 12 local area municipalities and numerous community partners, the Region delivers a range of high quality programs and services to support and advance the well-being of individuals, families and communities within its boundaries. Nestled between the great lakes of Erie and Ontario, the Niagara peninsula features some of Canada's most fertile agricultural land, the majesty of Niagara Falls and communities that are rich in both history and recreational and cultural opportunities. Niagara boasts dynamic modern cities, Canada's most developed wine industry, a temperate climate, extraordinary theatre, and some of Ontario's most breathtaking countryside. An international destination with easy access to its binational U.S. neighbour New York State, Niagara attracts over 14 million visitors annually, as well as a steady stream of new residents and businesses.
The Peoplesoft Administrator /Senior Database Administrator is responsible for managing all aspects of the database environments for all Regional departments and shared service partners through optimal and secure information technology systems, process improvement and best practices.
This role is also responsible for the architecture and support of Peoplesoft and Hyperion Enterprise application environments, including system requirements installing upgrades monitoring system performance
Bachelor's degree in Information Technology, Computer Science, or other related field of study. Formal training in PeopleSoft tools considered an asset.
Minimum five years' experience in a Microsoft SQL Server environment with experience in Hyperion and Peoplesoft Experience with Peoplesoft Integration Broker and Application Designer Experience with Peoplesoft PUM application process Minimum of eight (8) years' experience working in a senior technical role Experience in assessing application technology and end user needs and recommending solutions in accordance with Regional strategic direction and functional requirements. Demonstrated experience with database integration, implementation and upgrades. Experience in developing complex queries to extract data from multiple tables. Experience working in a project-based team. Strong interpersonal skills - motivation, influence, relationships, team building, coaching and mentoring Managed services and system development methodologies, application and technical architecture design, business modeling, data modeling (5 years of experience).
Support databases, manage data and data integrity, including monitoring and reporting. Manage the database environment, including resolution of any incidents, problem and service requests related to the databases in accordance with up to date support documentation. Work on Enhancements, design, build, configure and deploy databases and directory structures Development of database backup requirements. Responsible for database backups, disaster recovery and business continuity processes Install, test, and maintain changes to the SQL Server database management systems in accordance with the approved Change Management process. Advanced-level DBA competency and analytical capability. Experienced in database maintenance, clustering technologies or DR/failover considerations Review and recommend changes to database management systems (including implementation of new releases and upgrades and patches as well as recommendations to change to different systems and related migration plans). Monitor optimize/improve DB performance when necessary and reporting.
Uncover the wonder of the Niagara Region and join a team dedicated to meeting tomorrow's challenges TODAY!
Let us know why you would be an excellent team member by submitting your online application.
We thank all candidates for their interest however, only those candidates selected for an interview will be contacted.