Sql dba Jobs in Scarborough, ON

Account Technology team oversee customer relationship management, business analysis, product and project management utilizing best-in-class software to support BGIS customers. Working directly with client/business partners and BGIS IT to manage and drive application enhancements while aligning with the direction of the Enterprise Project Management Office.

The Business Partner collaborates with business leads and subject matter experts to support Operations initiatives (. implement tactical software solutions, workstream processes, data analysis, documentation & communication. At this level, the incumbent implements and supports systems with fewer dependencies involving little or no financial component, lesser requirement for real time processing, less complex processes, and lower risk to the organization

Business Systems Analysis

• Works with business leads, subject matter experts and IT resources (. Solutions Consultants) in the implementation of tactical software solutions.

• Arranges and facilitates requirements discussions including interviewing SME’s, shadowing key end users, and collaborating with business leaders to define and document requirements for new solutions or enhancements to existing applications and reports.

• Performs impact analysis of proposed solutions, assesses the impact of changes/enhancements to various accounts/users, understands variances in implementation by account, and identifies opportunities for standardization.

• Understands and communicates technical and architectural complexities of a technical solution so that project concerned parties can easily understand.

• Translate business requirements to IT specifications and communicates to IT teams to obtain the necessary time and cost estimates (documentation, development, UA/QA testing, deployment, as well as any anticipated issues and risks.

• Obtains business sponsor approvals on all business requirements and estimates, where applicable, prior to proceeding to the next stage in the project in accordance with IT process and audit requirements.

• When assigned, assists with the development of high-level plans for completion of Requirements and Acceptance phases of projects, improving in the level of detail and accuracy of estimates over time.

• When assigned, contributes to the development and execution of testing, including creation of test cases, coordinating system and acceptance testing, reviewing defects arise during testing and works with concerned parties to resolve them.

• Contributes/creates user guides, reference manuals/training materials as appropriate.

• Contributes to the team knowledgebase with best practices, lessons learned, concepts and solutions documents.

Solutions Delivery

• Works with IT resources ( Solutions Consultants) to gain a solid understanding of requirements and implement client specific solutions with emphasis on data analysis, extract, transform and load.

• Completes assigned data loads to support specific client initiatives and new client transitions. Performs data parsing and transformation as required to import data into our system while maintaining data integrity and quality.

• Creates and maintains implementation checklist.

• Nice to have ability to when assigned to:

• Creates and update ETL specification, define ETL logic and create supporting documentation.

• Create database views and performs minor modification in database packages.

• Create data extractions utilizing MS-Access or SQL Developer.

Product Management

• Serves as a knowledge expert in areas of focus from an IT product perspective.

• Works with business leads and SME’s in the completion of Business requirements for system configuration including analyzing legacy systems/data for the purposes of enhancing or migration to BGIS systems.

• Supports implementation of new modules (. configuration, documentation, training, launch), and coordinates user acceptance testing and sign off prior to production implementation.

• Works with business leads, SME’s and key end users to assist in defining new business processes which leverage existing or new RealSuite, Best of Breed Applications and Business Intelligence Applications functionality.

• Researches industry/product trends and makes appropriate recommendations for tactical software enhancements that align with industry trends and clients evolving needs.

• Performs analysis of reported production problems, determines impact and priority; and recommends corrective actions.

• Provides direction and guidance as a Second-Tier support resource to the Application Support team for products under the responsibility of the Solution Consultant.

Customer Relationship Management

• Participates in regular meetings with account leads and/or product line leads as an accountable technology partner to ensure that their implemented solutions continue to meet their business needs.

• Manages a backlog of account- or product line-specific needs on behalf of business partners.

• Represents BGIS, account leads and/or product lines in IT-centric processes to ensure the business needs are raised and considered.

Project/Initiative Coordination

• Participates in the overall success of IT projects including but not limited to application development projects, business process development projects and new client implementations for core BGIS applications.

• Contributes to the development of Project Proposal Forms, Project Charter for project management, business requirements

• Establishes project milestones with key business leads and technologies team members.

• Provides status updates to senior management for relevant initiatives highlighting key deliverables, risks and areas requiring assistance/escalation.

• Employs documentation best practices in all solutions documentation and applies established BGIS and IT processes to the management of all software and implementation projects (Change Management, Application Enhancement/Defect Process, .

General Communications

• Collaborates with internal and external concerned parties to design and develop communication plans and implement communication initiatives that are specific to the client account.

• Researches, writes and edits related materials such as presentations, posters, notices, briefing notes, social media posts and newsletters, in line with communications plan.

• Distributes communications to internal and external audiences.

• Leads assigned internal communications initiatives at a regional level, including refreshment of various communication materials to ensure team members are aware of client programs and are engaged.

• Working with different BGIS departments, identifies unique and innovative ways to communicate internally and externally.

• Supports translation to French of communication materials by working with BGIS’ translation company.

• Assist with various industry events including registration, booth set up, coordination of materials.

• Supports vendor engagement to improve awareness of BGIS opportunities.

• Supports social media requirements.

Tenant & Occupant Engagement

• Builds and implements Tenant communication programs based on national and regional initiatives.

• Oversees all Tenant and occupant regional communications, ensuring messaging is consistent with national initiatives and is engaging and informative.

• Develops and implements new methods to engage with clients, Tenants and occupants.

KNOWLEDGE & SKILLS

Required:

• University or college degree in a related discipline (. Computer Science, Information Technology, Business Technology)

• Minimum of 1 years of relevant job experience.

• Understanding of various SDLC project delivery methodologies such as Waterfall, Agile and ability to apply to the applicable portions of the Intake, Discovery, Execution and Stabilization phases.

• Ability to work on multiple projects in parallel.

• Strong interpersonal and facilitation skills to lead group discussions and solid skills in eliciting business requirements from end-users, including experience with different techniques.

• Excellent consulting and relationship management skills.

• Strong verbal/written communication (English) and interpersonal skills including the ability to communicate effectively to both technical and non-technical individuals.

• Strong analytical and problem-solving skills in troubleshooting system and data issues.

• Strong customer focus.

• Solid understanding of business processes and experience working with similar lines of business

• Strong organizational and time management skills including the ability to adapt to frequently changing priorities, manage and/or prioritize simultaneous tasks to meet deadlines.

• Strong negotiation/conflict resolution skills.

• Knowledge of relational database concepts and SQL queries.

• Demonstrates working knowledge of

  MS Office Suite (Word, Excel, Outlook, PowerPoint)

• Quick learner and self-starter with demonstrated ability to learn new and exciting technologies with minimal assistance.

• Ability to work independently with minimal supervision and as a member of a team to excel in a dynamic environment.

• A wide degree of creativity.

Experience on the following is desired:

• Microsoft and/or Oracle Database Technologies, SQL, PLSQL and relational databases

• Experience with ETL tools and procedures

• Experience with ERP systems

• Experience with reading and writing SQL and develop automated scripts

• Experience or knowledge of programming and scripting language

• Experience with Facilities Management / Real Estate software applications such as: ReaSuite, IWMS (Archibus, Tririga, Accruent, Serraview, PMWeb), CMMS (Maximo, Angus), Real Estate (Yardi, Argus)

Licenses and/or Professional Accreditation

• None required

This is a regular, full-time position with a salary range of $63,397 - $79,246 per annum. The starting salary will be based on the successful candidate’s competencies, including but not limited to experience, education and performance related to this role.

#LI-SS1