What are the responsibilities and job description for the Database Analyst position at ASSYST, Inc.?
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.