Oracle Database Architect
Resume:
MANOHAR MUDI
*******@*****.***
SUMMARY:
Over 20 years of experience in Oracle Technology, Administration
* ***** ** ********** ** Oracle RAC database administration
2+ Year experience in ATLAS and FACETS application patching and maintenance
2+ Years of experience in Oracle Apps, OBIEE Administration & Development
15+ Years of experience in all oracle tools like PL/SQL, SQL Loader, expdp/impdp,
Installed and upgraded ORACLE 19c/13c/12c/11g/10g RAC and ASM on Linux and AIX
Installed and Configured Linux VM and Configured Oracle HA Cluster
Designed, Developed, Installed and Configured Oracle13c OMS Cloud Control
Created backup scripts and Automated RMAN Backup & Recovery operations
Expert level knowledge in Oracle Tools and Utilities
Implemented security plans for a secured Oracle environment
Created entity relational data model Star and Snowflake schemas
Designed and developed OBIEE Repository (.rpd), Dashboards and reports
Designed and managed ETL feeds and data extraction and loads
Sound knowledge of IBM, HP_UX, Sun Solaris, Linux Administration
Developed OEM and Shell scripts to monitor and maintain databases
Designed and developed several applications using COBOL, ORACLE and OBIEE
5 years of experience in batch and on-line processing using COBOL and JCL
1 Year experience in supporting Oracle19c on AWS Cloud
SKILLS:
RDBMS: Oracle(19c/13c/12c/11g/10g/9i/8i/7.x/6.0), RAC, SQL Server
OBIEE: OBIEE, Web logic, BI Publisher/Interactive Dashboards/Answers
Oracle Tools: Cloud, Golden Gate,ASM, RMAN, OEM/OMS, Active Data Guard, OCR, ADDM/AWR,
SQL Developer, APEX, PL/SQL, SQL, Datapump, SQL*Loader, WebLogic, Shareplex
ETL: VISIO, Oracle Warehouse Builder, COGNOS, Informatica
OS: Linux, OCFS2, AIX, Sun Solaris, HP-UX, Windows
Other: Shell script, DPA, Spotlight, DB Artisan, Banner, TOAD, ERStudio, Erwin, Java, XML & COBOL
WORK EXPERIENCE:
11/2019 to Current: Sr. Oracle DBA, Orbcomm, Oracle Cloud, ODA Oracle 19c/12c/11g RAC One node, AWS,Linux 5/6,
Dataguard, OEM, RMAN, ACFS, Datapump, APEX, SQL-Loader, PLSQL, Toad, DPA
Working as Database Architect, Database Designer and Senior Database Administrator
Responsible for providing all aspects of Database Engineering, Administration, support ing multi TB Databases
Installed Oracle12c database software and Oracle12c Golden Gate software
Designing proposed system; defining database physical structure, schema objects as per MAA architecture.
Identified and resolved database performance issues and OS level changes required on the servers.
Worked on Database performance issues and changed database structure and parameters for better performance
Recommended best partitioning and indexing strategies for performance and ease of maintenance
Wrote many data massgae plsql procedures to delete, update, move and backup Terrobytes of data.
Designed partition pruning, converted non-partition big tables to partition tables and loaded data
Converted Interval partitions to Range partition tables for ease of maintenance
Separated database tables and indexes as per the application design
Supporting Oracle and AWS Cloud, Production, QA, Test and Development Environments
Developed Application Development using Oracle SQL, PL/SQL, and APEX
Worked on data loading from flat files to fact and dimension tables using SQL*Loader
06/2014 to 3/2019: Database Administrator,1-800-Flowers, Oracle 13c/Oracle12C/11G/10g, AIX, Linux,
SUN OS, OEM, RMAN, Shareplex, Flashback, Datapump, SQL Developer, Toad
Maintaining and supporting multi terra-byte Oracle Apps and Oracle databases.
Managed Oracle Database, Oracle EBS and Offshore database team
Installed and configured Bi-directional Shareplex to replicate Oracle-to-Oracle replication.
Ensuring CDC, Shareplex and Oracle Standby databases are refreshed from time to time.
Installed and Upgraded Oracle 11g database to Oracle 12 Rel 2.
Designed, Developed, Installed and Configured Oracle13c OMS Cloud Control
Designed RMAN Backup and Recovery operations and ensure successful backups taken everyday
Working with SA team and make sure there is enough storage is allocated for database growth.
Experience in SOX IT General Controls compliance in the areas of Change management and approvals
Migrated ATLAS, MBP to new platforms, identify and decommissioned/EOL databases
Actively involved in in-house application deployments and migrations
Created SQL, PL/SQL and Shell scripts to provide periodic reporting and database monitoring
Worked on PUPPET auto setup on Linux and Oracle 12c documentation
Migrated Oracle databases from Unix to Linux 7 environment and Oracle 12c
Provided solutions for critical performance problems and improved database overall performance
Performed code reviews and identified logic flaw and gave recommendations to development teams
Tuned SQL Queries using explain plan, TKPROF with SQL trace and SQL Tuning Advisor
Created and Monitoring RMAN Full, Archive log and export backups
Handling day-to-day DBA activities and proactively working on database related issues and problems.
Providing 24x7 on-call support and coordinating with off-shore DBA team
Managing DBA Team and supporting enterprise Oracle database operations
12/2011 to 03/2014: Database Administrator, CDPHP, oracle12C/11G/10g, AIX, Linux, SQL Server, FACETS,
ASM, OEM, RMAN, Golden Gate, Flashback, Datapump, SQL Developer, Toad
Supported FACETS application and applied monthly Trizetto FACETS patches
Installed and configured Oracle12c/Oracle11g Oracle on Linux/AIX servers
Tested and implemented 12c/11g new features Multi-Tenant and Flashback database
Automated Fair Health Dental, HCPCS, MDR(Medical & Dental), Configuration backend loads
Designed, developed environment refresh schedules using Datapump and Golden Gate
Created RMAN catalogs, configured RMAN backups and restored the databases from corruptions.
Provided solutions for critical performance problems and improved database overall performance
Planned system growth and monitored database capacity usage for new hardware requirements.
Worked with architects and archived historical data, moved data to various data marts
Developed detailed documentation for FACETS patching, DR procedures
Provided on-call support in adherence to specific business and customer Service Level Agreements
09/2011 to 12/2011: Oracle DBA, Database Designer, Verizon Wireless, Oracle11g, Linux/HP-UX, OEM, RMAN, SQL Developer, PL/SQL Developer
Installed and created and upgraded Oracle 10g/11g R2, OEM, Grid Control and Oracle databases
Developed and setup database monitoring and maintenance scripts in UNIX and OEM
Refreshed and Clone Databases as per customer requirements
Maintained and supported multi-terabyte Data Warehouse and OLTP Production and Development databases
Implemented backup and recovery using RMAN in all environments
Planned for system growth and monitor capacity usage for new hardware requirements
Worked directly with software developers to develop and enhance applications and data conversions.
Provided technical guidance to DBA staff, Consultants and application developers
5/2007 to 3/2011: SUNY, Oracle 11g/10g RAC DBA, Database Designer,
Oracle11g/10g RAC, Linux, OCFS2, OEM, OBIEE Admin/Developer, Dashboard, Answers, PL/SQL Developer, VISIO and Banner
Installed and configured Grid Infrastructure and Oracle RAC databases
Implemented 2 Node RAC databases, Data Guard, Standby database with OCFS2 on Linux
Migrated Oracle 10g RAC/ Non-RAC Oracle databases to Oracle 11gR2 RAC using RMAN
Populated RAC databases using datapump from stand-alone database instances
Designed and developed the Siebel Analytics Metadata Repository (.rpd) for SUNY students repository databases
Worked extensively with Physical Layer, Business Layer and Presentation Layer
Created different types of Customized Reports Drilldown, Aggregation to meet client requirements
Managed security privileges for each subject area and dashboards according to user requirements
Imported Dimensions, Facts & Aggregates with Referential Integrity constraints into Physical Layer
Designed and developed backup and recovery strategy using RMAN, configured automated OCR backups
Designed Source, Staging area and Target tables, transformation and relationships
Developed BI dashboards, Answers requests, charts, pivot table layouts, dashboard prompts
SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor
3/2004 to 5/2007: Database Management Advisory, JPMorgan Chase, Oracle10g/9i, Oracle10gAS/9iAS, Customer Profitability Warehouse
Supported Oracle, OracleAS, Infrastructure, Middle Tier components
Installed and upgraded Oracle9i/10gAS and applied Oracle patches to Oracle and Oracle9iAS
Implemented standards across the systems and databases
Configured the kernel parameters on Sun Solaris and installed and created Oracle databases
Customized the environment setup scripts for Oracle and OracleAS instances
Developed and Customized RMAN backups and tested the recovery procedures with user participation
Customized the database as per the security baseline
Developed scripts to create, update, start and stop Oracle10g/9i Portal, J2EE, and BI_Forms
Developed scripts to deploy, redeploy and un deploy Oracle10g/9i Portal, J2EE, and BI_Forms
8/2002 to 3/2003: NY State, Oracle DBA, OTDA Warehouse Database, Oracle9i on HP-UX 9000 64Bit
Improved database performance by splitting the very large partitions in to small partitions
Tested and implemented locally managed tablespaces with extent managed auto feature
Created and maintained the automatic managed UNDO tablespaces
Restored and recovered the databases from media failures
Increased database performance by modifying the database structure and memory parameters
Created scripts to extract and load the data in to the warehouse database from text files
Created PL/SQL procedures to move data to resolved, pending, reject target tables
Identified and created required bit map indexes for query performance
4/2000 to 5/2002: FIDELITY INVESTMENTS, Oracle DBA for Equity Trading Warehouse databases, Oracle8i/9i, Sun Enterprise 6800/4500
Monitored and maintained Oracle distributed Trading databases across the globe 24/7
Created and maintained the snapshots for the required tables from the remote databases
Designed and Maintained Yearly/Monthly/Weekly/Daily partitions based on requirements
Designed and automated the process to create the tablespaces for these partitions
Automated archival process to purge older data and to load to the historical database
EDUCATION: Bachelor’s Degree in Science, Diploma in Computer Science
Contact this candidate