Summary

• More than 13 years of progressive experience as Database Administrator of Oracle Database, Oracle Application Server, MS SQL server and IBM DB2 database includes installation, setup, creation, configuration, tuning, migration, upgrades, logical and physical database design, backup, recovery, partitioning, replication, shell scripting and maintenance processes on heterogeneous operating systems including Solaris, HP Unix, Linux,Tru64 Unix and Windows.
• Over 21 years of IT working experience with a proven background of technical problem solving. a self-motivated, responsible, and reliable team player with a set of very strong technical skills.
• Extensive experience with database architecture, relational and object relational database design, development, coding and testing of business/commercial applications using Oracle database, MS SQL Server Database, SQL, PL/SQL, SQL Plus, Oracle Forms, Oracle Reports, Oracle Designer, SQL Loader, Oracle Export/Import, Oracle Data pump, TOAD, T-SQL, DTS, SQL Query Analyzer, INFORMATICA etc.
• Over one year of experience as IBM DB2 Database Administator.
• Over one year worked as a Microsoft SQL Server 2000 database administrator in National Institute of Health NIH , Maryland.
• Customer service oriented, strong analytical, problem-solving and conceptual skills.
• A solid understanding of business functions, systems and data.
• Strong understanding of networking, platforms, OS management, trouble shooting, networking, hardware compatibility and system Administration on Windows, Unix systems.
• Strong understanding and experience of Oracle Hot/Cold backups, recovery, restore, copy databases, database scheduled jobs, cron jobs, RMAN backup and restore, Data guard, Oracle Enterprise Manager OEM , Explain Plan and SQL trace .
• Experienced with Data guard, Oracle10g Grid Control and Advanced Oracle Queue, partitioning and Basic Replication
• Developed or modified oracle backup and recovery scripts. Used Oracle backup utility RMAN and user-managed backup and recovery to implement oracle backup and performed a number of times of disaster recovery.
• Extensive knowledge of Oracle Real Application Clusters RAC databases .
• Developed distributed applications using Oracle Database, SQL, PL/SQL, Oracle Forms, Oracle Reports and Oracle Designer.
• Extensive experience in installing and upgrading Oracle 9i, 10g and Oracle 10g Application server, Oracle 10g Developer suits and Oracle Warehouse Builder OWB . Planning and creating the database and their objects tables, tablespaces, views, indexes, database links, triggers, packages, functions, procedures, synonyms, user accounts, roles, privileges and db links.
• Reporting the problems to Oracle, getting the latest patches and upgrades from Oracle and keeping in touch with the latest technologies of Oracle related products.
• Extensive Business knowledge and experience in Healthcare, Housing Finance Home Mortgage , Government, Manufacturing Chemicals Textiles and successfully executed projects for the Federal and State Government, Largest Home Mortgage company.
• Upgraded development, test, stage and production databases from 9i to 10g.
• Design and developed complex PL/SQL packages, procedures, functions and database triggers to applications.
• Developed ETL mappings for data extract and load using INFORMATICA 9.x
• Designed and Developed n-tier including business and data tier applications. Well versed with Back end, Middle tier, Front end and GUI Development.
• Strong Business and applications analysis skills with excellent communication and professional skills.
• Ability to adapt to fast changing skills and work
• Ability to work in-groups as well as independently with minimal supervision.
• Excellent problem solving, analytical and software technical skills.

Confidential

Position: Sr. Oracle DBA Consultant

• Provided Oracle Database administrative support for CMS PECOS and PDE projects with Oracle 11g/10g running on Linux, Solaris and Windows server.
• Designed and created database schema objects for the application
• Created new schemas with data from previous release objects to support development and system testing efforts for future releases including dot release.
• Provided assistance in logical and physical data modeling using ERWIN tool.
• Identified, resolved or provided recommendations to other different kind of the performance problems ranging from database performance problems to I/O hardware performance problems. The tools used mainly are Oracle Enterprise Manager, Explain Plan, SQL Developer and some my own scripts.
• Created materialized views for PDE project and scheduled to run an Oracle job to refresh them.
• Created new databases, schemas, users, roles, configure registry parameters, setup backups and recovery, schemas refresh and other monitoring scripts.
• Responsible for maintaining database objects/scripts in varies database environments Development, System test, Validation and Production .
• Migrated database schema objects from CGI environment to CMS databases.
• Developed PL/SQL packages, procedures and functions for PECOS project.
• Supported for data extract and data load using PL/SQL package and an ETL tool INFORMATICA 9.

Confidential

• Provided DB2 database administrative support for CMS HITECH project.
• Responsible for DB2 9.7 logical and physical database design, implementation and maintenance on Windows NT environments.
• Managed and resolved database issues during development.
• Developed some DB2 database operations and maintenance scripts.
• Updated reference data to CGI local databases from CMS environments.
• Helped the development team in writing/tuning SQL queries.

Environment: Oracle Database 11g/10g, SQL, SQL Plus, PL/SQL, Unix shell scripts, IBM DB2 9.x, JIRA, Sun4u SPARC, ZLinux64, Microsoft Windows Server 2003 R2, INFORMATICA 9.7, Erwin 7.2, Source safe, SVN, SQL Developer, PLSQL Developer

Confidential

Position: Sr. Oracle DBA

Worked as Oracle DBA in NIH eRA operations to maintain and monitor the IMPACII systems of development, test, stage and production environments.

• Install, configure and upgrade Oracle10g database software in Solaris 5000 Server, Tru64 Server and Windows.
• Refresh/Copy production data to Training database.

• Maintain and monitoring OLTP and Data Warehousing databases including Backup/Recovery.
• Worked on Oracle10g database migration from Tru64 Unix Server to Sun Solaris 5000 Server using Oracle tools Export/Import and Datapump.
• Wrote PL/SQL Packages, Procedures, Function, Database Trigger, PL/SQL script and Unix shell script as required for applications.
• Worked on trouble-shooting SQL query performance issues, application issues, Oracle Advanced Queues, unix cron jobs, oracle daily scheduled jobs, materialized view refresh, data problems and day to day database issues.
• Provides technical support to developers to write SQL query and data validations to ensure database data integrity.
• Resolved end user errors including application access issues, login problem, data errors etc.
• Worked on Deployment tickets to deploy in development, test, training, reporting database and production environments.
• Implement and maintain database security through granting and revoking privileges to user accounts.

Participate in a 24x7 on-call rotation in support of the production databases

Environment: Oracle Database 9i/10g, SQL, SQL Plus, PL/SQL, Unix shell scripts, Compaq Tru64 Unix Version 10.1, Windows 2003 Advanced Server, Windows XP, OEM,Clearcase, Oracle Designer, TOAD, SQL Developer

Confidential

Position: Oracle DBA

• Install, configure and upgrade Oracle database software and related products.
• My role and responsibilities maintain the backend database where the information stored, retrieved and updated test, train and production databases.
• Worked as Oracle DBA in Montgomery county government for the EJustice application. The Records Management System RMS will provide an integrated data repository that will contain Arrests, Incidents, Collisions, Citations, Warrants, Property, Field Interviews, Civil Papers, Domestic Violence and Investigations. Numerous stand alone databases and redundant data entry processes will be replaced by this unified and comprehensive RMS. The County's police agencies and Sheriff's Office will each be able to conduct their specific mission and at the same time share a consolidated database foundation of persons, events and criminal history. The Record Management System RMS also used by Department of Correction and Rehabilitation DOCR , and County Attorney's Office OCA .
• Implement and maintain database security create and maintain users and roles, assign privileges .
• Write Unix Korn shell scripts for database maintenance like backup, recovery, purge archive log files etc. in Test, Train and Production environment.
• Verify hot and cold daily backups in all three environment.
• Create and maintain the database replication in test, train and production environment.
• Deploys new application packages in test, train and prod environment.
• Write PL/SQL procedures, function, database trigger and packages as required for applications.
• Perform day to day database operations in test, train and production databases
• Perform problem determination and trouble-shooting of technical problems with the databases. Act as a liaison between application vendor Northrop Grumman NG and Bearing Point and user and achieves a timely resolution to related problems.
• Provide technical assistance to the user community and applications support staff.

Environment: Oracle 9i/8i, SQL, SQL Plus, PL/SQL, Unix korn shell scripts, SQL Loader, HP-UX 11, Windows 2000 Advanced Server, Windows 2003, Windows XP.

Confidential

Position: Oracle DBA

DBA for Oracle database, Oracle Applications Server and MS SQL/Server serving 3 remote locations, 4 Oracle Databases, 4 Oracle Application Servers and 15 Microsoft SQL Server databases.

• System analysis and architecture, capacity planning, backup/recovery, installation, configuration, monitoring, performance tuning, restructuring of databases, trouble shooting, migration and application development.
• Daily maintenance review, SQL optimization, checking daily DTS jobs, Design the DB schema and create any necessary database objects for the current Bio-informatics projects.
• Working closely with application developers and system administrators to ensure all database needs.
• Design through implementation of a comprehensive Microarray, SIMON referral system widely used system in NIH/NIDDK division.
• Other responsibilities include: DBA for all Oracle and SQL Server development, manage and maintain Web application based products manage programmers on various web based systems, maintain data interfaces with Oracle to SQL Server and vice versa.
• Provided initial installation, configuration and testing of Oracle's 9iAS Application server.

Environment: Oracle 10g/9i, Oracle AS 9i/10g, MS SQL Server 2000, Oracle Forms 10g, Oracle Reports 10g, SQL, SQL Plus, PL/SQL, T-SQL, DTS, SQL Query Analyzer, ERWIN, Sun Solaris 8/9, Red Hat Linux AS/ES 2.5, HP-UX, Windows 2000 Advanced Server, Windows 2003, Windows XP.

Confidential

Position: Oracle DBA/Developer

Project: Delaware Automated Correction System DACS

• Gathered User Requirements design, development, testing and implementation of the screens involved in the application using Oracle 10g/9i Database, PL/SQL Packages, Function, Procedures, Database Triggers, Oracle Forms 10g/5.0 and Oracle Reports 10g/3.0
• Application design based on n-tier Architecture.
• Designed Logical and Physical Data Model.
• Installing and upgrading Oracle 9i, 10g and Oracle 10g Application server and Oracle 10g Developer suits. Planning and creating the database.
• Creating new database tables, tablespaces, views, indexes, database links, triggers, packages, functions, procedures, synonyms, create user accounts, roles, etc. Give grants to user accounts.
• Allocating system storage and planning future storage requirements for the database system.
• Fine tuning of the Oracle Database and Oracle initialization parameter file.
• Making and writing scripts for Hot and Cold Backups. Performance monitoring, tuning and dividing administrator responsibilities. Created Backup Recovery procedures.
• Monitored and tuned online redo log mechanism, Undo segments and temporary tablespaces.
• Determined the SGA parameters depending on the memory, workload, concurrent users and expected database size to improve the performance.
• Creating and maintaining cron jobs.
• Written and tune SQL Query for optimal performance using EXPLAIN PLAN and SQL Plus Auto trace report.
• Deployment of Application on Test and Production Server and testing of application.
• Participated in full software development lifecycle.
• Responsible for the integration of software modules version control and packaging releases .
• Done unit testing, integration testing and regression testing.
• Testing of database, queries optimization and performance
• The Oracle based application allows the Department of Corrections to monitor and maintain all data related aspects of the offenders they manage such as criminal history, family details, offense, security level, length of sentence, housing, parole/probation details and other statistical details. The system provides beneficial information to their internal staff for day-to-day activities, to their management staff in planning for the future and to the external agencies such as Courts, Police, etc. in keeping the community safe and secure.
• The system includes a set of integrated modules including Central Booking/Intake, Classification, PreTrial, Special Programs, Case Management, Escapees, Movement, Disciplinary, Victim Notification, Grievance, Transportation, Sentence Calculation, Central Records, Facility Maintenance, Trust Fund Accounting, Health Medical, Visitation, Food Services, and Mail Recording.

Environment: Oracle 10g/9.x/8.0.4, SQL, SQL Plus, PL/SQL, Oracle Forms 10g/5.0, Oracle Reports 10g/5.0. Sun SPARC Solaris, Red Hat Linux, Windows NT 4.0 , Windows XP.