PROFESSIONAL SUMMARY:

• Professional and highly motivated; for 7 years of DBA and Development work and academic experience in the software industry with Oracle 11g R2, MySQL(4.x,5.x) and SQL Server 2000/2005/2008.
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, Oracle Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as Oracle DBA.
• Strong Oracle and MySQL skills but also significant general system administration skills on UNIX/Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Expertise with Shell Script, PHP backend, system integrations & development.
• Experience in the administration of Web based Internet/Intranet Client/Server multi - tiered distributed application, major in database technologies in Sales, Quality & Standards domains.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle 11g.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, database optimization with the help of explain plan.
• Experienced in implementing row data changes using DML(Lock Table, Call, Explain Plan, Insert, Update, Select, Delete, Merge), DDL(Update, Alter, Truncate, Create, Drop, Comment, Rename), DCL(Grant, Revoke) and TCL(Commit, Rollback, Savepoint, Set-A-Transaction) changes.

TECHNICAL SKILLS:

Operating Systems: Windows XP, UNIX, windows 7 & 8, Solaris, Red Had Linux Enterprise, IBM-AIX, HP-UX, SUSE Linux Enterprise, Windows Server 2003/2008.

Databases: Oracle 11g R1, 11g R2, Oracle 10g R1, 10g R2, Oracle 9i, SQL Server 2005, 2008, 2012, MS Access 2010, MySQL, IBM DB2.

Database & Multimedia Applications: SAP ECC 6.0, SAP NetWeaver 7.0, SQL*Plus, SQL Developer, SQL Data Modeler, SQL Server Management Studio Express, DBCA, DBUA, EMCA, OLAP, OLTP, Oracle Data Pump Utility Export/Import Processes, RMAN, OEM 12c Cloud Control, ODB Configuration Assistant, SQL Loader, Oracle Data Guard Software, Active Data Guard, Snapshot Standby Technology, Data Guard Switchover Process, Oracle Weblogic Server 11g/12c, Fusion Middleware, Oracle Net Configuration Assistant, Fusion Applications, Oracle Identity Manager 11g, Oracle RAC (Real Application Clusters), OEM 10g Grid Control, Oracle Access Manager 11g, GoldenGate 11g R1 R2, 12c v1, SOA suite, Portal, E-business suite 11i R12, Oracle Streams, Repository Creation Utility (RCU), Exadata, Exalogic, Oracle Jdeveloper, Oracle Jrockit JDK/JRE, SunDISK JDK/JRE, J2EE, Java EE, TCP/IP, DNS, BMC-Remedy ITSM 8.0, BMC-Remedy SRM 8.0, DGMGRL Client, Data Guard Broker Server Management, LDAP Directory Server Management, IBM Lotus Notes, IBM Lotus Sametime, Amazon Web Services (AWS), Oracle Application Express (APEX 4.1, 4.2.x), Amazon EC2 (Virtual Nodes/Servers), Oracle Coherence 11g 12c, Oracle Net Manager, Oracle Automatic Storage Management (ASM), Linux x84-64 VMWare, Putty, Toad v12

WORK EXPERIENCE:

Sysadmin/ Sr Oracle DBA

Confidential, Monterey, CA

• Monitor and troubleshoot database backups, disk space, and server availability.
• Maintained Enterprise databases using DML, DDL commands, and modified generated DDL scripts from Application Development team for object creations, modifications, deletions.
• Performed new database design, estimations for maximum server capacity based on storage space requirements, configurations, backups/Export dumps to Solaris filesystems, recoveries, security, schema changes, tuning and data integrity.
• Monitor access rights to servers/databases; assigned system/object privileges to users, roles connect, resource ; developed SQL commands to test increased access rights to existing and/or new account holders.
• Supported Oracle production databases as primary on-call DBA.
• Performed database administration duties including user account creation, password setup tasks.
• Provided operational support for Oracle 10g 9i database on Sun Solaris operating system/server.

Oracle EM 11g 12c Administrator

Confidential, Greater Pittsburgh Area

• Created administration group ex. 'NON-PROD 12c - MySQL Hosts' 'NON-PROD 12c - MySQL Databases'...Non-PROD targets; '12c - MySQL Hosts' '12c - MySQL Databases'...critical/PROD target
• Created notification rule NON-PROD PROD databases/hosts targets; Configured metric alert(CPU utilization, Memory Utilization, InnoDB row lock avg time, others); Enabled paging PROD targets 'SEVERITY=CRITICAL'/metric alert three time every fifteen minute; Enabled email notification NON-PROD targets 'SEVERITY=WARNING'/metric alert one time every thirty minute.
• Responsible 10g 11g agent migration to 12c OMS(Oracle Management Server); 10g 11g OMS agent(count 1600+) upgrade/and target migration(cluster database/RAC and database instance,+ASM instance, single node instance, MySQL database, listener, HAS-High availability service targets); --TEST 400+, QA 400+, PROD 800+
• Instructed/Trained other OEM team member steps follow to migrate OMS agent fully to 12c release version; Reviewed OMS agent migration ensure server/target ready return to DBAs.
• Functioned as primary/Sr. OEM migration resource 12c agent deployment QA TEST PROD server upgrade from 11g 10g OMS agent installs; Platforms SolarisSPARQ, Linux x86-64, AIX 5.3.
• Worked DBA teams enable EM monitoring for clustered/single node instance; Oracle/Windows host machines.
• Researched/then created target upgrade process for PNC Infrastructure and Engineering team; Built 1300+ page manual 11g 10g OMS agent upgrade to version 12c.
• Researched/Developed/Executed 'EMCLI' script on servers with 11g 12c OMS installs TEST QA PROD .
• Provided OEM support for Oracle Enterprise Manager Grid Control 11G/Cloud control 12C and targets Solaris SPARQ-64bit/Linux x86-64/Windows server 2012 hosts, agents, listeners, Oracle/SQL server databases ; Worked OEM 12c using auto-discovery/manually identify, add targets for servers/hosts.
• Worked to troubleshoot ValidateAndRefresh OEM jobs identify plugins (.opar) files unzipped to PLUGIN BIN directory/agent12c binary file ; 12cPreupgradeconsole patch applied to OEM 11.1.0.1 Grid Control .
• Provided OEM support for Oracle Enterprise Manager Grid Control 11G/Cloud control 12C and targets Solaris SPARQ-64bit/Linux x86-64/Windows server 2012 hosts, agents, listeners, Oracle/SQL server databases ; Worked OEM 12c using auto-discovery/manually identify, add targets for servers/hosts.
• Configured targets cluster database, instance, agent, host on production servers; Applied team-defined monitoring templates to target entries/improved performance on memory, I/O; OEM v12.1.0.4.
• Created patch plan using patch templates/OEM patching and provisioning; Patched OEM agents for target servers.
• Setup failover on clustered nodes for Windows server 2012 R2s; Configured/Installed OMS and virtual agents on QA/RND/PROD servers.
• Tasked with adding SQL Server database targets on OEM 12c PROD; Assigned physical/virtual host, agent, instance to administration groups.
• Along with Sr OEM resource, worked to apply Oracle patch two-node servers OEM 'test' instance; Enabled 'Enterprise Manager 12c Upgrade Console' functionality OEM 11.1.0.1; Server downtime required to patch OEM 11g home..Opatch utility.
• Staged upgrade 1500+ OMS agents; Validated OEM plugins software/package, upgradeable agents identified during validation.

Senior Oracle DBA

Confidential, Buffalo, NY

• Functioned as Primary resource for GoldenGate software build, configuration and administration using GGSCI client on AIX servers; Goldengate release version 12.1.2.0.
• Creation and configuration of Oracle database (POC) on test environment; ASM/12c database installs on Linux x86-64 VMware. Also created/managed user, tablespaces, datafiles
• Performed schema refreshes of test cert databases from PROD databases; using dumpfiles from nightly exports/direct import across network/DB links.
• Worked on high availability tools(Flashback database,RMAN backup) and setup restore points for required PIT recoveries.
• Supported Oracle production databases as primary on-call DBA.
• Monitored access rights to servers/databases; assigned system/object privileges to users, roles connect, resource ; developed SQL commands including DML DDL operations to test increased access rights to existing and/or new account holders.
• Exported privileged user's account from production database onto live environment during schema reorg operation; dropped database user with SQL statement 'Drop user /*username*/ cascade'; then restored user account by importing user into live database, querying data dictionary view for 'invalid' objects, compiling schema to change status for objects to 'valid'.
• Performed database administration duties including user account creation, password setup tasks. • Provided operational support for Oracle 11g databases on IBM AIX operating systems/servers.
• Configured automation for RMAN backups; monitored health of database instances using OEM grid control 10g, OEM cloud control 12c.
• Provided guidance for application owners on database/server requirements of parallel tuning environment.
• Worked to identify tuning problems in Oracle database using OEM grid control 10g; generated ADDM reports and reviewed findings such as system logjams causing slow run-time for executed batch jobs.
• Administered user access Auditing and security aspects of the database; PL/SQL programming.

Oracle DBA II

Confidential, Suitland, MD

• Tasked with interfacing with client in order to develop reliable backup and recovery technique.
• Performed various tasks in administration of databases including instance creation, performance tuning, storage management Multi Gigabytes ASM instance, and general troubleshooting; Participated in multiple database development activities such as SQL scripting, and various database server configurations and interfaces for disparate applications, servers, and systems Ex. SAS .
• Worked to new database installations, configurations, security implementing transparent data encryptions and schema changes, tuning and backups using export data pump utility ‘expdp’ command embedded in internally developed cronjob process shell script .
• Assisted in admrinistration for large RDBMS servers and application servers, Installation & Performance Tuning, & Security Management, Backups, Restores & Recoveries using RMAN and NetBackup software partitions including Netbackup clients, master backup servers, and Netbackup agent *Oracle version*.
• Performed new databases design, estimations for maximum server capacity based on storage space requirements, configurations, backups/Export dumps to RHEL filesystems, recoveries, security, schema changes, tuning and data integrity.
• Maintained Enterprise databases using DML, DDL commands, and modified generated DDL scripts from Application Development team for object creations, modifications, deletions.
• Provided DBA implementation and support for SAP/Oracle migrations and upgrades, including environments using Oracle Data Guard.
• Installed and configured multiple instances of Oracle 11g. Involved in the configuration of Oracle Patches/Upgrades.
• Administered Oracle and SQL Server databases to include database backup and restoration, performance tuning, database creation, replication and migration on Windows server instances and Linux servers. Designed and developed HR-related reports, interfaces, conversions, extensions and workflows.
• Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.
• Provided Oracle DBA (24X7) support to Florida Community Bank for their installs (Development, Test and Production Oracle 11g2 Real Application Cluster (RAC) Database).
• Wrote highly complex SQL, UNIX shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers & stored procedure to finish the project on time and save the organization cost.
• Consistent database security for different database schemas, and modified DML/DDL scripts for Oracle 10G, 11G databases.
• Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages, with active archived logs transfer to Standby/RAC databases.
• Administered user access Auditing and security aspects of the database.

Oracle DBA I

Confidential, Fairfax, VA

• Performed installations, new databases design, configurations, backups, recoveries, security, upgrades and schema changes, tuning and data integrity for UNIX/Linux servers and Windows Server 2003/2008 platforms.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files.
• Managed GoldenGate as a complement to Oracle's HA and DR systems.
• Involved in setups, configurations and management of Oracle Enterprise Manager 11g applications for Windows server 2003 environment.
• Configured Streams Replication for schemas and database objects by setting up capture processes for data loads, apply processes to propagate and data writes to target databases, row data changes including DML, DDL changes. Ex. 3 million data rows from the source database were applied/replicated to a target database within a period of 25 mins.
• Executed generated DDL scripts to create database objects (tables, views, materialized views, indexes and synonyms) on Oracle, SQL Server database instances.
• Worked with the Development team on the AWS Management Console; lending input as an Oracle DBA on best practice configuration, installation for Oracle RDBMS, including database design with application consoles (developed by adrenna development team) built on Amazon Web Services.
• Set up WebLogic domain with a single Server instance for developers on their windows server 2003/2008 and UNIX machines.
• Performed GoldenGate 11g installations, configurations, trouble shooting, and daily maintenance on Linux/Unix and Windows server 2003/2008 instances
• Prepared systems and supported QA team to tune SQL statements against database and its objects.
• Supported WebLogic Server Clustering, Load balance, Failover and Performance tuning.
• Worked closely with the chief architect to perform software configurations so they improved connectivity with the DBMS.
• Modeled, implemented and maintained Oracle advanced replication tools GoldenGate 10g, 11g and Oracle streams to provide data replication on source, target database servers for test, dev, and production environments.
• Wrote and edited documentation for user's manuals, system design and use case documents, requirements traceability and version description documents for Learning Management Systems.
• Installed Oracle Weblogic Servers on UNIX, Linux, Windows clients, Windows servers and Solaris environments.
• Replicated, extracted data and applied development database data to production databases using GoldenGate 11g.
• Installed and configured Oracle Fusion Middleware applications on Linux/UNIX domains.
• Trouble-shooting for different kinds of failures in Weblogic Servers, immediate fixture of the issue and performing root cause analysis.
• Administered user access Auditing and security aspects of the database.

Oracle DBA I

Confidential, Fairfax, VA

• Performed installations, new databases design, configurations, backups, recoveries, security, upgrades and schema changes, tuning and data integrity.
• Performed setup, configuration and management of Oracle Enterprise Manager 11g.
• Assisted in the integration of a bug tracking system into current enterprise’s production environment.
• Monitor and troubleshoot database backups, disk space, and server availability.
• Assisted in deploying application, database & OS upgrades as required.
• Migrated Non-ASM databases to ASM database environments with RMAN.
• Performed replications and extractions on oracle databases in production using GoldenGate 11g. 12c.
• Installed, configured and upgraded Oracle Identity manager on development, QA and Production servers.
• Trained less experienced personnel and collaborated with clients, analysts, engineers, and developers.
• Performed troubleshooting for the production issues related to re-deployed OIM applications.
• Installed and configured Oracle Fusion Middleware applications on Linux/UNIX domains.
• Responsible for implementation for fusion middleware applications which comprised of UNIX environment, Weblogic application server and oracle database.
• Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.
• Researched, then incorporated applied solutions for the Oracle Identity Manager (OIM) and Oracle Identity Analytics which included the automated provisioning for more than 80 connected systems and also manual provisioning for disconnected system for thousands of active users.
• Performed installations, maintenance for RAC, Data Guard, ASM environments.
• Assisted with high availability configurations using Oracle Flashback Features, and RMAN backups, restores and recoveries activities.
• Administered user access Auditing and security aspects of the database.
• Installed, configured and upgraded operating systems and software applications including database applications and associated peripherals on-site at multiple office locations.
• Assisted in configuring database security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts for single node, standby/Active Data Guard databases.
• Installed, configured and maintained wired and wireless networking technologies.
• Troubleshoot hardware and software issues.
• Assisted in the Installation, configuration and administration of Golden Gate replication software using ggsci scripting tool.
• Implemented 10g RAC/11g RAC/Active Data Guard with ASM files system using Oracle clusterware.
• Processed customer and account source documents by reviewing data for deficiencies.
• Provided system DBA engineering, implementation and support for Siebel Applications and SAP using Oracle databases in order to improve database availability, backups and recoveries, and performance tuning methods.
• Administered and maintained data entry requirements by following data program techniques and procedures.
• Performed software and hardware installations followed by the creation of manuals for future references.