Robert Half Corporation Jobs

Job Information

Robert Half International Database Analyst in CHICAGO, Illinois

Description

The SQL Database Analyst will be responsible for the design, development, and deployment of new database solutions, as well as provide support for existing databases and data-driven applications.

Duties and Responsibilities include the following. Other duties may be assigned.

•Hands-on writing of complex, and optimized, T-SQL scripts, stored procedures, and database functions

•Troubleshoot and resolve any database related issues including performance, waits, bottlenecks, deadlocks

•Assist with the design and development of new data solutions, applying best practices to current and new processes including unit, integration, and acceptance testing.

•Assist with managing and monitoring multiple mission-critical SQL Server environments

•Support operational activities including production applications, tech support tasks, troubleshooting data issues, database change requests, monitoring jobs & data processes

•Investigate and resolve application performance issues, tracing and identifying the root cause and resolving in production systems.

•Understand database environment including schemas, table indexing and statistics, query strategies, and database objects maintenance and performance issues.

•Research & Develop new and improved strategies and processes to help enhance the data environment.

•Performance tuning in critical production environments using Extended Events/Profiler, execution plans, system tables, error logs, data/plan caches, etc.

•Work with system architects to maintain database performance by identifying and resolving production problems.

•Assist with training data analysts on best methods for SQL reporting and querying

Preferred Knowledge:

•Expert knowledge of T-SQL

•Microsoft SQL Server 2008 through 2016, and beyond

•JSON, XML and XSL

•Query and database performance optimization

•Ability to prioritize and concurrently manage multiple projects

•SQL Server Analysis Services and SQL Server Integration Services a plus, but not required

Requirements

MS SQL Server, MS SQL Server 2008, SQL Server Analysis, SSIS - SQL Server Integration Services, SSAS - SQL Server Analysis Services, T-SQL, Database Servers, SQL Server Databases, Database Query, JSON, XML, XSL, Database Development

Skills:

Critical thinking

Professionalism

Attention to Detail

Technical Communication

Problem Solving

Systems Analysis

Time Management

Education/Experience:

5+ years of professional database-related experience preferred.

Robert Half Technology matches IT professionals with some of the best companies on a temporary, project or full-time basis. From roles in software and applications to IT infrastructure and operations, we provide you unparalleled access to exciting career opportunities. Our personalized approach, innovative matching technology and global network with local market expertise help you find the technology jobs that match your skills and priorities — fast. By working with us, you have access to challenging opportunities, competitive compensation and benefits, and training to enhance your skill sets.

From philanthropy to environmental stewardship to employee programs, Robert Half is proud to have an active role in the communities in which we live and work. Our company has appeared on FORTUNE’s “Most Admired Companies” list every year since 1998.

Download our mobile app to take your job search on the go!

Contact your local Robert Half Technology office at 888.490.4429 or visit www.roberthalf.com/jobs/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.

© 2020 Robert Half Technology. An Equal Opportunity Employer M/F/Disability/Veterans.

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

Salary: DOE

Location: CHICAGO, IL

Date Posted: October 15, 2020

Employment Type: Temp to Hire

Job Reference: 01300-0011591063

Staffing Area: Technology u0026 IT

DirectEmployers