Talent.com
Oracle, PL SQL,unix

Oracle, PL SQL,unix

ConfidentialHyderabad / Secunderabad, Telangana
30+ days ago
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.

    • Skills Required

    Bash, Oracle, Unix, Sql

    Create a job alert for this search

    Oracle • Hyderabad / Secunderabad, Telangana

    Related jobs
    • Promoted
    Senior Engineer, Software - SQL

    Senior Engineer, Software - SQL

    Talent500 INCHyderabad, India
    Senior Engineer, Software - SQL.Were building the future of digital experiences, and we need a Senior Full Stack Engineer who thrives at the intersection of creativity, problem-solving, and technol...Show moreLast updated: 30+ days ago
    • Promoted
    PostgreSQL, Oracle Database > PL / SQL

    PostgreSQL, Oracle Database > PL / SQL

    ConfidentialHyderabad / Secunderabad, Telangana
    Roles and Responsibilities) Data Base Administration, Data Modeling, Create and manage DBs, Backup & Recovery, Monitoring health of. DB Servers, Query Tuning, DB parameter tuning, Server Sizing, Net...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Database Engineer (Oracle, PL / SQL)

    Senior Database Engineer (Oracle, PL / SQL)

    ConfidentialDelhi, Pune, Hyderabad / Secunderabad, Telangana
    Required Skills and Experience : .Strong PL / SQL development and Oracle database administration skills.SQL, SQL tuning, and performance optimization methods. Experience with data modeling and database ...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle PL / SQL Developer

    Oracle PL / SQL Developer

    ConfidentialHyderabad / Secunderabad, Telangana
    Design, develop, test, and deploy Oracle PL / SQL applications using various programming constructs such as IF-ELSE statements, Loops (FOR-NEXT), Functions, Procedures, Packages, and Triggers.Ensure ...Show moreLast updated: 30+ days ago
    • Promoted
    PL / SQL Developer ( REMOTE )

    PL / SQL Developer ( REMOTE )

    ADV TECHMINDSHyderabad, Telangana, India
    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 moreLast updated: 30+ days ago
    • Promoted
    Oracle & PL SQL Developer

    Oracle & PL SQL Developer

    ConfidentialHyderabad / Secunderabad, Telangana, Kolkata
    We are seeking a skilled Oracle & PL SQL developer with hands-on experience in Informatica PowerCenter to join our data integration and backend development team. The ideal candidate will be responsi...Show moreLast updated: 30+ days ago
    • Promoted
    Senior SQL Server DBA – Cloud (Azure & AWS)

    Senior SQL Server DBA – Cloud (Azure & AWS)

    ValueMomentumHyderabad, Telangana, India
    Senior SQL Server DBA – Cloud (Azure & AWS).We are looking for a highly skilled Senior SQL Server DBA with strong experience in Azure and AWS. This role involves managing, optimizing, and securing S...Show moreLast updated: 11 days ago
    • Promoted
    • New!
    PL / SQL Developer

    PL / SQL Developer

    Datacore Technologiessecunderabad, telangana, in
    Python experience with more than 6 years of experience in developing python applications, with working experience in database connectivity, multi-threading and multi-processing , file handling (xml...Show moreLast updated: 21 hours ago
    • Promoted
    SQL & PL / SQL

    SQL & PL / SQL

    ConfidentialHyderabad / Secunderabad, Telangana
    Demonstrated proficiency in SQL and PL / SQL, with a deep understanding of complex queries and optimization.Strong experience in data modeling, including designing table structures and efficiently jo...Show moreLast updated: 30+ days ago
    • Promoted
    PL / SQL Developer

    PL / SQL Developer

    Maganti IT Resources, LLCHyderabad, Telangana, India
    Location : Hyderabad,TG- Onsite.Note : Selected candidates must be Able to join Immediatly at client location in Hyderabad from day one. Minimum 6+ years' experience as Oracle developer (10g / 11g) and...Show moreLast updated: 21 days ago
    • Promoted
    Oracle PlSQL and Unix

    Oracle PlSQL and Unix

    ConfidentialHyderabad / Secunderabad, Telangana
    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 moreLast updated: 30+ days ago
    • Promoted
    PL / SQL, Unix Professional

    PL / SQL, Unix Professional

    ConfidentialHyderabad / Secunderabad, Telangana, Bengaluru / Bangalore
    Develop and maintain PL / SQL procedures, functions, packages, and triggers.Write and optimize complex SQL queries for large datasets. Develop Unix / Linux shell scripts to support data processing and b...Show moreLast updated: 30+ days ago
    • Promoted
    PL / SQL

    PL / SQL

    ConfidentialHyderabad / Secunderabad, Telangana
    Develop, maintain, and optimize PL / SQL packages, procedures, functions, and triggers for complex database operations.Design, develop, and support applications using Oracle Forms and Oracle Reports....Show moreLast updated: 30+ days ago
    • Promoted
    PL / SQL Developer

    PL / SQL Developer

    Mount Talent Consulting Pvt Ltd.Hyderabad, Telangana, India
    Oracle, Python and shell scripting.Strong in Oracle PL / SQL and SQL.Must have good database programming skills covering Design / development of Stored Procedures, Functions, Tables.And Triggers and tu...Show moreLast updated: 11 days ago
    • Promoted
    PL-SQL Developer - Oracle DB

    PL-SQL Developer - Oracle DB

    Maganti IT Solutions Private LimitedHyderabad
    Key Responsibilities : - Develop, maintain, and optimize various database objects such as tables, indexes, and sequences.Create and manage DDL scr...Show moreLast updated: 3 days ago
    • Promoted
    Senior Engineer Oracle ERP Integrations - OIC & SQL Development

    Senior Engineer Oracle ERP Integrations - OIC & SQL Development

    Talent500 INCHyderabad, India
    Senior Engineer Oracle ERP Integrations - OIC & SQL Development.As a Senior Engineer Oracle ERP Integrations, you will design, build, and deliver Oracle Integration Cloud (OIC) solutions while le...Show moreLast updated: 30+ days ago
    • Promoted
    PL / SQL Developer

    PL / SQL Developer

    Blue Spire IncHyderabad, Telangana, India
    PL / pgSQL Developer with 2+ years of dedicated experience in PostgreSQL.The ideal candidate will have strong expertise in PL / pgSQL development, query optimization, and batch job analysis.This role i...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle - Pl / Sql Developer

    Oracle - Pl / Sql Developer

    ConfidentialHyderabad / Secunderabad, Telangana
    Language - UNIX shell scripting, Python, Oracle PLSQL.Data base - Strong DB SQL experience - Oracle / MYSQL.Scheduler - Airflow or other schedulers will be of added advantage.Integration & logging to...Show moreLast updated: 30+ days ago