- 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