Oracle Maintenance
Resume:
Sai Reddy.
***************@*****.***
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