Senior Database Performance Tuner

Canada-That’s CGI

Seeking a contractor for a three (3) month contract

Starting approximately June 1, 2023

Due to the short contract time MUST hold Enhanced Clearance Required

Remote Worker Accepted – Yes – Located in Canada

• You will audit and make recommendations and improvements on current environments, including all operational aspects of a client environment from application, infrastructure, network, and security. The solution is in the final phases of development so recommendations should be made in that context.
• Collaborate with development teams to review and optimize SQL queries, stored procedures, and database design to improve performance and scalability.
• Apply various monitoring and profiling tools to diagnose and resolve performance issues, such as AWS CloudWatch, Amazon RDS Performance Insights, and PostgreSQL EXPLAIN.
• Work closely with project managers, solution architects and team members to ensure SRE projects are delivered accurately and within timeline & budget for clients.
• Support regular performance tests, load testing, and benchmarking to assess the impact of system changes and optimizations.
• Experience with a number of database platforms (Oracle, MSSQL, PostgreSQL, AWS Aurora)
• Update standard operating procedures to reflect updates in our best practices as part of our dedication to continual service improvement

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
• Shown experience as a Performance Engineer, Database Engineer, or similar role with a focus on AWS RDS PostgreSQL Database and SQL Tuning.
• Proven ability to work creatively and analytically in a problem-solving environment
• Excellent communication and collaboration skills to work effectively with cross-functional teams.

Desired Qualifications

• Proficient with relational Rational Database Management System (RDBMS) and NoSQL concepts.
• Hands-on experience with AWS RDS PostgreSQL, including configuration, monitoring, and performance tuning.
• Proficiency in database performance profiling and diagnostic tools, such as pg_stat_statements, EXPLAIN, and performance monitoring tools.
• Solid understanding of database internals, query execution plans, and indexing strategies.
• Knowledge of AWS Cloud services and standard methodologies, particularly related to RDS and EC2.
• AWS Certified Database – Specialty or related certifications.
• Experience with other database technologies, such as MySQL, Oracle, or NoSQL databases.
Cloud Technologies (e.g. Azure, AWS, Google Cloud Platform, RedHat, OpenStack)
• Familiarity with containerization technologies (e.g., Docker, Kubernetes) and their impact on database performance.

#LI-LF

• Database Administration
• English
• SQL

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.