Responsibilities:
Ø Developed various complex business processes using procedures, functions, triggers and packages.
Ø Tuning and optimizing current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regenerationandrebuild of indexes and creation of views.
Ø Extensively worked on PL SQL to generate various reports and implement complex business requirement.
Ø Decreasing Contention by appropriate Tablespace management and Sizing of objects.
Ø Tuning the database and assisting the other developers for the application performance tuning.
Ø Automated a lot of process to keep the systems up to date and to reduce manual errors by developing shell scripts.
Ø Responsible for taking hot backups and logical backups at schema, tablespace and database level.
Ø Database capacity planning and performance tuning.
Ø Extensively used Cursors and Ref Cursors in order to generate various reports.
Ø Requirement analysis and database design.
Ø Helped .NET developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC.
Ø Testing and implementation.
Ø Created schema objects like tables, indexes, views.
Ø Security Management using roles and grants.
Environment: Oracle 9i, Server 2000 Enterprise Edition, Windows Server 2003, C#, HP UX 10/11i, Oracle Enterprise, SQL developer, Toad 6, PL-SQL, Erwin, Crystal Reports 8.5
