Database Administrator Level I

5 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



  • Airdrie, Alberta, Canada THE KIDS PLANET INC. Full time

    At THE KIDS PLANET INC., we are seeking an Administrative Officer to join our team. As an Administrative Officer, you will be responsible for maintaining manual and computerized information filing systems. You will also type and proofread correspondence, forms and other documents, as well as perform data entry. Additionally, you will be responsible for...

  • Service Administrator

    2 months 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...


  • Airdrie, Alberta, Canada GOLDEN WHEELS TRANSPORT LTD. Full time

    Key Responsibilities:Administrative Support: Provide administrative support to ensure efficient office operations.Communication: Establish and maintain effective communication with colleagues, clients, and management.Task Management: Coordinate and schedule appointments, meetings, and events.Office Organization: Maintain accurate and up-to-date records,...


  • Airdrie, Alberta, Canada Canada Inc Full time

    About the RoleWe are seeking an organized and detail-oriented Administrative Clerk to join our team at Canada Inc. As a key member of our administrative staff, you will be responsible for providing exceptional support to our employees and stakeholders.ResponsibilitiesType and proofread correspondence, forms, and other documents with accuracy and...

  • Administrator, Quality

    2 months ago


    Airdrie, Canada Strike Group Full time

    *** Supporting our Quality Control department, the Administrator will provide support managing and distributing controlled manuals, issuing, and processing PO’s, managing AP/AR logs for business units, and maintaining and formatting all Quality technical documentation and supporting databases. Employees are expected to support and participate in a...

  • Office Administrator

    2 months ago


    Airdrie, Canada MJ McClain Professional Corporation Full time

    **Job Summary** **Responsibilities**: - Oversee daily office operations and ensure efficient workflow. - Manage client relationships, including follow-up on client documents and collections. - Maintain client files and client database. - Provide support for bookkeeping and year-end preparation. - Provide administrative support, including clerical tasks...

  • Administrative Manager

    5 months ago


    Airdrie, Canada Jomana Badran Professional Cooperation Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years - Business administration and management, general **Work setting**: - Clinic **Tasks**: - Co-ordinate administrative services - Assist in preparing annual budgets - Conduct research - Plan, organize, direct, control and evaluate daily operations - Direct and advise staff engaged in...


  • Airdrie, Alberta, Canada THE KIDS PLANET INC. Full time

    Administrative Assistant Role at THE KIDS PLANET INC.We are seeking a detail-oriented and organized individual to join our team as an Administrative Assistant. This role will provide administrative support to our team, ensuring the smooth operation of our daily activities.Key Responsibilities:Record and prepare minutes of meetings, seminars, and...

  • Administrator, Quality

    6 months ago


    Airdrie, Canada Strike Group Full time

    POSITION SUMMARY Supporting our Quality Control department, the Administrator will provide support managing and distributing controlled manuals, issuing, and processing PO’s, managing AP/AR logs for business units, and maintaining and formatting all Quality technical documentation and supporting databases. Employees are expected to support and...


  • Airdrie, Alberta, Canada PLATINA LIQUOR INC. Full time

    At PLATINA LIQUOR INC., we are seeking an experienced Administrative Assistant to join our team. This key role will be responsible for providing administrative support to our management team, ensuring the smooth operation of our office.Key Responsibilities:Scheduling and Coordination: Schedule appointments, meetings, and travel arrangements for management...


  • Airdrie, Canada Mango Insurance Full time

    Education: Secondary (high) school graduation certificate - Experience: 7 months to less than 1 year - or equivalent experience - ** Tasks**: - Arrange and co-ordinate seminars, conferences, etc. - Record and prepare minutes of meetings, seminars and conferences - Schedule and confirm appointments - Greet people and direct them to contacts or service...


  • Airdrie, Alberta, Canada Canada Inc Full time

    We are seeking a highly organized and detail-oriented Administrative Clerk to join our team at Canada Inc.About the RoleThis permanent, 30-hour per week position is an excellent opportunity for someone who enjoys working in a fast-paced environment and has strong communication skills.Job ResponsibilitiesType and proofread correspondence, forms, and other...


  • Airdrie, Canada King's Court Church Full time

    **Job Overview** **Responsibilities** - Office administration including computer processing (Word, Excel, Power point, Publisher, etc.), copying, purchasing of supplies and coordinating and tracking servicing and maintenance of the office equipment. - Sort and distribute mail and messages. - Maintain subscriptions and licenses. - Maintain membership...


  • Airdrie, Canada Get Go Transportation Inc. Full time

    Education: - Expérience: **Education**: - Secondary (high) school graduation certificate **Tasks**: - Coordinate the flow of information within the team - Open and distribute mail and other materials - Establish and implement policies and procedures - Determine and establish office procedures and routines - Schedule and confirm appointments - Manage...


  • 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...


  • Airdrie, Alberta, Canada Mango Insurance Full time

    About the RoleAs an Administrative Assistant at Mango Insurance, you will play a vital role in ensuring the smooth operation of our office. Your responsibilities will include arranging seminars and conferences, recording minutes of meetings, scheduling appointments, greeting visitors, conducting research, performing data entry, providing exceptional customer...


  • Airdrie, Canada Get Go Transportation Inc. Full time

    Education: Secondary (high) school graduation certificateExperience: 1 year to less than 2 yearsTasksCoordinate the flow of information within the teamOpen and distribute mail and other materialsEstablish and implement policies and proceduresDetermine and establish office procedures and routinesSchedule and confirm appointmentsManage contractsAnswer...


  • 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...


  • Airdrie, Alberta, Canada THE KIDS PLANET INC. Full time

    Job OverviewWe are seeking a highly skilled administrative support specialist to join our team at THE KIDS PLANET INC. This role involves providing administrative support to ensure the smooth operation of our organization.Job DescriptionThis is an exciting opportunity for an organized and detail-oriented individual to work in a dynamic environment. As an...


  • Airdrie, Canada Get Go Transportation Inc. Full time

    Education: Expérience: EducationSecondary (high) school graduation certificateTasksCoordinate the flow of information within the teamOpen and distribute mail and other materialsEstablish and implement policies and proceduresDetermine and establish office procedures and routinesSchedule and confirm appointmentsManage contractsAnswer telephone and relay...