OBJECTIVE:

Pursuing for a challenging career as a Senior Oracle Database Administrator/Architect to utilize my knowledge, experience and intuition.

SUMMARY:

• Highly motivated and enthusiastic IT professional with proven experience in both team and project management capabilities.
• Demonstrated abilities in designing and managing Very Large Database Systems and Online Transactional Databases.
• Extremely self - motivated, enthusiastic, persuasive and goal-oriented, also work well as a team.
• Remain calm, focused and motivated to resolve any crisis/disaster promptly.
• Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.
• Installed, Configured, Managed Oracle 12c/11g/10g on AIX/Solaris/Linux/Windows
• Expert on Database upgrade and migration from 11g to 12c adopting new features
• Expert on Oracle High Availability Solutions ( Confidential / RAC/ ASM)
• Expert on Database tuning for best performance
• Designed, capacity plan and modeling of the databases, E-R Diagram
• Expert on deploy/maintain Oracle Enterprise Manager 11g/12c/13c
• Expert on Oracle Real Application Cluster, cache fusion, scan configuration
• System Administration on UNIX (Solaris/AIX), Linux and Windows
• Excellent Unix (ksh) shell script writer for efficient process automation
• Expert with cost based optimizer, performance tools like sqlT, Confidential & AWR
• Installed and managed DB2/PostgreSQL/Hadoop/MongosDB for POC projects

TECHNICAL SKILLS:

• Oracle RAC/ASM/RDBMS design, plan & install
• Oracle Performance Tuning using Confidential /AWR/OEM/SqlT
• Oracle Backup & Recovery Plan (RMAN)
• Oracle High Availability Solutions
• 11g/12c RAC with ASM, Confidential, Upgrade/Migration
• Oracle PL/SQL
• Unix (Aix/Solaris/Linux)
• Oracle Enterprise Manager 12c
• Pyhton/Perl/Unix Shell Script/
• WebLogic/WebSphre App Servers
• Informatica ETL Tool
• DB2/PostgreSQL/Hadoop/MongosDB
• Oracle SqlDeveloper/SqlT/Sqld360
• Data Modeler/Erwin ER

PROFESSIONAL EXPERIENCES:

Snr/Lead Oracle Database Administrator

Confidential, Richmond, VA

Responsibilities:

• Designed/Maintained relational database systems for a highly transactional and large database environment for Wholesale Product System of FRIT
• Schema design with Entity-Relationship, Normalization of data, Storage capacity plan with Automatic Storage Management, High Availability architecture with Real Application Cluster, Contingency plan for multiple sites with Confidential
• Elegantly customized automated script for Patch Set Update for specific requirement of Federal Reserve System, authored various scripts using ksh/perl/python script.
• Extensively used Active Session History ( Confidential ), AWR, sqlTxplan for performance analysis, sql tuning and implementation and Oracle Internals.
• Expert on troubleshooting RAC/ASM/RDBMS for debug log and trace analysis
• Enterprise class automated RMAN repository and backup system for multi-terabytes data with Virtual Tape Library system
• Upgrading to Oracle 12c with multi-tenant features, FlexASM, Adaptive Execution Plan, In-Memory Aggregation
• Expert knowledge on physical/logical Data Model with Oracle Data Modeler for Entity-Relationship Diagram, Informatica ETL tool usage
• ITIL certified for multi-layer support system using Remedy Application

Senior Oracle Database Administrator

Confidential, Washington, DC

Responsibilities:

• Architect, designed and maintained a very complex and highly transactional multi-terabyte database systems for Confidential .com (Internet Sales and Internet policy Holder Services) with 3.5 millions hits per day. Oracle database being the pivotal part for efficient data delivery with 3 seconds page turn; Confidential .com rated the best site for consecutive 3 years among the insurance industry for its Internet portal.
• Configured, construed, designed High Availability solutions for Confidential .com with Oracle 10g Real Application Cluster (RAC), Oracle Confidential on a remote DRP site.
• Design, deploy and plan for storage for terabytes of data storage with EMC Symetrix storage media; with proper data striping for high IO efficiency and automated BCV (Business Contingency Volume) script. Also, used Oracle Recovery Manager (RMAN) for database backup and recovery procedure where data stored in a VTL.
• Expert on Oracle internals, memory and resource management, data and storage layout, complex data architect and XML data types design with CLOB; cohesive and seamless integration with weblogic connection pool with JDBC driver for efficient data delivery.
• Proven record of accomplishment for effectively troubleshoot for any production issues with least MTTR, proactive monitoring of production databases to avoid performance demagogue.
• In compliance with Sarbanes-Oxley data security, Oracle security policy was in place, using standard security profile, role and policies. Implemented unique methodology for security compliance and auditing of databases.

Oracle Database Administrator

Confidential, Rockville, MD

Responsibilities:

• Installed & configured Oracle 8i on Sun Netra Server & Solaris 8 OS.
• Installed & configured Oracle Internet Application Server (9iAS) on Sun servers
• Performance tuning of the database, tuning Confidential and memory using enhanced oracle 8i features, designing tablespace, extents, with proper db block size, designing proper temp tablespace, redo log files, rollback segments with optimal configuration. Stored procedure, functions and Sql tuning using explain plan and Tkprof and informed developer to use proper optimizer mode, indexes or hints, etc.
• Installed Apache Web server ( Confidential ) and set tcp/ip tuning parameter, virtual web hosting, domain name registration, written test procedure for 9iAs application server.

Database Analyst

Confidential

Responsibilities:

• Installed and configured Oracle Database server with Enterprise Manager (including Storage Manager, Instance Manager, Security Manager etc). Defined or altered databases, tablespaces, instances and profiles. Created users and grant access to user tables, defined constraints, familiar with pl/sql scripts, stored procedures, and functions. Creating Data Dictionary views, maintaing control files, redo log files, rollback segments, Managing Tablespaces and data files, indexes, Managing audit, roles and User privilages etc. Database instance/profile setup, triggers, pl/sql loaders
• Performed Oracle database performance tuning, optimization of Data Storage, Extents, Defragmentation, networking database with TCP/IP setup, Database connectivity, setup Listener services and host name etc.
• Implemented Backup process and Disaster Recovery plan, copying Databases in different locations and modified profile, control files, rollback segment etc accordingly. Performed (direct/indirect) pl/sql loader for export/import options, Upgrading Oracle to higher versions, catprog/catlog scripting of Oracle.