We provide IT Staff Augmentation Services!

Senior Database Admin Resume

0/5 (Submit Your Rating)

Reston, VA

SUMMARY

  • Senior - Level IT Professional with 25 Years of IT Experience, including Programming, Analysis, DBA, Q/A, Systems Administration, Design & Testing, and Re-Engineering with Full Life-Cycle Methodology on IBM Mainframe, Windows and SUN Servers.
  • Senior IT Project Leader with proven expertise in major programming languages and latest technical tools.
  • Oracle DBA certification - in progress
  • Performance Monitoring Databases, such as DB2 V10 and V11 on IBM Mainframe and Servers applied SMP/E, TSO, DFHSM/SMS, PURESCALE, CA TOOLS, ACF2, MXG, SMF, ROCKET SHUTTLE 9.2, BMC Tools, ERWIN, OMEGAMON, DPF, WLM, DSM, COGNOS, AIX, MQ, TMON, TIVOLI, WLM, JES2, Z/OS,SQL SERVER 2014, SSRS, SSAS.
  • Consistently completed projects before deadlines, saving employers significant money.
  • Recognized by upper management for major accomplishments during large/complex projects.
  • Able to take charge of development, maintenance and support responsibilities.
  • Excellent technical communication skills.
  • Proven ability to streamline administrative tasks, manage multiple databases, alter and migrate database objects, optimize databases, improve database retrieval and monitor critical resources.
  • Able to keep data secure and reliable, perform online database reorganization and reduce database downtime.

PROFESSIONAL EXPERIENCE

Senior Database admin

Confidential, Reston, VA

Responsibilities:

  • Working as senior architect for the healthcare migration project from legacy/mainframe to the Web services
  • I am working on the conversion/migration project for the major healthcare provider for the FEP system on CLAIMS, utilizing, DB2 V11, SQL SERVER 2014, PURESCALE, Rocket Shuttle 9.2, ERWIN, COBOL, SQL, QMF, MQ, COGNOS, WLM, SAS, VSAM, JCL, IBM Utilities, Assembler, SHARE POINT, MS EXCEL, WORD, AGILE, POWER POINT, LINUX/UNIX, SHELL SCRIPTING, IBM mainframe, UNIX and many more tools and technology providing them technical lead and in designing, coding, testing and production turn over for the migration of the current software from Mainframe to the web services environment.
  • Participating on the daily SCRUM meetings and creating the system design documentation.

Technical Lead/DBA

Confidential, Bedford, MA

Responsibilities:

  • Worked as a Database Admin and a Technical Lead on the Financial systems utilized, DB2 V10, IMS, Network Database APAM, DPF, SQL SERVER 2014, HADR, SAS, MYSQL, Shell Scripting, REXX, C, Assembler on IBM Mainframe and Linux Servers, and t00k lead role on these and disciplines for Financial systems.
  • Performing Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supported the Data Warehouse projects as a Lead Database systems person.
  • Developed, maintained, and supported the existing Systems.
  • Provided Support for large financial system on Bonds, stocks, equity and much more.
  • Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • Responsible for all DB2 products in production, test and development environments.
  • Monitored the financial Production Databases on the Z/OS and on Linux for potential problems.
  • Managed the Database security by enabling the users with proper authorizations.
  • Upgraded, restored the Database and applications.
  • Managed the storage and I/O performance issues related to databases.
  • Took the responsibility of SQL tuning and optimization of the SQL queries to run efficiently.
  • Ensured that the work is in compliance with the IBM MAINFRAME for Z/OS, MQ, WLM, AIX.
  • Assisted all development work with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.
  • Travelled abroad and part of the vacation. Took care for the family member who was serious ill for a longer period.

Confidential, Camp Hill, PA

Responsibilities:

  • Worked as a DB2/UDB/IMS/DBA utilizing, SQL, SOP, HADR, IDMS, MYSQL, IMS, VSAM, HIPPA 2010, XML, Snapshot, on IBM Mainframe and Servers, and taking lead role on these and disciplines for HealthCare Provider for the State of PA Healthcare systems.
  • Performed Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supported the Data Warehouse projects as a DB2/IMS Lead person for the HealthCare databases related to Confidential t care and billing, Provider database, Medicare database and the Claims database.
  • Developed, maintained, and supported the existing Systems.
  • Provided Support for HealthCare, Confidential t database, Providers and Claims as a DB2 and IMS DBA.
  • Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • Responsible for all DB2 and IMS migration products in production, test and development environments.
  • Installed and upgraded the DB2, IMS, COBOL, ALC, CICS products with full code testing.
  • Monitored DB2 Production Databases on the Z/OS for potential problems.
  • Responsible for Backup, Security and Controls of databases.
  • Upgraded, restored the Database and applications.
  • Took the responsibility of SQL tuning and optimization of the SQL queries to run efficiently.
  • Ensured that the work is in compliance with the IBM MAINFRAME DB2 for Z/OS, SMP/E, WLM, TSO, JES2, DASD, DFHSM.
  • Assisted all development work on DB2 and IMS with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Performed Q/A, and team responsibilities in the software development projects.
  • Delivered quality solutions, to Customer Acceptance and Satisfaction with end products.
  • Utilized Innovative approaches in problem solving.
  • Worked with minimal directions from the management and achieved the goals with efficient results and quality.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.

Database ANALYST/DEVELOPE/DESIGNER/TESTER

Confidential, HARRISBURG, PA

Responsibilities:

  • Worked as a Database Developer/Admin on DB2/IMS utilizing SAS, AGM, SQL, MYSQL, and IBM Database utilities on IBM Mainframe and Servers, and taking lead role on these and disciplines for HealthCare Provider for the Healthcare Financial Institution of PA.
  • Performed Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supported the Data Warehouse projects as a DB2, IDMS and IMS Database support person for the HealthCare databases related to Confidential t care and billing, Provider database, Medicare database and the Claims database.
  • Developed, maintained, and supported the existing Systems.
  • Provided Support for HealthCare, Confidential t database, Providers and Claims on DB2 and IMS Databases.
  • Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • Responsible for all DB2 and IMS products in production, test and development environments.
  • Monitored DB2 and IMS Production healthcare Databases on the Z/OS for potential problems.
  • Managed the Database security by enabling the users with proper authorizations.
  • Upgraded, restored the Database and applications.
  • Ensured that the work is in compliance with the IBM MAINFRAME DB2 and IMS for Z/OS.
  • Assisted all development work on DB2, MQ, WLM, and IMS with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Performed Q/A, and team lead responsibilities in the software development projects.
  • Delivered quality solutions, to Customer Acceptance and Satisfaction with end products.
  • Utilized Innovative approaches in problem solving.
  • Worked with minimal directions from the management and achieved the goals with efficient results and quality.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.

DB2 Database Engineer

Confidential, Harrisburg, PA

Responsibilities:

  • Working as a DB2/UDB/DBA utilizing DPF, ERWIN, TIVOLI, SQL SERVER, HADR, MYSQL, Snapshot, on IBM Mainframe and Servers, and taking lead role on these and disciplines for HealthCare Provider for the Nationwide, Financial Institution.
  • Performing Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supporting the Data Warehouse projects as a DB2/DBA for the HealthCare databases related to Confidential t care and billing, Provider database, Medicare database and the Claims database.
  • Developing, maintaining, and supporting the existing Systems.
  • Providing Support for HealthCare, Confidential t database, Providers and Claims as a DB2/UDB DBA.
  • Advising and Collaborating with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • Responsible for all DB2 products in production, test and development environments.
  • Installing and upgrading the DB2, MQ, WLM, DPF, IMS, SAS, COBOL, ALC, CICS products with full code testing.
  • Monitoring DB2 Production Databases on the Z/OS for potential problems.
  • Applying upgrades along with Business System Services to the DB2 in the test and production environment.
  • Responsible for Backup, Security and Controls of databases.
  • Manage the Database security by enabling the users with proper authorizations.
  • Upgraded, restored the Database and applications.
  • Managed the storage and I/O performance issues related to databases.
  • Took the responsibility of SQL tuning and optimization of the SQL queries to run efficiently.
  • Ensured that the work is in compliance with the IBM MAINFRAME DB2 for Z/OS.
  • Assisted all development work on DB2 with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Monitored and managed the data partitioning with DPF, and utilized appropriate IBM and other tools and utilities to accomplish this.
  • Performing Q/A, and team lead responsibilities in the software development projects.
  • Delivered quality solutions, to Customer Acceptance and Satisfaction with end products.
  • Utilized Innovative approaches in problem solving.
  • Worked with minimal directions from the management and achieved the goals with efficient results and quality.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.

DB2 Database Engineer

Confidential, Baltimore, MD

Responsibilities:

  • Designed, developed and maintained systems/applications software on SUN SOLARIS.
  • As a Database Engineer utilized, DPF, SQL SERVER, IMS, HADR, SAS, IDMS, MYSQL, Snapshot, on IBM Mainframe and Servers, BCV Copies, and taking lead role on these and disciplines for HealthCare Provider for the Nationwide, Financial Institution and Federal Government.
  • Performed Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supported the Data Warehouse projects as a DB2/DBA for the HealthCare databases related to Confidential t care and billing, Provider database, Medicare database and the Claims database.
  • Developed, Maintained,, and Supported the existing Systems.
  • Provided Support for HealthCare, Confidential t database, Providers and Claims as a DB2/UDB DBA.
  • Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • I took overall responsibility for all DB2 products in production, test and development environments.
  • Installed and upgraded the DB2/UDB servers on the UNIX/LINUX environment.
  • Utilized Shell Scripts to accomplish this work.
  • Monitored DB2 Production Servers and on the Z/OS for potential problems.
  • Applied upgrades along with Business System Services to the DB2 in the test and production environment.
  • Took responsibility to Backup, Security and Controls of databases.
  • Took charge of the Database security by enabling the users with proper authorizations.
  • Upgraded, restored the Database and application servers when required.
  • Managed the storage and I/O performance issues related to databases.
  • Took the responsibility of SQL tuning and optimization of the SQL queries to run efficiently.
  • Ensured that the work is in compliance with the IBM MAINFRAME DB2 License agreement for Z/OS.
  • Assisted all development work on DB2 with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Monitored and managed the data partitioning with DPF, and utilized appropriate IBM and other tools and utilities to accomplish this.
  • Performed duties as an administrator for HL7, HIPPA application systems
  • Utilized most of the latest Technological Tools and Software Systems to accomplish my daily work duties
  • Delivered quality solutions, to Customer Acceptance and Satisfaction with end products
  • Utilized Innovative approaches in problem solving.
  • Worked with minimal directions from the management and achieved the goals with efficient results and quality.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.

Software Engineer/SYSTEMS ENGINEER/DB2/DBA

Confidential, Baltimore, MD

Responsibilities:

  • Designed, developed and maintained systems/applications software on SUN SOLARIS.
  • Worked as a DB2/UDB/DBA utilizing, DPF, TIVOLI, SQL SERVER, HADR, RETAIL, MQ, WLM, DB2 PURESCALE, SMPE, IMS, MYSQL, TSA, STORAGE, Snapshot, on IBM Mainframe and Servers, BCV Copies, SAP, and taking lead role on these and disciplines for HealthCare Provider for the Nationwide, Financial Institution and Federal Government Agencies.
  • Lead the Projects and Performed Requirements and Definitions, Analysis, Design, Data Mining and ERD.
  • Supported the Data Warehouse projects as a DB2/DBA for the HealthCare databases related to Confidential t care and billing, Provider database, Medicare database and the Claims database.
  • Developed, Maintained,, and Supported the existing Systems.
  • Provided Support for HealthCare, Confidential t database, Providers and Claims as a DB2/UDB DBA.
  • Advised and Collaborated with the Developers on the solutions to issues, Data Architectures, Systems Facilities and Capabilities and the Operations and Tuning the Databases on a daily basis for a 7 x 24 Environment.
  • I took overall responsibility for all DB2 products in production, test and development environments.
  • Installed and upgraded the DB2/UDB servers on the UNIX/LINUX environment.
  • Utilized Shell Scripts to accomplish this work.
  • Monitored DB2 Production Servers and on the Z/OS for potential problems.
  • Applied upgrades along with Business System Services to the DB2 in the test and production environment.
  • Took responsibility to Backup, Security and Controls of databases.
  • Took charge of the Database security by enabling the users with proper authorizations.
  • Upgraded, restored the Database and application servers when required.
  • Managed the storage and I/O performance issues related to databases.
  • Took the responsibility of SQL tuning and optimization of the SQL queries to run efficiently.
  • Ensured that the work is in compliance with the IBM MAINFRAME DB2 License agreement for Z/OS.
  • Assisted all development work on DB2 with application development designing and creating database objects, migrating from test to production and implemented batch schedules with appropriate DB2 utilities.
  • Monitored and managed the data partitioning with DPF, and utilized appropriate IBM and other tools and utilities to accomplish this.
  • Performed duties as an administrator for HL7, HIPPA application systems
  • Utilized most of the latest Technological Tools and Software Systems to accomplish my daily work duties
  • Utilized Full SDLC Methodology and other development/testing software tools
  • Delivered quality solutions, to Customer Acceptance and Satisfaction with end products
  • Utilized Innovative approaches in problem solving.
  • Worked with minimal directions from the management and achieved the goals with efficient results and quality.
  • Lead the technical as well as the non-technical staff and users with responsibility, trained and mentored the staff.

Senior Systems Engineer/DB2/DBA

Confidential, Owings Mills, MD

Responsibilities:

  • Provided software re-engineering and full software support to Federal Employee Program Division.
  • Upgraded Systems Software DB2, IMS, FileAid, TMON, DataPropagator.
  • Utilized Z/OS, WLM, TIVOLI, DFHSM/SMS, LINUX, CA TOOLS, ERWIN, OMEGAMON, SQL SERVER, SAP, SMPE, Snapshot, BCV Copies, HADR, SAS, MYSQL,TSA on the systems programming responsibilities utilizing IBM Mainframe and Servers and MS Windows.
  • Provided full support to test plans development and regression testing process and Disaster Recovery.
  • Collaborated with multitask teams, including management and customers in peer reviews.
  • Provided Performance Tuning and Disaster Recovery on Datawarehouse projects
  • Performed Functional Analysis to support Federal Employee Program clients. Related to the Federal Employees HealthCare databases.
  • Took the responsibility in performance tuning of the SQL queries and closely monitored on a daily basis to run very efficiently by applying available tools and utilities.
  • Monitored the DB2 servers and upgraded whenever required.
  • Worked with the security administration to ensure that proper security is in place for DB2 data.
  • Monitored the disk space and the DB2 logs, backups to protect the integrity of the data.
  • Provided full support for conversion and migration of software with large DB2 Database, IMS FileAid and TMON.

S/W Engineer/DBA

Confidential, MD

Responsibilities:

  • Provide software re-engineering and full software support to E-Services Division of IRS.
  • Mentored team members and provided full support to test plans development and regression testing process. Took responsibility for development, testing full Life Cycle, Q/A, C/M and system support.
  • Collaborated with multitask teams, including management and customers in peer reviews.
  • Provided Performance Tuning and Disaster Recovery on DB2/UDB, MQ, CICS, IDMS, SAP
  • Performed Functional Analysis and Developed software for IRS Online Electronic Registration process for customers external to IRS Financial Management Systems.
  • Provided full support for conversion and migration of software with large DB2 Database on Z/OS with Snapshot, TIVOLI, BCV Copies, TSA Storage, HADR on IBM Mainframe and Servers, MS Windows.

S/W Engineer/DBA

Confidential, Arlington, VA

Responsibilities:

  • Provided database administration during strategic planning of massive telecomm-billing database
  • Provided full support. Mentored team members through formal training
  • Collaborated with multi-functional teams, including management, operations and customers
  • Developed Disaster Recovery and Performance Tuning and conversion of very large databases for UDB/DB2/SAP, LINUX and Oracle for the Financial Management System on Z/OS Utilizing SUN Servers, IBM Mainframe and MS Windows.

We'd love your feedback!