Oracle PL/SQL Developer & DBA - Vendor JD

Weekday 1; Bengaluru; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

Weekday 1 is seeking an experienced Oracle PL/SQL Developer & DBA to join as an Individual Contributor for client projects in Hyderabad or Bengaluru. You will develop, administer, and optimise enterprise Oracle databases, with a strong focus on performance tuning and production support.

The role requires hands-on expertise with complex SQL, AWR/ADDM reports, Linux scripting, and collaboration with engineering teams to ensure database reliability and scalability.

Qualifications

• 7+ years of experience in Oracle PL/SQL development or Oracle DBA.
• Hands-on expertise in Oracle database administration and performance tuning.
• Experience with AWR/ADDM, SQL advisory, and execution plans.
• Proficient in Linux and Shell scripting for DB ops.
• Experience with production databases and incident resolution.
• Ability to work as an Independent Contributor.
• Exposure to Hive/Impala/HBase is a plus.

Responsibilities

• Develop, maintain and optimise SQL/PLSQL components.
• Perform Oracle database administration, monitoring, troubleshooting, and operational support.
• Analyse AWR and ADDM reports to identify database performance bottlenecks.
• Use SQL Advisory and related performance-analysis tools to identify optimisation opportunities.
• Optimise complex SQL queries, database operations, execution plans, and resource utilisation.
• Diagnose and resolve database performance, availability, and production issues.
• Monitor database health and proactively identify potential risks.
• Provide production support and troubleshoot critical database incidents.
• Develop Linux/Shell scripts for database administration and operational activities.
• Collaborate with application and engineering teams to resolve issues and improve performance.
• Support database changes, deployments, maintenance activities, and operational processes.
• Document database solutions, troubleshooting procedures, performance improvements, and operational activities.
• Contribute to database reliability, scalability, and maintainability initiatives.
• Support cloud-based infrastructure and database environments where required.

Skills

Oracle PL/SQL development

Oracle Database Administration

Performance tuning

AWR/ADDM analysis

Linux/Shell scripting

Production support

Documentation

Independent contributor

Tools

Hive

Impala

HBase

GCE

Job description

This role is for one of the Weekday's clients

Salary range: Rs 1500000 - Rs 2000000 (ie INR 15-20 LPA)

Experience: 7+ yrs

Location: Hyderabad or Bangalore

Job Type: Full-time

We are looking for an experienced Oracle PL/SQL Developer & DBA to develop, administer, troubleshoot, and optimise enterprise Oracle database environments. This is an Individual Contributor role requiring strong hands‑on expertise across both PL/SQL development and Oracle database administration, with a significant focus on performance tuning and production support.

The ideal candidate will be comfortable working with complex SQL, database objects, performance diagnostics, Linux scripting, and production database environments.

Requirements

Key Responsibilities

• Develop, maintain, and optimise complex SQL and PL/SQL components.
• Design and maintain procedures, functions, packages, views, triggers, synonyms, and other Oracle database objects.
• Perform Oracle database administration, monitoring, troubleshooting, and operational support.
• Analyse AWR and ADDM reports to identify database performance bottlenecks.
• Use SQL Advisory and related performance‑analysis tools to identify optimisation opportunities.
• Optimise complex SQL queries, database operations, execution plans, and resource utilisation.
• Diagnose and resolve database performance, availability, and production issues.
• Monitor database health and proactively identify potential operational or performance risks.
• Provide production support and troubleshoot critical database incidents.
• Develop and maintain Linux/Shell scripts for database administration and operational activities.
• Collaborate with application and engineering teams to resolve database‑related issues and improve application performance.
• Support database changes, deployments, maintenance activities, and operational processes.
• Document database solutions, troubleshooting procedures, performance improvements, and operational activities.
• Contribute to database reliability, scalability, performance, and maintainability initiatives.
• Support cloud‑based infrastructure and database environments where required.

What Makes You a Great Fit

• 7+ years of relevant experience in Oracle PL/SQL development, Oracle DBA, database engineering, or a closely related role.
• Strong hands‑on expertise in Oracle PL/SQL development and Oracle Database Administration.
• Proven experience with Oracle database performance tuning and troubleshooting.
• Strong understanding of AWR, ADDM, SQL Advisory, execution plans, and SQL optimisation.
• Experience writing and optimising complex SQL queries.
• Strong hands‑on experience with procedures, functions, packages, views, triggers, and synonyms.
• Experience supporting production databases and resolving critical database issues.
• Strong understanding of database monitoring, performance diagnostics, availability, and resource utilisation.
• Good working knowledge of Linux and Shell scripting for database‑related activities.
• Ability to analyse complex technical problems and perform effective root‑cause analysis.
• Strong understanding of database development standards, administration practices, and operational processes.
• Experience collaborating with application developers, infrastructure teams, and other technical stakeholders.
• Exposure to Hive, Impala, or HBase is an advantage.
• Experience with Google Compute Engine (GCE) and GCE provisioning is a plus.
• Strong communication, documentation, troubleshooting, and problem‑solving skills.
• Ability to work independently as an Individual Contributor and take ownership of database development and operational responsibilities.
• Willingness and availability to work from Hyderabad or Bengaluru during the required 11:00 AM–8:00 PM IST schedule.