Senior Data System Software engineer: Oracle Database 26ai and client drivers System Test Engineering
Database Product Development | Senior Lead or Principal Level
Role summary This role combines hands-on Oracle database development with component, integration, system, stress, and performance testing. The engineer will build automated test solutions for Oracle Database 26ai, Oracle client drivers, converged database features, and the major Oracle client drivers on Windows and Linux.
Team and mission
The SHARP VLDB organisation improves the scalability, high availability, reliability, and performance of Oracle Database and cloud services. The team designs realistic, high-volume and highly concurrent workloads that expose product defects and architectural limitations before release. Engineers work closely with database kernel, feature, client drivers, cloud, and support teams to reproduce issues, verify fixes, and strengthen product quality across on-premises and cloud deployments.
Role at a glance
- Primary focus
- Database feature development and cross-platform system test engineering
- Target database
- Oracle Database 26ai with vector and AI capabilities
Platforms
- Windows Server and Linux, including cross-platform compatibility and interoperability
- Database areas
- XDB, JSON, Oracle Text, SQL and PL/SQL, multitenant and high availability
- ODAC scope
- ODP.NET Core, Managed and Unmanaged providers and related ODAC components
- Client drivers
- python-oracledb, node-oracledb, OCI-C driver and JDBC
- Test coverage
- Functional, integration, compatibility, upgrade, patch, system, stress, performance and resiliency
- Design and develop production-scale database schemas, data generators, workload drivers, and application logic using SQL, PL/SQL, Python, Java, JavaScript or Node.js, C/C++, and C# as appropriate.
- Create highly automated end-to-end test suites that simulate large enterprise applications, high concurrency, long-duration operation, mixed workloads, and very large databases.
- Review Oracle Database 26ai feature designs and translate functional and architectural requirements into test strategies, coverage matrices, test specifications, and reusable automation.
- Validate Oracle Database 26ai vector and AI capabilities, including vector data types, vector indexes, similarity search, hybrid vector and text scenarios, embedding workflows, concurrency, correctness, performance, and upgrade compatibility.
- Develop comprehensive coverage for XDB and XML processing, JSON data management and APIs, and Oracle Text indexing, search, synchronization, security, and mixed-workload interoperability.
- Test ODAC and ODP.NET components across Windows and Linux, including platform-appropriate ODP.NET Core, Managed, and Unmanaged provider scenarios, connection management, pooling, transactions, data type mappings, high availability, security, and framework integration.
- Build a consistent cross-driver test matrix for python-oracledb, node-oracledb, OCI C, and JDBC to validate feature parity, protocol behavior, data type support, error handling, failover, performance, and backward compatibility.
- Exercise client and server combinations across Windows and Linux, including installation, configuration, networking, TLS, authentication, character sets, file systems, process and memory behavior, and operating-system-specific regressions.
- Test Release Updates, one-off patches, client upgrades, rolling maintenance, database upgrades, and mixed-version scenarios while preserving data correctness and service availability.
- Execute tests on standalone databases, multitenant CDB and PDB environments, RAC and ASM clusters, Data Guard configurations, Exadata, and cloud or Autonomous Database environments as applicable.
- Develop monitoring and diagnostics for database, operating system, network, application, and client layers; analyze traces, dumps, logs, wait events, execution plans, memory usage, and performance profiles.
- File high-quality defects with reproducible evidence, isolate failures to the responsible layer, collaborate with development teams on root cause, and verify fixes across platforms and client stacks.
- Enhance test frameworks based on customer escalations and field defects, and participate in feature reviews, certification exercises, documentation reviews, and quality readiness assessments.
Core technical scope
Area
Technologies
- Expected coverage
- Database features
- XDB XML, JSON, Oracle Text, SQL, PL/SQL, Multitenant
- Correctness, interoperability, security, concurrency, upgrade and performance
- AI and vector
- Vector types, indexes, similarity and hybrid search, AI workflows
- Accuracy, scale, performance, resiliency and client accessibility
- ODAC and .NET
- ODP.NET Core, Managed and Unmanaged providers
- Windows and Linux component behavior, pooling, transactions, HA and data types
- Client drivers
- python-oracledb, node-oracledb, OCI C and JDBC
- Feature parity, compatibility, error handling, failover and throughput
Platforms
- Windows Server, Linux, RAC, ASM, Data Guard and cloud
- Installation, networking, security, resource behavior and lifecycle operations
- Required qualifications
- Bachelor’s or master’s degree in Computer Science, Computer Engineering, Electronics, or a related discipline, or equivalent professional experience.
- Strong Oracle Database development experience with SQL, PL/SQL, schema and physical design, transaction processing, concurrency, diagnostics, and performance tuning.
- Experience developing or testing database client applications using at least two of the following: Python, Node.js, C/C++, Java, or C# and .NET.
- Practical knowledge of client-server database architecture, Oracle Net connectivity, connection pooling, transactions, data type conversion, error handling, and high-availability behavior.
- Strong Windows and Linux engineering skills, including services and processes, networking, file systems, security, automation, resource monitoring, and troubleshooting.
- Experience designing automated functional, integration, system, stress, or performance tests and diagnosing failures across multiple software layers.
- Ability to read feature designs, identify risk areas, create measurable coverage, and produce maintainable test code and clear defect reports.
- Experience with source control and continuous integration practices, such as Git, build pipelines, automated regression execution, and artifact management.
- Clear written and verbal communication, strong analytical skills, attention to detail, and the ability to collaborate across geographically distributed engineering teams.
Preferred experience
•Expert Oracle Design/Development/Principal DBAs (OR) Lead/Principal Oracle DB Developers with sound
Oracle DB Application Development cum DBA Full-Life cycle experience ranging from 4-12 years.
- Oracle Database 23ai or 26ai, AI Vector Search, machine learning or embedding-based applications, and performance evaluation of AI-assisted database workloads.
- ODAC, ODP.NET, .NET and .NET Core, Entity Framework Core, ADO.NET, ASP.NET, IIS, Visual Studio, and Windows application diagnostics.
- python-oracledb Thin and Thick modes, node-oracledb, OCI C interfaces, JDBC Thin or OCI modes, and cross-driver compatibility testing.
- Oracle XDB and XML, native JSON capabilities, Oracle Text, search indexing, document-oriented applications, and mixed JSON relational workloads.
- Oracle RAC, ASM, Data Guard, Multitenant, Exadata, Autonomous Database, Database Cloud Services, or Oracle Cloud Infrastructure.
- PowerShell, shell, Python automation, REST APIs, container platforms, orchestration, observability, and infrastructure-as-code tools.
- Experience analyzing customer escalations or post-release defects and converting them into durable automated regression coverage.
Range and benefit information provided in this posting are specific to the stated locations only
IN: Hiring Range in INR from: 1,832,007 to 3,140,585 per annum.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
Range and benefit information provided in this posting are specific to the stated locations only
IN: Hiring Range in INR from: 1,832,007 to 3,140,585 per annum.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
As part of Oracle’s onboarding process and consistent with applicable law, India-based employees are required to complete identity verification, which involves the collection and processing of their biometric information. Accommodations to this requirement may be granted following an individualized assessment.
Job description provided by Oracle.
View the original posting