Senior Development DBA

insightsoftware$99K — $124K *
US-AnywhereRemote in United States
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 10+ years of hands-on database engineering and architecture experience, with at least 5 years on enterprise-scale database systems.
  • 8+ years of deep Oracle database expertise in performance tuning, query optimization, and execution plan analysis.
  • Strong track record of modernizing legacy database architectures and migrating business logic to application tiers.
  • Experience with database deployment automation and CI/CD pipelines.
  • Bachelor's degree in Computer Science, Engineering, or equivalent work experience.

Responsibilities

  • Evaluate and optimize the database architecture for performance and scalability.
  • Design and implement strategies to address database bottlenecks and performance issues.
  • Lead the normalization of database models and develop a modernization roadmap.
  • Collaborate with application engineers to migrate business logic out of Oracle stored procedures.
  • Architect and oversee database CI/CD processes and deployment tooling.

Benefits

  • Opportunity to influence and lead modernization efforts in a pivotal transformation period.
  • Collaboration with cross-functional teams including development and infrastructure.
  • Hands-on execution combined with strategic data architecture responsibilities.
  • A chance to mentor and drive adoption of database best practices.
  • Engagement with modern BI tools and cloud capabilities to enhance data integration.
Full Job Description
Job Description:

We are looking for an Oracle Database Administrator with a primary focus on Performance Tuning and Query optimization to join our team. In this role, your primary focus will be database performance tuning across the full development lifecycle - from early schema and query design through production optimization. This is not a traditional DBA role; day-to-day responsibilities will center on performance engineering rather than routine database administration tasks such as backups, patching, or user management.

You will serve as the performance subject matter expert embedded within our development teams, reviewing code and data access patterns before they reach production and driving a culture of performance-aware development. You will be expected to proactively identify inefficiencies, respond to performance incidents, and deliver concrete, measurable improvements to query response times, throughput, and resource utilization.

Success in this role requires a deep understanding of how databases execute queries under the hood - including execution plan analysis, index internals, wait statistics, and the interplay between database behavior and application workloads. You will work closely with development, DevOps, and infrastructure teams to ensure our databases operate at peak efficiency across all environments.

What you'll do:
As an Oracle Database Administrator specializing in database performance and query optimization, you will serve as the technical authority for all database initiatives across the Equity Management platform, reporting to the Manager of Database Administration and working closely with the DevOps teams. This is a specialized technical role that combines strategic data architecture thought leadership with hands-on implementation - you'll 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. You'll 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.

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. You'll work day-to-day with our DBAs, Solution Architect, and team of Principal Engineers to execute the transformation of our database systems.

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:
  • 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.


Hands-On Implementation & Optimization:
  • Analyze and optimize long-running queries and database performance issues impacting customer experience with the ability to refactor/rewrite complex queries where needed.
  • 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.


Cross-Team Collaboration & Technical Leadership:
  • 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


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:
  • 8+ years of deep Oracle database expertise including performance tuning, query optimization, enterprise-scale deployments, and a deep understanding of execution plans and rewriting complex SQL statements for performance improvement.
  • 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


Core Technical Skills:
  • 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.


Modernization & Cloud Experience:
  • Experience transforming databases from on-premises 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.


Collaboration & Technical Leadership:
  • 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 Qualifications:
  • 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.


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.

The salary range in United States of America for this position is 99,000.00 to 124,000.00 USD Annual.

Your specific offer within this range will be determined by your skills, experience, and qualifications. For non-sales roles, you may be eligible for a bonus. For sales roles, this range includes a commission target.

We are committed to pay transparency and fair compensation practices. If you have questions about our compensation approach, please don't hesitate to ask during the interview process.

Additional Information

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

insightsoftware About Us: Hear From Our Team

About insightsoftware

insightsoftware is a leading provider of financial reporting and enterprise performance management software. The company was founded in 2018 and is headquartered in Raleigh, North Carolina. insightsoftware's software solutions help businesses of all sizes improve their financial reporting and analysis capabilities. The company has over 500 employees and serves clients across the United States and internationally.
Learn more about insightsoftware
Size
500 employees
Industry
Net Income
-$10 million
Founded
2018
5 Year Trend
+50%
Revenue
$100 million

Similar Jobs

More Jobs at insightsoftware

More Information Technology Jobs

Find similar Senior Development DBA jobs: