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
********@*****.***
Contact Numbers
Current Location
Sandiego, CA, USA