SQL Database Administrator

Category: Database Administration
Main location: Canada, Ontario, Toronto
Position ID: J0822-0465
Employment Type: Full Time

Position Description:

SQL DBA
DB2 nice to have

"SQL Server DBA duties and responsibilities
We are looking for a Logical/T2 database administrator, with programming experience
• Manage SQL Server databases
• Configure and maintain database servers and processes
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Provide 24x7 support for critical production systems
• Perform scheduled maintenance and support release deployment activities after hours
SQL Server DBA requirements and qualifications
• X years of experience as a SQL Server DBA or similar role
• X years of experience with MY SQL Server Administration experience required
• X years of experience with Performance Tuning and Optimization (PTO)
• X years of experience with backups, restores and recovery models
• X years of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• X years of experience with Windows server, including Active Directory
• Sense of ownership and pride in your performance and its impact on company’s success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills
• MCTS, MCITP, and/or MVP certifications a plus
DB2 DBA duties and responsibilities
• Offer DBA DB2 support for application development team.
• Ensure integrity, availability and performance of DB2 database systems by providing technical support and maintenance.
• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management and data maintenance activities for database system.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on daily and weekly basis.
• Develop and maintain patches for database environments.
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security and disaster recovery procedures.
• Perform troubleshooting and maintenance of multiple databases.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing locks and failed updates.
• Oversee utilization of data and log files.
• Manage database logins and permissions for users.
• Provide 24x7 support for critical production systems"

Skills:

  • Database
  • DB2
  • Financial Services
  • Insurance
  • SQL

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees "members" because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.