We provide IT Staff Augmentation Services!

Sr. Database Dba Resume

Brentwood, TN

SUMMARY

  • Over 17 years’ experience in Data Management, Data Administration and Business Intelligence in enterprise accounts including Confidential
  • Extensive experience using ETL Tools Informatica PowerCenter and Microsoft SSIS
  • Extensive experience with ETL (Extract, Transform and Load) and Database queries
  • Experience with Designer, import/export, query and utilities in SSIS/SSRS
  • Excellent understanding of complex logical to physical DB structures
  • Extensive “Report Writing” experience using Tableau, COGNOS and CRYSTAL REPORTS
  • Experience developing Documentation for all Database/Data Warehouse projects
  • Very good knowledge in analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
  • Experience performing Database Performance Tuning
  • Experience with SQL server installation and Security Management levels
  • Experience with CDM data analysis

TECHNICAL SKILLS

Databases: SQL 2008 R2/2012, Oracle 10g/11g, Teradata

BI/ETL Tools: Informatica 8.1, Business Objects, Cognos, SSIS/SSRS/SSAS

Data Modeling: Erwin, ERStudio

Reporting Tools: Tableau, SSRS, Crystal Reports, Cognos

Productions Apps: MS Visio, Microsoft Office (Word, Excel, PowerPoint), Visual studio, SharePoint, Team Foundation Services

Languages: PL/SQL, C#, Java, HTML, Oracle Toad

Methodologies: Agile Scrum

Platforms: Window, IBM OS/400 iSeries, AIX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

Sr. Database DBA

Responsibilities:

  • Support over 3000+ Confidential clinical data movement, data analysis, data fix, Solutions.
  • Worked with development team on Enterprises solutions, design, In/out bound queues analysis, Performance review an all Applications servers and databases servers troubleshooting.
  • Developed SSIS packages to load data from Clinical data (Snappy) to SQL Server 2008 database.
  • Support Data movement using eGate interface, data absent, month end close claims support.
  • To support BILLPROD/Clinical client data movement and development team support.
  • Worked FSO team on Snappy Backups/restoring databases new install/release versions.
  • To Monitoring HPOV database system details within the database, including stored procedures and execution time, plan cache for databases.
  • Worked and extracted data into ROPS Dashboard status and SSRS reporting analysis.
  • Develops, implements, and maintains change control and testing processes for modifications to databases in DEV/QA/Production systems.

Environment: Oracle, SQL server, BI (SSIS/SSRS), SharePoint 2010, ServiceNow, Visual studio 2013, CA Erwin, HP Open view tool, EGATE interface, ETL, Tableau.

Confidential, Kingsport, TN

Sr. Epic Clarity Cogito Data Warehouse consultant

Responsibilities:

  • Epic Clarity Databases production problem analysis, client support and on call support.
  • Backups/restoring databases on Dev/STG environments.
  • Develop T - SQL stored procedures, views, functions and triggers for Development SSIS/SSRS.
  • Epic Cogito Data warehouse design, ETL develops in staging and production systems.
  • Epic Clarity report in hospital and clinical data analysts and designs/testing.
  • Developed ETL from Clarity databases to Epic CDW databases and design CDW databases using star schema (facts and Dimensions models).
  • Worked databases and T-SQL performance tuning and query analysis.
  • Worked databases updates and uses requests, data analysis.

Environment: SQL 2008/12, Epic Hyperspace 2014, Epic Clarity Console, Cogito Clarity, PL/SQL, T/SQL, Crystal Reports, C#, SharePoint 2010, Toad, ER/Studio, SharePoint, Service Connect, Epic CDW.

Confidential, Franklin, TN

Sr. Database Architect/Database Developer

Responsibilities:
  • Migration, replication, reporting and on call support for clients product databases.
  • Databases design Erwin model all release products databases.
  • Developed SSIS packages to load data from IBM iSeries database to Oracle PL/SQL, Toad, views, procedures, triggers, and functions in Oracle /SQL Server 2008 database.
  • Developed reports using tools SSRS, Crystal and Cognos and deploying the client locations.
  • Worked in an Agile and SCRUM Software and changing requirements.
  • Clinical, Patients, order, EHR, DM, HIM, HL7 databases support.
  • Backups/restoring databases new install/release versions.
  • Database administration, maintenance, and schema design for DB2 and MS SQL Server
  • Create all objects using Aldon change Management.
  • To Monitoring database system details within the 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.

Environment: IBM iSeries, AS400, Java, WebSphere 7.5, SOAP, JSM, Oracle 11g/12c, HTML 5, SQL Server 2008/2012, BI (SSIS/SSAS/SSRS), Cognos, HL7, Jira, SharePoint 2010, IBM I navigator, Salesforce, Aldon Life Cycle

Confidential, Nashville, TN

Sr. Application Engineer / ETL Developer

Responsibilities:
  • Provided support for Clinical Data (CDM) and DR Databases.
  • ETL (Extract Transform and Load) developer using SSIS packages
  • Design and build SSIS packages for Meditech 6.0 applications and FTp’ed data files to EDW.
  • Migrated databases, SSIS packages and SSRS report code in QA and Live systems.
  • Migrate SharePoint 2008 to 2010 using .Net, C# code to design custom web pages, AD login access
  • Build reporting design in SSRS reports in CDM applications.
  • Meditech NPR data extract into EDW system and design SSRS reporting.
  • Backups/restoring Meditech DR databases (Focus/NPR).
  • 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.

Environment: Meditech 6.0, SQL server 2008, BI (SSIS/SSRS), Oracle 10g, PL/SQL, TFS 2010, Remedy, SharePoint 2010, Visual Studio 2008, XML, C#, .Net, HTML, XML, Tableau, Teradata, DB2 and BMC.

Confidential,Nashville, TN

Sr. Database Developer/Reports Writer

Responsibilities:
  • Databases - Backup, design, implementation, stored procedures and triggers.
  • Create PL/SQL using stored procedures, functions, Views for Crystal XI.
  • Load data from FoxPro using SISS/SQL *loader to SQL/Oracle databases.
  • Responsible for all database architecture and program design, report developers, and interfaces with clients’ CRM software.
  • Migrate Crystal reports XII to SSRS reporting and design new reports in SSRS and deploying UAT/PROD servers.
  • 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.

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

Confidential,Franklin, TN

Sr. Database Administrator

Responsibilities:
  • Provided support for DB2/IMS databases production environments
  • Provided Daily backups, data restore and recovery, user accounts, privileges for Database support, troubleshooting, planning and migration.
  • Resource planning and coordination for application migrations with project managers, application and web app teams
  • Monitoring of database size and disk space in Production, Staging & Development environments.
  • Conducted Performance Tuning using DB2/IMS and BMC Performance Monitor.
  • Performed ETL (Extract Transform and Load) functions using Informatica v6.0
  • Created Custom ETL solutions using T-SQL stored procedures schedules as jobs Responsible.
  • Configured Database mail, linked servers in SQL server 2005/2008.
  • Conducted training sessions for Customers on Business Objects Full client version

Environment: Windows NT/XP, z/OS, DB2, COBOL, JCL,VSAM,CICS, IMS, Essbase, SQL server 2005, Oracle 10g, Informatica 6, ETL, UNIX, .net, C#, SharePoint, TFS, SQL Profiler, Unix, BMC, Erwin, Windows, DBArtisan, BMC Remedy.

Confidential

Mainframe DB2 DBA / ETL support

Responsibilities:
  • On Call support for the production environment.
  • Creation of new database environment
  • Provided ETL functions using Informatica
  • Supported Data Architect - end-to-end vision, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive Stages
  • Providing access privileges to the database users.
  • Backup & Restoration, databases design of the databases for DB2 on Mainframe.
  • Performed the Disaster Recovery process
  • Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for DB2/Oracle databases.
  • Created/configured MQ Objects, Queue Managers, Remote Queues, Local Queues, Queue Aliases Designed distributed queuing client server architectures and configured MQ
  • Created and maintaining Databases, Stored procedure, cluster indexes
  • Created and maintaining data warehouse
  • Troubleshot and Optimized Database Performance.
  • Develop plans and manage and execute complex technical efforts.

Environment: MVS, DB2, COBOL II, IMS DC/DB, CICS, Windows, MQSeries, MQI, PL/1, Enterprises Manager, Query Analyzer, Informatica, and Data Warehouse, IBM utilities, JCL, VSAM

Confidential

Mainframe DB2 DBA / Programmer

Responsibilities:
  • On Call support for the production environment.
  • Creation of new database environment
  • Backup & Restoration, databases design of the databases for DB2 on Mainframe.

Environment: MVS, DB2, COBOL II, IMS DC/DB, CICS, Windows, MQSeries, PL/1, Query Analyzer, IBM utilities, JCL, VSAM

Hire Now