Talent.com
Database Administrator
Database AdministratorBGIS • Toronto, ON, CA
Database Administrator

Database Administrator

BGIS • Toronto, ON, CA
6 days ago
Job type
  • Full-time
Job description

Job Description

The Database Administrator (DBA) will possess extensive knowledge and practical experience in supporting enterprise database environments with MS SQL, along with proficiency in one or more of the following : Oracle, MongoDB, mySQL, MariaDB, PostgreSQL. The DBA’s responsibilities include managing database operations such as installations and upgrades, data access and migration, high availability, monitoring, and troubleshooting. Furthermore, they will provide technical leadership in areas including database design and solutioning, security, performance tuning, and capacity planning to ensure robust support for business-critical applications.

Key Duties & Responsibilities

Database Management

  • Manage all database instances, including creation, configuration, and monitoring
  • Proactively ensure optimal availability and performance of the database systems
  • Ensure 24x7 operations of customer-critical database systems
  • Implement and support cloud-based database solutions
  • Provide guidance on data modelling, database design and infrastructure
  • Design and implement highly available, redundant database solutions
  • Generate standard operating procedures for database operations in order to standardize all relevant database activities

Database Application Support

  • Provide support for database applications, ensuring optimal performance and reliability
  • Collaborate with development teams to design and implement database solutions
  • Troubleshoot and resolve database-related issues promptly
  • Support code or release deployment process
  • Performance Tuning

  • Perform system and query tuning to optimize database performance
  • Analyze and resolve performance bottlenecks
  • Implement best practices for database performance and scalability
  • Patching and Security

  • Plan and support internal projects such as database patching, migrations and upgrades
  • Accountable for database security and integrity
  • Ensure compliance with security policies and standards
  • Assist in designing backup, recovery and DR strategies
  • Investigate and implement new features within continuous service improvements process
  • Facilitate audit discoveries and remediation activities
  • Monitoring and Maintenance

  • Utilize and maintain SQL monitoring tools
  • Conduct regular health checks and performance assessments
  • Conduct capacity planning and growth projections
  • Propose and develop automated solutions for routine database processes, tasks, and procedures to improve efficiency
  • Additional

  • Follow operational policies and processes that are compliant with ITIL standards
  • Track projects and system incidents through to resolution via the IT ticket tracking system and the various IT Logs
  • Participate in project and team meetings - interacting and collaborating with team members and other departments as required
  • Maintain qualifications and continuous learning relevant to your role
  • Other duties as assigned
  • Knowledge & Skills

  • 2-5 years of proven experience as a Database Administrator
  • Post-Secondary education in IT or related discipline
  • Extensive hands‑on experience building and managing MS SQL servers and databases
  • Proficiency with one or more of the following database systems : Oracle, MongoDB, MySQL, MariaDB, PostgreSQL, and / or other
  • Experience designing, configuring and managing High Availability (HA) and Disaster Recovery (DR) database solutions
  • Experience in performance tuning, monitoring, backup and recovery
  • Extensive hands‑on experience with the following MS SQL Server database technologies : SSRS, SSIS, SSAS and T‑SQL
  • Knowledge of various types of file and data structures, understanding of concepts relating to Data Warehouses
  • Proficient in dimensional modeling, application design and development
  • Possess strong security practices with regards to authentication, authorization, compliance, and encryption
  • Experience managing database systems on physical, virtual and cloud environments
  • Experience with Windows and Linux operating systems
  • Familiarity with Azure or AWS services is a plus
  • Knowledge of scripting languages (e.g., Python, Shell scripting) for automation
  • Knowledge of SQL monitoring tools (e.g., Redgate SQL Monitor, SolarWinds, Oracle Enterprise Manager, dbWatch)
  • Good verbal and written communication skills (English)
  • Ability to work effectively under pressure and manage multiple, concurrent and conflicting priorities and deadlines
  • Ability to work both independently with minimal supervision and in a team environment
  • Willingness to learn and adapt in a fast pace, dynamic environment
  • Excellent customer service skills, with a clear understanding of customer impact and business requirement
  • Technical writing including documentation of procedures
  • Licenses and / or Professional Accreditation

  • Certificate in MS SQL database administration
  • Certificate in one or more additional database systems (e.g. Oracle, MongoDB, MySQL, MariaDB, PostgreSQL) – Preferred
  • MS Azure SQL certifications – Preferred
  • ITIL Foundation - Preferred
  • This is a regular, full-time position with a salary range of $73,600 - $92,000 per annum. The starting salary will be based on the successful candidate’s competencies, including but not limited to experience, education, professional designations and performance related to this role.

    About Us

    We value transparency in our hiring processes. Please note, artificial intelligence may be used in certain stages to screen, assess, or select applicants, however, a human reviewer makes all final decisions. This posting is for an existing vacancy.

    About The Team

    BGIS is a global leader in integrated facility management services. With a combined team of over 10,000 globally, BGIS relentlessly focuses on delivering innovative service solutions that create value for its clients. Globally, BGIS manages over 50,000 facilities totaling more than 600 million square feet across several markets including government, higher education, utilities, telecommunications, financial services, oil & gas, healthcare and cloud enterprise. In addition to managing a diverse portfolio of corporate offices, retail, colleges, hospitals and industrial assets, BGIS is a world leader in the management of data centers and other critical environments.

    At BGIS we believe that diversity and inclusion is a key business driver, such that we never lose sight of its importance as it is woven into the fabric of our organization. We are committed to maintaining a barrier‑free recruitment process by providing equal employment opportunities through recruiting and retention of individuals of all backgrounds. We recognize that promoting diversity is an essential component of our continuing pursuit for organizational success!

    BGIS is an equal opportunity employer, and we welcome you to apply for a position with us! If you require accommodation during the recruitment process, please contact us at askPC@bgis.com . Upon request for accommodation, we will consult with the applicant in question and provide, or arrange for the provision of, a suitable accommodation in a manner that takes into account the applicant's accessibility needs due to disability.

    #J-18808-Ljbffr

    Create a job alert for this search

    Database Administrator • Toronto, ON, CA

    Similar jobs
    Senior PostgreSQL DBA — High Availability & Performance

    Senior PostgreSQL DBA — High Availability & Performance

    Aarorn Technologies Inc • Markham
    Full-time
    A technology solutions provider is seeking a Senior PostgreSQL System Administrator in Markham, ON.The candidate will be responsible for managing large-scale PostgreSQL environments, optimizing dat...Show more
    Last updated: 20 days ago • Promoted
    Senior Systems Administrator : Impactful IT & Rapid Support

    Senior Systems Administrator : Impactful IT & Rapid Support

    Idealogical Systems • Markham
    Full-time
    WHEN WAS THE LAST TIME YOU ENDED YOUR WORKDAY WITH A SMILE?.You spend 80% of your life at work, and you should be doing what you love with people you enjoy working with, all while making a differen...Show more
    Last updated: 20 days ago • Promoted
    Sr. Clinical Data Team Lead - newmarket

    Sr. Clinical Data Team Lead - newmarket

    Connect Life Sciences • newmarket, on, ca
    Full-time
    Minimum of 5 years of experience as an independent lead, with an overall 10 years of CDM experience.The role involves independently managing the end-to-end delivery of data management services for ...Show more
    Last updated: 3 days ago • Promoted
    SAP Concur

    SAP Concur

    Yochana • markham, on, ca
    Full-time
    SAP Concur modules : Expense, Travel, and Invoice.Strong experience in SAP Concur configuration (Expense, Travel, Invoice). Expertise in integration with SAP ERP / S4HANA using middleware (SAP CPI, Del...Show more
    Last updated: 3 days ago • Promoted
    Database Analyst : Build & Secure Modern Data Systems

    Database Analyst : Build & Secure Modern Data Systems

    SRCO Professional Corporation • Richmond Hill
    Full-time
    A professional services company in Richmond Hill is looking for a candidate to manage databases and implement strategic plans. This role requires a Bachelor's degree and experience in database manag...Show more
    Last updated: 5 days ago • Promoted
    Cloud Network Administrator

    Cloud Network Administrator

    OpenText • Richmond Hill
    Full-time
    OpenText - The Information Company.OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture.As a member...Show more
    Last updated: 4 days ago • Promoted
    Administrator, Billing

    Administrator, Billing

    Aecon Group Inc. • Whitchurch-Stouffville
    Full-time
    Aecon is a Canadian leader in infrastructure development.We are safely and sustainably building what matters for future generations to thrive, with transformational projects in transportation and e...Show more
    Last updated: 5 days ago • Promoted
    DataBricks Architect

    DataBricks Architect

    Astellas • Markham, ON, Canada
    Full-time
    Do you want to be part of an inclusive team that works to develop innovative therapies for patients? Every day, we are driven to develop and deliver innovative and effective new medicines to patien...Show more
    Last updated: 30+ days ago
    Remote Temporary

    Remote Temporary

    ClaimsPro LP • Markham, On
    Remote
    Full-time +1
    Remote Temporary / Administrative Assistant- (Markham, ON Canada).This position is a Full-Time (2-Month) Temporary contract position, for an existing opportunity. In this role you will work with our...Show more
    Last updated: 18 hours ago • Promoted • New!
    DB2 LUW Reliability Engineer – SRE & Automation

    DB2 LUW Reliability Engineer – SRE & Automation

    IBM • Markham
    Full-time
    A global technology leader seeks a DB2 LUW Database Reliability Professional to design and operate resilient database systems. The ideal candidate will have 8+ years of experience managing DB2 LUW i...Show more
    Last updated: 5 days ago • Promoted
    Field Office Administrator : Highway & Bridge Projects

    Field Office Administrator : Highway & Bridge Projects

    GHD • Markham
    Full-time
    A leading engineering consultancy in Markham is looking for a Field Office Administrator to join their contract administration team on highway and road construction projects.The ideal candidate sho...Show more
    Last updated: 2 days ago • Promoted
    Tier I SOC Analyst - newmarket

    Tier I SOC Analyst - newmarket

    CyberClan • newmarket, on, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 7 days ago • Promoted
    Telecom Expense Management Analyst - System One

    Telecom Expense Management Analyst - System One

    System One • markham, on, ca
    Full-time
    Telecom Expense Management Analyst (Contract).Canada (9am – 5pm EST working hours).Global Technology / Enterprise IT.A large, multinational technology organization is seeking a.Telecom Expense Mana...Show more
    Last updated: 3 days ago • Promoted
    Data Administrator

    Data Administrator

    Thomas, Large & Singer Inc • Markham
    Full-time
    TLS) is currently seeking an energetic.Reporting to the Business Process Support Manager, the Data Administrator is responsible for accurate data entry, managing data extracts and imports, and perf...Show more
    Last updated: 2 days ago • Promoted
    Cloud Database DevOps Engineer - High-Performance & HA

    Cloud Database DevOps Engineer - High-Performance & HA

    Huawei Technologies Canada Co., Ltd. • Markham
    Full-time
    A leading tech company in Markham is looking for an individual to join their Cloud Native Data Engine team.The ideal candidate will build and set up development tools, develop automation test frame...Show more
    Last updated: 5 days ago • Promoted
    AS / 400 Admin

    AS / 400 Admin

    Astra North Infoteck Inc. • Richmond Hill, ON, ca
    Full-time
    Quick Apply
    Location : Richmond Hill, Ontario, Canada.On-site (5 Days a week, General shift & deployments hours).Robot Suites (Schedule, Console, Alert, Network etc), MIMIX configuration, Patrick Townsend s...Show more
    Last updated: 15 hours ago • New!
    Business Analyst- Secret Clearence Level 2 - VBeyond Corporation

    Business Analyst- Secret Clearence Level 2 - VBeyond Corporation

    VBeyond Corporation • markham, on, ca
    Full-time
    We are looking for a Business Analyst-.Canadian Security : Secret Clearance (Level II).The role involves working closely with business stakeholders, technical teams, and vendors to gather requiremen...Show more
    Last updated: 7 days ago • Promoted
    Data Analyst with Experience in Pharmaceutical - Sophus IT Solutions

    Data Analyst with Experience in Pharmaceutical - Sophus IT Solutions

    Sophus IT Solutions • richmond hill, on, ca
    Full-time
    Data Analyst with Experience in Pharmaceutical or Life Sciences Manufacturing.The Data Analyst is responsible for collecting, categorizing, and submitting data generated by Vision AI monitoring sys...Show more
    Last updated: 3 days ago • Promoted