Oracle DBA

Krishna P

*******.********@*****.***

Mobile: 940-***-****

Professional Summary:

Having 13 years of experience as Oracle DBA and having hands on experience in

Installation, Configuration, Upgrades, Patching, Backup & Recovery, Migrations, Memory & Space Management, Cloning, Performance Tuning, RMAN, Data Guard, ASM, RAC, OEM Grid Control and Golden Gate CDC Setup

support and manage 24/7 Production, Development and Test instances and managing databases up to 10+ TB on Linux/Solaris/HP Unix/Windows environments

SQLServer clustering, Failover Clustering, SQL Replication in SQL Server 2005, 2008, 2012 and 2014, SQL Server Native Backup and Symantec

Oracle Web Services for Fusion Middleware (Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11gR1

Interface with SQL Server/Oracle for technical support and evaluate their features and products.

IBM DB2 Database Migration (Windows to Linux), DR and Switchover Implementation, DB2 Relocate utility, backup and recovery procedures.

Supporting DB2 system administration, application development, troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.

Installation of the IBM DB2 products and latest fix packs and maintaining DB2 environment including creating instances, databases, buffer pools, tablespaces and tables.

oracle spatial and Oracle Identity Management (IDM), Identity Access Management (IAM), Oracle Access Management, Integrations with SOA, Fusion middleware Applications

Advanced security options of database vault, audit vault, database firewall in CyberARK Applications for our oracle eBusiness suite and other production databases including key ControlM users

Database upgrades from 9i to 10g/11g, 10g to 11gR1/R2 and 12C (CDB/PDB DBs) & post system integration testing.

Experience facilitating interpersonal interactions involving design, development, testing, peer reviews, and implementation activities including developers, business analysts, development and QA teams while ensuring that system requirements are documented, complete and accurate, and that system support, release notes and maintenance documentation is complete

Experience in ability to elicit requirements from multiple stakeholders with different knowledge areas, clearly and concisely identified requirements, and provide an integrated solution for projects of varying size and complexity.

Performance monitoring, Tuning and troubleshooting of SQL statements and using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

ETL Technologies, data cleansing, data transformation, ETL automation using scripting languages Informatica loads monitoring, troubleshooting and Neotix support

Experience in understanding of data structures, data migration/conversion/transformation and concepts of both relational and multi-dimensional database design

Disaster Recovery Strategies, designing the recovery plans, implementing and Testing

Application’s sysadmin tasks - creating & managing users (responsibilities, Menus, Functions, Profiles, Alerts)

implementation of Oracle Statewide Standards and designing complex spreadsheets in Excel

Knowledge in PostgreSQL databases, shell scripting, EMC BCV sync/split to clone technology

Golden Gate installation, configuration & implementation (Oracle 11g) & replication to remote sites (active/passive and active/active) for disaster recovery, change data capture, platform migrations & load balancing

Golden Gate DDL Replication and oracle Streams and Site to Site Replication and CDC extraction of files for ETL

Replication of tables to cross platform and Creating Materialized Views.

DDL, DML, PL/SQL, oracle-based stored procedures, triggers, views, constraints and cursors

Create/maintaining partitioning, Enable/Disable at software level

Data loading with external tables in to oracle database and data migrations.

Logical backup strategies using oracle backup and Recovery, EXP/IMP, EXPDP/IMPDP.

Web ADI and Custom Application Deployment knowledge with Oracle 11i Application.

Installation and Administration of other Oracle products such as Demantra, Oracle Application server and non-Oracle products such as Kintana (ITG), Informatica, Outer Bay and Clear Orbit

Oracle Application Server, Oracle Demantra, Oracle Advance Supply Chain Planning (SCP/ASCP)

SQL experience with SQL server & Windows OS for all currently supported versions and at least TSQL/SSIS

Skills:

Platforms

Linux, HP-UX, RHEL 5/6, Oracle Solaris SPARC 8/9/10, Windows (NT2008R2)

Database

Oracle11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4), 12C, Oracle 10g(10.2.0.4), Oracle 9i/8i, MS-SQL Database (2000,2003,2005/R2,2008), IBM DB2 Database (v9.5, v9.7)

Languages

PLSQL, UNIX Shell Scripts

Third Party applications

Demantra, ASCP, HP Kintana Applications (ITG for deploying scripts, forms, reports, objects), Clear Object Tool (for Bar Coding), Informatica tool for data loading, HP Outer Bay (for data archiving tool)

Tools & Utilities

Oracle Enterprise Manager(OEM),OAM,SQL Developer, BMC remedy,Toad, VNC, Secure CRT, PDWare (PMP), KBACE, TAXWARE applications, Essbase applications, share point, Nimsoft monitoring tool

Educational Certifications and Training:

Master of Computer Applications from Andhra University, 2001

Master of Business Administration from Anna University, 2013

PGDC Methods of Programming from AP Productivity Council

Oracle Certified Professional (OCP) Oracle Database 11g Administrator.

Oracle Certified Associate (OCA) Oracle Database 10g Administrator

Trained RAC and Trained EXADATA

Projects Experience:

NetApp Inc, Sunnyvale CA Oct 2015 to present

Senior Oracle DBA

NetApp offers software, systems and services to manage and store data, including its proprietary Data ONTAP operating system. NetApp Advanced Technology Group (ATG) focuses on engaging and evaluating emerging technologies and trends that may affect the storage industry and the company’s long-term business

Responsibilities :

Install, setup deploy and manage Oracle Golden Gate in bi-directional modes and CDC extraction of files for ETL

Created and configured a multitenant container database (CDB) includes tasks such as planning for CDB creation, creating the CDB, and optionally configuring EM Express for the CDB

schedule jobs in a multitenant container database (CDB)with Oracle Scheduler

Configured advanced replication between Master Sites using Oracle Streams and golden gate advanced queuing.

Implement and maintain Golden Gate configuration settings for applications

Upgraded 12C for Oracle Enterprise Manager

Develop high level designs for Golden Gate components for applications

Develop detailed designs for Golden Gate infrastructure in consultation with Client

As a part of Oracle Identity Management Cloud service team, responsible for new customer implementations, data and environment migration, and major product upgrades for Fusion Middleware product sets. Offer Fusion Middleware (FMW) product and technology expertise

Oracle Database Vault with privileged access to data by implementing policies which restrict and control access of privileged users and thus mitigate the associated security risks.

Enforces and maintains database constraints to ensure integrity and Advanced Security Option.

Working on Fully utilizing the POSTGRES plugin in backups (PostgreSQL NetApp and NFS)

Creates and maintains all databases required for development, system integration testing and production usage.

Assists with impact analysis of any changes made to the database objects.

Performs the capacity planning to create and maintain databases. Works closely with system administration Team to often have applications or tools on them in addition to the Oracle Databases.

Performance tuning for existing and new concurrent programs.

Working with Oracle support for resolution on Workflow Mailer issues.

Maintaining Gather Stats, Mark view Hot Sync and daily backups and EBS refresh instances

Migration of the databases and applications between different file systems on different filers.

Third party applications including KOFAX transactions processing by implementing best practices, integrating all associated information, and leveraging the existing Oracle E-Biz suite.

Troubleshoot problems in databases, applications and tuning the database performances.

Make RMAN backups scalable and reliable. Plans and implements backup and recovery of the Oracle databases.

Control on all migrations, database changes, reference data changes and menu changes through the development life cycle.

Perform database re-orgs to gain performance and ensure maximum database uptime (99.99%)

Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.

Administers all database objects (tables/clusters/indexes/views/sequences/packages & proc)

Multiple Standby Database setup for Critical databases and create new database users

Manage sharing of resources amongst applications.

Key Projects/Assignments:

Markview for Accounts Payable Automation Validated Integration with Oracle E-Biz Suite

Part of successful completion of VM Migration to new GZ hardware.

Environment: Oracle RDBMS 12C/11gR1/11gR2/10g/9i, RMAN, 12C CDB/PDB, Active Data Guard, Oracle, Application Server, Solaris 5.10, RHEL 5, OBIEE, OEM, KOFAX, Golden Gate, Share point, Informatica

Teradyne Inc, North Reading, MA/ Alkermes, Waltham, MA Aug 2013 to Sept 2015

Oracle DBA/SQL Server DBA/DB2 DBA

Teradyne (NYSE:TER) is a leading supplier of Automatic Test Equipment used to test semiconductors, wireless products, data storage and complex electronic systems which serve consumer, communications, industrial and government customers.

Responsibilities:

Installation, Administration and Maintenance of Test, Dev., Staging and Production SQL Server instances

Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

Users maintenance and assign permissions based on the level of database access the user would need

Create linked Servers to SQL Servers and other databases such as Oracle, Access, and Informix

Responsible for providing administrative support for Oracle, DB2, MSSQL databases

Setup High-Availability as part Disaster Recovery Strategy for the Databases (Failover Clustering, Database Mirroring, Log Shipping and Replication)

Implemented Advance security options for sys/system/apps and other production user passwords for database vault, audit vault, database firewall through CyberARK Applications

CyberArk Enterprise Password Vault for secure, rotate & control access to privileged account passwords used to access systems throughout the enterprise IT environment.

Update user’s passwords for ebiz applications and oracle database users as part of Advance security options

Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

DB2 Database Installation and administration, migrations, backup & recovery in Windows and Linux platform.

High availability disaster recovery setup and Switchover exp for Sametime Application databases

Multiple Database recovery using the Db2relocate utility.

Regular Database Refresh for Sametime Chat Application Databases.

Application Integration with DB2 using the Web sphere Application Manager Portal.

DB2 UDB EE Database development and support

Golden Gate CDC setup, DB2 for CDC and CDC extraction of files for ETL

Golden Gate environment backup & recovery, GG replication components and GG configuration settings

Define Golden Gate software security alert compliance standards

Data availability, integrity, consistency, and performance for 300 + dbs.

Complete end to end support for backups (hot, cold & export/imp), user’s management, DR setup, DR Testing, scheduling jobs & maintaining Unix Shell scripts to automate database operations

Identifying partition removals from Oracle database to reduce the license cost.

SOX auditing in regular intervals quarterly/half yearly/Annual (internal and external audit), apply taxware patches regularly (first week of every month)

Creating users, granting and maintaining the privileges, roles and managing the resources with profiles.

Diagnosing database performance through monitoring alert files, trace files and log files of different services.

Ensuring backups (hot, cold and logical backups) and periodic restoration tests from backups and configuring and managing Physical standby databases.

Table partitioning (yearly Tablespace partition) for Informatica databases and Purge old data.

Oracle Enterprise Manager Implementation and Replication job scheduling for all Smarteam Application DBs

Experience in Audit Enable/Disable, Reclaim space for Fragmented tables.

Multiple Standby Database setup for Critical databases.

Key Projects/Assignments

Migrated Sterling database from Windows/Oracle DB to Linux/ DB2 database.

Upgraded sox production ControlM database from 10g to 11gR2

Upgraded non sox production databases from 9i to 10g,10g to 11gR1, 11gR2 in windows and UNIX environments

Part of UNIX databases consolidation project to VMware environment.

Part of successful completion of AFM PROJECT and Part of Japan tax update project

Part of successful HP-UX Virtualization Project to reduce license cost.

Implemented RMAN backups in place of traditional backups.

Environment: Oracle Applications 11i/R12.1.3, Oracle RDBMS 10g/11gR1/11gR2/9i/8i, DB2 database, Golden Gate, SQL Server Databases, Oracle, Application Server, Solaris 5.10,RHEL 5

Alkermes, Waltham, MA

Alkermes is a biopharmaceutical company that focuses on central nervous system (CNS) diseases. The company is the result of a merger between Alkermes, Inc. and Elan Drug Technologies (EDT.

Responsibilities:

customer issues and monthly maintenance activities for oracle ERP productions.

change requests of code migrations & patching activities.

create & maintaining users, granting privileges, roles and managing the resources with profiles.

Monitored and diagnosed database performance through monitoring of alert files, trace files and log files

Configured alerts and threshold values in Oracle Enterprise Manager 12C

Time to time RDBMS patches using OPatch.

Application and database User, concurrent, form and Session tracing.

Administrating software and tools in line with the clients requirements

Key Projects/Assignments

Active Data Guard (11gR2) has been implemented and tested in disaster recovery drill

Environment: HP UNIX, DB 11gR2 (11.2.0.4), Oracle 12C

Arvin Meritor (Meritor), Troy, Michigan Aug 2006 to Aug 2013

Oracle Apps DBA & Oracle DBA

Meritor is a leading global supplier of a broad portfolio of axle, brake and suspension solutions and the aftermarket for the transportation and industrial sectors.

Responsibilities:

Administration and Troubleshooting of Oracle applications Server issues, code migrations & patching activities, monthly maintenance activities for oracle ERP productions

Creating and maintaining users, granting privileges, roles and managing the resources with profiles.

Cloning, patching and diagnosing database performance through cron alerts/trace files.

Developing and maintaining an up to date knowledge of practice area specific Oracle products and services

Setting up, configuring Oracle Streams between the two database (Schema level)

Data center and Storage migration from EVA to EDS/HP

Change control administration for Environments with HP ITG Tool

Managing Table spaces for space usage and adding required space after it reaches threshold.

Responsible for developing user acceptance and systems test plans, test scenarios, test processes and schedules, and pre-test training. Experience in designing and coordinating defect reporting and validating defect fixes for database upgrades or patch upgrades

Responsible for database patches (CPU/PSU) and Standby Database creation and maintenance for DR.

Responsible for SOX maintenance, ensure availability & uptime of all the databases

Administrating software and tools in line with the clients requirements

Key Projects/Assignments:

a)Demantra/ASCP Implementation:

New implementation (end to end with ebusiness suite) has been done for Demantra/ASCP (taking the schemas from Production instance) includes CU2 upgrade for Demantra

Scheduled to refresh Demantra schema every day with ebusiness suite database.

Worked on workflow changes for Demantra and Demantra schema build

Worked on post Demantra upgrade issues.

b)EU ERP/ Database upgrade

Oracle database upgrade from 10.2.0.3 to 11gR2

Clear orbit application upgrade, compatibility with oracle database versions

OUTERBAY compatibility upgrades with oracle database versions

c)Global Data center Migration project: (Servers moved from Auburn Hills to Charlotte)

Migrated 7 ERP (11i, R12) Production instances from Auburn Hills to Charlotte Datacenter.

Migrated 25 Production Oracle databases (10g, 11g).

Involved in creating 150+ TEST instances from production using BCV& RMAN backups.

Participated in DR DRILL activity during Datacenter migration.

Configured the DMZ for restricted access on standard apache for isupplier portal for 4 productions

Configuration of Kintana ITG workflows for new environments.

Installed the Demantra application on Wintel (2008 server) box and configured with the production schema.

Configured third party tools like (Clear orbit, Matrix listeners, oracle configurator) which are integrated with e-Biz instances.

Migrated distributed HP-Outer Bay application and resolved all printer issues.

d)EU ERP/ Database upgrade

Oracle database upgrade from 9.2.0.3 to 10g and EBiz applications from 11.5.9 to 11.5.10.2

Clear orbit compatibility upgrade and OUTERBAY compatibility upgrade

e)Global Reportal Database upgrade and Oracle database upgrade from 9i to 10g and then 11g.

Apex application upgrade from 2.2.4 to 4.2

Installation of oracle HTTP server and Apex application deployment

Environment: Oracle 8i/9i/10g/11g, EBS 10.7/11.5.9/11.5.10.2/12.1.3, Sql Servers, RHEL 5/HP UNIX/ORACLE SORARIS 8/9/10, Outerbay (HP), ITG (HP), Clear Orbit (TAKE Supply Chain), Informatica for loads, web portal for reporting

Reliance Communications, Pune, Hyderabad, India Mar 2003 to Aug 2006

Oracle DBA & Business Operations

Reliance Communications Ltd. (RCOM) is an Indian Internet access and Telecommunications Company headquartered in Navi Mumbai, India. It provides CDMA (CDMA2000, 1xRTT, EV-DO), GSM (Voice, 2G, 3G) mobile services, fixed lines

Responsibilities:

Handling user management (roles, profiles) and change request issues and code migrations

Applying patches in dev/test/production environment with change implementation business process.

Handling monthly maintenance activities for oracle production databases.

Monitored and diagnosed database performance through monitoring alerts

Administrating software and tools in line with the clients requirements

Responsible for business operations in Telecom, Retail & Mobile sectors in areas of Business Analysis & MIS Reporting/Channel Management/Order & Distribution Management, Commercial operations/Retail operations/ Collections/Revenue Assurance/Customer Relationship Management/Sales support Operations

Key Projects/Assignments:

Maintain all 24 clusters data and reporting MIS information daily.

Complete authorization on all POS accounts

Environment: Oracle database 9i, windows XP, Windows Server 2000

Contact this candidate