Senior Oracle PL / SQL Developer
Lancesoft India Pvt LtdPune4 days ago
Job descriptionDatabase Expertise : Full life cycle development experience with Oracle Database (10g and above), specifically managing and optimizing databases with very high volumes ($\ge 5 \text{ TB}$). Core PL / SQL Mastery : Strong, demonstrable expertise in SQL / PLSQL development, including advanced performance tuning techniques and robust transaction management. PL / SQL Object Development : Hands-on, expert-level development of complex packages, procedures, functions, triggers, advanced SQL, and effective use of bulk DML / DDL operations. Advanced Structures : Experience utilizing advanced Oracle structures such as cursors, dynamic SQL, nested tables, and V-arrays. Database Fundamentals : Maintain data integrity by ensuring ACID properties, implementing robust exception handling, and advanced debugging of database code. Schema Objects : Deep working knowledge of building and maintaining various schema objects, including tables, indexes, views, sequences, and synonyms. Data Loading : Practical experience with high-volume data ingestion techniques utilizing tools like SQL Loader, external tables, and message queuing systems like Oracle AQs (Advanced Queuing). Performance Tuning Tools : Expert-level proficiency in performance tuning using standard Oracle utilities, including interpreting Explain Plans and analyzing AWR reports to effectively identify and resolve issues with long-running jobs. Job Orchestration : Experience with job scheduling and management using the native Oracle Job Scheduler or equivalent enterprise scheduling tools. Source Code Management : Proficiency in using modern source code management systems such as SVN, Git, and Bitbucket. CI / CD Integration : Experience with pipeline creation and automation using tools like Jenkins for continuous integration and deployment processes. Operating System : Working knowledge of Unix / Linux environments and practical experience with shell scripting for automation and environment management.
Description :
Role Overview & Key Responsibilities :
As a Senior Developer, you will operate with limited supervision, taking ownership of the full software development lifecycle for critical database applications.
- Your primary focus will be on delivering high-quality, high-performance Oracle solutions.
- Software Deliverables : Produce high-quality, production-ready software deliverables, ensuring timely completion and compliance with all organizational standards and security policies.
- Full Lifecycle Ownership : Proactively analyze, design, code, unit-test, document, and implement application releases within the database layer.
- Performance & Optimization : Conduct unit tests on large datasets and consistently produce highly optimized solutions to maintain system responsiveness and efficiency.
- Risk Management : Proactively notify managers of potential risks, technical bottlenecks, and implementation issues.
- Quality Assurance : Collaborate closely with Quality Analysts (QAs) to ensure all developed solutions meet defined acceptance criteria and quality standards.
- Mentorship & Review : Act as a mentor for junior developers and actively participate in peer code reviews to maintain code integrity and enforce best practices.
- Agile Environment : Thrive and contribute effectively within a dynamic, fast-paced Agile development methodology.
Essential Experience & Technical Competencies :
The ideal candidate will have extensive, hands-on experience across the entire data lifecycle in enterprise-grade Oracle environments.
Advanced Oracle Development :
Data Ingestion and Performance Tuning :
Development Operations & Environment :
(ref : hirist.tech)
Create a job alert for this search
Developer Oracle Plsql • Pune
Related jobs
)
- Promoted
Oracle Data Integrator (ODI) Developer
KPG99 INCPune, IN Role- Oracle Data Integrator (ODI) Developer.Strong understanding of relational database design and performance optimization.
Excellent troubleshooting and problem-solving skills.Ability to work ind...Show moreLast updated: 5 days ago
- Promoted
Oracle Oracle Exadata Database
Tata Consultancy ServicesPune, Maharashtra, India Role - Oracle Oracle Exadata Database.Oracle Oracle Exadata Database.Oracle Oracle Exadata Database.Good understanding of Exadata Architecture.
Clear understanding of Exadata features like.Solid exp...Show moreLast updated: 6 days ago
- Promoted
Opening for PL / SQL Developer
eInfochips (An Arrow Company)Pune, Maharashtra, India Experience - 5 to 9 years Location - Indore / Ahmedabad / Pune Job Description - Designing, developing, and maintaining Oracle database systems using PL / SQL - Performance optimization and ensuring dat...Show moreLast updated: 14 days ago
- Promoted
Senior Consultant
YASH TechnologiesPune, Maharashtra, India Willingness to work 24 •7 shifts.Deep understanding of Oracle E-Business Suite architecture and components.Expertise in Oracle database administration, including SQL, PL / SQL, and database concepts.P...Show moreLast updated: 14 days ago
- Promoted
Oracle PL / SQL Developer
People Prime World WidePune About Client : Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris...Show moreLast updated: 30+ days ago
- Promoted
Celebal Technologies - Senior Oracle Developer
Celebal TechnologiesPune Primary Responsibilities : - Provide expertise in the design and programming of all kinds of Oracle database components logical and physical schemas, tables, indexes,...Show moreLast updated: 28 days ago
- Promoted
Senior SQL Developer
KVAS TechnologiesPune JOB SUMMARY : The SQL Developer will join a team of Mobile, WPF and.NET developers to administer, develop and maintain several large-scale...Show moreLast updated: 30+ days ago
- Promoted
Zensar Technologies - Senior Oracle CPQ Cloud Developer
Zensar TechnologiesPune Position : Senior Oracle CPQ Cloud Developer Experience : 7-10 Years Location : PAN Zensar (Hybrid) Notice Period : ImmediateShow moreLast updated: 30+ days ago
- Promoted
PL-SQL Developer - Unix / Shell Scripting
People Prime World WidePune Job Description : Key Responsibilities : - Design, de...Show moreLast updated: 30+ days ago
- Promoted
Senior SQL Developer - Azure Cloud
Talks About PeoplePune Description : Domain : Azure Cloud - Data Engineering - Enterprise SQL Are you a data expert who loves building scalable, high-performance syst...Show moreLast updated: 5 days ago
- Promoted
PL-SQL Developer - Unix / Linux
DeqodePune Key Responsibilities : - Design, develop, and optimize PLSQL procedures, functions, and packages.Work with Unix / Linux environments for deployment and system-related t...Show moreLast updated: 29 days ago
- Promoted
PL / SQL Developer
ConfidentialPune Strong experience with Oracle functions, procedures, triggers, packages, performance tuning.Hands-on development using Oracle / MySQL / PostgreSQL PL / SQL.
Solid understanding of key concepts, such a...Show moreLast updated: 30+ days ago
- Promoted
Senior Oracle Application Developer - EBS / SCM Module
Excelencia I-Tech Consulting Pvt LtdPune Job Title : Senior Oracle Applications Developer - SCM : Type : Full-Time - Hybrid (3 Level : 7- 13 : UK Time Summary : &l...Show moreLast updated: 30+ days ago
- Promoted
Senior Azure / SQL Developer - Big Data / PySpark
Lancesoft India Pvt LtdPune Description : Position Overview As a Senior Azure / SQL Developer, you will be responsible for the end-to-end development, deployment, a...Show moreLast updated: 4 days ago
- Promoted
PL-SQL Developer - Scripting
People Prime World WidePune Job Title : PLSQL Developer with Azure with Scripting Languages.Location : Pune(Hybrid).Experience : 7+ yrs.Job Type : Contract to hire.Notice Period : &...Show moreLast updated: 30+ days ago
- Promoted
- New!
PL / SQL Developer
Datacore TechnologiesPune, Maharashtra, India Job Description : Key responsibilities Python experience with more than 6 years of experience in developing python applications, with working experience in database connectivity, multi-threading and...Show moreLast updated: 12 hours ago
- Promoted
Lead SQL Developer
ConfidentialPune, Maharashtra, India Seeking a Lead SQL Developer with strong expertise in SQL development, database management, data warehousing, and reporting.
Develop and optimize complex SQL queries, stored procedures, and ETL proc...Show moreLast updated: 30+ days ago
- Promoted
Fusion Practices - Senior Oracle Integration Cloud Developer
Fusion PracticesPune We are looking for a highly experienced Senior Oracle Integration Cloud (OIC) Developer with 15+ years of overall IT experience.
The successful candidate will have a strong background in Oracle tech...Show moreLast updated: 30+ days ago