About This Role
We are looking for someone to lead the creation of a comprehensive end-to-end detailed solution with overall accountability for the technical design and delivery of the System Design Specification (SDS). You’ll be exposed to stretch assignments as you take on large-scale, complex and/or enterprise-wide projects.
Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here are the essential job functions of this position:
- Develop and document a detailed solution design within SDS, impart your subject matter expertise throughout life cycle.
- Participate in complex applications and systems development, programming.
- Propose solution options; generate stakeholder support.
- Collaborate with stakeholders on project estimates.
- Produce top-notch functional, technical and user interface designs.
- Take business, Enterprise Architecture, system performance and development standards requirements, then develop functional, technical and user interface designs for an application and/or system.
- Consult on development of the System Requirements Specification (SRS).
- Review technical deliverables for quality throughout detailed design and development phase, identify gaps or redesign as needed.
- Define metrics and performance goals with technology partners and peers.
- Respect TD’s technology delivery practices and standards, project management disciplines, business technology architecture, and risk and production capacity – this includes thorough project requirements, documentation, scope estimates and costs.
- Deliver effective and efficient solutions by meeting milestones and ensuring project deliverables are on time, within budget, and adhere to the corporate quality and security standards.
- Identify ways to minimize cost, play a role in introducing strategic solutions to support cost effectiveness and enhance stakeholder experience.
- Conduct code reviews to address quality, standards compliance, reusability and ease of maintenance, Operational Readiness Reviews, and support gating and review sign-offs for solution design.
- Support knowledge management processes and ensure knowledge is codified, monitored, tracked and managed.
- Ensure design leverages existing reusable components, traces back to business requirements, and that new modules are designed with reusability in mind.
- Identify and address any issue that affects the integrity of the application ( e.g. cross-capability/release issues).
- Provide technical support to promptly resolve escalated incidents/outages.
Other duties as assigned
• Driving Requirements:
• Travel Requirements:
What can you bring to TD? Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. Here are the minimum requirements for this position:
- Undergraduate Degree or Technical Certificate.
- Graduate degreepreferred.
- 7+ years relevant experience.
- Expert knowledge of the business, broader organization, technical environment, standards, processes, tools, procedures, multiple programming languages, operating systems, solutions design and other relevant technology areas from a design/support/solutions perspective.
- Readiness and motivation to work autonomously in a lead capacity on a diverse range of activities (e.g. design, support of technical business solutions) and can be relied on to coach, educate and monitor the work of others.
- Primary subject matter expertise in multiple areas; you’re seasoned in counselling clients and project teams on all aspects of research, analysis, design, hardware and software support, development of technical solutions and testing.
- Strength coaching and advising clients, partners and project teams, capable of being a internal expert resource in “technical information exchange”.
- Commitment to and belief in the quality of your deliverables.
- Must be eligible for employment under regulatory standards applicable to the position.
Preferred Qualifications – Here are thepreferredqualifications for this role:
• Previous experience in SQL and PL/SQL
• Sound knowledge of Oracle database tools, concepts and technologies on version 11 or higher (Oracle certification an advantage)
• Strong programming experience in writing and optimizing PL/SQL stored procedures, packages, functions, tables, materialized views, indexes, triggers and sequences.
• Strong Database application development and ETL experience with high volume data and batch processing
• Experience with UNIX/Linux shell script development
• Strong working experience with database tuning and optimization
• Previous experience in database upgrade, migration and testing a big plus
• Experience with T-SQL programming and MS SQL Server databases a big plus