ScotiaTech Bogota, D.C., Capital District, Colombia Technical Analyst Contributes to the overall success of the Global 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 language (like Python or Peri) to automate database administration tasks. Advanced Excel Skills, PowerPoint and Power BI. Advanced ability to analyze data and assess vulnerabilities in infrastructure (software, hardware, networks). Highly familiar with Network and Operational System version and protocols (all O/S) Technical Background. Highly familiar with or experienced in Vulnerability Management/Cybersecurity & Server compliance. Experience in Vulnerability Management Tool sets (Tenable) equating to a strong working knowledge of information security principles and security operations. Strong ServiceNow knowledge (ticketing tools). Exacting in following procedural documents. Experience with SQL. Working Conditions Work in a standard office-based environment; non-standard hours are a common occurrence. You would be a part of a vibrant, dynamic, decisive, top performing cohesive and respected team. Learning and using skills that will take you anywhere with confidence. Your efforts would be realized by top levels at BNS as part of the contribution arm to upstream reporting mechanisms. You will not be left in a box. You’d be part of a team that drives and motivates each other to exceed expectations. A rewarding and self-satisfying role. You'll be proud to work with us. Seniority level Not Applicable Employment type Full-time Job function Information Technology Industries Banking Referrals increase your chances of interviewing at ScotiaTech by 2x #J-18808-Ljbffr