Wrote and modified Stored procedures, complex SQL queries for data extraction from SQL Server
Set up and managed database security by creating new users, roles, profiles, and provided required user privileges in development, test, training and production environments

Unit testing, performance measuring, profiling, tuning, and designed data structures, created ADF modules, entities, views, associations and view links to do object-oriented ADF components
· Analyzed network efficiency and provided routine software and hardware support.
· Analyzed diverse datasets and designed aggregated data views in Oracle DB, MySQL, and developed PL/SQL stored procedures to perform complex data oriented business logic.
· Created and monitored standby databases and ensured minimum downtime
· Aid in establishing and monitoring sound backup and recovery
· Assisted in the performing database tuning and performance monitoring.
· Assisted in performing backup and recovery of database and tablespaces

Create persistent, mapping and annotation objects from database tables by using Hibernate for DHR to upgrade SACWIS application. Created persistent, mapping and annotation objects from database tables by using Hibernate for DHR to upgrade SACWIS application. Perform database refresh from production environment to test environment.
· Evaluated clients Oracle database requirements and develop optimal solutions to address their needs
· Performed database, schema, tablespace cloning/refresh using Data pump (Import and Export) utility and RMAN
· Participated in large, complex Oracle database deployments, Migrations, consolidations and upgrades projects
· Tuned the database and handled Incident tickets to meet Clients Service Level Agreement (SLA)
· Troubleshoot database issues, rebuilt indexes and gathered/update statistics of tables to improve the performance.
· Edited Help Text documents using HTML Tags, and developed queries to retrieve, update, delete and insert data using SQL and PLSQL

Evaluated clients Oracle database requirements and develop optimal solutions to address their needs
· Performed database, schema, tablespace cloning/refresh using Data pump (Import and Export) utility and RMAN
· Participated in large, complex Oracle database deployments, Migrations, consolidations and upgrades projects
· Tuned the database and handled Incident tickets to meet Clients Service Level Agreement (SLA)
· Troubleshoot database issues, rebuilt indexes and gathered/update statistics of tables to improve the performance.
· Edited Help Text documents using HTML Tags, and developed queries to retrieve, update, delete and insert data using SQL and PLSQL
· Created persistent, mapping and annotation objects from database tables by using Hibernate for DHR to upgrade SACWIS application