Sql Server Oracle

Ramana Cheemakurthy

Status: US Citizen

Phone: 678-***-****

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

Objective

Seeking as a Senior Oracle DBA/Programing/Performance Tuning Architect

Professional Profile

Over 20+ years of IT experience with 18 years of Oracle DBA, Database tuning, SQL/PL SQL Programming and 8+ years of SQL Server Administration/programming.

Well versed in working in the Oracle and Microsoft SQL Server technologies, Oracle 12c, Oracle 11g, Oracle Clustering (RAC), Oracle Super Cluster (T5-8 half rack), Oracle Exadata 12c, Oracle ODA X5-2, SQL/PLSQL Performance Tuning, High Availability (Data Guard), Oracle securities (OAM), Grid, Cloud Computing (EM12c), Data migration & Replication (Golden gate), Oracle RMAN, Microsoft SQL Server 2005, 2008R2 and 2012.

Technical Profile:-

Seasoned professional with 18 year’s database experience

Proficient in VLDB environments ranging over 10 terabytes

Working in an environment with over 200+ databases totaling over 100TB in size.

Proficient in Oracle SQL, PL/SQL, Microsoft T-SQL

Scripting: Shell Scripting, Perl, PL/SQL, T-SQL

Tuning: Explain Plans, OEM, Grid Control, SQL Analyzer, TKProf, AWR, ADDM, ASH, Baselines, SQL Profiles, MS SQL server built in tools

Install/Configure/Manage Oracle Enterprise Manager (11g,12c)

Administration of Oracle Exadata x4-2, Oracle Super Cluster T5-8, Oracle ODA X5-2/X-6

Oracle Features: Partitioning, Dynamic SQL, Streams, Golden Gate, Bulk Collects

Skill Set: Technical Presentations, SQL and PL/SQL Tuning, Oracle DBA, MS SQL server Administration/Programing & Tuning, Database backend Architecture, Requirement Analysis, Training and mentoring, Data Modeling, Oracle Exadata, Oracle Super Cluster, Oracle ODA X5-2/X-6.

Professional Experience

GSI, Inc (Oracle Platinum Partner) Sep 2015-July 2017

Principal Database Administrator

Worked as a senior Principal Database Administrator of GSI, Inc, GSI’s front line business is to Managed Services. GSI mainly manages and provides Oracle JD Edwards EnterpriseOne application support, Database management and database solutions to the various clients. As a principal DBA, helped, supported/managed the Oracle and SQL Server databases including Oracle Super Cluster, Oracle ODA, Oracle RAC, Oracle Data Guard. Designed and built custom applications using Oracle/MS SQL Server databases and tools in Linux and Windows environments. I have helped various clients in database tuning to improve the performance and query optimization. Very closely worked with CNC administrators by Supporting/managed databases for various clients 24/7 to maintain the 100% availability and optimal performance.

Here are the list of major clients I have supported.

Jones Lang LaSalle Incorporated JLL is an American professional services and investment management company specializing in real estate.

I have supported the two Oracle Supercluster T5-8 half rack engineered systems which were hosting the JD Edwards EnterpriseOne (9.0) systems using Oracle 12c databases. The first Supercluster is located in Lisle, IL and houses Production, Training, Playground, Archiving, Development, Pristine and Upgrade environments. The second Supercluster is located in Sterling, VA and houses the DR environment which is also used for Reporting. These databases were configured with Oracle 12c RAC, Data Guard for DR/Reporting solution. Production database is about 8TB.

The Honest Company THC is an American consumer goods company. Supported their JD Edwards EnterpriseOne application on Oracle 11g database. I have supported the day to day database tasks and monitoring the Oracle 11g production database, non-prod databases refreshes from production copy, backup & recovery tasks, performance monitoring and tuning. Production database is about 5TB and Non-Prod environment is about 3.5TB.

AxleTech International is a global designer, manufacturer, and supplier of drivetrain systems and components for on-highway and off-highway vehicles across many markets. Worked on the project for upgrading the JDE1 application/Database from JD Edwards EnterpriseOne (8.0)/Oracle DB11g to JD Edwards EnterpriseOne (9.2)/Oracle DB 12c.

Eastern Propane Corporation provides propane gas delivery service and quality propane appliances and repair for homes and businesses. Provided 24/7 support for the Oracle 11g database on Linux environment.

Tornier, Inc Orthopedic Extremity Specialists with more than fifty years of devout concentration in prosthesis design, education, training and markets devices for joint replacement and soft tissue repair that enable surgical specialists to improve patients’ lives by restoring motion and physical vitality. Managed their ODA server with Oracle 11g RAC databases to maintain 24/7 availability, optimize the performance and Backup/Recovery operations.

Intrawest Resorts Holdings, Inc is a developer and operator of destination resorts and a luxury adventure travel company. Managed the Oracle 11g database which is hosting the Oracle JD Edwards EnterpriseOne (9.0) application on Linux environment.

APR Energy provides fast, flexible power generation to cities, countries and industries around the world, satisfying temporary and longer-term power needs. Supported production and non–prod SQL Server databases including performance tuning, backups and recovery.

IDEX Corporation, based in Lake Forest, Illinois, is a publicly traded company engaged in the development, design, and manufacture of fluidics systems and specialty engineered products. Supported production and non–prod SQL Server databases including performance tuning, backups and recovery.

Tiffany & Co Luxury American retailer known for fine jewelry, china & silver, plus wedding registry.

Working with their in house DBA’s to optimize the Oracle 11g database for Oracle JD Edwards EnterpriseOne.

Consultant at Georgia Department of Revenue Sep 1999-Sep 2015

Sr. Oracle DBA / Oracle Programing / Performance Tuning Architect

Led several work teams as part of organizational attempt to better utilize resources

Led numerous database tuning initiatives

Migrated the Oracle 11g RAC Database from MS Windows 2012 to Oracle 11g RAC databases on to Exadata platform and then upgraded to Oracle 12c.

Proficient in Exadata features such as smart scan, flash cache, storage indexes, IORM, Performance tuning the SQL Queries and databases.

Implemented Exadata X4 half Rack for Georgia Department of Revenue.

Migrating the windows/Linux databases to Exadata machines and setup the environment for Application functioning.

Implementation and administration of Oracle 10g, 11gR1 & 11gR2 RAC setup

Administration of Oracle databases on versions 8i, 9i, 10g,11g & 12c

Handled Administration of SQL Server 7.0, SQL 2000, SQL 2005, and SQL 2008R2

Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node.

Implemented Oracle 12c cloud control Enterprise Manager.

Execution of traditional, secured backup and RMAN based backups.

Perform various maintenance tasks on Exadata Database Machine.

Monitor Exadata Database Machine using the monitoring infrastructure inherently within Exadata Database Machine, along with the monitoring capabilities exposed through Enterprise Manager Cloud Control 12c.

Using utilities OEM/ ILOM for monitoring Exadata Database Machine.

Performance testing on the Exadata Machines. Enabling flash cache features.

Migration of Oracle database across the same and different platforms manually and using O2O tool (Non Exadata to Exadata machines).

Experienced working on complex issues with RAC, ASM, and Oracle streams, RMAN and Recovery by using user managed backup or RMAN.

Worked closely with Oracle Exadata hardware team for various issues - Infiniband, switch issues. Implementing Exadata Storage Server security to prevent from vulnerable.

Using query execution plans, statistics and wait events to examine Exadata Smart Scan.

Best-practice recommendations for consolidation on Exadata Database Machine.

Generated ADDM/AWR reports from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries and performed query optimization

Worked on several in-house projects to support the backend coding to migrate the application from Mainframe (DB2) to Oracle. Which includes the schema designs, SQL and PL/SQL coding includes the Procedures, Packages, Functions and Triggers.

Enhanced the application code from 9i to 10g and to 11g by tuning the application code using the new features like bulk binds/collects, SQL WITH clause, new partitioning features like reference, interval, virtual columns, and composite partitioning, dynamic SQL using the DBMS_SQL

Created PL/SQL procedures, triggers, functions and packages to improve performance of complex reports and to enforce business rules, extensive utilization of dynamic SQL.

Performed several tuning efforts to ensure high performing database such as tuning database design, application, memory usage, sort operations, query optimization and I/O contentions

Performance tuning has been achieved using the Tracing and Tkprof reports, AWR, ASH, ADDM, and Oracle Cloud Computing. This effort has greatly enhanced overall system performance by increasing query data retrieval rates by 40%

Instrumental in developing complex procedures, packages using PL/SQL using new features

Code review in PL/SQL procedures, function, packages & triggers to improve the performance

Coordinated the production changes with QA and load testing groups by using SDLC life cycle.

Conducted the frequent lunch and learn sessions to the new programmers and the DBA’s to educate the importance of optimized SQLs and techniques on how to tune.

As an Architect and DBA, I supported the team to standardize the databases across the platforms and made various SGA/PGA parameter changes according to the environment and application requirement.

Up gradation of Databases from SQL Server 2000 to 2005 and 2008R2 and 2012

Implement & manage MS SQL server database clustering, failover and load balance technologies as per client requirement

Created, administered & maintained MS SQL Server Databases (Production, Development, Test and Staging Environments) for various groups such as Developer, QA, User acceptance and ensured the Availability of the Database Server in a 24X7 Environment.

Handled Logical Data and Index partitioning for large tables in MS SQL Server 2008R2.

Expert in developing T-SQL (DDL, DML, DCL) statements, data integrity (constraints), rules, performance tuning, query optimization and data validation issues, used DBCC (Database Consistency Checks) utilities to check the physical and logical consistency of the database.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and T-SQL code and SQL joins for applications in Microsoft SQL server Databases.

Support the development teams on optimized coding techniques for CRUD functions and schema design optimization

Highly skilled and experienced in Agile Development process for diverse requirements

Created various check points/reports to monitor the client jobs on daily/weekly/monthly basis.

Collecting performance statistics using ASH, Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).

Identified non-scalable database patterns and tuned.

Performed process review for ETL teams to better streamline their SQL Server to Oracle access methodologies

Worked alongside Enterprise Architecture team to consolidate databases platforms to proven commodity hardware saving the company in Oracle licensing, hardware and maintenance.

Mentored the Java .NET developers with the transaction isolation, stored procedure usage and SQL return code validation practice to maintain database consistency and integrity

Worked on several archiving and purge processes to improve the online applications performance

Established the database security using OS authentication, encryption and roles, groups, profiles

Performed SQL tuning, this effort has greatly enhanced overall system performance by increasing query data retrieval rates by 80%.

Environments

Red Hat Linux release 5.7, AIX 6, Windows 2008, 2012 Oracle (10g, 11g R2, RAC & Exadata x4-2), OIM/OAM, OEM, Oracle Cloud Computing (EM12c), Oracle Golden Gate, ETL (ADT), MS SQL Server 2005, 2008R2 & 2012, Toad, Perl, Erwin

Professional Providers Inc, Tampa, FL June 1998-August 1999

Oracle Programmer

Role Summary:

Responsibilities include monitoring the production and test database instances, data architecture, PL/SQL programming and tuning, data loading using Oracle external tables, SQL Loader & UTL packages, batch processing scripts for data warehouse loads, troubleshooting application problems.

Monitor databases for performance issues. Optimize PL/SQL and SQL statements using SQL Analyzer, SQL Expert

Involved in the processes of migrating the Oracle database from 8i to 9i and tuned the SQL and PL/SQL code for the optimal performance using the new features

Trained other developers in tuning the SQL, PL/SQL and usage of trace and explain plans

Environments

Windows NT, Oracle (7.x, 8.x, 9), OEM, Quest Schema Manager & Storage Manager, Erwin, SQL Navigator, C++, PVCS, SQL, PL/SQL, HTML, ASP, Crystal Reports OLTP and OLAP applications.

ORG Systems Limited, India Jan 1997-May 1998

Oracle Programmer

Created a custom extraction system that populated the data into Oracle database

Performed data loads based on the file formats using SQL loader, Imports & UTL files

Extensively tuned the application code using Tkprof, UTLBstat, UTLEstat and Explain Plans

Migrated the application from Non-relational to relational database

Drastically cut down the processing time of generating reports by de normalizing the data

Trained new developer for ongoing system support and maintenance

Took the initiative and migrated more than 80 existing Excel reports into Crystal reports & Web based reports using the Oracle Cartridges.

I have been assigned additional responsibility of tuning the existing packages/procedures.

Tuning the poorly performing SQL queries, this effort has resulted faster batch processing.

Developed custom PL/SQL scripts using built in DBMS procedures that took a precise snapshot of storage consumption for better understanding of the storage requirements.

Tune the database design, application code, memory usage, and I/O contentions.

Environments

HP-UNIX, Oracle 7.x, SQL, PL/SQL, Developer 2000.

ACCEL Automation Limited, Hyderabad, India May 1995 - Dec 1996

Windows/ UNIX/ Network System Administrator

Role Summary:

Hardware and Software Installation, Software upgrades, Operating system upgrades on SUN, DEC Alpha, IBM and Compaq machines.

Maintain the Unix and Windows servers running Oracle 7.x databases

Administrating the network, network operations and new net installations, administrating NFS, DNS and DHCP servers, Novell 3.x, 4.1x and NT 4.0 servers

Isolation and rectification of problems with peripheral devices such as printers, plotters, tap drives, digitizers, DAT drives, disk drives and special electronic devices

Got trained Oracle SQL, PL/SQL and Oracle database administration.

Environments

Sun servers on Solaris 2.x; DEC Alpha Servers; 3000/800 on Digital UNIX; Silicon graphics servers and workstations: IBM servers and workstations: Novel Netware 3.1x, 4.x, Windows ; HP 9000 Servers, HP servers using HP-UX, Oracle 7 Databases.

Educational Qualification

1990-1994 Osmania University, India (B.E Electronics & Communication Engineering)

1994-1995 Jawaharlal Nehru University, India (Advanced programming in C,C++, TCP/IP)

Contact this candidate