SUMMARY:

• Oracle Certified Professional DBA in Oracle 10g & 11g R1,R2 and 12C for Grid Control with more than 18 years of experience on all releases of Oracle database starting from 7.3 to 11g (Release 2)on Red Hat Linux, Sun Solaris and Windows. Implementation of RDBMS concepts. Also experience of working on Microsoft SQL Server versions 2000, 2005 versions.
• Installation and Upgrade: Virtualization, Installation of 10g/11g on Virtual machine, Extensive Experience of installation, configuring, upgrade and administer Terabyte of Oracle Databases on Oracle 11g,10g/9i/8.x. Recently completed upgrade of oracle 10g to oracle 11g on Linux and Sun Solaris environments. Installation of M.S SQL Server 2008
• Oracle Web Logic Installation and administration: Oracle Clinical Application TMS (Thesaurus Management System) Installation, configuration and support. Grid Control 12c Management and configuration.
• OLTP Database: Managed OLTP database having 24 * 7 activities, Handled all the aspects of database design, administration, tuning, backup and recovery in Test, Development and Production environments.
• Performance Tuning: Used oracle provided tools like Stats pack, OEM, AWR, ADDM, ASMM, Oracle packages. Auto trace and cost of executing queries, also used third party tools like DBARTISAN
• Backup and Recovery / ERP: Configured and used RMAN for backup & recovery. Planned for backup strategies for Mission Critical databases and configuring Flashback databases for faster recovery. Planning resource for Future growth at enterprise level
• Data Migration, Load and Integration: Oracle Data Pump for export and Import. SQL Loader for loading the data in Oracle. Used M.S SQL SSIS Tool for data migration and integration
• Development work / Data Modeling: Used PL/SQL in stored procedures Functions, triggers & packages, Partitioning of very large tables, security through views and other objects like Materialized views. Erwin tool used for forward and reverse engineering, E-R Diagrams
• MS SQL Server Administration: Administered M.S SQL Server 2000, 2005 versions including Procedure, Function and packages, Data Migration experience using DTS/SSIS packages, Export of SQL Server database to Oracle and Vice versa.
• DML and DDL Commands: Extensively used for getting users, password and uptime information about databases.
• Data warehouse database: Experience working on Data warehouse database. The issues like designing Star Schema, Bitmap indexes, Dimension tables, parallel query, partitioning and performance tuning and related issues were handled. Data modeling, analysis of design, modeling and converting to physical design
• RAC and Data Guard experience and Grid Control: Managed, configuring, and administered Oracle 10g RAC (Rel.1&2) on Sun Solaris and Linux platforms. Oracle 10g and 9i Data Guard Configurations, SQL Server Cluster database Management.
• Position & Industries worked in: Worked as Team member, Team Lead as well, in education, entertainment, non-profit, Medical govt. and semi govt. sectors
• Worked as Adjunct Professor @ Johns Hopkins University & Virginia Tech University for Oracle Database management system. Presently working @ UMBC as Adjunct Professor @Columbia Campus.

EDUCATION:

• M.S (Organic Chemistry)

CERTIFICATIONS:
Informatics - Professional Training on Oracle DBA
CMS - Professional Training for database management
Oracle Certified Associate:

• 11g(database admin)
• 10g(database admin)
• 6i (Internet application development)

TECHNICAL SKILLS:
Operating Systems: Sun Solaris, Linux, Fedora, Ubuntu UNIX, Windows 2000, Windows XP.
Programming Languages: Oracle SQL, PL/SQL, T-SQL, MYSQL
Web Design Tools: Html, Java Script, Active Server Page, IIS
Databases: Oracle (11g, 10g, 9i, 8i, 8, 7.3 v), SQL Server (2005, 2000 & 7.0v)
Data Modeling Tools: Data Modeling (Erwin Tool), MS- Visio
ETL- Tools: DTS, SSIS, Informatica
Reporting Tools: Crystal, Oracle, Cognos
Other Applications: Ultipro, DBartisan

PROFESSIONAL EXPERIENCE:
12/04 - Present
Confidential, Washington DC
Client: Confidential
Senior Database Administrator & Architecture-Consultant

• Migration of 11g from old Server to new server
• Developing Test environment from RMAN backup from production
• Working with developers, Storage Management , CRONTAB and NOHUP Jobs
• Performance Tuning- I/O and CPU Utilization Monitoring

11/10 - 12/03
Confidential, Washington DC
Client: Confidential
Senior Database Administrator & Architecture

• Virtualization and installation of 10g,11g oracle databases
• Migration of Database Oracle10g and M.S SQL 2005 on new system
• Export Schemas and import into staging.
• Restore of Production database backup to Development and Test environments.
• Editing of scripts for creating schemas and objects
• DDL and DML Commands for reports to Management on regular basis
• Oracle Database Data Guard Management 10g, 11 g
• Policies analysis and Implementation
• Data Modeling using Erwin after putting the entities and relation etc
• RAC Setup and configuration, User creation, RMAN setup and Grid Control for Database management for different databases

11/09 - 09/10
Confidential, Washington DC
Clients: Confidential
Senior Database Administrator & Architecture

• Recently upgraded oracle 10g system to oracle 11g manually on Sun Solaris environment.
• RAC with two node environments on Linux managed with all the administrative activities like backup, setup of RMAN, Export AND Import etc.
• Interacted with Business analyst and development team frequently to make changes in design / add objects to physical design of the database, based on the requirements.
• Worked on Auditing and security with Oracle databases.
• Used oracle provided tools like ADDM, Stats pack, Tkprof, Explain plan, SQL Analyze, Oracle packages and tools like oracle enterprise manager and data control.
• Implemented Oracle 10g flash recovery area and flash back feature.
• Captured the database statistics and metrics for proactive database management.
• Configured Oracle Data Guard to ensure high availability, data protection, and disaster recovery for enterprise data.
• Configured standby databases as physical standby and logical standby databases.

04/08 - 09/09
Client: Confidential, Virginia
Team Lead (Senior Database Administrator and Architecture)

• Handled database size ranging from 25 GB to 4 TB on Linux / Windows environments
• Analyzing business requirements, gathering users and stake holder’s requirements, converting them into logical design, presenting prototypes to them etc. Once approved, designing physical database objects and their growth plan. Also helping developers to develop the application accordingly.
• Data Integration, data analysis for reporting point of view. Used Informatica for Data Integration , mapping and migration
• Creation & implementation of PL/SQL & Shell scripts with respect to automate scheduled jobs.
• Created RMAN based backup & recovery scripts for database.
• Performance Tuning of Production Databases using oracle provided tools like Stats pack, Tkprof, Explain plan, SQL Analyze, Oracle packages
• Writing production support documentation for supporting production RAC databases.
• RAC Setup and configuration, User creation, backup, RMAN setup

09/05 - 03/08
Client: Confidential, Washington DC
Senior Database Administrator

• Supported Payroll , HR and Planning departments clients (39)
• Establish and maintain backup and recovery policies and procedures. RMAN Implementation with recovery catalog.
• Migration of database using DBUA from 9i to 10g, Export/Import, Data pump & using scripts.
• M.S SQL SSIS Packages and Installation of 2005. Database Administration, backup and recovery etc.
• SQL tuning using explained plan, TKPROF, AWR, ADDM
• Dataware House database Management and administration
• Administration of all database objects, including tables, clusters, Indexes, views,
• Sequences, packages and procedures

06/04 - 09/05
Client: Confidential New Jersey
Sr. Database Administrator

• Development patches deployment in test , development and production environments
• Managed dataware house database Oracle 9i and 10g for administration and tuning.
• Interacting with Business analyst for enhancement of the application.
• Data integration, Migration using M.S SQL Server DTS packages.
• Performance tuning, Stats pack Report and Individual SQL Statement Tuning -consuming High CPU Usage.
• Backup and recovery of database using RMAN.

05/03 - 06/04
Client: Confidential, Virginia
Database Administrator

• Oracle-9I, SQL Server 2000 on Windows environments.
• Management of web based application
• Students Training for Oracle 9i database management system
• Develop reports for the management.

03/99 - 05/03
Client: Confidential, Virginia
Database Administrator

• Oracle-9I, SQL Server 2000 on Windows environments.