The SQL Developer will need to interpret and understand what the user is requesting, research available solutions to fulfill the request, and implement the solutions by creating SQL scripts.
The state client is seeking an SQL Developer to ensure that proper steps are taken to keep our databases accurate and up to date. This includes actively researching and resolving user requests through application side administrative actions or through SQL scripting. The SQL Developer will need to interpret and understand what the user is requesting, research available solutions to fulfill the request, and implement the solutions by creating SQL scripts.
Work Schedule: 3 days onsite (downtown Atlanta office) /2 days remote
SQL Developer duties and responsibilities
•Create SQL scripts that will fulfill the user requests and submit the scripts to the DBAs for execution
•Set up automated processes, when required, for handover to the Deployment team
•Development of high-quality database solutions
•Review and interpret ongoing business report requirements
•Research required data
•Build appropriate and useful reporting deliverables
•Analyze existing SQL queries for performance improvements
•Suggest new queries
•Develop procedures and scripts for data migration
•Provide timely scheduled management reporting
•Investigate exceptions
•Keep records of all scripts and queries associated with each request
•Identify frequently submitted requests, research potential solutions, and implement the solutions to
minimize future errors
•Monitor internal ticketing system as well as executive requests through email.
•Interpret and understand user requests
•Research the requests and acquire additional information from the users if necessary.
•Design, develop and maintain SQL applications/ETL, databases, reports, and programs.
•Create, document, and implement test plans
•Set up and maintain automated SQL scheduled tasks
•Investigate and provide support to the business regarding all data related issues
•Designing, building, and maintaining efficient, reusable, and reliable code
•Document current or new processes
•Ensure the best possible performance and maintain the quality and responsiveness of applications
•Perform data analysis – write relational and multi-dimensional database queries
•Handle escalations from the business
Formal Education & Certification
•College diploma or university degree in the field of computer science or statistics, and/or 3 years of equivalent work experience. MS SQL Certifications beneficial.