PL SQL Developer

As a SQL Developer, your role involves developing, optimizing, and maintaining SQL queries, PL/SQL stored procedures, functions, packages, and triggers. You will write and optimize SQL Functions such as string, number, date, conversion, aggregate, Window Functions like RANK, DENSE_RANK, ROW_NUMBER, LEAD, LAG, SUM OVER, moving averages, and CTEs (Common Table Expressions) to ensure cleaner and modular queries. Additionally, you will be responsible for database design, normalization, indexing, and schema management. Your tasks will also include creating complex queries for reporting, ETL, analytics, and dashboards, as well as conducting performance tuning through execution plan analysis, indexing strategies, and partitioning. It will be your duty to implement data validation, constraints, and business rules at the database level, support data migration, integration, and transformation projects, and collaborate with developers to design backend database logic for applications while ensuring data security, compliance, and integrity in all deliverables. Key Responsibilities: - Develop, optimize, and maintain SQL queries, PL/SQL stored procedures, functions, packages, triggers. - Write and optimize SQL Functions, Window Functions, and CTEs for cleaner and modular queries. - Perform database design, normalization, indexing, and schema management. - Create complex queries for reporting, ETL, analytics, and dashboards. - Conduct performance tuning including execution plan analysis, indexing strategies, partitioning. - Implement data validation, constraints, and business rules at the database level. - Support data migration, integration, and transformation projects. - Collaborate with developers to design backend database logic for applications. - Ensure data security, compliance, and integrity in all deliverables. Qualifications Required: - Strong proficiency in SQL (DDL, DML, DCL, TCL). - Hands-on experience in PL/SQL programming including procedures, functions, packages, and cursors with exception handling. - Experience with partitioning, bulk operations, and advanced PL/SQL features. - In-depth understanding of SQL Functions, Window Functions, and CTEs. - Expertise in query optimization and performance tuning. - Strong foundation in data modeling and relational database design. - Familiarity with ETL processes, reporting tools, and data migration.,