SUMMARY

• Worked 15 years’ experience in Data Management, Administration, and Business Intelligence.
• Worked in SQL 2008/2012 DBA, Data Architect/Modeler/ analyst.
• Worked in Oracle 10/11g databases support, PL/SQL, TOAD, SQL*Plus, SQL*Loader, Data Pump tools
• Worked in Data modeling - Logical Data and Physical database design using Erwin, ERStudio and MS Visio.
• Worked DB2/IMS DBA - Responsible for project planning, requirement analysis, and technical specification.
• Worked in SQL Server 2008 SSIS/SSRS clinical data analysis.
• Worked in SQL server installation and Security Management levels.
• Worked in SSIS tools (Designer, import/export, query and utilities)
• Worked Data Warehouse - EDW, Teradata, and CDW Database modeling/design.
• Worked in Mainframe DB2, IMS, AIX, CICS, BMC, JCL, z/OS and application support.
• Two months trained on BIG DATA - Hadoop Core, Ecosystem, HDFS, MapReduce, Hive, Hbase, Oozie, MPP etc.,
• Worked in computer hardware (servers, networks, SAN).

PROFESSIONAL EXPERIENCE

Confidential, Kingsport, TN

Sr. SQL DBA

Responsibilities:

• Epic Clarity Databases production problem analysis, client support, and on call support.
• Backups/restoring databases on Dev/STG environments.
• Worked CDW database design Facts, Dimensions and measures for data analysis and reporting process.
• Build SSIS packages to process ETL data load and extract from EPIC Clarity databases.
• Configured SQL Server 2012 Reporting Services and supported to publishing in SharePoint.
• Develop T-SQL stored procedures, views, functions and triggers for Development SSIS/SSRS.
• Worked C# for ETL using SSIS, SSRS data reporting analysis.
• Worked databases and T-SQL performance tuning and query analysis.
• Worked databases updates and uses requests, data analysis.

Environment: SQL 2008/12, Epic Clarity 2014, Cogito Clarity, Epic Hyperspace 2014, BI (SSIS/SSRS), T/SQL, C#, MS 2010, SharePoint 2010, Toad, SharePoint, Service Connect, Epic Cogito Data Warehouse.

Confidential, Franklin, TN

Sr. Database Architect

Environment: HMS products, OS 5.1, 7.1, IBM iseries, AIX, UNIX, TSM, DB2, Java, HTML 5, RPG,CL, SQL server 2008/2012, PostgreSQL 8.3, Oracle 11g, Nagios, BI (SSIS/SSRS), T/SQL, C#, MS 2010, Jira, SharePoint 2010, IBM i navigator, Agile, Aldon Life Cycle.

Responsibilities:

• Worked HADR - Clustering, Log shipping, Migration, replication, reporting and on call support for clients product databases and on call support.
• Worked in PostgreSQL/MSSQL linked server to data access for reporting/data analysis.
• Replication, SQL server migration, performance monitor and databases stored procedures.
• DB2/Oracle 12c Databases design Erwin model all release products databases.
• Clinical, Patients, order, EHR, DM, HIM, HL7 databases support.
• Backups/restoring databases new install/release versions.
• Create all objects using Aldon change Management.
• Databases production problem analysis, client support, and on call support.
• Install, performance tuning and monitor SQL database instances.
• Develops, implements, and maintains policies, procedures, and accompanying training plans for database resource administration
• To Monitoring database system details wifin teh database, including stored procedures and execution time, plan cache for databases.
• Develops, implements, and maintains change control and testing processes for modifications to databases in DEV/QA/Production systems.

Confidential, Nashville, TN

EHR (Clinical data) Consultant DBA

Environment: Meditch 6.0, Epic, SQL server 2008, BI (SSIS/SSRS), MS 2008, Oracle 10g, PL/SQL, TFS 2010, z/OS, JCL, DOCLIB, Remedy, SharePoint 2010, Visual Studio 2008, XML, C#, DMExpress, Teradata, DB2 and BMC.

Responsibilities:

• On Call support for Clinical Data (CDM) and DR Databases.
• Design SSIS packages for EDW/Epic/HPF applications and FTp’ed data files.
• Migrated databases, SSIS packages and SSRS report code in QA and Live systems.
• Meditech 6.0, NPR data extract into EDW system and design SSRS reporting.
• Worked in SQL*Plus, SQL*Loader, Data Pump, and TKPROF.
• Co-ordinate to BMC change, code builds, Stonebranch and fixing incident tickets.
• Using C# scripts in SSIS packages FTP, file process to data validate.
• Creating Data sets for NPR/DR databases using SSRS report develop and deploy.
• Design, implement and maintain ETL components supporting CDM (Clinical Data Management) and EHR (ADM/ABS/OM/HIM/SCH) data.

Confidential, Nashville, TN

DBA - III

Environment: Oracle 10g/11g, server 2008, OEM, RMAN, Crystal Report XI, SSIS, SSRS, MS studio 2010, TFS 2010, Unix, PL/SQL, Toad, Visio, FoxPro, C#, SharePoint.

Responsibilities:

• Oracle Databases - Backup, design, implementation, stored procedures and triggers.
• Create PL/SQL using stored procedures, functions, Views for Crystal XI.
• Load data from FoxPro using SQL *loader to Oracle databases.
• Responsible for all database architecture and program design, report developers, and interfaces wif clients’ CRM software.
• Build Dynamic CRM for to converting DIDD applications COSMOS, QP, QA and PCP.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining SSIS packages.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Wrote installation and procedural manuals for support staff.

Confidential, Franklin, TN

Sr. Database Administrator

Environment: Windows NT/XP, z/OS, DB2, CICS, IMS, MS SQL server 2005/2008, Oracle 10g, IBM AIX, Unix, .net, SQL Profiler, Unix, SAN, BMC, Citrix, Erwin, Windows, DBArtisan, BMC Remedy.

Responsibilities:

• 24X7 on call support for DB2/IMS databases production environments.
• Daily backups, data restore and recovery, user accounts, privileges
• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations wif project managers, application and web app teams.
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Configured Database mail, linked servers in SQL server 2005.
• Conducting training sessions for Customers about using Business Objects Full client version and creating ad-hoc reports.
• Custom ETL solutions using T-SQL stored procedures schedules as jobs.

Confidential, Hoffman Estates, IL

Consultant DBA

Environment: MVS, z/OS, TSO, CICS, COBOL, IMS, DB2, Windows NT, Oracle 8i,Unix, IIS. Java, ASP

Responsibilities:

• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
• Perform security updates for all user types
• Design diagrams for 35 different databases
• Understanding of complex logical to physical DB structures
• Develop Documentation for all Databases
• Responsible for teh creation of SQL procedures, triggers, temp tables, and views for teh development of Crystal Reports 10. Reporting across multiple databases, multiple servers, multiple applications, wifin teh Wellness Care industry
• Scheduling and delivery of reports wif Crystal Enterprise 10 in multiple formats, to print servers and through email
• On Call support for teh production environment.
• Creation of new database environment
• Providing access privileges to teh database users.
• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for DB2/Oracle databases.
• Creating and maintaining Databases, Stored procedure, cluster indexes
• Creating and maintaining data warehouse
• Troubleshooting and Optimizing Database Performance.
• Develop plans and manage and execute complex technical efforts.