Senior Oracle Pl Sql Developer

2 days ago

Hyderabad, Telangana, India Maddisoft Solutions Full time ₹ 5,00,000 - ₹ 8,00,000 per year

Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. send in resume along with LinkedIn profile without which applications will not be considered.

Job Title: Senior Oracle PL/SQL developer

Location : Hyderabad, India

Job Description:

Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.

Essential Duties/Responsibilities:

  • Develop Oracle PL/SQL applications.
  • Code packages, stored procedures, functions, objects, tables, views, synonyms based on requirements. Understand functionality of existing applications and either incorporate new functionality to automate the calculations process or build new applications for the calculations process.
  • Work with IT Technical Lead to understand requirements/technical design, understand the source tables and relationships, adhere to consistent coding/SVN standards, do code reviews, and provide daily status updates.
  • Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
  • Use Oracle Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning and so on in the Oracle PL/SQL code.
  • Optimize code by following performance tuning techniques considering limitations of current environment.
  • Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code. Use analytics skills to troubleshoot and resolve problems quickly
  • Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
  • Have code reviewed with Technical lead prior to moving the code to QA environment
  • Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
  • Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
  • Follow SOX procedures for code deployment.
  • Perform production support.
  • Monitor batch processes daily/weekly/monthly and resolve job failures as quickly as possible.
  • Work with ControlM/Redwood group on re-run/re-start instructions.
  • Be willing to perform this off hours during weekdays and weekends.
  • Fulfill ad-hoc requests for data pulls, updates or minor enhancements.
  • Work effectively in a team environment.
  • Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups.
  • Independently work on tasks without step by step Supervision
  • Communicate progress or issues clearly either verbally or through email.
  • Escalate issues or delays that would impact deadline as early in the process as possible.

Education:

  • Bachelors degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.

Experience:

  • 15+ years of experience in Software development
  • 12+ years of strong development experience using Oracle PL/SQL including experience using features like Analytical functions, Merge statements, WITH clause, Table partitioning, Job logging, Exception handling, and Performance tuning
  • 12+ years of experience in Oracle 12c or 19c
  • 5+ years of experience in a Data Warehouse environment
  • Strong Analytical skills to analyze and resolve data discrepancies
  • Troubleshooting skills
  • Strong Team Player

  • Oracle PL/SQL Senior Consultant

    2 weeks ago

    Hyderabad, Telangana, India Talent Worx Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Talent Worx is a growing services & recruitment consulting firm, we are hiring for our client which is a leading Big4 Consulting firm and provider of financial intelligence, data analytics, and AI-driven solutions, empowering businesses worldwide with insights for confident decision-making. Join to work on cutting-edge technologies, drive digital...

  • PL/SQL Developer

    6 days ago

    Hyderabad, Telangana, India NTek Software Solutions Full time ₹ 22,00,000 per year

    Job Title : Oracle PLSQL-JAVAExp : 7+Budget : 22 LPA MAXLocation : Hyderabad / Gandhinagar ( complete WFO)Shift Time : General ShiftNotice period : immediate – 15 daysJob Description:We are seeking an experienced and highly skilled Senior Software Engineer with 6+ years of hands-on experience in Oracle PL/SQL and Java. The ideal candidate will be...

  • PL/SQL Developer

    2 weeks ago

    Hyderabad, Telangana, India ADV TECHMINDS Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Required Skills: 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, packages, and triggers. Deep understanding of query optimization, execution plans, and Oracle indexing strategies. Hands-on experience...

  • PL/SQL Developer

    2 days ago

    Hyderabad, Telangana, India Belen IT Solutions Full time ₹ 45,000 - ₹ 55,000 per year

    Company DescriptionBelen ITS is a fast-growing technology company specializing in Java, Angular, and Artificial Intelligence. With over a decade of industry experience, we deliver transformative, tailor-made solutions in software development, QA, AI, and data analytics. We empower enterprises with agile, scalable, and cost-effective IT solutions that drive...

  • pl/sql

    5 days ago

    Hyderabad, Telangana, India Kiash Solutions LLP Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    JOB PROFILE: 5+ years solid experience of Oracle development under a 10g or 11g environment. Advanced PL/SQL knowledge required. Must have very strong experience with creating PL SQL scripts. Must have strong PL SQL stored procedure, packages, functions, & triggers. Any wider SQL or DB experience would be desirable e.g. Postgres, MSSQL, MySQL etc. Strong...

  • Senior PL-SQL Developer

    3 days ago

    Hyderabad, Telangana, India Minivel Full time

    Key Responsibilities : - Design, develop, and optimize complex PL/SQL packages, procedures, triggers, and functions for enterprise-grade applications.- Analyze business requirements and translate them into scalable database solutions.- Perform code debugging, performance tuning, and query optimization for high-volume databases.- For Shell Scripting & Unix...

  • PL/SQL Developer

    2 weeks ago

    Hyderabad, Telangana, India Talent Worx Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    We are looking for a talented PL/SQL Developer to join our dynamic team. In this role, you will be responsible for designing, developing, and optimizing database applications leveraging PL/SQL. The ideal candidate will have a strong grasp of Oracle databases and experience in writing efficient queries, stored procedures, and triggers to support various...

  • PL SQL Development Expert

    20 hours ago

    Hyderabad, Telangana, India beBeeDatabase Full time ₹ 8,64,000 - ₹ 12,12,000

    Job Title: Junior PL-SQL DeveloperWe are seeking a highly skilled professional to develop, test, and maintain PL/SQL packages, procedures, triggers, and functions.Key Responsibilities:Develop and maintain high-quality database code.Perform code debugging, query optimization, and performance tuning for database applications.Collaborate with senior developers...

  • PL - SQL Developer at An IT Service Company

    6 days ago

    Hyderabad, Telangana, India Talentzo Full time US$ 90,000 - US$ 1,20,000 per year

    ResponsibilitiesDesign and develop complex PL/SQL procedures, functions, packages, triggers, and cursors.Test, debug, and implement PL/SQL code in an Oracle database environment.Optimize existing PL/SQL code for performance and maintainability.Create and execute unit and integration tests for PL/SQL code.Preferred candidate profileProven experience in...

  • PL-SQL Code Specialist

    2 days ago

    Hyderabad, Telangana, India beBeeDatabase Full time ₹ 7,50,000 - ₹ 12,50,000

    OverviewWe are seeking a skilled Junior PL-SQL Developer to join our organization. This is a challenging and rewarding opportunity that requires the development, testing, and maintenance of high-quality PL/SQL code.Key Responsibilities:Develop and maintain PL-SQL codebase, ensuring adherence to industry standards and best practices.Perform thorough...