SUMMARY:

• All together 11+ year in IT and 8+ years of experienced with Oracle Database Administration, installation, configuration, migration, upgrade, backup and recovery, oracle patch apply, cpu apply, performance tuning, health check, database security setup, schema design, and production support of 24x7
• OBIEE 11g Administration Managed Data Repository / Data warehouse Databases, performed structural changes and ETL activities.
• Experienced in Real Application Clustering (RAC) installation, configuration & administration
• Replication with Data Guard and active data guard (MAA)
• Experienced with Weblogic 11g/ 12c, Fusion middleware 11g, ASM, Grid Control 11g/10g
• Experienced with Database up - gradation Oracle 10g/11g
• Experienced with designing logical and physical backup/recovery procedure
• Experienced with Sun Solaris, Linux and Windows Server environment
• Experienced in Performance Tuning Index, SQL Hints, SGA, ASH, ADDM, AWR & Statspack
• Experienced with database security, files, directory, user, group, and database profiles.
• Worked with Bug fixing, Patching of oracle Database.
• Extensive experienced with performance tuning of instance tuning and good knowledge on database waits events and oracle internals.
• Extensive DBA experience with export/import, datapump, indexing and administration tool like OUI, DBCA, NETMGR, OEM, srvctl, crsctl, opmnctl, emctl, sqlplus etc.
• In depth understating of oracle architecture, SGA & PGA memory and background process, oracle data dictionary and explain plan.
• Experienced with database objects like materialized view and modifying PL/SQL stored procedures, functions, packages, triggers, index, and sequences etc
• Expertise with UNIX shell scripting and automated task scheduling using crontab
• Experienced to configure IBM InfoShere DataStage and WebSpere
• Worked with Capacity Planning of Database and server

TECHNICAL SKILLS:

Databases: Oracle 10g/11gr2/12c

Operating Systems: AIX, Sun Solaris, Linux, Windows Server, VMware

Programming Languages: C++, Java 2.0,SQL,PL/SQL,HTML

Backup Recovery: RMAN secure backup, EMC.

Languages: SQL, PL/SQL, C#, Shell, HTML

Monitoring Tools: Grid Control, EM, Toad, Quest Foglight Agent

Others Tools: TOAD, PL/SQL Developer and MS project.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. Oracle Database Administrator

Responsibilities:

• Responsible for Database support for multiple projects. Working closely with Applications developers and IT Architect. Presenting and analyzing database performance reports and improvement recommendations to client company's senior executives.
• Patching and upgrades of OTLP 3 node Oracle RAC with tow node active Data Guard Build, patching, maintenance and upgrade of DW Oracle database.
• Carrying out Oracle Database maintenance ; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR) / Automatic Database Diagnostic Monitor (ADDM) to generate performance reports.
• Support of the Database Architecture Team in developing solutions for data replication into the lower environments with data masking, transparent data encryption and Oracle database Vault technologies.
• Performance & tuning the database by using sql plan management, explain plan, SQLT, tkprof, histogram, OS Watcher, indexing, sql hints, ADDM, AWR & ASH defragmenter, shrink table space and gathering statics, and using wait events
• Planning GlodenGate setup to achieve Unidirectional and Bidirectional . Installed and configure GoldenGate for data replication and tested Data load.
• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Managing Partitioned tables and Indexes for efficient and robust access of database objects.
• Wrote highly complex SQL, UNIX shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers & stored procedure to finish the project on time and save the organization cost.
• Provide on-call support to specific business and customer Service Level Agreements .

Tools: /Technologies: Oracle database 12c/11g r2, Oracle CRS, Oracle Web Logic 11g, Net backup,Tuning, RMAN.

Sr.Oracle Database Administrator

Responsibilities:

• Installed, upgrade and administration of 11gR2 RAC databases and data guard ( MAA) setup and worked with grid upgrade and database upgrade, scan listener and ASM upgrade.
• Installed, configured administration of data replication solutions using Oracle Golden Gate 11g. Worked on replication and upgrade production databases zero downtime with oracle Golden Gate.
• Installation and physical-logical structure design for the database environment and performance tuning for our projects’ databases, mainly working on enterprise content management system and online Transaction management system.
• Worked with Exadata storage servers, database servers and InfiniBand switches maintaining, patching and upgrading to higher versions, troubleshooting with Cell servers and firmware.
• Worked as data analysis, data growth in and system infrastructure analysis for database environments. I managed to reduce the size of one of the major databases in half. Implemented Table re-org and shrink for highly fragmentation table.
• Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages, with active archived logs transfer to Standby/RAC databases.
• Change management/review/implementation and complex projects in pipeline implementation. Review and evaluate all the database changes, approve or reject, and assign them to appropriate DBAs.
• Implement complex projects, such as database infrastructure design/optimize, database refresh, migration, upgrade .Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, Oracle Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as an Oracle DBA.

Tools: /Technologies: Oracle database 12c/11g r2, Oracle CRS, Oracle Web Logic 11g, Net backup, Tuning, RMAN.

Sr.Oracle Database Administrator

Responsibilities:

• Presenting and analyzing database performance reports and improvement recommendations to client company's senior executives.
• Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
• Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle.
• Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
• Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Performed logical backups using Export/Import and Data Pump utilities for very important Production Code release . Restore Databases in previous state fail of releases.
• Scheduling maintenance and health check of the applications and databases. Other duties include schema implementation, security, upgrades (installing patches). Analysis Databases patches every quarter release with Confidential .
• Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, hot backup scripts and Recovery Point .
• Perform and Monitor Daily and weekly full/incremental backup and Recovery using RMAN . Performed database restores and recoveries utilizing RMAN backups that resulted in 0 data loss .
• Used the OBIEE 11g Administration tool to develop and enhance Data Model. Configured and created OBIEE Repository. Involved in modifications of all three layers (Physical, Business Model and Presentation) using Oracle BI Administration (OBIEE RPD)
• Administrated IBM InfoSphere DataStage and IBM WebSphere for DataStage and application users.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.

Tools: /Technologies: Oracle database 12c/11g r2/10gr2, Oracle CRS 10g/11gr2, Oracle Web Logic 11g, Net backup, Tuning, RMAN, Solaris, OBIEE. IBM WebSphere

GTI Oracle Production Support

Responsibilities:

• Worked as team to Installation, Configuration and Administering Oracle Real Application Clustering (RAC). Administered several databases including single instance and multi-node RAC instances. Installed, configured 10g/11gr2 RAC on two node cluster.
• Set up Oracle disaster configuration using Data-Guard (Physical Standby Database) in Oracle 10g/11g. Configure and manage Oracle 10g physical data guard and 11g Active data-guard (MAA).
• Configuration/Installations of Oracle Enterprise Manager (OEM) to automate the DBA activities on Production databases. Administer and monitoring database, file system, CRS and listener with Oracle 11g grid control.
• Made recommendation for growth of system which involves the use of an Oracle Exadata system.
• Focusing on Exadata administration, perform Disaster recovery of Exadata Dataguard Physical Standby. Failover, Switchover, Loss of service, Rebuild, Corruption, Loss of datafile testing.
• Good understanding of Oracle Exadata and HCC (Hybrid Columnar Compression). Worked on servers like Oracle Exadata /HP /IBM /SUN/
• Scheduling maintenance and health check of the applications and databases. Other duties include: schema implementation, security, upgrades (installing patches).
• Data modelling ( STAR schema ) design and architecture, created new facts, dimensions and alias tables for the dimensional tables when required.
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layer of the Repository.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics
• Used the Catalog Manager and maintain the Analytics Web Catalog to manage Dashboards, Answers.
• Closely worked with the business analysts to gather user requirements and did thorough Data Analysis.
• Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.

Tools: /Technologies: Oracle database 11g r2/10gr2, Oracle CRS 10g/11gr2, Data-Guard, RAC, Oracle Web Logic 11g, ASM, net backup, Tuning, RMAN, Linux and Oracle Linux, OBIEE.

Oracle DBA

Responsibilities:

• Installed Oracle 11gR2 RAC on Linux Red Hat 5 from scratch and Managing Oracle 11g2 RAC
• Providing production support for oracle 10g r2/11gr2 Server databases.
• Configured RMAN backup, perform RMAN backup and recovery, monitoring database health.
• Install & configure Oracle Enterprise Manager to monitor Oracle 11g, Oracle10g database.
• Monitoring, performance & tuning the databases using trace file, alert log files, v$views, AWR, ADDM, indexing, gathering statics, explain plan, SQL tuning, OEM, and Grid Control.
• Performing and designing backup/recovery strategy using data-pump and RMAN.
• Experience with Oracle database including their appliance Exadata.
• Working with database security setup files, user, group access, and database profiles security setup
• Working with schema objects like tables, functions, store procedure, packages, indexes, views
• Updated and test oracle SQL & PL/SQL scripts, shell scripts and automated task scheduling using Enterprise Manager (OEM) scheduler, also crontab and windows scheduler for production databases
• User Management - creation and maintenance of users, creation of Roles and profiles.
• Regular backups & Recovery. Writing automated Regular Daily backup procedures using RMAN
• Monitoring system security, auditing of database objects, system privileges.
• Monitoring of free space and extents in table spaces. Technical documentation for backup/recovery and data archiving process. Database design, testing, implementation, tuning, and administration
• Extensive use of performance tools like AWR, ADDM, ASH and Explain plan for performance monitoring and troubleshooting.

Tools: /Technologies: RAC, Data guard, ASM, RMAN, Linux, windows, AWR, Shell scripting, Oracle 11g/10g, Grid Control Toad.

Oracle & MS -SQL DBA

Responsibilities:

• Creating, checking, extending tablespace. Administered database security, created users, granted/revoked roles, privileges, extended databases storage capacity, monitored and reduced database fragmentation, managed data files, rollback segments, extents, segments, re-indexing, monitor storage, backup & restore/recover database, export/import database objects.
• Worked on Load balancing and performance tuning on RAC environment.
• Provided support and Trouble shooting on 24x7 basis for Production environment.
• Involved in Tuning stored procedures that include PL/SQL stored packages, procedures and functions.
• Worked on exports/Imports, backup/recovery operations.
• Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation.
• Responsible for all aspects of database administration including Oracle software installation, database creation of development, testing, staging, and production databases.
• Applied patches and modifications to remain compliant with the security requirements.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and Separating of tables and indexes on different locations. Reducing Disk I/O Contention.
• Installed SQL Server 2005/2008 windows 2003/2008 advanced servers, applied services packs and security fixes.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Set up Database Maintenance Plan for the Database Integrity Checks, Update Database Statistics, cleansing and solving data base troubles.
• Administering the MS SQL server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Full backups and Transaction Log backups; Restore them whenever necessary, creating backup strategies and scheduling them for execution.
• Regular monitor of servers, which includes backup job monitoring and troubleshoot all the issues on regular basis.

Tools: /Technologies: Oracle RAC, data guard, oracle stream. Grid control, RMAN, Sun Solaris, Linux, Windows 2003, VMware, EMC, AWR, Shell scripting, net backup, Oracle 11g/10gr2

Network Engineer

Responsibilities -

• Managed independent networks, consisting of Cisco 2600 / 3600 routers, and Cisco 3750 switches . Configured and troubleshoot OSPF, BGP, and EIGRP. Implemented the IPv6 protocol and developed a migration plan.
• Procedures (MOP) for the NOC covering escalation procedures and troubleshooting scenarios. Initiated updating floor plans and Visio diagrams that were currently in the companies system with information from site surveys.
• Responsible for Monitoring billing server, MVNO Management software, and has knowledge of wireless technologies TDMA, GSM, UMTS, and E911/Location Based Services network components design, testing, and troubleshooting of the network from Mobile to PSAP.
• Configure user quota, Group quota, File permissions, Group Permissions, User permissions on Linux. Scheduling the auto backup tasks of Oracle database using crontab and job Scheduler.
• Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects.
• Experience with Data Center to move physical server to in the cloud, using VM Ware. Experience to work with VM client to manage server from remote. Install Citrix XenServer / XenCenter. backup jobs, workstation images, inventory equipment, and logon scripts.
• Responsible for Office 365 of organization core e-mail system in the cloud. Export old exchange data and import new cloud server. Work with Confidential Support Tech for company implementation.
• Experience for Remote server Administrator and Data Center manage . Great team player and able to work under pressure. 24x7 duty rotation.

Tools: /Technologies: Cisco Router & Switch, Windows 2003, MS SQL Server 2005, Windows 2003 Dashboard, Diagnostic Manager, Database copy Wizards, Performance Monitor, Oracle, Linux.

System Administrator

Responsibilities -

• Assisting doctors, nurses, and office personnel for hardware and software problems.
• Tracking and following up on trouble tickets, reducing average response time.
• Install Misys, RAMBA and Unity Application for hospital users and configured printers.
• Gave them a prompt support for Medical Admin Cart 24/7/365 with shift wise.
• Upgrade design for management building that saved the company over 60% over the previous design without compromising features, performance or reliability requirements. Project on hold due budget issues.
• Documented their network using Confidential Visio, including datacenter, operations, corporate network and airport network.