Database Developer (SQL) - Consultant

Location Columbia
Discipline: Information Technology
Salary: $ 70 to $72
Contact email: rgarcia@brightmetro.com
Job ref: 436670
Published: 30 days ago
Summary
Scope of the Project:
  • This position will ensure databases are set up following industry best practices to ensure strategic initiatives and compliance with federal and state regulatory laws and ensure business continuity.
  • This position will be a part of the team responsible for supporting critical system data and database environments used by Public Health Deputy Area and Public Health Labs. The candidate will work with other team members to enhance the agency data integration processes and data warehouse.
  • Candidates should be self-motivated, team-oriented, work under limited supervision, and respond to priority tasks as needed.
Roles & Responsibilities Daily Responsibilities:
  • Participate in a team comprised of DHEC and solution implementation staff for related planning, designing, configuration, and maintenance of integrated systems and data associated with Public Health and Lab environments. Ensure assignments are completed accurately and on-time, assist with problem resolution, mitigate issues, provide solutions, communicate, and escalate as needed to management, and report progress to manager.
  • The candidate will work closely with the Enterprise Computing Services Team Lead and Section Manager to identify, prioritize, and schedule workload and implementation to IT standards and procedures. The candidate will work closely with customer and subject matter experts for streamlining system data integration, modeling, and reporting.
Specific database developer duties and responsibilities will include but are not limited to the following:
  • Work closely with other developers to integrate databases with other applications.
  • Evaluate, design, code, optimize, and modify Microsoft SQL, DB2 and Oracle databases and database applications.
  • Model databases and develop tables, stored procedures, views, triggers, and other database objects.
  • Tune databases for optimum performance.
  • Develop reporting and dashboard capabilities.
  • May involve interface development to access database
  • Modification of existing computer systems to be compliant with agency security requirements.
  • Ensure maximum system uptime for critical components to ensure business continuity.
  • Diagnoses, isolates and de-bugs technical problems and performs problem resolution.\
  • Database monitoring and tuning.
  • Adheres to Information Technology application development standards and security requirements.
  • Prepare and maintain system documentation and architecture diagrams for applications assigned.
  • Work in a collaborative effort to conceptualize total systems and/or product solutions currently in place and remediation of those systems in a segmented framework.
  • Ability to plan, organize, review, implement associated project milestones to completion.
  • Recommend and assist in the design of system architectures to align with organizational strategic business objectives.
  • Requires mastery technical and business knowledge in multiple disciplines/processes.
  • Create supporting project and system documentation.
  • Provide updates to the Project Team.
  • Assist with development of policies and procedures to conform and comply with agency standard cyber security policy design related to information risk management, designation of data as to criticality, confidentiality, and protection. (NIST 800-53, FISMA, SC InfoSec Requirements http://admin.sc.gov/technology/information-security/policies-and-procedures, etc.)The position will be utilized for 40 hours per week for the duration of this project. The selected candidate should be able to work flexible hours where it may be necessary for work to be completed outside traditional business hours.
  • This will also include compliance to DHEC security policy/procedures as well as integrating systems when possible to streamline staff workflows, user security, and data correction.
  • Module support of the project.
  • DHEC will require that selected personnel sign the DHEC confidentially agreement and/or Business Associate (BA) agreement if applicable. All web services must be secure.
  • DHEC will not accept any offers including an “up-lift” charge. The rate paid per consultant must not exceed the maximum rate established for this position described in the State contract terms.
  • Contractors must be onsite during each week throughout the term of the contract.
  • Follow agency IT Standards, policies, and procedures to include documentation.
  • All source code (compiled and un-compiled) will become the sole property of the South Carolina Department of Health and Environmental Control. Any source code, data, product, or functionality resulting from this SOW or previously owned/developed by DHEC will remain the sole property of DHEC and is not to be incorporated into the core product of any vendor's application. Any modifications and interfaces developed under said contract will be not be used by the contractor for any independent project of the contractor or published or publicized by the contractor without written permission of DHEC.
  • DHEC has the final say on all programming choices.
 
Preferred Qualifications  
Minimum Qualifications Required Skills:
  • SQL SERVER
  • DATA WAREHOUSING
  • DATA MODELING
  • KNOWLEDGEABLE IN VARIOUS DATA INTEGRATION TECHNOLOGIES
  • UNDERSTANDING OF COMPUTER AND NETWORK OPERATING SYSTEM FUNDAMENTALS (E.G. OPERATING SYSTEMS, APPLICATIONS, STORAGE, NETWORKING)
  • POWERSHELL
  • MICROSOFT ACTIVE DIRECTORY
  • EXPERIENCE WITH WINDOWS SERVER
  • REPORT AND DASHBOARD DEVELOPMENT
  • DB2
  • ORACLE
  • Experience with security and data classification related to CDC, HIPAA, and CJIS.
  • Ability to establish positive working relationships with technical staff, customers and others involved in data-centric management.
  • Excellent written, oral, and interpersonal communication skills
  • TICKETING SYSTEM
  • SUBVERSION (SOURCE CONTROL)
  • PYTHON
  • Ability to integrate technical systems with agency goals and objectives.
REQUIRED EDUCATION: 

  • Bachelor's or Master's Degree in a relevant field of work or equivalent work experience (5 years).