Oracle Database Developer (ADB-S / OCI) (India)

Job Type: Full Time Experience: 4 to 5 years Locations: Trivandrum - IN Categories: IT About the Role We are looking for a skilled Oracle Database Developer with strong administration exposure to join our team, working primarily on Oracle Autonomous Database (ADB-S) in Oracle Cloud Infrastructure (OCI). The ideal candidate will have hands-on expertise in PL/SQL development, data modelling, and query optimisation, along with working knowledge of managing and securing cloud-native Oracle databases. This role is development-focused, with administration responsibilities largely centred on cloud-managed environments rather than traditional on-premises DBA tasks. Key Responsibilities - Database Development (Primary Focus) - Design, develop, test, and maintain Oracle database objects tables, views, indexes, sequences, triggers, packages, procedures, and functions on Oracle ADB-S. - Develop efficient, well-structured PL/SQL code for enterprise applications, leveraging ADB-S features such as JSON support, REST-enabled SQL, and Autonomous performance advisors. - Write and optimise complex SQL queries for high-performance data retrieval and reporting. - Support application teams with database design, data modelling, and query optimisation for cloud-hosted applications. - Perform SQL tuning using Oracles Autonomous Database tuning advisors and execution plan analysis. - Develop and execute data migration scripts, including on-premises-to-cloud and cross-schema migrations. - Implement database security standards within ADB-S, including roles, privileges, Data Safe policies, and auditing. - Cloud Database Administration (Supporting) - Provision, configure, and manage Oracle Autonomous Database (ADB-S) instances via the OCI Console, CLI, and APIs. - Monitor database health, performance, storage, and auto-scaling behaviour within OCI. - Manage backup and recovery using ADB-Ss automated backup capabilities; support disaster recovery readiness via Autonomous Data Guard. - Support minimal-downtime patching and version updates (largely automated in ADB-S, but requires validation and coordination). - Monitor and resolve locks, deadlocks, and performance bottlenecks using OCI-native monitoring tools and Oracle Enterprise Manager (OEM), where applicable. - Manage database users, wallets, and access controls, including integration with OCI IAM. - Troubleshoot production issues and provide timely resolution in collaboration with cloud infrastructure teams. Required Skills & Qualifications - Bachelors degree in Computer Science, Information Technology, Engineering, or a related discipline. - 45 years of hands-on experience in Oracle Database Development, with working exposure to database administration. - Strong PL/SQL and SQL programming skills, including packages, procedures, functions, and triggers. - Working knowledge of Oracle Autonomous Database (ADB-S) or robust willingness/aptitude to work in a cloud-native Oracle environment (traditional Oracle 12c/19c experience with cloud exposure is acceptable). - Experience with SQL performance tuning and query optimisation. - Familiarity with Oracle Cloud Infrastructure (OCI) console, CLI, and basic provisioning of database services. - Understanding of Oracle Data Guard/Autonomous Data Guard and high-availability concepts. - Basic knowledge of database security, auditing, and user/role management. - Strong understanding of database design principles and normalisation. - Experience supporting production environments and resolving application-related database issues. Preferred Skills - Hands-on experience with Oracle Autonomous Database (ADB-S) specifically, rather than general Oracle Cloud exposure. - Knowledge of scripting/automation (Python, Shell) for cloud database tasks. - Familiarity with DevOps practices, CI/CD pipelines, and Git-based version control for database code - Exposure to OCI services beyond the database layer (Object Storage, Functions, API Gateway) for building integrated cloud applications. - Understanding of JSON handling and document-store capabilities within Oracle Database. - Oracle certification such as Oracle Database SQL Certified Associate, OCP, or Oracle Cloud Infrastructure Certification is an added advantage. Soft Skills - Strong analytical and problem-solving abilities. - Good troubleshooting and performance optimisation skills. - Effective communication and stakeholder management. - Ability to work independently and collaboratively within cross-functional, cloud-focused teams. - Strong documentation and knowledge-sharing practices. - Ability to manage multiple priorities in a fast-paced, evolving cloud environment. If you are interested in one of our vacancies, please send your CV and motivation to: If you like to know more about working at ARS, please contact us at: +91-XXXXXXXXXX .