NARENDRA RAYAPPA
Glen Allen,VA
Summary
Highly accomplished, deeply-driven, Professional Oracle Database Administrator with 18+ years’ experience with a profound knowledge in Database Security and User Management, Backup and Recovery, Database Design, Expert in Performance tuning and monitoring, Migration , Upgrades , cloning and replication. Proficient in an assortment of technologies including Oracle 19c/12c/11g running on UNIX flavors (LINUX, AIX, SOLARIS, HP-UX) & Windows environments. Exceeds ongoing and overlapping deadlines in fast-paced environments.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Sr. Oracle Database Administrator
Health & Human Services, TX
10.2022 - Current
- Perform Database upgrades, migrations, take logical exports from QA, DEV etc instances and importing the data on to the productions systems
- Deployed and managed Oracle 19c Autonomous Database instances for scalable, self-managing database environments
- Installed OEM agents and managing databases using GRID Control 11, 12c/13c EM
- Utilized Oracle Data Integrator (ODI) for ETL processes, integrating data from various sources into Oracle 19c databases
- Designed and implemented data warehousing solutions using Oracle 19c, ensuring data integrity and high performance
- Configured and managed Oracle Enterprise Manager 13c for centralized monitoring, alerting, and administration of Oracle 19c databases
- On-call for supporting OCI migrations, Engineered systems escalations
- Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL
- Trace, AWR and ADDM reports
- Provided support on performance issues during project development resulting in improved response times and reduced contention
- Led and executed database migration projects from legacy systems to Oracle 19c, ensuring minimal downtime and data integrity
- Tuned and optimized in-memory column store settings to achieve significant performance gains for analytical queries
- Experience in installation of high availability RAC environment (2,3 and 4 node clusters) and upgraded standalone databases to 12c/19c RAC environment
- Troubleshooting typical Oracle Golden Gate technical problems such as unique key violation / Long transaction abend by using GGSCI / Log dump / discard file analysis etc Architecting, planning, designing, developing, deploying and supporting 19c/12c/11g Oracle RAC, Exadata, Golden Gate, Active Data Guard and ASM environments
- Upgraded Oracle 11G RAC Databases to 12c/19c RAC with zero down time method using Golden Gate
- Used Data pump export/import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process
- Also, involved in tuning the performance of the application using Explain Plan, Sql Trace, and TKProf and Auto trace facilities
- Environment: Oracle 11.2 RAC, 12c, 19c, Data Guard, AIX: 64-bit, Red Hat Linux 8, HP-UX and Windows, ODI, Exadata X6, OEM
Oracle Database Administrator
AstraZeneca (INDIA)
01.2007 - 12.2007
- Automated refresh of non-production databases and PeopleSoft file system from production environment
- Tuning the Oracle database to optimize the performance by creating new Indexes, PL/SQL stored procedures and optimizing the SQL queries
- Unix Shell scripts for hot backups, SQL
- Loader, export and import of database
- Scheduled UNIX cron jobs to Monitor and advice of database health
- Experience in the design and architecture of complex, distributed, highly transactional database systems, including specification of hardware and storage infrastructure requirements
- Monitoring the database for CPU, Memory and I/O utilization, and other I/O related
- Managing all the data files, redo log files, control files, archived log files
- Created database, database links, communicated with the production server through remote access
- Controlled and monitored user access to the database and maintained system security
- Environment: Oracle 10.2.0, PeopleSoft, HP- UNIX 11.23, Sun Solaris 8, Windows NT.
Sr. Oracle Administrator
Kaiser Permanente
09.2014 - 09.2022
- Used Data pump export/import to instantiate SCN to avoid conflict at destination, created different rule sets to propagate and apply process
- Deployed and managed Oracle 19c databases on Oracle Cloud Infrastructure, leveraging OCI services for scalability and high availability
- Managed and optimized Oracle 19c Multitenant architecture, including multiple PDBs within a single CDB for resource consolidation and simplified management
- Configured Oracle Advanced Security options, including Transparent Data Encryption (TDE), Data Redaction, and Oracle 19c Database Vault, to protect sensitive data and enforce security policies Installed OEM agents and managing databases using GRID Control 11, 12c/13c EM
- Provided support on performance issues during project development resulting in improved response times and reduced contention
- Identified, resolved, or provided recommendations to other different kinds of the performance
- Problems ranging from Database performance problems to I/O hardware performance problems
- Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
- Implemented SQL Plan Management to maintain consistent SQL performance by capturing and evolving execution plans
- Utilized SQL Plan Baselines to ensure that critical SQL statements use the best available execution plans
- Implemented Oracle Spatial and Graph features to manage and analyze spatial and graph data within Oracle 19c databases
- Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
- Resolved the issues in conflicts between the source and target database in Golden Gate
- Administered Oracle Exadata Database Machine, leveraging its performance and storage optimization capabilities for Oracle 19c databases
- Environment: Oracle 10.2 and 11.2 RAC, 12c, 19c, Oracle SOA Suite 11g – BPEL 2.0, Oracle WebLogic 11g, Active Data Guard, AIX: 64-bit, Red Hat Linux7,8 , HP-UX and Windows, AWS, SAN Storage and Tivoli Management Server, Oracle ZDLRA , ASM, Exadata X6.
Oracle Database Administrator
CIBA VISON (Novartis)
04.2008 - 09.2008
- I was Involved in Migrating all Customers from PeopleSoft Application to SAP Application with Usernames, Passwords and Encrypted Passwords
- Migrated 6000 plus customers from Peoplesoft to SAP and successfully implemented in Production
- Upgrade/apply patches, database administration, SQL/SQR tuning, Peoplesoft builds/migrations
- Design and Developed Test Cases according to Functional Requirements and design specifications of the application
- Functional and White box testing
- Code walk-through and review
- Interact with Business People and Developers to exchange the updated Functionality specification
- Uploading scripts provided by the DEV team in all Environments (SIT, UAT, STG, PRD) except Development system
- Tuning the Oracle database to optimize the performance by creating new Indexes, PL/SQL stored procedures and optimizing the SQL queries
- Also, involved in tuning the performance of the application using Explain Plan, Sql Trace, and TKProf and Auto trace facilities
- Environment: Oracle 10.2, HP-UX
Lead Database Specialist
PayPal
03.2009 - 08.2014
- Supporting Development, Test and Production Environment
- Installation and configuration of Oracle Enterprise Manager Cloud control 12c on RHEL Consolidated database creation in oracle 12c using multiple PDBs Tracked MS SQL Server activity, Query Performance and Disk usage activity statistics via Performance Data Collection
- Implementation of EM 12c installation for multiple data centres
- Tablespaces and Users Management Oracle Network Components Management RMAN: Backup and Recovery Strategy – Online Hot and Archive Backup Database Upgradation from 10g to 11g and 11gR1 to 11gR2 Transportable Tablespaces, data pump and export & import utility used to move the data and schemas Involved in identifying requirements using user stories Build up DG environment with 2 Physical standby servers Assigning tasks to team members, managing critical issues, L1 & L2 Support Weekly Reports and score card discussion with team members Knowledge sharing and Technical Discussion
- MS SQL SERVER 2005/2008 RDBMS database development including T-SQL
- Worked on M204 Database for Data Migration Project
- Generated periodic reports based on the statistical analysis of the data using SQL SERVER reporting services SSRS
- Environment: Oracle 10.2 and 11.2 RAC, 12c, Data Guard, AIX: 64-bit, Red Hat Linux 7, HP-UX and Windows, SAN Storage and Tivoli Management Server, ASM.
Oracle Database Administrator
FannieMae (Capital Markets)
10.2008 - 02.2009
- Undergone Knowledge Transfer of the existing system.(Capital Markets) Created SQL scripts to maintain a daily checklist to monitor the database growth, archive logs generation
- Purged Data based on RunId and DMRId’s in Development, Test and Acceptance Databases to restore memory
- Created 2009 Monthly Partitions to 10 tables and for one table Daily Partition and changed global indexes to Local Indexes
- Modified the datafiles and table structures according to the project requirement
- Cloned the production database to the test database at a weekly basis or per requirement
- Support Development, Performance and Test Environment
- Schema Refresh using traditional export/import or Data Pump utility Environment: Oracle 10.2 and 11.2 RAC, MS SQL Server 2008/2005, Stand Alone, AIX: 64-bit, Red Hat Linux 7, HP-UX and Windows
Database Analyst
J.P. Morgan Chase (INDIA)
08.2006 - 01.2007
- Involved in system analyzation and improving the performance of the entire System Capacity Planning, Designing, Estimation of team efforts, hardware & Software sizing Administered PeopleSoft, Oracle, Tuxedo, Application servers, Process Schedulers and WebSphere servers
- Monitored SQRs and Crystal reports in testing and production environment
- Unix Shell scripts for hot backups, SQL
- Loader, export and import of database
- Partitioned very large GL related tables using Range Partitioning to facilitate faster access of data
- Uploading scripts provided by the DEV team in all Environments (SIT, UAT, STG, PRD) except Development system
- Tuning the Oracle database to optimize the performance by creating new Indexes, PL/SQL stored procedures and optimizing the SQL queries
- Also, involved in tuning the performance of the application using Explain Plan, Sql Trace, and TKProf and Auto trace facilities
- Environment: Oracle 10.2.0, PeopleSoft, HP- UNIX 11.23, Sun Solaris 8, Windows NT.
Education
Bachelor of Science - Computer Applications
University of Madras
Chennai - India05.2000
Skills
- SQL, PL/SQL, Bash/Korn
- Oracle Database 9i/10g/11g/12c/19c
- Oracle Solaris 10X,11, Oracle Enterprise Linux 5X, Red Hat/Centos Linux, Windows 20XX, HP-UX
- Oracle X4/X6 Half/Full Rack Exadata Machine, Sun SPARC T-Series server, Dell/HP X86-64 box
- OEM 12c/13c
- GoldenGate Implementation
- Database Troubleshooting
- Oracle Database Administration
- Oracle Exadata Management
- Oracle Enterprise Manager
- Performance Tuning
- Oracle ASM Management
- Oracle RAC Configuration
- Database Administration
Certification
- Oracle Cloud Infrastructure Foundations 2020 Certified Associate
- Oracle Autonomous Database Cloud 2019 Certified Specialist
- Oracle Cloud Infrastructure 2019 Certified Architect Associate
- Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate
- Oracle Cloud Infrastructure 2019 Certified Architect Professional
- Oracle GoldenGate 12c Certified Implementation Essentials
- Oracle 19c DBA Certified Professional – 19c DBA OCP
- Oracle 11g DBA Certified Professional – 11g DBA OCP
- Oracle 10g DBA Certified Professional – 10g DBA OCP
- Oracle 9i DBA Certified Professional – 9i DBA OCP
Clientexperience
- Health & Human Services, TX, 10/22/22, 03/23/23, Sr. Oracle Database Administrator, 8
- Kaiser Permanente, 09/14/14, 11/21/21, Sr. Oracle Administrator, 12
- Paypal, San Jose, CA. (INDIA), 03/09/09, 08/14/14, Lead Database Specialist, 14
- FannieMae (Capital Markets), Herndon, VA, 10/08/08, 02/09/09, Oracle Database Administrator, 8
- CIBA VISON (Novartis), Atlanta, GA, 04/08/08, 09/08/08, Oracle Database Administrator, 4
- AstraZeneca (INDIA), 01/07/07, 12/07/07, Database Administrator, 3
- J.P. Morgan Chase (INDIA), 08/06/06, 01/07/07, Database Analyst, 6
Timeline
Sr. Oracle Database Administrator
Health & Human Services, TX
10.2022 - Current
Sr. Oracle Administrator
Kaiser Permanente
09.2014 - 09.2022
Lead Database Specialist
PayPal
03.2009 - 08.2014
Oracle Database Administrator
FannieMae (Capital Markets)
10.2008 - 02.2009
Oracle Database Administrator
CIBA VISON (Novartis)
04.2008 - 09.2008
Oracle Database Administrator
AstraZeneca (INDIA)
01.2007 - 12.2007
Database Analyst
J.P. Morgan Chase (INDIA)
08.2006 - 01.2007
Bachelor of Science - Computer Applications
University of Madras
- Oracle Cloud Infrastructure Foundations 2020 Certified Associate
- Oracle Autonomous Database Cloud 2019 Certified Specialist
- Oracle Cloud Infrastructure 2019 Certified Architect Associate
- Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate
- Oracle Cloud Infrastructure 2019 Certified Architect Professional
- Oracle GoldenGate 12c Certified Implementation Essentials
- Oracle 19c DBA Certified Professional – 19c DBA OCP
- Oracle 11g DBA Certified Professional – 11g DBA OCP
- Oracle 10g DBA Certified Professional – 10g DBA OCP
- Oracle 9i DBA Certified Professional – 9i DBA OCP
Similar Profiles
Garrett CottomGarrett Cottom
Director of Vaccine Operations at TX Department of Health & Human ServicesDirector of Vaccine Operations at TX Department of Health & Human Services
Maimuna IkerodahMaimuna Ikerodah
Program Specialist at TX Health and Human Services CommissionProgram Specialist at TX Health and Human Services Commission
Lynn HancockLynn Hancock
Customer Service Associate at TX Dept Of State Health ServicesCustomer Service Associate at TX Dept Of State Health Services