Vacancy expired!
Zycron has coupled with a Nashville-based company and is in search of SQL Database Developer for a long-term contract position in Nashville, TN.
Responsibilities:- Support Database development activities including improving database quality and scripts while developing and deploying DB scripts for data quality, stability, and security systems to support maintenance activities that meet or exceed SLAs.
- Investigates, troubleshoots and corrects data and user related system errors in lower environments; ensures data integrity.
- Create, manage and troubleshoot SQL Server Agent jobs and SSIS packages for in-house developed software in development environments.
- Works with Database Administrators and Business Analyst to create and maintain in-house SSRS reports.
- Works with Database Administrators to design, document and implement database schema changes and additions.
- Write, document, and tune stored procedures, functions, views and ad hoc T-SQL queries used for in-house developed software.
- Works with Database Administrators, developers, and Business Analysts for any data transformation requests.
- Analyze and optimize database table indexes and statistics for in-house developed software
- Work all SQL-related development requests to completion, including running scripts, reviewing logs and/or trace files, troubleshooting performance issues and assisting developers as necessary.
- Bachelor's degree with a major in data processing, computer science, mathematics, or other related acceptable field.
- Three years of experience equivalent to database programming work.
- Strong experience with SQL Server 2017 and above for developing stored procedures, views, triggers and functions using T-SQL.
- Working experience with troubleshooting, fine tuning and optimizing database procedures, views and queries.
- Working experience creating and maintaining SSIS packages and SSRS reports.
- A thorough understanding of using and building XML.
- Experience with Azure DevOps in regards to Git and Work Item Queries, Areas, Iterations, and time tracking.
- Experience with Git Check-In/Out, Branching, Merging and Reversion.
- Experience with developing Database Change Scripts for deployment of database changes.
- Experience with RedGate tools SQL Compare, SQL Data Compare and SQL Source Control.
- Documents regularly, thoroughly, accurately, and completely.
- Computer literate; proficient in Microsoft Word, Excel, Outlook, and the internet; able to effectively adapt to and use other computer systems as needed for daily activities.