Database Administrator Level I

3 months ago

Airdrie, Canada City of Airdrie Full time

**Company Biography1**:
As one of the fastest growing cities in Alberta, the City of Airdrie is a recognized leader in building a vibrant and sustainable community through innovation.

At the City of Airdrie, incredible opportunities happen every day in a flexible work environment that is tailored to each department. Our inclusive culture and values create a workplace where we welcome aspiring, driven and creative individuals to help us accomplish our business and community goals. We are supportive of one another, and we have fun while we serve our community. We are passionate about improving the lives of our residents through care and respect; that is the foundation of our organization. At the City of Airdrie, we learn, grow and accomplish great things together.

If you have a passion for building a better community and are ready to join the excitement, we’d love to hear from you

**The Opportunity**:
The Database Administrator Level I is responsible for assisting senior technical resources and business units with administering relational databases in the Citys’ MS SQL environment. As the Database Administrator Level I, you will configure and maintain database servers and processes including monitoring the health of the system and overall performance. This position identifies inefficiencies and mitigates issues as needed to ensure system performance and security for all database systems. This position is accountable for excellent customer service while providing a reliable and stable database environment. The Database Administrator Level I receives escalated database service requests and works closely with business units and technical teams to deliver measurable outcomes.

Responsibilities include:

- Assist in all aspects of database administration including testing of all modifications, security administration, optimization, capacity planning and performance tuning
- Provide access to database resources through windows security permissions. Maintain appropriate database access control levels and security. Educate users on appropriate database use and security
- Configure and maintain database servers and processes, including monitoring of system health and performance
- Query and analyze data through complex T-SQL queries, responding to requests for the business. Identify data discrepancies and data quality issues and work to ensure data consistency and integrity
- Work closely with technical support staff and be available to troubleshoot routine problems that they may encounter. Escalate complex technical matters to the DBA Level II
- Assist with developing and maintaining stored procedures, triggers, views and functions within the database environment
- Provide technical direction to analysts for any database related support
- Collaborate in a team environment with senior database resources to understand the entire database structure within the organization
- Support project initiatives to improve database functionality and design
- Assist with the documentation and development of policies and procedures including for disaster recovery and data archiving to ensure effective availability, protection and integrity of data assets
- Record all database incidents, service requests, change requests and all related documentation including notes and resolutions within the City’s ITSM and SharePoint online
- Implement all production systems changes in line with the IT change management process

**You Bring**:

- Completion of a post-secondary information technology degree or diploma, with a focus in database management
- Certificate in database analysis, management and/or design
- The following certifications would be an asset: ITIL Foundations v4, Power BI and data Analytics Certification, Microsoft Certifications in SQL or windows server
- Prior work experience in a database administrator role supporting on premise Microsoft SQL server enterprise environment
- Minimum 5 years of work experience supporting technology services
- Prior work experience troubleshooting and resolving database issues (performance, integrity, recovery, security, etc.)
- Strong working knowledge of relational database systems and all components
- Strong working knowledge of SQL components and query languages such as T-SQL, SSIS, DTS, SSRS, SQL Server Agent
- Knowledge of database configuration, support, development in Microsoft Azure
- Experience setting and establishing windows permissions to various file structures
- Experience participating in software upgrades, capacity management and patching
- Strong knowledge of windows servers running SQL Server version 2005+
- Experience with monitoring and diagnostic tools such as SQL Profiler and database tuning engine wizard
- Knowledge of database development and programming
- Knowledge of other database technologies such as MySQL, Postgres SQL, Oracle, Firebird would be an asset
- Working knowledge of spatial reference technologies such as ArcGIS would be an asset
- Strong initiat

  • Administrative Assistant

    6 months ago

    Airdrie, Canada Equation Staffing Solutions. Full time

    We are currently seeking Administrative Assistant on a temporary, contract or casual basis for several of our clients in Airdrie. If you are organized, detailed oriented and self motivated, we would love to speak with you about our current opportunities! **Responsibilities**: - Direct clients, staff and guests to appropriate departments - Handle client...

  • Administrative Manager

    3 weeks ago

    Airdrie, Canada Jomana Badran Professional Cooperation Full time

    About the RoleWe are seeking a highly skilled and experienced Administrative Manager to join our team at Jomana Badran Professional Cooperation. As an Administrative Manager, you will be responsible for coordinating administrative services, preparing annual budgets, and conducting research to support the growth and development of our organization.Key...

  • Administrative Support Specialist

    3 weeks ago

    Airdrie, Canada THE KIDS PLANET INC. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at THE KIDS PLANET INC. as a key member of our administrative staff.Key ResponsibilitiesAdministrative Support: Provide administrative support to our team, including preparing and maintaining records, files, and databases.Communication: Respond to...

  • Administrative Support Specialist

    2 weeks ago

    Airdrie, Canada THE KIDS PLANET INC. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at THE KIDS PLANET INC. as a support role.Key ResponsibilitiesAdministrative Support: Provide administrative support to our team, including preparing and maintaining records, files, and databases.Communication: Respond to electronic inquiries,...

  • Administrative Support Specialist

    2 weeks ago

    Airdrie, Canada THE KIDS PLANET INC. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at THE KIDS PLANET INC. as a support role.Key ResponsibilitiesAdministrative Support: Provide administrative support to our team, including preparing and maintaining records, files, and databases.Communication: Respond to electronic inquiries,...

  • Administrative Support Specialist

    3 weeks ago

    Airdrie, Canada Rocky View Schools Full time

    **About Rocky View Schools**Rocky View Schools is a rapidly growing school division in Alberta, supporting the educational needs of over 28,000 students from Kindergarten to Grade 12 in 52 schools. Our mission is to ensure students learn, belong, and succeed.**Job Summary**We are seeking an experienced Administrative Assistant II to join our team. As a key...

  • Administrative Coordinator

    19 hours ago

    Airdrie, Canada Precise Builders Ltd. Full time

    Job SummaryPrecise Builders Ltd. is seeking an organized and detail-oriented Administrative Assistant to support our team. The successful candidate will be responsible for scheduling appointments, managing information filing systems, and providing administrative support to our staff.Key ResponsibilitiesScheduling and Coordination: Schedule and confirm...

  • Administrative Coordinator

    3 hours ago

    Airdrie, Canada Precise Builders Ltd. Full time

    Job SummaryPrecise Builders Ltd. is seeking an organized and detail-oriented Administrative Assistant to support our team. The successful candidate will be responsible for scheduling appointments, managing information filing systems, and providing administrative support to our staff.Key ResponsibilitiesScheduling and Coordination: Schedule and confirm...

  • Administrative Manager

    2 weeks ago

    Airdrie, Canada Jomana Badran Professional Cooperation Full time

    About the RoleWe are seeking a highly skilled and experienced Administrative Manager to join our team at Jomana Badran Professional Cooperation. As an Administrative Manager, you will be responsible for coordinating administrative services, preparing annual budgets, and conducting research to support the growth and development of our organization.Key...

  • Administrative Manager

    2 weeks ago

    Airdrie, Canada Jomana Badran Professional Cooperation Full time

    About the RoleWe are seeking a highly skilled and experienced Administrative Manager to join our team at Jomana Badran Professional Cooperation. As an Administrative Manager, you will be responsible for coordinating administrative services, preparing annual budgets, and conducting research to support the growth and development of our organization.Key...

  • Service Administrator

    1 week ago

    Airdrie, Canada Chamco Industries Ltd. Full time

    **Job Summary** **About Chamco Industries Ltd.** Chamco Industries Ltd. has been a leader in pumping and compression equipment services for the world's air and fluid requirements since 1962. Chamco designs, manufactures and services a broad selection of air and fluid modular packages and equipment, while providing our 24 hour field service by factory...

  • Administrative Coordinator

    2 weeks ago

    Airdrie, Canada Precise Builders Ltd. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at Precise Builders Ltd.Key ResponsibilitiesScheduling and Coordination: Schedule and confirm appointments, meetings, and events, ensuring seamless coordination and minimal disruptions.Communication and Reception: Answer telephone calls, relay...

  • Administrative Coordinator

    2 weeks ago

    Airdrie, Canada Precise Builders Ltd. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at Precise Builders Ltd.Key ResponsibilitiesScheduling and Coordination: Schedule and confirm appointments, meetings, and events, ensuring seamless coordination and minimal disruptions.Communication and Reception: Answer telephone calls, relay...

  • Administrative Coordinator

    5 days ago

    Airdrie, Canada Precise Builders Ltd. Full time

    About the RolePrecise Builders Ltd. is seeking an experienced Administrative Assistant to join our team. As an Administrative Assistant, you will play a vital role in supporting our operations by providing administrative support to our staff.Key ResponsibilitiesScheduling and CoordinationSchedule and confirm appointments, meetings, and events, ensuring...

  • Administrative Coordinator

    5 days ago

    Airdrie, Canada Precise Builders Ltd. Full time

    About the RolePrecise Builders Ltd. is seeking an experienced Administrative Assistant to join our team. As an Administrative Assistant, you will play a vital role in supporting our operations by providing administrative support to our staff.Key ResponsibilitiesScheduling and CoordinationSchedule and confirm appointments, meetings, and events, ensuring...

  • Administrative Coordinator

    22 hours ago

    Airdrie, Canada Precise Builders Ltd. Full time

    Job SummaryPrecise Builders Ltd. is seeking an experienced Administrative Assistant to join our team. As an Administrative Assistant, you will provide administrative support to our team, ensuring the smooth operation of our office.Key ResponsibilitiesScheduling and CoordinationSchedule and confirm appointments, meetings, and events, ensuring timely and...

  • Administrative Coordinator

    20 hours ago

    Airdrie, Canada Precise Builders Ltd. Full time

    Job SummaryPrecise Builders Ltd. is seeking an experienced Administrative Assistant to join our team. As an Administrative Assistant, you will provide administrative support to our team, ensuring the smooth operation of our office.Key ResponsibilitiesScheduling and CoordinationSchedule and confirm appointments, meetings, and events, ensuring timely and...

  • Administrative Coordinator

    1 week ago

    Airdrie, Canada GOLDEN WHEELS TRANSPORT LTD. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at GOLDEN WHEELS TRANSPORT LTD.Key ResponsibilitiesCoordinate seminars, conferences, and other eventsPrepare and distribute meeting minutes, reports, and other documentsDevelop and implement office procedures and routinesSchedule appointments and...

  • Administrative Coordinator

    1 week ago

    Airdrie, Canada GOLDEN WHEELS TRANSPORT LTD. Full time

    About the RoleWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at GOLDEN WHEELS TRANSPORT LTD.Key ResponsibilitiesCoordinate seminars, conferences, and other eventsPrepare and distribute meeting minutes, reports, and other documentsDevelop and implement office procedures and routinesSchedule appointments and...

  • Administrative Coordinator

    7 days ago

    Airdrie, Canada Precise Builders Ltd. Full time

    About the RolePrecise Builders Ltd. is seeking an experienced Administrative Assistant to join our team. As an Administrative Assistant, you will play a vital role in supporting our operations by providing administrative support to our staff and management.Key ResponsibilitiesScheduling and CoordinationSchedule and confirm appointments, meetings, and events,...