On-Site Database/Systems Analyst - Tallahassee, United States - Global Information Services

Description

Skills:

Please DO NOT Apply unless YOU:

1) can work 100% on-site from day one & have all the Required skill set and have worked as a "On-Site Database/Systems Analyst (Java - SQL/PL-SQL/ETL/Data Cleansing/Conversion/mapping)" in a large & Complex IT Environment.
2) can meet the min required experience as defined under the MANDATORY Skill.
3) can provide at least 3 verifiable experience from completed and/or substantially completed jobs that closely match this request + fill out a skill Matrix
4) Can go through a Full background investigations (including finger printing, credit check and drug screen) by the client once selected. You would also need to fill out some pages of paperwork from the client to start the background check process which typically takes 4+ weeks. Your Status WILL ALSO BE VERIFIED USING E-VERIFY SYSTEM.
5) have a Competitive Rate
6) Can sign a certification form verifying All the experience in your resume
7) will be available in July/Aug 2024 timeframe as the background check after a successful interview takes a minimum of 5+ weeks.

s and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time.NOTE: GIS will utilize the U.S. Department of Homeland Security's E-Verify system to verify the employment eligibility of all persons employed during the term of the ContractNote to Consulting Companies : ANY CONSULTANT S RESUME YOU SEND ME MUST BE ON YOUR COMPANY S PAYROLL, NO H1-VISA TRANSFER, NO PRO-MARKETING, NO SISTER COMPANY RESUMES. The resume should have the DIRECT contact info and email of the candidate otherwise the candidate will NOT be considered. ALL H1 candidates including those onWOULD need to provide I-797 (no exceptions).

each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard.

This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks.

Interviews:
In the event an interview is requested, in-person interviews will be conducted at Tallahassee, Florida. At the discretion of the manager, interviews may be conducted remotely via Microsoft Teams. A phone interview may also be requested as a first step.
Telecommuting: Telecommuting is not an option for this position. This is NOT a remote position.

Background
The mission of the Client is to promote public safety and strengthen domestic security by providing services in partnership with local, state, and federal criminal justice agencies to prevent, investigate, and solve crime while protecting Florida s citizens and visitors. In 1982, the Florida Legislature appropriated funds for the establishment of the first state Missing Endangered Persons Information Clearinghouse (MEPIC) in the nation. The current system has added functionality over the years as required by legislation and to assist the Client members who use the system to issue alerts and streamline processes for faster communication about a missing person.
The MEPIC system needs to be replaced with a database re-design and programming in newer technology with web screens that adhere to the current business needs rather than being constrained by the foundation of a 1983 system design. Newer technology in a re-designed MEPIC system can better assist in the recovery of missing persons.

Description of Services & Deliverables
Client requires the services of one Systems Analyst to work under the direction of Client s assigned supervisor to achieve the goals and objectives of the MEPIC Technology Upgrade Project as approved by a Legislative Budget Request (LBR). The Systems Analyst will be responsible for converting data from existing SQL database structures to a better designed SQL relational database structure.
The person in this position: Must analyze the structure, content and quality of the data to be converted. Map the data elements from the source tables to target tables ensuring that all necessary data is accounted for. Convert the data from the source tables into the target format tables. Validate the accuracy and integrity of the converted data. Document the data conversion process to include how issues were resolved with particular data elements Clearly communicate with stakeholders the data conversion plan

Systems Analyst responsibilities include, but are not limited to the following:
Planning, Organizing, Integrating, and Implementing requirements with system interfaces, scheduled processes (jobs), functions and features
Adhering to Client Project Control Processes, Procedures, and Change Control
Technical issue identification and resolution
Deployment and Implementation Planning
Technical leadership in data conversion strategies for successful implementation
Provide detail and summary reporting to the Project Manager on the progress of completing assignments by the developers
Develop the programming architecture for converting the data to the new structure
Coordinate effectively with Client Information Technology Services (ITS) staff required to support the project
Effectively work with the Office of Statewide Investigative Systems (OSIS) Enforcement and Investigative Services (EIS) Leadership and MEPIC members throughout the software development life cycle to complete this project

Deliverables:
Documented Detailed Data Conversion Plan
Converted data ready for import in to the target SQL system
Reports to support the accurate results of the converted data
Identification of issues immediately with recommendations to mitigate
Assistance to the Project Manager ensuring Action Items, Decisions, and optimal design is documented
Contributor to the Operations & Maintenance Plan
Knowledge transfer to the Client ITS MEPIC Maintenance Team

Mandatory Skills and Experience:
Bachelor s Degree in Computer Science, Business Administration, or other related Information Technology (IT) fields
Minimum of 11-12 years of work experience designing successful, large-scale IT projects
Proficient database management system skills to build SQL scripts to extract, transform, and load data from old structures to new structures
Analysis and understanding of data structures and schemas
Ability to troubleshoot and resolve issues that arise during the data conversion process
Ability to clearly communicate with team members and stakeholders about the data conversion process and any issues that arise
Ability to manage multiple tasks simultaneously and to work under tight deadlines
Understanding the system from which the data is being moved from and to
Ability to handle sensitive data responsibly
Strong SQL programming skills
Experience in completing the SQL scripts to convert the data within the schedule timeline
Excellent oral and written communication skills
Strong collaboration skills with stakeholders and project team
Ability to communicate the technical data conversion design in non-technical terms for the end-users to understand
Experience working in a multi-vendor project team members
Technical understanding of data conversion projects
Experience designing and programming in development projects
o J2EE/Java (JSP, EJB)
o JBoss 7.x application servers
o JDBC
o MS-SQL 2019 database
o PL/SQL stored procedures, triggers, views, etc.
o XML

Preferred Skills and Experience:
Master s Degree in Computer Science, Information Systems, Business Administration, or other related field or equivalent work experience;
Government, Law Enforcement, or Public Safety IT projects

Note : These are Full Time ON-SITE Contract Position with NO remote options allowed.

**When responding please do tell us your All-inclusive compensation requirements ***.

POSITION STARTS : July/Aug 2024

# of Positions : 1

No phone calls please.
Local Citizens are encouraged to Apply
No relocation assistance provided.
ONLY Candidates with an exact match will be contacted
Candidates should be authorized to work in the US.