SUMMARY:

• More than 12 years IT experience Oracle DBA experience on Windows 2K3/2K/XP/NT, UNIX, Solaris & Linux in 24/7 basis for Production. Development, QA, Testing and Deployment on a RAID level.
• Perform database monitoring, upgrades, cross - platform migrations, patching, backup and recovery management, SQL/PLSQL performance tuning, troubleshooting production issues and root cause analysis.
• Installed and configured Oracle 8i, 9i, 10g, 11g and 12c on Windows 2K3/2K/XP/NT and Red Hat Linux and AIX for Production, Development and QA database server.
• Migrated Oracle 8i/9i/10g to Oracle 11g and 12c using RMAN and export/import process for Production, QA & Development.
• Experienced in DBA Studio, Oracle Enterprise Manager, database configuration, maintenance and monitoring. Monitoring databases using DBA Studio Status Package, adding user’s roles/profile and checking log. Applied patches and other Oracle updates for Database, Enterprise Manager and Oracle Agent.
• DBA Team Lead for Oracle Enterprise Manager Grid Control 10g and 11g.
• Setup, Admin and Maintenance of Oracle Enterprise Manager 12c(12.1.0.3)
• Broad knowledge on RMAN and Recovery Catalog.
• Restored database on Oracle 8i/9i/10g/11g/12c using RMAN for data migration, disaster & recovery and for query/investigation purposes.
• Experienced on Datapump/Classic Export and Import of all Oracle Database.
• Experienced in writing Procedures, functions, triggers and packages in Oracle Server using PL/SQL.
• Involved in monitoring and optimizing Oracle database for performance tuning and system/modules for application tuning.
• Good experience in writing/editing UNIX Shell Scripts.
• Extensive experience in Dataguard configuration , implementing and maintaining standby databases .
• Performed numerous Disaster & Recovery testing.
• Experienced on install and setup of Oracle RAC under Red Hat Enterprise Linux.
• Experience Programming and writing scripts in Delphi, Visual Basic, Clipper, SQL, PL SQL & Crystal Reports.
• Team player, willing to share and develop his knowledge and experience.
• Customer Service oriented with high values of customer satisfaction.

SKILL:

RDBMS: Oracle 8i/9i/10g,11g,12c, Different options Materialized view, Database resource manager, RMAN, Flashback, Dataguard, RAC, Enterprise Manager, Migration, Performance Tuning, Monitoring, Physical design, Backup & Recovery planning and implementations, 24/7 Customer support.

OS: Windows 20XX/W7/W10, RHEL, Solaris

LANGUAGES: Oracle SQL, Oracle PL/SQL, Delphi, Clipper, Visual Basic.

EXPERIENCE:

Confidential, Somerville, MA

Oracle Database Administrator

Responsibilities:

• Perform multiple database refresh based on Production backup
• Implement new RMAN incremental backup strategy for non-prod environment
• Rebuild observer/broker on Data guard environment
• Tested/documented RMAN TSPITR on RH7 Oracle Database host
• Did numerous performance analysis on Production databases
• Data guard Failover/Switchover, broker configuration and recovery.

Confidential, Boston, MA

Sr. Oracle DBA

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support rotation.
• Supporting client issued on SaaS and Non-SaaS environment.
• Designed RMAN backup and recovery procedures.
• Instance cloning using RMAN to be used for Test and environments.
• Generated scripts (cronjob) for daily maintenance activity like gathering statistics, fragmentation, space issue, database/listener/ASM status alert and monitoring database growth rate.
• Installed and setup Oracle RAC Enterprise for 11g and 12c.
• Migrated all 11g Standard Edition to Enterprise Edition.
• Created RAC/Non-RAC Physical Standby Dataguard for Production databases.
• Assisted developer on tuning their queries for better performance.
• Implemented documents for DBA task for disaster and recovery, installation/patching, RMAN backup and daily tasks.

Confidential, Marlboro, MA

Sr. Oracle DBA

Responsibilities:

• Responsible for database upgrade from 9i, 10g to 11gR2 release of oracle.
• Implement RMAN backup technology on all Production Databases.
• Documented a RMAN recovery scenario to be used in case of Production issue or disaster and recovery.
• Installed and setup Oracle RAC for Enterprise and non-Enterprise edition of 11g Release 2.
• Involved in numerous database refresh and cutoff of Development, QA and Prod databases using RMAN and data pump.
• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting.
• Lead engineering effort, implementation, tuning and support of Oracle 11g Dataguard/Active Dataguard.
• Design, implement and support daily/weekly/monthly reporting using crontab, shell scripts and OEM Repository reporting.
• Migrated 11g Grid to 12c Grid.
• Setup, Configure and Administer Oracle Enterprise Manager 12c Grid for Prod, QA and DEV databases.
• Migrated 10g & 11g databases to Oracle RDBMS 12c.

Confidential, MA

Sr. Oracle DBA

Responsibilities:

• Installed RMAN Repository and registered all databases in the catalog.
• Created RMAN incremental backup strategy for both Production, Test and Dev.
• Created an RMAN recovery scenario which were tested and documented with all their current databases.
• Installed 11g RDBMS, Web Logic Server 10.3.2 and applied all patch on Solaris 10.
• Migrated Oracle 10g database to 11g using Datapump and startup upgrade scripts. All the steps taken are documented.
• Implemented 11g OEM Grid on Solaris 10 and registered all the host using agent silent install.
• Migrated all Oracle 10g(10.2.0.2) database to 11g(11.2.0.2) running on Solaris 10 using manual method.

Confidential, Wellesley, MA

Sr. Oracle DBA

Responsibilities:

• Created numerous Production, Development, Implementation and Test database refresh from client request of 9i, 10g and 11g databases.
• Created data guard for Production databases 9i, 10g and11g on Linux & Solaris box.
• Administered and installed two OEM Grid on Production & Test databases. Created documents for installing grid agents on Linux & Solaris boxes.
• Involved in fine tuning shell scripts use on cronjobs for hot backup, gathering statistics and performance tuning on Production and Test using AWR reports.
• Introduced Flashback concept on yearly disaster and recovery testing for multiple clients.
• Performed numerous cutover of UAT databases to Production.
• Tested and documented RMAN Recovery Scenario.
• Involved in daily tuning of SQL scripts from Prod and Test using TKPROF and SQL tracing.
• Assigned on a DBA call rotation list scheduled 24/7 for client database support and maintenance.

Confidential, Wallingford, CT

Sr. Oracle DBA

Responsibilities:

• Implemented/Managed Oracle Enterprise Manager Grid Control Release 2 to Production/Development and Test environment.
• Setup all databases in Production, Test and Development on OEM RMAN Backup and Recovery such as full, incremental and archive backup.
• Created flashback for the entire database and closely monitored in case of a database failure it can easily go back to were it started to failed.
• Daily performance monitoring and tuning of all databases, created a script which is scheduled at OEM to generate report for statistics and logs.
• Setup Oracle Agent to all database to centralized monitoring of all database which automatically generates email based on the metric collection setting assigned on each database. This email will trigger all DBA assigned to each database.
• On Call rotation scheduled 24x7 DOD (DBA on Duty) for various production/dev/test support and database maintenance.
• Performed database movement from one host to another using RMAN, EXP/IMP, Data pump and manual copy.
• Worked as an administrator/team lead for Oracle Enterprise Manager Grid control for 2 branches in Hopewell, NJ and Wallingford, CT. It manages 138 databases with Production and Development under 8i, 9i & 10g.
• Setup Oracle streams on multiple production databases.
• Created environment for Oracle Application Express as a monitoring tools on Production, Development and Test databases.
• Analyzed Production database performance using OEM Grid Control ADDM.
• Setup Oracle Real Application Cluster on Red Hat Enterprise Linux 3.

Confidential, Silver Spring, MD

Sr. Oracle DBA

Responsibilities:

• Setup Development and Test databases for a Multi Master Replication environment. This includes setting up INIT.ORA parameter file, checking global naming for the entire database, validating the entire schema involved and testing all the process before deploying it to UAT.
• Created partition for tables with millions of records using date range which will be used later for archiving. Analyzed the space usage it will consume by creating dummy tablespace for testing and allocating additional datafile for the tablespace involved.
• Created a script that will archive data by entering the parameter year. Based on the partitioned tables created data archiving will be much easier by just dropping the partition created on the selected year.
• Documented all the Development and Test databases, fixed all the table relationship using ERWin and fine tune some of the table by removing unnecessary column. Created additional index to improve performance of all existing packages and stored procedures.
• Involved in any DB data changes that needs to be pushed to UAT.

Confidential, East Providence, RI

Oracle DBA

Responsibilities:

• Configured enterprise manager and all Oracle Agent for Oracle GRID testing.
• Data migration of Oracle 8i to Oracle 10g using import/export process on a Windows 2K3/2K servers.
• Conducted parallel testing of all database before deploying it to production during data migration this involves department heads, managers, and all the users for approval and signing..
• Installed and configured enterprise manager tools to help in daily management, database tuning, capacity planning and performance management
• Conducts disaster and recovery procedure for all Oracle database yearly using RMAN and export/import approach.
• All databases are running in ARCHIVELOG mode and available 24/7. Database backup mode is ONLINE HOT BACKUP. Planning backup/restore strategy and backup scheduling. Created a script for backup/restore using Recover Manager (RMAN) utility to locate, back up, restore, and recover data files, control files, and archived logs. Automated backup jobs that runs nightly using RMAN.
• Cloned Production Database for used in Development, Testing, QA and Deployment database using Recovery Manager for Oracle.

Confidential

Oracle DBA

Responsibilities:

• Oracle database migration, backup & recovery using RMAN in databases under Windows 2K3/@ Confidential .
• Gives comment and suggestions on existing system, setup of the department and also the process of their existing system
• Involved in Data Gathering and Case Study
• Duties also included system analysis and design, data flow diagram, database design and maintenance in Oracle 8i, system and process flow. Involved in Software and Hardware analysis on Client companies

Confidential

Sr. Systems Analyst/DBA

Responsibilities:

• Majorly involved in System Analysis, Data Gathering, Case Analysis, System design and development
• Team leader for four programmers using Delphi 5 under Oracle 7.3 database
• Instrumental in designing and implementing Citibank E-Commerce payment system for Bureau of Customs
• Responsible for the design and creation of Oracle 7.3 database
• Administers, maintenance and fine tuning of Oracle database for clients
• Data migration of Oracle 7.3 database to Oracle 8i

Confidential

Sr. Systems Analyst

Responsibilities:

• Revised the HR payroll system to be more efficient and accurate to give reports to management in a properly manner.
• Instrumental in the development of Log-in/Log-out system for HR
• Involved in analysis and design on Attendance monitoring system