PROFESSIONAL SUMMARY

Have strong IT experience and a seasoned DBA in oracle and Informix. During this stint turned out from an amateur to a virtuoso in Oracle products and technologies like Clusterware, ASM, RAC, RMAN and SQL/PLSQL tuning areas. Performed database upgrades from oracle11g to 12c standalone, Restart and Cluster configurations. Upgraded golden gate from 12.1 to 12.3. Performed refreshes of production database to dev instances using rman duplication. Patching Oracle11g and 12c databases. Managed standby databases. Converted physical standby database to snapshot standby for resilience testing. Involved in migration of Networker to commvault backup tools. Cloning oracle home across servers. Installing and managing agents. User management from OID(oracle internet directory). Worked on Testing areas for 2+ Yrs and possess excellent knowledge on testing methodology and tools. Handled database administration on various OS’s like HP-UX, Solaris, Linux, Windows. A Comprehensive 5+ Years of experience in Oracle Database Analysis and SQL tuning. Having adequate skills of managing SQL server and Performance tuning on SQLServer. Worked on programming languages like Informix 4gl, C, VB, Centura, I4GL,PL/SQL and tools like Jmeter, SQL Server Integration services, SQL server reporting tools, JAMS, App Dynamics, Perfmon. Have a good insight of testing tools like Load runner. Acquired an excellent skill on scripting technologies like Groovy, Shell, Perl, Awk, DOS and PowerShell, beanshell over all the period. Highly skilled on analysing AWR’s and stats packs, trace files and other issues pertaining to database, Also acquainted with java stack and heap dumps. Accomplished oracle DBA OCA certification. Accomplished course-era certification in Machine learning . Dynatrace for monitoring database connections. Co-ordinating with development/network/sysadmin teams for changes and testing application. Has knowledge of Machine learning and data science tools in python. Done POC on Mongo DB for analytics dashboard

EDUCATION

Degree

University

Year of Passing

B.E

Osmania

1999

CERTIFICATIONS

Oracle 10g Certified associate (OCA)

Machine Learning from Course-Era

Google IT Automation with Python

EXPERIENCE

Organization

Designation

Duration

Tech Mahindra

Manager DBA

May/2008-Till date

Hewlett Packard

Software developer III

Mar/2004 to Apr/2008

C.M.C

Systems engineer

Sep/1999 to Mar/2004

Hardware

PA-RISC, SUN Spark, Intel Itanium,SCSCI

Operating Systems

Windows, AIX, HP-Unix,Solaris, Linux, SCO-Unix

Languages

VB, C, C++, Centura, PLSQL, SQL, Java,python,Scala,spark

Databases

Oracle9i/10g/11g/12c,Informix, SQL Server 2012

GUI

Toad, SQL Developer

Web Related

HTML, JavaScript, JSP

Tools & Utilities

Informatica, VSS, Shell, AWK, Groovy, Loadrunner, Jmeter, OEM, Oracle SQLTand trace utilities, App Dynamics, Perfmon, Beanshell, SQLServer Integration Services, SQServer Reporting tool,pandas,Goldengate veridata,Goldengate,OID(oracle internet directory)

PROJECTS PROFILE

1.

Project Name : NWF Support And Maintenance

Client

Verizon

Role

Manager DBA

Organization

Tech Mahindra, India

Duration

(09/2016) – Till Date

Team Size

3

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell,AWK

App/Web Server :Weblogic

Database : Oracle11g/12c

Tools : Goldengate,Veridata,OEM,Jira,OID

O/s : Linux, Solaris 10/11

Contribution

Performed database upgrades from oracle11g to 12c standalone,Restart and Cluster configurations. Installation and configuration of Clusterware and ASM. Performing RMAN restore from oracle11g to 12c using commvault media management and upgrade the database. Upgraded golden gate from 12.1 to 12.3. Performed refreshes of production database to dev instances using rman duplication. Patching Oracle11g and 12c databases. Managed standby databases. Converted physical standby database to snapshot standby for resilience testing. Involved in migration of Networker to commvault backup tools. Cloning oracle home across servers. Installing and managing agents. User management from OID(oracle internet directory).

Develop and maintain Backup monitoring framework using Shell Scripts and relational tables. Cloning Oracle Binaries,Performing archive log cleanup using RMAN. Maintaining RMAN backups and trouble shooting RMAN backups over networker tool. Performing Database refreshes from production to Dev instances using RMAN. Performing datapump export and import operations. Coordinating with sysadmin teams for Disk group volumes, Adding disk space to disk groups to ASM. Daily Monitoring of RMAN/Export Backups and rectify. Configuring oracle wallets for password security. Managing TDE wallets. PSU/SPU Patching for 11g Grid/ClusterWare/RAC and standalone Databases using Opatch. PSU Patching for 12C standalone and PDB databases. Working with Golden Gate Replication. Writing Shell scripts for monitoring golden gate. Migrating IBM flash storage to Hitachi storage. Adding additional nodes to database cluster. Complying with audit policies. Maintaining Partioning on Production and non-Prod Systems. Working with Oracle Internet Directory for creating users and maintaining them. Providing 24/7 Oncall support for databases. Working with other teams during patchings etc.Monitoring, configuring targets on OEM. Creating shell scripts and Querying OEM repository to generate HTML reports for DB growth and monitoring golden gate and scheduling through cron. Managing Cron jobs. Performing database deployments. Converting cron jobs to Database scheduler jobs. Managing Users through Oracle Internet Directory(OID) and managing OID replication. Performing POC for zero downtime of the database/Application using Oracle Editioning feature. Performing/Implementing Disasaster recovery for High availability using Snapshot Standby feature. Planning for 12C upgrade. OEM Agent installations and management through OEM. Monitoring template creations in OEM. OEM agent Patching and trouble shooting. Partition archival using transportable tablespace. Reconciling data between oltp and dataware house using Oracle veridata tool. Configuring additional nodes on Oracle cluster. Managing Weblogic server. Compressing Oracle table partitions. POC for Analytics dash board using Mongo db aggregation framework.

2.

Project Name : PCS

Client

PCL

Role

SQL Server DBA, Test Lead

Organization

Tech Mahindra, India

Duration

(09/2014) – (08/2016)

Team Size

11

Project : PCS

Module :

Environment

(with skill versions)

Software

Languages : BeanShell, PowerShell

App/Web Server :Windows IIS 2012

Database : SQL Server2012

Tools : SQL Server Integration Services, SQLServer Reporting tool, Jmeter, App Dynamics, Perfmon

O/s : Windows 2012

Contribution

Preparing Test Cases, Test scenerio Desing for load and scalability, Scripting Scenerios and Test Execution. Preparing test plan for Batch job execution. Planning, Deploying and execution of Batch Jobs. Analyzing the logs and test results and raise Defects for response time Outliers and issues at web,APP, Databae layer. Performing Database backup and Recovery. Extracting Top SQL’s and analyzing for resolution and recommending the dev teams for implemention of Solution. Extracting the results from JMETER Test run and consolidating for final circulation. Installing Perfmon on Test environments, extracting Perfmon Graphs and automating the extraction process. Co-ordinating with other teams. Assisting new team members on JMETER and Database queries. Bringing new insigths on Jmeter for smoother execution of the project. Automating sql server packages through DOS and PowerShell. Installing JAMS client and Configuring Batch Jobs. BeanShell Scripting on Jmeter for simplifying the Test Scripting. Monitoring IIS servers, windows server, Load balancer dashboards and Databases during and after the tests. Analyzing app dynamic request and comparing the responses with JMETER. Raising Defects and tracking for resolution.

3.

Project Name : LIMS, UII, Phoenix, NMDB

Client

British Telecom

Role

Manager Oracle Performance DBA, Test Lead

Organization

Tech Mahindra, India

Duration

(05/2008) – (08/2014)

Team Size

6

Project : LIMS, UII, Phoenix, NMDB

Module :

Environment

(with skill versions)

Software

Languages :PLSQL

Database : Oracle10g/11g

Tools : OEM, Tkprof, SQLT, Trcess,

10046/10053, Load Runner, Jmeter

O/s : OEL, Windows

Contribution

Regular analysis of production and test AWR’s,ASH,ADDM, Identifying expensive SQL and Tuning, Analyzing performance issues using 10046/10053 trace, Profiling SQL queries, Profiling and performing code reviews of PLSQL code, Performing RCA of production SQL/Database issues, performing database capacity management, Driving database production improvements, Co-ordinating with Designers/Devepolers to verify the implementation of recommendataions, Attending production database issues, Desigining database for High performance and availability using RAC and services,Implementing New features in oracle11g, analyzing Java thread dumps,Heap Memory leak analysis. Trouble shooting out of memory issues. Posses very good knowledge on Optimizer working.Tuning Queries by modifying statistics on the objects, Using SQL Hints where ever appropriate. Tuning using SQL tuning/Access advisor. Segment advisot usage and Shrinking segments online. Using performance views for analysis of Queries and general performance. Using Parallelism for Queries. Leading the team, cordinating with external teams for scoping, strategizing the test plans and mentoring the team for developing and execution of scripts. Performing tracing of sessions and tkprof/trcessing the trace files.

4.

Project Name : Partner IT operations

Client

Hewett Packard

Role

Team Member(Oracle DBA)

Organization

HP, India

Duration

(05/2006) – (04/2008)

Team Size

20

Project : Partner IT operations

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK

Database : Oracle8i/9i/10g

Tools : OEM, Tkprof, Trcess, Toad

10046

O/s : OEL, Windows

Contribution

Responsibilities included installation, configuration and Upgradation of Oracle software oracle8i/9i/10g on HP-UX. Configuring, Monitoring RMAN backups using omni backup tool.Restoring, trouble shooting backups when necessary. Standby database creation and management and monitoring. Fixing corrupted standby databases by incremental RMAN backups. Migrating databases from 9i to 10g using datapump. Complying databases for SOX auditing. Configuring,managing scheduler jobs. Managing materiaized views, Partitions. Migrating databases across character sets. Managing deployments and performance of application/Database. Applying patches using Opatch tool. Creating standby databases using cold backup/hotbackups,RMAN duplicate. Performing hotbackups.Refreshing databases using RMAN duplicate. Re-Creating Control files from Cold backups. Performing block corruption detection using DBVERIFY and RMAN and object level. Administrative activities like monitoring tablespaces, table partition management, user management, RAC database creation, configuration and management, materialized view management, resoving service tickets raise by end users

5.

Project Name : -ETL Solutions to Partner operations,CSRT(Channel Sales and reporting,

CALMS (Commercial Air lineHaul Management),CIA(Clear in Air), CALDW, AIR-OPS

tool)

Client

Hewett Packard

Role

Team Member(Oracle/Informix DBA)

Organization

HP, India

Duration

(02/2004) – (04/2006)

Team Size

3

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK

Database : Informix 7.x/9.x, Oracle8i/9i/10g

Tools : OEM, Tkprof, Trcess, Toad

10046, dbaccess, Onstat, ontape

O/s : HP-Unix, Windows

Contribution

Responsibilities include writing shell scripts, analyze PL/SQL code, tuning sqls, migrating pl/sql to informatica

In CIA, CALDW, AIR-OPS the responsibilities include Install, manage informix 7.x/9.x and replication server, optimize sql’s, writing shell scripts. Ontape, onbar utilities. Schema management. Performance trouble shooting. Dbspace management

In CSRT Responsibilities include writing Shell scripts for migrating the database, schema management

Using Informix ontape backup/restore and export and import utilities.

6.

Project Name : Application Maintenance and Support for Western Europe

Client

British Petroleum

Role

Team Member(Oracle/Informix DBA)

Organization

CMC, India

Duration

(08/2003) – (02/2004)

Team Size

2

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK

Database : Informix 7.x

Tools : dbaccess, ontape

O/s : HP-Unix, Windows

Contribution

The Scope of the Work Included Maintaining and Supporting Various applications. The Business scope includes RETAIL, LUBES, LOGISTICS.

Responsibilities include installing, managing oracle8i database and monitoring informix database and creating i4gl reports

7.

Project Name : Out Sourcing of Application support and DBA Activities

Client

GE Woodchester

Role

Team Member(Oracle/Informix DBA)

Organization

CMC, India

Duration

(03/2002) – (07/2003)

Team Size

2

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK

Database : Informix 7.x

Tools : dbaccess, ontape

O/s : HP-Unix, Windows

Contribution

Responsibilities include handiling CR’s from the customer, administer Oracle8i, perform

cold/full backups, capacity planning and proactive tablespace alert management, monitoring

alert logs for issues, Administer informix 7.x/9.x databases, Develop informix ACE reports

8.

Project Name : DGOF

Client

Ordinance factories of India

Role

Team Member(Informix DBA/Developer)

Organization

CMC, India

Duration

(07/2001) – (02/2002)

Team Size

10

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK, VB, C

Database : Informix 7.x

Tools : dbaccess, ontape

O/s : Sco-Unix, Windows

Contribution

Director General of Ordinance factories is a department under ministry of Defence. The aim of DGOF was to computerize all the day-to-day activities in various subunits at the factory level and all the factories in India. The Scope of the work includes

Developing program modules, reports, fixing bugs, administering Informix 7.x database,optimizing instance performance, performing online tape backups using informix ontape utility, writing C modules, VB code for various business scenerios

9.

Project Name : DGOF

Client

Ordinance factories of India

Role

Team Member(Informix DBA)

Organization

CMC, India

Duration

(09/1999) – (07/2001)

Team Size

2

Project :

Module :

Environment

(with skill versions)

Software

Languages : Shell, AWK, C

Database : Informix 7.x

Tools : dbaccess, ontape

O/s : Sco-Unix, Windows

Contribution

Director General of Ordinance factories is a department under ministry of Defence. The aim of DGOF was to computerize all the day-to-day activities in various subunits at the factory level and all the factories in India. The Scope of the work includes

Responsibilities include installing, configuring, administering informix 7.3 databases, writing schell scripts, AWK programs to implement informix new features. Acquired mastery in informix ontape backup/restore utility, perfoming recovery from system crashes, migrating informix 4gl to VB, migrating informix from magnum to datamini servers

Personal Details:

Name

Chakravarthy Pathri

Qualification

Bachelor of Engineering

Email Id

adlakg@r.postjobfree.com

Contact Numbers

+1-858-***-****

Current Location

Sandiego, CA, USA

Contact this candidate