Database Analyst - SQL & Oracle

Cornerstonetechtalent; Florida; Sur place; USD 55 000 - 83 000; Plein temps

Résumé du poste

Cornerstonetechtalent is seeking an experienced Database Analyst to support enterprise database operations, SQL development, reporting, and infrastructure maintenance in a complex technology environment. This role requires strong Oracle PL/SQL and Microsoft SQL Server T-SQL skills, with responsibility across multiple platforms and environments, onsite in Ocoee, FL.

The ideal candidate will have at least 5 years of IT experience and a proven ability to manage migrations, monitoring, and Power BI

Qualifications

• 5+ years of IT experience involving database administration, SQL procedural programming, database design, or related computing environments.
• Strong hands-on experience with Oracle PL/SQL.
• Strong hands-on experience with Microsoft SQL Server T-SQL (Transact-SQL).
• Experience supporting and maintaining relational database environments.
• Knowledge of database architecture, schemas, data dictionaries, and data processing.
• Experience with database migrations, maintenance, and troubleshooting.
• Ability to analyze data requirements and develop or optimize database solutions.
• Strong analytical, troubleshooting, and problem-solving skills.
• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.

Responsabilités

• Support database administration, maintenance, and operational activities across multiple platforms and computing environments.
• Develop, maintain, and optimize SQL queries, stored procedures, and database-related processes.
• Work extensively with Oracle PL/SQL and Microsoft SQL Server T-SQL.
• Perform database migrations and support system deployments.
• Maintain SQL distribution processes and support database replication activities.
• Create, manage, and maintain KPIs, metrics, and operational reports.
• Develop and maintain Power BI reports to support business and operational analysis.
• Perform detailed data analysis to identify trends, discrepancies, and operational issues.
• Create and maintain database alerts and monitoring processes.
• Collaborate with technical teams to monitor database environments and coordinate third-party patching activities.
• Support vendor build deployments and hardware replacement activities.
• Analyze data requirements, database schemas, data dictionaries, and application architectures.
• Design, modify, and optimize database structures and processes to meet system requirements.
• Gather, analyze, and normalize business and operational data to ensure accuracy, relevance, and consistency.
• Participate in multiple technical projects and occasionally provide project leadership.
• Provide technical guidance to junior team members as needed.

Connaissances

Oracle PL/SQL

T-SQL

Database administration

Data analysis

Power BI

Formation

Bachelor's degree in Computer Science, Information Systems, or related field

Description du poste

Database Analyst – SQL & Oracle

Type: Contract

Location: Ocoee, FL

Work Setting: Fully Onsite (Not Remote or Hybrid)

Position Overview

We are seeking an experienced Database Analyst to support enterprise database operations, SQL development, reporting, and infrastructure maintenance within a complex technology environment. This position combines database administration, SQL development, data analysis, and operational support, with responsibilities spanning multiple database platforms and computing environments. The ideal candidate will have at least 5 years of relevant IT experience and strong technical proficiency in both Oracle PL/SQL and Microsoft SQL Server T-SQL.

Key Responsibilities

• Support database administration, maintenance, and operational activities across multiple platforms and computing environments.


• Develop, maintain, and optimize SQL queries, stored procedures, and database-related processes.


• Work extensively with Oracle PL/SQL and Microsoft SQL Server T-SQL.


• Perform database migrations and support system deployments.


• Maintain SQL distribution processes and support database replication activities.


• Create, manage, and maintain key performance indicators (KPIs), metrics, and operational reports.


• Develop and maintain Power BI reports to support business and operational analysis.


• Perform detailed data analysis to identify trends, discrepancies, and operational issues.


• Create and maintain database alerts and monitoring processes.


• Collaborate with technical teams to monitor database environments and coordinate third-party patching activities.


• Support vendor build deployments and hardware replacement activities.


• Analyze data requirements, database schemas, data dictionaries, and application architectures.


• Design, modify, and optimize database structures and processes to meet system requirements.


• Gather, analyze, and normalize business and operational data to ensure accuracy, relevance, and consistency.


• Participate in multiple technical projects and occasionally provide project leadership.


• Provide technical guidance to junior team members as needed.

Required Qualifications

• 5+ years of IT experience involving database administration, SQL procedural programming, database design, or related computing environments.


• Strong hands-on experience with Oracle PL/SQL.


• Strong hands-on experience with Microsoft SQL Server T-SQL (Transact-SQL).


• Experience supporting and maintaining relational database environments.


• Knowledge of database architecture, schemas, data dictionaries, and data processing.


• Experience with database migrations, maintenance, and troubleshooting.


• Ability to analyze data requirements and develop or optimize database solutions.


• Strong analytical, troubleshooting, and problem-solving skills.


• Ability to work collaboratively with technical teams across multiple projects.


• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.

Preferred Qualifications

• Experience with Power BI reporting and dashboard development.


• Experience creating and maintaining operational KPIs and metrics.


• Knowledge of SQL distribution and database replication processes.


• Experience supporting database monitoring, alerting, and patching activities.


• Experience with vendor deployments and infrastructure-related database support.


• Experience working in complex, multiplatform technology environments.


• Previous experience supporting transportation, infrastructure, or other operational systems.

Ideal Candidate

The ideal candidate is a hands-on database professional who is comfortable working across Oracle and Microsoft SQL Server environments, combining strong SQL development capabilities with database administration and operational troubleshooting. This individual should be experienced in PL/SQL and T-SQL, capable of supporting database migrations and replication processes, and comfortable developing reports and analyzing data to support operational decision-making. The position is particularly well suited for someone who enjoys balancing technical database responsibilities with reporting, system maintenance, and cross-functional collaboration.

Additional Information

Fully onsite position in Ocoee, Florida.

Remote and hybrid arrangements are not available.

A Level 1 background check is required prior to starting.

Interviews may be conducted virtually through Microsoft Teams.