SUMMARY:

• Oracle certified DBA with over nineteen (19) years of IT experience including eighteen (18) years as an Oracle DBA
• Proficient with Oracle 6 - 12C, Enterprise Manager, Oracle Parallel Server/RAC, Data Guard, Recovery Manager (RMAN) and EMC/SAN storage Inc. using replication technology i.e. SRDF, Golden Gate, Oracle Streams, forms, reports and PL/SQL
• Solid Oracle DBA experience, large scale Oracle development and production support, full systems lifecycle
• Excellent commercial experience with utilization of leading-edge technologies
• A good understanding of delivering local and global systems from in-house to vendors supplied
• Planned and implemented new database builds, upgrades and maintenance
• Proactive at applying and enhancing standards and procedures, including security and auditing strategies
• Experience in managing databases from small schema to Terabytes ones with advance features such as Oracle replication, Oracle partitioning, etc.
• Experienced in writing and installing scripts for database administration tasks.
• Strong experience in installing, configuration, upgrades, patching, cloning, performance tuning, backup and recovery, disaster recovery and troubleshooting the various DB categories
• Excellent leadership and interpersonal communication skills

TECHNICAL SKILLS:

Development: PL/SQL, PRO*C, C

Technologies: ASM, RAC, Golden Gate, Oracle Streams, Veritas Clusters, Data Guard, RMAN, Oracle Application Server

Operating Systems: Linux AIX, Linux, HP, Sun Solaris

Databases: ORACLE, SQL Server, Sybase, Times Ten, MySQL

Tools: Platinum Erwin, Princeton OPTIM, OWB, Fog light, Spotlight, Toad, OEM, VSS, Developer 2000, Remedy, ECMS, Alacrity, Service Now

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA Consultant

Confidential, Charlotte, NC

Responsibilities:

• Worked with the engineering team as a consultant supporting architecture, design, reviews and developed best practices, automated processes, troubleshot issues, performance tuning, communicated and managed the expectations on a day to day basis with various stake holders
• Coordinated the IT projects including tracking projects through Life cycle, administration of weekly project team meetings and management of project reporting
• Performed analysis and reported the monthly metrics including preparation of scorecards, dashboards and Root Cause Analysis, identifying trends and provided recommendations for improvements
• Established infrastructure requirements, identified methods of collection and data entry, provided quality control and created distributed channels for reporting purposes
• Managed cloud control hygiene by identifying gaps in configuration and data, reports and worked towards resolutions
• Reduced database alerts across the state to minimalize by identifying common issues, provided solutions and shared with the infra teams
• Reviewed the database capacity using scripted reports and collaborated with the stakeholders to procure relevant storage across the state
• Managed different kinds of storage related processes for ASM/ACFS/DBFS NAS/SAN
• Tracked and designed database report cards to share with applications and business teams on issues observed, progress made and accomplishments for the last quarter
• Troubleshot major issues which surfaced over the period and collaborated with various stakeholders and vendors to work towards solutions while tracking the progress and managing expectations with regular meetings
• Tuned databases and infrastructure to enable the customers to save on hardware costs and enabled low latency applications
• Automated the monthly backup and refreshed the processes across Confidential estates saving dollars and setting standards for the firm while reducing overall time by more than fifty percent
• Participated in firm events and projects like business continuity tests, OS Patching, SAN refresh, hardware refresh etc., providing insights where required to improve overall setup
• Ensured all databases were compliant with regulatory and statuary requirements and Confidential CREF compliance policies and procedures
• Managed the solution release processes between database engineering and database operations providing documentation and training as appropriate

Environment: AIX, Linux, Oracle 12C, 11i, 10G, 9i Database Servers, Delphix, Exadata, RAC, Data Guard, ASM, RMAN, Golden Gate, Oracle Streams, Oracle Enterprise Manager, Rochade, Optim, Cyberarc

Vice President, Production Infrastructure Support

Confidential

• Production infrastructure team supporting 7 LOB (FO, Equities, Prime Brokerage, Core Processing, CASH, Credits and Rates) with over 800 in production, UAT and Dev databases.

Environment: Solaris, Linux, Oracle 11i, 10G, 9i Database servers, SQL Server 2005/2008, Sybase 12.5/15.x, Oracle Application Server, Timesten 7.x and 11.x, RAC, Data Guard, ASM, RMAN, Sybase Replication Server, Microsoft SQL Server (Windows Clustering, Log Replication), SRDF, Oracle Enterprise Manager, Fog Light

Sr.Oracle DBA

Confidential

• Credit Risk Management System (CRMS) has been built to provide a comprehensive risk and limit monitoring with flexibility in viewing exposure information. Provides information on counterparties for all products involving credit risk used for trade capture.

Environment: IBM AIX, Solaris, Oracle 9i Database server, RMAN, Data Guard

Sr. Oracle DBA

Confidential

• FOCUS 3 is an application catering to the costing functionality built upon existing Atlas BD1 operational functionality (FOCUS 1). It has interfaces to PeopleSoft AP (FOCUS 2), and the ICR (Interim Cost Reporting) in Europe

Environment: IBM AIX, Oracle 9 Database server, Forms 6i, PRO * C, Oracle 9 iAS, Oracle Enterprise Manager

Sr. Oracle DBA

Confidential

• The crew management system was built to automate the entry and maintenance of crew personnel working on ships. It helped to maintain the time slots of crews working on ships. Forex System was built to crew manage the foreign exchange transactions on the ship

Environment: Windows NT, Oracle 8i Database server, Forms 6i, PRO * C, Oracle 9 iAS, Oracle Enterprise Manager, Toad

Sr. Oracle DBA

Confidential, Seattle, WA

• The project involved creating the Oracle database for the REI application systems, designing objects using Erwin, creating objects and writing the PL/SQL procedures and control file scripts to map data from SQL Server to the Oracle database

Environment: NT, Oracle 8i, SQL Server 7.0, Oracle Enterprise Manager, SQL * Loader, Platinum Erwin, PL/SQL