SUMMARY:

• 11+ years of experience as an ORACLE 12c/11g/10g/9i/7 DBA on different UNIX/Linux and Windows platforms advanced features including Oracle ASM 11g/10g and Oracle RAC 11g/10g, GRID, Dataguard
• Proficient in databases Performance Tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Installation, configuration and administering Oracle Golden Gate replication
• Perform various tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security
• 24*7 production database support with Support to developers & end - users
• Implemented RMAN backup (Full, incremental) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Performance Tuning i.e. tuning applications, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Successfully implemented logical standby database using Oracle Data Guard feature for High availability configuration
• Implementing the Golden Gate Unidirectional for reporting database
• Operational Responsibilities - Database refreshes/ backups, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Experience monitoring and managing the databases in OEM Grid Control (10g, 11g, 12c, 13c)
• Possessed a strong working knowledge of OAS 10g and web services technologies.
• Implement Oracle TDE column encryption for advanced security.
• Applied Java security patch to WebLogic server domains. Deployed Java EAR files.
• DBMS job and DBMS scheduler jobs, Ksh scripting - setup cronjobs, implemented nagios and em7 monitoring tools with SQL scripts
• Accessing remote database with DB link, HSODBC, ODBCINST and third party tools
• Working knowledge of SQL server 2008 and MySQL databases, Postgres
• Working experience of Tomcat/Apache, mid-tier applications like Weblogic 12c/ OAS 10g/Apex and upgrades/ http:/ WebServers/ Nagios monitoring tool/ EM7 monitoring tool

TECHNICAL SKILLS:

Languages: SQL,PL/SQL, HTML, DHTML, Bash, Pearl, Python

Database: Oracle 11gr2, 12c

RDBMS Tools: Toad, SQL*PLUS, RMAN, DGMGRL, ASMCMD, SRVCTL

Others: Microsoft Office, Microsoft VISIO, Microsoft Project 2003 Server

Platform: Unix (Linux, AIX), Windows

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

• Production support DBA. Responsible for other duties/projects as assigned
• Successfully migrated 11g/12c Databases and applications like Weblogic, Jboss from one location to other.
• Proficient in 10G/11G/12c RAC Installation/Maintenance and Troubleshooting CRS/Grid Infrastructure and ASM issues
• Extensively working on new builds of 11g/12c RAC / RAC - ONE / Data guard environments with ASM on Linux/AIX platforms.
• Extensively worked on Catalog databases for rman backup.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
• Well versed with Switchover and Failover of databases in Dataguard environment. Both manually and via DataGuard Broker.
• Worked on TDE encryption for security.
• Wrote .ksh script for automation purpose. Eg, Rman Backup report, DataGard Status report, Scheduled Jobs in oracle.

Environment: Oracle 7, 10g, 11g, 12c, SQL, PL/SQL, AIX/Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), Web logic, Oracle Application Server, Webcache Server.

Confidential, Duncanville, TX

Senior Oracle DBA

Responsibilities:

• Provided database support for production, two-node RAC and DG (physical standby) instances running on AIX and Linux, Periodically7 tested our DR strategy by doing switchover and failover exercises.
• Used RMAN and Datapump for backup, restore, recovery and refreshes Periodically leveraged oracle 11g’s ‘Duplicate from Active Database’ feature to clone Dev, Test/QA DB from production used Grid control and Toad heavily for administration, monitoring, scheduling and troubleshooting.
• Provides knowledge transfer to Government personnel and others as directed on Oracle database administration, stored procedures, packages and triggers
• Develops/Maintains Oracle database backup and recovery processes using tools such as Oracle Recovery Manager (RMAN), SQL-BackTrack.
• Good knowledge of SQL with Performance Tuning skills
• Experience implementing Oracle Real Application Clusters and Oracle Data Guard for high availability, data protection, and disaster recovery
• Supports real-time monitoring utilizing Oracle Enterprise Manager (OEM) for all Oracle databases. Uses Oracle Enterprise Manager (OEM) and/or other vendor software to monitor, measure, and maintain database and application server integrity through active analysis of performance measures
• Supports data integration and replication in heterogeneous IT environments utilizing Materialized Views
• Emphasis on implementing, planning, execution and delivery of many environments involving complex Oracle databases in support of critical and non-critical applications

Environment: Oracle 7, 10g, 11g, 12c, SQL, PL/SQL, AIX/Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), Web logic, Oracle Application Server, Webcache Server.

Confidential, Dallas, TX

Senior Oracle DBA/ WebLogic

Responsibilities:

• Responsible for database infrastructures, strategies, enterprise solutions, administrations.
• Led effort on consolidating small departmental databases into enterprise database thereby
• Saving licensing cost by $100K/year.
• Database upgradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g, 11g to 12c.
• Defined and implemented HA/DR solutions using Oracle Data Guard, Oracle RAC for the
• Company’s mission critical applications to maintain business continuity.
• Looking into day-to-day activities of Production database, monitoring its growth and performance.
• Successfully worked with Auditors and implemented PCI and SOX defined rules.
• Support PCI/SOX overflow activities. Responsible for tracking remediation activities on security vulnerabilities or risks.
• Successfully developed and implemented database auditing using Oracle LDAP and
• Windows Active Directories. Implemented Transparent Data Encryption and SQL net encryption.
• Worked on Backup and Recovery strategies, improve database functionality, consolidate databases, and provide periodic health check to ensure your system is operating at maximum efficiency.
• Extensive work on Service Oriented Middleware deployments that support complex and essential web services across the enterprise, including shared and dedicated, production and non-production environments.
• Experience in installation, implementation, maintenance, and operations of middleware and related infrastructure components.
• Upgrade and support middle tier software, Oracle Application Server 10.1 and 10.2 to Web logic 10g/ 12c, Apex 3/4.
• Experience with Java application support and troubleshooting.
• Strong understanding in PL/SQL and SQL and able to write SQL query.
• Actively participate in developing Shell scripts to automate and monitor.
• L1+ work for MySQL and SQL server.
• Working knowledge of ticketing tool (HP Service Manager/Remedy/ITSM7)

Environment: Oracle 10g, 11g, 12c, SQL, PL/SQL, Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), SQL server, MySQL, Web logic, Oracle Application Server, Apex, Webcache Server, F5, Tripwire, PRTG/Nagios.

Confidential, Milwaukee, WI

Senior Oracle DBA

Responsibilities:

• Involved as DBA for knowledge transfer activity
• Database support (Monitoring, Administration, and Tunings & Backup) in Oracle 9i, 10g, 11g, 12c
• Database up gradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g
• Responsible for implementation and management of Datagaurd (Logical database)
• Remote database administration of the instances
• Looking into day-to-day activities of production database, monitoring its growth and performance
• Experience on working on the DB’s hosted on Clustered Servers using Veritas
• Linux crontab configuration to automate the shell scripts
• Extensively worked on DBMS JOB and DBMS SCHEDULER
• Working on DR Drills
• Migration of codes from Oracle Database to Postgres
• Perform database software installation/patching/ up gradation to development, test and production servers
• Management of Oracle Instance, physical structure of the database like data files, redolog files, control files (mirroring of the control file) and storage management
• Creating users with restricted access, profiles and attaching them with users
• L1+ work for MySQL, Postgres and SQL Server
• Working knowledge of ticketing tool (HP Service Manager)

Environment: Oracle 8i, 9i, 10g, 11g, SQL, PL/SQL, Linux/Windows, RMAN, Oracle Enterprise Manager (OEM), SQL server, Postgres

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Extensively worked on datacenter migration and database upgrade
• Migrated database of different release from Solaris to Linux
• Database up gradation to its higher release like 10.2g to 11.1g and 11.1g to 11.2g
• Setting up Grid control 11gr2 infrastructure to monitor databases.
• Basic Unix Shell Scripting Knowledge(Actively participate in developing Shell scripts to automate
• The DBA processes for our Client for Service Improvement)
• Working on DR drill (RMAN and NetBackup tool)
• RMAN extensively worked on backup and restore strategies. Implemented backup and recovery of Databases using Recovery Manager, hot backups, cold backups and logical backups
• Create backup and verification policies
• Database support (Monitoring, Administration, and Tunings & Backup) in oracle 9i, 10g, 11g
• Apex application upgrade and configuration from release 3 to 4
• Working knowledge on Data guard (Transferring log files from primary to standby database and manually applying the logs at standby side etc.)
• Analysing the segment fragmentation and re-organizing tables and partition tables
• Performing Archiving and purging activity as per the policy
• Creating table partitions, monthly, daily & yearly
• Perform database software installation/patching/up gradation to development, test and production servers. Having knowledge in RAC Architecture, Installation, and administration
• Configuring ASM and creation of ASM database
• Configuration of Heterogeneous services and BI Tools for connection with Oracle Database
• Interacting with the oracle support (Oracle Meta-link) and open the Service Request (SR) in case of major issues
• Raising TAR and coordinating with Oracle Support in resolving Oracle issues
• Creating users with restricted access, profiles and attaching them with users
• Monitoring the table growth, database growth, current users, and system resource usage and so on
• Configured listener.ora and tnsnames.ora as on when required for clients
• Generate Root Cause Analysis (RCA)
• Linux Redhat 4, 5 OS configuration and installation
• SQL script, cronjobs, ksh scripting, dbms jobs/dbms scheduler job setup
• Monitoring tools setup. Nagios/EM7
• HSODBC, Apex install/upgrades, midtier application setup,
• Uploading/transferring by the help of SQLLoader, WinSCP, PSCP and other utilities
• Worked on ITSM ticketing tool team (ticket handling) and change management, also upgrade of remedy 25 TB plus database migration via SAN copy.

Environment: Oracle 10g/11gR2, SQL PLUS, PL/SQL, Solaris, Linux/ UNIX, Oracle Enterprise Manager (OEM), Nagios, EM7, Weblogic.

Confidential

Oracle DBA

Responsibilities:

• Responsible for both manage and support all Production, Development and Staging Instances of Oracle Version 8i, 9i and 10g.
• Maintaining databases in 24x7 Production environment
• Monitor and troubleshot various database remotely
• Also refreshing Database as per the requirements of the clients (CLONING, Export, Import, Datapump)
• Ensuring successful & periodical Backup & Restoration
• Develop, Implement and administer database policies and procedures
• Writing scripts for informing the DBA’s regarding the status, performance and Space Management of the Database
• Provide 1st level technical support and assistance to all database end-users
• Install new versions of database software and perform maintenance functions of the database
• Reorganization of tables, indexes, table spaces, data files, redo log files, and control file as per the requirements of the databases performance and space management requirements of the Servers
• Database Backup Management using exports or online backups/Data Pump
• Sox Remediation.
• Monitoring the database for CPU utilization and killing unwanted user processes
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management
• Administrating Database in various platforms like WINNT 4.0 / 2000, SUN SOLARIS, and HP-UX & Linux
• Create new Database, perform regular backup’s for all the database and main the DB’s
• Working knowledge of ITSM ticketing tool (Remedy 6)

Environment: Oracle 9i/10g, SQL PLUS, Unix/windows, Oracle Enterprise Manager, RMAN