IT Solutions Design Specialist ( SQL Developer )
8 - 10 years experience • Financial Services
Building a World-Class, Diverse and Inclusive Technology Team
We can’t afford to be boring. Neither can you. The scale and scope of what TD does may surprise you. The rapid pace of change makes it a business imperative for us to be smart and open-minded in the way we think about technology.
TD’s technology and business teams become more intertwined as new opportunities present themselves. This new era in banking does not equal boring. Not at TD, anyway.
TD Applications & Systems Development covers technical planning, integration, systems analysis, design, development, unit and component systems testing, support-maintenance, and more. Meaningful, effective relationship-building is part of what these highly-skilled experts do best as they work together with technology project managers, delivery partners, business and systems analysts, testing and quality assurance teams, sponsors and so many other stakeholders to clarify requirements.
There’s room to grow in all of it.
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 technologyarchitecture, 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.
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:
- UndergraduateDegree 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.
PreferredQualifications – Here are thepreferredqualifications for this role:
Previous experience as SQL and Java developer
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.
Experience with UNIX/Linux shell script development
Experience with T-SQL programming and MS SQL Server databases a big plus