Oracle PLSQL Developer Database Developer

Required Skills:

We are seeking Senior Oracle PL/SQL Developers with approximately 1015 years of experience and most importantly deep current hands-on PL/SQL development expertise. This role is highly technical. Candidates should be able to demonstrate strong practical knowledge during technical interviews and provide thoughtful solutions to real-world day-to-day engineering problems. This is not a management-focused position; the team is specifically looking for engineers who remain actively hands-on with Oracle SQL/PLSQL development. Key Responsibilities Design develop test and maintain complex Oracle SQL and PL/SQL solutions. Develop complex stored procedures packages database business logic custom data types and transactional data models. Perform advanced SQL development data analysis data modeling and data manipulation. Design and implement data APIs and database-centric solutions. Analyze and optimize database performance. Develop and maintain batch processing jobs using technologies such as ETL/Informatica and Autosys. Translate business requirements storyboards and use cases into scalable and maintainable software solutions. Participate in application design design reviews and code reviews. Develop automated test cases and participate in regression testing. Contribute to engineering practices involving ATDD CI/CD and continuous delivery. Collaborate with distributed/global development teams. Provide technical guidance and mentorship to other team members. Contribute directly to the codebase while working with cross-functional teams and stakeholders. Must-Have Skills Oracle PL/SQL Engineering Strong hands-on experience developing Oracle SQL and PL/SQL. Development of complex: Stored procedures Packages Database business logic Custom data types Transactional data models Advanced SQL & Data Manipulation Analytical and windowing functions. Complex joins and aggregations. Set operators. Subqueries and query optimization. Strong data analysis and data modeling capabilities. Database Performance Tuning Query optimization. Reading and analyzing execution plans. Database diagnostics. PGA memory tuning. Partitioning strategies. Additional Technical Experience ETL / Informatica. Autosys and batch job development. Data API design and implementation. Understanding of scalable application design principles. Knowledge of mid-tier technologies such as Java. Familiarity with messaging technologies and web containers. Understanding of how mid-tier technologies interact with databases. CI/CD processes and tools. Agile software development. Ideal Candidate The ideal candidate is a senior-level engineer who is still 100% hands-on with PL/SQL and can confidently engage in deep technical discussions. Candidates should be able to: Solve practical database and software engineering problems. Explain technical decisions and trade-offs. Demonstrate current deep PL/SQL expertise. Work independently while collaborating effectively with a global team. Contribute to engineering excellence and continuous improvement. Mentor team members while remaining actively involved in development.