Job Description
𝗧𝗵𝗶𝘀 𝗿𝗼𝗹𝗲 𝗶𝘀 𝗳𝗼𝗿 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗪𝗲𝗲𝗸𝗱𝗮𝘆'𝘀 𝗰𝗹𝗶𝗲𝗻𝘁𝘀
𝗦𝗮𝗹𝗮𝗿𝘆 𝗿𝗮𝗻𝗴𝗲: 𝗥𝘀 𝟭𝟱𝟬𝟬𝟬𝟬𝟬 - 𝗥𝘀 𝟮𝟬𝟬𝟬𝟬𝟬𝟬 (𝗶𝗲 𝗜𝗡𝗥 𝟭𝟱-𝟮𝟬 𝗟𝗣𝗔)
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 ISTschedule.
