SQL Database Administrator (DBA)

Accenture; Mississauga; On-site; CAD 83,152,000 - 152,010,000; Full time

Job summary

Accenture is seeking an experienced Database Administrator Specialist to manage multifunctional SQL Server databases and support development/test environments. You will install, configure, patch, back up, and tune performance while ensuring reliable 24/7 support and engineering collaboration across Canada and the US.

The role requires 2–3 years of SQL Server DBA experience, on-prem administration, and strong T-SQL development skills.

Qualifications

• 2–3 years SQL Server DBA experience in large-scale production environments.
• MS SQL Server Administration experience on-premise required.
• At least 2 years in SQL HA: Clustering, Availability Groups, Mirroring, Log Shipping.
• 2–3 years SQL programming and performance tuning experience.
• Experience with T-SQL scripts and development of views, stored procedures, UDFs.
• 2–3 years of Backup/Recovery experience.
• 2–3 years of shell scripting (Windows).
• Good experience building new system environments.
• Minimum 3 days/week in the office; location Montreal or Mississauga.
• Must be eligible for Reliability Clearance.
• English required for cross-Canada/US/global interactions.

Responsibilities

• Install, configure and patch SQL Server in clustered environments.
• Backup and restore databases.
• Performance tuning and optimization.
• Install DBMS and related tools; knowledge of operating systems.
• Provide input for procedures and documentation for problem resolution.
• Be on-call 24/7 for database support.
• Collaborate with teams and stakeholders across Canada and the US.

Skills

SQL Server DBA experience

MS SQL Server Administration

SQL HA Clustering

T-SQL development

Backup/Recovery

Shell scripting (Windows)

System environments

Office presence 3 days/week

Reliability Clearance eligibility

English communication

Tools

SQL Server

DBMS

Windows OS

Job description

We are:

The Advanced Technology Centers (ATCs) is the engine for reinvention in our clients’ transformation journey. Powered by more than 255,000* people across 24 countries, ATCs will provide our clients seamless access to industry insights and innovative technology solutions.

Stronger together!

The Advanced Technology Centers (ATCs) make tremendous impact in solving our clients’ business problems leveraging Innovation, Intelligence, Industry insights, new IT and new technology skills. Now, with the global environment changing at a faster pace, our clients are facing unprecedented challenges and they need us more than ever before. As a Network, ATCs are positioned to unlock greater opportunities and exponential value for our clients.

The value for our clients and our people

For our clients, the Network provides the strength of our geographic diversity, greater resilience, and seamless access to the deepest industry knowledge, the latest in Gen AI solutions, and tech expertise from around the world.

For our people, it brings an opportunity to shape truly boundaryless career paths in a highly collaborative team of experts where they can learn from each other and solve the world’s most complex client challenges.

You are

An experienced Database Administrator Specialist

The Work:

The Database Administrator (DBA) handles multifunctional database projects. You will administer development/ test databases. You will be primarily responsible for performing many related database functions across one or more teams. This may include: designing, implementing and maintaining new databases, backup/recovery and configuration management. You are able to install database management systems (DBMS); related software tools, and have working knowledge of operating systems. You should be also able to submit input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

Key Responsibilities:

• Installation, configuration and patching of SQL server in clustered environments.
• Backup and restore of the databases.
• Performance tuning and optimization.
• Install database management systems (DBMS); related software tools, and has a working knowledge of operating systems.
• Should be able for on-call 24/7 support of the databases.
• Able to submit input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

Here’s what you need:

• Must have 2 to 3 years overall SQL Server DBA experience supporting large-scale production systems, or equivalent.
• experience with MS SQL Server Administration for on-premise
• Atleast 2+ years SQL HA Clustering, Availability Groups, Mirroring, Log Shipping
• 2-3 years of experience with SQL programming and performance tuning
• Experience in writing T-SQL scripts and development of views, stored procedures, UDFs.
• 2-3 years of experience in Backup/Recovery
• 2-3 years of experience with shell scripting (Windows)
• Good experience building new system environments
• This role will require a minimum of 3 days per week in the office. Preferred location: as in the Local ATC office location: Montreal or Mississauga
• Must have eligibility for Reliability Clearance.
• English is required for this position as this role will regularly interact with stakeholders across Canada, US and other countries across our Global footprint where English is the common language. Due to the significant high volume of interactions with these English-speaking stakeholders, which is inherent to this position, it is not possible to reorganize the company’s activities to avoid this requirement.

Bonus Points if:

• Relevant DB certification
• Cloud experience (AWS, Oracle, Azure, Google)
• Experience with other DB platforms including open source and No-SQL DB (Oracle, SQL, DB2, Sybase, MYSQL, Postgres, MongoDB, etc.)

Compensation at Accenture varies depending on a wide array of factors, which may include but are not limited to the specific office location,
role, skill set, and level of experience. As required by local law, Accenture provides a reasonable range of compensation, based on full-time
employment, for roles that may be hired as set forth below.
The base pay range shown below is intended as a guideline to reflect the majority of offers for this role.
It does not represent a maximum limit — in some cases, actual compensation may exceed the range where appropriate.

Role Location Hourly Salary Range
British Columbia/Ontario/New Brunswick $29.01 to $53.05

About Accenture

Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent- and innovation-led company with approximately 791,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Song, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients reinvent and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities.

Equal Employment Opportunity Statement

We believe that no one should be discriminated against because of their differences.All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, military veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by applicable law.Our rich diversity makes us more innovative, more competitive, and more creative, which helps us better serve our clients and our communities.