Oracle PL/SQL Developer & DBA - Vendor JD

'

: - ( - )

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 componentsDesign and maintain procedures, functions, packages, views, triggers, synonyms, and other Oracle database objectsPerform Oracle database administration, monitoring, troubleshooting, and operational supportAnalyse AWR and ADDM reports to identify database performance bottlenecksUse SQL Advisory and related performance-analysis tools to identify optimisation opportunitiesOptimise complex SQL queries, database operations, execution plans, and resource utilisationDiagnose and resolve database performance, availability, and production issuesMonitor database health and proactively identify potential operational or performance risksProvide production support and troubleshoot critical database incidentsDevelop and maintain Linux/Shell scripts for database administration and operational activitiesCollaborate with application and engineering teams to resolve database-related issues and improve application performanceSupport database changes, deployments, maintenance activities, and operational processesDocument database solutions, troubleshooting procedures, performance improvements, and operational activitiesContribute to database reliability, scalability, performance, and maintainability initiativesSupport 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 roleStrong hands-on expertise in Oracle PL/SQL development and Oracle Database AdministrationProven experience with Oracle database performance tuning and troubleshootingStrong understanding of AWR, ADDM, SQL Advisory, execution plans, and SQL optimisationExperience writing and optimising complex SQL queriesStrong hands-on experience with procedures, functions, packages, views, triggers, and synonymsExperience supporting production databases and resolving critical database issuesStrong understanding of database monitoring, performance diagnostics, availability, and resource utilisationGood working knowledge of Linux and Shell scripting for database-related activitiesAbility to analyse complex technical problems and perform effective root-cause analysisStrong understanding of database development standards, administration practices, and operational processesExperience collaborating with application developers, infrastructure teams, and other technical stakeholdersExposure to Hive, Impala, or HBase is an advantageExperience with Google Compute Engine (GCE) and GCE provisioning is a plusStrong communication, documentation, troubleshooting, and problem-solving skillsAbility to work independently as an Individual Contributor and take ownership of database development and operational responsibilitiesWillingness and availability to work from Hyderabad or Bengaluru during the required 11:00 AM-8:00 PM ISTschedule .