SUMMARY:

• Oracle / Database Specialist ~ Information Technology ~ Strategic Planning
• Self - motivated and results-driven in technical operations with 19+ years of IT experience as Oracle DBA and 2+ Years of SQL Server DBA.
• Currently supporting 24x7 high availability Oracle 11g/12c Databases within the high visibility Trading Domain environment at a leading Financial Firm.
• Expert in Standby / Data Guard, Real Application Cluster (RAC) and Automatic Storage Management (ASM) support and implementation.
• Oracle 8i, 9i RAC, 10g RAC, 11g RAC, 12c 9i Data Guard, 10g Data Guard, 11g Data Guard 12c Data Guard
• Oracle 9i, 10g, and 11g, 12c DB Support GRID Control Support and Configuration
• Installation, Upgrade, and Migration RMAN Backups / BMC SQL Backtrack
• Oracle Golden Gate Replication Data Warehousing, OLTP and Partitioning
• Performance Tuning Audit Control / SOX Compliance
• EMC BCV Implementations Automatic Storage Management (ASM) Support
• Data Guard Broker Configuration Oracle Flashback Database - Recovery Area
• Dynamic technical career with strong leadership, problem-solving, planning, team-building and project management skills. Recruit, develop, motivate and retain diverse staff structuring them in teams that deliver results and savings. Full responsibility for designing and building multi-million-dollar budget oracle architectures.

AREAS OF EXPERTISE:

Oracle 9i, 10g, & 11g, 12c RDBMS Server * Oracle Services MS-SQL Server 2000 / 2005 / 2008 / 2012 * Data Warehousing Oracle 9i RAC, 10g RAC, 11gR2 RAC, 12c RAC * Performance Monitoring Data Security * Database Monitoring Data Modeling * Audit/Risk Compliance (SOX) SQL*NET Configuration * OLTP / Warehouse Database Design UNIX, AS400, Sun AIX, RedHat Linux, CENTOS * Project Management MS Windows HTML, ASP.NET * Microsoft SQL Server Management Studio Oracle Infrastructure Design * Microsoft SQL Server Enterprise Manager Unix Shell Scripting * SQL Server Transactional / Snapshot Replication PL/SQL Programming * Golden Gate Replication Oracle Data Guard * Oracle Active Active Data Guard Oracle 11gR2 Advance Compression

TECHNICAL SKILLS:

Hardware: SUN-ULTRA, HP 9000, SUN E5K/E10K, SUN 2900, Confidential RS6000, SUN CLUSTER 2.2, SUNT5240, EMC Storage Devices including BCV Split Technologies, Oracle Exadata Suite of Appliances

O/S: Solaris 5.x, Windows Server Family, Linux(Redhat/Suse), HP-UX 10.x/11.x, AIX 4.3 5.x, zLinux

Languages: SQL, PL/SQL, UNIX SHELL SCRIPTS, HTML, C#

RDBMS: Oracle 7.3.4/8.0.5/8.1.6/8.1.7/9.2/10.2.0.3/11.2.0.4/12.1.0.2/12.2 , SQL Server 2000/2005/2008/2012

GUI: Oracle OEM / 13c/12c Grid/Cloud Control/12cGrid/Cloud Control, DB Artisan, TOAD, SQL Developer

Tools: RMAN, OEM, SQL*Loader, Export/Import, SQL*Net, expdp/impdp, BMC SQL BackTrack, BMC Patrol, SharePlex, Golden Gate Replication, BMC BDA

MANAGEMENT SKILLS:

• Technology Architecture & Integration Leading Edge Software Development
• Global IT Delivery & Project Management Electronic Commerce Strategy/Development
• Budgeting and Cost Control Staff Management & Team Building
• Organization & Staff Development Strategic Analysis & Internal Consulting

EMPLOYMENT HISTORY:

Sr. Oracle DBA

Confidential, New York, New York

Responsibilities:

• Upgraded 12, 3 - Node RAC environments from 10gR2 databases to 11gR2 and eventually to 12.2
• Worked on building large Exadata system to create internal cloud system to service different departs database needs.
• Once 12.2 was setup, created CDBs for different line of businesses with many PDBs within the CDBs.
• Implemented central grid control to monitor all production environments.
• Installed 4 sets of 3 node 12cR2 RAC cluster on Redhat Linux with data guard implementation and SRDF.
• Configured Active Active 11g/12c Data Guard for reporting database.
• Worked with UNIX admins to implement Huge Pages for maximum benefit of 500Gig SGA
• Created Standard for Oracle 11g/12c Data Guard implementation.
• Moved a 3 Node cluster to a 2 Node Redhat Cluster (non - RAC) database after upgrading to Redhat Cluster
• Wrote refresh scripts for development database refreshes.
• Implemented Advance compression to save 70% space while increasing select query responses. In exadata did HCC.
• Implemented Secure Files with advance compression for LOB compression to save storage.
• Setup jobs via Autosys for rman backups, monitoring, and various maintenance scripts.
• Worked on setting up Datical software for change control and source code version control system.
• Implemented DBMaestro with development team for version control for PL/SQL code for reporting database.
• Deployed Database installation with BDA (Bladelogic, Database Automation) for smaller databases.
• Configured database services to balance connection to databases via SQL*Net.

Consultant - Sr. Oracle DBA

Confidential

Responsibilities:

• Supported over 100 Databases 24/7 for Qwest & Honeywell clients.
• Improved performance for users utilizing 10g features.
• Supported 9iR2 two Node RAC on Linux.
• Created Standard for Oracle 11g Data Guard implementation.
• Used RMAN to clone database and extensively used datapump for refreshing non - prod databases.
• Wrote and implemented expdp/impdp scripts to refresh DEV and UAT environments from PROD.
• Implemented userid s to authenticate via OID.
• Generated AWR/ADDM/ASH/explain plan/Grid control and performed application and database tuning.
• Setup standard automated RMAN backups as well as backups utilizing Flash Recovery Area.
• Introduced scripts to better manage cleanup of archive logs with primary and standby database.
• Implemented & supported Oracle 10g Data Guard & broker for DR site.
• Performed Disaster Recovery utilizing Oracle s Flashback Technology.
• Maintained and generated partitions for large db s with range type partitioning.
• On call 6 days a week for production databases fixing space issues, performance issues, and any other oracle related issues.
• Provided Oracle database administrative supports for various Oracle applications.

Consultant - Sr. Oracle DBA 10/07 - 08/08

Confidential, Princeton, NJ

Responsibilities:

• Upgraded Oracle 9i database to 10gR2 using DBCA.
• Installed and configured Oracle 11g for future Grid upgrade of current environment.
• Upgraded SQL Server 2000 to SQL Server 2005 using migration utility.
• Setup RMAN backups utilizing Incremental feature performing Level 0 on weekend and Level 1 during weekdays.
• Implemented Data Guard as disaster recovery strategy.
• Setup SQL Server replication using Transactional processing using pull subscription method.
• Designed database to accommodate inventory management system.
• Designed and architected database for Small Business Ownership Project for Guardian and their business customers.
• Applied latest security patches for both Oracle and SQL Server databases.
• Setup and configured Sql Server Reporting services.
• Automated refresh of databases from UAT to Development environment on a weekly basis.
• Setup Oracle Streams on database that did not require full refresh.

Consultant - Sr. Oracle Systems DBA

Confidential, Rochelle Park, NJ

Responsibilities:

• Migrated Oracle 9i database to 10g. Created plan to migrate legacy systems to meet support requirements with SLA between Oracle and PSEG.
• Trained PSEG employees with new Oracle features in 10g as well as Data Guard setup in 9i for better management.
• Fine - tuned existing Oracle RAC environment and implemented Data Guard for disaster recovery.
• Setup SQL Server replication using Transactional processing and snapshot processing over two remote sites.
• Responsible for Oracle 10g Installs on UNIX Sun 3500 Servers and created new standards for Oracle 10g.
• Configured and setup Oracle 10g Grid control for monitoring over 40 servers.
• Applied latest security and vulnerability patches on both Oracle and SQL Server (SP4) databases.
• Installed SQL Server 2000 / SQL Server 2005 on Dell Servers and configured automated backups and monitoring.

Sr. Oracle System DBA

Confidential, Warren, NJ

Responsibilities:

• Developed and implemented environments to ensure attainment of business plan for growth, profit, and branding. Responsible for IT DSS department, development, and supporting the organization s structure, strategic growth plans, all operational policies, and procedures.
• Managed a team of 16 Oracle Database Administrators with respect to project management, time - off, and personal achievement onsite and managed 7 Offshore dba s in India for night and weekend support.
• Hire and manage geographically dispersed staff of differing cultures and weave them in teams. Initiated and developed in-house training that enabled timely and cost-effective delivery of end-user applications.
• Responsible for Oracle 8i / 9i and now 10g software installs. Maintenance and improvements of production oracle database services via latest patch sets and vulnerability threats.
• Installed Oracle on development, staging and production environments; installed Oracle OCFS, 9i, 10g on Linux RHAS
• Installed Oracle Enterprise Manager to manage 2-node Oracle 9i RAC cluster environments and defined Oracle
• RAC best practices on Linux.
• Installed Oracle 10.2.0.2 RAC / CRS on 2 node AIX cluster using Veritas Clusterware on EMC storage. Configured
• GRID control to manage cluster and performance. Setup automated RMAN backups.
• Setup Oracle 8i, 9i, 10g Data Guard using a manual method as well as the broker. Resolved out of sync issues due to network outages. Created Unix shell scripts to automate cleaning of archive log.
• Improved performance on sensitive tables by evaluating stat plans, execution plans, indexes, and validating partitions.
• Lead operational audit in a project management capacity to address internal and SOX compliance. Analyze information, business processes and new systems. Assisted in the assessment and management of business and risk, made recommendations on improving internal controls and provided bottom-line oriented solutions.
• Created platform and published white papers for internal and external distribution. Effectively directed, influenced, developed, and motivated subordinates, obtaining positive team solutions.
• Performed capacity planning and setup database monitoring via BMC patrol and Confidential Tivoli. Adjusted parameter based on size, raw devices, upgrades, etc
• Registered new services and nodeapps for RAC to failover and switchover RAC automatically using Data Guard Broker.
• Wrote extensive PL/SQL and Unix Shell script programs for various different purposes including that of collecting all audit information from over three hundred database instances. Wrote generic Unix Shell scripts to perform backups and cleanup of old log files and other maintenance purposes.

Sr. Oracle Database Administrator

Confidential, Montvale/Paramus, NJ

Responsibilities:

• Designed backup strategy, creating scripts using UNIX shell; used UNIX cron for scheduling.
• Installed Oracle 8i on UNIX and NT platforms, and created databases, schemas, users, and other Oracle objects in development and production environments.
• Created snapshots in the reporting databases, monitored the replication processes and resolved any related issues.
• Resolved major performance issue by creating 11 listeners temporary during heavy Christmas season to load balance ver two hundred hits per second.
• Installed and configured Shareplex to replication production database for reporting purposes.
• Successfully created and deployed the infrastructure utilizing LAN/WAN for load balancing over 500 concurrent users per second. Developed and initiated data/Internet security, auditing, and best - practices procedures.
• Created a platform and published white papers for internal and external distribution.