Robert Half International Database Analyst in CHICAGO, Illinois
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
•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
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
Attention to Detail
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.
Location: CHICAGO, IL
Date Posted: October 15, 2020
Employment Type: Temp to Hire
Job Reference: 01300-0011591063
Staffing Area: Technology u0026 IT