Uploaded File
Jyothi
jbikkuma1@gmail.com
904-737-7717
Jacksonville, FL 32099
Oracle DBA Lead
23 years experience W2
2
Recommendations
Average rating
216
Profile views
Summary

  • Hands-on DBA Lead with 15+ years of experience in architecting, designing, consulting, tuning, supporting various versions of Oracle RDBMS, MS SQL Server and PeopleSoft environments. Experienced in monitoring and mentoring global DBA teams to perform timely upgrades. Mentored DBA teams to follow Change Management processes.
  • Currently lead two teams totaling 10 DBAs.
  • Responsible for leading 10+ end-to-end complex Oracle, SQL Server & PeopleSoft projects Implementations & Migrations.
  • Implemented follow the Sun strategy for global DBA teams and supported 24X7 clients.
  • Responsible for migration of Convergys Oracle, SQL Server & Peoplesoft Systems to NGAHR.
  • Responsible for Oracle database upgrades from 10g to 11g, or from 11g to 12c and SQL Server upgrades from SQL Server 2005 to 2008, 2012.
  • Experienced in Oracle 12c Cloud control and Oracle 10g OEM administration as well as RMAN and NetBackup technologies.
  • Experience in tuning databases with respect to Memory/IO/CPU and SQLs.
  • Successively executed multiple Disaster Recovery exercises using Oracle Data Guard & SQL Server log shipping.
  • Configured high availability for Oracle and SQL Server environments using Veritas Clusters.
  • Knowledgeable in Config, Setup, Design, Install & Implementation of Oracle 11g & 10g Grid/ RAC (Real Application Clusters) multiple RAC Node Configuration.

Databases: Oracle 12c/11g/10g/9i with RAC, MSSQL server 2008R2/2008/2005/2000

Operating Systems: Sun Solaris, Linux, AIX, Windows NT/2000/2008R2, VMware

Hardware: Sun SPARC Servers, Sun Cluster, Intel Pentium, Network, SAN storage

Languages: SQL, SQL*Plus, PL/SQL, Shell Scripts, Perl, Java, C, etc.

Oracle Tools: TKPROF, SQL*Loader and Export/Import, Data pump, RMAN, Data Guard, Enterprise Manager (OEM 10g), Grid Control (12c), Oracle Forms/Reports, Oracle APEX

SQL Tools: MSSQL Management studio, SQL Profiler, SSIA, SSAS, SSRS

PeopleSoft: PeopleTools 8.53/8.46, PeopleSoft HCM 9.1/8.9, Portal 8.9

Web Servers: WebLogic 10.x/8.x/5.x, Apache

Middleware: Oracle Fusion Middleware 12c, Tuxedo 10.x/8.1

Experience
DBA Lead
Information Technology
Aug 2010 - present
  • Working as hands-on Senior DBA Lead, managing enterprise database systems using Oracle RDBMS and MS SQL Server in Unix, Linux VM, Windows environments. Support PeopleSoft HCM and Portal systems. Provide support for diverse industry clients, including both data warehouse and OLTP systems. Major Clients: Fifth Third Bank, DuPont, Johnson & Johnson, Multi-client E-Case, ALM, HRW, BMC Technologies: Oracle 10g to 11g, 12c, SQL Server 2005 to 2008, Solaris 5.9/5.10, Windows 2008R2
  • Production support over 200+ databases across multiple platforms with sizes ranging from 2GB to 6TB.
  • Database Administration expertise includes installation, database creation and sizing, backup, recovery, optimization and performance tuning of Oracle 12c/11g/10g in Linux and Solaris environment.
  • Installing Oracle 11g/12c binaries and creating databases according to the customer requirement.
  • Upgraded Databases from 10g (10.2.0.4) version to the Oracle 11g (11.2.0.2 & 11.2.0.3) and Oracle 12c versions and applied timely security patches.
  • Configured Oracle Enterprise Manager Cloud Control 12c for all production and development databases. End to End monitoring implemented with OEM.
  • Involved in Datacenter move by copying databases from source to destination server.
  • Implemented database refreshes using various Backup strategies like RMAN, EXP/IMP, EXPDP/IMPDP.
  • Successfully implemented Disaster Recovery test using Data Guard
  • Various database performance issues fixed using AWR, Statspack and O/S level reports.
  • RAC administration using SRVCTL commands.
  • Managing services with SRVCTL commands
  • Monitoring the resources on multiple nodes.
  • Applying Patch on Cluster and database. Major Clients: Multi-Client RAMCO Payroll systems, Multi-Client e-HR (Amazon Cloud Solution), Multi-Client Authoria/eCase Technologies: SQL Server 2005/
Oracle DBMS Oracle 11i Oracle SQL Server SQL Production Support Performance Tuning Peoplesoft Disaster Recovery Database Backups Data Warehousing DBA OLTP Database Upgrades UNIX Cloud Solutions Data Center Windows
Remove Skill
References
Average Rating

2 recommendations
Sr.Oracle DBA
Information Technology
Jun 1999 - Aug 2010
  • As a Junior DBA and became senior DBA in time and handled major end-to-end projects implementation in Oracle, MS SQL and PeopleSoft environments. Major Clients: State of Florida, State of Texas, E-case, Fifth Third Bank, DuPont, Johnson & Johnson Technologies: Oracle 9i to 11g, SQL Server 2000 to 2008, Solaris 5.9/5.10, Windows
  • Production support over 400+ databases across multiple platforms with max size 3TB.
  • Installed, configured Backed up and Monitored databases of different Oracle releases 9i/10g/11g in different platforms like Linux, Sun Solaris
  • Upgraded Databases from 9i/10g version to Oracle 11g (11.2.0.2 & 11.2.0.3) versions .
  • Implemented database refreshes using various Backup strategies like RMAN, EXP/IMP, EXPDP/IMPDP.
  • Configured Oracle Enterprise Manager Grid Control (OEM 10g) and database Control
  • Successfully implemented Disaster Recovery test using Data Guard
  • Various database performance issues fixed on SQL and DB level using AWR, Statspack and O/S level reports.
  • Supported and assisted Development teams in the design, development testing and implementation of database applications.
  • Provided 24X7 on-call support for database environments.
  • Proficiency with OS scripting for both Windows and UNIX. Major Clients: Multi-Client Authoria, Johnson and Johnson Technologies: SQL Server 2000 to 2008, Windows 2003 to 2008
  • Experience in database design, performance monitoring and tuning, capacity planning, database backup and recovery, SQL statement tuning of SQL Server 2000/2005/2008 environments on Windows 2003/2008.
  • Configured high availability solutions like Replication and log shipping.
  • Diagnosed and resolved common application performance issues within databases including identification of poorly written SQL, missing indexes, over indexing, fragmentation, locking and blocking issues, etc. Major Clients: Convergys HR, State of Texas & Boston Scientific Technologies: PeopleSoft HRMS 8.9, PeopleSoft Portal 8.9, PeopleTools 8.46
  • Installed, supported, and configured: - Weblogic Tuxedo, Cobol Compiler, Process scheduler, Application Servers, Web Servers, Integration Broker for all Peoplesoft Portal and HCM environments.
  • Setup and Monitored App Messages between Portal and HCM environments.
  • Experience Upgrading PeopleTools and applying delivered patches.
  • Experience using Change Assistant.
  • Configured Load Balancing through F5 architecture.
UNIX Scripting Production Support Performance Monitoring Peoplesoft Oracle 11i Oracle Load Balancing Linux Disaster Recovery DBA Database Design Database Backups Data Replication BEA WebLogic Capacity Planning Ant SQL Server PeopleTools Tuxedo
Remove Skill
Tech Lead
Information Technology
Aug 2008 - Jan 2010
  • Major Clients ING, Convergys HR Technologies: PeopleSoft HRMS 9.1/8.9, PeopleSoft Portal 8.9, PeopleTools 8.53/8.46
  • Experience in Implementation, Customization, Upgrade and Maintenance of PeopleSoft HRMS Applications.
  • Proficient in Peoplesoft Components - Application Designer, Process Scheduler, Data Mover, Report Nodes, COBOL, Tuxedo, PIA Integration Broker, Upgrade Assistant, Maintain Security.
  • Complete end-to-end support for project implementation from the design phase. Involved in setting up the Topology and designing of the entire architecture to support client needs for the PeopleSoft implementation
  • Configured App Domains, Web Domains, setup File Servers.
  • Configured CSS and SSO setup for Portal and HCM environments.
  • Configured Integration Broker started Pub/Sub services at the App Server and configured App Messaging between Portal and HCM environments.
  • Performed PeopleSoft refreshes for SandBox PeopleSoft environments.
  • Checking performance and tuning web/app in PeopleSoft environments.
  • Installed Tuxedo, COBOL compiler.
  • Run Data Mover Scripts for password resets and to populate demo/production databases.
  • Applying People Tools Patches.
  • Upgrade PeopleTools.
  • Migrated Peoplesoft landscape in transitioning from Convergys to NGA.
  • Migrated the Peoplesoft support for 2 landscapes for a large bank.
  • Proficient in implementing F5 architecture.
  • Support Peoplesoft Migration activities
Performance Tuning PeopleTools Peoplesoft PS HRMS CSS
Remove Skill
Oracle DBA
Information Technology
Sep 1998 - Jun 1999
  • Major Client: AT&T American Transtech
  • Oracle Database Installations, upgrades & maintenance support.
  • Database account creations, modifications and removals.
  • On Call Production support.
  • Oracle database performance monitoring, troubleshooting and tablespace utilization.
RAD Production Support Performance Monitoring Oracle Database Installation DBA Database Upgrades
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Computer Science
University of North 1997
Skills
UNIX
2021
20
DBA
2021
19
Database Backups
2021
18
Disaster Recovery
2021
18
Oracle
2021
18
Oracle 11i
2021
18
Peoplesoft
2021
18
Production Support
2021
18
SQL Server
2021
18
Ant
2010
11
BEA WebLogic
2010
11
Capacity Planning
2010
11
Data Replication
2010
11
Database Design
2010
11
Linux
2010
11
Load Balancing
2010
11
PeopleTools
2010
11
Performance Monitoring
2010
11
Scripting
2010
11
Tuxedo
2010
11
Cloud Solutions
2021
10
Data Center
2021
10
Windows
2021
10
Performance Tuning
2021
8
Database Upgrades
2021
7
Data Warehousing
2021
6
OLTP
2021
6
Oracle DBMS
2021
6
SQL
2021
6
CSS
2010
2
Database Installation
1999
1
PS HRMS
2010
1
Apache
0
1
Change Management
0
1
node.js
0
1
PL/SQL
0
1
RAD
1999
1
RDBMS
0
1
SAN
0
1
Shell Scripts
0
1
SQL Loader
0
1
Veritas
0
1
VMWare
0
1