GDC SQL Developer

29 Jul 2024

Vacancy expired!

The GDC 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 Georgia Department of Corrections (GDC) protects the public by operating safe and secure facilities through the development of professional staff and effective offender management. GDC 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. Knowledge & Experience Minimum 3 years' experience in SQL development Must have experience with SQL queries, stored procedures, functions, and triggers Experience in data warehousing and analytics Questions No. Question Question1 Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question2 Please list candidate's email address. Question3 Candidate must be paid AT LEAST NA if selected for engagement. Candidate can be paid more; however, the SRP rate cannot exceed NA. Do you accept this requirement? Question4 The maximum mark-up for this engagement's SRP rate is 16.9%. To be competitive on pricing, a mark-up below the 16.9% threshold is suggested. Do you agree to propose a mark-up at or below 16.9%? Question5 This assignment is contingent upon customer renewal and availability of adequate funding. Do you accept this requirement? Question6 The selected candidate will be expected to start their engagement no later than 2 weeks (10 business days) from the client's selection date. Do you accept this requirement?

  • ID: #44462031
  • State: Georgia Atlanta 30377 Atlanta USA
  • City: Atlanta
  • Salary: $47
  • Job type: Contract
  • Showed: 2022-07-29
  • Deadline: 2022-09-27
  • Category: Et cetera