PLSQL Developer

Key Responsibilities:

PL/SQL Development

• Design, develop, and deploy PL/SQL programs including stored procedures, functions, packages, and triggers
• Write reusable and modular PL/SQL code following best practices and coding standards

SQL Query Development

• Develop complex SQL queries to extract, transform, and analyze data from large datasets
• Optimize SQL queries for performance and efficiency

Database Performance and Optimization

• Monitor, troubleshoot, and tune database performance to ensure high availability and reliability
• Identify and resolve performance bottlenecks, deadlocks, and long-running queries

Collaboration and Requirement Analysis

• Work closely with business analysts, developers, and other stakeholders to understand functional requirements
• Translate business requirements into efficient database solutions

Testing and Quality Assurance

• Conduct unit testing, code reviews, and validation of PL/SQL programs
• Ensure data integrity, accuracy, and consistency in database operations

Documentation and Maintenance

• Maintain technical documentation for database design, procedures, and workflows
• Provide support for existing database applications and implement enhancements as needed