We provide IT Staff Augmentation Services!

Senior Db2 Dba Resume

NY

SUMMARY

  • Seventeen years of professional experience, specializing in Operating Systems & Relational Database Administration, Team Leadership skills and experience, AIX certified, and Linux savvy.

TECHNICAL SKILLS

Operating Systems: AIX 6.1 & V7.1, RedHat Enterprise Linux, HP/UX Windows 7, 10

Languages: SQL/DSQL, korn, C & bash shell scripting, Perl V5.10

Databases: DB2 LUW V10.5, V11.1 & SQL Server 2016 & SS Management Studio

Other Software: Erwin ERD, Oracle Applications & RMAN V11, Quest Toad, ODBC/JDBC, PeopleSoft 8.4.6, Tivoli Storage, EMC SRDF, Vmware, Websphere Application Server, LDAP, IBM Data Studio and Optim Performance Manager. Pure App and Pure Scale. MongoDB.

PROFESSIONAL EXPERIENCE

Confidential, NY

SENIOR DB2 DBA

Responsibilities:

  • Install and implement DB2 LUW on AIX, Linux and Windows platforms
  • Setup archive logging and implement online backup & pruning tasks using shell scripts and automated task scheduler.
  • Understanding of sql queries for better performance, review code and make suggestions to developers for improved performance of queries.
  • Manage all db and table space activity including OS level responsibilities such as Volume Groups, logical volumes, file systems and mount points
  • Design and build databases instances on IBM pSeries servers or VM’s
  • Responsible for database security at the instance, database and OS levels.
  • Work with software engineers and application teams to satisfy application requirements
  • Setup and maintain federated servers and databases including federation between DB2 V10.5 and SQL Server 2014.
  • Setup and configure TSM or NETBACKUP as required.
  • Install DB2 fix packs and preform DB2 upgrade, perform migrations
  • Install Sql Server service packs and cumulative updates, perform migrations
  • Monitor DB2 security and health using db2 scripts, Data Studio
  • Available for 24/7 response and on - call duties, nights and weekends
  • Recently installed and implemented Optim Performance Manager
  • Recently Installed and implemented MongoDB

Confidential, Jacksonville, FL

Oracle/DB2 DBA Team Lead

Responsibilities:

  • Managing from 15 to 25 Oracle & DB2 Database Administrators
  • Conducting team meetings & provide guidance for newer resources.
  • Teach and mentor entry or mid-level dba resources.
  • Manage DBA resources - time sheets, time off, vacations, liaison for concerns from both Bank and Confidential management, Local, remote and off-shore DBA’s.
  • Install and implement DB2 LUW V9.7 on Mid-Range platforms - AIX, Solaris, Linux and Windows
  • Design for performance and tune existing databases for better performance using database configuration parameters and table cardinality.
  • Understanding of the Optimizer, Data access paths, visual explain and indexes
  • Understanding of SQL queries unions and joins, alter SQL queries for better performance, review UOW and make suggestions to developers for improved performance
  • Understand buffer pools and table space types, SMS, DMS and Automatic Storage
  • Design and build DB2 servers on IBM P Series servers and virtual machines
  • Work with other teams, system engineers and application teams to satisfy application requirements
  • Setup and configure DB2 for HADR
  • Setup DB2 and work with SA for Red Hat Cluster fail over system
  • Design, configure and implement DB2 DPF with 220TB total storage in production/contingency environments Catalog node plus 4 physical data nodes with 16 logical nodes on each.
  • Support automated tasks and related Perl and Shell scripts via crontab entries
  • Manage active & archive logging, table spaces and database performance
  • Install and configure Quest Fog Light monitoring
  • Write and maintain Perl and shell scripts for pruning old logs or message files.
  • Provide client software installation with DB entries using DB2 Connect and RTC
  • Build single and multiple partition databases
  • Support performance, permissions, databases and table spaces
  • Implement SAN replication using EMC SRDF solution

Confidential, Atlanta, Ga

Senior DB2 Consultant

Responsibilities:

  • Plan and implement major upgrades for PeopleSoft and DB2
  • Work with system administrators and PeopleSoft administrators to plan, test and document upgrade procedures to PeopleTools Ver. 8.9.4 and DB2 Ver. 9.1 & 9.5 and AIX Ver 6.1
  • Redesign physical layout of file systems, volume groups and physical disks to incorporate performance techniques
  • Personally reduced units taking several hours down to just 15 minutes
  • Responsible for 18 - 20 database servers, mostly p-series servers, running AIX 5.3.3 and DB2
  • Maintained all crontab entries and shell scripts used for online and offline backups, runstats, reorgs as well as other automated tasks
  • Taught junior level DBA’s these techniques and provided purpose and reasoning

Confidential, NC

DB2 DBA / Developer

Responsibilities:

  • Responsible for the design and general database administration of five DB2 UDB ESE V.8.1 environments running under Linux on IBM Blade center servers
  • Responsible for data loads from 23 countries
  • Create and maintain complex sql queries, triggers and stored procedures
  • Use Data Stage to produce ETL processes for all data loads, manage load calendar and write procedural documents that contain verification and back out instructions
  • Automate loads through shell scripting and execute via crontab
  • Retrieve data in various formats from 23 different IBM locations around the globe and load to warehouse maintained by our team
  • Performance tuning of data warehouse loads and reports
  • Working closely with developers and system administrators to resolve performance bottlenecks

Hire Now