SUMMARY

• Senior Oracle Database Administrator with over ten years of Total experience.
• Experience in all Phases of Enterprise Database Lifecycle.
• Experience in HP - UX, Solaris, AIX, Linux and Windows platforms.
• Expertise in Production Support and High-Availability mission critical databases.
• Experience in supporting development projects and Teams.
• Experience in SQL, PL/SQL Development and Tuning.
• Strong experience in Oracle Performance Tuning.
• Expertise in UNIX Shell Scripting & DOS Scripting.
• Experience with RMAN, LogMiner, and FRA and Flashback databases.
• Experience with Streams Replication, Dataguard and Standby databases.
• Expertise in RAC administration, Grid Control, and ASM, experience.
• Experience in Data Warehousing, Partitioning, ETL, and OLAP.
• Expertise in Oracle Application Server, OID, OC4J, SSO, Forms, Reports, Oracle APEX.
• Expertise with Legato Networker, Vertias Netbackup, NetApp, Backup Exec and HP Omniback.
• Experience in SQL Server 2003/2005 and MS Access Database Administration.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i, 8i, SQL Server 2003, 2005.

Oracle Technologies: RAC, Data Guard, Replication, Streams, DBMS Scheduler, Data Pump, SQL*Loader, Oracle Data Warehouse Builder, Oracle Discoverer, OEM, Grid Control.

Back up Recovery: RMAN, Legato Networker, Symantec Back up Exec 12.5, VERITAS Net Backup, Openview Omniback, EMC Data Protection Advisor.

Tools: and Utilities: TOAD DBA Suite, DB Artisan, SQL Developer, ERWIN, Visio, Microsoft Project.

Operating Systems: HP-UX 11, AIX 6.1, Sun Solaris 10, RHEL 5.5, Windows 2003.

Oracle Applications: Forms, Reports, Developer Suite, Application Express 2.2.1/3.2, JDeveloper.

Middleware: Oracle Application Server 10g, Infrastructure Metadata Repository, Oracle Internet Directory, Oracle Single Sign-On, Web Logic Application Server, Sun One Application ServerApache HTTP Server, Jakarta Tomcat.

Programming Languages: SQL, PL/SQL, Java, C, Shell Scripting, Perl, Visual Basic, VBA, JSP, VB Script.

Versioning Control: PVCS 8, CVS, Visual SourceSafe, Serena Business Mashups, SVN.

Virtualization: VMWare, VSphere Console.

PROFESSIONAL EXPERIENCE

Confidential, Bethpage, NY

Senior Oracle Database Administrator

Responsibilities:

• Manage Oracle 11g, 10g databases in Development, Production, UAT and Training environments.
• Lead DBA to development teams in Cablevision and Offshore Project Teams.
• Supported Core Provisioning databases and also non provisioning databases.
• All the work involved standalone instances but also worked on a database assignment that involved troubleshooting of 11g RAC instances, ASM Installations, and Exadata database performance tuning.
• Install, Create and maintain Oracle 10g and 11g databases on Solaris, AIX, HP-UX and Linux.
• Set up standard monitoring scripts and auditing scripts.
• Install Grid Agents, Manage databases, and set up Grid Alerts using Grid Control.
• Register databases against OID. Resolve issues with OID.
• Monitor backups, Networker logs regularly.
• Set up EMC Data Protection Advisor reports for Backups monitoring.
• Perform Database Failovers, Recovery tests and Backups testing.
• Prepared database recovery documentation that included testing scenarios with RMAN, FRA, and Logminer.
• Support several development databases from inception until production releases.
• Work with development managers on database designs, Project plans and DB Link diagrams.
• Create scripts for DB Links and synonym checking,
• Deploy Builds in Production databases. Participate in Production Release meetings.
• Perform session monitoring, manage persistent sessions and perform Weblogic Pool Refreshes.
• Work with development Teams daily on various Database related issues.
• Implement and revise Database and Code design standards.
• Prepare Database Deployment Checklists and Installation Checklists.
• Perform SQL and PL/SQL Tuning. Debug and Troubleshoot procedures for performance.
• Use AWR, SQL*Trace, Explain Plan, ADDM and ASH reports for Performance Tuning.
• Setup and manage Backups and Monitoring and Maintenance Scripts and tasks.
• Set up RMAN Backup and Datapump backup scripts in databases.
• Perform Streams Replication between databases.
• Resolve issues with Streams and Auto Space Advisor.
• Create DBMS Scheduler Jobs, Programs and Windows.
• Set up and Monitor Database Replication Jobs and Scripts.
• Developed and deployed database scripts for batch loads.
• Monitor performance of Data loads, and Data Warehouse refreshes.
• Resolve issues related to Java, Appworx, and Shell script based applications on servers.
• Designed an efficient automation system for processing over 300 Database Backfill builds in Business critical IDA Training Project.
• Automation extracts DML, DB Link, and Synonym extracts using Korn Shell Scripts and applies on target databases.
• Automated TOAD Database Compare and Schema Compare operations on multiple schemas and databases.
• Repeated the automation procedure six times in one year successfully every time.
• Perform Database Auditing. Manage audit trails.
• Perform Log Miner analysis of databases.
• Changed Database Character Sets on Databases.
• Prepare Grid control templates, migrate existing shell scripts to Grid control.
• Generate Tablespace, Filesystem and other complex reports using Shell scripts.

Confidential, Boston, MA

Senior Oracle Database Administrator

Responsibilities:

• Lead Consultant responsible for migration of Oracle 10g Databases, Oracle Application Express (APEX) Applications, Oracle 10g Application Servers, Forms, Reports, and Infrastructure Servers with Oracle Internet Directory from Solaris 10 servers to Windows 2003 servers.
• Provided road-map for the migration. Developed Microsoft Project Plans and Migration Documentation.
• Migrated Production, Testing and Development Case Management and Trust Fund Systems from Solaris 5.10 to Windows 2003 servers on virtual machines.
• This migration was done altogether four times. It was repeated two times at the end of the project in order to verify the procedure. As part of this effort, a document was given to client detailing steps of the migration.
• Provided complete knowledge transfer, monitoring and backup scripts to the client.
• Installed, Patched Oracle Databases, Mid-Tier Application Servers and Infrastructure-Tier Application Servers on Windows 2003 servers.
• Installed and Administered Oracle Application Express 2.2.1 on Oracle 10g databases.
• Migrated APEX 2.2.1 Applications from Solaris Databases to Windows.
• Migrated Oracle 10g databases from Solaris 10 to Windows 2003 servers.
• Migrated 32-bit databases to 64-bit server.
• Between the migrations, database suffered from memory issues. Tuned 32-bit databases for performance. Changed /3G and orastack settings for continued performance.
• Migrated Metadata Repository databases from Solaris to Windows.
• Performed LDAP Migrations. Prepared LDIF Files for migrations.
• Implemented Oracle Single Sign-On with Oracle Application Express as Partner Application.
• Renewed Certificates on existing Solaris Production Servers.
• Implemented SSL using 10g Application Server Certificate Authority on Test and Development Windows Servers.
• Implemented SSL using VeriSign Certificate Authority on Production Windows servers.
• Converted Single Sign-On, APEX partner applications, Forms and Reports to work with SSL.
• Used Oracle Developer Suite 10g, Forms Builder, and Reports Builder.
• Debug/Troubleshooted PL/SQL Stored Procedures, Oracle Forms and Reports Code.
• Worked closely with application developers. Answer questions about creation of DB Links, database jobs and all other Oracle related questions for their application.
• Monitor/Tune performance using OEM, AWR, ADDM, TRCSESS, and Explain Plan utilities.
• Developed Oracle Forms and Reports Batch compilation scripts, Solaris Korn Shell scripts and several other Windows batch scripts.
• Design and test Backup and Recovery procedures for Oracle databases and application servers.
• Implemented RMAN and Datapump Backups. Used Flash Recovery Area for Storage.
• Integrate RMAN with Symantec Back Up Exec 12.5.
• Cloned Databases. Recover databases from cold and hot backups. Restore database and application servers from VMware clones.
• Performed Application Server backups, restore backups when needed.
• Tested Disaster Recovery procedures on Oracle Application Servers and Databases.
• Closely work with Network Services Team for issues resolution. Coordinate DMZ moves.
• Provided Oracle database knowledge transfer to the Manager of Application Development and the team continually.
• Performed routine Windows and Solaris System Administration tasks.
• Received Client appreciation for completing the projects successfully within budget and timeframe.

Confidential, Alexandria, VA

Senior Database Administrator

Responsibilities:

• Administered and supported Oracle 10g, 9i, 8i high availability databases in production, development and UAT.
• Manage Time and Attendance, Payroll, H.R. databases and data warehouses.
• Managed over 300+ databases on Solaris, Linux, Windows 2003 Server environments with sizes up to 2 + T.B.
• Participate in Design and Deployment meetings. Work with Project Teams.
• Installed, created and managed databases. Created monitoring and backup infrastructures.
• Perform data refreshes and loads.
• Perform Database Restore and Recovery testing periodically.
• Upgraded 8i and 9i databases to 10g.
• Administered RAC databases using 10g Grid control.
• Managed OCR and voting disks on OCFS partitions. Sized disk spaces, set up oracle environments.
• Monitored network, I/O and disk performance.
• Managed RAC services, tested TAF and monitored FAN events.
• Managed instances using SRVCTL and 10g Grid control.
• Managed RAC backups. Perform rolling upgrades.
• Installed and configured ASM instances. Configured Oracle Clusterware.
• Installed grid control agents on servers. Setup OEM alerts.
• Managed RMAN backups and catalogs.
• Created logical Standby databases using RMAN.
• Monitored Streams replication and Standby database replication using 10g Data guard.
• Tuned performance of 10g databases using Grid control, AWR, ASH and ADDM reports.
• Tuned 9i, 8i databases using STATSPACK reports.
• Tuned SQL queries using EXPLAIN PLAN, SQL*Trace, Stored Outlines and 10046 trace reports.
• Tuned performance of batch jobs and PL/SQL.
• Coded SQL*Loader scripts for data loading.
• Developed and Implemented Triggers for change logging in tables.
• Created and scheduled Materialized View jobs for data warehouse loads and refresh.
• Managed DBMS Jobs and DBMS Scheduler Jobs.
• Administered Sun One Application servers, deployed Web applications.
• Set up Performance Statistics collections, JDBC connection pooling and LDAP.
• Configured web servers to accommodate growing user base up to 7000+ users.
• Administered SQL Server 2003/2005 databases and backups.
• Developed and implemented a backup and recovery plan for production SQL Server databases.

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

• Administered and support mission critical production E9-1-1 Oracle 8i databases in primary standby environment.
• Performed Oracle DBA and HP-UX System Administration tasks.
• Monitored database replication using Oracle 8i Dataguard.
• Resolve all issues with Standby database.
• Instantiated physical standby databases. Activated managed recovery after reporting windows.
• Monitored archive log transfer between primary and standby databases.
• Managed database links. Optimized data transfer processes over database links.
• Coded PL/SQL and complex SQL queries for various data analysis tasks.
• Monitor database objects free space, perform tablespace defragmentation regularly.
• Instrumental in upgrade of Oracle databases from 8i to 9i release.
• Instrumental in providing a Road Map and prepared migration documentation for HP-UX operating systems upgrade from 32-bit to 64-bit release.
• Coordinated with Stratus Corporation, HP-UX systems vendor.
• Actively involved in HP-UX systems administration and performed admin tasks.
• Used SAM, iostat, vmstat, PerfView and Glance Plus utilities for performance monitoring.
• Monitored swap, CPU and I/O performance.
• Performed in-depth swap analysis determining whether or not more swap memory was need for Oracle databases.
• Maintained Operating System shutdown and startup shell scripts.
• Tuned Performance of 3rd party vendor applications.
• Used 10046 trace reports, SQL*Trace and Explain Plan utility for tuning SQL statements and sessions.
• Analyzed STATSPACK reports provide recommendations to the Team Lead and Vendors.
• Recommended database best practices.
• Conducted disaster recovery tests. Updated disaster recovery documentation.
• Developed a complex set of UNIX shell scripts for application/database/server housekeeping.
• Provide 24x7 on call support.

Confidential, Southfield, MI

Database Administrator

Responsibilities:

• Managed 30+ Oracle 9i production, development and QA databases on AIX and Windows machines.
• Performed data modeling with ERWIN.
• Implemented 100+ table detailed implementation data model.
• Designed and created Oracle 9i databases on AIX and Windows machines.
• Structured business requirements and designed OLTP ER logical data models
• Performed forward and reverse engineered models using Erwin.
• Create Databases, Schemas. Perform Schema refreshes.
• Performed database migrations and refreshes using Export-Import.
• Coded Shell scripts for various load and refresh jobs.
• Apply Database Patch set upgrades and CPU Patches.
• Maintained database audit profiles, managed audit trails.
• Refreshed development and testing databases.
• Setup and monitored RMAN hot backups.
• Managed indexes, database extents, tablespaces sizes and DB Links.
• Managed database jobs and alerts. Partitioned database tables and indexes.
• Performed database backups, cloned databases.
• Performed RMAN Backup recovery tests and prepared documentation.
• Analyzed STATSPACK reports explain plans and trace reports.
• Tuned performance of databases, and SQL performance using Explain Plans, Stored Outlines.

Confidential

Database Administrator

Responsibilities:

• Administered Oracle 9i and SQL Server 2000 databases. Designed and developed a database for a highly transactional financial application.
• Designed Logical and Physical Data models. Analyzed Use cases. Developed customized ERWIN relational data model for capital calculation (80 entities) and regulatory reporting (50 entities).
• Installed and Created Oracle and SQL Server 2000 Databases on AIX and Windows machines.
• Cloned databases, performed data transfers, managed users, table spaces.
• Developed and optimized SQL Server 2000 database structures, T-SQL stored procedures, views, triggers and user-defined functions in a highly-transactional financial application.
• Tuned SQL & PL/SQL scripts for better performance.
• Developed and implemented a backup and recovery plan for production SQL Server databases.
• Performed SQL Server database imports using Data Transformation Services.
• Scheduled and monitored all maintenance activities of SQL Server including database consistency check, and index defragmentation.