Oracle, PL SQL

Job Description - 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.