Database Architect

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 is a premier implementer of cutting-edge software solutions. Synergy brings the experience and expertise necessary to deliver capability that provides tangible ROI to our customers. Our core areas of expertise are in the fields of Digital Transformation, Cloud Solutions, SaaS and Low-Code/No-Code Solutions, Emerging Technologies, Data Analytics and Visualization, Information Assurance, and Business Process Re-Engineering.

Synergy offers its employees a generous portfolio of core and voluntary benefits including: group medical, dental, and vision insurance, company paid life, short-term, and long-term disability insurance, HSA, FSA, 401(k) with company match, PTO & Bonus Leave, 11 paid federal holidays, parental leave, tuition and training reimbursement, a referral bonus program, and well-being programs.

At Synergy, you’ll be challenged and given the opportunity to grow in your career path. In fact, growth is such a big deal to us that we have career mentors available for every employee, company-funded certification opportunities, education reimbursement, and a general open-door policy so that you have support when you need it. Our team is eager to learn, fast-paced, and quality-driven. If that sounds like you, Synergy has a position for you!

Role Overview

• Design and develop databases, schemas, PL/SQL, SQL*Plus, and scripts.
• Support Agile modernization of legacy systems, including Oracle SDO/Esri → PostgreSQL/PostGIS migrations.
• Work independently with strong analytical and problem‑solving skills.
• Develop, implement, and test software on a modernized technology stack.

Key Responsibilities

• Translate requirements with product owners, analysts, and design leads.
• Create tables, views, procedures, and scripts for web application support.
• Write and optimize complex SQL queries to support application
• Participate in Agile development processes and ability to adapt to changing requirements
• Lead on‑premise → cloud database migration efforts.
• Establish scalable enterprise database architecture and standards.
• Implement EA principles for cost reduction, security, and performance improvements.
• Serve as technical lead across multiple projects; define architecture and quality procedures.
• Advise clients on secure, scalable database architecture.
• Collaborate with management across multiple departments and functional areas.

Core Competencies

Architecture & Modeling

• Logical/physical/conceptual data modeling; ERWin/Lucidchart/Visio use.
• Schema design for OLTP/reporting workloads; enforcement of DB standards.

PostgreSQL & PostGIS

• PL/pgSQL scripting; indexing/partitioning; vacuum/maintenance tuning.
• Spatial data modeling, transformation, optimization.

Oracle & PL/SQL

• Advanced PL/SQL (packages, triggers, procedures).
• Bulk operations, tuning, SDO spatial experience; complex hierarchical queries.

Cloud & Infrastructure

• Cloud‑ready DB designs (AWS/Azure/OCI).
• HA/DR strategies, IAM/security models, cloud migration tooling (AWS DMS, ETL pipelines).

ETL & Data Migration

• ETL tools (ODI, SSIS, Informatica); custom migration scripts.
• Data validation, reconciliation, cutover/rollback planning.

DevOps / CI/CD

• Automated DB deployments (Liquibase, Flyway, Jenkins, GitLab CI).
• Version control for DB artifacts; automated unit testing.

Performance & Monitoring

• SQL optimization, plan analysis; Splunk/CloudWatch/Oracle monitoring.
• Troubleshooting large‑scale performance bottlenecks.

Leadership

• Mentor developers; lead Agile technical decision‑making.
• Define coding standards, architecture reviews, and best practices.

Soft Skills

• Strong communication, stakeholder alignment, analytical thinking.
• Ability to make independent architecture decisions across projects.

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.

Education/Certification Requirements:

• A BS degree in Information Technology, Cybersecurity, Data Science, Information Systems, or Computer Science, from an ABET accredited or CAE designated institution fulfills the educational requirement . Note: The U.S. Department of Education Database of Accredited Postsecondary Institutions and Programs located at https://amspub.abet.org/aps/name-search?searchType=institution identifies accredited postsecondary institutions. In Lieu of education requirement listed, candidate must have the required certification or will obtain required certification within 6 months of the start date. Certification requirement(s) for this role is AN IASAE II certification (CASP+CE, CLSSP associate) or CSSLP.

Citizenship & Clearance Requirements:

• Ability to attain Federal Government Position of Trust. Ability to obtain a public trust clearance.
• Must be a U.S. citizen
• Must pass a background investigation

Target Salary Range

Compensation for roles at Synergy is determined by a variety of factors including, but not limited to, the requirements of the role; level of experience; education and certifications; the individual’s combination of knowledge, skills, and abilities; as well as alignment with market data, federal and state laws, and other business and contract considerations. The estimated pay range for this position is: $157,500.00 – $190,000.00. The disclosed range has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. It is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each case and represent just one component of Synergy’s total compensation package for employees.

Candidate AI Policy

Synergy is committed to the responsible and ethical use of AI tools. However, we want to ensure a fair candidate evaluation process based on your own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) or other tools to assist with responses during interviews (whether in-person or virtual) is prohibited unless permission is explicitly granted. You are expected to be on camera during interviews and assessments. We reserve the right to take your picture to verify your identity and prevent fraud.

#LI-Remote

Synergy is an equal opportunity employer and does not discriminate against applicants for employment or its employees on the basis of age, race (including hair texture/style), creed, color, religion, religious creed, ancestry, national origin, ethnic origin, sexual orientation, gender identity or expression, military or veteran status, sex, medical condition, pregnancy (childbirth, breastfeeding, and related medical conditions), physical or mental disability, personal appearance, organ donation and hair length associated with race, genetic information or characteristics, family responsibilities, familial status, marital status, citizenship or immigration status, status as a victim of domestic violence, a sexual offense, or stalking, political affiliation, arrest records and criminal convictions, credit information, matriculation, homeless status, or any other characteristic protected by federal, state and local law. Discrimination or harassment based upon these protected categories is expressly prohibited. This policy applies to all aspects of employment, including job selection, assignment, promotion, compensation, benefits, training, discipline, and termination.