PROFESSIONAL PROFILE:

• A vast amount of experience as a Data professional working for government agencies (US, State, and local), banks, fortune 500 companies, health care, Telecom, and small start - ups
• A professional who demonstrates a commitment to ensuring client success and satisfaction
• Clear concise planning and excellent analytical abilities

PROFESSIONAL SKILLS:

• Managed Dev, test, & Production VLDB, OLTP, & Real Time databases
• Installed, and managed Oracle high availability Data Guard (11G & 12c)
• Proactive Oracle infrastructure and capacity planning
• Performed upgrades & patching, SQL and index tuning
• Installed mysql, Apache and PHP lampstack on AWS EC2 instance
• Installed configured Oracle DBA training app using Wordpress
• Configured and brought up Oracle instance using Amazon web services RDS
• Connected in-house clients to AWS Oracle RDS over the internet
• Installed Amazon linux on EC2 instance AMI
• Configure DNS with Elastic IPs using the Amazon Management Console
• Wrote the code using Wordpress for the oraocp.com testing web site on EC2
• Created the Schemas, permissions and data in mysql running on AWS

TECHNICAL SKILLS SUMMARY:

Oracle RDBMS Versions 5, 6, 7, 8,8i, 9i 10g, 11g and 12c database administration and management.

Oracle11g R2 Real Application Clusters. Data Guard Physical Standby and Golden Gate replication Active - Active

Oracle Linux and UNIX SYSTEMS (HP/UX, Solaris, AIX) administration. Bash Shell scripting.

Linux systems admin adding users and assigning responsibilities

Oracle Fusion Discoverer, OBIEE and OBIA installation.

SQL*Plus and PL/SQL programming and development.

JAVA, JDBC, Apache, Oracle Fusion.

Oracle*Net and TCP/IP.

EXPERIENCE:

Oracle DBA

Confidential, Seattle, Washington

Responsibilities:

• Extensive DBA experience in supporting multiple instances of ORACLE database including Development, written over 100,000 lines of BASH shell scripting code.
• Managed all Virtual Servers and installed all Enterprise Linux on site. Installed and configured all production databases: mysql and Oracle Enterprise edition 11g and 12c. Setup Dataguard, RAC,
• Well versed with Database Administration, Cloning of Database, Backup and Recovery strategy using RMAN. Used RMAN to backup AWS databases to onsite for disaster recovery, replication and failover.
• Experience in using data pump import/export utility of ORACLE.
• Experience in Database Migration by designing and implementing database logical and physical storage structures.
• Migrated several applications and database to AWS EC2 instances.
• Move in house intranet (Apache, PHP, mysql, wordpress lampstack) to EC2. Deployed to Amazon Machine Image (linux). Performed all Linux systems Administration. Created all User account, configured kernel parameters, set the file permissions.
• Configured DNS and Amazon’s Elastic IP. Created the pem file for SSH access. Setup system and database backups from AWS EC2 to in house.
• Setup replicated environment mirror image of EC2 instances to onsite instances running Oracle Virtualbox and Linux 6 enterprise edition. Have worked with VMWare and Hyper-V virtual servers as well. Working as the linux systems administrator. Setting up all networking both private and public networks.
• Configured all clustering software and network configurations (virtual ips, scan addresses) to support shared storage (NAS/iSCSI) and mutlinode Real Application Clusters. Performed all clustering configuration (Kernel, file permission, ASM Shared Storage Array, group and user accounts)
• Experience in Optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Created Dataguard instance in house and applied redo from AWS EC2 RAC database.
• Strong Oracle PL/SQL development background besides DBA skills.
• Experience in database security strategies by creating database Implemented & monitored daily, weekly and monthly batch jobs in database.
• Worked with Automatic Storage Management (ASM) Oracle utility providing a simple storage management interface that is consistent across all server and storage.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Experience in analyzing database & rebuilding indexes to improve database performance.
• Applying oracle patches (CPU, PSU and ONE-OFF), using the OPatch utility and fixing bugs.
• Involved in software upgrades, installations and migration of database as and when required.
• Supported and provided Oracle DBA on-call after hours support for a 24x7 production environment.

Oracle DBA

Confidential, San Francisco, California

Responsibilities:

• Oracle Database Administrator providing 24/7 production support of Oracle 11g RAC
• Proficient in DBA activities such as installation, creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical

Oracle DBA

Confidential, Houston, Texas

Responsibilities:

• Standby database (Data Guard), Materialized views, Streams Replication.
• Database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis and Design
• Backup and recovery with RMAN.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Excellence in Performance Tuning using TKPROF, EXPLAIN PLAN, SQL TRACE
• Proactive monitoring, identifying areas that need to be improved in the application and database using OEM Grid Control.
• Experience with writing PL/SQL Packages, Stored Procedures, Functions and Triggers.
• Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.

Oracle DBA

Confidential, Orange, California

Responsibilities:

• Cloned/Refreshed Oracle Databases and Oracle Applications for development
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Involved in taking Backups using Oracle Recovery Manager
• Development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.

Oracle DBA

Confidential, Las Vegas, Nevada

Responsibilities:

• 24x7 production database and applications support.
• Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
• Converted single instance to RAC Added nodes to RAC
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in database cloning, tuning, patching and monitoring
• Performing Backup/Recovery of Oracle databases.
• Implemented RAC and Standby databases for high availability/ disaster recovery purpose.

Oracle DBA

Confidential, Vista, California

Responsibilities:

• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, data files, and Block Corruption.
• Developed stored procedures, packages and database triggers.
• Proactive analysis of systems using various monitor shell scripts.
• Experience in monitoring and tuning system resources associated with the database performance.
• Create tablespaces, tables and indexes, sizing the tablespaces, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Involved in the migration of databases from Windows to Linux
• Automation of Startup, Shutdown on all production and development databases.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installation of Oracle on HPUX and AIX.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Provide user account administration: ptimizing SQL queries ptimizing developer code manage table partitions large data sets created reports using SQL
• Backup and Recovery via RMAN scripts and troubleshooting.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Handle service requests from the business using Helpdesk Service Management.

Oracle DBA

Confidential, Princeton, New Jersey

Responsibilities:

• Upgrade of Database from 9i and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM (Automatic Storage Management).
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.