ORACLE PL/SQL DEVELOPER & DBA

Weekday 1; Bengaluru; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Weekday 1 is seeking an experienced Oracle PL/SQL Developer & Database Administrator to manage and optimise Oracle database environments. The role focuses on developing efficient PL/SQL solutions and ensuring high availability and performance in enterprise settings.

Candidates will analyse SQL execution, tune performance, review AWR/ADDM reports, and collaborate with developers to deliver robust database systems.

Qualifications

• 7+ years of professional experience with Oracle database technologies.
• Hands-on Oracle PL/SQL and DBA experience mandatory.
• Experience in database performance tuning and optimisation.
• Experience analysing AWR/ADDM reports.
• Ability to troubleshoot production database issues.
• Collaborates with developers and infrastructure teams.

Responsibilities

• Develop, maintain and optimise Oracle PL/SQL solutions.
• Design complex SQL queries, procedures, packages and components.
• Perform DBA activities including monitoring, configuration and maintenance.
• Analyse and optimise SQL for performance and resource use.
• Review execution plans and identify indexing issues and bottlenecks.
• Support deployments, releases and production changes.

Skills

Oracle PL/SQL

Oracle DBA

Database performance tuning

SQL optimisation

Complex query development

Root cause analysis

Education

Bachelor's or Master’s in Computer Science/IT/Engineering

Tools

AWR reports

ADDM reports

SQL Advisory Reports

Oracle Packages

Job description

𝗧𝗁𝗂𝘀 𝗋𝗈𝗅𝗂𝔦𝙈 𝗀𝗃…

𝗦𝗮𝗹 𝗀… 𝗿𝗆…

Experience: 7+ yrs

Location: Hyderabad, Telangana, India, Bengaluru, Karnataka, India

Job Type: Full-time

We are looking for an experiencedOracle PL/SQL Developer & Database Administratorwith strong expertise inOracle PL/SQL, Oracle DBA, database performance tuning, SQL optimisation, and complex query development.

The ideal candidate will have deep hands-on experience managing and optimising Oracle database environments while developing efficient PL/SQL solutions. This role requires strong analytical and troubleshooting capabilities, particularly in identifying database performance bottlenecks, analysing SQL execution behaviour, and implementing effective optimisation strategies.

Requirements

Key Responsibilities

• Develop, maintain, and optimise complexOracle PL/SQLsolutions.
• Design and write complex SQL queries, stored procedures, functions, packages, and database components.
• Perform Oracle database administration activities including monitoring, troubleshooting, configuration, and maintenance.
• Analyse and optimise SQL queries to improve execution time, resource utilisation, and overall database performance.
• Perform detaileddatabase performance tuningacross enterprise Oracle environments.
• Generate, review, and analyseAWR (Automatic Workload Repository) reportsto identify performance bottlenecks.
• AnalyseADDM (Automatic Database Diagnostic Monitor) reportsand implement recommended performance improvements.
• Generate and analyseSQL Advisory Reportsto identify opportunities for SQL optimisation.
• Review execution plans and identify inefficient queries, indexing issues, resource contention, and other database performance problems.
• Monitor database health, availability, capacity, and resource utilisation.
• Troubleshoot database incidents and perform detailed root-cause analysis.
• Optimise SQL statements, indexes, joins, execution plans, and database objects where required.
• Develop and maintain complexOracle Packages, Procedures, Functions, Triggers, and Views.
• Support database deployments, releases, upgrades, and production changes.
• Work closely with application developers to identify and resolve database and SQL-related issues.
• Participate in production support and resolve critical database performance and availability issues.
• Maintain database documentation, technical specifications, performance reports, and troubleshooting procedures.
• Identify opportunities for database automation, optimisation, and operational improvements.
• Ensure database development and administration activities follow established security, quality, and operational standards.

What Makes You a Great Fit

• 7+ years of professional experiencewith strong hands‑on expertise in Oracle database technologies.
• Strong hands‑on experience with Oracle PL/SQL is mandatory.
• StrongOracle DBAexperience in enterprise production environments.
• Proven experience indatabase performance tuning and optimisation.
• Strong hands‑on experience generating and analysingAWR and ADDM reports.
• Excellent understanding ofSQL query analysis, execution plans, optimisation, and performance tuning.
• Experience generating and analysingSQL Advisory Reports.
• Strong expertise in developing and maintainingOracle Packages.
• Proven ability to write and optimisecomplex SQL queries.
• Strong understanding of Oracle database architecture, objects, indexing, transactions, and performance concepts.
• Experience troubleshooting production database issues and conducting root‑cause analysis.
• Strong understanding of database monitoring, capacity management, availability, and reliability.
• Ability to work effectively with application developers, infrastructure teams, and other technical stakeholders.
• Strong analytical and problem‑solving skills with exceptional attention to detail.
• Ability to independently manage technical issues and deliver solutions within defined timelines.
• Excellent communication and collaboration skills.
• Experience working in Agile or structured enterprise development environments is preferred.
• A Bachelor’s or Master’s degree inComputer Science, Information Technology, Engineering, or a related disciplineis preferred.