sql server dba / bi developer in Toronto

posted:
location
Toronto, Ontario
job type
Permanent
reference number
2013592PROEN
apply now

job description

This position is a key position for our client. This team is primarily responsible for the development, maintenance and Support of Corporate Microsoft SQL Server Business Intelligence Environments.

Reporting to the Manager of Application Support, this position is responsible for overall System Architecture Microsoft Business Intelligence solutions utilizing MS SQL Server 2012/2014 SSIS, SSAS, SSRS and MS SharePoint, tailoring solutions for Financial Reporting and Operational Business Intelligence; requiring to perform Database Administration (DBA) on all MS SQL Server Environments and engage in Business Intelligence (SQL, SSIS, SSAS, SSRS) development and troubleshooting activities.

Configure and optimize BI environments, which includes relational and OLAP layers, and data migration components. Work in partnership with Infrastructure teams to ensure system availability, collaborate with BI developers and business owners to ensure the creation of production Business Intelligence designs and implementations. Troubleshoot BI Environment problems and tune for performance; diagnosing and resolve application bottlenecks and performance issues. Define and enforce coding standards, design styles and best practices. Develop and manage BI presentation layer training, and documentation.


Job Duties in Brief

Database Administration

Manage SQL Server instances through multiple product lifecycle environments from development to mission-critical production systems.

Configure, patch and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate standard processes, track issues, and document changes.

Provide 24x7 monitoring and support for critical production systems.

Handle common DBA tasks such as monitoring, high availability, upgrades, migrations, backups, recovery, environment builds, security, etc.

Manage Database Job schedules; based off business requirements and job runtime durations.

Profile server resource usage, and optimize and tweak as necessary along with capacity planning.

Perform scheduled maintenance and provide support of release deployment activities after hours.

Work closely with infrastructure (Network, Storage, Security and Wintel) teams to maintain Windows environments running SQL Server components.

Manage Windows Server IIS environments and install SSL Certificates onto SSRS sites.

Setup Kerberos delegation on Windows Servers for SSRS environments to utilize Windows AD authentication.

Attend Change Management (CAB) calls to represent deployments/changes to Production environments.

Serve as subject matter expert; providing direction on industry best practices, cross-training to peers and stakeholders.



Database/Business Intelligence Development

Write, optimize and troubleshoot highly complex SQL statements.

Prepare documentation and specifications for development projects; including dataflow diagrams.

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.

Assist other developers with complex query tuning and schema refinement.

Maintain source Code using Team Foundation (TFS) repositories and handle overall BI development and deployment tasks.

Create complex SSIS ETL packages; focusing on optimization and portability within multiple environments (QA, UAT and PROD).

Engage in development and maintenance of all SSAS Cubes and SSRS Reports.



Project Management/Coordination

Work closely with Project Managers to ensure on-time on-budget delivery.

Organize, schedule, and manage small and medium projects.

Manager Risk, coordinate resources, and resolve project issues.



Testing

Assist with QA, UAT, and testing in coordination with Business test users.



About You:

Bachelor’s Degree in a related field is required.

7-10 years of DBA with SQL Server

2-3 years with Business Intelligence

Microsoft Business Intelligence/DBA Certification preferred.

If you would like to hear more about this role apply on-line or give us a call

Randstad Professionals Canada
apply now