SUMMARY:

• Around ten years of IT experience as an Oracle DBA on a variety of UNIX (Solaris, Linux, HP - UX), AWS, Azure, Windows 2000 platforms with Oracle 8i/9i/10g/11g/12c. Currently working on 2500+ databases residing on Linux, SunOS, HP-UX, AWS and Windows.
• Significant experience in Oil, Financial, Insurance, Transportation and Trading applications.
• Experience in implementing and managing Oracle 10g/11g features like Real Application Clusters (RAC), Data Guard, Streams and worked extensively in OLTP and OLAP environments.
• Working experience of AWS and Oracle cloud products and services.
• Proven hands-on cloud migration solution design/delivery experience.
• Installed OEM 12c and Migrated 79 servers containing 427 databases.
• Experienced in DB activities that involved DevOps tools like JenKins, SVN, GITS and Flyway in the environment.
• Ability to effectively address data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM.
• Exposure on AWS Relational Database Service (RDS), AWS Database Migration Service (DMS), Elastic Compute Cloud (EC2), Elastic Cache, Elastic Load Balancing, Elastic Block Store (EBS).
• Exposure in install/configure/upgrade the High-Availability Hadoop Clusters.
• Installation, Configuration and Administration of Oracle10g/11g RAC by using ASM.
• Good experience in installing, configuring and administrating Data Gaurd on both RAC and Standalone Servers.
• Also administered, monitored, migrated and upgraded versant databases.
• Applying oracle patches for Daylight Savings Time (DST), upgradation and migration of databases using the OPatch utility and fixing bugs.
• Experience with exporting and importing data to and from a database using the exp/imp utility.
• Used EXPDP/IMPDP (Data pump) to take the hot backup using DUPLICATE or full export and also to accomplish table level and full database de-fragmentation.
• 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.
• Proficient in SQL, PL/SQL, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Analyze and Autotrace.
• Used STATSPACK for Database Monitoring and Database Performance.
• Created table partitions to improve performance and data management.
• Experience in creating Materialized Views in data warehousing environment.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Worked on various Technologies in Data warehousing - ETL Tool Informatica, Ab initio and database development tools like TOAD, ERWIN, and SQL Developer.
• Experienced in designing, developing, scheduling and monitoring UNIX shell scripts to administer all the environments.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Providing assistance in logical/physical data modeling using ERWin.
• Experience in database application development using SQL, TOAD.
• Extensively involved in Database Cloning manually as well as using RMAN.
• Configuration of Oracle Enterprise Manager (OEM) to monitor database and report on events as defined by the DBA group.
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
• Extensive Database Administration - Oracle 8i/9i/10g/11g/12c experience that includes creation and management of users and their profiles. Tuning of the database for optimum performance.
• Documentation of projects, databases, installations.
• Knowledge of the System Development Lifecycle (SDLC).
• Experience with delivery management and estimation.
• Clear communication and documentation of technical specifications.
• Extensive Database Designing - Oracle 9i/10g/11g. Experience. Common tasks include analysis of the particular system, which further included interaction with the end - users and the management to develop requirements and specification for the project.
• Experience in working with high-transacted OLTP systems.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Excellent troubleshooting skills and committed follower of Oracle Technologies.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server, My SQL, DB2, Ms-Access

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM,TOAD, ER-studio, Oracle migration work bench, Oracle Parallel Server, Oracle Replication, OID, Data Guard, ASM, Golden Gate, Oracle Data Integrator, RAC, OLAP, SQL backtrack and DevOps tools.

Operating Systems: Z-Linux, Sun Solaris, HP-UX, AIX4.3.3, Red Hat Linux 7.2, and Windows Server 03/08/12/16, AWS, Azure.

Languages: VB6.0, C, Pro*C, SQL, PL/SQL

Scripting Languages: Shell scripting, VB script, JavaScript, Perl

Markup Languages: HTML, XML (knowledge).

Web Servers: IIS, Apache, IBM

Server side Tools: ASP, PHP

Reporting Tools: MS Project, Ms-Office, MS-Visio, MSBI, VERITAS, Informatica, Ab Initio, oracle warehouse builder.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Data Base Administrator

Responsibilities:

• Senior Oracle Database Administrator that is responsible for managing and upgrading ORACLE Non-RAC and RAC Clusters which are used by Mission critical customer facing Applications with the goal of improving the database system scalability, performance and functionality which resulted in the business satisfaction and the cost savings.
• Support Installation, Configuration, Migration, Upgrading, Patching, Tuning, RMAN and Data Guard for Database and Application servers on Solaris, Linux and windows Servers platform.
• Support 10+ Terabyte Production RAC and Non-RAC Databases and applications plus Data Guard Servers.
• Installed and configured Oracle Database 12C.
• Upgrade Oracle Databases from 11G to 12C.
• Troubleshoot performance and Apply PROD Fixes.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) Patches on all the Databases.
• Installed, Configured, Upgraded and Managed OEM 12C (12.1.0.5) and Agents.
• Upgraded OEM from 12C to 13C.
• Created/updated Shell Scripts and Oracle SQL, PL/SQL Scripts to monitor databases and other related activities.
• Installed and configured Standby (Data Guard) Databases (Active and Snapshot).
• Performed Switchover and Failover from production to standby.
• Performed backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
• Importing and exporting data to and from the database servers using data pump (EXPDP & IMPDP) and Creating & maintaining detailed configuration documentation, and maintenance plans for the database environment.
• Creating tables, views, indexes, database links, views, materialized views, stored procedures, and other database objects as needed.
• Install, Configure, Supports and Mange SQL Server 2012/2014.
• Creating and assigning database roles and privileges and Performing Oracle and SQL performance tuning tasks using AWR, ADDM and TOAD.
• Analyzing, capturing data requirements, data definitions, business rules, and data quality requirements.
• Raise Oracle SR tickets and working with remedy ticketing system in support of production and Non-production servers
• Managing the storage environments for the databases from ASM and File System, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.

Confidential, San Diego, California

Oracle DBA

Responsibilities:

• Carry out all major service delivery and support areas: Installation, Configuration, Migration, Upgrade, Patching, Cloning, Tuning, RMAN, MAA and Data Guard for Database and application servers primarily on Solaris and Linux Servers platform.
• Support 4+ Terabyte Production RAC and Non-RAC Databases and applications plus Standby servers.
• Installed and configured Oracle Database 12C.
• Apply Oracle CPUs Patches on Databases.
• Upgrade Oracle databases from 11G to 12C.
• Troubleshoot and Apply PROD Fixes.
• Troubleshoot performance and database code issues across all the environments (Prod, Non-Prod).
• Support Oracle 11G Fusion Middleware servers including OAM, OIM, OID, Web Logic, Forms and Reports
• Apply Oracle Weblogic Patches.
• Create/update UNIX shell scripts and Oracle SQL, PL/SQL scripts for database monitoring and other related activities.
• Convert Forms and Reports from 10g to 11g.
• Compile Forms and Reports.
• Upgrade Oracle Database servers from 10G to 11G.
• Wrote RMAN and shell scripts for Production and non-production databases.
• Created Shell Scripts to Baseline FMW and Databases.
• Manage Users access/privileges and groups through OID (Oracle Internet Directory) and Databases.
• Upgrade Oracle Databases from 11.2.0.3 to 11.2.0.4.
• Upgrade Oracle 11G FMW ( Fusion Middleware ) from 11.1.1.6.0 to 11.1.1.7.0.
• Upgrade OEM 12C from Release 3 (12.1.0.3) to Release 4 (12.1.0.4)
• Support User Accounts on Databases and Fusion Middleware level.
• Installed, configured and upgraded BI Publisher 11G.
• Troubleshoot and Support BI Publisher reports including Create reports, Data models, Data sets and Data sources and schedule jobs.
• Working on the Remedy ticketing system.
• Using Oracle Data Integrator (ODI) to support the Data warehouse databases.
• Installed, configured and support the new 11g Snapshot Standby Database.
• Creating and maintaining databases and database objects including logical and physical data models, DML, DDL, DCL, tables, object types, views, synonyms, users, sequences
• Installed and configured and upgraded OEM 12C and Agents.
• Troubleshoot and Support Standby Databases (Active and Snapshot).
• Install, configure, troubleshoots and supports SQL Server 2008/2012.
• Strong experience in writing and improving SQL Server T-SQL queries.
• Experience working with SSMS, SSRS, SSAS & SSIS (reporting, analysis & integration services).
• Monitor and schedule blackouts through OEM 12C for all the FMW and Database servers.
• Uses Oracle tools and utilities like RMAN, CMD, DGMGRL, SRVCTL, Import/Export (and Data pump) plus SQL*Loader and 3rd party tools like Toad.

Confidential, Dallas, TX

Oracle DBA/ Architect

Responsibilities:

• Perform DBA responsibilities including creating and maintaining database objects, user profiles and access privileges, Performance monitoring and tuning databases backups, etc.
• Manage Production, non-production, DR databases and Application Servers.
• Provide programming support for applications using SQL, PL/SQL and UNIX scripts including Stored Procedures, Triggers, and other objects as required.
• Proactive monitoring performance, Plan growth and changes (capacity planning) and manage parameters to provide fast query responses to 'front end' users.
• Accept responsibility for problem escalation to line manager, in the event of database availability and performance problems and provide realistic, achievable potential solutions to the problems.
• Installed, configured and upgraded Oracle Database from 10G to 11G.
• Installed, Configured JDK, Weblogic on Windows, Linux and Solaris.
• Installed and Configured Oracle Fusion Middleware 11gR2 for deploying DCMS tailored forms-based applications.
• Converted and Compiled Oracle Code (Forms, Libraries, Reports, Menus….).
• Integrated/Migrated Custom Applications DCMS "Daybreak" to work with 11G Fusion Middleware.
• Upgrade Application server from 10G to 11G.
• Troubleshoot and develop solutions for problems related to database and Oracle Applications.
• Deploy Zip Codes using Sql*Loader.
• Install and configure the new 11g Snapshot Standby database.
• Liaise with application and business clients to gather requirements, design and deploy standard systems which clearly differentiate between production, development, UAT, and DR.
• Involved in on-call support on a rotating basis with other team members to support production systems environments.
• Monitor and raise Oracle Service Requests (SR).
• Use Oracle specific tools and utilities like OEM, CMD, RMAN, DGMGRL, SRVCTL, Import/Export (and Data pump), SQL*Loader and 3rd party tools e.g. Toad etc.
• Deploy Builds to DCMS and ELA Production and non-Production Databases.
• Apply Production Fixes to DCMS and ELA Production Databases.
• Used remote tools to connect after hours like FTP, PuTTY, VPN, etc.
• Resolved rollback segment errors by creating bigger UNDO table space and increasing the retention time and this increased performance to the users.
• Design and plan infrastructure for oracle database including Allocating system storage and planning future storage requirements for the database system.
• Configured and implemented backup and recovery strategies using Recovery Manager (RMAN) backup on the Production and non-Production servers.
• Troubleshot and resolved locking issues on DCMS Daybreak application.
• Keep a checklist and methodologies which defines required deliverables at each stage.
• Apply Patches & Bug fixes on Oracle databases and applications tiers on Sun Solaris Sparc servers.
• Wrote RMAN script to duplicate production database to a test instance.

Confidential, Princeton, NJ

Oracle Principal Consultant

Responsibilities:

• Production DBA responsible for responding to problems on over 100 databases for over 7 clients with different environments in Oracle 9i,10g and 11g {Standard & Enterprise Edition} plus the Data Guard databases.
• Fulfill DBA daily activities including user management (*creating users, synonyms, privileges, roles, quotas, table, index, sequence* etc.), space management (table space, undo segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
• Responsible for all levels of Support, troubleshooting, customer consultation and performance tuning in a 24 x 7 x 365 environment for Oracle 9i, 10g, and 11g on different platforms (UNIX, Linux and Windows)
• Installed Linux Enterprise 4 & 5.
• Excelling experience in Installing and configuring Oracle Real Application Cluster (RAC) cluster on Oracle 10g and 11g R2 With ASM and Raw Devices and 11g CRS providing high availability to the Oracle production environment.
• Manage and Supported Oracle RAC (Real Application Cluster) on Oracle 9i, 10g and 11g.
• Excelling experience in Installing and configuring Oracle Database Appliances (ODA).
• Excelling experience in Installing and configuring OHTTP (Web tier).
• Excelling experience in Installing and configuring Web Logic.
• Excelling experience in Installing and Troubleshooting Oracle 6i, 10g and 11g Forms.
• Excelling experience in Installing and configuring and Managed (OEM) Oracle Enterprise Manager Database and Grid Control 10g and 11g.
• Configured UTL SMTP to send Emails from the server.
• Successfully completed 6 projects on Oracle RAC - Configure, implement, and support
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Monitor and Tune the databases through command line (pro active scripts) or OEM to insure satisfactory performance.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
• Created database users, table spaces, tables, and indexes, constraints, Function, stored procedures, Packages and triggers, profile, roles and allocating default table space for users.
• Resolve lock issues, space management issues, security, user management, privileges, roles and auditing.
• Worked with archive and no archive log mode.
• Implement disaster recovery sites using standby Oracle Data guard/Active Data Guard Modes Maximum (Performance/Availability/Protection) and configure it with DG broker.
• Manage, support and maintain Oracle Data Guard 10g providing high availability and disaster recovery for Oracle production environment.
• Upgrade and migrate Oracle databases from 10g to 11g R2.
• Applied Oracle patches and troubleshooting.
• Detect and correct any performance issues.
• Successfully changed the Database Name.
• Successfully converted the database character set from single byte to multi-byte (UTF8).
• Reconfigured production SAN environment, created new logical volumes for Oracle files (control files, data files, flashback logs, redo and archive log files) based on the best suited RAID levels and RAW devices for ASM.
• Configured and Performed backups and tested crash recoveries using Cold, Hot backups with RMAN and also tested various recovery procedures.
• Setup RMAN Catalog for all the Oracle databases.
• Using Export, Import and Data Pump.
• Schedule and create scripts to refresh the DEV databases from Production.
• Experience in writing Shell Scripts for automating backups and restoration.
• Monitored and tuned SQL and PL/SQL code using Quest TOAD for maximum efficiency and performance reducing execution times.
• Compile /Migrate Oracle Forms & Menus & Reports from 6i to 10g to 11g.
• Rewrote sections of PL/SQL code to improve performance.
• Responsible for disaster recovery planning.
• Performed Switchover and Failover from production to standby and vice versa.
• Monitored and followed up Tar’s service requests raised with Oracle Support.
• Write and Fine-tune UNIX scripts and setup Crontab jobs, schedule tasks, Oracle and UNIX alerts system to facilitate Weekly /Monthly/Daily updates/jobs.
• Modified Oracle initialization parameters.
• Analyze Redo Log Files Using LogMiner.
• Create SSH keys between the Database servers (production and standby).
• Add LUNS to the ASM and monitor the database and do capacity planning.
• Partitioned (Hash, Range, List) large tables to increase performance.
• Ran a (Stats pack, EXPLAIN PLAN, AWR) reports to evaluate the performance activity.
• Wrote Oracle scripts to update and modify policies in the databases.
• Create SQL trace files and used the TKProf tool to analyze them in as needed basis.
• Ran a (trace plan, ADDM, and OEM tuning advisor in order to make tuning recommendations for slow running queries.
• Excelling experience in Installing SQL Server 2008/2012 .
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and Database Engine Tuning Advisor.
• Created new databases and objects like Tables, Procedures, Functions, Indexes and Views using T-SQL and SQL Server Management Studio in Development and Production environment for SQL Server 2008.
• Define and implement ETL development standards and procedures for Data Warehouse environment.
• Managed data warehouse projects improvement and growths.
• Wrote Shell Scripts to monitor slow running queries table space and extent growth.
• Configured network configuration using TNS, LISTENER, Net Configuration Assistant.
• Customized Oracle 10g Grid to send email alert when thresholds are out of given range.

Confidential, Los Angeles, CA

Oracle DBA ( Independent Contractor)

Responsibilities:

• Configured multi-node 11G RAC cluster Configuration on RHEL5 with ASM disks for storage with RAW devices for voting disk.
• On -call response in Oracle DBA group.
• Setup standby databases (Active Data guard and non active Data guard) and managed some standby databases as well as worked on resolving issues related to standby databases
• Experience in performance tuning of production and development databases
• Restore RMAN from prior backups.
• Served both as Linux systems administrator as well as Oracle Apps DBA as the sole
• Install and configure OEM Grid control 10G, 11G and 12C
• Backup and recovery issue resolution.
• Rewrote sections of PL/SQL code to improve performance.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided 24 x7 database administrations, user/production support and monitoring.
• Provided database Installation and configuration on both windows and Linux platforms.
• Provided Oracle application Server installation and configuration.
• Provided Oracle Developer Suite 10g, 6i installation and configuration.
• Oracle RAC 10g installation and configuration.
• Setting up Linux kernel parameters for Oracle.
• Linux permissions and file structures for Oracle.
• Documented Change Request Design Documents and install scripts for enhancement issues.
• Solid experience in all kind of backup and recovery (logical & physical) using OEM, RMAN, TOAD, SQL*PLUS.
• Created databases and imported schemas and ran the applications in the right way.
• Provided Patching and Upgrading Oracle 10g.
• Solving day-to-day user Problems (VPN at client location or by phone) in applications / database / network.
• Good PL/SQL experience (working with the developers solving problems).
• Reported to direct supervisor with a database status report.
• Documented new system and created the entire Database Run book & Redbook.
• Experienced in Export & Import user level, table space level, and database level.
• Provided Monitoring & Managing the Table spaces and Data files growth.
• Monitored locks and various sessions using OEM.
• Controlled database privileges and managed user accounts.
• Maintaining several Database instances running on Windows environments.
• Worked on 6i and 10g Oracle applications, Installation of servers and clients.
• Created and administrated database objects like table, views, indexes etc...
• Provided support for the smooth functioning of the Database to developers.
• Worked with archive and no archive log mode.
• Worked on all kinds of flashback.
• Restoration and Recovery from backup.
• Setup RMAN catalog for all the Oracle databases.
• Data transfer from excel, to oracle database using TOAD.
• Provided Performance Tuning.
• Provided Network connectivity and configuration.
• Tuned PL/SQL code using Quest Toad.
• Tuned Oracle initialization parameters and adjusted Oracle buffer cache to reduce disk access time.
• Modified tables to allow parallel querying and loading.

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Creating users and maintaining database security.
• Maintained Oracle Databases running on various operating systems like Windows NT and Linux.
• Implementing Backup/Recovery Strategies using RMAN.
• Load data into Oracle using Export/Import database objects/schema
• Problem troubleshooting and resolution.
• Experience in performance tuning of production and development databases
• Database tuning, backup and recovery and general day to day running of the system
• Worked with OEM daily.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Provide DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR.

Confidential

Oracle DBA

Responsibilities:

• Database installation and instance creation.
• Using Enterprise Backup utilities for backup.
• Writing UNIX shell scripts for backup and recovery.
• Writing technical manuals.
• Creating project plans and implementation schedules.
• Performing Backup / Restore of Oracle Databases.
• Ran Statspack report on a daily basis to create performance reports on the previous day’s activities.
• Setup Network connectivity and configure switches and routers.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.