SUMMARY:

• Over 12 year experience (including 5+ USA experience) of ORACLE DBA and Performance & Tuning Analyst - supported Non-RAC & RAC databases of PROD, DEV and TEST environment.
• Experience in database administration related tasks such as:
• Administering, managing RAC & NON-RAC DB instances, ASM instances, Oracle S/W and database installation and configuration, upgrades, migrations, cloning and patch management
• Creating and managing database objects: tablespaces, tables, indexes, views, columns, synonyms, sequences, database links, constraints etc.
• Management tasks such as memory management (AMM, AMMS), user accounts & password, security policies & encryption/decryption, space & storage management (ASSM, ASM), networking, data dictionary authentications; access controls through privileges, roles, profiles; and data accountability through auditing and RAC/Non-RAC database Health checks.
• Installation and management of Grid Control and Agent - OEM practices.
• Data moves using export and import utility; transportable tablespace/databases, SQL*Loader, External tables, UTL FILE and PL/SQL scripts
• RMAN utility for data refreshes; Incremental/full data back-up, restores and recoveries
• Building and managing STANDBY databases using Dataguard and ADG.
• Flashback recovery solutions, Partitioning/Sub-partitioning;
• Experience in using database utilities or tools such as OEM, Grid/Agent Control, and Grid infrastructure, DBCA, DBUA, VIPCA, NETCA / NEAT and TOAD, Flashback Recovery.
• GOLDENGATE (OGG) as real time replication solution - OGG installation, managing, configuring (classic capture, integrated capture), monitoring, performance tuning and troubleshoot; creating and managing various replication topologies such as uni-directional and bi-directional. Live reporting (initial direct load, with/without data-pump),
• Experience in performance and tuning related tasks such as
• Generating High Top SQL resource consumption metrics such as Explain Plan, AWR, ADDM, ASH, Trace files etc. Interpreting and analyzing the metrics and providing solutions.
• Gathering extended statistics (histograms), column and expression level statistics
• Initiating SQL traces at query level and Application level; session level and system level - using trace events 10053, 10046, 1775, 4020; reviewing, analyzing and providing solutions.
• Analyzing wait events and optimizer internals and providing solutions.
• SQL Tuning, analyzing query transformation, minimizing joins in order to improve the query execution efficiency and optimization.
• Performance and regression solutions by recommending SQL plan management (SPM), SQL profiles, OUTLINES, new indexes, partitions on table/index level, LOB and materialized VIEWS
• Running SQL advisors such as SQL Access Advisor, SQL Tuning Advisor, SQL Performance Analyzer and SQL Tuning set, SQL Monitor, SQL TRACE, DBMS STATS.
• Performance analysis on Large Volume DBs (VLDB), LOBs and Partition/Sub-partition, Parallelism and providing solutions.
• Preparing action plan to implement SPM, SQL profile, new indexes, partitions and LOBs.
• Good understanding in application design, systems analysis and prototype and OOPs design; creating and maintaining conceptual design, logical and physical models, database modeling.
• Experience in Linux/Unix shell scripts, jobs schedules using CRONTAB and Oracle utilities
• Knowledge in IT practices such as: Sarbanes-Oxley (S-OX), IT Audit and IT control in enforcing database securities; and ILM (INFORMATION LIFE CYCLE MANAGEMENT); understanding on hardware storage devices: SAN/NAS, EMC middle-range storage systems (VMAX, DMX, CLARiiON);
• Ability to work independently, with minimal supervision.
• Excellent communication and interpersonal skills.
• Ability to work on multiple projects simultaneously.

TECHNICAL SKILLS:

Primary Skills: Oracle DBA, PERFORMANCE & TUNING, SQL and PL/SQL

OS/Platform: HP-UX/SOLORIS/AIX UNIX, SUSE & RH-Linux, Windows 2007/2000/NT/XP, VMWare

Databases & Tools: Oracle 11g/10g/9i/8i, SQL Server, MySQL RAC, CRS, ASM, AWR, ADDM, ASH, TNS, RMAN, Data Guard, OEM Grid control, Streams, GoldenGate 11.1 SQL*Plus, iSQL*Plus, PL/SQL stored procedures, Data Pump, Flashback Recovery, SQL*Loader, Oracle External Tables, Export/Import, LoadPSP Data Modeling, Data warehousing & Marts, ETL, OLAP, DBCA, Database Upgrade Assistant, Oracle Net Manager TKProof, SQL* Trace, TOAD, Explain Plan, Stats pack, AWR

Data Modeling & Strategies: UML, ERD, DFD, Normalization & OFA, ERWIN, Toad, RATIONAL ROSE, DISASTER RECOVERY (DR PLANNING), ILM (INFORMATION LIFE CYCLE MANAGEMENT)

Scheduling Tools: CRONTAB, DBMS SCHEDULER()

Application: COBOL, JAVA, C/C++, FORMS 6.0, VB6 Java platform, Visual Basic, Web Technologies (PHP, JS, XML, AJAX, .NET), Websphere

Reporting Tools: Reports 6.0, COGNOS 8 Suite

Network Tools: NEAT (linux),Network Configuration Assistant (oracle)

Testing & other IDE tools: QC, QTP, WS-FTP, CuteFTP, Ms-WORD, Ms-Excel

PROFESSIONAL EXPERIENCE:

Confidential, Urbandale, IA

Sr. Oracle Database Administrator

Responsibilities:

• Performing the major role as “Performance & Tuning Analyst” and role of “Application DBA”.
• Supporting production, development and testing databases.
• My regular typical tasks includes,
• Collecting intense resource consumption SQLs (problematic SQLs) from PRODUCTION. We do use SQL resource consumption metrics such as AWR report, our own scripts to catch the problematic queries. Analyzing those queries and providing reactive and proactive solutions. .
• Collecting SQLs from DEVLOPMENT and analyzing and providing proactive solutions.
• Receiving the requests from DATA ARCHITECTS/SYSTEM ARCHITECTS to analyze certain Database situations such as PARITIONS, PARALLELISM, LOB, Long running queries, INDEX/TABLESPACE Fragmentations; and analyzing and providing solutions.
• In order to review and analyzing the requests, I do the following tasks frequently until we found the expected solution.
• I either request and/or generate performance and tuning related metrics such as EXPLAIN PLAN, AWR, ADDM. We do interpret and provide solutions based on the metric
• I do execute the advisors tools such as SQL Tuning Advisor, SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Set and Advisors to generate tuning recommendations; reviewing, analyzing and providing solutions.
• Setting Traces such as 10053, 10046, 1775 at application level and statement level to create trace logs; reviewing, analyzing and providing solutions.
• Monitoring the process of query execution using SQL*Monitor; reviewing, analyzing and providing solutions.
• Gathering Extending Statistics and COLUMN level statistics and finding solutions to fix the bottlenecks to improve database and query performance.
• Interacting with SYSTEM ARCHITECTS, DATABASE ARCHITECTS, DEVEOPMENT to discuss about the implementation of solutions.
• Solutions may include:
• Recommends simplifying query by removing redundant joins and unnecessary joins; use/remove of HINTS in the queries to improve the query performance; and recommending new INDEXES, PARTITIONING, SUBPARTITIONS, PARALLELISM.
• Recommends implementing solutions such as SQL Profiles, OUTLINE, SPM (SQL Plan Management) as solution for performance regression.
• Preparing ACTION PLANS to implement technical solutions in PROD and DEV environment.
• Beside above tasks, I involved and supported the following areas -
• Administering, managing RAC & NON-RAC DB instances, ASM instances; software maintenance such as Oracle S/W and database installation, configuration maintenance, upgrades, migrations, patch management, cloning databases and health checks;
• Creating and managing database objects such as user/passwords, schemas, tablespaces, tables, indexes, views, columns, synonyms, sequences, database links, constraints etc.
• Grid Control and Agent management - OEM practices
• Replication databases using Dataguard and Goldengate (classic capture & integrated capture) - Installation, Configuration, performance troubleshoots & maintenance
• Installation, configuration, managing, monitoring and troubleshoot of Oracle GOLDENGATE in source and target systems. Performing planning, design, development and implementing unidirectional and bidirectional replications.
• Data moves using export and import utility; Transportable Tablespace/Databases and RMAN utility for data refreshes and data updates.
• Preparing ACTION PLANS for implementing Flashback recovery solutions, Partitioning/Sub-partitioning; other ETL tasks using SQL*Loader, External Tables, UTL FILE and PL/SQL scripts.
• Writing shell scripts (UNIX/LINUX); job schedules using CRONTAB and Oracle utilities.

Environment: Tools/Utilities used: OEM (Grid/Agent Control), DBCA, DBUA, VIPCA, NETCA/ NEAT and TOAD, Flash/Flashback Recovery, RMAN utility, Oracle GOLDEN GATE 11, RAC, ASM, OCR, SQL*Plus, iSQL*Plus, PL/SQL stored procedures, OEM, DB Console, Data guard, Flashback, SQL*Loader, Oracle External Tables, Export/Import, Data Modeling, AWR, ADDM, ASH, Explain Plans, TKProof, SQL* Trace, TOAD, Cronjob (unix), JAVA, J2EE,, Ms-WORD, Ms-Excel, ERWIN, Ms-Visio, UNIX SOLORIS, AIX, RH-LINUX

Confidential, Tulsa, OK

Oracle Database Administrator

Responsibilities:

• Provided database solutions to the production and development databases
• Provided general database administration tasks such as creating, managing, configuring RAC and Non-RAC databases; ASM storage environments,
• Worked with application developers, data architects and business analysts in order to provide database solutions like creating and managing logical and physical models; changing table structure, column structures and schema structures; executing SQL scripts in PROD.
• Provided DB services such as creating and managing tablespaces, tables, columns, constraints, indexes, views, sequences, db links and synonyms etc..
• Managed user accounts, password management, data security through encrypt/decrypt, data accountability through auditing; and access controls through privileges, roles and profiles; etc.
• Provided replication solutions using Data Guard and DG/Goldengate
• Data move from source to target system (database/system) using DATAPUMP, IMPORT/ EXPORT.
• Performed and monitoring backup strategies and plans - taking cold, hot and logical backups; and full and incremental backup management using RMAN
• Performed monitoring database, analyzing the database changes trends and providing solutions.
• Provided Performance and SQL tuning solutions. Used tools: AWR, ADDM, ASH, Explain Plan, Auto Trace, Trace files 10053, 10046 trace files.
• Installation, configuration, managing, monitoring and troubleshoot of Oracle GOLDEN GATE 11.1 software in source and target systems. Performing planning, design, development and implementing unidirectional and bidirectional replications.
• Performed initial direct loads, change synchronization and DDL synchronization.
• Provided support to Business Applications (ERP, E-Business, Oracle Application Server, SOA) such as writing PL/SQL scripts, packages, stored procedures, triggers, functions and constraints.
• Shell scripts in UNIX/LINUX and scheduling in CRONTTAB and DBMS SCHEDULER() for periodical runs to check the status.
• Documented policies and procedures for each project including recovery in case of disaster using procedures, Mentored the users on applications and interfaces.

Environment: ORACLE 11G/10G/9i, Oracle GOLDEN GATE 11.1, RAC, ASM, OCR, SQL*Plus, iSQL*Plus, PL/SQL stored procedures, OEM, DB Console, Data guard, Data Pump, Flashback, GoldenGate 11.1, SQL*Loader, Oracle External Tables, Export/Import, Data Modeling, OEM Data grid control 10g, RMAN, DBCA, DBUA, NEAT, NETCA, Ms Access, AWR, ADDM, ASH, TKProof, SQL* Trace, TOAD, Explain Plan, Cronjob (unix), JAVA, J2EE, Ms-WORD, Ms-Excel, ERWIN, Ms-Visio, UNIX SOLORIS, AIX, RH-LINUX

Confidential

Sr. Database Administrator

Responsibilities:

• Performed database administration and system analysis and design.
• Supported and coordinated many migration, implementation and maintenance project.
• Performed System Administration such as installing, configuring and managing Operating systems such as Windows, Linux and UNIX; and networking administration - OS level and application level.
• General database administration (60%) such as creating and managing database objects such as tablespaces, tables, indexes, views, sequences, db links and synonyms etc.
• Performed Database Analysis, Modeling and Design including Capacity planning of system storage and application growth for the projects.
• Involved in application development (40%) such as writing PL/SQL SCRIPTS, PSP SCRIPTS, UNIX SHELL SCRIPTS for automatic querying, report generation etc.
• Installing, Configuring and Tuning the Oracle Database. Upgrading Versions and patches. Based on requirement, cloning (replicate or duplicate) databases from production to Testing and Development.
• Monitoring logs and databases using SQL scripts and UNIX/LINUX shell scripts and scheduling in CRONTTAB and DBMS JOB() for regular and continuous monitoring.
• Providing data protection by managing user accounts/passwords; data security through encryption & complex password management; data accountability through auditing; and access controls through privileges, roles and profiles; etc.
• Taking regular cold, hot and logical backups; and full and incremental backups using RMAN
• Involved in Major Conversion project from Legacy application (COBOL, dBASE and VB6) to Oracle Application. We have done conversion successfully manually.
• Performed data capturing, data transforming, data conversion, data load and extracts using SQL*Loader, LOADPSP(), EXPORT/IMPORT and PL/SQL scripts and creating, managing data Marts
• Performance tuning for overall database performance, using such tools as Statspack, TKProf, Traces, TOAD to determine I/O bottlenecks and improve performance.
• Worked closely with Customer and Application development team to provide database support
• Monitored database system daily for runaway queries to find abnormalities
• Documented policies and procedures for each project including recovery in case of disaster using procedures, Mentored the users on applications and interfaces.

Environment: ORACLE 9i/8i, SQL*Plus, PL/SQL stored procedures, SQL*Loader, Export/Import, LoadPSP Data Modeling, ERWIN, ETL, OLAP, DBCA, Oracle Net Manager, TKProof, SQL* Trace, TOAD, Explain Plan, Cronjob (unix), COBOL, FOXPRO, DBASE, JAVA, FORMS 6.0, VB6 Java platform, Visual Basic, Web Technologies (ORACLE PSP/PHP, JS, XML, AJAX, ASP.NET), QC, QTP, WS-FTP, CuteFTP, Ms-WORD, Ms-Excel, SUN SOLORIS UNIX/ RED HAT & SUSE LINUX, Kornshell and SQL scripts.