Strong understanding of database schema design and normalization
Proficient in performance tuning and query optimization
Experience with data profiling and validation
Ability to collaborate with cross-functional teams
Familiarity with coding standards and version control
Mentorship experience with junior developers
Responsibilities
Develop and maintain high-quality PLSQL code including procedures, functions, packages, and triggers
Analyze existing database structures and recommend improvements
Troubleshoot and resolve PLSQL and database-related issues
Perform code reviews and provide constructive feedback
Collaborate with team members to ensure adherence to coding standards
Mentor junior developers on Oracle PLSQL best practices
Provide regular status updates and technical reports to management
Benefits
Opportunity to work with cutting-edge Oracle database technologies
Collaborative work environment with cross-functional teams
Mentorship opportunities to guide junior developers
Focus on continuous improvement initiatives
Access to professional development resources
Full Job Description
Role description
Job Summary
Seeking a Specialist with 5 to 7 years of experience specializing in Oracle PLSQL within the Oracle DBODIPLSQL skill cluster family
Job Description
Design develop and optimize complex Oracle PLSQL queries stored procedures functions and packages to support business applications and data processing Collaborate with crossfunctional teams including developers DBAs and business analysts to gather requirements and translate them into scalable database solutions Participate in database schema design including normalization and performance tuning Perform data profiling validation and ensure data integrity across Oracle databases Monitor and enhance PLSQL code performance and optimize query execution plans Maintain documentation related to database design development and changes Stay updated with the latest Oracle database technologies and best practices to improve development efficiency and solution quality
Roles and Responsibilities
Develop and maintain highquality PLSQL code including procedures functions packages and triggers
Analyze existing database structures and recommend improvements for performance scalability and maintainability
Troubleshoot and resolve PLSQL and databaserelated issues in a timely manner
Perform code reviews and provide constructive feedback to peers
Collaborate with team members to ensure adherence to coding standards version control and documentation protocols
Mentor and guide junior developers on Oracle PLSQL best practices and development techniques
Provide regular status updates and technical reports to management and stakeholders
Drive continuous improvement initiatives to enhance database performance and development processes
About LTIMindtree
LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across 30+ countries, LTIMindtree — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale.
