Description
The City of Markham is proud to be recognized for the 4th consecutive year as one of Canada’s Best Employers by Forbes and Statista Inc. In 2024, the City of Markham is ranked the top city in Ontario and in the top 10 for Government Services. The recipient of multiple environmental awards, we are recognized for our innovative sustainability and urban planning initiatives as well as our fiscal accountability. More than 357,000 residents call Markham home and benefit from our rich heritage, culturally diverse environment, vibrant local economy and focus on quality of life.
Applications are now being accepted for the above position in the Information Technology Services (ITS) Department, Corporate Services Commission. To apply, please submit your cover letter and resume on-line by January 20, 2025.
Join us and make a lasting difference!
JOB SUMMARY
Reporting to the Lead, Database Management, the Database Administrator is responsible for the availability, integrity, security and performance of corporate databases and data through effective planning, administration, and client support. In-depth participation in Datawarehousing, Business Intelligence and Master Data Management programs.
KEY DUTIES AND RESPONSIBILITIES
- Responsible for upkeep of enterprise level Oracle and MSSQL server database stack by performing design, installations, configuration, and administration of multiple versions of each database platform.
- Conduct database optimization by managing all aspects of Oracle and MSSQL database performance, installation, configuration, design, capacity planning, load-testing, and performance benchmarks.
- Plan, execute, and monitor backup operations on all Oracle and MSSQL databases as well as all other data sets in a secured and reliable fashion. Perform backup and restore operations as per requirements.
- Provide operational support to incident management (break/fix), change management, release management according to guidelines provided by ITIL framework.
- Assist application support specialists and end-users in troubleshooting, diagnosis, and fixing of issues related to database environment and provide solution for issues and problems.
- Manage non-SQL (Big Data) platform to maintain unstructured data sitting in conjunction with structured data.
- Proactively monitor performance and ensure availability of database environment according to business continuity plan (BCP) and disaster recovery plan (DRP).
- Provide technical advice, subject matter expertise, and guidance on the analysis, interpretation and evaluation of complex database features to constantly upgrade and enhance the database environment according to emerging database technologies.
- Maintain database security by implementing the security policies, evaluating trends, anticipating security requirements, and applying security patches and fixes to database environment.
- Upkeep and maintain a fully patched database environment by planning and scheduling patches periodically, evaluating patches, applying patches to test environment, assist in patch testing, and patching the production servers in a timely and cost effective manner.
- Automate repeated tasks and activities by designing and implementing processes through scripts, procedures, and packages.
- Install, configure, and maintain MSSQL server features: SSRS, SSIS, and SSAS according to application requirements.
- Install, configure, and maintain Oracle APEX environment to build complex in-house applications. Implement and manage Workspace, user accounts, ORDS, and PLSQL for optimal functioning of APEX applications.
- Design, create, implement, modify, and maintain reporting and dashboard database structure in current reporting database platform and be able to adopt a new platform seamlessly by migrating database to the new platform.
- Design and implement data-marts, data extraction, data transformation, data load processes, and procedures through ELT and/or ETL methodologies. Provide support on existing data structures, processes, and procedures.
- Provide professional and technical expertise in design and operation of Datawarehouse (DWH), Master Data Management (MDM), and Business Intelligence (BI) initiatives by implementing database technologies, data governance, data quality, data extraction, data load, data consistency and accuracy, data security, and availability components and produce reports and dashboards for KPIs.
- Provide database support to GIS team to manage and maintain spatial data under ESRI platform.
- Work with vendors and third party service providers to maintain and upkeep of database environment.
- Support team lead and management by contributing in the implementation of capital projects, non-capital projects, software and technology selection, creating life-cycle plans and roadmaps.
Requirements
REQUIRED SKILLS & COMPETENCIES
- A college diploma or degree in computer science or equivalent.
- Minimum of 5 years’ experience in database administration and data/database related field of expertise.
- Certification in database technology platforms such as Oracle and MSSQL DBA are required.
- Excellent knowledge and working experience in Oracle Multi-tenant architecture and ETL/ELT platform.
- At least 5 years of experience with programming languages: SQL, T-SQL, PL/SQL, Java, Python.
- Strong command of database and data management related tools: OEM, MSSQL MS, SQLDeveloper,Toad.
- Excellent knowledge of database security, backup and recovery/restore, performance monitoring, disaster recovery and business continuity planning.
- Experience managing database backup and recovery operations using third party appliance such as Commvault.
- Experience in report and dashboard development using Crystal and SAP platforms.
- Strong knowledge and understanding of database concepts, design, and administration.
- Working knowledge of GIS data under ESRI platform.
- Experience in working under virtualized environment and be able to handle all tasks and support using virtual and on-site support methods.
- Experience in managing SSRS, SSIS, and SSAS.
- Vendor management skills related to database and third party applications support.
- Experience with cloud services (Oracle Cloud, Google, AWS, Microsoft Azure) an asset.
- Ability to work independently and as an integral part of a cross-functional team
- Excellent interpersonal and communication skills.
- Excellent documentation skills.
- Excellent problem solving and time management skills to handle multiple activities.
- Ability to work after-hours to help with scheduled maintenance and be willing to work on-call for emergencies and outages.
CORE BEHAVIOURS
- Service Excellence: Meets or exceeds service standards when interacting with customers in the community and in the organization.
- Change & Innovation: Responds positively and professionally to change and helps others through change.
- Teamwork & Relationship Building: Interacts with others in an inclusive, collaborative and respectful way that creates effective working relationships.
- Communication: Communicates in a clear, professional and respectful way; demonstrates active listening.
- Accountable & Results Oriented: Demonstrates ethical behaviour and accountability, aligns with City values, and abides by relevant policies and legislation.
- Management & Leadership: Demonstrates self-management, professionalism and engagement; leads by example.
The City of Markham is committed to inclusive, accessible and barrier free employment practices and to creating a workplace that reflects and supports the diversity of the community we serve. Please let us know if you require an accommodation and we will work with you to ensure a barrier free hiring process.
Please respect our scent free area by not wearing scented products when visiting the office.
Salary & Benefits
86,864.00 To 102,230.00 (CAD) Annually
From the same organization
14 Jan, 2025
20 Jan, 2025
10 Jan, 2025
