SQL Reports Developer_ ERWin/ERStuido_Healthcare domain _Govt. exp preferred

US IT Solutions Inc; Tallahassee (FL); On-site; USD 75,000 - 95,000; Full time

Job summary

A reputable IT solutions company in Florida is seeking an experienced SQL Reports Developer. The role requires significant experience in PL/SQL and Oracle databases, as well as expertise in MS SQL Server. Responsibilities include providing technical support, resolving user issues, and developing complex queries and reports. Candidates should have a strong understanding of database design and integrity evaluation. This is an excellent opportunity to work with various state and local departments.

Qualifications

• 6 years of experience with PL/SQL and Oracle databases.
• Strong knowledge of MS SQL 2008 and SQL programming.
• Experience with ERWin and ERStudio for database design.

Responsibilities

• Support end users and resolve technical problems.
• Document and track issues for timely resolution.
• Analyze and interpret table structures to develop complex queries.

Skills

PL/SQL

Oracle databases

Source Code Control System (SCCS)

MS SQL Server

SQL programming

Database design tools (ERWin, ERStudio)

Data integrity evaluation

Education

Associate's degree in a related area

Tools

Oracle Forms

Crystal Reports

Job description

Overview

SQL Reports Developer_ ERWin/ERStuido_Healthcare 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 (SourceSafe 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.