Senior Development DBA

insightsoftware, LLC; India; Remote; INR 1,200,000 - 2,400,000; Full time

Job summary

insightsoftware is a global provider of financial reporting and analytics solutions. We seek an Oracle Database Administrator focused on performance tuning and query optimization to join our teams.

You will act as a performance SME embedded with development groups, driving improvements across schema, indexing, and execution plans. This role involves partnering with DevOps and other engineers to modernize deployments, implement observability, and enable cloud-native patterns while maintaining

Qualifications

• 5-7 years hands-on database engineering and architecture experience.
• 6+ years Oracle database expertise including performance tuning and query optimization.
• Experience with database deployment automation, CI/CD pipelines, and enterprise tooling.
• Knowledge of read-optimization patterns, indexing strategies, and BI integration.

Responsibilities

• Optimize long-running queries and overall database performance across environments.
• Lead modernization and tooling efforts (Liquibase, Flyway, DACPAC) for deployments.
• Collaborate with solution architects and engineers to align data architectures with applications.
• Mentor teams on best practices in data engineering and performance.

Job description

About Us

insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.

Job Description

Company Description Insightsoftware is a growing, dynamic computer software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. At Insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for future Insighters who can demonstrate teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team!

About the Role

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 optimization 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 behaviour and application workloads. You will work closely with development, DevOps, and infrastructure teams to ensure our databases operate at peak efficiency across all environments.

Responsibilities

• Database Strategy:
  • Evaluate and lead efforts to optimize data models for performance and scalability.
  • Assess current database bottlenecks, long-running queries, and performance issues, designing and implementing optimization strategies.
  • 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).
  • 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 5-7 years of hands-on database engineering and architecture experience, with at least 5 years focused on enterprise-scale database systems.
• Database Performance Tuning and Development Experience:
  • 6+ 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.
  • 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.
• Strong experience with database deployment tools (Liquibase, Flyway, Redgate, or similar enterprise solutions).
• Experience with database normalization, data modeling, and designing for both transactional and analytical workloads.
• 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-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.
• 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

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

Additional Information

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

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.

Learn more at insightsoftware.com.