Oracle Data

Chakradhar Reddy Jeereddy

**** *** *****-**** *****-Marie, Montréal, QC H3H 2E8 - 437-***-**** (H) - ac6ihw@r.postjobfree.com

Summary

Extensive support and engineering experience on variety of systems & platforms. Innovative with

proven ability to identify, analyze, and solve problems and control costs through expertise in Cross

functional team leadership & resource management. Support, architecture & design of complex &

distributed systems. Database Administration & Development (Oracle, PostgreSQL and Cassandra). Forecasting, capacity planning and budgeting. Designing & optimizing systems for optimal

performance & scale-ability.

Skills

Oracle database 9i-12c Backups to tape using Symantec NetBackup

Oracle platform cloud integration and Simpana Commvault.

UNIX, Windows Standby/Failover Administration

On premises to cloud consolidation/migration Performance Tuning & Capacity Monitoring

PL/SQL, UNIX Shell Script Oracle RAC, Exadata and ASM

RMAN cloning, backup & restore Administration/Installation

SQL Loader, Erwin Golden Gate replication

Microsoft Azure AWS Cloud(EC2, EBS and S3)

Talend ETL

Education and Training

Jawaharlal Nehru Technological University Hyderabad College of Engineering 2006

Bachelor of Technology

India

Education credential assessment by WES as "Canadian Equivalency" of bachelor’s degree (4 Years).

Experience

TELUS International Through Xavient Digital LLC (Client) April 2018 - June 2018

Oracle DBA-PL/SQL Developer

Montreal, Quebec

Environment: Bare metal servers with Redhat Enterprise Linux operating system, 3-node Oracle 12C

RAC, GoldenGate unidirectional feed, OEM-12C.

Enhanced the features of existing PL/SQL data purging engine to automate deletion of

600 million unwanted records from an integrated database. Performed reverse engineering of data models and provided insight on existing logical and physical relationship between 40 schemas and 3000 entities.

Improved performance of purging activity using parallel DMLs at the same time prevented constraint violation errors by following the order of deletion of rows for tables with referential constraints. Provided a toolset design and code to purge 600 million records from database and earned value to client by improving DB system performance, reclaimed disk space and saving dollars on maintenance and per CPU software licenses.

TATA Consultancy Services Ltd November 2013 to January 2018

Oracle Database Administrator

Client: BlackBerry Research in motion, Waterloo, Canada

BlackBerry Limited, formerly known as Research In Motion Limited (RIM) is a Canadian

telecommunication and wireless equipment company best known to the general public as the

developer of the BlackBerry brand of smart phones and tablets, also well known worldwide as a

provider of secure & high reliability software for applications and mobile device management.

Project: Maintenance and support for oracle 11g/12c, MSSQL 2012/2014

Environment: Oracle 11g/12c, Unix, Windows, NetApp storage, Exadata X5-2, GoldenGate

Bi-directional, Oracle secure backup and Commvault, OEM 12c & AWS Cloud.

Responsibilities:

Responsible for major Oracle database and server consolidation effort comprised of high-end

UNIX servers which was completed ahead of schedule and led to $500k in annual cost savings.

Managed RMAN backups using Commvault tool, conducted performance tuning analysis and

modification and developed standard operating procedures.

Proactively provided technical infrastructure solutions to meet strategic business goals

including application integration, database design, system consolidation and database training.

Implemented and maintained Goldengate Bi-directional replication between Asia pacific and

North America transnational databases.

Configured shell scripts to monitor GGS replication lag and process status.

Provided High Availability (HA) and Disaster Recovery (DR) solutions to maintain business

continuity.

Responsible for implementing and overseeing enterprise database security standards and

ensuring compliance with the corporate IT change management process.

Provided architecture design and implemented production database replication, backup and

contingency recovery strategies.

Performed data loads using Data Pump and export/import utility.

Analyzed database performance utilizing Oracle ASH, AWR, ADDM and OEM.

Diagnosed and troubleshot database problems such as errors and bugs, performance problems,

runaway processes, connectivity problems, poor SQL statements, etc.

Administrated Golden Gate replication between transaction and warehouse environments.

Exadata implementation, migration of databases from oracle standalone to eight node RAC on

exadata.

Performed 400 TB warehouse database migration from x2-2 to x5-2 exadata machines.

Launched UAT, DEV and production database into EC2 instances of AWS cloud.

Designed and implemented high availability architecture for applications using

operating system clusters such as veritas, Oracle's Real Applications Cluster, Data guard and

golden gate.

Hands on experience in Altus and AWS Cloud environments.

As part of BlackBerry transformation project, I migrated databases from itanium servers to Red

Hat Enterprise Linux OS/UX and CentOS platform.

Wipro Limited November 2012 to November 2013

Senior Database build and deployment

Client: Genpact USA

Genpact (NYSE: G) is a global professional services firm that makes business transformation real. It

drive digital-led innovation and digitally-enabled intelligent operations for their clients, guided by

their experience running thousands of processes for hundreds of Global Fortune 500 companies.

Project: Genpact IT DBA support

Environment: Oracle, Golden Gate, PostgreSQL, Unix, Netbackup Symantec, Windows, OEM 11g,

Altus.

Responsibilities:

Worked with operations, development and incident management teams to troubleshoot and

take pro-active steps to ensure the availability and reliability of database services.

Installed and supported 2-node 10gR2 and 11gR2 RAC databases, running on RedHat Linux 5.

Contributed to Data Center migration project involving database upgrades; 9i to 11g, 10g to 11g.

Tuned and improved daily purge process using partitioning and parallel processing by 400%.

Collaborated with managed service providers, internal development team, consultants and

Oracle Support, to plan, optimize, and design database systems and its supporting applications.

Wrote several scripts (shell, SQL) associated with monitoring, database backups using RMAN

and NetBackup tool, tuning, and cloning.

Capacity planning, estimate and technical proposal on hardware and software for new clients.

Launched database into cloud and automated backups and monitoring

Migrated databases from HP-Itanium to commodity servers and reduced the per CPU product

license cost by 40%.

Configured Golden Gate replication between oracle databases.

Implemented business continuity plan using data guard and GoldentGate active-passive

bidirectional replication between production and standby databases.

Envestnet Yodlee (Client – Bank of America) April 2010 to June 2012

ORACLE IT DBA

Yodlee provides the best and most comprehensive financial data across retail banking, credit and

wealth management, made possible through the strengths of our data acquisition capabilities,

extensive data cleaning and enrichment expertise, and massive scale. The Yodlee Data Aggregation

Platform has fueled innovation in online banking and financial data management for 17 years,

securing 80 issued patents along the way.

Project: Legacy and trilogy database support

Environment: Oracle 10g, HP itanium, RMAN, Oracle Secure backup RAC and ASM.

Responsibilities:

Migrated 200 TB of warehouse databases into cluster using RMAN backup based cloning and

without using third party tools.

Duties included database optimization and performance tuning, developing and implementing

backup and recovery procedures, database installation, upgrades and migration, monitoring

and maintaining the databases and resolve locking issues.

Tasks performed using Quest DBA tools, SQL* Plus, Enterprise Manager, Oracle Performance

Pack, EXP, IMP, RMAN, Netbackup, Veritas and custom designed scripts written in SQL and

PL/SQL for monitoring and optimization.

Supported multiple production and pre-prod instances running Oracle 10g and 11g standalone

and RAC. Database sizes range from 400GB to 10TB.

Configuration of monitoring alerts using CRON and OEM grid control.

Database upgrade from 10g to 11g and patching.

Worked with the internal development team to provide the necessary SQL, PL/SQL and other

database management scripts to enhance, tune, optimize and implement database related

development activities.

Collaborated with managed service providers, internal development team, consultants and

Oracle Support, to plan, optimize, and design database systems and its supporting applications.

Wrote several scripts (shell, SQL) associated with monitoring, database backups, tuning, and

cloning.

Tuned and improved daily purge process using partitioning and parallel processing.

Contributed to Data Center migration project involving database upgrades 9i to 10g, 10g to 11g.

Olive Crypto Systems LLP February 2007 to April 2010

Associate DBA - Oracle

Olive solutions provide scalability, extensibility, high availability with good performance on

commodity hardware, reliability is built into application rather than depending on expensive

hardware platform for its reliability. Olive is a product based company and has built several

indigenous payment products and also offers consulting and auditing services in financial domain.

Client: Reliance General Insurance

Responsibilities:

Refreshed UAT and Development database using production backups through RMAN and

Export/Import utilities.

Resolved incident tickets and followed the ticket closure process.

Managed daily support for financial application, including monitoring standby database

availability, monitoring replication snapshots performance, maintaining schema referential

integrity, and cloning databases.

Managed databases ranging from a few GB to 650 GB which included OLTP and Data

Warehouse.

Tasked with start-up and shutdown of Oracle Applications processes when needed.

Improved performance with segregated reporting, tuning PL/SQL code, and scheduling

changes.

Improved code deployment techniques by enhancing shell and SQL scripts and processes.

Attended requirements gathering sessions in new application design or migration projects.

Recommended appropriate Oracle high availability and high stability configuration to

customers based on their business needs and budget.

Activities and Honors

CERTIFICATIONS

Oracle 12c Oracle certified associate

Redhat certified system Administrator

Oracle 10g Oracle certified professional

Recognition

Band A performer for last 3 consecutive years at TCS.

Continuous appreciation and accolades from regional heads at Wipro.

Several Outstanding performance and White Cap awards at Yodlee InfoTech.

Contact this candidate