Sai Reddy.

567-***-****

ace8ly@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 8 + years of experience in Oracle Database Administration, tuning, development,

analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration,

database security, capacity planning, space management, data modeling, backup and recovery,

cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.

1. Experience in installing, maintaining, upgrading, migrating and

patching Oracle versions 11g/10g/9i/8i.

2. Oracle Database Administration in a variety of environments like Linux(Red Hat), Sun

Solaris, and Windows NT/2000/2003.

3. Experience in testing and implementing RMAN scripts in windows, linux, oracle 11g

4. Experience in system Monitoring and Database Performance Tuning using Explain

plan, SQL Trace, TKProf, AWR,ADDM.

5. Setup of Standby database for faster disaster recovery and Data guard setup for high

availability.

6. Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic

thinking.

7. RMAN procedure for backup and recovery and also cloned database using RMAN

Duplicate.

8. Have knowledge about Application dba and can support base quieries.

9. Managed Oracle databases in High Availability environments using Failover, Clustering,

Mirroring, Dataguard and Cloning technologies.

10. Developing and implementing RMAN scripts on Unix, solarix and oracle 9i,11g

11. Experience in performing needs assessment, database planning and design, application

testing and integration, production cutover, change management.

12. Experience in clustering and disaster recovery.

13. Good Knowledge in handling and setting up of Data Guard.

14. Perform maintenance activities for application like running statistics manually

15. Experience in working with networking tools TOAD,PL Sql Developer ….

16. Experience in Database problem resolution, dealing with Oracle, creation of SRs.

17. Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch

utility.

18. Worked on 10g New Features: Data Pump, Automatic performance and diagnostics,

Flash Back Technology, 10g RMAN’s New Features and Data guard(stand by database).

19. Experience in database full Backup (hot and cold), Incomplete Backup, fail-over, DR

methodologies, DataPump Export/Import, FTP, SQL Backtrack and Restore procedures.

20. Experience in Space Management, Rollback segments, Undo segments and Capacity

Planning.

21. Production and Dev Support for RAC environment.

22. Performance tuning of Oracle servers, databases and SQL.

23. Experience in Database creation with RMAN jobs and security implementations in

Oracle.

24. Ability to write, debug and tune sql and pl/sql, packages, procedures, functions, triggers.

25. Data Loading using SQL*Loader and DBVERIFY for corruption checking.

26. Used parameters to configure, install and manage ASM instance in 10g RAC.

27. Handled hierarchical and relational databases.

28. Experience in maintenance of Production, batch management, Testing, Development,

RAC, Standby databases/ Dataguard.

29. Experience in monitoring of systems using Grid control.

30. Planned and implemented Disaster Recovery solutions using Oracle Standby

Database/Dataguard.

31. Back-end programming, database Triggers, stored procedures and functions using

PL/SQL.

32. Executes software installations, database creations and loads.

33. Responsible for data loading, security, performance monitoring and tuning, capacity

planning, and backup and recovery.

34. Experience in executing DDL/DML scripts.

35. Good Experience in creating and managing schemas, tables, indexes, constraints and

materialized views.

36. Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces,

Indexes, User Setup, Roles, Security, Storage and hands on experience in network

management.

37. Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.

38. Experience in Very Large Multi Terabyte Database ( VLDB) and also performed

migrations in this environment.

39. Documented all Oracle database installations and database operations

EDUCATION:

Bachelor’s Degree from Jawaharlal Nehru Technical University – Hyderabad, India -

•

May 2006

TECHNICAL SKILLS:

Database : Oracle 12c/11g/10g, RAC 11g/10g, SQL Server

•

Operating System : Linux, HP-UX 11/11i, Sun Solaris, DB2 and Windows 8

•

Languages : SQL, PL/SQL, UNIX

•

Tools/Utilities : RMAN, TOAD, TKPROF, Oracle Grid Control, SQL*Loader,

•

DataPump (Export/Import), OEM, RAC,AWR, STATSPACK,

GoldenGate.

PRACTICAL EXPERIENCE:

Lexis Nexis April 2014 - July 2014

Dayton, OH

Database Admin

Working with Infosys as implementation partner for client: Lexis Nexis. LexisNexis® is a leading global

provider of content-enabled workflow solutions designed specifically for professionals in the legal, risk

management, corporate, government, law enforcement, academic markets and homeland security

initiatives. Through risk and analytics solutions to assess risk, the company helps professionals verify

identity, prevent fraud, comply with legislation, facilitate and secure commerce and support law

enforcement. LexisNexis encompasses authoritative legal-publishing brands dating back to the 19th

century including; Butterworths® in the United Kingdom, Canada, the Asia-Pacific region & France.

Project here mainly delt with maintaining more than 500 different application related databases and

regular maintenance of databases in different platforms like SQL, SYBASE and Oracle.

Responsibilities:

• Major activities were deploying the scripts in Oracle, SQL and sybase platforms and

troubleshooting the errors by co-ordinateing with developers and other related teams.

• Cloning/replication of application database environments & database related troubleshooting.

• Working on performance tuning of queries and database performance improvements.

• Worked in a team where upgrade of database from 10.2.0.4 to 11.2.0.3 by applying patches using

Opatch utility was done.

• Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).

• Work on Run and Change activities in a 24x7 environment on-call.

• Exposure and working Knowledge of SQL and Sybase database.

• Worked on dba activities which include Creating Users, Roles and Profiles, Privilege

management with role-based security of databases, table spaces, indexing, data maintenance and

user management.

• Performed performance tuning using Explain Plan & SQL*Trace.

• Applied High priority patches downloaded from Metalink.

• Generate AWR,ADDM reports and analyze it.

• Study the Explain plans and try to troubleshoot where query taking long time.

• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.

• Working with different tools like OEM, SQL DEVELOPER, MS SERVER MANAGEMENT

Studio for SQL databases and DB artisian for Sybase databases.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, Toad, AWR, ADDM, ASH, SQL,

PL/SQL, 2005 and 2008 MS SERVER MANAGEMENT studio, DataPump, OEM, RMAN,

SQL*Loader, DBartisian, SQL Server, OLTP.

Novelis Nov 2013 – Feb 2014

Atlanta, GA

Senior Oracle DBA

Worked with Capgemini Implementation partner. Client: Novelis is the world leader in rolled

aluminum products, delivering unique solutions for the most demanding global applications, such as

beverage cans, automobiles, and architecture and consumer electronics. Project here mainly delt with

maintaining different application related databases, migrating and regular maintenance of databases in

different locations in country, there were total of 120 databases.

Responsibilities:

• Refreshing the reporting database from transactional database every month end.

• Involved in the team for migrating the development and test databases from Canada, Ohio to

Atlanta.

• Created Documents for all the sessions for the juniors for reference in offshore.

• Co-ordinate and implemented maintenance of databases with HCL, CGI and CapGemini offshore

team.

• Creating, updating user accounts.

• Designed physical and logical database structures and created, managed Table spaces.

• Looking after the dbms jobs on windows server, if there is any issue rectifying it.

• Fixing replication jobs.

• Worked with different tools like TOAD, SQL developer, Benthic Golden, putty and OEM java

consoles.

• Creating Documents for Knowledge Transfer sessions for fresher’s in Offshore and provided

them the online Knowledge transfer sessions.

• Testing and implementing RMAN Scripts on Oracle 9i/11g, Linux, Unix and Windows.

• Maintenance of different applications like SAP,TIBCO and other internal classified databases

related databases that mainly concentrated on shipping, logistics, inventory and Auto pay

databases.

• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack,

ASH and Unix commands.

• Executed DDL/DML scripts.

• Applying upgrade patches, maintenance and interim patches on all the databases

• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures

• Fixing the Materialized views when it showed errors while refreshing.

• Executed and implemented the refresh scripts of different MV.

• Monitored production database using AWR and ADDM for Daily or weekly tuning

needs.

• Archiving and clearing of old log files in the databases and setting up in automatic mode.

• Performing federated refreshing.

• Documented all Oracle database installations and database operations.

Environment: Oracle 8i/9G, ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Windows 2000

Servers, Benthic Golden, Toad, AWR, ADDM, ASH, SQL, PL/SQL, Dataguard, DataPump,

OEM, RMAN, SQL*Loader, NETBACKUP, SQL Server, OLTP.

Epsilon Oct 2012 – Oct 2013

Irving, TX

Senior Oracle DBA

Epsilon makes e-mail marketing easy. Epsilon Data Management is a leading provider of direct

marketing and customer relationship management services. As one of the world's

largest permission-based email marketing providers, it sends more than 40 billion e-mails each

year and helps develop database marketing and consumer loyalty programs, as well as marketing

communications for traditional direct mail and interactive media campaigns.

Responsibilities:

• Perform Backup and Recovery of Primary and Standby Databases using RMAN and external

backup using NETBACKUP.

• Migration of Database from 9.2.0.6 to 10.2.0.2 (RAC)

• Testing and implementing RMAN Scripts on Oracle 9i,11g, Linux, Unix and Windows.

• Upgrade of database from 10.2.0.4 to 11.2.0.3 by applying patches using Opatch utility.

• Transportable Tablespaces (TTS), Export/Import and Datapump (expdp/impdp).

• Manage and maintain database and user security using OEM Grid Control

• Supported development by providing SQL statement tuning and optimizing ETL

procedures and removing load and query performance bottlenecks by using tools like

Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager (OEM).

• Worked with IT managers and application developers to ensure the database integrity, high

availability and security.

• Worked with networking tools TOAD.

• Executing scripts to maintain performance and conduct maintenance activities.

• Experience in clustering and disaster recovery.

• Data Loading using SQL*Loader and DBVERIFY for corruption checking.

• Developed PL/SQL packages, procedures, functions and triggers to support application.

• Installed Oracle 11g database in the test environment and tested the upgrade from Oracle

10g to 11g.

• Executed DDL/DML scripts.

• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics

on UNIX servers using IOSTAT, NETSTAT, VMSTAT and PRSTAT.

• Applying upgrade patches, maintenance and interim patches on all the databases.

• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.

• Designed physical and logical database structures and created, managed Tablespaces.

• DBA activities which include Creating Users, Roles and Profiles, Privilege management

with role-based security of databases, tablespaces, indexing, data maintenance, roles, user

management, and maintenance.

• Applied High priority patches downloaded from Metalink.

• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, BI, RHEL 4.x, SNET, SUN

SOLARIS 10, Toad, AWR, ADDM, ASH, SQL, PL/SQL, GoldenGate, Dataguard, DataPump,

OEM, RMAN, SQL*Loader, NETBACKUP, SQL Server, OLTP.

CNSI

Maryland Oct 2011 – Sep 2012

Oracle Database Administrator

CNSI delivers a broad portfolio of information technology (IT) and business process

outsourcing. The company has established presence and strong domain expertise in prominent

industries, including Defense, Energy, Financial Services, Healthcare, Homeland Security/Law

Enforcement and Transportation. The project includes installation of Oracle 10g RAC,

performance tuning, maintenance of production database.

Responsibilities:

• Involved in team management, team building exercises for the DBA team.

• Involved in RAC administration including 10g Database cloning, tuning, patching and

monitoring concurrent manager processing etc.

• Wrote several shell scripts for checking oracle errors in alert file and database backup log

files.

• Handled Hierarchal and Relational Databases.

• Cloning of application from production environment to test environment and application of

patches.

• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN

catalog for the same.

• Developing, testing and monitoring scripts of RMAN.

• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned

the Databases, Backing up and Refreshing ORACLE DB’s.

• Creating users with restricted access, with default and temporary table spaces. Partitions on

tables and indexes .Creating roles and granting to users based on their group requirements.

• Creating profiles and attaching them with users, performing hot and cold backups.

Restoration and recovery from backup.

• Oracle Export, Import, SQL*Loader and data pump utilities.

• Installing & configuring Oracle 10g, 10g RAC, 9i on Linux Installation, Configuration,

Upgrade, patching of Oracle RDBMS.

• Influencing Skills, High confidence, Passion for retail, Empathy for people, Strategic

thinking

• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack,

ASH and Unix commands.

• Executed DDL/DML scripts.

• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared

Pool Tuning, Buffers and Disk I/O tuning.

• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.

• Experience in Very Large Multi Terabyte Database ( VLDB) and also performed migrations

in this environment.

• Documented all Oracle database installations and database operations

Environment: ORACLE 11g, SQL, PL/SQL, Import/Export, UNIX, Windows 8.

Ericsson Inc

Plano, TX May 2009 – Aug 2011

Database Engineer

Ericsson is a provider of telecommunication and data communication systems. It is one

of Sweden’s largest companies. Ericsson hosts every production servers of ATT and few other

Telecomm companies. Ericsson provides various opportunities for suppliers like installation and

testing, transportation and construction. This project includes installation of Oracle 10g RAC,

performance tuning, maintenance of production database, patch supplying, migration,

maintenance of standby database and performing recovery operations.

Responsibilities:

• Defining and implementing Backup and Recovery Strategies on production, test and

development databases using RMAN and RECOVERPOINT, Hot and Cold Backups.

• Performing the oracle 10g DataPump export and import on database, tablespace, and

schema.

• Successfully implemented physical standby database using Oracle Dataguard feature for

High availability on Sun Solaris.

• Implementing and testing Scripts of RMAN on Solaris and Unix.

• Installed and configured 10g Enterprise Manager and Grid Control.

• Performed Database Migrations from 9.0.1.4 to 10.2.0.2.

• Maintaining the oracle database security like Users, Privileges, Roles and Profiles Using

OEM.

• Cloned/ Data Refresh from production to setup test and development environments.

• Monitoring and Tuning UNIX servers using TOP, PRSTAT, IOSTAT, NETSTAT, VMSTAT.

• Created Big file Table Space creating and maintaining big file Table Spaces.

• Applied patches, patchsets and Critical Patch Update (CPU) using OPatch utility and OUI.

• Created and maintained different database entities included table spaces, data files, redo log

files, Rollback segments, Indexes, Undo segments and renaming/relocating of data files on

servers.

• Involved in migration of non-ASM database to ASM with the use of OUI/OEM

• Experienced in using utilities like Export/Import and SQL*Loader.

• Documented all Oracle database installations and database operations

• Monitored production database using AWR and ADDM for Daily or weekly tuning needs.

• Monitoring databases to ensure high availability and optimum performance.

Environment: Oracle 9i,/10g, Oracle 10g RAC, ASM, Sun Solaris, RHEL, UNIX, OEM Grid

Control, RMAN, SQL*PLUS, TOAD, PL/SQL, SQL*Loader, Datapump,

B.H.E.L

Hyderabad, India Dec 2007 – Feb 2009

Oracle DBA

Bharat Heavy Electricals Limited is one of the largest engineering and manufacturing

enterprise in India in the energy-related/infrastructure sector. BHEL manufactures over 180

products under 30 major product groups and caters to core sectors of the Indian Economy. This

project deals with installation, migration, RMAN backup, setup standby database and

performance tuning.

Responsibilities:

• Backup of database Logical and Physical (hot and cold) procedures and also

using RMAN, Complete and incomplete recovery of database

• Setup of Standby database for faster disaster recovery and Data guard setup for high

availability.

• Migration of database from 8i/9i to 10g in the production and development.

• Performed SQL query optimization by gathering statistics and by using explain plan,

STATSPACK, TKPROF and SQL Trace.

• Applied patches for the upgrades, bugs recovery, troubleshooting.

• Coding stored procedures, Packages and functions and well tuning the SQL in the

application.

• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash

Back Technology, 10g RMAN’s New Features and Data guard(stand by database)

• Responsible for creating tables and indexes, performance monitoring of queries, table

space allocations, and data striping.

• Used RMAN for Cloning of the creating database in test and development environment.

• Performed migration of database with Export, Import, Datapump and SQL*Loader jobs.

• Periodically uploading data from flat files using SQL*Loader

• Monitored RMAN scripts on Oracle 9i.

• Monitoring production systems to establish status and conduct proactive maintenance

• Ensuring proper online and offline backup and Periodical reading and checking of backups

taken.

• Online index rebuilds. Controlling and monitoring user access to the database. Monitoring

Rollback Segments.

• Estimation and creation of Control file, Log file (including multiplexing), Data files,

Tablespaces and rollback segments.

Environment: Oracle 10g/9i/8i, RHEL, IBM-AIX, Windows NT, RMAN, Datapump, SQL,

PL/SQL, exp/imp, TOAD, SQL*Loader.

Bajaj Alliance Insurance

Hyderabad, India June 2006 – Nov 2007

Junior DBA

Bajaj Alliance Insurance offers a comprehensive range of financial services bringing the freedom

of mobility to consumers, businesses and government users. It is widely recognized for Business

technologies. The project mainly delt with RMAN backups, maintaining databases and applying

patches.

Responsibilities:

• Installing Oracle 9i and upgraded it to latest 9i patch .

• Migrating applications from non-clustered oracle 8i/9i databases to new 10g RAC Database

environments.

• Monitoring and supporting Applications using OEM 9i Grid Control.

• Configured two node Oracle 9i RAC cluster.

• Created PARTIONING of its types like Range, List & Hash by the specific use.

• Implemented Oracle Streams for Replication.

• Implemented schema level, table level and bidirectional oracle streams.

• Registering Databases to RMAN Catalog.

• Planning and scheduling Backups, RMAN, taking Logical Backups.

Environment: Oracle Grid Control, Oracle 9i.

Contact this candidate