We provide IT Staff Augmentation Services!

Global Technology Analyst, Mainframe Db2 Dba Resume

Dallas, TX

CAREER SUMMARY:

Dynamic and creative with strong Database, Security and Software Development skills with over 8 years of experience in defining stable, secure and scalable applications and producing robust code for high - volume companies. Eager to join your team.

SKILL:

Programming and frameworks: COBOL, REXX, CLIST, CICS, APS, Mainframe BMS, Db2 Stored Procedures, Perl, C, C++, JAVA, C#, Clojure, Julia, Python,, Prolog, SR,ASP.Net

Web: PHP, HTML, XML, JavaScript, Dreamweaver, Ajax, CSS, Flex, JQuery, WordPress, SVG

Databases: IBM Db2, SQL, Oracle, MS-Access

Software Packages: BMC Catalog and Change Manager, IBM WebSphere MQ Series, BMC Main View, IBM Info Sphere Data Replication, Apptune, Omegamon, ZOS Explorer, ISPF, Spufi, QMF, Endevor Package Creation and Job Migration, Changeman, Xpeditor, FILEAID for Db2, SAR, Quick, File Manager, RACF, CA7, ACF2, ITSM BMC Remedy- Change, Incident Ticket and Problem Management Tool, OS/390 Data Warehouse(Internal App), DB2RQRY(Internal Query Tool for RACF), ARM-Access Request Management Tool, PODS-Production Online Datacenter Scheduling Tool, IBM Data Studio, Power Designer, Nexus- Work Request Management Tool, Juno, Jupyter, Hadoop, Git, Net Beans, Apache, ESRI MOJ20, Visual Studio, VMWare, MATLAB, Service Now, Fujitsu TRIOLE

EXPERIENCE:

Global Technology Analyst, Mainframe Db2 DBA

Confidential, Dallas, TX

Responsibilities:

  • Verified SQL code with DB2 Explain for production implementation and ensured their performance by tuning them for optimal 4 Hour Rolling Average, resulting into $200000 savings
  • Handled 2 QREP IBM MQ based applications for Confidential and handled the replication for these applications
  • Served as DBA for 46 Confidential applications and designed Data Models and Implemented heavy changes for them in Production as part of Application Releases. Handled projects requiring around hours of DBA work for release
  • Provided RACF and ACF2 Security Consulting to Application teams for setting their Service ids and User ids Security Profiles
  • Lead a team of 6 people in recovering critical US and UK Production Db2 tables in the event of data corruption. Fastened the recovery process by coordinating between the application and system team. Made improvements in recovery process by keeping around 24 hours of DB2 logs readily available on disk. Built post recovery documentations for the team
  • Loaded and Refreshed databases for application testing in various lower test environments. Handled 23 such concurrent application testing for major production releases. This required more than 500 hours of DBA work
  • Provided 24x7 ONCALL Support for Live Production Environment on Rotation Basis for all Db2 applications of GWIM (Merill Lynch), Retail and Card Services for the Bank. Handled hours of Triage Calls as sole DBA representative and provided DBA level Monitoring and Support wherever required. Helped reduce the count of FCI - Failed Customer Interaction
  • Worked on few confidential Projects for the Bank. Modified some of the most critical tables for CARDS and Points application, few of which required outage window
  • Handled US Trust application for Confidential . The app required agile methodology for creation and changes to more than 200 Db2 objects and deployment of more than 300 Stored Procedures in a single PROD release
  • Attended IBM Tech Conferences. Participated in 2018 IBM Orlando Tech Conference in Florida. Participated in many IBM Db2 User Group meeting at IBM, Dallas. Attended IBM workshop on Db2 as a REST service
  • Assisted many Confidential Intern joiners. Organized Bootcamp s for them and guided them for project presentations. Handled 3 such Summer Intern batch from

Technology Intern Analyst, Mainframe Db2 DBA

Confidential, Dallas, TX

Responsibilities:

  • Implemented Db2 Image Copy Modernization Project for Europe and North America Card Apps thus automating the Image Copy Process for 2 applications during my internship period
  • Worked on Utilities for Image Copy, Data Recovery, Reorg, Runstats, Binds, Data check, Load, Unload, REXX/ISPF Panel Automation, Db2 objects creation and maintenance in DEV and SIT regions
  • Extensively used BMC Catalog Manager and BMC Mainview and Apptune for doing analysis related to ICM project
  • Performed Tablespace Analysis for backup requirements, setting up more than 60 JCLs in DEV and QA as per production standards, Testing of JCLs, GDG Creations and Staging the Image Copy Modernization jobs thru Endevor Change Manager
  • Visited Confidential ’s Data Center at Richardson location and learnt about the hardware involved behind Mainframe

Graduate Senior IT Assistant

Confidential, San Diego, CA

Responsibilities:

  • Desktop and Software Security and Admin settings, Web Programming using HTML, CSS, ASP .Net and SQL, Ticket management, Hardware-Software upgrade and configuration and Inventory and Purchase Order management

Graduate IT Assistant

Confidential, San Diego, CA

Responsibilities:

  • Incident ticket management, Hardware-Software upgrade and configuration, classroom and remote arrangements, WordPress, SumTotal and Qualtrics Web Services API interaction for Survey and LMS

Software Engineer Analyst

Confidential

Responsibilities:

  • Handled Application Design, Development and Maintenance of 12 mainframe db2 applications for a US Retail client
  • Implemented IBM Messaging Queues architecture on Mainframes and trained 8 people in MQ, CICS, REXX and Cobol-Db2
  • Coded automated tools in REXX saving around 125 DBA team hours in a week and also supported critical Db2 and ZOS upgrades
  • Coded 22 new client applications in Cobol Db2 to help transform from a catalogue-led business to a digitally enabled business
  • Monitored critical Mainframe batch cycle and resolved production issues within SLAs for a UK retail client
  • Resolved nearly 10 incident tickets/day on Service Now and Fujitsu TRIOLE and also solved around 4 problem tickets per week
  • Provided release coordination for Unix and Mainframe modules by facing quarterly audits and monthly release metrics

Hire Now