Technical Analyst, Database

Overview

Reporting to the IT Manager – Technical and Client Services, the Technical Analyst is responsible for the effective provisioning, installation, configuration, operation, security, access control, support, and maintenance of related systems hardware, software, and related infrastructure. Accountabilities of this position includes the administration and support of specific systems, environments, and infrastructure; and supporting departmental and organization projects with their IT infrastructure and technology needs.

Working closely with the appropriate application, business, and departmental leads, the Technical Analyst will ensure that the systems and IT infrastructure are reliable, secure, compliant with best practices and regulatory requirements, and optimized for performance.

Primary Responsibilities

1. IT Infrastructure and Systems Management

- Possess strong analytical and problem-solving skills with proficient, hands-on experience in the effective deployment, administration, and support of the organization's IT infrastructure and systems.

- Ensure system high-availability, optimal performance, and scalability to meet business requirements with proactive monitoring, maintenance, and capacity planning. Takes initiative in issue resolution; seek efficiencies and improvements in systems andprocesses.

- Experience implementing and managing security measures to safeguard systems – including user account management and permissions; applying system patches, updates, and security configurations; etc. Follow, maintain, and improve compliance with best practices and industry standards. Collaborate with security team to conduct vulnerability assessments and remediate security gaps.

- Support in the development, implementation, monitoring, maintenance, and testing of disaster recovery plans and backup & recovery solutions. Ensure recovery point and recovery time objectives are met.

- Implement and support system and infrastructure upgrades, migrations, and improvements in line with organizational needs.

- Follow and maintain ITbest practices, standards, and regulatory requirements (including PHIPA, PIPEDA, etc.); ensuring consistency across all IT systems, processes, and documentation.

MGH IT Infrastructure (current and future) includes (but not limited to) the two most recent generations and releases of:
- Server technologies
o Physical servers (Dell preferred)
o Virtualization platform (VMWare, Hyper-V, and Citrix preferred)
- Enterprise storage
o EMC (Powerstore, Unity, and VNX preferred)
- Client and Server Operating Systems – Windows, Linux
- Identity and Access Management (IAM) and Privilege Access Management (PAM)
o Microsoft, Windows Active Directory, Azure Directory
o Okta, Beyond Trust, Sailpoint, Manage Engine
- Networking
o Aruba (wireless) and Cisco(wired)
o DNS, DHCP services
o Zero Trust Network (Netskope, Citrix, Aruba)
- Web technologies
o Apache, IIS
o PHP
- Database
o MS SQL and MySQL preferred
o MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MSSQL Server Analysis Services (SSAS)
- Cloud computing (Azure, AWS, GCP)
- Enterprise Backup and Recovery
o IBM Spectrum Protect/SPP, EMC Data Domain, and Rubrik preferred
- File and Print services

2. Technical Leadership and Collaboration

- Serve as the escalation point for support issues. Provide technical leadership and proficiency in the day-to-day operations (support and IMACD) and project related tasks, ensuring adherence to best practices.

- Have excellent communication and collaboration skills to work effectively with cross-functional teams (technical and non-technical), external partners, user groups, and vendors.

- Strong documentation and presentation skills to foster knowledge sharing with cross-functional teams to facilitate better understanding, management, and support of MGH systems. Assist in the development and maintenance of detailed system documentation, including architecture diagrams, change logs, and standard operating procedures. Assist in the development and review of related policies and procedures.

- Dedicated to technical skills development and help mentor junior team members and contribute to their…