Manoj R

About Manoj R

Over 7 years of hands-on experience as an SQL Developer with strong expertise in database development, support, and optimization across production, staging, and development environments. Proficient in tuning SQL performance using EXPLAIN plans, optimizer hints, SQL trace, and TKPROF to ensure optimal query execution and system efficiency. Successfully designed and deployed Oracle databases on high-performance platforms like Exadata and Supercluster to enhance scalability and reliability. Skilled in writing complex SQL queries with joins, subqueries, set operators, rollups, and cubes. Experienced in creating external tables, optimized views, clustered indexes, and cursors to streamline data access and improve application performance. Automated recurring database and ETL processes using UNIX shell scripting and AutoSys job scheduling. Built parameterized SSRS reports integrating diverse data sources and ensuring high-performance rendering. Strong command over Informatica transformations including Expression, Filter, Lookup, Aggregate, and Update Strategy for building scalable ETL workflows. Implemented advanced PL/SQL features such as cursor variables, ref cursors, dynamic SQL, and nested tables. Well-versed with tools like SQL Loader, SQL Developer, SSMS, SSRS, TOAD, and SQL Plus. Involved in all phases of SDLC, delivering reliable database-driven solutions aligned with business needs. Managed table partitioning using range, list, hash, and composite strategies for large datasets. Developed and maintained packages, procedures, triggers, functions, indexes, sequences, grants, and synonyms. Handled user roles and privileges for secure and structured access across Oracle and SQL Server environments. Enhanced and maintained existing ETL workflows with a focus on performance, reusability, and scalability. Built Power BI dashboards combining multiple data streams to deliver actionable insights. Quickly resolved critical database issues to ensure business continuity and minimal downtime. Experienced in patching and updating Oracle and SQL Server databases. Created Tableau visualizations to present complex datasets in simple, accessible formats. Developed installation scripts in SQL/PLSQL for managing exchange connections. Proficient in database security, materialized views, and writing complex stored procedures and triggers across Oracle, SQL Server, and MySQL.

Experience

1. Sql Developer

   Mastercard

   Jul 2024 — Present · O\'Fallon, MO, US

   Developed and maintained robust ETL workflows using SQL Server Integration Services (SSIS), ensuring reliable data movement across systems and adherence to business rules.• Designed and optimized complex database structures, including tables, triggers, indexes, and stored procedures, for efficient data management.• Provided ongoing monitoring and troubleshooting of MSSQL database environments, promptly addressing any issues to minimize downtime and optimize performance.• Developed and optimized T -SQL queries to validate and clean large datasets, ensuring data accuracy and integrity.• Created stored procedures, triggers, and functions in T -SQL to automate data validation workflows.• Utilized JOINs, CTEs, and window functions in T -SQL to perform complex data integrity checks and resolve discrepancies• Led the design and development of intricate SQL Server Integration Services (SSIS) packages, leveraging advanced control flow tasks and data flow transformations.• Enhanced event handling and error management within SSIS packages, utilizing PostgreSQL expertise to ensure seamless execution and effective user communication.• Facilitated smooth migrations of Crystal Reports to SQL Server Reporting Services (SSRS), enhancing report efficiency and streamlining data access for user communities.• Monitored and improved database performance using tools like SQL Profiler, implementing optimizations such as creating clustered and non-clustered indexes and indexed views.• Conducted data testing, cleaning, and standardization to meet business standards using SSIS tasks, ensuring data integrity and quality across platforms.• Gathered user requirements, designed software solutions and databases, and implemented automated batch processes and schedulers for data management tasks.• Environment: TOAD, SSMS, UNIX, Microsoft SQL Server Integration Services (SSIS), SQL Server, Windows, SQL Developer, Microsoft SQL Server Reporting Services (SSRS).