SUMMARY

• Dedicated Senior Database professional with ~10 years of DBA experience on multiple UNIX platforms (AIX, Solaris, Linux, Windows), and Open VMS with Oracle 10g/11gR2 RAC, Data Guard, ASM Oracle Grid, and RMAN.
• Experience of supporting more than 800 Database at enterprise level having mixture of Oracle Version 9i - 11g R2, RAC, Data guard, Hardware Clusters, OCFS2, ASM,OEM 11g-12c versions, Replication.
• Experience in installing Oracle 10g, 11g R2 Real Application clusters on different UNIX flavours, administering, and troubleshooting, managing cluster ware.
• Experience in handling large sized databases, handled up to 15TB size databases for PeopleSoft /SOA / Billing applications.
• Experience in handling multiple projects in setting up Golden Gate replication from scratch upto production implementation.
• Expertise in Golden Gate Installation, configuration and end to end management/troubleshooting and tuning of Golden Gate replication technologies.
• Experience in setting up DR database sites using Oracle Data Guard and Golden Gate replication. Handled 10+ projects for DR Recovery Exercise and setting up DR sites.
• Strong hold on Database performance tuning which includes Memory Tuning, Application Tunings, SQL Tuning and Network Tuning.
• Working Knowledge on database licensing options. Have done license requirement for current client for Database and Middleware products.
• Database cloning using RMAN duplication, user managed backups, SQL Backtrack backups etc. Having strong experience in refreshing database environments. Involved in RMAN backup & recovery Tuning.
• Attending incident bridges for any production issues and working with app team to solve the issues at earliest. Made sure that client SLA is maintained for all level severity issues.
• Responsible for managing the DBA team (20+) to work effectively in a business-critical production environment and in 7x 24 supports. Good history of bringing the DBA team and IT team to enhance the productivity.
• Directed the team to implement proactive database monitoring, and automation of database maintenance, diagnostic reports, databases repots & regular database operation tasks.
• Knowledgeable and hands on experience in Oracle 11gR2/10gR2 RAC implementation, RMAN backup/recovery Strategies, Data Guard implementation, ASM file system, Load Balancing and tuning database infrastructure.
• Steered myself towards optimal logical and physical database design, and effective capacity planning.
• Kept the databases on track with regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, and security administration.
• Effective leader in implementing multiple projects on schedule by hiring right resources, allocating the resource, team motivation and accountability. Strong communication skills in handling clients, users, other support organizations.
• Documenting new processes and updating existing process standards related to Database build, Backups, Restore, RAC and non-RAC cluster upgrades.
• Achieved the SOX/PCI security compliance for all financial databases. Worked in setting up Oracle Security like TDE, Oracle obfuscation packages.
• Experience in Oracle Middleware Technologies for Installing, configuration, and administration of Oracle SOA Suite, Oracle Service Bus, Weblogic and Java Based Applications.
• Expertise in setting up Oracle 12c Cloud Control Enterprise manager and handling end to end management of OEM 12c suite.
• Worked on relational and dimensional modeling and managed OLTP and data warehouse databases.
• Not afraid to roll up the sleeves and get hands dirty on Middleware/Data Management/reporting side, if needed.
• Complete understanding of Project Management, Requirement Analysis, Software Development Life Cycle, Software Configuration, Software Testing, and Software Quality Assurance.

TECHNICAL SKILLS

Hardware: IBM P-595 Servers, IBM-750s, SUN SPARC/5500/5000/10000, HP DL280/380 Servers, DEC-ALPHA/2100, DEC-ALPHA/4100 Clusters, HP-9000/V class, WIPRO Super-mini system (UNIX), Pentium PC’s.

Operating Systems: AIX 5.3/6.1, Solaris 10/8. Red hat Linux 5-6, HP-UX, Xen Server Virtualization, OPEN VMS, and WINDOWS

Database: ORACLE 11g/10g/9i, Real Application Clusters (RAC), Data guard, RMAN, Grid control, ASM, ORACLE Utilities (SQL*Loader, Import/Export), SQL*Net, MS SQL server 2000

Backup Utilities: RMAN, HP Omni Data Protector, SQL Backtrack, Export/Import, DataPump

Monitoring Systems: OEM, Oracle 12c Cloud Control, Golden Gate Director, Scripts based Monitoring

Scripting: PL/SQL, Shell programming

Replication: Golden Gate, IXION, Oracle Multi-master Replication, Data guard, VERITAS File System

ETL Tool: Oracle Data Integrator (ODI)

Oracle Security: Oracle Transparent Data Encryption, DBMS CRYPTO, Obfuscation Security

Oracle Fusion Middleware: WebLogic, Oracle SOA Suite, Oracle Service Bus, Oracle Transaction Manager

Software Configuration Tools: SVN, GIT

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior Database Administrator

Responsibilities:

• Working as database architect on prepaid technologies for Oracle 11g database performance management, restructuring of databases and schemas and coordinated with the development team for implementing data model changes.
• Planning for database upgrades and coordination with all infrastructure teams and impact analysis on database systems on critical factors.
• Responsible for reviewing the physical database design and provide the suggestions/modifications on physical design of the database for performance.
• Implemented Database Oracle Advanced Security in critical applications and databases.
• Implemented Golden gate replication methods between multiple databases. Implemented Golden Gate Director for monitoring Oracle Golden Gate.
• Involved and worked directly in migrating multiple Oracle Databases for cross platforms.
• Database Tuning using Oracle Advisor, ASH Reports, ADDM, AWR SQL Reports and Cloud Control.
• Worked closely with ETL developers and tuned data loading techniques and SQL queries.
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Directed a team of DBAs on activities like database upgrades, applying patches, data model changes, and security administration.
• Worked closely with data architects and implemented their logical designs into Physical design. Used Erwin as a modelling tool. Implemented partition strategies, index portioning methods, multiple index strategies based on the carnality, data compression techniques, and read only tablespaces.
• Involved in troubleshooting and documenting database problems and resolutions.

Confidential, Dallas, TX

Database Administrator/Technical Architect

Responsibilities:

• Lead a team of DBAs on 10g to Oracle 11g Upgrades, applying patches, and coordinated with the development team for implementing data model changes. Also, hands on experience with 11g upgrades.
• Responsible for reviewing the physical database design and provide the suggestions/modifications on physical design of the database for performance.
• Installed configured and maintained multiple Oracle 11g RAC databases and Data Guard instances to increase high availability, scalability and disaster recovery.
• Implemented Golden gate replication methods between multiple databases. Implemented Golden Gate Director for monitoring Oracle Golden Gate.
• Involved and worked directly in migrating multiple Oracle Databases for cross platforms.
• Database Tuning using Oracle Advisor, ASH Reports, ADDM, AWR SQL Reports and Cloud Control.
• Worked closely with ETL developers and tuned data loading techniques and SQL queries.
• Installation and Configuration of Oracle 12c Cloud Control setup monitoring for all Database and Middleware applications. Implemented Metrics, Notifications for all Oracle Systems.
• Installation and Configuration of Oracle Data Integrator (11.1.1.6) for ETL purpose. Deployment through ODI Studio for ODI code, patching, up gradation of ODI Tool and Maintenance.
• Implemented Oracle Business Transaction Manage for monitoring Business related services.
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Directed a team of DBAs on activities like database upgrades, applying patches, data model changes, and security administration.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN
• Worked closely with data architects and implemented their logical designs into Physical design. Used Erwin as a modelling tool. Implemented partition strategies, index portioning methods, multiple index strategies based on the carnality, data compression techniques, and read only tablespaces.
• Oracle Fusion Middleware Configuration and Installation (SOA, OSB, Weblogic)

Environment: HP DL360/380 Servers, Hitachi AMS2500/V9960 SAN Arrays, Oracle11g RAC, Data Guard, RMAN, ASM file system. Golden Gate, GG Director, Oracle 12c Cloud control, BTM, Weblogic, Oracle SOA Suite, Oracle Service Bus, Shell scripts, PL/SQL, SQL, ODI, SQL*Loader, Java, J2EE, Weblogic, Oracle Data encryption, SSL, and XML web services.

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Lead a team of 12 DBAs on Oracle 9i/10g/11g Upgrades, applying patches, and coordinated with the development team for implementing data model changes. Also, hands on experience with 11g upgrades.
• Responsible for reviewing the physical database design and provide the suggestions/modifications on physical design of the database for performance.
• Installed configured and maintained multiple Oracle 10g RAC databases and Data Guard instances to increase high availability, scalability and disaster recovery. Also, implemented Golden gate replication methods.
• Involved and worked directly in migrating multiple Oracle Databases from Sun Solaris/HP-UX to AIX based system.
• Database SQL Tuning using SQL Profile/Outlines, ASH and AWR reports.
• Worked very closely in implementing Oracle OEM Grid control and mentoring all the database through the grid. Also, analysed AWR reports daily and resolved the issues, if any.
• Worked with DBA team to perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Helped the DBA team to implement, tested and maintain backup and recovery procedures using RMAN
• Implemented Database Security using Oracle TDE and Oracle Ofuscation encryption.
• Involved in troubleshooting and documenting database problems and resolutions.
• Mentored and worked with the team on Database tuning, SQL tuning, OS tuning and IO tuning for better performance on the system.
• Instrumental in creating the backup/recovery and Disaster recovery strategies and helped the DBA team to follow them.
• Managed and worked with the DBA team to adhere the standard operating procedures, database standards best practices and published them in SharePoint location, which in turn produced consistent results.
• Keep updating the knowledge in latest technologies of Database Servers, SAN arrays, Database features and provided the right direction for better cost effective solutions.
• Tracked the team on regular DBA activities like database upgrades, applying patches, data model changes, new database server setup, backup/recovery, 7 x 24 support, on-call rotation and security administration.
• Hands on experience in Oracle RAC, OLTP, Data warehouse, Very large Databases(VLDB), Data Guard, RMAN backup/Recovery, Grid Control, SQL tuning, PL/SQL, and Shell scripts.
• Responsible for the DBA team to get Sarbanes-Oxley (SOX) and PCI compliance, and for satisfying SLAs.

Environment: IBM P-595/P750 AIX servers, HP DL360/380 Linux Servers SUN SPARC/6500/V880, Oracle 8i/9i/10gR2 RAC, Oracle Grid Control, Data Guard, PeopleSoft, WebSphere, SQL*Loader, PL/SQL, SQL, Java, J2EE, Veritas File systems, RMAN, Toad, Oracle TDE, DOM

Confidential

Oracle DBA/System Administrator

Responsibilities:

• Installation, configuration, administration, upgrade and tuning of Oracle Database on UNIX environment.
• Installation and Management of 10g RAC on windows server for two node cluster.
• ASM Management on Storage Area Network (HP - HSV 580 DS).
• Maintenance/conversion/data migration for Project databases.
• Maintenance of the existing modules according to the requirement of the work.
• Weekly uploading of the database for the new contracts which get booked.
• Monitoring and maintenance of database.
• Responsible for upgrades, fixes and customizing database whenever required.
• Responsible for task completion on timely and accurate basis.
• Controlling access permissions and privileges.
• Ensuring that storage, archiving backup and recovery procedures are functioning correctly.
• Involved in database cloning for testing purpose.
• Involved in running stats pack for monitoring the database instance status.