Product Support Analyst - Database and ETL
Product Support Analyst – Database and ETL
Location: Canada, ideally greater Vancouver area
Copperleaf provides enterprise decision analytics software to companies managing the critical infrastructure we all rely on every day. We help the world’s leading organizations decide where and when to invest in their businesses to manage risk, contribute to ESG strategies, deliver against performance expectations, and maximize value for every dollar spent. Join our team as we empower our clients to make the best strategic decisions through our innovative, award-winning solutions.
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
Compensation:
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, we’re committed to building a great culture because we know it’s what sets us apart. Culture is at the very core of everything we do, and it’s what makes people want to be part of the market-leading company we’re building. We are a global team of world-class innovators continually pushing the limits of what’s possible to deliver exceptional value and extraordinary experiences to our clients. To do that, we actively cultivate an open and supportive team environment, where diverse ideas and perspectives are encouraged and respected.
Headquartered in Vancouver, Canada, Copperleaf is building a better world, one decision at a time. As one of the Americas’ Fastest-Growing Companies, Canada’s Most Admired Corporate Cultures, and winner of BC Tech Association’s Tech Culture of the Year, we are a dynamic 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.
Apply for this job
*
indicates a required field