Engineering Lead – Database
| Company | Ontario Teachers’ Pension Plan |
|---|---|
| Location | Toronto, ON, Canada |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Expert or higher |
Requirements
- Minimum of 10 years in IT
- Expert level knowledge of database internals with one or more of SQL Server, Azure SQL, Snowflake, Oracle, PostgreSQL
- Minimum 5 years implementing, managing, and supporting cloud (Azure) and hybrid data platforms
- Minimum 5 years designing, developing and implementing automations to deploy databases and to manage day-to-day operational activities
- Strong technical troubleshooting and problem-solving abilities
- Experience in contributing to a complete Project Life Cycle process including but not limited to project Request-Discovery-Planning-Delivery and Closure landmarks
- Bachelor’s degree in Computer Science, Engineering, or equivalent
Responsibilities
- Apply your existing knowledge of database technologies to deploy, optimize and manage database infrastructure services
- Analyze existing database ecosystems to ensure they are effectively meeting the needs of the organization
- Coordinate with all areas of the organization to see that the database technology stack is performing optimally
- Perform market research and evaluations including Proof of Concepts (POC) of new technologies and may recommend alternative data platforms or improvements
- Develop and detail the proposed technical design for the integration and implementation of any new system/service
- Defines TI Standards and Strategies, including configurations and settings (hardening, security, logging, backup/recovery, patching and platform standard methodologies)
- Responsible for artifact management relating to design standards, templates, patterns, reference architectures and other design documentation standards
- Participate in evaluating the success of the project, identifying best practices and lessons learned and provide feedback to leadership and incorporates this information into future integration plans
- Developing and documenting standard operating procedures, improvements to design, build, configuration or operational functions based on measurement of reliability or efficiency of the service
- Management of technology licenses, asset management, prioritizing and assigning work to vendor staff, and the evaluation of OTPP and vendor operations performance
Preferred Qualifications
- Experience with DevOps, Infrastructure-as-Code, Ansible, Terraform, Jenkins, Spacelift are definite assets
- Knowledge of Enterprise Infrastructure Services including Compute, Network & Storage ecosystems are assets
- ITIL Foundations and TOGAF certification are assets