Summary:
More than Seven plus years of Oracle Database Administrator experience in database administration, development, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, auditing. Over eight years of IT working experience with a proven background of technical problem solving. A self-motivated, responsible, and reliable team player with a set of very strong technical skills. Experience 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, Standby Database (Data Guard), Replication, Real Application Clusters. Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full backup, incremental and cumulative backup. Experience in using RMAN, Data Pump, Flash-Back recovery and ASM Experience in performance tuning by using tools/utilities like Statspack, TKPROF, Explain plan, AWR. Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas. Expertise in Oracle GoldenGate, GoldenGate Veridata installation, configuration, troubleshooting issues with GG. Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin. Expertise in techniques to design normalized Database, planning for Index for optimized SQL and database tuning in UNIX environment for OLTP. Excellent interpersonal and strong analytical, problem-solving skills. Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service. Exceptional ability to quickly master new concepts and applications. Technical Skills:
Software: SQL, PL/SQL, UNIX Shell Scripting
Databases &Tools:Oracle 9i/10g/11g, RAC, Oracle Enterprise Manager, TOAD, SQL Server 2005 ,Golden Gate
ETL:Informatica, Data Stage, Cognos, SQL*Loader
Web Technologies: XHTML, HTML, CSS, JavaScript, JSP, AJAX, JQuery
Operating Systems:Sun Solaris 2.5/2.6/7/8, HP-UX 10.2/11.0, RHEL 4.x5.x6.x, AIX, Windows
Data modeling tools: Toad data Modeler, Erwin, SQL Developer, Data Modeler
Languages: C, C++, Java, SQL, Pl/SQL
Education / Training / Certification
Master of Sciences from Confidential,University, California, USA Masters of Computer Applications from Confidential,University, India Oracle Certified Associate (OCA) 1Z0-007: Introduction to Oracle9i SQL 1Z0-147: Program with PL/SQL 1Z0-052: OracleDatabase11g: Administration I Professional Experience
Confidential,Georgia Jan’08 to till date
Oracle DBA
Working as Oracle DBA and providing Database Administration production support. Involved in database sizing, installing database software, patching, upgrading, import –export, backups, performance tuning, database creation etc., for development, QA, UAT and Production environments.
Responsibilities:
Installation and Maintenance of stand by database Monitoring of database for growth and performance Creating ASM instance/maintaining ASM (adding, dropping disk to disk group etc). Installed, configured and administered RAC with ASM Migrated databases from file system to 11g ASM using RMAN restore Performed day-to-day DBA jobs for managing Prod/Development databases like Export/ Import, moving table spaces, rebuilding indexes, synonyms, partitioning tables, etc. Performed database cloning to setup test and development database Used RMAN for backup and recovery. Performed backup validations using RMAN Worked on sizing the SGA, db buffers, shared SQL area, log buffer for better performance Diagnose and troubleshoot Database problems and failures Hands on experience in maintaining OEM Grid Control Using AWR for database performance statistics Generating ADDM reports for tuning Provided 24/7 support during production deploy and post production monitoring process. Database and SQL tuning to improve performance of loads. Experience in database Replication, Transformations and Verifications in GOLDEN GATE. Performed unidirectional replication from source to target database using GOLDEN GATE. Implemented table partitioning to improve performance and data management. Experiencing Data warehousing and ETL. Responsible for setting and managing user accounts, Granting required privileges to users. Environments: Oracle 11g/10g, OEM, RAC, GoldenGate Sun Solaris, AIX, Linux (RHEL), windows XP, Erwin 4.0, TOAD
Confidential,CA. Jan’05 to Dec’07
Oracle DBA
Consultant at Cisco systems Inc. California to work as Oracle DBA on new implementation of Quote to Cash Web based Application.
Responsibilities:
Carrying out upgrades of databases using the Oracle Installer. Applying patches to Oracle using Installer. Hands on experience with issues related to RAC, ASM disk groups Performed Backup and Recovery Activities using RMAN Created the catalog and registered the databases for RMAN Worked on Flashback feature on standalone databases and standby databases for read/write testing Refreshing development database from production using export/import. Creating Tablespaces and planning the location of data, index and rollback Tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture. Analyzing tables on a regular basis for the oracle optimizer Database backups and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases. Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN Management of schemas, objects partitioning the tables & indexes. Responsible for setting and managing user accounts, Granting required privileges to Defining and Implementation of backup and recovery strategies Perform other regular DBA activities including space management and performance monitoring. Environments: Oracle 10g,/8i, OEM Sun Solaris, AIX, Linux (RHEL), windows XP, Erwin 4.0, TOAD
Confidential,NY Feb’04 to Nov’04
Oracle DBA
Worked as Oracle DBA and providing technical support to system analysts, and end clients on technical issues. Involved in installation, performance tuning, upgrading, maintenance and trouble shooting.
Responsibilities:
Applied patches to the existing versions of Oracle. Worked with Tables, Tablespaces, Data file sizing and reorganization, Index rebuild, data loading, Analyzing objects, data modeling, and managing rollback segments using OEM. Provided Oracle DBA support included oracle database installation, upgrades, instance configuration, tuning, schema maintenance, troubleshooting and production monitoring. Implemented Hot, Cold and Logical backup plans. Identified poorly performing queries using explain plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace and SQL Tuning Advisor. Managed the Schemas by creating various objects like tables, views, indexes and maintaining data integrity using constraints. Implemented “Stored Procedures and Triggers” based on business plans using PL/SQL. Environments: Oracle 9i,/8i, OEM, Sun Solaris, AIX, Linux (RHEL), windows XP, Erwin 4.0, TOAD
Confidential,India Jul’03 – Dec’03
Jr. Oracle DBA
Worked Oracle DBA in management Information and advisory System for an administrative office of the bank administration and monitoring for several branches.
Responsibilities:
Installed and configured Oracle 8i/9i on windows 2000 server environments. Monitored backups, applying patches, exporting and importing data between the instances, creating database links, creating users, maintaining rollback segments, adding table spaces and data files. Creation of new oracle user accounts. Extensively used Explain Plan, Tkprof and Statspack. Created database objects like tables, views, indexes and partitions. Tuned and configured sizing, performance monitoring and tuning the databases, database objects and custom applications. Installed and configured Net8, client8 and Oracle Enterprise Manager on hosts and console. Uploaded the data between the databases using export and import utilities. Loaded the data from legacy systems to databases using SQL * Loader Wrote small shell scripts for automating jobs. Environments: Oracle 8i/9i, Enterprise Manager, Windows 2000 server, TOAD, SQL*PLUS
Confidential,India. Jan’03– Jun’03
Oracle Backend Developer
The project aims to develop a reservation system for an airline company, which operates its flights around the world. It is basically intranet Project. The project had passenger service system, cargo service system and flight maintenance system etc.
Responsibilities:
Written pl/sql stored procedures, shell scripts for populating data in tables as a part of release. Involved in reorganizing the tables and rebuilding the indexes that are highly fragmented to improve the performance. Table fragmentation tuning, partitioning the existing large tables. Worked on pl/sql procedures to validate Items for open Item interface in Inventory according Business Requirements. Developed PL/SQL packages for validating the data for invoice process. Environments: Oracle 9i, Red Hat Linux 5.1, Informatica Power Center 5.1.1, TOAD, SQL developer
Privacy Policy
