Professional Profile:

• Highly experienced Oracle Database Administrator with 14 Years of progressive experience in Information Technology
• Expertise includes ADBA, Administration, Performance and Tuning, Installation, Upgrading, Data Guard and RAC

Technical Summary:

• Expertise in Database administration design, development and testing
• Consulting experience with AT T, Wells Fargo, Dr Pepper, Verizon, Hewlett Packard, Procter Gamble, AIA and EMC2
• Strong troubleshooting skills, problem skills, Positive thinking, interpersonal skills, Ability to work independently, Team player with good interpersonal skills
• Databases : 11g/10g/9i,8i/7.3.2, Sybase 11.X, MS SQL Server 7.0/2000/2005/2008
• Database Administration : Oracle DBA, Oracle ADBA, Oracle RAC DBA, Sybase DBA
• Database Tools : OEM, OEM 10g/11g Grid, SQL, PL/SQL, Toad, DBArtesian, Sybase central, SQL developer
• Backup Tools : HP Data Protector, BrightStor ARC serve Backup, IBM Optim tool
• UNIX OS : RHEL Linux 2.6/3/5, AIX, HP-UX 11i, Sun OS 2.6/2.7/2.8/2.9/5.10 Solaris 10
• Windows OS : Windows 2012/2008/2005/2003/2000/N.T/98/95
• Archiving tools : IBM OPTIM and ILM, Amdocs Tiger tool
• Languages : SQL, PL/SQL, Shell Programming, C, Perl scripts
• Tools : ADT Mapper and ADT Script Manager 2.0 CA , Informatica, OWB, Toad 11.5/10/8.5.3
• Modeling Tool : Erwin 3.5/4.1
• ERP : Siebel 6/7.5
• Productivity tools : Microsoft Word, Excel and Power Point
• Other : Developer 2000, Visual Basic 5.0, Power builder, CITRIX, Peregrine Systems 5.1,
• HP Open View Service Desk 4.5, SAN, Networking
• Domain : Bank Mortgage, Telecommunications, Insurance
• Expertise in ADBA Application DBA activities export, import, users, roles, privileges, Versions, Patches, DB Reports, DB Changes, SWP, Repositories, tablespaces, quotas, alert scripts, installation, building and dropping environment
• Expertise in Implementation, Administration, Performance Tuning, disaster recovery and business continuity planning for number of Oracle databases 7/8i/9i/10g/11g on multiple platforms such as UNIX and Windows servers with High Availability HA options like Real Application Cluster RAC , Data Guard DG and Active Data Guard ADG
• Best experience of Planning, configuring, performing upgrades, space monitoring, cloning, trouble shooting TAR support of Oracle DBMS software on various platforms.
• Extensively worked with implementing the oracle database backup using Export/Import, Datapump, Shell scripts, RMAN
• Expert in resolving issues from simple SQL tuning to complex Oracle database issues using Statspack, TKPROF, explain plan, AWR, ADDM that analyzing, evaluating, fact finding, troubleshooting and documenting issues.
• Monitoring Databases using Oracle Grid Control.
• Good working experience of Oracle ASM, Flash Recovery Area FRA , Materialized Replication, Partitioning, SQL Tuning advisor, Segment advisor, SQL Access advisor.
• Experienced in administration of Logical and Physical Standby Databases and applying redo logs to protect enterprise data from failures, disasters and errors using Oracle Data Guard Feature.
• Worked extensively with UNIX O/S like SUN Solaris, HP-UX, Linux Red Hat MS Windows as well.
• Provided root cause analysis and permanent fix of production problems.
• Building best practices OFA .
• Versatile team player with excellent presentation, analytical and inter-personal skills.
• Complex SQL statements are created and restructured for tuning purpose. PL/SQL procedures are created, analyzed and tuned to improve performance. Functions are created.

Professional Experience:

Confidential

Responsibilities:

• Providing day-to-day support and maintenance for key Oracle databases and services of Amdocs applications on production and test environments
• Working on Application platforms on production and lab environments
• Participating in version releases and patches
• Investigating potential problems and issues raised by users
• Participated on an on-call rotation
• Working with other teams to promote changes to production and other environments
• Maintaining database configurations in compliance with established best practices Requirements
• Prepared SQL and PLSQL scripts. Working on Golden Gate
• Strong experience supporting mission critical relational databases. Exceptional troubleshooting and analytical problem-solving skills. Working effectively in high pressure situations
• Prepared shell scripts and automating repetitive administrative tasks
• Working on Oracle partitioning, statistics, export, import, creating tables, copying data, database links, users, roles, privileges, profiles, passwords, schema manager SA, SAREF, REF1 and REF2 for CRM

Confidential

Responsibilities:

• Upgrade of 10g R2 RAC to 11g R2 RAC.
• SR Service Request opened and worked effectively with oracle support.
• 2 OLTP databases are migrated from Oracle10gR2 Solaris RAC 3 node to oracle 11gR2 on Linux RAC 8 node
• AWR report is collected for peak periods of time on database 11g. AWR reports are analyzed. SQL statements are tuned. 11g databases are monitored by OEM grid control Oracle Enterprise Manager .
• Shell scripts and procedures, Functions are created. Shell scripts of RMAN are fixed and modified as per new requirement. Process in OS is gripped in script and stopped double execution of scripts. Shell scripts are created to automate the load processes that run periodically to load the data. PL/SQL stored procedures to load the data from various legacy systems into databases. Functions are created to view data for improving performance. SQL statements are tuned
• Oracle Advanced Security Transparent Data Encryption TDE is implemented for columns and tablespace. TDE wallet management also implemented. EAS web tool info filled using web conference tools
• Space estimated for existing data, archived data and purged data and database growth. Report generated for row counts, size of table, schemas and databases
• Setup the meetings and discuss with business about the scope visibility options for new critical works.
• Track the requirement changes and estimate the development, testing and implementation efforts.
• Open the remedy tickets for any data issues and manage them appropriately. .
• Coordinate with development and testing teams to ensure the application developed efficiently.
• SQL Server: Databases are created. Views are created in databases. Users are created and roles and privileges are assigned. Databases are backed up and restored. Data is restored from SQL server 2005 to 2008 and vice versa.
• Analyzed data and determine similarities. Redundant data identified. Complex queries prepared and ETL processes build and executed. Involved in physical model. Data is normalized as per performance and integrity data.
• Data is loaded from export dump files to databases and then archived.
• IBM Optim connect studio entries are added. Archive files are registered and Data is browsed from archive file using IBM Optim and nav utility. My login tickets are created for Non ATT UIDs and ATT UIDs. Views created in Non ATT UIDs and Grants to ATT UIDs. Indexes created to improve performance of queries. Optim installed on new servers and configured
• Complex SQL statements are created for OLTP and restructured for tuning purpose. PL/SQL procedures are created, analyzed and tuned to improve performance. Functions are created. Provided 24X7 Production support

Confidential

Oracle Performance and Tuning DBA

CORE

• Wells Fargo Home Mortgage is headquartered in Des Moines, Iowa and is the nation's 1 residential mortgage lender.
• Wells Fargo home and consumer finance group offers customers first mortgage loans used to purchase a home or to refinance an existing mortgage. It also services the loans it originates, as well as loans originated by other mortgage lenders or investors. Home mortgage also delivers services to mortgage brokers and correspondent home lenders.

Responsibilities:

Upgrade databases on Virtual machines:

• Binary installation of oracle software is done for various virtual machines by manually.
• Cloning is used for binary installation to save time on various virtual machines.
• 30 Databases are upgraded from 10.2.0.4 and 10.2.0.5 10gR2 to 11.2.0.2 11gR2 for single node. Required patches are applied. Invalid RDBMS components are reinstalled like Oracle XML Database, Oracle Expression Filter, Oracle Rule Manager, JServer JAVA Virtual Machine, and Oracle XDK and Patches are applied for few invalid components.

Upgrade RAC databases:

2 Databases OLTP and Data Warehouse are upgraded from 10.2.0.4 and 10.2.0.5 10gR2 to 11.2.0.2 11gR2 for three nodes on RAC. Oracle Cluster Upgraded 10g ASM to 11gR2. Patches are applied to ASM and Databases

Tuning of SQL statements and Database:

• Application contains 22 screens. Session trace is enabled for some particular screens and SQL Queries are pulled from trace session. Sometimes database session is enabled so lots of SQL queries are pulled from trace file. Extensively tkprof, sql trace are used to pull trace information. AWR reports and ADDR reports are generated for particular time. SQL queries are selected depending upon statistics available of AWR and ADDR recommendations. SQL queries are extracted from: Application screens, AWR, ADDR, Shell scripts. Star schemas are created as per 3NF and de normalization in Large Data warehouse. SQL queries are tuned by: Tuning adviser, Optimizer, ADDR, SQL TRACE, TKPROF, Collecting statistics, Gather statistics explain plan and Explain plan, Creating indexes, Adding Hints, replacing triggers by checked constraints, Rewriting SQL, Changing initialization parameters of database. Tables are partitioned to improve performance of a query.
• Database is tuned by: Initialization parameters of database like sga target, pga aggregate target, optimizer mode, parallel and optimizer . Log files, Temporary tablespace, Undo tablespace, Data files and Index files, Partitioning of tables, Disk I/O. In Oracle 10g, Staspack are evolved into Automatic work load repository AWR .
• Local build: Database Oracle 10g express edition is created in local. Checkout Java builds. Run SVN update for required revision of build is successful and deployment successful. Run configure database command creates user and required tablespaces and privileges. Run express java environment daily build. Start the application server and open local web page.
• Linux: Configured Linux kernel parameters, file systems, shell limits. Shell scripts created,. Databases are monitored using Linux commands SAR, vmstat, top, iostat
• Golden Gate is developed in Development databases.
• Performed monitored backup strategies plans using cold-hot, logical backups, full and incremental backup management using RMAN. Passive and Active Data Guard ADG are created and monitored.

Confidential

Oracle Performance and Tuning DBA

Responsibilities:

Performance and Tuning:

• SQL Queries are tuned using explain plan, AWR report and hit ratios, advice by OEM 10g web grid control. Required indexes are created on tables. Very big tables are partitioned.
• OLTP Database tuned for Disk I/O using distributing key data files, using locally managed tablespaces, using partitions, Using correct extent sizes, exporting and re importing to the table, using UNDO management, by size of redo log file size, number of redo log groups, checkpoint interval, killing problem sessions, optimizing archiving, temporary tablespace, database writers and file systems
• Initialization parameters like sga target, pga aggregate target, optimizer mode are tuned
• OS kernel parameters for database tuned such as shmamax, shmall and network parameters. Physical memory increased as per calculation of utilization

Data guard Standby database:

• By increasing size of redo log file, number of redo log groups Standby database is tuned
• Switch over database from primary to hot standby.
• Second standby database is synchronized with primary. First standby database is synchronized with primary. Data Guard problems are resolved.
• Proposed changes are discussed in database with application team and administrator and EA Organization. Changes applied in Dev, Test and Prod databases.

Confidential

Oracle DBA

IPSM and VDDS

IPSM is a middle tier application at Verizon business that is used by the internal team members to configure the routers and switches on the Verizon Business network. The application deals with a multitude of networks including PIP, IDA, Ethernet etc.

Responsibilities:

• Worked as a team lead and supporting development and production environments and communicating with QA team and off shore team by providing requirements of their needs to complete projects in time.
• Oracle software 9.2.0.1/10.1.0.5/10.2.0.1 installed on Solaris and Redhat Linux platform
• Issues are resolved by involving in configuration and trouble shooting of 10g RAC and standby databases.
• Oracle Critical Patches applied periodically. Served in major installation and created of large 10g databases for multimode RAC configuration of Production, Development and Functional environments. Tnsnames, listener and OEM are configured for cluster and nodes. Databases are created for Web logic Environment.
• OLTP Databases are monitored and troubleshooter using web based OEM. Shell scripts are implemented for day to day activities. Logical backups are taken using expdp and impdp. Backup jobs are scheduled using RMAN.
• Problems of RAC Data guard are resolved
• Relational databases in support of operational applications are designed. Physical database are designed and created. Conducting meeting with developers and DBAs on issues, best practices, and transitions from logical to physical design.
• Generating data movement code, compiles code, execute the code and troubleshoot data movement problems. Data is loaded into staging tables using flat files and tables.
• Creating users and granting permissions. Map flat files, data, and Meta data management. Prepared scheduler scripts and stored procedures. Developed physical database models from logical models
• Performed performance and tuning on SQL Queries and data movement scripts. Created tables, indexes, stored procedures, functions, users and granted permissions. UNIX shell scripts are created. Dynamic SQL is used to facilitate the automatic generation and execution of program statements. SQL scripts are tested on dev database. Schemas are created on dev and test environment. Data is masked for offshore team.
• Security: Data is masked for few columns of tables in a OLTP database. Granting right privileges, roles and implementing case sensitive passwords.
• Statspack are installed and perfstat user is created. Statistics gathered automatically by using DBMS JOB
• In Oracle 10g, Statspack are evolved into Automatic work load repository AWR .
• Migration Sybase to Oracle: Designed and developed table structures in Oracle. Transact-SQL stored procedures and triggers to implement business rules. Data is migrated from Sybase 11.9.2 to oracle 10g RAC database. Stored procedures, triggers and functions are modified to suite of oracle database. UNIX shell scripts are prepared. Worked with development team, offshore team, testing team and production team
• Providing 24X7 Production support

Confidential

Senior Oracle RAC DBA

Data Center

One of the HP prestigious project which is to migrate and consolidate all the data centers Globally in to three Data centers with all the databases to be on 10g and RAC for High Availability and scalability, and easy maintenance and reducing the costs of infrastructure and labor. Applications to be migrated from different versions and platforms which are located globally in to DCC servers, It follows specific DCC standards for all the steps involved in migration.

Responsibilities:

• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity, Oracle migration checklist, legacy oracle outstanding tasks
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments Ensure databases adhere to corporate standards and policies. Work with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Binary installation of OLTP and Data Warehouse Oracle 10g implemented on Oracle Cluster. Created, Configured and supported several 10g RAC databases with Enterprise Manager Database Control feature. Oracle Critical Patches applied periodically. Served as senior DBA in major installation and created of large 10g databases for multimode RAC configuration of Production, Development and Functional environments on HP-UX 11i
• Configured tnsnames, listener and OEM for cluster and nodes
• Performed physical database design, database space needs and growth analysis, and future disk need analysis.
• Data is migrated from Oracle 8i, 9i and 10g legacy databases to Oracle 10g databases DCC using migration utilities Data Pump, Export and Import schemas and full database , Transport Tablespaces and RMAN. RMAN jobs are scheduled to take backup of database for RAC and stand alone instances. Participated in implementation of off-site Disaster Recovery
• Configured of Oracle OEM web based to monitor database and report on events as defined by the DBA group. Performed production system problem analysis and recommended corrective measures in a timely manner.
• Handled requests received by HP Open View Service Desk
• TCP/IP protocol used for networking
• Security: Enabled TDE encryption through wallet manager. Tablespaces are encrypted. Some columns also encrypted in a table. Granting right privileges, roles and implementing case sensitive passwords.

Confidential

Senior Oracle DBA

• Oracle software 9.2.0.1/10.1.0.5/10.2.0.1 installed on Solaris and Redhat Linux platform. Oracle Patches applied. Oracle kernel and init parameters are set as per requirement. Activities supported for 24X7.
• OLTP Oracle databases are monitored using shell scripts and OEM. Automated UNIX shell scripts to load data into Fact and Dimension tables. Logical backups taken for schemas and database using expdump and impdump utility
• Generating data movement code, compiles code, execute the code and troubleshoot data movement problems. Data is loaded into staging tables using flat files. Created and maintained Materialized replication.
• Creating users and granting permissions for OLTP databases. Map flat files, data, and Meta data management
• Loading data into ODS tables, dimension tables, base line tables, data mart tables. Prepared scheduler scripts and stored procedures. Performed performance and tuning on SQL Queries and data movement scripts.
• Created tables, indexes, users and granted permissions.
• UNIX shell scripts are created. Dynamic SQL is used to facilitate the automatic generation and execution of program statements. Statspack are installed and perfstat user is created. Statistics gathered automatically by using DBMS JOB
• Providing 24X7 Production support

Confidential

Senior Oracle Production DBA

• Materialized Views are created and managed. Oracle 10g Database Control OEM agents are installed to manage and monitor databases, configured Notification alerts and events installed and upgraded agents
• Oracle software installed and database are created. SR TAR created to solve the problems of Oracle for performance problems and Patching. Applied Oracle security patches on a quarterly or as-needed basis. Statistics are gathered for OLTP NRT and EDW databases.
• Performance and consistency are checked. Initiating corrective action to ensure all database servers meet processing requirements for performance and reliability. Backups taken using RMAN for databases and Data Pump for repositories.
• Database objects are managed such as schema, table spaces, tables, views, user login, indexes, stored procedures, triggers and declarative integrity constraints. Setting up access privileges to databases, and creating user security profiles. In Day to day activities are involved. UNIX shell scripts to monitor of database are created. Providing 24X7 Production support

Confidential

Senior Oracle RAC DBA

• Extensively used oracle data pump for export and import of schemas and tables. Experience in taking Daily and Weekly Physical backups using RMAN. Involved in writing Korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and Generate Multi-Master Replication.
• OLTP Databases are reorganized to improve performance
• Daily monitoring Alert logs, growth of tablespaces, size of the tables, top sessions and top 10 sql
• Created users, schemas, tables, Indexes, sequences, db links
• Involved in building and maintenance of High availability solution - Oracle 10g Data Guard and Oracle 10g Advanced Multi Master Replication in RAC environment and oracle 10g RAC
• Databases are administrated in RAC Environment by modifying spfile, managing by redo and undo, enabling archiving flashback, adding removing cluster nodes, managing tablespaces, tables, indexes,
• Starting stopping CRS, enabling disabling CRS. Providing 24X7 Production support

Confidential

Oracle Production DBA

• Monitoring/Maintenance Siebel v6/Siebel v7//Sidekick . Monitor sufficient space exists in all tablespaces. Monitor minimum extents, next extents on the database for proper sizing, performance and capacity. Monitor the backup status of previous night. Work with DBM team if any issues with backup.
• Monitor the Oracle alert log for any errors at instance level or internal errors. Monitor the database for fragmentation and take appropriate action when needed. Recommend archiving timing based on database size and data retention requirements. Monitor the production databases on regular basis and work with application owners to tune resource intensive Interfaces/jobs. Recommend index creation, optimum init.ora parameters.

Confidential

Oracle DBA and Data Warehouse Developer

• Export and import utility used to take backup of schemas. Automated jobs using dbms job package
• User, roles, profiles and schemas are created. Created Materialized Views to improve database performance
• Taking Full and incremental backups using backups using RMAN. Manage storage in segments efficiently by reclaiming wasted space, reorganizing tables online, and estimating growth trends.
• Created tablespaces, and monitored spaces. Tables are Partitioned and indexed to improve performance.

Confidential

Data Warehouse Developer

• Creating Mapper programs, Manipulate data and create reusable transformations. Generating data movement code, compiles code, execute the code and troubleshoot data movement problems.
• Control console for data transformer server using server console. Creating users and granting permissions. Map flat files, data, and Meta data management. Loading data into staging tables from flat files and tables

Confidential

Oracle DBA

• Planned and tested Cold / Hot / Export / Import backup strategies for the database. Queries are tuned based on get-hit ratio and pin-hit ratio. Indexes are created. Controlled and monitored user access to the database by Creation of Roles and granting required object and system privileges.
• Recovery Manager Implementation for Development database in testing environment

Confidential

Sybase DBA

Installation of Database Sybase 11.9.2 Adaptive Server Enterprise on Solaris 2.7 O/S and Database Sybase 11.0.3 Adaptive Server Enterprise on Solaris 2.6 O/S. Managing Sybase products using Sybase Central, Creating and Managing User Databases, Creating and Using Segments, Initializing Database Devices. Designed and Developed table structures, Transact-SQL stored procedures and Triggers to implement business rules. Tables are denormalized to improve performance. Database Users, Roles and User Permissions are managed.

Confidential

Oracle DBA