SUMMARY

• Support, maintain, and install Oracle 11g and Oracle 12c RAC databases on LINUX Servers
• Worked on Upgrade to Oracle12c from Oracle11gR2
• Configured ASM disk storage
• Installed and configured Oracle Enterprise Manager 13c
• Worked on Database performance and tuning
• Used tools (TOAD, DBArtsian, Foglight) for database maintenance
• Used AWR, ASH and ADDM reports for baseline and performance monitoring
• Created SQL and PL/SQL script to modify data per user request
• Worked on capacity planning and tuning
• Self - motivated and execute tasks in high pressure environment
• Worked on NetBackup backup and storage
• Worked on logical and physical database design
• Configured Link server to connect SQL server 2012 to oracle 12c
• Configured Direct connect to connect Sybase 15.7 to Oracle 12c
• Worked on SQL Server 2012 and 2008
• Create and maintain User Management and Database Security
• Working on Mission Critical systems People Soft Financials
• Used RMAN with RMAN catalog to backup and restore all critical system
• Used Flashback to restore tables
• Used Datapump to Export and Import
• Create duplicate databases from Production RMAN Backups on same server or different servers
• Ensure databases adhere to corporate standards and policies including database auditing requirements
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation
• Maintained currency with periodic Oracle Critical Patches
• Developed LINUX scripts for database performance and monitoring
• Perform production system problem analysis and recommend corrective measures in a timely manner
• Work with external vendors to support their applications
• Mentor and Train team members
• Provide onCall support after hours
• Worked with internal and external IT Auditors
• Support, maintain Sybase 15.7

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Production DBA

Responsibilities:

• Support, maintain, and install Oracle 9i; 10gR2 and 11gR2 databases on UNIX AIX and Windows Servers
• Installed and configured Oracle Web Logic
• Installed and configured Oracle Internet Directory (OID)
• Created SQL and PL/SQL script to modify data per user request
• Worked on capacity planning and tuning
• Worked on logical and physical database design
• Worked on SQL Server 2008 and knowledge and maintain Perl scripts
• Create and maintain User Management and Database Security
• Installed, configure Business Intelligence Reporting Services on SQL Server 2008
• Working on Mission Critical systems (payroll, time entry and police information systems)
• Used RMAN with RMAN catalog to backup and restore all critical system
• Used Flashback to restore tables
• Create duplicate databases from Production RMAN Backups on same server or different servers
• Ensure databases adhere to corporate standards and policies including database auditing requirements
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation
• Configure Enterprise Manager Database Control feature
• Maintained currency with periodic Oracle Critical Patches
• Developed UNIX scripts for database performance and monitoring
• Perform production system problem analysis and recommend corrective measures in a timely manner
• Work with external vendors to support their applications

Confidential

Oracle Production DBA

Responsibilities:

• Support and maintain 13 Oracle Databases including 7 production
• Manage large partitioned databases on Windows 2003 platforms
• Ensure databases adhere to corporate standards and policies including database auditing requirements
• Work with developers and change management team to ensure smooth life cycle progress from development through testing and production implementation
• Install Oracle 8i, 9i and 10g software
• Create 10g database and configure Enterprise Manager Database Control feature
• Upgrades from version 8.1.6 to 8.1.7.4 and from 8.1.7.4 to 9.2.0.3
• Upgraded 9i databases through version 9.2.0.7
• Maintained currency with periodic Oracle Critical Patches
• Developed scripts for database backup and recovery including hot and cold backup
• Perform production system problem analysis and recommend corrective measures in a timely manner

Confidential

System Analyst/Project Leader

Responsibilities:

• Implemented Agency wide Intranet Client/Server CBS System using Oracle 8.0, JAVA, VB Script on NT Server
• Evaluate technical description deliverables, and system work plan on CBS System
• Evaluate hardware and software for new CBS system
• IDP'S and Infrastructure for Health and Safety System
• Working on Data Modeling for H&S System using Oracle 7 and PeopleSoft

Confidential

Database Analyst on IBM 3090 Mainframe

Responsibilities:

• Plans, monitors, and executes changes to the department’s ADABAS COMPLETE and CICS system tables to ensure that the system operate efficiently
• Establishes new programs and files in the database executes
• ADABAS, PREDICT, and COM-PLETE system utilities to monitor the Database
• Conducts feasibility studies and make technical recommendations to system development staff concerning the most efficient means for accessing, and securing the database, to ensure that system will operate with minimum on-line response time and at minimum cost
• Develops and monitors the implementation of operational modification to the database system to
• Ensure that all changes are implemented properly
• Provide technical support to application development staff during coding and testing of programs
• Updates PREDICT data dictionary; develops backup, recovery, and restart programs and procedures for database application
• Develops system and software for end users using COBOL and NATURAL
• Maintain Client/Server system using Adabas/natural with OS/2; Used SQL
• To retrieve data from Oracle Database
• Used Microsoft Access to create tables Views and Reports
• Worked Independently in Analyzing, Designing, Coding, and Testing Programs for FINDS System