Database Analyst

ASSYST; Florida; On-site; USD 90,000 - 120,000; Full time

Job summary

ASSYST is seeking a Database Analyst to support our client in Ocoee, Florida. The role focuses on creating, maintaining, and optimizing KPIs, reports, and data systems on onsite infrastructure.

The candidate will develop Power BI reports, perform deep-dive data analysis, and collaborate with the Roadside Toll Systems Team to ensure accurate data across multiple platforms. A strong background in DBA duties and SQL is essential for success.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field or equivalent work experience.
• 5 years IT experience in DBA, SQL code, and design in relevant environments.
• Versatile in Oracle PL/SQL and Microsoft SQL (T-SQL).
• Proven experience in Power BI report development and deep-dive data analysis.

Responsibilities

• Create, manage, and maintain KPIs and metrics.
• Generate reports and alerts; support database migrations and deployments.
• Collaborate with monitoring and SLAM teams for patching and data analysis; develop Power BI reports.
• Analyze data requirements, schemas, and dictionaries; design and optimize databases.
• Gather and normalize business process information to evaluate data credibility and relevance.

Skills

Power BI

SQL

PL/SQL

T-SQL

DBA

Analytics

Education

Bachelor's degree in CS/IS

Tools

Oracle

MS 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.