Source description
About the role
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
More at CGI Information Systems and Management Consultants Private Limited