|SQL Analyst X8 (138143)|
|Location: Brentwood, TN|
|Metro Area: Nashville, TN|
|Category: Information Technology|
SQL Analyst - Mulitple OpeningsResponsibilities
Provides recommendations for solutions.
Creates the workplan for execution. Identifies the gaps in the workplan. Executes the workplan.
Creates Stored procedures to execute the workplan.
Creates the database structures to execute the workplan
Responds to ad hoc requests. Quickly understands and assesses the business problem. Creates ad hoc queries and solutions.
Able to understand the operational workflow and data sets. Understands the internal or external client needs.
Creates standard reports.
Analyzes the workflow between internal departments and external vendors. Identifies gaps and areas for improvement.
Creates solutions to pass and transform data from Chart Ops to others within the organization.
Analyze large amounts of data sets to determine optimal way to aggregate and report on it.
Create and maintain load processes.
Ability to create tools such as databases, tables, reports to facilitate operations? ability to meet goals and objectives.
Responsible for development of stored procedures and T-SQL/PL-SQL scripts. Writing complex queries, using data modeling tools, designing and optimizing databases. Create and edit T-SQL code in a well-structured, optimized and documented format. Working internally with many teams on a wide variety of projects. Make recommendations, troubleshooting & database functions for new systems and utilities. Adhere to firm and departmental procedures, policies and processes.Qualifications
Expert level knowledge of T-SQL language required. Must have a strong understanding of how the SQL Server database engine and architecture work, including but not limited to: Physical storage, indexing, physical database design best practices, and the Query Optimizer. Experience and detail level understanding for various SQL Server features such as SSIS, SSAS, SSRS, XML, Full-Text, etc. Excellent communication skills, both verbal and written, with excellent analytical and problem solving skills. Strong knowledge of and experience with SQL Server 2008/2012/2014. Development of data-driven .NET applications using the Microsoft Sharepoint framework. Bachelor's Degree in Computer Technology or equivalent experience. 5+ years SQL Server Development Experience.Technologies (Database)