SUMMARY:

• Taking ultimate responsibility for the availability, performance and, wellbeing of the Enterprise wide Oracle databases.
• Performed capacity planning required for creating and maintaining production databases. Implementing physical and logical database design.
• Take ownership of database designing, planning, and rolling it into production databases.
• Deployment of databases creation as required. Installing new versions of the Oracle RDBMS, applying patches and any other tools that access the Oracle database.
• Planning and implementing automated “Backup & Recovery” strategies as well as Disaster Recovery strategies for the production databases.
• Perform on going crash database and recovery simulation on test machines. Work closely with system administration staff to deal with applications and tools that affecting the Oracle Databases.
• Implementing and enforcing security and access levels for all of the Oracle Databases.
• Enforced and maintains database constraints to ensure integrity of the database.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assists with impact analysis of any changes made to the database objects. Troubleshoots
• Oracle RAC Administration: RAC Installation; RAC DB Administration; Backup and Recover a RAC DB; RAC DB Monitoring and Tuning; RAC environment Services configure and manage
• Cluster Management: Oracle Clusterware Installation, administration/diagnosing the Oracle Clusterware components and node addition/removal

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

• Having an Oracle DBA performance and backup monitoring contract. (second shift)
• Writing multimedia educational classes for Oracle Cloud Control
• Writing multimedia educational curriculum for Oracle Database Machine Administration certification preparation

Confidential

Systems Coordinator

• Tuning SQL statements, stored procedures and functions. Oracle E - Business Suite, Speeds up nightly ETL process. Grid Control
• Automating manual process using combination in Linux scripts and stored procedures. Automate nightly RMAN backup process.
• Identifying SQL and PL/SQL that slowing the database down and tuning them to optimal performance.
• Combine ITIL and Six Sigma methodologies to get maximum benefits of both by migrating an existing process to an ITIL-compatible process and thus is applying the DMAIC (Define, Measure, Analyze, Improve, Control) roadmap of Six Sigma that will provide an ITIL-compatible process aligned with the SLA.

Environment: Oracle 12c, Oracle 11g, Linux and Windows workstations, VMWare, SQL Server

Confidential, Tampa, Florida

Sr. Oracle DBA

• Responsible for and maintaining enterprise wide production databases including installation, configuration and upgrading of Oracle server software and related products. Implemented, maintain and ongoing monitoring backup and recovery system including policies and procedures along with periodical crash simulation testing.
• Administered interaction between Oracle Warehouse Builder and SAP.
• Moving Data via different methods; Configuring Recovery Manager; Performing Database Recovery; Recovering from User Errors; Dealing with Database Corruption;
• Monitoring database performance. Troubleshooting, identifying and tuning application code identifying performance issues, discuss such issues with developers and help tuning the code.
• Proactive Maintenance; Performance Management; Performing Backup; Performing Flashback; Flashback Database; Using Recovery Manager; Recovering from Critical Losses including recovering from loss of all control files; Monitoring and Managing Storage.
• Supported development team in tuning codes for better performance.

Environment: Oracle 12c, Oracle 11g, Linux and Windows workstations, VMWare

Confidential, Clearwater, Florida

Sr. Oracle DBA

• Software installation, database creation, monitored and maintained.
• Managing: storage structures, schema objects, Data and Concurrency, Undo Data,
• Implementing Database Security and Enforcement, administered user access security.
• Configuring the Oracle Network Environment; Automatic Storage Management (ASM);
• Monitoring and Managing Memory; Using Globalization Support Objectives; DBVERIFY etc. and Managing Resources; Automating Tasks with the Scheduler.

Confidential, Norfolk, MA

Sr. Oracle DBA

• As a Sr. Oracle DBA, I was trusted with the performance and confidentiality of a critical state level governmental confidential database that keeps accurate tracking for state wide jail system; including inmates’ personal and legal history of arrest, court and legal records, in-jail incidence and behavior tracking, and inmate images for all Massachusetts state wide jail systems.
• Duties included general Oracle DBA tasks including installations, migration, data manipulation, Backup & Recovery automation, working with developers, Monitoring.

Environment: PL/SQL, SQL, Oracle 10g, Oracle 11g, Linux/UNIX on VMWare, RMAN, Dataguard, Oracle Diagnostic Tools, RAC administration.

Oracle DBA

• At the time I arrived M2S didn’t have an Oracle production database
• Helped in setting up and configuring the Oracle Clinical Application (OC) for a Clinical Trial Registry. Generating reports with SAS and Cristal Reports.
• Helped with the introduction to the Oracle as a new product in their environment.
• Configured Oracle Backup and Recovery System
• Helped the QA testing the new OC.
• Helped the developers to move data and programs from PostgreSQL Database into the Oracle database format.
• Wrote complex PL/SQL Stored procedures for OLTP/DSS database.

Environment: PL/SQL, SQL, Oracle 10g, Oracle 11g, Linux RMAN, Standby database, Oracle Features (10g/11g), Oracle Diagnostic Tools, Toad, Spotlight for Oracle.

Confidential, Tewksbury, MA

Oracle Database Administrator

• RAC implementation, installation, configuration, troubleshooting
• Duties included installation, configuration, tuning, and administration of Oracle production and development plus UNIX administration on HP-UX 11i server of production and development servers
• Other duties. Database Administration for live production Oracle OLTP / DSS systems and optimization, including optimization for mixed OLTP/DSS systems.
• Upgrade of Oracle8i to Oracle9i then to Oracle10g and Oracle database server software using OFA methodology.
• Physical and logical database design and configuration; data modeling using CASE tools (ErWIN) and Toad; business analysis of data collected in databases for business development support; reporting on historical data, and archiving Legacy system into Oracle database using external tables.
• Tuning the databases with Enterprise Manager
• Scheduled jobs for scripts by setting up UNIX cron jobs using crontab.
• Wrote complex PL/SQL Stored procedures for OLTP/DSS database
• The enterprise databases handle a large amount of online transactions from 58 large supermarkets concurrently. I monitored, tuned and kept up to the minute with all the databases on the day-to-day and ongoing basis. I handled all the life cycle and care of the all issues of the production databases.
• Was available 24x7 as the nature of this line of work expects for the DBA.

Environment: PL/SQL, SQL, Oracle 10g, Oracle 11g, linux/unix on VMWare, RMAN, Dataguard Physical Standby Database, Oracle Features (10g/11g), Oracle Diagnostic Tools, Toad, Spotlight for Oracle.

Confidential

• Oracle Database Administration Consultant (small DBA contracts)
• RAC implementation, installation, configuration, troubleshooting Duties included installation, configuration, administration and tuning of a multi­instance Oracle environment, including interpretation of user requirements to provide appropriate database solutions.
• I was also responsible for Oracle server upgrades; configuration and administration of NLS environment for multilingual databases; troubleshooting and resolution of database problems and bugs.
• Duties also included assisting developers and technical consultants with relational database design and with implementation, including query optimization and writing stored procedures.
• In addition, I created the DBAdmin tools, written in Perl and PL/SQL, to facilitate text­based administration of multiple concurrent Oracle instances.
• Wrote complex PL/SQL Stored procedures for OLTP/DSS database

Environment:: PL/SQL, SQL, Oracle 9i, Oracle 10g, Linux, RMAN, Dataguard physical and logical, Oracle Features (10g DB Monitor Expert) Toad tools.

Confidential, Boston, MA

Oracle DBA/ Architect

• RAC implementation, installation, configuration, troubleshooting
• Production administration for live Oracle systems simultaneously hosting several OLTP and DSS applications, with wide variations in load
• Designed, created, and maintained highly complex ETL / data reconciliation packages to carry out mixed load and reconciliation of data from several heterogeneous data sources into central financial database.
• Normalization and entity relationship mapping for the inter transportable data between the data warehousing and the OLTP databases,
• Extensive work with backend database tables of PeopleSoft
• Upgraded production and development systems from 8i to 9iR2
• Optimization, including optimization for mixed OLTP/DSS systems
• Tuning: I/O, memory usage, SQL optimization, rollback segment configuration and optimization; database init & configuration parameters; etc.
• Designed schema for inventory application in Oracle Designer, including data model;
• Designed and created ETL from static and warehouse sources for Data aggregation, rollup, and cubes. Optimization for both OLTP and DSS applications.
• Physical database design and configuration, including server configuration and future capacity planning
• Database backup and restore, including media recovery
• Coordinate and arrange cross­business­unit data flow with IT peers in other business units.

Environment: E-Business Suite, PL/SQL, SQL, Oracle 8i, Oracle 9i on Linux/UNIX, RMAN, Dataguard physical and logical, Toad for Oracle and DB Tuning Expert tool.