Develop and optimize PL / SQL scripts, stored procedures, functions, triggers, and packages for database applications.
Design, implement, and maintain SQL queries and PL / SQL procedures to ensure efficient data retrieval and manipulation.
Optimize existing PL / SQL code for performance improvements, such as reducing query execution times and improving system efficiency.
Participate in code reviews and provide feedback for maintaining high standards in SQL and PL / SQL development.
Database Design & Maintenance :
Collaborate with the database team to design, implement, and maintain database structures like tables, indexes, and views.
Ensure data integrity, consistency, and accuracy within the Oracle database.
Troubleshoot and resolve database performance issues, bottlenecks, and resource utilization concerns.
Unix Shell Scripting :
Develop and maintain Unix shell scripts to automate database tasks such as backups, data migrations, and job scheduling.
Perform database interactions via Unix scripts, including executing SQL queries , monitoring database health , and analyzing logs .
Work with Unix-based tools to monitor system performance, conduct system analysis, and resolve server-related issues.
Performance Tuning :
Monitor, analyze, and resolve performance-related issues in Oracle databases, including query optimization and proper indexing strategies.
Tune SQL queries and PL / SQL procedures for optimal performance on Oracle databases.
Analyze execution plans and recommend improvements for complex SQL queries and stored procedures .
Database Troubleshooting & Support :
Provide technical support for resolving database-related incidents, including issues with SQL queries, PL / SQL scripts, and database performance.
Troubleshoot and debug SQL and PL / SQL code in a production environment.
Work with the support team to resolve any system issues related to Oracle databases running on Unix-based systems.
Collaboration & Documentation :
Collaborate with business analysts, project managers, and other developers to understand business requirements and translate them into technical solutions.
Write and maintain comprehensive technical documentation related to database schema, PL / SQL procedures, and Unix-based automation scripts.
Ensure adherence to data security and compliance standards during development and implementation processes.
Version Control & Deployment :
Use version control tools (e.g., Git , SVN ) to manage PL / SQL code and database scripts.
Manage deployments of changes and new features to various Oracle environments (development, staging, production).
Participate in the deployment process and ensure the successful migration of database objects to different environments.
Skills and Qualifications :
Mandatory Skills :
Strong proficiency in Oracle PL / SQL (creating packages, procedures, triggers, and functions).
Expertise in writing complex SQL queries , including joins , sub-queries , and aggregations .
Solid experience with Oracle database performance tuning , query optimization, and working with execution plans .
Proficiency in Unix shell scripting (Bash, KornShell, etc.) for automation and system monitoring tasks.
Hands-on experience in automating database maintenance tasks such as backups, restores, and data migrations using Unix scripts.
Familiarity with Oracle Database administration, including schema design, table partitioning, indexing, and data backup / recovery strategies.
Understanding of Unix system performance monitoring tools and server resource management .
Strong problem-solving and troubleshooting skills in both Oracle and Unix environments.
Familiarity with data security practices and ensuring compliance with organizational policies.
Skills Required
Bash, Oracle, Unix, Sql
Create a job alert for this search
Oracle • Hyderabad / Secunderabad, Telangana
Related jobs
PL / SQL Developer
MOURI Tech • Hyderabad, Telangana, India
Strong expertise in Oracle PL / SQL.Proficiency in one or more UI frameworks : Angular, React, or JavaScript.Working knowledge of any backend language : .
Github / SVN for version control.CI / CD pipelines...Show more
Last updated: 1 day ago • Promoted
Oracle PL / SQL Database Developer
Tata Consultancy Services • Hyderabad, Republic Of India, IN
TCS Hiring !!Virtual Drive • • •Oracle PL / SQL developer.Primary -TCS -Hyderabad / Chennai.Please read Job description before Applying.
NOTE : If the skills / profile matches and interested, please reply t...Show more
Last updated: 24 days ago • Promoted
Oracle PL / Sql Developers
MillionLogics • Hyderabad, IN
MillionLogics, a trusted Oracle Partner, is a leading global IT solutions provider with a presence in London, UK, and a development hub in Hyderabad, India.
The company specialises in transforming e...Show more
Last updated: 1 day ago • Promoted
PL / SQL Developer ( REMOTE )
ADV TECHMINDS • Hyderabad, Telangana, India
Remote
Releavant exp min 5+ years experience as an Oracle PL / SQL Developer.Strong proficiency in PL / SQL development in Oracle environments.
Proven expertise in writing complex stored procedures, functions,...Show more
We are looking for an experienced.Oracle PL / SQL & Unix Developer.The ideal candidate should have strong expertise in either.
Develop, optimize, and maintain complex.Support data extraction, transfor...Show more
Last updated: 30+ days ago • Promoted
PL / SQL Developer
Tata Consultancy Services • Hyderabad, Telangana, India
Secondary Skills : Linux Shell Scripting.Design, model, develop, and deploy Oracle DB objects including tables, views, triggers, stored procedures.
Self-coordinate with CIO and Business stakeholders...Show more
Last updated: 30+ days ago • Promoted
Oracle Application Technical Consultant
Sutherland • Hyderabad, Telangana, India
Oracle EBS Technical Consultant with 5-8 years of experience in designing, developing, and supporting Oracle E-Business Suite (EBS) R12.
Expertise in Finance (GL, AP, AR, FA, CM) or Supply Chain (PO...Show more
Last updated: 9 days ago • Promoted
Pl / Sql Developer
Tata Consultancy Services • Hyderabad, Republic Of India, IN
Secondary Skills : Linux Shell Scripting.Design, model, develop, and deploy Oracle DB objects including tables, views, triggers, stored procedures.
Self-coordinate with CIO and Business stakeholders...Show more
Last updated: 30+ days ago • Promoted
Oracle PL / SQL Solutions Architect
MOURI Tech • Hyderabad, Republic Of India, IN
Strong expertise in Oracle PL / SQL.Proficiency in one or more UI frameworks : Angular, React, or JavaScript.Working knowledge of any backend language : .
Github / SVN for version control.CI / CD pipelines...Show more
Last updated: 1 day ago • Promoted
Oracle PL / SQL developer
Tata Consultancy Services • Hyderabad, Telangana, India
TCS Hiring !!Virtual Drive • • •Oracle PL / SQL developer.Primary -TCS -Hyderabad / Chennai.Please read Job description before Applying.
NOTE : If the skills / profile matches and interested, please reply t...Show more
Last updated: 24 days ago • Promoted
PL / SQL Engineer
Tata Consultancy Services • Hyderabad, Republic Of India, IN
Secondary Skills : Linux Shell Scripting.Design, model, develop, and deploy Oracle DB objects including tables, views, triggers, stored procedures.
Self-coordinate with CIO and Business stakeholders...Show more
Last updated: 17 days ago • Promoted
Oracle Database Developer
Grid Dynamics • Hyderabad, Telangana, India
Key Responsibilities : Develop, optimize, and maintain Oracle PL / SQL code to support business-critical workflows and financial analysis functions.
Collaborate closely with RJ managers, Financial Anal...Show more
Last updated: 21 days ago • Promoted
Technical Lead Consultant - Oracle PL-SQL
Growel Softech Pvt. Ltd. • Hyderabad
Description : About the Role : We are seeking an experienced Technical Lead Consultant with strong expertise in PL / SQL development and hands-on e...Show more
Last updated: 29 days ago • Promoted
PL / SQL Developer
People Prime Worldwide • Hyderabad, IN
Our client is a Palo Alto–based AI infrastructure and talent platform founded in 2018.It helps companies connect with remote software developers using AI-powered vetting and matching technology.Ori...Show more
Last updated: 7 hours ago • Promoted • New!
Oracle Apps DBA
Tata Consultancy Services • Greater Hyderabad Area, India
Proven experience as an Oracle Apps DBA or similar role.In-depth knowledge of Oracle E-Business Suite architecture and components.
Strong understanding of database security, backup, and recovery str...Show more
Last updated: 11 days ago • Promoted
Oracle Integration Cloud
White Force Group • Hyderabad, Telangana, India
Exp - 8+ years CTC - 30 Lpa Skills : Strong experience in integration design, development, and monitoring using OIC.Expertise in REST / SOAP, FTP, and ERP Cloud adapters.
Preferred : Experience with IC...Show more
Last updated: 15 days ago • Promoted
Oracle Database Developer
Tata Consultancy Services • Hyderabad, Republic Of India, IN
Secondary Skills : Linux Shell Scripting.Design, model, develop, and deploy Oracle DB objects including tables, views, triggers, stored procedures.
Self-coordinate with CIO and Business stakeholders...Show more
Last updated: 17 days ago • Promoted
Oracle Applications Developer
Sutherland • Hyderabad, Republic Of India, IN
Oracle EBS Technical Consultant with 5-8 years of experience in designing, developing, and supporting Oracle E-Business Suite (EBS) R12.
Expertise in Finance (GL, AP, AR, FA, CM) or Supply Chain (PO...Show more