Oracle, PL SQL ,unix

Fusion Plus Solutions

3 - 6 years

8 - 11 Lacs

Hyderabad Telangana India

Posted:2 months ago| Platform: Foundit logo

Apply

Skills Required

KornShell

Work Mode

On-site

Job Type

Full Time

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.