Candidates About

 

Krishna A                                                                                                                                 

 

PROFESSIONAL SUMMARY:

 

•         Over 5+ years in Oracle Database Administration in very large Production, test and development environments in diversified domains, on various versions of UNIX/LINUX/ SOLARIS operating systems.

•         Database experience using Oracle 12c/11g/10g, Oracle SOA, SQL,PL/SQL,SQL LOADER, Stored Procedures, Explain Plan, Materialized Views, Database links.

•         Created and setup Oracle databases 12c. Created Container database and Pluggable databases.

•         Knowledgeable about how to Configure, Migrate and Maintain, manage I/O Resource, Optimizing Database Performance of Exadata Storage Server.

•         Experienced in Upgradation and Migration of Oracle Database across various platforms.

•         Configured Oracle Enterprise Manager OEM 13c, 12c monitoring. Created rules to send out mission critical alerts from production database.

•         Oracle Golden Gate Replication Expert with knowledge in implementation of Golden Gate on both Standalone and RAC Servers.

•         Expert in using tools like Veridata for Data comparison which are involved in Golden Gate Replication. 

•         Migrated Databases from Solaris to Linux, Shareplex to Golden Gate.

•         Having a good knowledge on both Classic and Integrated Processes.

•         Installation, setup and configuration of logical and physical StandBy Database using data DataGuard.

•         Performed Switchover and Switchback of databases using DGMGRL.

•         Running the Autosys Jobs/ SOA Scripts from Utility Server in Exadata .

•         Troubleshoot Database Performance issues using Automated Workload Repository AWR , SQL Tuning Advisor and Automatic Database Diagnostics Monitor ADDM . Tuned database for optimum performance.

•         Experience in implementation of TDE(Transparent Data Encryption).

•         Good Knowledge on AWS.

•         Creating AWS Instances and Resources Bills.

•         Setup/Managing Linux Servers on Amazon (EC2, EBS).

•         Extensive knowledge of Oracle Architecture, SGA, PGA, V$ views.

•         Installed, Upgraded, Patched, Configured various Oracle related Software Packages on RHEL, Sun Solaris Operating Systems.

•         Good knowledge of Physical and Logical Objects.

•         Good Knowledge of various states of Software Development Life Cycle (SDLC) i.e. System Analysis, Applications Design, Development, Integration & System Testing Support in Production, Staging, and Development environments.

•         Developed backup and recovery policy and used new features/technologies to optimize system maintenance and good knowledge on table Partitions.

•         Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. tablespaces).

•         Proficient in using Oracle utilities like export/import Data Pump, Data Guard, ASM and OEM.

•         Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.

•         Good Knowledge of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting, Java Scripting.

•         Strong ability to script the database models into SQL to create the database objects including tables, views, triggers, indexes, foreign keys and sequence counters.

•         Participating in Webex sessions for addressing the Customer issues.

•         Good knowledge of User Acceptance Testing and writing of Test Cases.

•         Implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.

•         Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions.

•         Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures. Escalating the issues as per the severity of database and resolving it immediately without any delay.

•         Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills, Good co-ordination and communication with system administrators, Quality analysts and development teams.

 

Technical Skills:

 

Databases:                           Oracle 12C, 11g R2 RAC, MySQL, Oracle SOA.

Operating Systems:       Linux, Sun Solaris, HP-UX, and Windows.

Languages:                          SQL, PL/SQL, PHP, UNIX Shell Scripting, Java, Python Scripting.

Tools:                                     RMAN, OEM, EXP, IMP, Data Pump, Veridata.

Tuning Tools:                    AWR, EXPLAIN PLAN, STATSPACK, ADDM, OEM Grid Control

ETL Tools:                           Data pump.

 

Professional Experience:

 

Client: Wells Fargo Bank, San Leandro, CA                                                                 June 2015 – Till Date

Oracle Database Administrator

 

Responsibilities:

•         Created and setup Oracle databases 12c. Created Container database and Pluggable databases.

•         Worked on upgrading of oracle databases from 11g to 12c.

•         Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

•         Discovered and Monitored Oracle 12C Container and Pluggable Databases also set up alerts in OEM 13C and legacy databases in earlier versions like OEM 12C.

•         Configured Data Guard for Oracle 12C Databases and performed switchover, switchback.

•         Configured Autosys Jobs for running Scheduled jobs.

•         Setup Autosys Jobs on Utility Server.

•         Tuned Oracle 12C databases like increasing Processes/ Sessions to support Oracle SOA.

•         Configured and monitored Oracle SOA Databases and maintained Purge Scripts.

•         Installed, configured and maintained Golden Gate on Oracle Databases.

•         Involved in Migration of the oracle databases from SharePlex to Golden Gate.

•         Migrated Oracle databases from Sun Solaris to Linux.

•         Good experience in installation, configuration and administration of Oracle 12C, 11g, Standby Databases for High Availability and Disaster Recovery purpose.

•         Experience in implementation of TDE.

•         Created new users, Roles, Profiles and assigning the required privileges to the users.

•         Experience using Export/Import and Data pump for migration of databases.

•         Table Partitioning, Creating Locally managed Table spaces.

•         Applying Oracle recommended patches.

•         Created Standby Databases using Data Guard for Disaster Recovery on latest version 12C and legacy.

•         Install and configure Oracle Veridata for comparison of Databases involved in Golden Gate Replication.

•         Worked on SQL Server.

•         Inserting/ updating/ deleting records or generating reports in SQL Server.

•         Knowledgeable about how to Configure, Migrate and Maintain, manage I/O Resource, Optimizing Database Performance of Exadata Storage Server.

•         An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.

•         Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.

•         Actively involved in Switchover/ failover processes.

·         Configured and implemented Oracle 11g Active Datagaurd for Database Disaster Recovery by using Data Guard broker (DGMDRL).

•         Performs Golden Gate replication monitoring, tuning, and capacity planning.

•         Installed, configured and maintained Oracle Databases and Applications.

•         Using EXPDP/IMPDP for export and import.

•         Involved in Upgrading of the oracle databases from 10g to 11g.

•         Used Diagnostic & tuning packs along with AWR & ADDM reports.

•         Installed JAGENT, XAG which supports Monitoring of Processes in OEM and Failover process.

•         Automated Archives deletion or Backups using Autosys Jobs.

•         Creating new users, assigning the required roles/ privileges.

•          Creating and maintaining Views on Database objects.

•         Application of patches and security patches downloaded from Oracle Metalink in lower environments before going to Production.

•         Working alongside programmers and contributing to the development process.

•         Responsible for continuous database monitoring and reorganization for ensuring performance.

•         Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

 

Environment : Oracle 12C, 11g/10g, OEM (Grid Control), Oracle Data guard, Sun Solaris, ASM, RAC, RMAN, Data pump, Import Export, HP-UX, and Red Hat.     

 

 

Client: InMage Systems, India                                                                                           Oct 2011– Nov 2013

Associate Software Engineer.

 

Responsibilities:

•         Supporting large critical databases in a 24x7 environment. Participated in Webex sessions for addressing the Customer issues.

•         Replication of Data between various databases using InMage Scout Product, used for Disaster Recovery.

•         Upgrading/ Patching or applying the Hot fixes for the databases.

•         Involved in Migration of database to latest versions.

•         Creation of Table space, Data files, Indexes and monitoring them.

•         Created Databases, tables using MySQL.

•         Inserting/ updating/ deleting records or generating reports in SQL Server.

•         Developed, Tested and debugged the code according to business requirements.

•         Responsible for writing database queries to Store/Retrieve the information from the database using SQL.

•         Performed RMAN Backups.

•         Auditing logs to keep a track of user movements.

•         Creating databases, objects, roles and privileges.

•         Running of Daily Health Check Reports and Fix the issues.

•         Involved in Failover/ Failback processes.

•         Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using SQL, UNIX shell Scripting.

•         Database Security Management involving managing Users, Roles, Profiles and Privileges. Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.

•         Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.

•         Taking the backup of the database and performing required tests before applying in on the Customer databases.

•         Having knowledge of Sub Queries, PL/SQL procedures, functions, database triggers and packages.

•         Code Optimization for enhancing the Performance.

•         Performing and writing Unit Test cases.

 

Environment: Oracle 11g , MySQL, Sun Solaris, RHEL, Oracle Linux, Windows.

 

Client: Ramky Enviro Engineers Ltd, India                                                                     Jan 2011 - Sep 2011

Role: SQL Developer

Responsibilities:

·         Responsible for creating the Tablespaces, tables and insertion of data.

·         Created users, roles and assigned required privileges.

·         Created  Table space, Data files, Indexes.

·         Taking Backups of Schemas and performing required Tests.

·         Implemented Cold Backup and Hot Backup depending on the requirement.

·         Created indexes on tables to improve the performance by eliminating the full table scans.

·         Wrote Sql, Pl/Sql programs required to retrieve data.

·         Having knowledge of creation of Virtual Machines and installations of databases for testing environments.

·         Performed Unit Testing before merging the code with the actual files.

·         Having knowledge in Writing the Test cases and assisting the QA understanding the expected behaviors.

·         Running the Daily Health Reports.

·         Supported during all testing phases and problem resolution.

 

Education:

Masters from Northwestern Polytechnic University, CA                                              April 2015

GPA: 3.69/ 4.0

 

Bachelor of Technology from JNTU, India                                                     May 2010

GPA: 3.5/ 4.0