Experience

Lumeris

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Senior DBA

  • Feb 2012 - Present

• Senior DBA

  • Nov 2005 - Feb 2012

  • Work with systems networking and application development team to storage capacity planning, DB file fragmentations, index fragmentations, installation of SQL instance in QA, DEV and UAT.• Migrated oracle databases to SQL server 2008• Support production ETL Data loads using SSIS 2008/2012• Administered full phase cycle of the database. Administered Development, QA, Integration, UAT, Pre prod and Production environments.• Installed Oracle 9i &11g database software on both Windows and UNIX boxes • Creating databases from existing databases have used both (export & import as well hot backup) approaches to achieve this depending on the scenario. Also used DBCA tool to create databases. Migrated Linux based 9i Database to 11g database. • Created Standby/Dataguard setups for the Production Databases and maintained. • Generating stats pack report and analyzing it and performing the necessary action for performance issues. • Taking Logical Backups using Export and Import. • Providing functional knowledge to team members. • Coordinating with the front-end team & fulfill their database requirements. Show less