Senior Oracle Database Architect — Onsite, PL/SQL Lead

Sligo Software Solutions Inc.; City of Albany (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Sligo Software Solutions Inc. is seeking a senior Oracle/SQL Database Administrator to lead complex data infrastructures in a government-facing environment. You will design, optimize, and secure databases while collaborating with developers and business stakeholders.

The role requires 15+ years of Oracle/SQL experience, strong PL/SQL skills, and proven ability to migrate and tune large systems. Onsite in New York with heavy data governance and regulatory compliance responsibilities.

Qualifications

• Fifteen plus years of database experience with Oracle.
• Strong PL/SQL coding, stored procedures and packages.
• Experience upgrading legacy Oracle databases and partitioning.
• Proven ability to maintain PHI in health care contexts.
• Experience with Medicare/Medicaid cost reporting data is a plus.

Responsibilities

• Write PL/SQL queries and database migration scripts across environments.
• Develop automation scripts for maintenance and support.
• Compare databases across Development/QA/Production and align structures.
• Troubleshoot and performance tune database queries.
• Develop data interfaces with systems like SFS.
• Implement work-arounds for failed processes while applications are fixed.
• Assist other developers on database-related items.
• Translate business requirements into technical data models.

Skills

PL/SQL development

Database performance tuning

SQL scripting

Data modeling

Client interaction

Troubleshooting

Tools

Oracle

PL/SQL

SFS

PeopleSoft

Job description

Sligo Software Solutions Inc. is seeking a senior Oracle/SQL Database Administrator to lead complex data infrastructures in a government-facing environment. You will design, optimize, and secure databases while collaborating with developers and business stakeholders.

The role requires 15+ years of Oracle/SQL experience, strong PL/SQL skills, and proven ability to migrate and tune large systems. Onsite in New York with heavy data governance and regulatory compliance responsibilities.