Enterprise Dba/ Middleware Admin / System Admin Resume
SUMMARY
- Seasoned Database Administrator with over 18 years of experience in teh Industry with exposure to several Domains, namely Toll Industry, Retail Industry, Banking Domain
- Investments Banking, Retail Banking, Private Banking, Global Finance, and Global Consumer Banking.Specialized in architecting and delivering Enterprise Systems.
- Architect and Implement Operating Systems (RedHat, Oracle Linux, AIX, HP - UX & Solaris), Databases(Oracle, MySQL, MongoDB) and Application Servers (OAS).
- Managed teams of System administrators, Database administrators, Data analyst and developers.
- Supported Java based Applications/OBIEE reporting Project and Application User Management environment in 24/7 model.
- Worked on Supercluster M7 administrating 3 node RAC databases, Deployed Oracle RAC 10 and 11.x as HA solution.
- Patches/upgrade RAC/non RAC Database systems and Solaris environments.
- Participate, validate and verify Business application strategies and testing.
- Propose, design, validate and implement Disaster Recovery Site and configured and performed Disaster Recovery using DATAGUARD/RMAN.
- Participate in identifying new tools to enhance teh existing Infrastructure Architecture and operations.
- Participate in planning and deploying Security and audit applications for Database hardening.
- Experience in different verticals like Toll Industry, Retail Industry, Banking Domain - Investments Banking, Retail Banking, Private Banking, Global Finance, and Global Consumer Banking.
- Extensive Experience in Performance Tuning.
- Deliver timely and quality incident resolution focusing on root cause analysis, prevention, and noledge transfer.
TECHNICAL SKILLS
Operating Systems: Red Hat Linux AS 5.11 and 6.4,Unix (Solaris 9/10,11, Tru - 64 UNIX), MS Windows server 2003, 2008 & 2012 .
Hardware: Oracle Supercluster M7,NetApp filer, Compellant, EMC2, Sun Fire Servers, Sun E series, Digital alpha series, DLT/SDLT Tape Drives, ATL, L80 Storage Array
Databases: Oracle 7.x,8.x,9i, 10g, 11g,12c,Sql Server 2008,Mysql, MongoDB
Scripting/Prog. Languages: Shell Scripting, Python.
Applications: Oracle 10g Application Server,Oracle APEX, Oracle OBIEE 11g and 12c, Apache, Oracle Weblogic Server,JBoss, dWEB, Summit, Report Servers, Risk Engines, Ifaces, PTSI, TSAR, Armor, Oracle Directory Server Enterprise Edition. OpenLDAP
Tools: Oracle Enterprise Manager Grid Control, DataGuard Broker, RAC, Rman, Uptime, Nagios, Cacti, AWR, ASMCMD, ADDM Reports, SQLBack Track, Tivoli Server Manager, ODMA, DBCA, MIG, Export/Import, Sql*Loader, Remedy, Toad, Control-M, Legato Networker 5.x/6.x
PROFESSIONAL EXPERIENCE
Confidential
Enterprise DBA/ Middleware Admin / System Admin
Responsibilities:
- Provide reports on findings and explanation on remedition and recommendation on remedition
- Provide guidance in implementing changes,patches and any maintenance activities.
- Approve and evaluate Change management Docs and implementation.
- Deploy Server on Solaris Physical Box both on ldom and zones, on VMware and UCS baremetals.
- Install and configure Databases from Glod Copy.
- Install and configure Fusion Middleware components.
- Deploy DR site and HA solutions, Test Backup and Recovery strategies
- Deployed end to end OBIEE 12c setup.
- Provide daily support for Data replication.
- Deploy Security Monitoring and Auditing Tools.
- Provide auditing support
- Provide PCI auditing and reporting solutions.
Confidential, Houston TX
TEMPPrincipal Oracle Database Administrator
Responsibilities:
- General Database monitoring, troubleshooting and Administration in 3 node and 4 node RAC database and Data Guard Environment.
- Performed Database Cleansing for PCI Compliance.
- Develop packages and procedures for Daily loads and Adhoc requirements.
- Managing Informatics Tool Power Center/Power Exchange installation, Failover to New Hardware and testing Functionality.
Confidential, Houston TX.
Sr. Oracle DBA/Middleware Admin - Team Lead
Responsibilities:
- Database administration, monitoring, patching/upgrades, troubleshooting and database backups using RMAN.
- Designed and Performed Disaster Recoveries by failing over to DR site and failback to Primary Site, both Datacenter level and single instance.
- Managed 3 database administrators,2 data analyst and 4 developers.
- Performed migration of Databases from Compellent SAN to Hitachi VSP without outage.
- Performed installation/upgrades of ASM/Database from oracle 10.2.0.4 to Oracle 11.1.06, 11.2.0.1 & 11.2.0.3, Oracle 11.2.0.1 to 11.2.0.3 using DBUA/catupgrade.
- Performed Physical Standby Database Set up and monitoring using Data Guard Broker.
- Installed, configured and administration of Oracle Application servers 10.1.2 and 10.1.3.
- Installation and configuration of Content Management Applications.
- Performed various Performance tuning activities, SQL tuning, memory tuning and DB me/O distribution which improved teh stability of teh Database performance.
- Involved in testing Oracle 11g reports using Web logic for upgrading from 10G AS to 11G.
- Responsible for identifying new tasks, assigning and delivering.
- Configured, scripted and set up automated jobs for different databases jobs and application vendors.
- Scripting using Bourne shell for various application related jobs.
- Tested moving standalone databases to RAC on Linux
Confidential, Houston TX
Database Consultant
Responsibilities:
- Database administration in Windows 2003.
- Trained Database admins with Daily DB activities, Backup and Recovery.
Confidential, Salt Lake City, UT
Oracle DBA/Middleware Admin - Consultant
Responsibilities:
- Database administration in Oracle 10g RAC environment and Oracle SOA Administration.
- Troubleshoot shell scripts, monitor blocking, re-indexing, add/resize data files, Performance tuning.