Key Responsibilities:
Oracle PL/SQL Development:
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.

Oracle, PL SQL ,unix

Job Description

Required Skills