Oracle, PL SQL ,unix

Fusion Plus Solutions

Hyderabad

3-6 Years

Save

Posted 12 days ago
Over 200 applicants

Quick Apply

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.

More Info

Job Type:

Permanent Job

Industry:

Information Technology

Role:

Software Developer

Function:

IT/Software Development - Client Server

Employment Type:

Full time

Open to candidates from:

Indian

About Company

Fusion Plus Solutions

At Fusion Plus Solutions Inc, we believe that it’s an exceptional company - a company of people proud of the work they do and the solutions they provide. By understanding what drives our specialty industries, becoming involved in our communities on a professional and personal basis, following a disciplined process of identifying quality candidates, partnering with employers to understand their core business and their employment requirements, and delivering exceptional service, we achieve great results for all concerned.

Job ID: 121827355

Jobs by Skill - IT