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
