SQL Reports Developer_ ERWin​/ERStuido_Healthcare domain _Govt. exp

Overview

SQL Reports Developer_ ERWin/ domain _Govt. exp preferred

Title: Reports Developer

Interview Type: Telephonic/In-Person

Description:

We are from US IT Solutions, an ISO Certified, E-Verify, WMBE Certified organization established in 2005 in CA. Our company is serving various State, Local and County Departments for over 10 years. USITSOL has been helping clients innovate across all phases of the application lifecycle for over a decade. Some of our prestigious clients are State of CA, State of OR, State of FL, State of NC, State of GA, State of CO, State of VA, State of AR, State of MI, State of OH, State of IL, State of MO, State of MS, California State University, Sacramento Area Sanitation Department, SMUD, Sound Transit, LA Superior Courts, District of Columbia, UMAS, University of Central Florida and Hennepin County and many more.

Responsibilities:

• Provides support to end users on a variety of issues. Identifies, researches, and resolves technical problems.
• Responds to telephone calls, email and personnel requests for technical support.
• Documents, tracks, and monitors the problem to ensure a timely resolution.
• May require an associate's degree in a related area and at least 3 years of experience in the field or in a related area.
• Familiar with a variety of the field's concepts, practices, and procedures. Relies on experience and judgment to plan and accomplish goals.
• Performs a variety of complicated tasks.

Experience /

Qualifications:

• 6 years’ of experience with PL/SQL to query Oracle databases.
• 6 years’ of experience with Oracle relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments.
• 6 years’ of experience with Source Code Control System (SCCS) for the management of internal code changes to Oracle Forms/Reports, Oracle objects, and scripts.
• 6 years’ of experience with MS SQL products inclusive of MS SQL 2008.
• 6 years’ of experience as an MS SQL administrator inclusive of data design/modeling, monitoring, and performance tuning.
• 6 years’ of experience with SQL programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked servers.
• 6 years’ of experience with SQL relational databases, OLTP and DSS, serving in high performance, service-oriented, multi-tiered environments.
• 6 years’ of experience with configuration management (Source Safe administration) for SQL database objects.
• 6 years’ of experience with database design tools including ERWin and ERStuido.
• 6 years’ of experience with independently analyzing and interpreting table structures and relationships in order to develop complex queries and reports.
• 6 years’ of experience with database navigational and analysis tools; ability to recommend the appropriate tool for the appropriate data infrastructure complexity.
• 6 years’ of experience with developing queries and reporting against complex relational databases with preference given to experience with Crystal Reports and ASP to deliver such queries and reports.
• 6 years’ of experience with data integrity evaluation, taking corrective action on identified data problems, assisting with implementing data quality checks during data intake.

Additional Information:

Information will be kept confidential according to EEO guidelines.