Manju H

Designed and developed Oracle database objects, including tables, views, indexes, and constraints, to support complex business processes. Proficient in writing and optimizing SQL queries, including scalar subqueries, inline views, outer joins, hints, and analytic functions, to retrieve and manipulate data effectively. Developed and implemented PL/SQL Packages, Procedures, Functions, Triggers, Collections, and robust Exception Handling to manage and migrate large and complex datasets. Expertise in SQL performance tuning and optimization using tools like Explain Plan, SQL Trace Files, and strategies involving Partitioning, Hints, and Indexing to achieve optimal performance. Managed data ingestion using SQL Loader, leveraging both Direct Load and Conventional Load methods for efficient data loading and transformation. Deep understanding of Oracle Database Architecture and experience applying best practices for database design, development, and maintenance. Designed indexing strategies and partitioning schemes to handle large datasets and ensure query efficiency. Developed and maintained Bash and Shell scripts to automate routine system tasks, monitor system performance, and manage backups. Well-versed in using Linux commands for file management, process handling, system monitoring, user management, and network troubleshooting.

Proficient in writing and optimizing SQL queries, including scalar subqueries, inline views, outer joins, hints, and analytic functions, to retrieve and manipulate data effectively. Developed and implemented PL/SQL Packages, Procedures, Functions, Triggers, Collections, and robust Exception Handling to manage and migrate large and complex datasets. Expertise in SQL performance tuning and optimization using tools like Explain Plan, SQL Trace Files, and strategies involving Partitioning, Hints, and Indexing to achieve optimal performance. Managed data ingestion using SQL Loader, leveraging both Direct Load and Conventional Load methods for efficient data loading and transformation. Deep understanding of Oracle Database Architecture and experience applying best practices for database design, development, and maintenance. Designed indexing strategies and partitioning schemes to handle large datasets and ensure query efficiency. Worked on automating server builds, configuration management, and application deployment using custom Bash scripts. Diagnosed and resolved system performance issues using tools like top, htop, iostat, vmstat, and other Linux utilities.