Data Oracle

MURALI KONDA

SUMMARY

Showcased excellent aptitude as a capable business frontrunner in establishing and directing company’s technical initiatives from its inception; drove changes across the organizational boundaries, established new processes, supported an environment of continuous improvement and directed a board range of corporate IT initiatives

Proven ability in managing end-to-end Database Management System (DBMS) Technology strategy, architectures, testing and preparation of DBMS solutions and configurations

Expertise in RAC (Real Application Cluster) Servers: installed, configured, maintained and monitored Oracle 12c/11g/ RAC for failover DB Server Management

Possess excellent Backups and Recovery Management Skills that involve logical backups (Import/Export), Hot/Cold Backup and tools & utilities like RMAN, Customized Scripts

Experienced in Performance Tuning such as tuning of memory, CPU, I/O distribution, shared memory segments using utilities like Explain Plan, Stats Pack, OEM, AWR, ADDM, ASM, TKPROF; enrolled Users and maintained System Security Excellent (SQL, PL/SQL) Programming Skills

Sound experience of working with FTP, SCP using SSH protocol, replication, loading data into Data Warehouse Event Notification, Data Protection; migrated/ upgraded database from Oracle 10.2.0.5 to 11.2.0.4; provided support for implementing and upgrading various new & third party application at client site

Successful track record of profitable project execution, delivery excellence, client engagement, planning, risk management, high employee satisfaction and customer delight leading to customer advocacy

PROFESSIONAL EXPERIENCE

Client: SHELL TRADING, HOUSTON, TX 05/2011 – 12/2015

SENIOR ORACLE DBA

Migrated Databases from Oracle 10.2.0.5 to 11.2.0.4 along with Advanced Compression techniques to reduce storage costs.

Used Golden Gate replication for minimum downtime while migrating.

Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.

Built numerous PL/SQL and UNIX SHELL Scripts to implement daily refreshes from Prod to Non prod database using Data pump and DBMS_SCHEDULER_JOBS.

Built scripts to automate schema stats and Index Rebuilds, automated using DBMS_SCHEDULER_JOBS.

Moving data between databases using Data Pump.

Helped resolve performance issues in ENDUR application with critical EOD TASKS

Performed capacity management involving growth trend analysis of the present production and forecasting storage requirement for budgeting.

Deployed change releases using Clear Quest to non-prod databases for User acceptance testing and move changes to Production.

Performed POC for Oracle Database in Amazon Cloud, Data Masking through Informatica, Data encryption using Oracle TDE.

Hands on working knowledge on MS SQL SERVER and ORACLE 12c.

Environment: Oracle 11g/10g/9i, SQL*Plus, Export/Import, RAC, Grid Control, RMAN, SAN, Data Guard, Data Migration DB Console, Performance Tuning, OEM, Sun Solaris, Toad, AWR, UNIX Shell Scripts, LINUX Red Hat 4.0, Windows Server.

Application: OpenLink ENDUR, In-house trading applications (oracle 10g and 11G).

Client: VERIZON – IRVING, TX 05/2008 – 05/2011

SENIOR ORACLE DBA

The Project was to maintain the Verizon Registration and Bill pay databases and support the new development changes to enhance the new features being introduced on the Verizon bill pay website.

Responsibilities:

Supported all registration and bill pay databases in different environments like Testing, UAT, Integration and Production.

Coordinated with Release management Team, Deployed code changes in UAT, TESTING and Staging databases, tested and provided support for production upgrades.

Upgraded and converted 10g Database to 11g RAC two node Database.

Imported and exported tables to load data between different databases.

Configured Replication between Databases using third Party tool Shareplex (supported by quest).

Analyzed Stats Pack reports, modified DB configurations, automated index rebuilding, DB reorganization, created partitions, converted highly accessed long columns to clobs.

Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application

Performed DBA Maintenance tasks in the form of adding data files to tablespaces, resizing the data files, increasing the size of redo log files and reorganizing the data.

Environment: Oracle 11g/10g/9i, SQL*Plus, Export/Import, ASM, RAC, Grid Control, RMAN, SAN, Data Guard, Data Migration DB Console, Performance Tuning,, OEM, Sun Solaris 10, Toad, AWR, Unix Shell Scripts, LINUX Red Hat 4.0, Windows Server.

Client: HP – HOUSTON, TX 06/2007 – 04/2008

ORACLE DBA

GDBA team was responsible for the database administration within the Data Center Consolidation (DCC) Program. The project was mainly for the consolidation of the about 110 datacenters located all around the world into six datacenters in 3 locations within US for easier maintenance. All the databases in DCC followed DCC standards having the same character set and the same backup policy (RMAN). Every database was configured in OEM for monitoring purposes. GDBA team provided technical support to Application team before and after MTP.

Responsibilities:

Created RAC and standalone databases for PROD, ITG and dev environment.

Configured databases in OEM 10g grid control for maintenance and monitoring.

Adhere to DCC standards and security policies for the databases.

Performed migration from Oracle 8i, 9i, 10g on different platforms (Sun Solaris, Linux, HP UX and Windows) to Oracle 10g Release2 RAC database on HP UX.

Performed performance tuning of migrated applications using ADDM / AWR, perfstat.

Migrated 100+ databases (10gR2, R1, 9i, 8i) from Legacy environment to Oracle 10g R2 on RAC DCC environment using Export/Import, Database links, Data pump, standby methods.

Created the standby databases using datagaurd for Mission Critical Applications.

Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Provided full technical support to various application teams before and after the databases moving to production.

Managed the databases of various sizes ranging from 50GB to 2 TB.

Migrated SQL server databases from SQL Server 2000, 2005 to SQL server 2008.

Environment: HPUX 11.11, HPUX 11.23, Windows 2000, HP Open VMS, Solaris 5.10, Oracle 8i, 10g, OEM

TATA CONSULTANCY SERVICES – MUMBAI, INDIA 01/2005 – 12/2006

ORACLE DBA

Client: GE Commercial Finance Services

This Project involves the administration of Oracle databases for GE Commercial Finance Fleet services Europe, with four environments in support of my scope – Test, UAT, Production-Support and Production environments with all over 30 instances, each database size ranging about 500GB. Also involves support to Oracle Application server 9i and Oracle 9iAS components- Apache server, form server, report server and Oracle Container for J2EE (OC4J- Application server). Worked as a dual role of Application support and core DBA

Responsibilities:

Installed Oracle Server Software and creating Databases as per business requirements.

Performed major production upgrades, prod-support upgrade, from dev and UAT environments.

Establish, review and maintain enterprise database standards and best practices covering backup/recovery procedure, monitoring scheme, space management, and database cloning methods.

Clone databases for new system implementations and development projects.

Provided support to Oracle Application server 9i components- Apache server, form server, report server and Oracle Container for J2EE (OC4J- Application server)

Installed, Configured and maintained Oracle Transparent Gateway for Ingress.

Develop UNIX shell scripts to administer the system and scheduling batch jobs using crontab.

Assisted the programmers in troubleshooting DBA related issues.

Escalated issues to Oracle Support via Metalink. Provide support information with events, system dumps and RDA. Follow-up with TARs and implementing patches/workaround provided.

Environment: Oracle 9i/10g, Sun Solaris 5.8, TOAD, PL/SQL, SQL* Plus.

CENTRAL WAREHOUSING CORPORATION – MUMBAI, INDIA 03/2000 – 12/2004

PL/SQL DEVELOPER

Central Warehousing Corporation’s CFS is an International Container Terminus at JNPT, Mumbai. Being the largest Container freight station in the country, we had given the corporation a total logistics solution and support to their facilities management system for the export and import operations.

Responsibilities

My responsibility as a Programmer was to develop and implement various new modules for the legacy logistics system.

Gave support to database administration activity in the running system.

Analyzed the client’s requirement and developing or modifying modules for the system is my prime job.

Environment: Windows NT, Developer 2000, Oracle 8.1.7.4, PL/SQL Developer, TOAD.

TECHNICAL EXPERIENCE

Relational Databases: Oracle 7.3/8/8i/9i (9.2.0.5, 9.2.0.6), 10g, 11g, SQL*DBA, Utilities (Export, Import, SQL* LOADER), Server Manager, Quest, Enterprise Manager, Data Guard, PVCS (SCM), Oracle 11g/10g/9i, MS Access 2003, TKPROF, SQL Trace, STATSPACK, O EM Diagnostic Pack,

Programming Languages: SQL, PL/SQL, Java, C, C++

Tools: Oracle Enterprise Manager, Grid Control, Toad, SQL Developer, WinSCP, Cygwin, Core FTP Lite, SQL Developer 1.1/1.2/1.5, PL/SQL Developer 5.0, ETL.

Backup Utilities: RMAN Backup and Recovery, Import/Export utility, data pump utilities, OE (expdp/impdp), DBMS Utilities, SQL*Loader, Replication, Oracle 11g/10g Replication using Shareplex, Materialized Views

Disaster Recovery: Physical Standby (Data Guard), Logical Standby

Tuning Tools: OEM, AWR, ADDM, Statspack, Explain Plan, TKPROF

Querying: SQL*plus, iSQL*Plus

Scripting: UNIX Shell Scripting

Data Modeling Tools: Erwin, Microsoft Office Visio

Protocols: TCP, UDP, FTP, SCP

Storage System: ASM (Automatic Storage Management), EMC SAN

Cluster Database: Oracle 10g RAC, Oracle 10g Clusterware

Operating Systems: HP-UX, Windows NT, AIX, Solaris, Linux, Windows 2000 Server, Windows XP

EDUCATION

Bachelor of Science in Computer Science

CERTIFICATIONS

Oracle Certified Associate

Certified Six Sigma Green Belt Associate

Contact this candidate