Product Support Analyst - Database and ETL
Copperleaf Technologies
Product Support Analyst – Database and ETL
Location: Canada, ideally greater Vancouver area
Copperleaf’s enterprise software helps some of the world’s largest firms make better strategic decisions. We have a track record of delivering award-winning, industry-changing solutions that enable our clients to operationalize their ESG and sustainability strategies. Our solutions empower them to build optimal investment plans that proactively manage risk, improve performance, and maximize value for every dollar spent. Join our team as we continue to enable our clients to build more resilient and sustainable infrastructure.
The opportunity:
We are seeking an experienced Oracle Database and ETL Product Support Analyst to join our Cloud Operations team. As an integral part of our team, you will collaborate with the Support, SRE, and Product Development teams to ensure the smooth operation of our Oracle databases and ETL applications. This role requires a strong understanding of Oracle databases, AWS RDS, ETL processes, and the ability to troubleshoot and resolve issues. The successful candidate will have excellent communication skills and the ability to work in a fast-paced, dynamic environment.
Key responsibilities:
- Provide support to multiple teams by troubleshooting and resolving Oracle-related application issues, including long-running and frequently running SQL queries, failures in our reporting ETL application (Reporting Data Source or RDS), and issues with client-managed on-premises Oracle databases
- Assist cloud operations team in managing their fleet of Oracle databases, including AWS RDS instances, by conducting performance analysis and tuning, creating procedures, consulting on tools, procedures, and best practices, and resolving database-related problems
- Advise software development team on industry common and best practices regarding Oracle security and administration, database design for scalability and performance, query performance optimization, and internationalization
- Develop SQL queries and repair/migration scripts as needed
- Gain a deep understanding of functional aspects of our software suite and how they support our clients' business processes
Your background:
- Minimum 5 years of experience administering Oracle databases, particularly Standard Edition
- Experience supporting AWS RDS
- 2+ years of experience working with ETL applications
- Familiarity with data warehouses, specifically Kimball-methodology design ("star schema")
- Exposure to complex enterprise software application support
- Strong understanding of IT concepts and principles, with ability to interact effectively with clients' IT and DBA teams
- Experience working with software development teams, with solid understanding of release cycles
- Willingness to occasionally be on-call during Canadian holidays and weekends
In addition to the above, the ideal candidate will possess the following skills and experience:
- Proven experience in Oracle Database support and administration, including installation, configuration, performance tuning, backup and recovery, and security management
- Familiarity with AWS RDS and experience in provisioning, monitoring, and maintaining Oracle RDS instances
- Strong understanding of ETL processes, including data extraction, transformation, and loading
- Proficiency in SQL and scripting languages for developing queries, repair/migration scripts, and automation tasks
- Ability to understand functional aspects of our software suite and how they support our clients' business processes
Salary:
The typical hiring range for this position is from $85,000 CAD to $110,000 CAD annually. The salary offered is based on market location and may vary depending on skills, experience, and internal equity. We offer a comprehensive benefits package and perks as a part of our compensation package.
We encourage all qualified applicants to apply, regardless of their current salary expectations.
About you:
- Detail-Oriented: You have an eye for detail and can identify trends and commonalities across a large number of events
- Great Communicator: You enjoy capturing processes in documentation and can create internal documentation such as accurate, concise bug reports, and reference material
- Flexible: As part of a small but rapidly growing team in an international company, you are open to working flexible hours as needed to support our 24/7 infrastructure
- Problem Solver: You have strong fundamentals in troubleshooting and are able to identify root causes and find workarounds for various issues
- Curious and Passionate: You have passion, enthusiasm, and transferable skills, as we recognize that talent comes in many forms, not only with specific qualifications
- Service Driven: You understand the importance of service tickets and their tracking issues and solutions; you maintain meticulous documentation, ensuring all relevant information is captured accurately for future reference allowing for efficient problem-solving and overall improvements to our service quality
What’s it like here?
At Copperleaf, culture is at the very core of who we are and what we do. We’re a world-class team of innovators that inspire one another to learn and continually push the limits of what’s possible. We cultivate an atmosphere of openness and support where all opinions and ideas are valued and encouraged, and where teamwork is key to success. We value a diverse environment and are proud to be an equal opportunity employer.
Founded in Vancouver, Canada, Copperleaf is committed to building a better world, one decision at a time. As one of Canada’s Fastest-Growing Companies and winner of Canada’s Most Admired Corporate Cultures, we are a dynamic and disruptive organization offering exciting opportunities for growth and innovation.
Diversity, Equity, and Inclusion are at the heart of Copperleaf’s culture and play a vital role in our growth strategy. We are committed to ensuring that everyone feels a sense of belonging and can contribute to their maximum potential. Our differences are the reason great things happen here. If you are an applicant in need of accommodations or special assistance throughout the interview process, please submit a request by email to exsupport@copperleaf.com.