Data Architect (Oracle/Microsoft SQL Server/Azure Certified)

Job Title

Data Architect (Oracle/Microsoft SQL Server/Azure Certified)

Job type

C2C

Location  

Tallahassee, FL

Relocation  

No

Location Type

Onsite

Duration

Long Term

Number of Positions

1

Experience Required

12+ years

Notes

Job Description

Description:

Note : Please reply ONLY if you

1)  can work 100% on-site from day one. NO remote options allowed.

2) have all the Required skill set and have worked as a " Data Architect (Oracle/Microsoft SQL Server/Azure Certified)" in a large & Complex enterprise level IT Environment. Prefer to have Public sector projects.

3) have min 12+ years of IT work experience with demonstrated knowledge in large and complex database management systems, business intelligence tools and systems.

4) can provide at least 3 verifiable experience from completed and/or substantially completed jobs that closely match this request (Filling the client provided form) + fill out a skill Matrix

5) Can go through a background check including fingerprinting + Agree to a Face to face interview OR a WEB CAM Interview (at your own cost)

6) A Competitive Rate

7) will be available in Oct/Nov 2024 timeframe as it takes a minimum of 2 weeks for a start after a successful interview.

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.

Face to Face Interviews:

In the event an interview is requested; 1st round of interviews may be conducted in the in Tallahassee, Florida or via Skype, video, phone or any other electronic means. However, 2nd round interviews will be F-2-F if the client manager wishes to do that.

Telecommuting:

Not an Option for this position. The work shall be conducted onsite with the Department's OIT in Tallahassee, Florida.

Purpose

Our Client is seeking is seeking a Data Architect to examine large data sets and use them to identify trends and reach meaningful conclusions that inform strategic business decisions.

Scope of Work

             Follow Department IT processes and coordinate with other Department IT staff to ensure  compliance with Department standards.

             Participate in the analysis of current system(s) to gain an understanding of inputs and outputs.

             Participates in all phases of the development and implementation process and may act as a project manager on special projects.

             Establish and manage a formalized solution architect for data development and maintenance projects.

             Provide appropriate documentation for object design decisions, estimating assumptions,  applets, and performance metrics.

             Analyzes assigned specifications, planning, designing, and developing solutions, utilizing  appropriate Internet/Intranet/Extranet architecture processes supporting a wide range of  content.

             Participate in the analysis of the current system to gain an understanding of the inputs and outputs.

             Attend and participate in all project related meetings and assuring meeting notes are produced and distributed, as necessary.

             Correspond (verbally and in writing) with project team and internal stakeholders  regarding project activities, deliverables, and status.10     Server as senior subject matter expert.

             Recommend best practices in solution architecture.

             This project does not require travel outside of Tallahassee, Florida.

MANDATORY Technical/Business Skill Set Requirements (must be clearly stated on the resume and verifiable via reference checks)

The Vendor shall provide a Consultant(s) who meets the following criteria:

•            11-12 years of IT work experience with demonstrated knowledge in architecture design, software development, database management systems and  systems integration in multi-platform environments.

•            Advanced knowledge of data analysis techniques, database structures, and database theories.

•            Proficient with Microsoft SQL Server.

•            Experience with Oracle.

•            Experience with PL/SQL, T-SQL, P-SQL and MS SQL.

•            Certification in one or more of the following: Oracle Certified Professional. Microsoft Certified DBA, Microsoft Azure Administration, CompTIA A+, CompTIA Data+, CompTIA Server+.

•            Strong communication and validation skills.

•            Experience with IT systems and processes, methodologies and their direct implementation to projects.

•            Experience working on multiple projects as a project leader or frequently as the subject matter expert.

•            Goals-oriented proactive team player with the demonstrated ability to multi- task and prioritize in a fast-paced professional environment.

•            Excellent oral and written communication skills; able to garner support from a wide variety of stakeholders.

•            Critical thinker with excellent problem-solving skills that can make independent decisions within area of responsibility and expertise.

             Preferred Qualifications:

•            Knowledge of and experience with State of Florida IT standards and processes.

•            Experience working in state government

Tasks

At a minimum, the Consultant(s) shall perform the following tasks:

•            Follow CLIENT IT processes and coordinate with other CLIENT  IT staff to ensure compliance  with CLIENT standards.

•            Create queries and accurately interpret multiple data sets; write shell scripts to automate repetitive tasks in order to streamline workflow; analyze and develop PL/SQL packages and execute T-SQL and P-SQL queries; analyze business procedures and recommend specific types of data to improve processes.

•            Develop conceptual and logical data models, data collection systems, data analytics and other strategies to optimize statistical efficiency; provide OECS staff with data resources from election related databases needed for case intake, investigation and management; transform specialized data into formatted reports.

•            Proposes and implements failover strategies. Performs database patches.

•             Performs database upgrades and implements new features. Schedules the monitoring of successful database back-ups. Performs database restores as required.

•            Responsible for conducting low level monitoring, access control, and performance of OECS databases; overall solution configuration; database and related systems architecture, availability planning, including Disaster Recovery; monitor all database environments for capacity, integrity, and efficiency.

•            Performs database tuning as needed to address performance issues; conducts proactive maintenance. Responsible for analysis and query execution plans and index utilization. Assists in the development of new applications, including system design, creation of tables, and setting performance metrics. Implement database schema modifications as required.

•            Maintain change logs for all database configuration updates and changes for all database servers. Maintain change logs for user accounts and ensure security standards are implemented.

"When replying please make sure to list your (All Inclusive) Compensation requirements !!!"