Database / EDW Application Administrator - Tangerine **Requisition ID** : 232137 Tangerine is Canada’s leading direct bank. We offer flexible and accessible banking options, innovative products, and award-winning Client service. The reason why Tangerine employees come to work each day is to help Canadians live better lives. We focus on making a difference in our communities, and that includes our own internal community. It’s important to us that our employees feel empowered and enthusiastic about belonging to our Orange culture. Do you like new challenges? Are you ready to reach new heights in your career and become part of an established disruptor? If so, come join us and help redefine the Canadian banking landscape! **What you will be doing:** The Database / EDW Application Administrator is responsible for administration, maintenance, upgrade and data integrity of all development and test databases and all EDW Applications (including Adobe Experience Platform, GCP – BigQuery, SAS and Informatica), Design and document database architecture, Data Modeling, coordinating assigned internal and external team projects, supporting other team members in all phases of the development life cycle. The Database / EDW Application Administrator reports directly to the Team Lead, Tangerine Analytics Platform. **Is this role right for you? In this role, you will:** + Administration of all Banking system development databases and maintenance of all aspects of Tangerine Analytics Platform including but not limited to: Adobe Experience Platform, Google BigQuery, Informatica, SharePoint, SAS, Unica Campaign Suite and Tangerine Machine Learning. + Participate in and support analysis, design, testing, implementation and maintenance of enhancements to Tangerine Analytics Platform applications. + Implement corporate policy, develop, publish, enforce and maintain standards and procedures + Manage the Informatica environment and the granting of access to data; perform administrative functions + Participate in EDW scope discussions and comment on feasibility + Maintain EDW data model and metadata + Identify and document data access and usage requirements with access frequencies + Design and produce ETL coding specifications + Code, test and document ETL processes + Promote changes via established IT change control procedures + Proactively tune to improve performance + Plan, test and implement software upgrades; monitor alerts; administer licenses; interface with vendor + Troubleshoot problems; provide Informatica/SAS problem resolution assistance to IT staff + Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff + Investigate, identify and document source system data for extraction; design and implement confirmation processes for data loads + Monitor daily operation relative to SLA; log issues and ensure resolution + Evaluate new technologies and participate in the continuous improvement of applications and systems + Ensure 24x7 availability of Tangerine Analytics Platform applications + Ensure that administration guidelines are met and enhance guidelines as required **Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:** + University or College Degree or equivalent experience + 5+ years IT experience + 2+ years administering an Adobe Experience Platform environment + 2+ years of experience in a database, data warehouse or enterprise application administration role strongly recommended + Banking industry experience preferable + Competent in enterprise application delivery and design techniques + Competent in: + Informatica administration + Google Cloud Administration + Unica tools – Campaign, Interact and Acoustic + Oracle Administration + SAS software applications administration + Design patterns + AIX, Linux, Windows Server + Releases/version control + Very good working knowledge of database technology, preferably Big Query / SQL Server / Oracle, and the SQL language + Very good knowledge of data modeling in a data warehousing context + Excellent documentation skills + Excellent troubleshooting and problem-solving skills + Ability to multi-task and work at a detailed level in a fast-paced environment + Availability to provide off-hours support for critical systems on a scheduled basis **What's in it for you?** + You will be part of a diverse and inclusive team of Client-focused go-getters looking to learn from each other in an environment that celebrates and recognizes success! + You will have access to thousands of online and in-person courses so you can shape your career growth with support from diverse industry leaders. + You will get our help to save for your future and to invest in your total well-being through our Tangerine benefits. + You belong here, and we are equal and uncomplicated. Bring your true self to work, dress codes don’t apply here. + You will enjoy workspace flexibility and all the excitement that comes from working at the official Bank of the Toronto Raptors. Location(s): Canada : Ontario : Toronto At Tangerine we value the unique skills and experiences each individual brings to the team, and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process, please let our Recruitment team know.