Talent.com
Database Administrator
Database AdministratorBGIS • Markham, ON, Canada
Database Administrator

Database Administrator

BGIS • Markham, ON, Canada
2 days ago
Job type
  • Full-time
Job description

SUMMARY

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 (., Python, Shell scripting) for automation
  • Knowledge of SQL monitoring tools (., 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 (. 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.

    #LI-Hybrid

    Create a job alert for this search

    Database Administrator • Markham, ON, Canada

    Similar jobs
    Senior SAP Basis Administrator — Private Cloud & S / 4HANA Expert

    Senior SAP Basis Administrator — Private Cloud & S / 4HANA Expert

    Capgemini • Toronto C6A, ON, Canada
    Full-time
    A global technology consulting firm in Toronto is seeking a skilled SAP Basis Administrator to manage and support SAP systems in a cloud environment. This role entails overseeing SAP S4 HANA and oth...Show more
    Last updated: 1 day ago • Promoted
    Senior Database Administrator

    Senior Database Administrator

    CAA South Central Ontario • Markham
    Full-time
    Company : CAA SCO Systems & Services Inc.Position Type : Existing position.At CAA Club Group, we are passionate about keeping our Members safe—whether they are on the road, at home, or traveling abro...Show more
    Last updated: 4 days ago • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    Tekshapers • Toronto
    Full-time
    Sr Client Management and Delivery Manager at Tekshapers.Minimum 8 years of DBA working experience building, deploying and administering. Undergrad Degree or Diploma in Computer Science.Responsible f...Show more
    Last updated: 3 days ago • Promoted
    HANA Database Administrator Senior - Canada

    HANA Database Administrator Senior - Canada

    SAP • Toronto
    Full-time +1
    HANA Database Administrator Senior - Canada.HANA Database Administrator Senior - Canada.HANA Database Administrator Senior - Canada. Be among the first 25 applicants.HANA Database Administrator Seni...Show more
    Last updated: 15 days ago • Promoted
    Sr. Database Administrator - Oracle

    Sr. Database Administrator - Oracle

    Canadian Imperial Bank of Commerce • Toronto
    Full-time
    We’re building a relationship-oriented bank for the modern world.We need talented, passionate professionals who are dedicated to doing what’s right for our clients. At CIBC, we embrace your strength...Show more
    Last updated: 7 days ago • Promoted
    PostgreSQL Senior Database Administrator (DBA)

    PostgreSQL Senior Database Administrator (DBA)

    National African-American Insurance Association (NAAIA) • Toronto
    Full-time
    Marsh McLennan's Database Services team is growing rapidly, and we have an exciting opportunity for a creative and inquisitive Senior Database Administrator skilled in Postgres and Oracle.This hybr...Show more
    Last updated: 3 days ago • Promoted
    Senior Database Engineer

    Senior Database Engineer

    G Adventures • Toronto
    Full-time
    G Adventures is the world’s largest small-group adventure travel company and we’ve been making epic travel memories happen on all seven continents for over 30 years. Our mission is simple : to change...Show more
    Last updated: 30+ days ago • Promoted
    Senior Oracle E-Business Suite DBA – Onsite Downtown Toronto

    Senior Oracle E-Business Suite DBA – Onsite Downtown Toronto

    Nexus Systems Group Inc. • Toronto
    Full-time
    A technology solutions company in Toronto is seeking a Senior Database Administrator.The role involves expertise in Oracle E-Business Suite installation and migration to cloud infrastructure.Respon...Show more
    Last updated: 3 days ago • Promoted
    Database Administrator

    Database Administrator

    Sunwing • Toronto
    Full-time
    Sunwing Vacations Group is home to North America’s largest vacation brands, comprised of the leading Canadian leisure tour operators Sunwing Vacations and WestJet Vacations, along with the growing ...Show more
    Last updated: 15 days ago • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    Insight Global • Toronto
    Full-time +1
    This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Direct message the job poster from Insight Global.Regio...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator

    Database Administrator

    Largeton Group • Toronto
    Full-time +1
    Our client is seeking a Database Administrator (DBA) for a short‑term contract to support ongoing data and reporting initiatives. The ideal candidate will have strong SQL skills, experience managing...Show more
    Last updated: 30+ days ago • Promoted
    Database Administrator (DBA) – Specialist (Oracle GoldenGate / SQL Azure)

    Database Administrator (DBA) – Specialist (Oracle GoldenGate / SQL Azure)

    Apex Systems • Toronto
    Full-time +1
    Hybrid – in-office every Tuesday.FTE based on performance and budget).We are looking for a Database Administrator Specialist with expertise in Oracle GoldenGate and SQL Azure, and experience suppor...Show more
    Last updated: 30+ days ago • Promoted
    PostgreSQL Senior Database Administrator (DBA)

    PostgreSQL Senior Database Administrator (DBA)

    Marsh • Toronto
    Full-time
    PostgreSQL Senior Database Administrator (DBA).Marsh McLennan’s Database Services team is growing rapidly, and we have an exciting opportunity for a creative and inquisitive Senior Database Adminis...Show more
    Last updated: 3 days ago • Promoted
    Oracle Database Administrator - Hays

    Oracle Database Administrator - Hays

    Hays • north york, on, ca
    Full-time
    Job Posting Title : APPLICATION DEVELOPER.Contract length : - 8 months (Possible Extension).Location : North York (2 – 3 days Hybrid (3389, Steeles Avenue East, North York, ON)).Install, configure, an...Show more
    Last updated: 3 days ago • Promoted
    Database Administrator

    Database Administrator

    J&M Group • Toronto
    Full-time
    Location : Mississauga, Ontario, Canada.Seniority Level : Mid-Senior level.Industry : IT Services and IT Consulting.Experience with Solr and MS SQL for large-scale applications and eCommerce platforms...Show more
    Last updated: 30+ days ago • Promoted
    Senior System Administrator — Cloud & Database Infra Lead

    Senior System Administrator — Cloud & Database Infra Lead

    SGGG Fund Services Inc. • Toronto
    Full-time
    A leading fund administration firm in Toronto is seeking a Sr.System Administrator to develop and maintain our IT infrastructure, focusing on Microsoft and Azure environments.The ideal candidate wi...Show more
    Last updated: 10 days ago • Promoted
    Oracle Database Administrator

    Oracle Database Administrator

    Hays • north york, on, ca
    Full-time
    Job Posting Title : APPLICATION DEVELOPER.Contract length : - 8 months (Possible Extension).Location : North York (2 – 3 days Hybrid (3389, Steeles Avenue East, North York, ON)).Install, configure, an...Show more
    Last updated: 3 days ago • Promoted
    Database Administrator

    Database Administrator

    Livingston International • Toronto
    Full-time
    Join Livingston and grow your career in the constantly changing world of international trade.Livingston is a market leader offering customs brokerage, international trade consulting, compliance and...Show more
    Last updated: 15 days ago • Promoted