Senior Oracle PL/SQL Technical Lead
HCLTech · State of Karnataka, India
HCLTech · State of Karnataka, India
Bengaluru, Karnataka Job Summary We are seeking an experienced SQL/PLSQL (Postgress) Developer to design, develop, optimize, and maintain database solutions. The ideal candidate should have strong expertise in SQL, Postgress PL/SQL programming, database performance tuning, and data integration, with experience working in enterprise application environments. Key Responsibilities Develop, test, and maintain Postgress SQL queries, stored procedures, functions, packages, and triggers. Design and optimize database objects such as tables, views, indexes, and sequences. Perform query tuning and database performance optimization. Analyze business requirements and translate them into technical database solutions. Develop ETL processes and data migration scripts. Troubleshoot production issues and provide timely resolutions. Ensure data integrity, security, and compliance with organizational standards. Collaborate with application development, testing, and business teams. Participate in code reviews and maintain technical documentation. Support deployment activities and release management processes. Required Skills Technical Skills Strong expertise in SQL and Postgress PL/SQL. **Experience with:** Stored Procedures Functions Packages Triggers Cursors Collections Dynamic SQL **Strong understanding of:** Database Design Data Modeling Query Optimization Performance Tuning Experience with Postgress. Knowledge of ETL concepts and data migration. Experience in debugging and troubleshooting database issues. Familiarity with Unix/Linux commands and shell scripting. Experience with version control tools such as Git, Azure DevOps, or SVN. Key Responsibilities null Other Requirements 1.Oracle Certified Professional (OCP) in Oracle PL/SQL is a plus. **#body.unify div.unify-button-container .unify-apply-now:** focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-