Senior Data Specialist (Oracle)

Job description

Endava is looking for a Senior Data Specialist (Oracle) to design, develop, and support enterprise data solutions based on Oracle technologies. The role combines advanced PL/SQL development with database architecture, data integration, performance optimization, release management, and production support. You will collaborate with technical and business stakeholders to transform requirements into reliable, scalable, and maintainable solutions. Key responsibilities include: Design and develop complex PL/SQL procedures, packages, batch processes, and data-processing solutions. Build and maintain integrations between Oracle Database and external systems using REST, SOAP, HTTP, XML, and JSON. Develop automation and operational scripts using Bash, Python, and scheduling tools. Design and improve data archiving, retention, storage, and data-movement strategies. Monitor and optimize Oracle database performance, including query tuning and execution-plan analysis. Contribute to technical architecture, database design, data flows, logging, error handling, and operational standards. Analyze business and technical requirements and translate them into effective solution designs. Provide Level 3 support for production incidents, including troubleshooting, root-cause analysis, and preventive improvements. Support release planning, deployment activities, database migrations, and production stabilization. Contribute to containerized and machine-learning-enabled solutions where relevant. Work effectively across multiple priorities and take ownership of the stability and quality of delivered solutions. Experience with Oracle Database and advanced PL/SQL development. Strong knowledge of SQL performance tuning, execution plans, and database optimization techniques. Experience with batch processing, parallel processing, scheduling, archiving, partitioning, or data retention. Experience integrating databases with external systems and web services. Good knowledge of Bash scripting and practical experience with Python. Familiarity with XML, JSON, REST, SOAP, HTTP, and JWT authentication. Experience with version control, release management, and production deployments. Experience with Docker, scikit-learn, or Siebel EIM is considered an advantage. Ability to contribute to architectural decisions and design scalable, maintainable solutions. Strong analytical and problem-solving skills, particularly in production and performance-related scenarios. Excellent communication skills and the ability to work with both technical teams and business stakeholders. A strong sense of ownership, attention to quality, and ability to work effectively under pressure. Discover some of the global benefits that empower our people to become the best version of themselves: Finance: Competitive salary package, share plan, company performance bonuses, value-based recognition awards, referral bonus; Career Development: Career coaching, global career opportunities, non-linear career paths, internal development programmes for management and technical leadership; Learning Opportunities: Complex projects, rotations, internal tech communities, training, certifications, coaching, online learning platforms subscriptions, pass-it-on sessions, workshops, conferences; Work-Life Balance: Hybrid work and flexible working hours, employee assistance programme; Health: Global internal wellbeing programme, access to wellbeing apps; Community: Global internal tech communities, hobby clubs and interest groups, inclusion and diversity programmes, events and celebrations. At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know. Technology is our how. And people are our why. For over two decades, we have been harnessing technology to drive meaningful change. By combining world-class engineering, industry expertise and a people-centric mindset, we consult and partner with leading brands from various industries to create dynamic platforms and intelligent digital experiences that drive innovation and transform businesses. From prototype to real-world impact - be part of a global shift by doing work that matters.