insightsoftware
Principal Database Engineer - Oracle Modernization
insightsoftware, Raleigh, North Carolina, United States, 27601
Principal Database Engineer
We are seeking an experienced Principal Database Engineer to lead the modernization and optimization of our operational Oracle 19c transactional database platform that supports our equity compensation SaaS application. In this strategic technical leadership role you will analyze the current database architecture, identify opportunities for performance and scalability enhancements, architect modern data solutions, and drive the execution of key technical initiatives.
Responsibilities
Evaluate and lead efforts to normalize the database architecture and optimize data models for performance and scalability
Assess 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 application tiers in collaboration with engineering teams
Develop a database modernization roadmap for read‑optimization and tighter integration with modern BI tools
Lead strategic decisions on indexing, partitioning, and data lifecycle management
Evaluate and replace custom database deployment tools with enterprise‑grade solutions (DACPAC, Liquibase, Flyway, etc.)
Architect and implement robust database deployment pipelines across environments (Dev, QA, UAT, Prod)
Design and implement database CI/CD processes to ensure reliability, repeatability, and auditability of schema changes
Lead migration strategies from write‑optimized to read‑optimized architectures
Design and implement database observability, monitoring, and alerting solutions
Analyze and optimize long‑running queries and performance issues impacting customer experience
Develop proof‑of‑concepts for database modernization approaches and data architecture improvements
Implement normalization initiatives while maintaining system stability
Work hands‑on with Oracle 19c to solve immediate performance challenges while planning long‑term improvements
Collaborate with Solution Architect on data strategy and phased modernization approaches
Work closely with Principal Application Engineers to ensure application and database architectures are optimally aligned
Bridge the gap between development teams and database operations, translating application requirements into database design
Mentor and teach engineering teams on database best practices, performance optimization, and modern data patterns
Drive adoption of database standards and hold teams accountable to data quality and performance requirements
Qualifications
10+ years of hands‑on database engineering and architecture experience, with at least 5 years focused on enterprise‑scale database systems
8+ years deep Oracle database expertise (11g, 12c, 18c, 19c) including performance tuning, query optimization, and enterprise‑scale deployments
Proven track record of modernizing legacy database architectures and migrating business logic from databases to application tiers
Strong experience with database deployment automation, CI/CD pipelines, and enterprise database tooling
Experience with database normalization, data modeling, and designing for both transactional and analytical workloads
Understanding of read‑optimization patterns, indexing strategies, and integration with modern BI platforms
Expert‑level SQL and PL/SQL development and optimization skills
Experience with database deployment tools (Liquibase, Flyway, Redgate, or similar)
Knowledge of cloud database services, particularly Azure SQL Database, Azure Database for PostgreSQL, or similar
Experience with data migration strategies and zero‑downtime database changes
Understanding of database security, compliance, and enterprise data governance
Master’s degree in Computer Science, Engineering, or MBA with technical focus (preferred)
Background in financial services or equity compensation domain (preferred)
Experience with Oracle migrations to cloud‑native alternatives (preferred)
Knowledge of data observability platforms and modern monitoring practices (preferred)
Experience with large‑scale database transformations serving 1000+ enterprise clients (preferred)
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.
EEO & Sponsorship All information will be kept confidential according to EEO guidelines. At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located.
Learn More For additional details about our organization and the innovation powering insightsoftware, visit insightsoftware.com.
#J-18808-Ljbffr
Responsibilities
Evaluate and lead efforts to normalize the database architecture and optimize data models for performance and scalability
Assess 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 application tiers in collaboration with engineering teams
Develop a database modernization roadmap for read‑optimization and tighter integration with modern BI tools
Lead strategic decisions on indexing, partitioning, and data lifecycle management
Evaluate and replace custom database deployment tools with enterprise‑grade solutions (DACPAC, Liquibase, Flyway, etc.)
Architect and implement robust database deployment pipelines across environments (Dev, QA, UAT, Prod)
Design and implement database CI/CD processes to ensure reliability, repeatability, and auditability of schema changes
Lead migration strategies from write‑optimized to read‑optimized architectures
Design and implement database observability, monitoring, and alerting solutions
Analyze and optimize long‑running queries and performance issues impacting customer experience
Develop proof‑of‑concepts for database modernization approaches and data architecture improvements
Implement normalization initiatives while maintaining system stability
Work hands‑on with Oracle 19c to solve immediate performance challenges while planning long‑term improvements
Collaborate with Solution Architect on data strategy and phased modernization approaches
Work closely with Principal Application Engineers to ensure application and database architectures are optimally aligned
Bridge the gap between development teams and database operations, translating application requirements into database design
Mentor and teach engineering teams on database best practices, performance optimization, and modern data patterns
Drive adoption of database standards and hold teams accountable to data quality and performance requirements
Qualifications
10+ years of hands‑on database engineering and architecture experience, with at least 5 years focused on enterprise‑scale database systems
8+ years deep Oracle database expertise (11g, 12c, 18c, 19c) including performance tuning, query optimization, and enterprise‑scale deployments
Proven track record of modernizing legacy database architectures and migrating business logic from databases to application tiers
Strong experience with database deployment automation, CI/CD pipelines, and enterprise database tooling
Experience with database normalization, data modeling, and designing for both transactional and analytical workloads
Understanding of read‑optimization patterns, indexing strategies, and integration with modern BI platforms
Expert‑level SQL and PL/SQL development and optimization skills
Experience with database deployment tools (Liquibase, Flyway, Redgate, or similar)
Knowledge of cloud database services, particularly Azure SQL Database, Azure Database for PostgreSQL, or similar
Experience with data migration strategies and zero‑downtime database changes
Understanding of database security, compliance, and enterprise data governance
Master’s degree in Computer Science, Engineering, or MBA with technical focus (preferred)
Background in financial services or equity compensation domain (preferred)
Experience with Oracle migrations to cloud‑native alternatives (preferred)
Knowledge of data observability platforms and modern monitoring practices (preferred)
Experience with large‑scale database transformations serving 1000+ enterprise clients (preferred)
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.
EEO & Sponsorship All information will be kept confidential according to EEO guidelines. At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located.
Learn More For additional details about our organization and the innovation powering insightsoftware, visit insightsoftware.com.
#J-18808-Ljbffr