Oracle Sql
Resume:
Abhiram Mallarapu
Oracle DBA
SUMMARY
• Over eight years of experience in the IT industry involving Production Database Administration.
• Oracle Database Administration experience in variety of different environments like HP-UX, SUN
SOLARIS, AIX, RedHat Linux and Windows.
• Proficient in database administration, production support, installation, configuration, upgrades,
patches, performance tuning, backup and recovery, cloning, space management, database security,
auditing, troubleshooting, Unix shell scripting and documentation.
• Experienced in installing and setting up Oracle 11g, 10g, 9i, 8i databases.
• Planned and implemented high availability solutions using Oracle 10g RAC, Oracle 11g
RAC Standby Database (Oracle Data Guard).
• Good Knowledge of Installation, configuration, Monitoring and maintenance of Oracle Databases,
ASM, CRS cluster ware administration.
• Worked with team to support 24/7 production environments.
• Demonstrated ability to identify root causes of problems, consider both long and short-term impact
of proposed solutions and develop workable solution. Ability to manage multiple project tasks with
changing priorities and tight deadlines.
• Expertise in Oracle performance tuning using STATSPACK, TKPROF, Explain plan.
• Effective troubleshooting of database and performance problems.
• Experience in SQL, PL/SQL.
• Worked with development teams and data administration staff to enhance Database and
application performance.
• Monitoring, identifying areas that need to be improved in the application and database.
• Management of schemas, objects and partitioning the tables, indexes.
• Experience in managing Very Large Oracle Databases (VLDB) which includes OLTP as well
as DSS. Experience in Data warehousing and ETL
• Excellent experience in Partitioning which includes List, Range, Hash and Interval
partitioning.
• Experience in administration of large Oracle databases running in SAN environment, setting up
databases for bank environment.
• Proficient in Logical Database Design, Physical Database Design and Normalization.
• Experience in Data Migrations using oracle export/import, datapump, sqlldr.
• Performed backups and tested crash recoveries using conventional hot & cold backups
and RMAN.
• Proficient in using OEM and RMAN.
• Excellent experience in OLTP/DSS database systems, implementing and managing Very
Large Oracle Databases (VLDB) of size multiple TB. Expertise in data warehousing design and ETL.
• Demonstrated ability to work well with a wide variety of people at various levels, foster
cooperation and collaboration among individuals in the work unit, help team resolve conflicts
constructively and ability and willingness to communicate when help is needed.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of
challenges. Strong listening, interpersonal and analytical skills.
TECHNICAL SKILLS:
Operating Systems HP-UX 11,11i Sun Solaris 8(5.8),9(5.9),10(5.10) AIX 5.2,5.3,6.1,
Red Hat Linux RHEL 4,5,6
RDBMS Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g (RAC)
Languages SQL, PL/SQL, C, PERL, UNIX Shell
Tools RMAN, OEM, SQL*Loader, EXP, IMP, EXPDP, IMPDP, ERWIN, TOAD
Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
Web Tools HTML,XML
Education:
• Bachelor of Technology
PROFESSIONAL EXPERIENCE:
OCIO/OCFO (DC Gov’t) - Washington DC June ’11 – Till Date
Sr. Oracle DBA
Responsibilities:
• 24x7 production support for several mission critical systems which utilize up to 45 Oracle
Production Databases running on Linux/Solaris environment.
• Performed database cloning to setup test and development databases.
• Installation, Configuration and Maintenance of 5 node Oracle 11g RAC databases with ASM
• Upgraded databases from Oracle 9i, 10g to Oracle 11gR2.
• Applied patches to Oracle RDBMS in Development, Test and Production environment
• Converted to Oracle RAC 3 node from Single Instance database using rconfig.
• Cloned/Refreshed Oracle Databases for development and testing.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold backup (user managed and RMAN) plans.
• Setup of recovery catalog for RMAN.
• Performed workload balance by configuring services based on application priority.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using
RMAN and automated RMAN backup using scripts.
• Set up Cronjobs to monitor file systems usage, archive logs and cleaning up of these file systems
periodically.
• Set up local listeners on each node for high availability solutions.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting up and managing user accounts, granting required privileges to users.
• Perform other regular DBA activities including space management and performance
monitoring.
• Optimization and tuning using TRACE FILE, TKPROF, EXPLAIN PLAN, AWR, ADDM.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches,
Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application
Tuning, Security Administration, Data Warehousing, Data Guard, Real Application Clusters.
Environment: Oracle Server11g RAC, 10g RAC/9i, SQL, PL/SQL, HP-UX, Sun Solaris, OEM, SQL
Plus, SQL Developer
AMEX - Phoenix, AZ October ’10 – May ’2011
Oracle DBA
Responsibilities:
• As a part of a team of seven DBAs, I am responsible for the support of a life cycle development
systems running oracle 10g and 11g on windows and unix based environment.
• 24X7 Production database administration, support and monitoring to ensure a proactive problem
recognition and resolution of database issues.
• Install, Configure, monitor, administer, upgrade, troubleshoot and patch 10G/11G Oracle database
in Multi Node RAC Unix in a Development/Production Environment.
• Used RMAN to Backup/Recover Production/UAT/Training/Dev databases regularly.
• Proactive database monitoring using 10g grid monitoring tool.
• Assist the application developers in testing and debugging new programs to ensure
compatibility with existing server technologies.
• Performed oracle administration for 6 RAC clusters. Duties include checking node health,
resizing disks when needed, workload partitioning by creating services with preferred nodes
and available nodes, schema creation, mirroring OCR files.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Fix data errors from the urgent tickets created by users/help desk.
• Performed database full, incremental, differential backups using RMAN.
• Implemented Dataguard technology and configured switchover and failover with physical
standby database on UNIX environment
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 10.2.0.4
• Applied patches to Oracle Databases and Oracle Applications.
• Involved in meetings with the users and gathered necessary requirements for creation of
databases.
• Implemented password verify function and stored procedure for user profiles and safeguarded
database privileges and security
• Identified causes for the slow performance of cluster database and worked proactively to
do the necessary changes,created a snapshot of database statistics for future reference.
• Responsible for optimizing the queries and application tuning.
• Resolved database incidents to ensure database stability and availability.
• Created External Tables to access the data in external sources(flat files, LOB data)
• Moved the data (schemas, tables) among the development databases using datapump utility.
• Registered databases to RMAN repository for Linux and Windows servers.
• Code review to ensure that the new customizations were developed to meet requirements.
• Effectively communicate and assisted offshore application developers with various requests.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Responsible for setting and managing user accounts, profiles, auditing user sessions.
• Generated and analyzed AWR and ADDM report for system performance enhancement.
• Code Promotions to UAT & Production environments
Environment: Oracle Server 11g, 10g RAC /9i, SQL, PL/SQL, AIX, Sun Solaris, Red Hat
Linux, SQL Plus, Toad.
AON Corporation – Atlanta, GA January ’09 – September ’10
Oracle DBA
Responsibilities:
• Primary responsibility to support several Production, Test and Development databases (10g, 9i)
running on HP-UX platform
• Configured the database for warehouse implementation, cloned schemas and databases
using RMAN.
• Applied PSU/CPU security patches to 19+ databases on six Dev, seven Test and six Prod
database environments.
• Deployed Profiles, Password Functions and DB hardening/lockdown process to database
accounts & environment to comply with enhanced security standards dictated under Baseline Control
Standards, audit vendor standards.
• Run Sql tuning set's exercise to identify any index recommendations to be implemented
• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql
executions and better execution plan selection (used v$ views and top to identify the problem sessions)
• Assisted developers in troubleshooting sql execution plan/performance using event 10046 setting
at the session level during performance tuning exercises. Rediscover new components created on the
database servers for monitoring
• Co-ordinate tasks with offshore DBA's for database work (running audit scripts, tasks assigned
directly by clients, etc.
• Recovered database on Windows platform due to disk and hardware problems
• Restored production databases for DR (Disaster recovery) exercise on Sungard servers using
previous hot backups and RMAN scripts. This included planning and execution of recovery with
assistance from Sys Admin and Storage administrators.
• Tuned database using statspack reports, creating new indexes, computing stats on tables - to
decrease the physical i/o(3k/sec to < 100/sec) and logical i/o (8k down to 3k)per second on sql
statement executions .
• Was awarded Geek of the Week award for working with technical teams, vendor and recovering
the production database
Environment: Oracle Server 10g/9i, SQL, PL/SQL, SQL Plus, AIX, HP-UX
Computer Associates – Hyderabad, India March ’06- November ’08
Oracle DBA
Responsibilities:
• Provided support for all the oracle databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per
user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recovery.
• Responsible for optimizing the queries and application tuning.
• Worked with Sys admins, storage and backup admins to setup the oracle environment, backup
process using RMAN
• Run AWR and statspack reports to identify sql with large buffergets and physical reads per
execution.
• Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql
executions and better execution plan selection
• Upgraded and patched databases (8.0.5, 8.1.6, 8.1.7.0 TO 8.1.7.x, 9.2.0.x) on Production, Test
and Development boxes
• Implement Hot, Cold and Logical backup plans.
• Created and maintained RMAN catalog on production environment
• Analyze, design and implementation of the Database for e-commerce system.
• Migrated data using export/import and loaded delimited flat file data using sql loader.
• Proactive database monitoring using automated scripts based on v$ views.
• Frequent Database audits to ensure the SOX standards were not violated.
• Developer Environments setup using database cloning and refresh procedures.
Environment: Oracle Server 8i, 9i, SQL, PL/SQL, SQL plus, Sun Solaris, Windows 2002.
Contact this candidate