Senior Oracle PL/SQL Architect & Data Solutions Lead

Jobtailor; Town of Florida (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Jobtailor seeks an experienced Oracle Database Developer to design and deliver high-performance Oracle solutions in production environments. You’ll optimize queries, implement ETL pipelines, and integrate deployments into CI/CD workflows, collaborating with analytics and engineering teams.

Ideal candidates have 5+ years of hands-on Oracle development, strong SQL/PLSQL skills, and cloud experience with OCI/AWS/Azure. Relocation support may be available for the right candidate.

Qualifications

• Bachelor’s degree in computer science, information technology, or a related field or equivalent experience.
• 5+ years of hands-on Oracle development.
• Experience designing and delivering complex database solutions in production environments.
• Advanced proficiency in SQL and PL/SQL.
• Complex query design, table design, data analysis, and table partitioning.
• Database performance tuning, including execution plan analysis, indexing strategies, partitioning techniques, and Oracle monitoring and diagnostic tools.
• Exposure to OCI, AWS, or Azure and cloud-hosted database architectures, deployment models, and operational best practices.
• Familiarity with Agile development methodologies and sprint-based workflows.
• Ability to collaborate across engineering, business, and analytical teams.
• Must be authorized to work in the U.S.; Citi will not sponsor U.S. work authorization
• Must be located within commuting distance or willing to relocate to the area.

Responsibilities

• Design and build high-performance Oracle database solutions.
• Develop and maintain ETL workflows, data transformation pipelines, validation frameworks, and batch processing solutions.
• Create and manage database migration scripts, schema updates, and automated deployment packages.
• Tune and optimize database performance using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic tools.
• Build and maintain database unit tests, regression tests, and data validation tests.
• Integrate database solutions into CI/CD pipelines with automated testing, deployment, and monitoring.
• Use AI-powered development tools, including GitHub Copilot, for SQL and PL/SQL development, code review, documentation, and knowledge sharing.
• Partner with business analysts and stakeholders to capture requirements and translate them into technical specifications.

Skills

Oracle Database Development

SQL and PL/SQL Proficiency

Database Performance Tuning

ETL Workflow Development

Cloud Database Architecture

Education

Bachelor’s degree in computer science, information technology, or a related field or equivalent experience

Tools

GitHub Copilot

Oracle Diagnostic Tools

CI/CD Pipelines

Agile Methodologies

AWS

Azure

OCI

Job description

Jobtailor seeks an experienced Oracle Database Developer to design and deliver high-performance Oracle solutions in production environments. You’ll optimize queries, implement ETL pipelines, and integrate deployments into CI/CD workflows, collaborating with analytics and engineering teams.

Ideal candidates have 5+ years of hands-on Oracle development, strong SQL/PLSQL skills, and cloud experience with OCI/AWS/Azure. Relocation support may be available for the right candidate.