DB2 LUW Database Administration Resume

SUMMARY

I am a LUW Data Base Administrator/Analyst (DBA). I have worked with DB2 LUW releases for over 20 years.
I have worked as database developer and also supported the databases in production. I install new DB2 releases and fixpacks; configure DB2 parameters; manage database recoverability, availability, security, performance, audit readiness, high availability; perform problem determination and support disaster recovery. I have experience with Confidential BLU Acceleration and Power - HA. I have experience as a DBA team leader/advisor.
I have worked with multi-terabyte databases with the high throughput OLTP applications. I was one of the developers of Data Sharing environment at Confidential, I have knowledge of System Development Life Cycle (SDLC). I have SQL tuning and application performance improvement experience.
I am able to work quickly on production problems and revolve DB2 issues quickly and effectively.
I have excellent analytical and troubleshooting skills. I have years of experience providing Oncall support.
I have Data Replication experience. I have experience with Distributed Environments.
I am a quick learner and can pick up new material and apply them quickly.
I have skills in DB2 LUW on Linux, SQL, Korn Shell Programing, AIX, Tivoli Storage Manager, SAN Storage, Performance tuning, problem determination, automation and script writing
I have skills as a Quality Analyst, analyzing problem tickets and performing Root Cause Analysis (RCA) to find the root cause of the problems.

TECHNICAL SKILLS

RDBMS: DB2 LUW 11.1, Db2 z/OS 11

Platforms: Linux, Unix, AIX, Windows, z/OS

Confidential Cloud: Softlayer, Ansible, SSH, Red Hat Linux / IPA (Identity Management)

Process Agile Methodology:

Testing JMeter, JUnit, Test Automation:

Languages SQL, Korn Shell, C++, JCL, REXX:

Change Management: jira, RTC, TSRM, Remedy

Application Servers: WebSphere Application Server, SAP

Tools: PCOM, jira, Slack, Box, github, Excel, SquirrelDBeaver, Webex, Outlook, Word, Powerpoint:

PROFESSIONAL EXPERIENCE

Confidential

DB2 LUW 11.1 - Confidential BLU Acceleration on Confidential Power-HA

Responsibilities:

Worked on the design and development of a digital analytical financial application on a DB2 LUW 11.1 database.
Designed/developed the DB2 database objects. I worked during the entire life cycle of the project.
Started from meeting with end users to find out the requirements, to architecting/designing the solution and building the database components.
Used the Confidential BLU Acceleration for the DB2 database on Confidential Power-HA. Worked with a multi discipline team.

Confidential

Responsibilities:

Provide Identity Management for Linux Virtual Machines. Using SSH, Ansible, IPA (Red Hat Identity Management) and Internal

Tools: . Supporting User Onboarding/Offboarding, Security, Shared Userids, Compliance, Audit and Penetration Testing.

Confidential

DB2 LUW Database Administration

Responsibilities:

Supported Confidential BLU Aceleration on Confidential Power-HA
Supported HADR DB2 environment.
Managed numerous DB2 Confidential and commercial databases.
Coordinated work with customers, account teams and other technical teams.
Provided technical expertise to implement changes and resolve incidents.
Subject matter expert in build, manage, implementation and administration of DB2 z/OS and LUW
Perform database rollouts, releases, upgrades and or application/Operating system releases/upgrades
Identify, troubleshoot and resolve database problems
Skillful in performing Operating system (AIX, Linux, Solaris, Windows) activities related to database
Monitoring & troubleshooting databases, alerts, backups and performance issues
Provided 24x7 support for all production databases
SQL Replication feature
Data Partitioning Facility
Automated database maintenance
Reduced repetitive problems by leading Root Cause Analysis and implementing preventative actions across all our customer environments.
Passed multiple audits by ensuring the team adheres to all industry and Confidential security guidelines and problem and change procedures.
Increased team efficiency and improved delivery quality by automating weekly database maintenance processes
Optimized performance of critical SQL statements to reduce run time up to 99%.
Successfully intervened in multiple troubled accounts, increasing customer satisfaction by improving communication and procedures.

Confidential

DB2 z/OS Database Administration

Responsibilities:

As a DB2 z/OS DBA, I configured DB2 parameters; executed DB2 utilities; managed database recoverability, availability, security, performance, audit readiness, high availability; performed problem determination and supported disaster recovery on the z/OS platform.

Confidential

z/OS Operating System Developer

Responsibilities:

I was a developer of the z/OS Operating system specializing in the Recoverability, Availability and Serviceability (RAS) components of z/OS.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship