Principal Database Engineer Oracle Modernization

As a Principal Database Engineer specializing in database architecture optimization and modernization you will serve as the technical authority for all database initiatives across the Equity Management platform reporting to the Sr Director of Engineering and working closely with the Solution Architect. This is a specialized technical leadership role that combines strategic data architecture thought leadership with hands-on implementation and influential team leadership - youll analyze our current Oracle database architecture identify optimization opportunities and architect its transformation into a modern performant data platform while rolling up your sleeves to execute key technical implementations. Youll need to not only identify and implement solutions but also teach influence drive change and hold teams accountable to data engineering standards and best practices.

Important : This is an application database architecture role NOT a data warehousing ETL / ELT pipeline or analytics platform engineering position. We have separate teams handling data warehousing and BI infrastructure. This role focuses exclusively on our operational Oracle 19c transactional database that powers our equity compensation SaaS application - optimizing its performance modernizing its architecture and supporting application development teams.

You will be joining the team at a pivotal transformation point as we modernize our data architecture to fully leverage cloud capabilities and support next-generation analytics. We are looking for someone who can evaluate our current Oracle database architecture lead optimization initiatives for performance and scalability and architect solutions that enhance integration with modern BI platforms. Youll work day-to-day with our Solution Architect and team of Principal Engineers to set the data roadmap and execute the transformation of our database systems.

This role focuses on operational database architecture and OLTP performance optimization - not data science or analytics. Youll bridge the gap between application development and data operations ensuring our database infrastructure supports both current operations for existing 1200 enterprise clients and future cloud-native capabilities.

Responsibilities

Database Architecture & Strategy :

• Evaluate and lead efforts to normalize the database architecture and optimize data models for performance and scalability
• Assess current database bottlenecks long-running queries and performance issues designing and implementing optimization strategies
• Design data architecture patterns to migrate business logic from Oracle stored procedures to proper application tiers in collaboration with application engineers
• Develop database modernization roadmap for read-optimization and tighter integration with modern BI tools
• Lead strategic decisions on database patterns indexing strategies partitioning and data lifecycle management

Database Modernization & Tooling :

Hands-On Implementation & Optimization :

Cross-Team Collaboration & Technical Leadership :

Qualifications :

Minimum 10 years of hands-on database engineering and architecture experience with at least 5 years focused on enterprise-scale database systems

Database Architecture & Engineering Experience :

Core Technical Skills :

Modernization & Cloud Experience :

Collaboration & Technical Leadership :

Preferred Qualifications :

Additional Information :

The ideal candidate combines deep Oracle database expertise with modern data architecture knowledge - someone who can understand complex legacy database systems while architecting their transformation into performant scalable cloud-optimized data platforms that support both operational excellence and modern analytics capabilities.

All your information will be kept confidential according to EEO guidelines.

Learn more about our high-energy high-performance global team. Work With Us

insightsoftware About Us : Hear From Our Team - InsightSoftware ()

Background checks are required for employment with insightsoftware where permitted by country state / province.

At insightsoftware we are committed to equal employment opportunity regardless of race color ethnicity ancestry religion national origin gender sex gender identity or expression sexual orientation age citizenship marital or parental status disability veteran status or other class protected by applicable law. We are proud to be an equal opportunity workplace.

Remote Work : Yes

Key Skills

Children Activity,Cost Accounting,Feed,Corporate Strategy,ERP

Employment Type : Remote

Experience : years

Vacancy : 1