Oracle Data
Resume:
Prem Kishan
Email :****.******@*****.***
Ph No : 424-***-****
SUMMARY:
10+ years of experience in the IT Environment as an Oracle Database Administrator Providing 24/7 support.
Manage Oracle database administration assignments for diverse industry clients.
Experienced in upgrading and migrating oracle 9i,10g R2 databases to 11.2.0.1 and 11.2.0.2 on Linux5 and Solaris10.
Experienced in migrating oracle 11.2 databases to 12.1.0.2.0 on linux and AIX platforms
Excellent experience in installing and configuring oracle RDBMS and oracle client softwares using SILENT INSTALLATIONS and SOFTWARE CLONING.
Experience with Oracle 12c/11g/10gRAC in manufacture, insurance, financial,telecom and banking industries in both Business Intelligence/Data warehouse Systems and OLTP Systems.
Installation and configuration of 12c/11g/10g RAC on UNIX, solaris, HP and Windows environment.
Experience in GOLDENGATE replication and SHAREPLEX for migrating the databases.
Experienced in installing and configuring UNIDIRECTION and Bi directional replication using oracle
GOLDENGATE 11.2 and 12C R2
Involved in Installation and Configuration of MS SQL Server 2000/2005/2008 /2012/2014/2016 Versions.
Experience in installing and configuration of Sybase databases
Experience working with data replication tools IBM CDC and informatica
Experience working on HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
Involved in administrating multiple 24*7 Production Oracle 8i/9i/10g/11g/12c RAC Databases as well as UAT/Dev/Test databases.
Experience in migrating Oracle databases from Solaris to Linux, Non-ASM to ASM and Non RAC to RAC.
Experience with Oracle Data Center infrastructures use commodity servers, network storage and full virtualization.
Excellent experience in database migrations from stand alone to 11gR2 & 12.1.0.2.0 RAC and also cross platform migrations.
Excellent experience in implementing data masking in oracle 11g,12c databases .
Experience in 11g and 12C OEM Oracle Grid Control, Quest central and Quest Fog light for databases.
Experience in AppWorx on Windows, LINUX, and AIX environments.
Experience in Writing Perl Scripting, Shell Scripting, bash scripting and Partitioning.
Experienced in Developing Oracle 9i/10g/11g PL/SQL Packages, Dynamic SQL, Triggers, Stored Procedures, Functions, DDL, and DML.
Experienced in administration setup, data migration and data dictionary reconciliation.
Worked on application servers Web logic, Web sphere in combination to oracle DB Oracle 10g.
Experience on installing and Administrating Oracle Enterprise Security Manager (ESM).
Experience working with Oracle E-Business Suite applications 11i & R12
Experience in Database Administration tools like OEM (Oracle Enterprise Manager) Grid Control and TOAD.
Experience in implementing ROLE based security as per SOX and OCC compliance and audit.
Oracle Database capacity planning, space management and storage allocation.
Strong Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP and Cognos.
Knowledge and done POC on NOSQL,MYSQL, & MONGODB databases
Working Experience with Hadoop & Bigdata
Knowledge and experience in AWS, Microsoft Azure cloud and cloud technologies
Strong Knowledge in People soft, SAP, Meta data & billing applications and also involved in reviewing performance reports with People soft & SAP Application developers.
Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN & HOT BACKUP methods.
TECHNICAL SKILLS:
Operating Systems
HP-UX 10.x, 11.x,IBM,Sun Solaris 9.0/10.0, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x,5,6,7,SOA servers and Windows 98/NT/2000/2003/2008/2012/2014/2016
RDBMS
Oracle 12C 12.1.0.2.0,11gRAC/10gRAC/10g/9i/8i, SQL Server 2000/2005/2008/2012/2016, MYSQL 4.1, 5.X
Languages
SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, korn scripting XML,GIT,JENKINS
DB Management
TOAD, OEM 9.2,11g,12c,13c, Cassandra-2.1, PostgreSQL 8.1/9.1
Tools/Utilities/Products
RMAN, OEM Grid Control 10g,11g & 12C, Ignite, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, TOAD, Patch Management, Oracle Warehouse Builder, Oracle Retek, SQLNET, ETL, Cognos, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware MS Office, Oracle EBS 11i/R12,Weblogic,Foglight,Precise,Informatica,PUPPET,CHEF,TIBCO BC 5.2, TIBCO BE 3.2/5.x,TIBCO HAWK 4.9,TIBCO ADB6.x/SAP/File/MQ Adapters, Teradata V2R5, V2R6, V2R12
Tuning Tools
TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR
Database Modeling
Erwin r7.1/7.2/7.3
EDUCATIONAL QUALIFICATION:
Bachelor of Engineering in Electronics&communications from Sri Indu College of Engineering &Technology.
PROFESSIONAL EXPERIENCE:
CLIENT : AT&T Jan 2015 – PRESENT
LOCATION: Dallas, Texas
POSITION: ORACLE DBA
Installed and configured 2 Node RAC of Oracle 12c 12.1.0.2.0 on half rac Exadata machine x6-2.
Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines
Worked with Storage team in configuring Netbackup and Datadomain on Exadata X6 machines
Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department
Deep understanding about Exadata specified features such as Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc
Installed and configured GOLDENGATE 12.3.0.1.0 for the Bi-directional replication for high availability mission critical oracle databases.
Installed and configured Golden Gate 12C for cascading replication on Red hat Linux platforms
Expertise in debugging the oracle golden gate issues from ggserr.log and analyzing trial files using log dump utility
Expertise in Golden gate configuration in 12c and 11g for bidirectional, unidirectional and cascading replication
Maintained ASM disk groups using ASMCMD and command utility.
Installed and configured Oracle software using silent Installations on Exadata x6-2 server.
Installed and configured 2node RAC cluster databases on Exadata x2-2 & x6-2 server.
Performed Migration of 10TB data from windows server to Linux Exadata server using Golden Gate unidirectional method and data pump.
Configured Oracle Advanced Security Encryption Disk level & network level Encryption for the databases.
Experience managing the Oracle Wallets for the Advanced Security Encryption.
Experience enabling the table level and transparent data encryption
Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method
Installed and configured Oracle 12C Release 2 Container & pluggable databases on Linux.
Upgraded the Oracle 11gR2 databases to 12c databases on the AIX, Red hat Linux platform & Exadata.
Supported Amdocs billing Software applications on 12C databases on the AIX & HP Platform.
Experience working on staging and loading the data into the tables using the ETL process
Experience loading over 500 GB data using ETL process
Experience in Data migration over 30TB across the Linux & AIX Platforms using Data pump & traditional export & import methods.
Performed RMAN backup and restore for 12c R2 databases.
Worked on Installation and configuration of MongoDB
Performing Backup and recovery in MongoDB
Installed and configured data guard for 11gR2 and 12c databases.
Installed and configured SQL Server 2008 R2/2012/2014/2016.
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition
Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
Upgraded production databases from 11g R2 databases to 12.1.0.2.0 on linux and solaris platforms.
Supported oracle databases for Amdocs billing applications
Installed and configured OEM 11g, 12c & 13c
Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator
Experience working closely with the application and developer teams and very good at communication with the teams
Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result
Resolved performance issues by analyzing AWR,ASH & ADDM reports.
Performance monitoring using OEM grid 12c & 11g
Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases
CLIENT : ALLIANZ Jan 2014 – Dec 2014
LOCATION: RICHMOND, VIRGINIA
POSITION : ORACLE DBA
Installed and configured 2 Node RAC of Oracle 11gR2 on half rac Exadata machine x2-2.
Database Migrations from non-exadata to Exadata
Installed and configured GOLDENGATE 11.1 for the uni-directional replication for high availability mission critical oracle databases.
Maintained ASM disk groups using ASMCMD and command utility.
Installed and configured Oracle software using silent Installations on Exadata server.
Installed and configured 2node cluster databases on Exadata server.
Performed Migration of 2TB data from windows server to Linux Exadata server using Golden Gate unidirectional method and data pump.
Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method
Installed and configured Oracle 12C Release 1 on Linux.
Upgraded the Oracle 11gR2 databases to 12c databases on the AIX platform.
Supported People Soft applications on 12C databases on the AIX Platform.
Performed RMAN cloning using Active database feature in 11gR2 databases.
Installed and configured Physical standby databases for 11gR2 databases.
Installed and configured SQL Server 2008 R2 .
Configured Transactional Replication and SQL server log shipping on SQL server 2008 R2.
Configured and supported replication and log shipping in both SQL 2008 and 2012
Installed and configured Shareplex 8.0 on Linux server
Experience working with shareplex replication
Experience in setting up Oracle Advanced Security data encryption and integrity features
Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
Experienced in Automation using korn & Shell Scripting.
Upgraded more than 30 production 10g databases to 11.2.0.4.1 on linux and solaris platforms.
Supported oracle databases for people soft, Sap applications, ATG Ecommerce applications and Siebel CRM.
Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator
Experience working closely with the application and developer teams and very good at communication with the teams
Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result
Resolved performance issues by analyzing AWR, ASH & ADDM reports.
Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases
CLIENT: LEXIS NEXIS MAY 2012 – Dec 2013
LOCATION: MIAMISBURG, OHIO
POSITION: ORACLE DBA
Installed and configured 2, 3 & 4 node oracle 10g and 11gR2 RAC on Red hat Linux 5 for databases upto 3TB on ASM. Provided 24/7 production support to over 300+ databases ranging from oracle 10g to 11gR3 in Linux, solaris and AIX.
Maintained ASM disk groups using ASMCMD and command utility.
Performed Database Refreshes from Production to Test and Development environments using Clone process by RMAN Duplicate.
Installed and configured OEM 12C Grid control for monitoring all Production and cert databases.
Installed and configured Oracle 12C databases on Solaris Platform.
Experience working on performance tuning on Oracle 12C databases.
Installed and configured GOLDENGATE 11.1 for the uni-directional replication for high availability mission critical oracle databases.
Implemented data masking on columns having sensitive data using OEM.
Experience in troubleshooting and fixing database and goldengate performance issues.
Installed and configured oracle standalone 11gR2 databases using Oracle Database Configuration Assistant (DBCA) and through silent Installations Method.
Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method.
Installed and configured OEM 11g & 10g
Configured and maintained physical standby for oracle 10g, and performed DR switch over test every month.
Configured and maintained physical standby using 11.2.0.1 active DATAGUARD for disaster recovery and reporting.
Experience in supporting the oracle EBS application 11i on 11gR2 RAC databases
Proficient in installation and upgrading Oracle Applications11i e-business suite to R12
Installed, security, and maintenance of Linux based systems including Apache and MySQL 5.0.22 configuration
MySQL database administration on a large scale MySQL installation.
Experience with MySQL on both Linux and Windows
Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1
Responsibilities include Upgrading for two applications from MS SQL Server 2000 to MS SQL Server 2005
Resolved performance issues by analyzing AWR & ADDM reports.
Performed SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility an AUTOTRACE utility
Experienced in upgrading SQL server 2005 to 2008.
Upgraded and Migrated Database from 10g to 11g and applying patches whenever required.
Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.
Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
Performed logical and physical data modeling and database design for an Oracle Retail Data ODS designed to enable Retail LOB fraud detection data mining with the use of analytics tools.
Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications
CLIENT: JPMORGAN CHASE Feb 2011 – MAY 2012
Location: COLUMBUS,OHIO
Position: Oracle DBA
Installed and Monitored the Oracle database on 10g and 11gR2 in RHEL 5
Installed Oracle 11gR2 in PeopleSoft environment.
Upgrade GOLDENGATE from 10 to 11.1
Installed and configured GOLDENGATE 10 and 11.1 for the unidirectional and Bidirectional replication for high availability oracle databases.
Identified and resolved errors through log dump utility, GGSEVT
Performed GOLDENGATE upgrades from V10.4 to 11.1 for oracle 11G databases
Experience in managing the Golden Gate performance by reducing lag between source and target
Installed and configured 2 node oracle 11.2.0.2 Rac on AIX 6.1 for a 15TB database on ASM and Raw devices.
Experienced in setting up Oracle 10g and 11gR2 2 and 4 Node RAC implementations & administration using CRSCTL, SRVCTL command utilities in AIX 6.1 environments
Maintained ASM disk groups using ASMCMD and command utility.
Converted numerous single instance databases to 11gR2 RAC on 2node and 3node architectures
Experience in maintaining large databases upto10TB supporting SAP and Peoplesoft applications.
Dealt with the problems or bugs with SAP software by interacting with SAP Service team through OSS (Online service support) messages and applying SAP Notes or patches required
Tested custom SAP transactions to ensure proper functionality.
Experience managing the Oracle Wallets for the Advanced Security Encryption.
Experience enabling the table level and transparent data encryption
Performed SAP EHP 5.4 Installation on windows server 2008 R2 with Oracle 10g
Installing SAP GUI for windows & enabling the WEBGUI
Installed and configured OEM 11g Grid control for monitoring all Production databases.
Configured alerts, thresholds and reports using OEM across all the enterprise databases.
Experienced in upgrading SQL server 2005 to 2008.
Configured MS SQL server 2005 on windows server 2003.
Migrated over 50 schemas from AIX 5.2 platform to AIX 6.1up to 50 TB.
Performed Data guard switch over and failovers using SQL commands and DGMGRL utilities.
Configured and maintained physical standby using 11.2.0.1 active DATAGUARD for backup and reporting.
Successfully performed several quarterly DR switchover exercises.
Developed batch processes for financial reporting applications and modules using Korn shell scripts on Oracle databases
Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems
Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
Provided DBA support during code releases and quarterly updates
Implemented and improvised database security using Role based security model.
Maintained large OLTP databases sizing upto30 TB in my current project.
Created and configured 10g and 11.2.0.2 databases using Oracle Database Configuration Assistant (DBCA) and through silent Installations Method.
Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team
Daily monitoring of over 120 databases using OEM Oracle Enterprise Manager and Toad.
CLIENT: T-MOBILE Jan 2010 – Feb 2011
Location: Seattle,WA
Position: Oracle DBA
Installed and Monitored the Oracle database on 11g RAC in RHEL.
Involved in performing migration from Oracle 10g to Oracle 11gRAC database.
Upgraded oracle RAC 11.1.0 to 11.2.2 using Oracle Golden Gate and in PeopleSoft environment.
Supported Remote DBA Support for Oracle 9i/10g and 11g.
Monitored and Tuned database to optimize the performance of Oracle EBS applications.
Installed and Monitored the Oracle database on 10g RAC in Solaris Servers using ASM and also with Oracle EBS applications.
Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever
required.
Installation and maintenance of Oracle 11g 24*7 Production Environment.
Implemented Oracle Streams for the replication of data in Development to Production.
Experience in Data modeling.
Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
Troubleshooting on the databases for Application Server and Oracle database related issues.
Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
Daily Health Checkup of the database using STATSPACK, AWR, ADDM.
Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
Optimizing Oracle RMAN and ASM environment.
Taking Periodic Backup of the databases and the software using RMAN.
Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
CLIENT: ICICI BANK June 2008 –Dec 2009
Location: Bangalore, INDIA
Position: Oracle DBA
Responsibilities:
Installed Oracle 10gRAC database on Redhat Linux using ASM.
Migrated Databases from 9.2.0.3 on Linux to 10.2.0.3 on HP-UX.
Monitored and Tuned database to optimize the performance and satisfy the availability and Oracle EBS applications.
Performance Tuning by using Oracle utilities like EXPLAIN PLAN, STATSPACK, and TKPROF for addressing performance bottlenecks is performed.
Logical and Physical data modeling using Erwin, Dimensional/OLAP data modeling.
Taken Backup & Recovery by using RMAN.
Analyzed and monitored that data got by ADDM performed logical database using Export utility.
Adopted general DBA tasks like Indexes, Partitioning and Flashback Recovery.
Used Oracle Retek Space Optimization for optimal space and allocation recommendations.
Used Snapshots for Replication and synchronization data with other branches.
Used Snap Mirror for creating duplication of production databases.
Implemented Oracle Data Guard for maintained oracle disaster recovery
Manage Enterprise databases, users and roles by Oracle Enterprise Grid Control.
Developed Dynamic SQL, PL/SQL Scripts, Packages and views.
Created Data Modeling and Data definition Language (DDL) to support development efforts.
Created and maintained different database entities included table spaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
Created PARTIONING of its types like Range, List & Hash by the specific use.
Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
Trouble shooting and resolving any database and/or application issues or errors that occurred.
Developing shell scripts and using various tools monitored the various database activities.
Utilizing OEM SQL Analyze, OEM Grid Control, STATSPACK, SQL Trace, and TKPROF etc.
Contact this candidate