SQL Developer in Lawrenceville, GA at HUNTER Technical Resources

Date Posted: 7/2/2019

Job Snapshot

Job Description

SQL Developer (contract)

Job Description: 

In this position, you will work as the SME around SQL development and reporting as well as creating a Graphical User Interface front end for global users to access the current SQL database. Assist with analyzing current systems in place to ensure systems are best suited for company operations. Develop Triggers to validate data and protect the database.

Experience & Responsibilities:
  • Solid experience working with Access front-ends calling MySQL or SQL server databases
  • Analytical Table relationships and ability to suggest Table restructure depending on the business enhancement requirements
  • Ability to build User Interfaces with Reporting, Print and Export to Excel capabilities in MS Access
  • Resolves defects encountered during various testing cycles
  • Analysis, design, coding, testing and implementation real-time multi-user application
  • Design solutions to improve business efficiency and productivity based on code enhancements
  • Create and modify tables, views, stored procedures, functions, indexes, schemas, etc
  • Develop complex SQL scripts to convert business requirements into technical scripts
  • Develop complex ETL & reports using SSIS/SSRS or equivalent BI tools
  • Analyze data and identify performance related gaps and provide solutions wherever applicable

Skills, know-how and experience:

Must have:
  • WinForms or other GUI development.
  • 5+ years T-SQL experience
  • 3+ years developing SSRS reports and SSIS packages
  • 3+ years’ experience with relational databases, specifically with application databases
  • 2-5 years hands-on experience with MS ACCESS application development experience
  • 3 years ASP, HTML, JavaScript, XML server-side Java based development a plus
  • J2SE and Perl experience a plus

  • Experience with merge replication setup, management, and troubleshooting are a plus for this position.
  • Familiarity with CRM and ERP systems a plus but not required

Technical / professional qualifications:
  • BS in Computer Science, Computer Information Systems, or equivalent