Database Administrator

RRC; Richmond Hill; On-site; CAD 75,000 - 95,000; Full time

Job summary

RRC is seeking a Database Administrator – SQL Scripting & Data Processing Specialist to manage and optimize database systems. The ideal candidate will possess expertise in SQL scripting, data processing, and performance optimization. Join us to help push the boundaries of technology in the renewable energy sector, ensuring databases are efficient, secure, and scalable.

Benefits

Flexible work hours

Health, dental, and vision insurance

401k matching

Bonus eligibility

Tuition reimbursement

Qualifications

• Proven experience as a Database Administrator or similar role.
• Strong proficiency in SQL and experience with RDBMS.
• Experience with ETL tools and data integration workflows.

Responsibilities

• Manage and optimize database systems like SQL Server and PostgreSQL.
• Write, debug, and optimize SQL scripts.
• Develop and maintain ETL processes for data extraction.

Skills

SQL

Data Processing

Database Performance Optimization

ETL

Problem-solving

Scripting

Education

Bachelor’s degree in computer science

Tools

SQL Server

PostgreSQL

MySQL

Oracle

SSIS

Talend

Informatica

Job description

Job Details Job Location: Canada - Toronto - RRC International - Richmond Hill, ON Position Type: Full Time Salary Range: Undisclosed Description

Job Description

Database Administrator – SQL Scripting & Data Processing Specialist

RRC Companies is a leading provider of innovative software and integration solutions in the renewable energy sector. With a commitment to excellence and a passion for innovation, we are dedicated to pushing the boundaries of technology to deliver exceptional products to our clients. We are currently seeking a talented Database Administrator (DBA) – SQL Scripting & Data Processing Specialist to join our team.

We are seeking an experienced and detail-oriented Database Administrator to manage and optimize our database systems. The ideal candidate will have strong expertise in SQL scripting, data processing, and database performance optimization. You will play a critical role in ensuring our databases are efficient, secure, and scalable to meet business needs.

RRC CORE VALUES

Must understand and personify RRC’s core values:

• • Client Satisfaction – understands the goal of always exceeding our client’s expectations
  • Employee Happiness – able to work well with others, communicate clearly with coworkers, promote a positive work environment, and mediate conflicts between team members
  • Quality Work - able to take ownership, work independently, prioritize workload, and deliver quality results on time while working on multiple projects simultaneously
  • Above and Beyond - versatile, flexible, able to anticipate the needs of the company, take the initiative, and willing to go out of your way to assist others

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Database Management & Maintenance

• Design, implement, and maintain database systems (e.g., SQL Server, PostgreSQL, MySQL, Oracle).

• Monitor database health and ensure optimal performance, reliability, and security.

2. SQL Scripting

• Write, debug, and optimize SQL scripts, including complex queries, stored procedures, functions, and triggers.

• Automate database tasks and workflows using advanced SQL techniques.

3. Data Processing & ETL

• Develop and maintain ETL processes for data extraction, transformation, and loading.

• Ensure data accuracy, integrity, and consistency across systems.

4. Performance Optimization

• Analyze and optimize database schemas, indexing strategies, and query performance.

• Troubleshoot slow-running queries and resolve database bottlenecks.

5. Backup & Recovery

• Develop and implement robust backup and disaster recovery strategies.

• Perform database migrations and upgrades with minimal downtime.

6. Collaboration

• Work closely with application developers, data engineers, and analysts to ensure seamless integration of databases with other systems.

• Provide support for data-driven applications and reporting tools.

7. Documentation & Reporting

• Maintain clear and concise documentation for database systems, processes, and workflows.

• Generate reports and dashboards as required by stakeholders.

Requirements:

• Proven experience as a Database Administrator or similar role.
• Strong proficiency in SQL and experience with one or more RDBMS (SQL Server, PostgreSQL, MySQL, Oracle, etc.).
• Knowledge of database performance tuning and optimization techniques.
• Experience with ETL tools and data integration workflows (e.g., SSIS, Talend, Informatica).
• Strong analytical and problem-solving skills to debug and resolve complex database issues.
• Ability to understand and process large datasets efficiently.
• Familiarity with scripting languages such as Python, Shell, or PowerShell for task automation.
• Knowledge of BI and reporting tools like Power BI or Tableau is a plus.
• Experience with cloud database platforms (e.g., Amazon RDS, Azure SQL, Google Cloud BigQuery) is a plus.
• Understanding of NoSQL databases is a bonus.
• Excellent communication skills and the ability to work collaboratively with cross-functional teams.
• Detail-oriented with a focus on delivering high-quality results.
• Bachelor’s degree in computer science, Information Technology, or a related field.
• Relevant certifications are a plus:
• Microsoft Certified: Azure Database Administrator Associate
• Oracle Database Certification
• AWS Certified Database – Specialty

Salary Range: $75K + Depending on experience

BENEFITS

RRC is committed to investing in talented employees because we recognize that healthy, happy employees provide the best path to sustaining a successful business. RRC offers competitive salaries and benefits for full-time employees, including:

• Flexible work hours to accommodate work-life balance.
• Health, dental, and vision insurance
• 401k matching
• Bonus eligibility
• Tuition reimbursement for certain pre-approved education pursuits

RRC thanks you for your interest in joining RRC. Only candidates selected for an interview will be contacted.

Visit our website www.RRCcompanies.com for more information.

No recruiters or staffing firms please.

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Qualifications