SUMMARY:

• An Oracle DBA with over 20 years of experience providing technical support in all phases of SLDC managing RDBMS projects with a diverse and dynamic career and extensive experience in planning, implementation and problem solving with great attention to detail, while managing and working with large teams.

TECHNICAL SKILLS:

Operating Systems: Windows NT/ 2000/2003/2008/ XP/7, UNIX (Sun Solaris, HP - UX, AIX), Linux

Databases: Confidential 7.x, 8i, 9i, 10g, 11g, 12c, SQL Server 2000, 2005

Confidential Utilities and Tools: Exp/Imp, DataPump, OEM/Grid Control, SQL*Loader, tkprof, XPlan, STATSPACK, AWR, ADDM, ASH, RMAN, DataGuard, RAC/ASM, SQL Developer

Networking: Telnet, ftp, scp, pcAnywhere, Terminal Services, VPN, Exceed, PuTTy, CygWin, VisionApps, SecureCRT, SecureFX, Citrix

Data Applications: ERWin, Designer 2000, Developer 2000

Third Party Tools: Spotlight, Space Manager, Schema Manager, SQLabXpert, TOAD, Quest Central, DBArtisan, Big Brother, Control-M, Autosys, UltraEdit, UltraCompare, BMC Patrol

Version Control and Ticketing Systems: Microsoft VSS, Confidential Rational ClearCase & ClearQuest, Remedy, PVCS

PROFESSIONAL EXPERIENCE:

Confidential,Columbia,SC

Responsibilities:

• Supported production and non-production databases for Confidential .
• Performed schema refreshes using Data Pump between Solaris and Linux with Confidential versions 11g and 12c.
• Troubleshot Data Pump export/import.
• Worked with the SAs, DBAs, Developers and the Management team.
• Use of LDAP and secure systems.

Confidential

Lead Oracle DBA

• Provided 24*7 support of Confidential 11g production and non-production databases on AIX for their client, Banorte (Federal Reserve Bank of Mexico), onsite at their headquarters office in Mexico City, Mexico, and remotely from the US.
• Planned and implemented partitioning of tables and indexes in Banorte’s various DW systems, including the physical and logical design and performance tuning.
• Reviewed, recommended and implemented changes to the database structures and documented them.
• Mentored, managed, trained DBAs and application developers working on OLTP systems with the differences between DW and OLTP systems.

Confidential,Rockville,MD

• Performed migrations of databases from Confidential 10g to Confidential 11g onto Confidential Exadata or Sun Superclusters located at the Confidential data center using Data Pump.
• Assisted in the migrations of databases using RMAN for larger databases.
• Migrated OLTP and DW databases with table and index partitions.
• Used customized templates to create the target databases based on the Confidential components installed in the source databases before migrations as per Confidential standards, regulations, security, policies and procedures.
• Worked with the Migration Team, their Team Leads and SAs and coordinated the migrations with the Applications DBA Team.
• Performed validation reports comparing the source and target databases after migrations and trouble shot related issues.
• Used Confidential Wallet and Transparent Data Encryption (TDE).
• Exposure to Confidential 12c.

Confidential,Baltimore,MD

• Worked directly with Sr. Confidential DBAs, SAs, Clients, Developers, PMs, Design Engineers and the Production Engineer.
• Managed WPO and WISE projects.
• Administered Confidential 10g on Solaris and Confidential 11g on AIX DW databases with table and index partitions and addressed performance issues on RAC with ASM, DataGuard, Flashback and Confidential Wallet of up to 1 TB in size.
• Created and configured Development, SVT and QA databases on AIX using customized templates.
• Performed data migration from Windows and Solaris to AIX using DataPump.
• Installed Confidential 11g and upgraded databases within 11g on AIX.
• Implemented RMAN scripts for the newly created databases and configured Control-M for the same.
• Performed schema comparisons between Development and SVT environments for schema changes and before data migrations.
• Troubleshot issues and problems with the various aspects of the Confidential database.
• Assisted developers with tracing and generating tkprof and AWR reports for analysis.
• Provided support during off-peak hours and weekends.

Confidential,Columbia,MD

• Managed MyMicros, MyInventory, Simphony, Fidelio and Opera systems which are Point of Sale and Property Management applications used by various hospitality businesses like restaurants, hotels, cruise lines and specialty retailing.
• Provided 24*7 support and reported to the Operations Manager and the VP of Operations.
• Checked daily RMAN reports and provided a status update to the higher management.
• Installed Confidential 10g cluster, ASM and database on Windows 2003.
• Configured and troubleshot Grid Control issues.
• Administered and managed 20+ RAC production databases of sizes up to 10TB DW databases with table and index partitions in various datacenters.
• Managed 4 mission critical 4 node clustered DataGuard environments, ensured synchronization between the primary and standby database, and performed manual intervention when required.
• Assisted the application developers with performance issues and database change requests.
• Coordinated system maintenance with Support Specialists and System Engineers.
• Managed space allocation and worked with the Storage and Network Engineer.
• Performed database refreshes using RMAN and created standby databases.
• Assisted the SQL Server DBA as and when required and performed simple tasks with the SQL Server databases.
• Conceptual knowledge of GoldenGate.

Confidential, Baltimore,MD

• The Federal CMS project required the decoupling of QIPS and CrownWeb applications, followed by the creation of the QIMS environment for the Facility and Organization data. The project required interfacing with Edaptive Systems and CSC for application development and with BCSSI for infrastructure and security.
• Created an environment for Data Conversion and implemented Materialized Views for data replication.
• Worked directly with the PM and maintained the project time line.
• Provided support for Development and QA environments for Confidential 10g databases on Solaris 10.
• Assisted developers with the creation of database objects, schemas and data loads using DataPump or with TOAD.
• Implemented a backup strategy using DataPump.
• Managed and troubleshot Confidential Connection Manager on proxy servers and database servers.
• Use of LDAP.

Confidential,Columbia,MD

• Provided 24*7 support for various Confidential 10g Development, QA and Production databases on HP-UX v11 and Linux RAC DW databases sizes of up to 10 TB with table and index partitions.
• Used OEM, TOAD, RMAN.
• Setup blackouts in OEM for scheduled RMAN backups, database and server maintenance.
• Assisted application developers, clients, maintained security as per business requirements and addressed performance tuning issues.
• Performed schema refreshes between the HP-UX systems and Linux using Data Pump and assisted in the migration from HP-UX to the Linux RAC system.
• Made database changes and performed deployments in production and non-production environments.

Confidential,Gaithersburg,MD

• Provided 24*7 support for a 2 node, 10TB IAT/UAT RAC for the eCAMS application for processing Medicaid and Medicare claims for the State of Washington (WA MMIS ProviderOne), at the Sun ITF data center, and a 2 node, 20TB RAC system of the Production, Pilot, Performance, Stage, and the Disaster Recovery databases at another datacenter.
• Supported Siebel, Data Conversion (DataStage/Ascential), Cognos and DW databases.
• Created a physical standby database using DataGuard, performed various tests, including manual switchovers and failover using SQL, DG Broker and Grid Control. Prepared a formal documentation for the higher management and the State of WA.
• Configured and administered Grid Control on Windows 2003.
• Worked with the SA, CM, DM, DC, Storage & Network, Chief Architect, VP of Infrastructure and the application development teams. Each application development team work on subsystems like Claims Processing, Prior Authorization, Managed Care, HIPPA, Providers, Provider Registration and Confidential Financials.
• Addressed issues between CNSI and Sun Managed Operations (SMO) and resolved Incident Tickets created by SMO.
• Created new schemas and performed schema refreshes using DataPump.
• Worked with the DBAs and the Infrastructure team for RMAN, DataGuard, Flashback, Flash Recovery Area, space allocations, capacity planning and physical and logical design. Used Solaris 10 (64 bit) for Confidential 10g.
• Assisted the Performance Benchmark Team and addressed performance issues.
• Secured PHI data and implement security standards and protocols based on federal and client/state requirements.
• Prepared table and index partitioning scripts for implementation in various environments.
• Implemented plans to archive claims data, based on the requirements of the State of Washington for auditing and reference.
• Documented setups and configurations for all environments. Streamlined best practices for the DBAs in the WA team.
• Provided conceptual and hands-on training while mentoring other Confidential DBAs.
• Created and administered Confidential 11g databases on Solaris for testing, development and demo environments for the South Dakota (SD MMIS ProviderOne) project.

Confidential,Suitland, MD

• Supported the WebCATI, ROSCO, CAPI, MCS, DAD and CARMN applications in distributed environments.
• Administered Confidential v7, 8i, 9i and 10g databases on Solaris 7 on a VCS cluster.
• Performed SQL tuning and used STATSPACK, Xplan and tkprof for performance tuning.
• Troubleshot and investigated database issues, bugs and errors.
• Implemented user requests and database changes with respect to CIS Benchmark protocol.
• Deployed new builds in production and non-production databases for the WebCATI and MCS applications.
• Created, configured, administered and managed physical standby databases using Confidential 9i and 10g DataGuard on Solaris 9 in test environments. Performed various tests and documented the tests and their results.
• Administered and performed tests on a 6 node Confidential 10g RAC database with ASM on RH Linux.
• Safeguarded and protected Title 13 data as outlined by the US Federal Law.

Confidential,New York,NY

• Supported global applications, such as PME, MIF, TRBIS, ICLNT and IDEAL
• Created and administered existing and new Staging, UAT and Production environments based on corporate standards.
• Worked in conjunction with application owners, SCM's, SA's, developers and the offshore ADC team.
• Administered Confidential 9i databases on Solaris and implemented security and auditing for all databases.
• Provided 24*7 support for all databases including production and non-production environments.
• Worked with application developers with releases in Staging, UAT and Prodution releases.
• Used Remedy, TeamQuest, STATSPACK, OEM, Precise, Spotlight, TOAD and BMC Patrol.
• Setup, monitored and troubleshot Autosys jobs and implemented user requests.
• Coordinated Remedy tickets/PRRs created by developers with the ADC Team for implemetation.
• Performed VCS C&R tests regularly in coordination with the SAs.
• Coordinated tasks with the SAs, Backup/Recovery and ADC team for RMAN restore or to clone the database.

Confidential,Edison,NJ

• Assisted in the application development for Confidential for deferred and payout products for annuities.
• Managed multiple Confidential 8i and 9i DW databases on Win2K and Win2003 on a 1 TB Netapp SAN box.
• Managed distributed databases with the use of table partitions.
• Addressed storage management, capacity planning and performance issues.
• Automated database backups of various development and QA environments and managed tape backups.
• Provided technical support for the application team, the System Architect and the PM.
• Prepared customized scripts for database and schema creation and configuration based on business requirements.
• Deployed new builds to the databases and documented them.
• Used Microsoft VSS 6.0 and PVCS for source code control.
• Recommended and purchased hardware & peripherals and maintained the hardware infrastructure.
• Installed Confidential 10g and created databases on Win2K & Win2003, including a 10g test database on RH Enterprise Linux 4.
• Administered SQL Server databases.

Confidential,Hillside, NJ

• Used Confidential 8i and 9i on Win2K and Solaris.
• Created and managed a production standby database on Win2K.
• Developed and established standards, procedures and maintenance protocols for database operations.
• Implemented and documented database backup and recovery procedures and task automations.

Confidential,Port Washington,NY

• Managed and cross-trained the development and production teams of developers, DBAs and SA for the PHI Project.
• Used Confidential 8.x on Win NT, Win2K, HP-UX and Solaris.
• Performed database, SQL and performance tuning. Assisted developers in rewriting codes for generating reports from DSS/Data Warehouse databases.
• Managed table and index partitions and the use of Materialized Views and deployment of database changes.
• Planned and built an infrastructure for large databases of upto 350GB.
• Managed database security and established best standards and procedures for effective database management.
• Documented object naming conventions, and developed task automation procedures.
• Copied data from MS Access to Confidential .
• Planned and implemented schema migrations from WinNT to Win2K and disaster recovery strategy.

Confidential,New York City,NY

• Assisted application developers and worked directly with the PM and the VP of Technology for the Lendware Project using Confidential 8.x on Solaris and Windows NT.
• Provided 24*7 support for the production environment and created various development, QA and Staging environments.
• Performed exports from the production database for import into non-production environments.
• Planned and implemented physical and logical layout of the production databases, storage management, addressed capacity planning issues, implemented and documented hot/cold backup procedures with recovery strategies and performed database upgrades and migrations.
• Performed database analysis and generated growth/trend analysis reports.
• Performed routine maintenance of the production environments.

Confidential,Somerset,NJ

• Created various production and development environments on WinNT and HP-UX hosting Confidential 7.x and 8.0.
• Performed hot/cold backups, tuning, capacity planning and storage management.
• Provided application support to developers, maintained database security and troubleshot database issues.

Confidential,Baltimore,MD

• Administered various production environments using Confidential 7.x on HP-UX.
• Performed database monitoring, tuning, backups and reporting.