Sravan Oracledba.docx

Pasumarti Sravan

[email protected] 816-585-7829 SUMMARY

✓ Over 8 years of experience as core DBA in database design and administration of Oracle 9i,10g,11g and 12c in development, integration, staging and production environments on Unix (Sun Solaris, Linux) and Windows servers. ✓ Experience in Installing and Configuring RAC with ASM on 4 node UNIX RAC environment for high availability databases. ✓ Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods. ✓ Automated common tasks using CRON including: Backups, exports and imports, archiving old records and verification of such processes. ✓ Good Experience in Hot and Cold Backups, and Cloning of Databases. ✓ Experience in using oracle packages such as DBMS_PROFILER, DBMS_SQL, DBMS_DATAPUMP, DBMS_MVIEW, DBMS_SHARED_POOL, DBMS_SCHEDULER, DBMS_JOB, DBMS_STATS and UTL_FILE. ✓ Experience in Upgrade and Migration of oracle database to higher version and installing patches. ✓ Experience in writing shell scripts to check to the Status, Space Management and Performance of Database. ✓ Extensively used the Grid Control for maintaining many databases together on separate servers. ✓ Used OEM,TOAD and DBArtisan for Database Monitoring and Performance Tuning. ✓ Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). ✓ Experience in Upgrade and Migration of oracle database to higher version installing patches and other platforms without/with using Oracle Data Migration Assistant (DBMA) and Oracle Data Upgrade Assistant (DBUA). ✓ Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data Warehouse. ✓ Knowledge of Veritas Cluster Environment, SAN storage systems, RAID, Logical Volume Manger . ✓ Experience in extracting, transforming and loading data from other databases and text files using SQL*Loader utility. ✓ Experience with Database SQL tuning and query optimization tools like TKPROF, SQL Trace, Explain Plan and STATSPACK. ✓ Experienced in oracle support processes and technical requests through oracle Metalink and other support Procedures ✓ Experience in creating Partitions on the Tables and Indexes in order to improve performance.

TECHNICAL SKILLS

Languages RDBMS Tools Utilities Operating Systems

SQL, PL/SQL, Shell Programming, C,C++, HTML Oracle 9i, 10g, 11g,12c Oracle Enterprise Manager/Grid Control, TOAD 8.6/8.5/7.6,SQL Developer, FSecure Client, Humming Bird, Smart FTP, Cute FTP, Putty, Mobaxterm SQL Loader, Export / Import, Data Pump, TKPROF, Statspack UNIX, Sun Solaris 5.6/5.8/5.9/10, Windows 95/98/2000, Windows XP, HP-UX 10/11i, RED HAT LINUX 3.x/4.x/5.x

CERTIFICATIONS

Oracle Certified Associate (OCA) ✓ Oracle Database 11g: SQL Fundamentals I ✓ Oracle Database 11g:Administration I PROFESSIONAL EXPERIENCE

Verizon Wireless,

June 2012 - Till date

Warren, NJ Senior Oracle DBA ROLES & RESPONSIBILITY

✓ Team member of CustomerCare support, was responsible for Development , Production and reporting database Support . ✓ Oracle 10g/11g RAC installation and Configuration. ✓ Troubleshoot database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). ✓ Created profiles, functions related to SOX compliance in prod environment and generate reports. ✓ .Implemented active data guard from VCS to ASM for 11g 3 node RAC environment. ✓ Setup RMAN catalog repository DB to store backup details of enterprise databases. ✓ Upgraded 5 node RAC database from 10.2.0.4 to 11.2.0.3. ✓ Hands on 12c RAC installation. ✓ Involved in cross platform database migration as part of tech refresh project. ✓ Expertise in shareplex replication tool. ✓ Performed RAC installation, configurations, patches, and upgrades. ✓ Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement ✓ Extensive experience in RMAN recovery in RAC and stand alone databases. ✓ Worked extensively on Performance tuning of Queries by maintaining Aggregates,

Compression, partition, indexing and use of Statistics. ✓ Developed UNIX shell scripts (Korn/Bourne) for daily maintenance tasks.

✓ Created and managed users, roles and profiles, audited and monitored databases and user access and provided the necessary security to the database. ✓ Implemented db level users, security, etc. in development, UAT and production environments ✓ Served as Oracle DBA in a 24x7 Production environment managing several Database instances. ✓ Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes. Environment Oracle 10g/11g, SUN Solaris 5.9, Red Hat Linux 4.2, ERWIN 7.3,DBartisan 8.5.5, OEM, Data Guard, RMAN, Exp/Imp, Data pump, Putty, Oracle Client 10.2

State Street Corporation Boston, Massachusetts Oracle DBA ROLES & RESPONSIBILITY:

May 2011-May2012

✓ Oracle 9i/10g installation and Configuration and Sybase support. ✓ Exposed to Real Application Clusters (RAC) on Oracle 10g using Automatic Storage Management (ASM). ✓ Deployed OEM agents on multiple oracle environments. ✓ Troubleshoot database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). ✓ Installation and configuration of Real Application Clusters (RAC) running on 2 node clusters. ✓ Created Physical Standby database as a part of DR planning, also involved in creating the Logical Standby database for the reporting. ✓ Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods. ✓ Used UNIX shell programs and Cron jobs for automating the process of refresh of data periodically. ✓ Upgraded and patched Oracle binaries in the non-prod and prod environments. ✓ Monitoring day-to-day Process for different Data Loads and resolving Issues. ✓ Sybase support,maintenance,backup and data loads. ✓ Assign ticket to offshore DBA according to availability of resources, skill sets and priority of works ✓ Served as Oracle DBA in a 24x7 Production environment managing several Database instances. Environment Oracle 9i/10g, Sybase,SUN Solaris 5.6/10, HP-UX 10/11i,HP 9000 Server, ERWIN 4.0,TOAD 8.5, OEM, Data Guard, RMAN, Exp/Imp, Data pump, Veritas Cluster Environment, Smart FTP.

National Association of Insurance Commissioners Kansas City, MO

Jan 2010- May 2011

Oracle DBA ROLES & RESPONSIBILITY

✓ ✓ ✓ ✓ ✓

Involved in designing OLTP databases and designing schemas. Exposed to Real Application Clusters (RAC) on Oracle 10g with (ASM). Exposed to complex Standby databases and Data Guard for disaster recovery. Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting. Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager Grid Control, TOAD to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts. Used import/export utility and Datapump utility to transfer data. Used UNIX shell programs and Cron jobs for automating the process of refresh of data periodically. Upgraded database from 10.0.1.2 to 10.1.0.5 on Sun Solaris using DBUA.

✓ ✓ ✓ ✓ Monitoring the alert log file for database alerts and errors. ✓ Created database objects, managed partitioned tables, managed table spaces. ✓ Carried out Performance optimization and Query tuning using Statspack, Tkprof and OEM. ✓ Database performance tuning using (v$ tables, STATSPACK, TKPROF, OEM). ✓ Involved in the designing of databases and developed the ER Diagrams with ERWIN. ✓ Worked with developers in a team environment to support their activities. Environment

Oracle 10g, SUN OS 5.8/5.9, Red hat Linux AS 2.1/3.0 UNIX, PL/SQL, SQL*PLUS, TOAD 7.6 ERWIN 3.0, Cute FTP.

Cohen and Steers Manhattan, NY Oracle DBA

Apr 2008 – Jan 2010

ROLES & RESPONSIBILITY

 Responsible for administration and supporting Oracle 11g and 10g databases.  Upgraded the databases from Oracle 10.2.0.4 to 11.2 and implemented the dataguard on 11g databases. Installed the RAC on 10gR2 and 11g databases.  Responsible for creating the disk groups and adding the diskgroups for datafiles in ASM for RAC env which resides on SAN storage.  Setting and troubleshooting of oracle listener, network connection, user security and administration. Tuning for optimum performance like SQL tuning.  Responsible for user management like creating users, creating roles, granting roles and privileges and creating profiles and granting them as per need.  Worked on import/export, import/export Data Pump and SQL- loader and also worked with RMAN backup and recovery.  Extensively used 10g new feature automatic SGA tuning by setting up the sga_target and tested the new features of recovery using RMAN in 11g.  Responsible for administrating the space management like adding the datafiles and creating the new tablespaces and also requesting the system admins to add the space.  Set up cron jobs to monitor file systems usage, archive logs, backup s and periodically cleanup these file systems, and also monitor RMAN hot backup scripts.  Tested the standby databases during switchover and failover scenarios and also tested the flashback feature on 11g dataguard and also worked on flash back recovery in recovering the tables, tablespaces, datablocks etc.  Experienced in changing the modes of the databases and also maintaining or changing the time lag for a database in dataguard.  Performed Database and SQL tuning by using various Tools like TOAD, STATSPACK, TKPROF, and EXPLAIN PLAN, AWR, and optimizer hints and also worked on undo retention.  Documented the upgradation, installation of dataguard and necessary steps to follow for database recovery using RMAN. Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, RMAN, STATSPACK, Data Guard, Shell Scripts, Grid Control, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, HP-UX 11.0.

Safeguard Properties LLC Valley View, OH Oracle DBA

Feb 2006 – Mar 2008

ROLES & RESPONSIBILITY

 Installing Oracle 9i/10g RAC on AIX and RHEL creating database for production, development and test environments.  Assisting developers and 24*7 production database supports.  Backup of database Logical and Physical (hot and cold) procedures and also using RMAN, Complete and incomplete recovery of database  Migration of database from 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.  Performed migration of database with Export, Import, Data pump and SQL*Loader jobs.  Periodically uploading data from flat files using SQL*Loader  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, Table spaces and rollback segments.

Environment:: HP-UX, Oracle 10g/9i, Windows 2003, RHEL 4.0, Oracle OEM, TOAD, Designer 2000, Erwin, RMAN, ASM, Shareplex, RAC, ASM, ADDM, Data Guard, Shell scripts, Perl Script, HP-UX, Linux, Sun Solaris 10.0, UNIX, IBM-AIX, LPAR.