Database Analyst

InstantServe LLC; Tallahassee (FL); On-site; USD 85,000 - 120,000; Full time

Job summary

InstantServe LLC seeks a seasoned IT professional to design, implement and optimize database and reporting solutions in a complex environment. You will manage KPIs, dashboards, alerts, migrations and cross-team data initiatives to ensure data credibility and performance.

The role emphasizes DBA work with Oracle PL/SQL and MS SQL, Power BI development, and collaboration across vendors and operations teams to support multiple platforms and computing environments from the Roadside Toll Systems

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, or related field or equivalent work experience.
• 5 years IT work experience in DBA, SQL procedures and design across computing environments.
• Proficiency in Oracle PL-SQL and Microsoft SQL (T-SQL).

Responsibilities

• Create, manage and maintain KPIs/metrics and dashboards.
• Support report generation, alerts, and data migrations.
• Maintain SQL distributor, vendor deployments, and hardware replacements.
• Work with monitoring and SLAM teams to oversee patching and data analysis.
• Develop Power BI reports and support databases across multiple platforms.

Skills

KPI reporting

SQL

PL/SQL

T-SQL

Power BI

Education

Bachelor’s Degree in CS/IS or related field

Tools

Oracle PL/SQL

Microsoft SQL (T-SQL)

Power BI

Job description

Responsible for creating, managing and maintaining key performance indicators

(KPIs)/Metrics. Supports the overall functions of the Roadside Toll Systems Team by performing report generation, creation of new alerts, database migrations, vendor build deployments, hardware replacements, SQL distributor maintenance, and roadside replication support. Works with monitoring operation center and other SLAM team members to oversee and monitor third party patching, deep-dive data analysis, Power BI report development and works with other teams to support databases across multiple platforms and computing environments.

Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, and optimizes to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.

Dimensions

Education:

Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

Experience:

5 years of IT work experience in DBA, SQL Procedural code and design, and relevant computing environments. Must be versatile in Oracle Procedural Language (PL-SQL) and Microsoft SQL (Transact-SQL)

Complexity: I

ntermediate professional level role. Supports team functions with medium to high complexity. Works on several projects as a project team member and at times, serves as a project leader. May be required to coach junior technical staff.