insightsoftware · 3 days ago
Principal Database Engineer - Oracle Modernization
United States
Full-time
Remote
Lead/Staff
10+ years expinsightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data. They are seeking a Principal Database Engineer specializing in database architecture and modernization to lead optimization initiatives and modernize their Oracle database systems to support cloud capabilities and enhance integration with modern BI platforms.
AccountingAnalyticsBusiness IntelligenceConsultingFinancial ServicesSoftware
Responsibilities
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
Evaluate and replace our custom-built database deployment tool with enterprise-grade solutions (DACPAC, Liquibase, Flyway, or similar)
Design and implement robust database deployment pipelines across multiple environments (Dev, QA, UAT, Prod)
Architect database CI/CD processes that ensure reliability, repeatability, and auditability of schema changes
Lead database 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 database performance issues impacting customer experience
Design and implement database changes that support cloud-native application patterns
Develop proof-of-concepts for database modernization approaches and data architecture improvements
Implement database 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 database 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
Lead by example through hands-on technical contributions while inspiring others to embrace modern data engineering practices
Qualification
Required
Minimum 10+ years of hands-on database engineering and architecture experience, with at least 5 years focused on enterprise-scale database systems
8+ years of deep Oracle database expertise (Oracle 11g, 12c, 18c, or 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
Bachelor's degree in Computer Science, Engineering, or equivalent work experience
Expert-level SQL and PL/SQL development and optimization skills
Experience with database deployment tools (Liquibase, Flyway, Redgate, or similar enterprise solutions)
Strong understanding of database performance monitoring, query analysis, and execution plan optimization
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
Experience transforming databases from on-premise to cloud-optimized patterns
Knowledge of modern data architecture patterns including data warehousing and analytics optimization
Experience integrating databases with modern BI tools (Power BI, Tableau, etc.)
Understanding of microservices data patterns and distributed data architectures
Proven ability to influence and drive change across development and operations teams
Strong communication and teaching skills with ability to mentor senior engineers and hold teams accountable to standards
Demonstrated ability to lead through influence rather than authority, driving adoption of modern data practices
Experience building consensus and driving technical decisions across diverse engineering teams
Track record of transforming team approaches from legacy to modern data engineering practices
Preferred
Master's degree in Computer Science, Engineering, or MBA with technical focus
Background in financial services or equity compensation domain
Experience with Oracle migrations to cloud-native alternatives
Knowledge of data observability platforms and modern monitoring practices
Experience with large-scale database transformations serving 1000+ enterprise clients
Company
insightsoftware
insightsoftware is the most comprehensive provider of solutions for the Office of the CFO.
1001-5000 employees
H1B Sponsorship
insightsoftware has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (3)
2023 (3)
2022 (4)
Funding
Current Stage
Late StageTotal Funding
$1BKey Investors
Hg
2021-07-13Private Equity· $1B
2019-08-15Private Equity
2018-06-14Acquired
Leadership Team
Bernie Emsley
Chief Technology Officer
Meg Christman
Executive Vice President Delivery Services
Recent News
Business Wire
2025-12-09
Company data provided by crunchbase