Db2 Luw Systems Dba Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Motivated self - starter, problem solver and versatile DB2 DBA with proven leadership experience in managing complex DB2 LUW environments.
- Team player and effective communicator, focused and dedicated to creating results that meet or exceed expectations.
- 20 Years of IT experience
- Multinational Project Management and Team Lead skills
- 15 years of experience with due diligence, sizing and DB2 LUW support transition projects
- Strong customer facing skills with the ability to communicate complex technical decisions to clients and account teams
- 15 years of experience developing strategies for backup and recovery of Large and DPF databases
- Skilled with using 3rd party tools such as Tivoli Storage Manager and Netbackup, Informatica, Data Studio, DBArtisean, Rapid SQL, Visio, Erwin Data Modeling
- 13 years of experience with configuring Disaster Recovery and High Availability DB2 environments including HADR and HACMP
- 10 years supporting DB2 in LDAP and Websphere environments
- Solid experience supporting data migrations and DB2 version upgrades
- Extensive experience supporting DB2 LUW product family and features including DB2 Client, DB2 Connect, Data Studio,SQL Replication, Q Replication, Compression, DB2 Autonomics, and DPF databases across various versions of DB2 LUW ( V5.2 - V11.1)
- Experience with DB2 Snapshot and Event monitoring and tools including DB2pd, DB2Top and AIX Topas/Linux Top
- Knowledgeable in application development life cycle support of DB2 LUW databases
- Skilled with business productivity tools including MS Office, MS Project, Lotus Symphony as well as server management tools like Hummingbird, Putty, Citrix and VMware
PROFESSIONAL EXPERIENCE:
Confidential
DB2 LUW Systems DBA
Responsibilities:
- Providing 24x7 support for Large AIX/Linux DB2 environment
- Managing complex data migration processes across platforms
- Cross DBMS data migrations Oracle/SQL Server/Terradata
- Planning and Scheduling large scale DB2 Version and Fixpak upgrades
- Building monitoring procedures for capacity,availability and resource usage on DB2 databases
- Working with Application teams and management to oversee new database builds and deployment through the product life cycle
- Provided SQL tuning and monitoring support as well as Managing DDL changes and capacity Planning
- Managing security and access privileges to DB2 databases including ssh and Cipher controls
Confidential
DB2 DBA and Team Lead
Responsibilities:
- Supporting over 250 AIX, Linux and Windows Production DB2 commercial databases including Health care Service providers, Government entities and Financial institutions
- Supporting a variety of DB2 implementations including Q Replication, HADR Single Standby systems, DPF, and Federated databases
- Managing the build and configuration of DB2 databases for SAP
- Supporting a 40 TB Analytic database for a retail customer
- Provided Performance Monitoring and Tuning support usingDB2 Snapshot and Event monitors and tools including DB2pd, DB2Top and AIX Topas
- Gathered and maintained account and organization metrics related to productivity and efficiency for presentation to upper management
- Procedural documentation focal for DB2 LUW technical tasks such as Base Software installs, Fixpak and APAR installations, DB2 version upgrades, Data Migration planning, High Availability Disaster Recovery configuration and backup and recovery assessments
- Lead in the implementation of the LEAN model in the Boulder Delivery Center
- SME and Workload Manager for 14 member DB2 LUW DBA team
- Audit and database security focal managing quarterly security compliance reviews across all DB2 LUW server environments using industry standard protocols (ITCS104, ISEC,Sarbanes-Oxley)
DB2 UDB Team Lead
Confidential
Responsibilities:
- Managed the Production and Transition On Demand Center Services DB2 LUW database teams
- Managed the Logical and Production DBA teams supporting a diverse customer base in Development, Test and Production environments
- Supported over 150 DB2 LUW databases across multiple industries including High Volume retail customers like Hallmark.com and Circuit City
- Implemented standardized support tools across all DB2 environments to enhance monitoring, tuning and recovery
- Procedural documentation focal assigned to create Best Practice documents for database support tasks like Software installs and updates, Data migration planning, Capacity planning, High Availability Disaster Recovery configuration, Replication, Backup and recovery procedures.
- Audit and database security focal managing security compliance across all DB2 LUW server environments using industry standard protocols
- Sized and managed the implementation of new projects for existing accounts and the transition of new accounts into the team.
DB2 UDB DBA Team Lead
Confidential
Responsibilities:
- Managed Production LUW DBA team supporting Commercial and Internal customers in a 24x7 environment
- Supported over 100 LUW databases including critical Confidential internal applications like the Confidential Labor Claiming and Confidential 's systems(Learning Services)
- Implemented standardized support tools across all DB2 environments to enhance monitoring, tuning and recovery
- Audit and database security focal managing security compliance across all DB2 server environments using industry standard protocols maintaining 100% compliance during my tenure
- Sized and managed the implementation of new projects for existing accounts and the transition of new accounts into the team.
- Technical lead that assisted in building and deployment database solutions as well as and assisting new DBA's in their role
Confidential
DB2 UDB and SQL Server Database Administrator
Responsibilities:
- Provided 24x7 DB2 LUW support for various Confidential Internal and External customers
- Account focal for over 50 LUW databases and 25 SQL Server instances
- Worked on-site with our customers to build recovery procedures and evaluate database performance
- Performed periodic healthchecking of database security compliance based on industry standard protocols
- Managed the planning and implementation of database and application changes in Test and Production environments
- Monitored problem logs and performance reports to preempt problems while working with vendors to resolve software related issues
- Assisted in capacity planning and resource utilization discussions
- Organized a DB2 LUW User group in Boulder to periodically discuss the Database arena, arranged speakers to discuss specific topics of interest and current issues related to DBMS support
- Attained DB2 LUW V8