The PL/SQL Developer plays a critical role in designing, developing, and maintaining database solutions using PL/SQL for efficient data management. They are essential in ensuring optimal performance, reliability, and security of the databases within the organization.
Role: PL/ SQL DeveloperExperience: 4-7 yearsLocation: Navi MumbaiNotice Period: Immediate to 15 days notice period max Required Skills:-· PL SQL Developer with Java· PLSQL with Oracle 12C,Oracle 19 C
Key Responsibilities:
- Write and optimize SQL queries and stored procedures to support application development
- Design, develop, and implement database systems and programs using PL/SQL
- Conduct performance tuning and query optimization for efficient database operations
- Create and maintain technical documentation for database solutions and processes
- Collaborate with application developers to integrate databases with applications
- Ensure data security and integrity through proper access control and backup/recovery processes
- Troubleshoot and debug database-related issues and provide timely resolutions
- Participate in database design and architecture discussions to support business requirements
- Perform data analysis and reporting using SQL and PL/SQL
- Participate in code reviews and provide constructive feedback to improve code quality
- Stay updated with the latest database technologies and best practices
- Collaborate with cross-functional teams to support database-related initiatives
- Contribute to continuous improvement of database processes and methodologies
- Provide technical support and guidance to junior developers and team members
- Assist in database migrations, upgrades, and patches
Required Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field
- Proven experience as a PL/SQL Developer or a similar role
- Strong proficiency in PL/SQL programming and database management
- Expertise in writing and optimizing complex SQL queries and stored procedures
- Thorough understanding of database principles and architecture
- Hands-on experience in performance tuning and query optimization
- Good knowledge of database security and data integrity principles
- Experience with database design, development, and implementation
- Proficiency in troubleshooting and debugging database-related issues
- Ability to collaborate effectively with cross-functional teams
- Excellent communication and teamwork skills
- Strong analytical and problem-solving abilities
- Familiarity with data analysis and reporting using SQL and PL/SQL
- Understanding of code versioning tools such as Git
- Relevant Oracle certifications would be a plus
- Ability to prioritize and manage multiple tasks in a dynamic work workplace