Database design, development, implementation, performance tuning, troubleshooting, and administration of Oracle, DB2, TOAD, UNIX, shell scripts, and test-cases.
Troubleshooting and resolving performance issues and tuning of Oracle 10g/11g RAC, production data Guard, and database security.
Implemented Oracle Golden Gate for disaster recovery and performance tuning. Created reports for the ETL process. This included installation of database, Listener, and security.
2. Developed scripts for data encryption, DDL, DML, and performed Oracle Golden Gate. Worked with the UNIX team to perform root cause analysis.
O performance tuning of Oracle database using Linux shell scripts, SQL Trace, TKPROF, explain plan, AWR, ADDM, STATSPACK, ASH.
4. Implemented partitioning, partitions, indexes, and dynamic SQL tuning using performance Monitor. Created and maintained database objects like tables, views, indexes, synonyms, sequences, and triggers.
Jack in the Box
Technical lead for the design and development of solutions for the business Analyst. Designed and developed the database and data models for the financial system.
Developed and maintained Oracle database and data models for the business Intelligence team to provide a means for the analysis of the data.
2. Developed and maintained data warehouse solutions using MS access, SQL Server and AP. Created and managed the process of creating and maintaining the contracts.
3. Designed and developed a new data warehouse using PowerBuilder to support the business requirements. This was a multi-tiered, multi-threaded RDBMS.
O lead the development of a new business process model for the enterprise. Responsible for the creation of technical solutions.