Senior Data Architect – Cloud, PostgreSQL & PostGIS

Synergy Business Innovation & Solutions, Inc.; Northern (KY); Hybrid; USD 158,000 - 190,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

HSA

FSA

401(k) with company match

PTO & Bonus Leave

11 paid federal holidays

Parental leave

Tuition reimbursement

Certification reimbursement

Referral program

Well-being programs

Job summary

Synergy Business Innovation & Solutions, Inc. is seeking an experienced database professional to design databases, schemas, PL/SQL, and SQL*Plus scripts; support Agile modernization of legacy systems, including Oracle SDO/Esri → PostgreSQL/PostGIS migrations; and develop, implement, and test software on a modernized stack.

The role leads technical decisions, mentors developers, and advises clients on secure, scalable database architecture while driving on‑premise to cloud migrations and

Qualifications

• 7+ years Oracle development (tables, views, procedures, scripts).
• 5+ years SQL/PLSQL; Oracle 19 experience.
• PL/SQL unit testing experience.
• PostgreSQL experience.
• Enterprise-wide application development.
• Strong communication with management and development teams.

Responsibilities

• Design and develop databases, schemas, PL/SQL, SQL*Plus, and scripts.
• Lead Agile modernization of legacy systems and migrations to PostgreSQL/PostGIS.
• Collaborate with product owners, analysts, and design leads to translate requirements.
• Establish scalable enterprise database architecture and standards.
• Advise clients on secure, scalable database architecture.
• Serve as technical lead across multiple projects and define architecture and quality procedures.

Skills

Oracle development

SQL/PLSQL

PostgreSQL/PostGIS

Data modeling

Cloud migrations

Agile

Leadership

Mentoring

Communication

Problem-solving

Education

BS in Information Technology or related field

IASAE II certification or CSSLP

Tools

Oracle SDO

PostGIS

Liquibase/Flyway

Jenkins/GitLab CI

AWS/Azure/OCI

Job description

Synergy Business Innovation & Solutions, Inc. is seeking an experienced database professional to design databases, schemas, PL/SQL, and SQL*Plus scripts; support Agile modernization of legacy systems, including Oracle SDO/Esri → PostgreSQL/PostGIS migrations; and develop, implement, and test software on a modernized stack.

The role leads technical decisions, mentors developers, and advises clients on secure, scalable database architecture while driving on‑premise to cloud migrations and