Microsoft SQL Server DBA

CGI-experience the commitment

     View a printer-friendly version of this page 
Category: Database Administration
City: Halifax, Nova Scotia, Canada
Position ID: J0617-0744
Employment Type: Full Time

jobimage

Meet our professionals

CGI: An employer of choice


Position Description:

At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 68,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members.

This is a great opportunity to join a winning team within CGI’s Atlantic Business Unit. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

CGI’s continuous growth is a testament to the confidence clients place in them and to the dedication of their professionals.

We are looking for great people who want to:

• Be challenged technically
• Go to the next level in their career
• Join a team of elite professionals
• Work with our client in a fast-paced, highly technical and demanding environment
• Grow and be recognized for excellence and innovation

In addition to technical excellence we are looking for candidates with strong and confident communication skills. You must be able to articulate a complex technical solution to a range of audience members in a clear and concise manner; the candidate needs to be comfortable working closely with the client and being part of a highly skilled technical solutions team. We're expanding in Atlantic Canada and we need your skills, enthusiasm, and dedication as part of our team.

You will be providing your technical expertise to the team to ensure all database environments are being cost effectively operated and managed by providing strong technical leadership in database planning, design, administration, development and operation activities. The Database Administrator is responsible for supporting and enhancing the production and testing banking database environments, monitoring of systems health and performance, fulfillment of routine SQL system maintenance/administration activities and special projects.

Your future duties and responsibilities:

• Providing Microsoft SQL Server database support, including administration, configuration,
installation, monitoring, maintenance and upgrade of databases in SQL2008, SQL2102 and
SQL2016 environments.
• Ensure appropriate database maintenance activities are scheduled and completed (e.g. re-
indexing, purging, rebuilds, stats gathering, etc.) using appropriate script and scheduling
tools
• Monitor and tune SQL Server database performance.
• Investigate, troubleshoot, and resolve query and database performance issues
• Improving database performance and capacity
• Prepare database growth projections and plan for storage capacity needs
• Administer the data integrity of all databases by controlling and coordinating all changes,
updates and deletes to the database configurations
• Work with technical and development teams to implement optimum physical database
design architecture
• Ensure all databases are backed up according to business backup strategy and in a way that
meets the business's recovery objectives
• Test backups to ensure we can meet the business recovery time objectives
• Troubleshoot SQL Server service outages as they occur, including after-hours and during the
weekends. Track and resolve database related incidents and alerts within defined service
levels by following incident management procedures
• Participate in change management processes including deploying database changes in all
environments as requested, following change management standards and procedures
• Prepare recovery processes and rehearse disaster recovery plans
• Develop and maintain database standards, processes and procedures including support
documentation
• Implement security policies as set out by corporate standards

Required qualifications to be successful in this role:

• Minimum 5 years of database administration experience in Microsoft SQL
• Experience with IBM Informix RDBMS would be considered a strong complementary asset
• Excellent written and verbal communication skills
• Ability to work closely with the Development and technical team members
• Excellent problem solving and troubleshooting skills
• Ability to recommend different solutions depending on the requirements for the database
• Ability to work with minimal direction.

What you can expect from us:

At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 68,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.

This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.

We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted.

No unsolicited agency referrals please.

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.


Skills:

  • Data Architecture
  • Database Administration
  • Database Design
  • Database Tuning
  • Server Setup/Config
  • SQL
  • System Administration
  • Windows
  • Credit Unions

     View a printer-friendly version of this page