DB2 DBA Consultant Resume

SUMMARY

11+ years of directed participation in database administration, design, and maintenance for OLTP/OLAP 24*7 high workload financial and insurance businesses
Proficient in software installation, capacity planning, automated backup implementation, and query/performance monitoring/tuning
Expertise in implementing High Availability solutions (DB2 HADR and Oracle DataGuard).
Hands - on experience with Oracle 11g/12c/19c architecture, query tuning, AWR/ASH reports, and database security/auditing users/roles.
Experienced with Oracle ASM, RAC, Clusterware, RMAN, DataPump in 7*24 businesses.
Installed, configured, and tested Oracle GoldenGate.
Self-motivated, expert with problem-solving skills often used to proactively forecast environmental issues and find optimal and cost-effective solutions in the database and query design
Organized, on-time, self/fast-learner, team player, and eager to new challenges
Comfortable to work under tight timelines, on-call/on-site support, and overnight hours

TECHNICAL SKILLS

Databases: Oracle 11g/12c/18c/19c, Db2 9.7/10.5, DB2 zOS 9.1/10.1, SQL Server 2005/2008

Operating Systems: HP-UX, Oracle Enterprise Linux, Windows NT, Red Hat Linux, z/OS

Languages: SQL, PL/SQL, shell scripting

Tools: Oracle EM, RMAN, Oracle DataPump, AWR, ADDM, EXPLAIN PLAN, IBM Data Studio, DBArtisan, Management Studio, Redgate, Spotlight, Zabbix, and JIRA

PROFESSIONAL EXPERIENCE

DB2 DBA Consultant

Confidential

Responsibilities:

Maintained and administrated over 100s test/develop/product Oracle 11g/12c/19c databases in 24*7 environment of over 20 financial and insurance businesses.
Experience on a fully developed Oracle infrastructure with Maximum Availability Architecture using ASM, RAC, and DataGuard.
Performed complex database maintenance such as designing scripts, defining indexes, analyzing requirements, access paths, and table partitioning.
Experienced in Oracle database security: schema auditing, user management, proxy authentication in production environment.
Developed and tested various database recovery scenarios: media failures, dropped tables, and data-file/block corruptions.
Managed database resources (Indexes, Clusters, and Tables), allocated physical storage structures like data-files, redo logs, control files, and logical storage structures like table spaces.
Adjusting Degree of Parallelism (DOP) in Oracle 12c for solving performance issue in production.
Installed and implemented Oracle GoldenGate for HW/SW migration from HP-UX Oracle 11g to Oracle Enterprise Linnux Oracle 19c.
Technical leadership for developing and implementing a data/structure migration plan from Oracle 11g to DB2 10.1 z/OS.
Trained and instructed staff to get familiarized with z/OS and DB2 concepts on two courses/workshops.

Senior DB2 DBA

Confidential

Responsibilities:

Migrated SQL-Server/MySQL (data/structure) into Db2 (LUW/zOS) to integrate all the company’s databases.
Envisioned and designed an enterprise-framework to establish financial and insurance projects of over 20 transactional OLTP (3000 TPS at peak) and analytical OLAP (over 10TB of data) databases on DB2 LUW 10.5 and DB2 z/OS 10.1.
Led and successfully implemented HADR and TSAMP automatic failover to ensure business RTO/RPO requirements meet with business continuity plans.
Stored and managed application logs in a fully partitioned database with over 200GB growth per day utilizing Db2 JSON NoSQL capabilities.
Performed automated daily backups and scheduled reorg, rebuild, runstats, and rebind.
Monitored database activity during peak time and extracting heavy queries using different monitoring tools.
Evaluated and examined DB2 zOS standalone utilities in case of loss of active/archive log, and BSDS, coldstart, applying new RBA, catalog tables capacity planning, and copy Db2 VSAM datasets.
Participated in the design and planning of new projects with developers and prepared a must follow standard document for database object definitions.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship