Data Analyst

Job Description

Seeking an experienced Senior Database Analyst with strong expertise in Oracle PL/SQL and Microsoft SQL Server T-SQL to support database operations, reporting, data analysis, and roadside toll systems.

Key Responsibilities

• Develop, maintain, and optimize SQL queries, stored procedures, and database schemas.

• Create and maintain KPIs, metrics, alerts, and operational reports.

• Develop Power BI dashboards and reports.

• Support database migrations, deployments, and SQL replication.

• Perform SQL Distributor maintenance and troubleshoot database issues.

• Analyze data requirements, data dictionaries, and database structures.

• Support roadside toll systems, vendor deployments, and third-party patching.

• Coordinate with infrastructure, monitoring, and application teams.

Required Skills

• 10+ years of overall experience in database development/administration.

• Strong hands-on Oracle PL/SQL and Microsoft SQL Server T-SQL experience – BOTH MANDATORY.

• SQL programming, stored procedures, database design, and performance optimization.

• Database migrations, SQL replication, and troubleshooting.

• Data analysis, reporting, and KPI development.

• Experience supporting enterprise database environments.

Preferred Skills

• Power BI dashboard development and reporting.

• SQL Server replication and Distributor maintenance.

• Experience with monitoring, alerts, and database deployments.

• Tolling systems or transportation industry experience.

Education

Bachelor's degree in Computer Science, Information Systems, or equivalent work experience.