Database Analyst

ASSYST, Inc.; Florida; On-site; USD 70,000 - 100,000; Full time

Job summary

ASSYST, Inc. seeks a Database Analyst to support our client onsite in Ocoee, Florida. The role focuses on creating and maintaining KPIs, optimizing database schemas, and delivering Power BI reports to inform business decisions.

Ideal candidates bring 5+ years of DBA experience with PL/SQL and T-SQL, plus strong data analysis skills and experience with Oracle and SQL Server. Onsite work in Florida is required.

Qualifications

• Bachelor's degree or equivalent in CS/IS or related field.
• 5+ years IT DBA experience in relevant environments.
• Proficiency with PL/SQL and T-SQL.
• Experience with Power BI reporting and data analysis.

Responsibilities

• Create, manage, and maintain KPIs and metrics.
• Support Roadside Toll Systems Team with reports, alerts, migrations, and deployments.
• Collaborate with monitoring and SLAM teams for patching and data analysis, Power BI development, and multi-platform databases.
• Design, develop, and optimize database schemas to meet system requirements.
• Gather and analyze business processes to validate data credibility and relevance.

Skills

DBA experience

PL/SQL

T-SQL

Power BI

Data analysis

Education

Bachelor's Degree

Tools

Oracle

Microsoft SQL Server

Job description

ASSYST is seeking for a Database Analyst to support our client in Ocoee, Florida (Onsite).

Responsibilities:

• Core Responsibilities: Responsible for creating, managing, and maintaining key performance indicators (KPIs) and metrics.
• Team Support: Supports the Roadside Toll Systems Team through report generation, creating new alerts, database migrations, vendor build deployments, hardware replacements, SQL distributor maintenance, and roadside replication support.
• Collaboration & Operations: Partners with the monitoring operation center and SLAM team members to oversee third-party patching, deep-dive data analysis, Power BI report development, and support databases across multiple platforms and computing environments.
• Database Design & Optimization: Analyzes data requirements, application and processing architectures, data dictionaries, and database schemas; designs, develops, amends, and optimizes them to meet system requirements.
• Business Analysis: Gathers, analyzes, and normalizes information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.

Requirements:

• Education: Bachelor's Degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
• 5 years of IT work experience in DBA, SQL procedural code, and design within relevant computing environments.
• Must be versatile in Oracle Procedural Language (PL-SQL) and Microsoft SQL (Transact-SQL).
• Reporting & Analytics: Proven experience in Power BI report development and deep-dive data analysis.

Preferred Skills:

• Experience supporting roadside tolling systems, particularly SQL distributor maintenance, roadside database replication, and operational monitoring.

ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

As set forth in ASSYST, Inc.’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.