PL-SQL Developer - Pune, India - D-TechWorks Pvt. ltd
Description
PLSQL Developer - Pune
Position : PLSQL Developer
Experience : 4-5 years
Job Location : Pune ,-Hybrid
Notice : Immediate joiner or 15 Days
Mandate Skills : ISO,ORACLE PL SQL,,,Oracle DB,ASP.NET,Performance Tuning,Other skills,Oracle,VB .NET
- Seeking a skilled PL/SQL Developer to join our dynamic team.
The ideal candidate is proficient in Oracle's PL/SQL programming language and possesses a strong understanding of database design and optimization.
As a PL/SQL Developer, you will play a key role in developing and maintaining our database applications, ensuring their performance, security, and reliability.
Responsibilities for PL SQL developer
- Create, optimize, and troubleshoot complex stored procedures, triggers, functions, and packages to support data manipulation and reporting needs.
- Collaborate with cross-functional teams, including database administrators and software engineers, to ensure seamless integration and optimal database performance.
- Participate in database design and schema definition, offering insights to improve data organization and access patterns.
- Perform performance tuning, query optimization, and indexing to enhance database responsiveness.
- Identify and address database-related issues, such as data integrity, security, and compliance.
- Work closely with business stakeholders to understand requirements and translate them into effective database solutions.
- Document database design, code, and processes for reference and knowledge sharing.
- Stay up-to-date with the latest database technologies, trends, and best practices to contribute to continuous improvement.
- Design logical and physical databases or review description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method)
- Development and programming in PL/SQL technology
- Design and develop multiple reporting applications
- Design, develop and implement ETL processes to update the data warehouse
- Design, develop, and maintain applications, reports and data structures needed for line of business applications in an Oracle 11G, 12C and above environments Design, develop, and maintain efficient and reliable PL/SQL code for database applications.
Qualifications for PL SQL developer :
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a PL/SQL Developer or in a similar role.
- Strong proficiency in Oracle PL/SQL programming.
- Proficiency in SQL and a solid understanding of relational database concepts.
- Familiarity with database design principles and normalization techniques.
- Experience with performance tuning and optimization of SQL queries.
- Excellent problem-solving skills and attention to detail.
- Strong communication and teamwork abilities.
- Ability to work effectively in a fast-paced, collaborative environment