Anish Peddireddi.

618-***-****

acdshu@r.postjobfree.com

8+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation,

Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data

Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams.

• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, HP-UX, Windows, UNIX and Sun

Solaris in OLTP environment.

• Managed Databases in the range from 50GB to 3TB.

• Performed Migration and Upgrade of databases to 11g and 10g.

• Upgradation of databases by applying patches, patch sets and critical patch updates.

• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i

in different operating systems for OLTP environment on Very Large Databases(VLDB).

• Extensive experience on Oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC

environment

• Experience in Configuring Automatic Storage Management (ASM).

• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing

issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks

regarding the performance and maintenance.

• Extensive experience in configuring and managing Dataguard on RHEL, OEL and Windows.

• Configuration of dataguard broker on RAC.

• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod

databases.

• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control

• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.

• Regular database synchronization for test database environments through automation.

• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.

• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing

periodical backup, restoration and recovery using RMAN(full and incremental)

• Testing and implementing different physical and logical backup and recovery methods including point in

time, media recovery, full/partial, export/import, expdp/impdp.

• Migration of databases from one platform to another platform.

• Extensive experience in migration of databases with export/import, expdp/impdp, RMAN.

• Implementation of Flashback Technology.

• Experience of installing, configuring Golden Gate and troubleshooting Golden Gate issues.

• Experience in Uni-directional and Bi-directional replication through Golden Gate.

• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data

loading.

• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports,

Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database

activity, Querying Oracle dynamic performance views.

• Monitoring and Optimization of database performance through database tuning, system tuning and

application tuning.

• Experience in SQL Tuning, Optimization, cost based optimization and Hints

• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF,

STATSPACK, SQL TRACE.

• Proficient in INDEX REBUILDING and INDEX TUNING.

• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux

monitoring using NMON and TOP commands.

• Experience working with Database Resource Management

• Working experience in creating materialized views.

• Proficient in writing PL/SQL Procedures, Functions and Triggers.

• Experience using Erwin as a Data Modeling tool & Designing the ETL processes

• 24*7 on-call production database support and maintenance including remote database support

• Assisting in implementation of change control process in production.

• Ability to work in a team as well as to take individual responsibility.

Technical Skills:

Databases: Oracle 11g, Oracle 10g, Oracle 9i.

Oracle Products: Oracle grid control, Oracle Enterprise Manager (OEM), SQL * Loader,

Export and Import, Expdp and Impdp, RMAN, ASM.

Other Tools: VERITAS, Putty, Oracle streams, Win Scp, ERWIN, VNC server, Toad.

Programming Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL.

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP, Windows server 2003.

Education:

Bachelors in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, 2005,

India.

Professional Experience:

Wells Fargo, San Leandro, CA

Sr Oracle DBA

(Nov ’12 – TILL DATE)

Wells Fargo is a provider of banking, mortgage, investing, credit card, insurance, and consumer and commercial

financial services.

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g on RHEL 4 and 11g on RHEL 5, HP-UX,

AIX and Windows 2003 Server and Upgradation from Oracle 10g to 11g.

• Responsible for setup and implementation of two node RAC on Oracle 11g.

• Configured Oracle Dataguard for Oracle Disaster Recovery.

• Implemented Dataguard on Production Database.

• Performed day to day administrative tasks by analyzing the database like checking for failed processors,

verifying the query for particular issues and validating disk space.

• Migration of large number of databases from 10g to 11g.

• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

• Migration of non ASM database to ASM database.

• Using list partitions for large tables and bitmap indexes for the OLAP databases.

• Cloned a database using RMAN Utility.

• Installation and configuration of Goldengate .

• Replication of data using Oracle Goldengate.

• Monitored database health checkup and took evasive action for any problem.

• Looking into day-to-day activities of Production database, Monitoring its growth and performance.

• Creation of users and granting them their roles and privileges.

• Configuration of Listener and TNS names using NETCA and NETMGR.

• Database backup & Recovery for non archive and archive database with RMAN commands.

• Done exports and imports of tables, schemas and tablespaces with datapumps.

• Archive weekly all production database exports to Tapes.

• Developed and enforced both database and OS-level security policies for data protection.

• Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting.

• Managed databases using OEM Grid Control.

• Post installation process, kernel upgrade, applying support packs and add-ons.

• Daily incremental backups and weekly cumulative backups using RMAN.

• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression,

partition, indexing and use of Hints, Stored outlines, Statistics.

• Worked extensively on monitoring grid control database, configuration of error notifications, installing

listeners, and adding them to the grid control.

• Used SQL*Loader to load data into database tables.

• Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR,

ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.

• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution

plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.

• Developed Scripts for transferring data from production server to testing/development servers.

• Cloning of databases using RMAN and also user managed.

• Management of databases on multiple servers.

• Developed table structures, PL*SQL stored procedures and database triggers to implement business

rules.

• Managing and providing 24X7 supports for various versions of databases.

• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11g,Linux 4/5, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003

server, OEM Database control, PL/SQL, SQL*Loader, Shell Scripting, PERL, TOAD, ASM, Golden Gate, Data

Guard.

CSG, Omaha, Nebraska.

Oracle DBA

(Sep ’10 – Oct ’12)

CSG is one of the world's leading providers of business support solutions, CSG International understands what it

means to evolve, adapt and transform. CSG goal is to help you generate revenue, maximize customer value, and

manage your business more efficiently.

Responsibilities:

• Installation, configuration, upgradation and maintenance of Oracle databases of Oracle 10g on RHEL.

• Configuring and maintaining of a Two node RAC on Oracle 10g.

• Managed users and maintained security, populated databases of Oracle 10g on RHEL, Solaris and

Windows 2003.

• Upgraded databases from 10.0.1.0 to 10.0.4.0.

• Implementation of Data Guard for disaster recovery.

• Migration of databases from Solaris to Linux.

• Involved in migration of applications of the clients.

• Configuring ASM with normal and external redundancy.

• Restoring databases from Critical failures.

• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance

and automating functions wherever possible.

• Responsible for scheduling backups.

• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management,

Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory

Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle

Advanced Replication, Real Application Clusters.

• Responsible for logical and physical database design, implementation, transforming logical data

models into physical databases, and defining strategies for database implementation, high performance,

replication & failover.

• Taking Incremental backup using RMAN.

• Creating tables, tablespaces, users, views and related objects.

• Used SQL*Loader to load data into database tables.

• Implemented procedures to detect the poor database performance, collecting required information, root

cause analysis, successfully tuned and improved the performance of the database.

• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.

• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.

• Implementation of logical backups using Log Miner.

• Implemented Point in time recovery using RMAN.

• Configuration and implementation of Oracle Streams (Advanced Replication) for high availability.

• Performed Schema as well as Table level Replication using Oracle Streams.

• Implemented downstream capture at the destination database using Oracle Streams.

• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

• Tuning SQL queries when the performance is poor.

• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical

IO and Memory Usage.

• Implementing backup procedures using Cron Tab.

• Worked on activities such as Query Optimization, Database Consistency Monitoring.

• Used Shell Scripting to backup database.

• Physical and logical data modeling using Erwin tool.

• Responsible for granting required privileges and roles to users.

• Duplication of production databases.

• Renaming and resizing databases.

• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using

NETCA and NETMGR.

• Responsible for Space management and resolving dead lock issues.

• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and

removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and

TKPROF

• Managing table spaces, user profiles, indexes, storage parameters.

• Involved in developing and implementing PL/SQL stored procedures and triggers.

• Involved in PERL for reporting purpose

• Responsible to provide 24 x 7 database administrative activities over different database servers.

• Provided all kinds of DBA support to development teams as well as production support to various

applications.

Environment: Oracle 10g, Linux, Solaris 10, Window 2003, Oracle Enterprise Manager Database Control,

RDBMS, TOAD, SQL*Loader, PL/SQL, Shell Scripting, PERL, ASM, Data guard, Oracle Streams, Oracle

primavera.

Sprint, Overland Park, Kansas

Oracle DBA

(Aug ’09 - Aug ’10)

Sprint offers a comprehensive range of wireless and wire line communications services bringing the freedom of

mobility to consumers, businesses and government users. Sprint is widely recognized for developing, engineering and

deploying innovative technologies, including the first wireless 4G service from a national carrier in USA offering

industry-leading mobile data services.

• Oracle Database software installation, Instance creations, schema creations.

• Upgradation of databases from 9i to 10g.

• Configuring and Maintaining of Physical Standby databases.

• Supported different Databases like Production, Testing, Staging and Training.

• Implementation of dataguard on 9i.

• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA,

for performance testing and future 10g production implementation

• Supported different Databases like Production, Development, Testing, and Data warehouse.

• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.

• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures,

data migration, data clean-up, copy data archiving, etc.

• Online and Offline Database backup and Recovery using RMAN.

• Automated monitoring the databases, performance parameters, backup and recovery activities by running

Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick

Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring,

move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high

availability.

• Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node

applications

• Monitored and tuned long running jobs by working closely with the application development team and

analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan,

TOAD.

• Performed troubleshooting of database using AWR and ADDM reports.

• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP

and OS methods.

• Performed Database replication from production to test/development environment Using RMAN, Data

pump utilities and manually

• Responsible for network configuration and involved in a Client–Server environment using TNS Names,

LISTENER, Net Configuration Assistant and other configuration files.

• Extensively used SQL* LOADER as a tool for loading data.

• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM

Database Control to monitor database.

• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily

basis observing the performance of the production database and constantly active regarding

performance and space management issues and accordingly providing on-fly solutions to make database

healthy and running.

• Extensively compressed large tables in Data warehouse Environment to reduce space usage.

• Created and Managed users, user profiles, tablespaces, data files, archive log.

• Created database links that are required for databases.

• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.

• Perform extensive testing on new versions of database products and tools to identify and resolve

migration issues before these products are installed in the production environment.

• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export,

Data pump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting,PERL, Data

warehouse, AIX 4.3 etc.

Selective Insurance, Branchville, NJ

Oracle DBA

(Jun ‘07 – Jul ‘09)

Selective Insurance Group Inc in Branchville, NJ is a public company categorized under Fire, Marine, and Casualty

Insurance. Our records show it was established in 1977 and incorporated in New Jersey.

Responsibilities:

• Installation and maintenance of Oracle 9i/10g on Linux OS

• Installed, upgraded and patched Oracle installations.

• Managed data files, control files, redo log files, tables, indexes, constraints for performance and

availability.

• Worked on user management mainly on grants, privileges, roles and profiles.

• Designing and developing SQL procedures, query performance tuning.

• Performed hot and cold backup and recovery using RMAN and UNIX Scripts

• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem

areas to enhance performance.

• Monitored database and system performance.

• Configured the Event Manager to notify support personnel.

• Worked on application and database security (data access, passwords, network, etc).

• Handled daily production problems/change requests with Oracle.

• Performed daily database administration tasks: User management, Space monitoring, Performance

monitoring and tuning, Alert Log monitoring and backup monitoring.

• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

• Proactively managed the databases; set up alarms for managing any exceptions in day to day management

of the databases; pre-empted and prevented issues, disasters from happening.

• Monitoring tablespace issues, creating tablespaces and adding datafiles.

• Involved in session management and monitored the critical wait events, blocking sessions in the database.

• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading

data from external files into the Oracle database.

• Tuning test and production database by altering the parameters.

• Export and Import of database objects to copy from one database to another database.

• Investigating suspicious database activity using Auditing.

• Involved in query optimization and using rule based optimizers and cost based optimizers.

• Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 9i, Window NT/2000/2003, Linux, Unix, Oracle Enterprise Manager, MS SQL Server

7/2000, RDBMS, VERITAS Net backup, PL/SQL, TOAD 7.5, Shell Scripting, HTML, Stored Procedures,

Triggers.

Bank of Maharashtra, Hyderabad, India

PL/SQL Developer, Oracle DBA

(Mar ’05 – May ’07)

Bank of Maharashtra ensures quick and efficient response to customer expectations. It is a vibrant, forward looking,

techno-savvy, customer centric bank serving diverse sections of the society, enhancing shareholders' and employees'

value while moving towards global presence.

Responsibilities:

• Installed and Configured Oracle 9i Software.

• Worked on Oracle 9i OEM for regular database management.

• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks

• Created different views as per the business needs

• Created materialized views and snapshots for high end application usage.

• Created and used different types of sequences and indexes.

• Planning, Installation and Configuration of Oracle 9i on Sun Solaris and Windows 2000 Server.

• Performance tuning of database using stats pack reports.

• Backup and Recovery operations over all databases, ensuring 100% recoverability using RMAN.

• Wrote control files for input to SQL*Loader utilities for loading data from external files into the Oracle

database.

• Created Table space, Data files, Indexes and monitoring them.

• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema

objects in Oracle.

• Understanding business data relation ships

• Prepared documents and loaded on to knowledge base portal of the company.

Environment: Oracle 9i, Windows (NT/2000), Sun Solaris, TOAD, PL/SQL, SQL*PLUS, Explain Plan,

Statspack etc.

Contact this candidate