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

Database Administrator

BGIS • Markham, ON, Canada
Il y a 1 jour
Type de contrat
  • Temps plein
Description de poste

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

    Créer une alerte emploi pour cette recherche

    Database Administrator • Markham, ON, Canada

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

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

    Capgemini • Toronto C6A, ON, Canada
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 15 heures • Offre sponsorisée • Nouvelle offre
    Senior Database Administrator

    Senior Database Administrator

    CAA South Central Ontario • Markham
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 4 jours • Offre sponsorisée
    Oracle Database Administrator

    Oracle Database Administrator

    Tekshapers • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Senior Database Lead : Raiser's Edge & Grants Management

    Senior Database Lead : Raiser's Edge & Grants Management

    Children's Aid Foundation of Canada • Toronto C6A, ON, Canada
    Télétravail
    Temps plein
    A charitable organization in Toronto is seeking a Senior Manager, Database to oversee data management, integrity, and reporting for fundraising efforts. The role requires strong leadership in managi...Voir plus
    Dernière mise à jour : il y a 1 jour • Offre sponsorisée
    HANA Database Administrator Senior - Canada

    HANA Database Administrator Senior - Canada

    SAP • Toronto
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Sr. Database Administrator - Oracle

    Sr. Database Administrator - Oracle

    Canadian Imperial Bank of Commerce • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 6 jours • Offre sponsorisée
    Database and Solution Architect

    Database and Solution Architect

    freelance.ca • Toronto, Canada
    Temps plein
    Database and Solution Architect .Key information / Informations clés.Région : Toronto, ON (downtown).Type de poste : Contrat (6 mois, renouvelable). Mode de travail : Hybride ou Remote.Industrie : I...Voir plus
    Dernière mise à jour : il y a 29 jours • Offre sponsorisée
    PostgreSQL Senior Database Administrator (DBA)

    PostgreSQL Senior Database Administrator (DBA)

    National African-American Insurance Association (NAAIA) • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Senior SQL Database Administrator (Sr. SQL DBA)

    Senior SQL Database Administrator (Sr. SQL DBA)

    freelance.ca • Toronto, Canada
    Temps plein
    Our client, a leading provider in the technology sector, is seeking a Senior SQL Database Administrator (Sr.SQL DBA, you will be part of the Platform Shared Services supporting cross-functional tea...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    Sunwing • Toronto
    Temps plein
    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 ...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Oracle Database Administrator

    Oracle Database Administrator

    Insight Global • Toronto
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    Largeton Group • Toronto
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Database Administrator (DBA) – Specialist (Oracle GoldenGate / SQL Azure)

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

    Apex Systems • Toronto
    Temps plein +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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Oracle Database Administrator

    Oracle Database Administrator

    Hays • toronto, on, ca
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Oracle Database Administrator - Hays

    Oracle Database Administrator - Hays

    Hays • north york, on, ca
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 2 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    J&M Group • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
    Senior System Administrator — Cloud & Database Infra Lead

    Senior System Administrator — Cloud & Database Infra Lead

    SGGG Fund Services Inc. • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 9 jours • Offre sponsorisée
    Database Administrator

    Database Administrator

    Livingston International • Toronto
    Temps plein
    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...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée