We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

SUMMARY:

  • Talented technology consultant with 16 years of success, improving functionality, performance and efficiency of Databases. Possess effective blend of technical & managerial skills. A dynamic, high energy solution provider and high impact technical resource.
  • Over 16 years of experience in Installation, Design, Deployment, Production Support & upgrade of databases.
  • Proven ability to research technology options and recommend solutions for various business processes.
  • Deep knowledge on database migration. I have worked on migrating Oracle, DB2 zOS, DB2 LUW databases to PostgreSQL.
  • Experience in PostgreSQL version 9.3/9.4/9.5/9.6 . Created functions in pSQL for automating tasks. Shell scripting to automate maintenance of database. Logical and physical database design and database modeling using CA Erwin.
  • AWS certified Solutions Architect with AWS Cloud based database support including EC2 and RDS platforms. Real time replications and DR support. High availability with AWS public cloud technology. Building, managing and deploying, deleting Instances/stacks on demand supporting multiple DevOps teams.
  • Train and consult developers on efficient way of coding SQLs and with the eye on enterprise data standard while creating database objects.
  • Diverse skill sets ranging from PostgreSQL, DB2 LUW & zOS, SQL Server in various capacity as Database design, installation, Performance tuning & monitoring, and support. Also have exposure to NoSQL databases like Cassandra and MongoDB.
  • PMP Certified professional with Project Management methodology expertise and worked for clients such as Options Clearing Corporation, Confidential Finance, Confidential Healthcare Insurance, CVS Pharmacy, Confidential Services, GE Consumer Finance. Expert at Agile Scrum methodology and ceremonies. Strong leadership skills and Project Management skills. Excellent communication skills and strong team player.
  • Expertise in Software Development Life Cycle (SDLC waterfall) and Agile processes in a large enterprise environment and proficient in analyzing existing systems and designing technical specifications for the proposed business requirements.

TECHNICAL SKILLS:

Office tools: MS Office - Word, Excel, PowerPoint, Access, Visio, Project, Outlook

DBMS: PostgreSQL 9.3, 9.4, 9.5, 9.6, SQL Server 2012, 2014 , DB2 UDB Version 9.5, 9.7, 10.1, 10.5, 11.1 , DB2 zOS Version 8, 9, 10, 11, 12

Database modeling tools: CA Erwin, Embarcadero ER Studio

OS/Environment: zLinux, Unix, Red hat Linux, Windows, zOS

Languages: Perl, Python, korn shell/ksh, bourne shell/bash, SQL, Rexx, Clist, UDF, Stored Procedures, Native SQL, Cobol, Easytrieve, JCL, Triggers,

ETL Tools: AbInitio, Informatica

Scheduling and Version Control: Version control Changeman, SCLM, Endeavor, Panvalet

Scheduling: UC4,CA-7, CONTROL-M, Crontab

Soft Skills: Empathy, Patience, Self-Motivated, Goal Oriented, Flexible, Accommodating, Team player, Mentoring attitude, Critical thinking

Tools: & Applications: Vi, Speedgain (Monitoring), Data Studio, DB2 Optim tools, Visual explain, SQL Explain (Explain tables, Plan table)

PGAdmin, Ora2PG, pgModeler: STROBE/iSTROBE, REXX, FILE-AID, MQ SERIES (WMB), DFSORT, SPUFI, QMF, QUICK START, TSO/ISPF, HP Quality Center

DB2 administration related tools and commands: Load, Runstats, Reorg, Recover, Import, Export, HADR, BACKUP db2look, db2mtrk, db2pd, snapshot, db2support, db2trc etc

IBM zOS: DB2-ADMIN tool, Omegamon DB2/IBM Performance monitoring, DB2 HPU, Runstats, Reorg, Recover, (IMAGE) COPY, Check, Load, Unload, Rebuild Index BMC Change Manager, Log Master, Mainview, AppTune, Recovery+, Unload+

PROFESSIONAL EXPERIENCE:

Confidential

Senior database administrator

Responsibilities:

  • Install, configure, upgrade and maintain PostgreSQL binaries on Linux.
  • Configuring, integrating and maintaining all Dev, QA and Production PostgreSQL databases.
  • Data modeling, re-engineering logical and physical data models for PostgreSQL.
  • Performance Monitoring & troubleshooting. Data backup and Recovery, security and troubleshooting.
  • Performance tuning using various methods, including access path validation by Explain. Performance index requesting for access path optimization. Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering. Develop postgreSQL functions. Load/Unload data. database parameter modification and standardization.
  • DB2 LUW installation, support, database creation, backup, performance tuning.
  • AWS RDS - Instance creation, upgrades, rehydration, Multi-AZ, DR Failovers, cloud formation scripting. AWS Cloud Watch monitoring and various AWS Operations management tasks.
  • AWS EC2 - CFT for automatic EC2 deployment and postgreSQL and PGAdmin installation.

Environment: Database - PostgreSQL 9.3/9.4/9.5/9.6 , DB2 LUW, DB2 zOS, Teradata, Oracle, SQL Server

Programming Language: Python programs, K Shell scripting, PL/pgSQL.

AWS Technologies: Cloud formation scripts, AWS CLI, AWS Cloud Watch, AWS RDS. AWS EC2, rehydration, VPC, Subnet, Security groups, Route 53.

Office Tools: MS Word, MS Excel, MS Visio, MS Access

Others: Visual Explain, DB2 Admin Client, Control-M, db2pd, db2 support, reorg, runstats, backup, snapshot, Omegamon, DSNTEP4, DSNUTILB, DSNTIAUL, HPU Unload, PGAdmin, Copy, import, export

Confidential

Senior DB2 database administrator

Responsibilities:

  • Migrate from DB2 9.7 to 10.5.
  • POC with new features of DB2 10.5 like BLU and out of box CPU savings.
  • HADR setup using Symantec Veritas for failover. Q replication (IIDR).
  • Support total of 50+ database environments (including development, QA and Prod).
  • Physical design (PDM) and deploy from Logical models. Create db2 instance, database, tables. Decide on partitioning strategy and indexes for performance. Create backup and disaster recovery strategies.
  • Create and maintain Very large multi partition tables. And tune queries going against these hugh tables. And design bufferpools and configure DB CFG parameters for the same.
  • Create triggers and stored procedures.
  • Data Replication, Migration & refresh from Production to Test environment. Support restore of Production data & unloads into development and QA environments using various methods. Redirected restores from backups.
  • Monitor the system performance, bufferpool performance, space management using SPEEDGAIN. And for troubleshooting and identifying the problem SQLs.
  • Recover tables from log / backups using IBM Recover.
  • Maintain DB2 governor, restrict run away SQLs while allowing desirable work load to go through.
  • Performance tuning using various methods, including access path validation by Explain/Visual Explain.
  • Access path validation by seeing the bufferpool & Miniplan in Omegamon (IBM Performance monitoring). Performance index requesting for access path optimization.
  • Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering. Best example is reduced CPU of a SQL from 50 minutes to under a second.
  • Create automation script to Install DB2 V9.7 in Red Hat Linux environment. Setup HADR. Create perl scripts to Reorg, Runstats and other maintenance tasks. Schedule using Cron.
  • Install and maintain DB2 gateways. Register / deregister databases.
  • POC on BLU columnar compression. Index jumps. Adaptive compression.
  • Perform Database Maintenance tasks in Dev & QA environment like running Reorgs, Runstats, Backup & data compression. Requesting the same for supported application tables in Production.
  • Performance Monitoring & troubleshooting using BMC Mainview and BMC AppTune for zOS.
  • Load/Unload data using DSNTIAUL for zOS and LOAD/IMPORT/EXPORT for DB2 UDB.
  • Develop, enhance & support in house REXX tool for database task automation, saving 100s of DBA hours.
  • DML/DCL/DDL/DB2 Security/Grants/RACF security/ACS2 groups/WLM Start-Stop

Environment: Database - DB2 LUW 9.5, DB2 zOS V10, SQL Server

Programming Language: perl, K shell, B shell scripting DB2 SQL Stored Procedure, REXX, DFSORT, Cobol, JCL, DB2-Cobol Stored Procedure

Office Tools: MS Word, MS Excel, MS Visio, MS Access

Others: Data Studio, Visual Explain, Speedgain, RESTART, RECOVER, REBUILD, REORG, RUNSTATS, BMC Change Manager, BMC AppTune, BMC Mainview, BMC Log Master, UC4, DSNTEP4, DSNUTILB, DSNTIAUL, MODIFY, REPAIR, QUIESCE

Confidential

Senior DB2 database administrator

Responsibilities:

  • Migrate DB2 zOS database to PostgreSQL on-premise server and AWS RDS instance.
  • Train and provide consultation to development team regarding cloud migration of their on-premise databases and suggest appropriate databases.
  • Implement index compression and reclaim lot of space.
  • Data Replication, Migration & refresh from Production to Test environment.
  • Perform Database Maintenance tasks in Dev & QA environment like running Reorgs, Runstats, Backup/Copy & data compression. Requesting the same for supported application tables in Production.
  • Performance Monitoring & troubleshooting using IBM Performance Monitor, Omegamon & DB2-Admin tools.
  • Performance tuning using various methods, including access path validation by Explain/Visual Explain. Access path validation by seeing the bufferpool & Miniplan in Omegamon. Performance index requesting for access path optimization. Optimize to use index, parallelism, avoid sorts & tablescans, promote partition elimination & data filtering.
  • Develop DB2 SQL Stored procedures.
  • Develop python programs for task automation and analytical operational reports.
  • Load/Unload data. Reorg, Runstats, monitoring using various tools provided by DB2.
  • Participate in regression testing of z9 to z10 upgrade.
  • Application support for AbInitio Co-op processing, troubleshoot production abends, review the access patterns and validate the SQLs for API & Load cards for Utility modes.
  • DB2 Connect server support, Remote package binding, performance monitoring, script development for automation
  • HADR setup using Tivoli system automation for failover.
  • DB2 LUW 9.5 installation, support, database creation, backup, performance tuning.

Environment: Database - PostgreSQL 9.3, DB2 LUW 9.5, Teradata, DB2 zOS

Programming Language: Python programs, K Shell scripting, Data Studio, Toad, Rexx. DB2 SQL Stored Procedure, Cobol, JCL, DB2-Cobol Stored Procedure, AbInitio Co-op processing

Office Tools: MS Word, MS Excel, MS Visio, MS Access

Others: Visual Explain, DB2 Admin Client, Control-M, db2pd, db2 support, reorg, runstats, backup, snapshot, Omegamon, DSNTEP4, DSNUTILB, DSNTIAUL, HPU Unload

Confidential

Database consultant & Analyst

Responsibilities:

  • Worked with Business analysts & Architects to create ERD, logical data model in Erwin for new application.
  • Data model analysis - Work with DBAs & Data Modelers to design the new data models. Normalizing the database. Implement referential integrity and triggers for audit tracking.
  • Data Analysis - Analyze Hospital and Clinical Claim data as well as Rx prescription data. Load the files in to Tables and perform complex data analysis tasks, joining multiple tables with ample conditions. Query the tables to analyze the data.
  • Interact with Stakeholders to gather the business requirement and convert them into functional requirement specification document and into value stream mapping.
  • Convert functional specification into detail design documents and work as SME for development team.
  • Provide Application Support with respect to Access path validation on queries, package binds/rebinds, data unload/backups.

Environment: Database - Oracle, DB2, Netezza

Programming Language: Unix scripting - Python ksh Cobol, JCL

Informatica: Workflow Manager, Workflow Monitor, Repository Manager, Designer

Office Tools: MS Word, MS Excel, MS Visio, MS Access

Confidential

Application Specialist

Responsibilities:

  • Analysis of existing applications in Mainframe and .Net/C# to fix the issues/bugs and find the opportunities for performance improvement.
  • Performance tuning of JCLs, COBOL and DB2 programs for CPU and IO optimization using tools such as PLATINUM DETECTOR and STROBE/iSTROBE. Use scheduling techniques like parallel processing, multi-threading to reduce the application down window.
  • Query Optimization of OLTP programs to improve response time. (Stored Procedures, Cobol/DB2 Programs)
  • Improve Knowledge Repository by documenting, domain and technical expertise, best practices and lessons learnt.
  • Installation and promotion of the elements to Panvalet.

Environment: Database: DB2

Programming Language: COBOL, JCL, EASYTRIEVE

Debugging tools: XPEDITOR, SMARTTEST, Abend-Aid

Other Tools: MQ SERIES (WMB), DFSORT, Sql/eSql, Platinum, Panvalet, Spufi, Strobe/iStrobe, FTP, Quick start, Service Desk (CA), Lotus Notes, MS Visio, MS Project, EDS Metavance, XML, XSL, .Net/C#

Confidential

DB2 Database Administrator

Responsibilities:

  • Installation and configuration of DB2 UDB V8 for LUW on multiple server and clients.
  • Data modeling responsibilities. Designing database schemas and structure. Normalizing the tables in the database. Implement referential integrity and triggers for audit tracking.
  • Performance monitoring and control of databases and instances. Index creation based on performance stats and frequency of queries. Schedule and perform Reorgs and Runstats to improve response time and accuracy of data.
  • Security control and administration.
  • DB2 SQL performance optimization by modifying the queries to use best possible path. Used visual explain to optimize the queries. Joints were optimized; sub-queries were eliminated or replaced with optimized ones. Temporary tables created for frequently used sub-queries.
  • Automatic DB2 backups scheduled and mock run for disaster recoveries performed.

Environment: DB2 UDB V8, SQL, eSQL, XML, Java, HTML, Windows XP Server.

Hire Now