Senior Database Administrator-FT-Downsview

Serco; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

Serco Canada Inc. is seeking an experienced Database Administrator to lead the design, maintenance, and security of mission-critical databases across on-premises and Azure cloud environments.

The role focuses on availability, performance, and data integrity, with leadership of programming staff to enforce best practices. The position requires hands-on experience with MS SQL Server 2019+, Oracle 19c+, ETL development (SSIS), and strong collaboration with data analysts and IT professionals to

Qualifications

• Bachelor's degree in computer science or related field.
• 7+ years MS SQL Server/Oracle Database Administrator experience.
• Strong knowledge of MS SQL Server 2019+ and Oracle 19c+.
• Experience with database migrations, security, and high availability.

Responsibilities

• Design and implement scalable database solutions.
• Install, configure, and maintain critical database environments.
• Establish robust monitoring for proactive issue detection.
• Enforce security policies and access controls, including encryption and masking.
• Develop and optimize ETL processes (SSIS).
• Collaborate with analysts, DBAs, and IT staff to ensure data quality and availability.

Skills

MS SQL Server

Oracle DB

ETL/SSIS

PL/SQL

Data security

Azure Cloud

Linux/Windows

Education

Bachelor's in Computer Science

Tools

SSMS

Oracle RMAN

Azure Data Factory

ETL Tools

Linux

Windows Server

Job description

Position Description & Qualifications

Provide technical direction for database design, maintenance, and administration. Evaluate and recommend available DBMS products after matching user requirements with system capabilities. Develops and formulates standards, procedures, and conventions for database use. Leads technical/programming staff to ensure database security from accidental or intentional loss or damage. Determines file organization, indexing methods and security procedures for specific user applications. Role will involve supporting mission-critical databases on a robust, highly available system, playing a pivotal role in ensuring the availability, performance, and security of diverse database infrastructure both on-prem and Microsoft Azure Cloud environment on RedHat Linux and Windows Servers. Also, will be responsible for designing, developing, and implementing ETL processes to support data integration and data warehousing solutions. This role involves working closely with data analysts, database administrators, and other IT professionals to ensure data quality, integrity, and accessibility.

Position Description & Qualifications

Provide technical direction for database design, maintenance, and administration. Evaluate and recommend available DBMS products after matching user requirements with system capabilities. Develops and formulates standards, procedures, and conventions for database use. Leads technical/programming staff to ensure database security from accidental or intentional loss or damage. Determines file organization, indexing methods and security procedures for specific user applications. Role will involve supporting mission-critical databases on a robust, highly available system, playing a pivotal role in ensuring the availability, performance, and security of diverse database infrastructure both on-prem and Microsoft Azure Cloud environment on RedHat Linux and Windows Servers. Also, will be responsible for designing, developing, and implementing ETL processes to support data integration and data warehousing solutions. This role involves working closely with data analysts, database administrators, and other IT professionals to ensure data quality, integrity, and accessibility.

Primary Duties And Responsibilities

• Work collaboratively with development teams to design and implement effective, scalable database solutions.
• Handle the installation, configuration, and maintenance of critical database environments, guaranteeing optimal performance and security.
• Establish robust monitoring systems to detect issues proactively and respond promptly.
• Implement and enforce security policies and access controls, utilizing encryption and data masking techniques to protect sensitive data.
• Set up proactive monitoring systems for early issue detection and respond to alerts with thorough root cause analysis.
• Dedicate efforts to maintaining high availability within the database environment.
• Keep the database infrastructure current with the latest patches and updates while strictly adhering to security policies.
• Utilize strong SQL, T-SQL, and PL/SQL programming skills to contribute to the support and optimization of stored procedures, triggers, and functions.
• Design, develop, and implement ETL processes using ETL tools (SSIS). Create mappings, workflows, and sessions to extract, transform, and load data.
• Develop scripts for data extraction, transformation, and loading.
• Optimize ETL processes for maximum efficiency and performance.
• Collaborate effectively with cross-functional teams, offering technical expertise and support.
• Maintain flexibility and openness to learning and adapting to newer database environments as organizational needs evolve.
• Communicate clearly and effectively with stakeholders regarding database-related matters, fostering transparency and understanding through verbal and written documentation.
• Possess familiarity with the administration of MySQL, Postgres DB .
• Willingness to learn other new database products would be considered an additional asset.
• Participates in team-based projects, many of which may be matrix managed; must be accustomed to completing deliverables within time and budgetary constraints.
• Manage multiple parallel projects, meeting designated deadlines and milestones.

Qualifications

• Bachelor's Degree in computer science or related fields
• Minimum of 7 Years as MS SQL Server /Oracle Database Administrator
• Good hands-on MS SQL Server Version 2019 onwards and Oracle Database 19c onwards.
• Experience with MS SQL Database Architecture, MS SQL Database Upgrade, Database migration and Data cloning methods.
• Responsibilities include designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes).
• Perform capacity planning, SQL analysis, schema revisions, security administration and user account maintenance.
• Immediate participation in an active on call rotation required.
• Candidate must be capable of providing off hours support to avoid impacting database availability during normal business hours.
• Excellent interpersonal, comm and presentation skills, and be a team player.
• Takes initiative to complete critical tasks, and overcome obstacles in a proactive manner.
• Works well in a growing, fast-paced, entrepreneurial environment
• Keeps informed on the latest technological approaches and trends in the technical field.
• Brings a work ethic that inspires your fellow team members to deliver their best.

Company Overview

Serco Canada Inc. strives to make an impact every day across 100+ sites in the areas of Defense, Citizen Services, and Transportation. We help our clients deliver vital services more efficiently while increasing the satisfaction of their end customers. Serco serves the Canadian Federal and Provincial governments and commercial clients. While your place may look a little different depending on your role, we know you will find yours here. Wherever you work and whatever you do, we invite you to discover your place in our world. Serco is a place you can count on and where you can make an impact because every contribution matters.

Pay Transparency

Our Total Rewards package includes competitive pay, performance-based incentives, and benefits that promote well-being and work-life balance, so you can thrive both professionally and personally. Program availability may vary based on factors such as contract type, location, hire date, and applicable collective bargaining agreements.

Salary range: The range for this position can be found at the top of the posting. This range is provided as a general guideline and represents a good faith estimate across all experience levels. Actual base salary will be determined by a variety of factors, including but not limited to, the scope of the role, relevant experience, job-related knowledge, education and training, key skills, and geographic market considerations. For roles available in multiple provinces, the range may vary to reflect differences in local labor markets. In addition to base salary, eligible positions may include other forms of compensation such as annual bonuses or long-term incentive opportunities.

To review all Serco benefits please visit: https://careers.serco-na.com/us/en/about-us.

Serco complies with all applicable federal, provincial, and local leave laws This is a Canada-based role and this position is for an existing vacancy, unless stated otherwise in the job description.