Robert Half Technology Senior Database Analyst in Toronto, Ontario

Our client in Downtown Toronto is looking to add a Senior DBA to their team- You will be responsible for database maintenance, data analysis, database development, and support of our existing reporting needs within the organization. The ideal candidate will have the ability to navigate and analyze volumes of data for end user report development, data analysis in an SQL Server environment. What you will be doing:

  • Develops database solutions by designing proposed system, defining database logical, physical structure and functional capabilities, security, back-up, and recovery specifications.

  • Determine data typing at a conceptual logical level

  • Installation, configuration, and maintenance of Microsoft SQL Server 2008/2012 software and related products.

  • Develop strategies for data synchronization, update, and integrity.

  • Ensures Data Integration policies, standards, and guidelines are adhered to and that templates, best practices, and appropriate additional artifacts are leveraged.

  • Maintains database performance by identifying and resolving production and application development problems and calculating optimum values for parameters.

  • Develop routine maintenance including database rebuilds/re-indexing/expansion and archiving.

  • Provides technical and data leadership to the application development group and other DBAs.

  • Reviews and provides concurrence on detailed requirements and architecture documentation.

  • Create and maintain users and roles, assign privileges.

  • Database tuning and performance monitoring.

  • Work with the various business units including Finance, Sales, Customer Service, Marketing, and Operations in order to fulfill each unit's reporting and analysis requirements

  • Work extensively with other members of our development team, using analytical and problem-solving abilities to push the boundaries and create new solutions

  • Use excellent problem solving and communication skills to navigate through complex business rules, competing priorities and deadlines Key Requirements:

  • 5+ years experience with administration and maintenance of SQL server databases (2005,2008,2012) including installations, updates, optimization, security, indexing, tuning, backup and recovery, in keeping with organizational policies

  • 5+ years experience using key components of SQL Server, Business Intelligence and Data Warehousing (SSRS, SSIS, SSAS) in MSSQL 2005/8

  • 5+ years experience with database design and modeling, complex queries (TSQL), stored procedures, with an SQL Server background

  • Strong experience in dimensional modeling and physical design of high-performance and highly scalable data warehouses and multidimensional databases

  • Strong analytical skills, problem-solving ability and attention to detail

  • Ability to establish priorities and manage multiple projects at the same time

  • Ability to work under pressure with tight deadlines

  • Good communication skills, both verbal and written Interested candidates should send their resume to izza.sheikh@rht.com

With more than 100 locations worldwide, Robert Half Technology is a leading provider of IT professionals on a project and full-time basis for initiatives ranging from web development and systems integration to network security and technical support. Through our alliances with industry-leading organizations such as HDI® and the Microsoft® Partner program, we have access to client companies that other staffing firms don't. In addition to our free job search services, we provide our candidates with access to free online technical training and a competitive benefits and compensation package.

Our parent company, Robert Half, once again was named to FORTUNE® magazine's list of "World's Most Admired Companies" and was the highest-ranked staffing firm. (March 1, 2016)

Contact your local Robert Half Technology office at 888.674.2094 or visit roberthalf.com/technology to apply for this job now or find out more about other job opportunities.

All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.

Equal Opportunity Employer M/F/Disability/Vet

By clicking 'Apply Now' you are agreeing to Robert Half Terms of Use.

Req ID: 05090-9500266652

Functional Role: Database Analyst

Country: Canada

State: ON

City: Toronto

Postal Code: M5J 2T3

Compensation: $80,000.00 to $90,000.00 per year

Requirements: Key Requirements:

  • 5+ years experience with administration and maintenance of SQL server databases (2005,2008,2012) including installations, updates, optimization, security, indexing, tuning, backup and recovery, in keeping with organizational policies

  • 5+ years experience using key components of SQL Server, Business Intelligence and Data Warehousing (SSRS, SSIS, SSAS) in MSSQL 2005/8

  • 5+ years experience with database design and modeling, complex queries (TSQL), stored procedures, with an SQL Server background

  • Strong experience in dimensional modeling and physical design of high-performance and highly scalable data warehouses and multidimensional databases

  • Strong analytical skills, problem-solving ability and attention to detail

  • Ability to establish priorities and manage multiple projects at the same time

  • Ability to work under pressure with tight deadlines

  • Good communication skills, both verbal and written Interested candidates should send their resume to izza.sheikh@rht.com