ScotiaTech Bogota, D.C., Capital District, Colombia
Technical Analyst
Contributes to the overall success of the Integral Technology & Engineering Platform Services in Canada and globally ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures that all activities conducted are in compliance with governing regulations, internal policies and procedures.
Accountabilities
- Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
- Oversight of Vulnerabilities and Patching cadences for Infrastructure and Application servers.
- Collection and Analysis of Critical Application Assets remediation efforts.
- Analyzing Vulnerability and remediation data and creates reporting dashboards.
- Manage Vulnerability SQL Server Reporting databases.
- Configure and maintain Vulnerability Reporting database servers and processes.
- Monitor SQL Server Reporting database health and performance, ensuring high levels of performance,
availability, sustainability and security.
- Analyzing, solving and correcting SQL Server Reporting databases issues. Providing suggestions for solutions.
- Develop ETL process using MS SQL and SSIS, refining and automating regular processes, tracking issues, and documenting changes.
- Contribute to and be a part of a collaborative team environment.
- Review performance reports, assist with the weekly, monthly reporting and ensure timely resolution of issues.
Education / Experience
- Superior English written and verbal communications with good presentation skills and collaborative orientation skillset B2.
- Bachelor’s Degree in Computer Science, Information Technology or a related field.
- 1-3 years of experience in database administration or in a similar role.
- Experience in database backup, disaster recovery planning, performance optimization and data security.
- Ability to use a scripting la