- Featured in:
-
More Db2 Dba Resumes
Use these Db2 Dba samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Data Systems Administration Resume Samples
Db2 Dba Resume Samples
No results found
0-5 years of experience
Responsible for database administration, performance tuning and sizing for production and development DB2 databases
- Designed, created, and maintained DB2 database objects
- Managed database growth and performance with database reorgs
- Audited application SQL code with DB2 Explain prior to production implementation
- Assisted developers in database and application tuning for optimal performance
- Loaded and refreshed non-production databases for application testing
- Provided 24/7 oncall support for production databases on a rotation basis
0-5 years of experience
Performed reorgs on a monthly basis and installed quarterly application releases
- Rolled up department database measurements (used at divisional level)
- Performed database recoveries
- Prepared detailed improvement plans of problem records and their resolutions
- Analyzed and performed tuning on IMS and DB2 databases which resulted in reduced dasd and tape costs of up $70,000 annually
- Instrumental in leading department project which determined proper tool usage within the group
- Voluntarily assumed additional responsibilities to facilitate installation of a new application
- Department lead in the establishment and implementation of procedures for the Batch Auto Ticketing project
0-5 years of experience
Hired to support the Sales Monitoring System (SMS) that generated reports reviewed daily by the CEO of the company (on call 24/7 to fix all production abends)
- Performed backup and recovery of table spaces and indexes and monitored performance/tuning
- Converted system to make Y2K compliant
- Designed, developed, created and installed a test environment to mirrored production
- Performed systems analysis, wrote a requirements, and a project plan for this effort
- Performed image copy, quiesce, recovery, reorg, report, modify, bind check, and loads
0-5 years of experience
Implemented DB2 Version 6 Query CP parallelism to support COGEN/MP property and casualty system from CSC.
- Installed, implemented, and trained staff in the use of Platinum DB2 tools, Candle Monitor for DB2, and DB2 tuning techniques.
- Tuned system DSNZPARMS, BUFFERPOOLS, SORTPOOLS, EDMPOOLS, and DASD configuration.
- Supported development and production environments.
0-5 years of experience
Managed database infrastructure on the mainframe, including installation, migration and maintenance of DB2 subsystems. Provided database administration services across all environments. Worked with users and programming staff on logical database design.
- Migrated from multiple stand-alone subsystems with cross system communication via DDF in DB2 Version 4 to DB2 Data Sharing groups across all LPARS that resulted in a huge cost reduction normally incurred from very active DB2 to DB2 DDF communication.
- Collaborated with Capacity Planning group to create SMS groups for dataset allocation parameters.
- Created and maintained DDL for all DB2 databases.
- Benchmarked development and Quality Assurance scenarios, resulting in pre-production approval.
- Performed SYSADM and Production DBA function for all DB2 subsystems and applications. Resulted in a stable environment for a company with a 24X7 uptime requirement.
- Maintained and applied all changes to all databases in the Production environment
- Collaborated with application areas to set up daily recovery strategy and BC scenario strategy.
0-5 years of experience
Software Data Support in IBM World Wide Website systems
- Supported applications in production by handling and determining the root cause analysis for issues as they come up and conducted crisis control while addressing these issues as a key element for keeping customer satisfaction.
- Provided technical support, troubleshooting, resolving and working on preventative actions related to data (setup) issues for the application that is the source of IBM products/services information
- Handled and provided weekly reports to Business Area Manager regarding OIM Level 2 queue and severity 1 issues.
- Developed and maintained shell scripts to improve and attend to the team’s needs
0-5 years of experience
Mainframe DBA responsible for implementing and supporting numerous DB it projects.
- Performed data modeling and implemented database design to support the project planning process.
- Provided production support for all DB2 mission critical databases and applications on 24X7 basis.
- Ensured business continuity by performing data maintenance, backup planning and recovery, data reorganization and updating DB statistics.
- Completed database performance monitoring and tuning to ensure optimal performance.
- Created and maintained LOB objects.
- Provided exceptional customer service, responding to inquiries in a timely manner.
- Converted simple table spaces to Universal (DB2 V10).
- Completed BIND/REBIND, SQL code reviews for new/existing applications.
- Liaised with programmers, applications/operational staff, IT project managers and other technical staff.
- Provided end user training, support and feedback to Developers on new functionality of V10, helping them become proficient with the new functions in a short time period.
6-10 years of experience
Managed a team of 10 DB2/zOS application DBAs who were responsible for providing 24×7 support for DB2 databases in multiple data sharing environments hosted at two data centers
- Primary DBA for retail brokerage databases. These databases were accessed by over 15,000 Financial Analysts as well as external clients in a 24×7 SYSPLEX, data sharing environment
- Work closely with application teams to create and maintain database objects, refresh databases, SQL tuning, and provide production support
- Implemented features of DB2 to increase database availability during REORGs and batch processing, and to allow for larger partition sizes which resulted in the ability to store more client data and statements online
- Managed project to migrate from BMC to IBM utilities. This resulted in lower software licensing costs
0-5 years of experience
Triggers to feed other systems
- Created two new tables and 76 trigger to be used to feed updates to other systems
- Created trigger SQL to keep duplicate of the control table
- Used a trigger to populate an archive table on deletion of the original table row
- Managed the PeopleSoft Database upgrade (PeopleTools 8.49 and AP/GL 9.0)
- 31 new tables with views and referential integrity
- Many data updates
- Monitored Top Ten Longest Running SQL and tuned the reoccurring SQL
- Monitored Top Ten Longest Running PeopleSoft SQL and tuned the reoccurring SQL
0-5 years of experience
- Supports 14 Production and 66 non-Production SAP system that meets or beats the SLA for response time, and up time.
- Developed and installed Index compression process that as saved 3 terabytes of DASD space with another 8 terabytes planned.
- Identified user catalog errors that was keeping DB2 RESTORE SYSTEM from working correctly.
- Optimized existing automation tablespace and index reorganization, and table partitioning.
- Database monitoring and tuning, identifying slow performing SQL and investigating reasons for slowdown.
0-5 years of experience
Installed the DB2 EE and ESE, DPF v. 8.1.4, 8.2 on AIX v.5.2.
- Created databases, backup, recovery, and tables; Set up the disaster recovery for DB2.
- Design and implemented the Data Warehouse using IBM’s Data Warehouse.
- Responsible for upgrades on DB2 across all nodes.
- Responsible for major new system at [company name].
- Performance and tuning of DB2 systems and SQL.
- Worked with Offshore Team
- Performed UNIX and Linux system administration; Responsible for the physical and logical disk layout; Installed and configured SmartDBA and Patrol.
0-5 years of experience
Short term DBA resource for data center move from NYC to Columbus, GA
- Migrated UDB/DB2 V8.2 on Linux platform to new data center.
- Performed assessment of existing system, which included reviewing physical and logical database architecture, configurations, stored procedures, batch jobs, disaster/recovery methodologies and required software levels.
- Created various data movement jobs, which included utilizing redirected restores with cold/online backups. Log shipping methodology was utilized with the larger databases (500G).
- Migrated existing PERL/DB2 Stored Procedures reporting/billing system to new data center.
- Two DBA resources implemented the database portion of the data center move within 3 hours, which included implementing various data movement predefined data movement methodologies.
0-5 years of experience
As Database Administrator I was responsible for technical assessment, analysis, design, development, and testing in DB2 (UDB v7).
- Configure, troubleshoot, and upgrade imaging scanners, VB applications, and Crystal Reports.
- Resolve tier II and III tickets.
- Train client personnel on how to use software and common debugging techniques.
- Assist sales staff with technical inquiries.
- Responsible for DB2 (UDB v7) databases. Duties included backups and log shipping, code writing and optimizing, access, monitoring, installations, creating objects, troubleshooting, maintenance plans, and cloning.
0-5 years of experience
- Wrote Detailed Analysis/Design documents and Interface Control Documents for system enhancements taking into consideration multiple factors including risks, resources required, and user impact.
- Streamlined/redesigned the tax calculation processes that provided up-to-date information on tax rules and tax methods. Eliminated redundant user processes and system resources and improved the billing accuracy and speed.
- Served as a Data Base Administrator (DBA). Redesigned the DB2 database and implemented 34 new DB2 tables with reference integrity and updated existing tables. Provided faster access to billing related data with improved run time by 22%, DASD savings up to 28%. Used QMF for SQL queries.
- Established System Backup and Disaster Recovery procedures for corporate tax data according to new government regulations and Corporate IT procedures.
0-5 years of experience
Reviewed and modified db server parms for [company name] databases to address poor perfomance. In some cases I altered some adhoc SQL and SP to process the data more efficiently.
- Automated purge of multiTB database, by detaching/attaching partitions. It was done with SP and shell scripts and scheduled in autosys.
- Worked on migrating 5 mainframe DB2 databases to UDB/Linux. Modified and re-wrote some SP to make compatible in UDB env.
- Migration from Sybase to UDB – POC.
- Database consolidation project, space/resources management.
- Moving/modifying data by writing simple Informatica jobs.
0-5 years of experience
Production DBA supporting IMS/DB2 databases across 7 complexes and 11 processing entities. Primary responsibilities included assisting development community with data access questions, supporting system during off tours, tuning databases, applications and SQL.
- Project Lead Disaster Recovery responsible for negotiating machine time, verifying recovery jobs run correctly, data validation
- RTI/DBA Savings Project Lead responsible for organizing DBA group to identify cost causers and reduce resource utilization. Created database and forms to track savings and generate cost savings.
- Analyze changes to application and database structure
0-5 years of experience
Coordinator of a team with 17 DBAs, responsible for organizing shift schedules, vacations, shift turnovers, overtime, workload and workflow processes, conflict management, etc.
- Member of a virtual team that supports the IBM Global Accounts (IGA) which includes around 200 projects with 900 instances and 1200 databases.
- Involved in server build phase, installing and configuring different DB2 products (ESE, Connect, Client) on Linux, UNIX and Windows servers.
- Involved mainly in customer database maintenance, troubleshooting, backups, restore, export, import and load, reorg, runstats, data propagation (DPROP) and HADR issues.
- DB2 for SAP support such as tablespace maintenance and backups.
- Troubleshooting performance related issues, using DB2 Explain, DB2 Advisor, snapshots, OS utilities and SQL statement tuning.
- Involved in applying ITIL best practices, such as SLA, Problem and Change management.
0-5 years of experience
Review DB2 design documents provided by both the Federal Deposit Insurance Corporation (FDIC) and Federal Reserve Board (FRB) and implement structural changes on the [company name]’s (OCC’s) DB2 subsystems.
- Update SharePoint documentation to reflect the aforementioned.
- Participate in disaster recovery planning and execution in March ’07.
- Forward all DELTA changes to SQL Server DBA’s to enable their update of downstream processes.
- Provide information for Certification and Accreditation process including but not limited detailed
- Provide continuing on-call support during weekdays and weekends.
- Maintain standalone DB2 subsystems and application; including but not limited to, ZPARM and DECP
0-5 years of experience
Help to create and implement Data Change request which includes some particular records changes, new structure or modify existing structure of databases
- Support issues of performance in stores Transactional databases (OLTP databases)
- Setup replication for development and testing environments and assist production DBAs in setting up the new environments, migration of changes done in dev and test to production.
- Setting up new envrionmnets by cloning existing environment to new servers which includes creating bufferpools, tablespaces, tables, views, triggers, stored procedure etc. using db2look.
- Data move utilities such as export, import load and db2move.
- Created shell scripts to check runstats status, check user authorization and to create objects statements dynamically from syscat tables.
- On call support, rotation based during weekends and nights.
0-5 years of experience
As a DB2 systems programmer, responsible for the installation and maintenance of 14 production and test DB2 subsystems and related software, including Platinum products, the GOAL DB2 monitor, BMC’s compression routines and ROCKET software, utilizing DB2 installation procedures and SMPE along with third party installation procedures. Brought their DB2 software, which was 18 months behind on maintenance, up to current PDO levels and kept the software current from then on. Regularly monitored and tuned their production and test DB2 subsystems, including buffer pools, the EDM pool, and disk subsystem pack space. Trouble-shot problems coming from the users, application developers, and DBAs, both in the production and test environments. Reduced CPU utilization to assist in the delay of a processor upgrade with substantial cost savings to the company. Tuned COBOL applications and end-user SQL statements producing significant savings in wall-clock time
- Developed and taught DB2 optimization and tuning techniques to the division application programmers
- Provided DBA functions to the company divisions not in possession of their own DBA, and assisted the DBAs of those company divisions in possession of one. Created and maintained databases and tables along with their respective table spaces and index spaces utilizing standard DB2 tools along with Platinum products. Migrated databases and their respective data across DB2 subsystems. Altered, loaded, unloaded, recovered, reorganized and image copied database tables and table spaces
- As an SAP administrator, supported and maintained 10 SAP R2 regions executing in a CICS/DB2 environment, applying all SAP supplied software fixes and upgrades. Assisted the application developers with their ABAP programming and debugging
0-5 years of experience
Created, maintained, and modified physical databases to include storage structures and developing linkages and enhancing the efficiency of the databases.
- Established interfaces with other database software. Established and defined database backup and recovery procedures.
- Researched and established backup schedules and retention periods for backup material. Developing procedures for reconstruction of lost or damaged data and developing security standards and procedures for controlling user access and passwords.
- Provided a rotating on-call beeper first level support to resolve production system abends.
- Involved in developing batch and CICS programs in a COBOL II, DB2, and Oracle environment. Also modified some Visual Basic panels and screens using SQL server 7.0 and Visual Basic 6.0.
- Used DB2 UDB tools to connect to the various Universal Databases.
- Got exposure to Peoplesoft and it’s usage for HR and payroll.
- Had exposure to Data Warehousing and ETL tools. Dealt with large scale DB2 recovery and backup procedures.
0-5 years of experience
Tools MS Office
- Document the Activities of the out going DBA and train the new JR. DBA to perform the necessary functions and how to use The BMC Tools
- Maintain (Create, Alter, Drop, Reorg, Backup, Load, Build and Migrate) Objects (Databases, Tablespaces, Tables, Views and Indexes) on all Sub Systems (Test, QA, Production)
- Create and Maintain Plans and Packages. Grant and Revoke Authority to users
- Use BMC Tools, IBM DBA Utilities and IBM MVS Utilities to Monitor and Maintain the DB2 system
- Author and Run DDL Scripts to Create, Alter, Drop and Migrate objects from TEST to QA to Production Subsystems
0-5 years of experience
Deliver high quality services to internal and commercial customers and support end user and middleware applications with face to face and phone interaction.
- Perform feasibility studies for installation requirements and database security to ensure a uniform environment allowing for quicker team management of problems.
- Create server build requests, change management and problem management tickets for steady state support of customer accounts.
- Execute day to day responsibilities which include the creation/deletion of db2 objects, grant/revoke privileges, perform backups/restores, alters, modify db2 instance configuration files, correct space issues, troubleshoot script/SQL errors and address any other requests that arise.
- Carry out the execution of DDL scripts as provided by the customer.
- Provided desktop, laptop and software instructions to end users and upgrade database applications.
- Create technical documentation outlining process procedures for the installation of database code, access to server and all aspects of steady state support on an individual account bases.
- Team lead of an integration group configuring desktop architecture and mobile communication applications.
- Lead technician for Windows 95 rollout to external sales offices, standardizing laptop and desktop users.
- Lead for on-going project consolidating 45 Netware 3.12 servers to 15 Netware 4.11 servers, standardizing
- Lead for two-member team that consolidated all shared data from 4 Netware 3.12 servers onto two Netware
0-5 years of experience
- Installed and upgraded new software.
- Coordinated with system analyst, system administration in logical and physical data storage design.
- Monitor, tuning to ensure all database running at the highest level of performance.
- Optimize database, tables, views, etc. Decided storage allocation, partitions.
- Completed creating JCL on MVS platform to UNLOAD/LOAD data from various resources into production Data Warehouse.
- Provided reports to managers and end users via QMF.
- Completed Function Points documentation for the Billing Data on Web (BDOW) application.
0-5 years of experience
Help mentor a group of 6 developers which included training in the following: Websphere Development Studio Client, System i Navigator on the OS/400 V5R4. Responsibilities included providing work estimates, conversion of iSeries PF to SQL tables, database object creation and modification, supporting application testing and debugging, writing and tuning SQL, writing and tuning SQL Stored Procedures, analyzing and tuning application database objects using an index advisor, identifying and resolving production data and performance issues. Advise Data & Database Administration, implement Data Management Policies & Procedures.
- Identify server hardware, software and configurations necessary for running DB2 UDB in an optimal fashion. Participate in the capacity planning and sizing activities for the data growth. Build new systems out of box by installing and configuring the DB2 UDB. Participate in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up. Participates in quarterly Disaster Recovery exercises. Design, develop and support both OLTP and large Data Warehousing related databases and applications. Optimize SQL queries and performance tuning, recommend changes in queries for better performance. Strong knowledge of the DB2 UDB architecture, memory and process model. Assist, troubleshoot and guide developers with any DB2 issues.
- Developed solutions for an in-sourcing project which consisted of eliminating utilization of a 3rd party Servicer and migrating the data in-house. This project consisted of 4 data migration phases. There were major application enhancements which included expanding functionality of pre-existing processes to incorporate business rules from the 3rd party servicer, application and database tuning to support new data loads and application rewrites.
- Developed Investor Reporting application for financing in the student loan industry utilizing DB2 SQL Stored Procedures, RPG Free, CLLE and Websphere Development Studio. Process included monthly statistics on loan payments, interest accruals, principle balance, daily SAP adjustments, and quarterly statics. Created technical specifications based on functional requirements. This code was packaged and shared with a remote client who serviced a portfolio of loans.
- Production support tasks included on-call rotation, fixing defects/work orders detected by end-users, system administrators or other development staff.
0-5 years of experience
Involved in Database design, Performance tuning, Trouble shooting, and using different kinds to tool to monitor the thread activates and upgrade.
- Worked on multi-terabyte database Partitions
- Worked on capacity planning on database level.
- Used different tools like Database Advisor to tune SQL queries.
- Worked on setting up Backup and Recovery procedures.
- Strong Experience on Database Maintenance Activities – Reorg, Runst, Export, Import and Load.
- Used to interact with the users, Developers, business analyst, storage management group, project managers, server groups and testers.
- Worked as a Database Administrator with experience in designing and implementing very large-scale Data Warehouse solution for Insurance Services Customer Relationship Management practice.
- Good exposure on Implementation, tuning and maintenance of the Databases used by the application, Data management policies and Procedures.
- Worked On Test, QA and Prod.
0-5 years of experience
- Review DB2 design documents provided by both the Federal Deposit Insurance Corporation (FDIC) and Federal Reserve Board (FRB) and implement structural changes on the [company name]’s (OCC’s) DB2 subsystems.
- Update SharePoint documentation to reflect the aforementioned.
- Participate in disaster recovery planning and execution in March ’07.
- Forward all DELTA changes to SQL Server DBA’s to enable their update of downstream processes.
- Provide information for Certification and Accreditation process including but not limited detailed description of RACF policy and implementation as it relates to all DB2 defined structures.
- Provide continuing on-call support during weekdays and weekends.
- Maintain standalone DB2 subsystems and application; including but not limited to, zPARM and DECP changes, adjustment of primary and secondary allocations and subsequent REORG’s of application, DB2 Catalog and Directory table spaces and index spaces.
10+ years of experience
Supported multiple in house written applications including a student management system, inventory control, plant operations, travel authorization, staff development, school location and cafeteria management. Responsible for all aspects of DB2 including installation using SMPE down to 24/7 online and batch support.
- Support district financial system conversion from VSAM to DB2. A 12 month project culminating in a more comprehensive, user friendly system with enhanced reporting capabilities. Provide support for vendors and contractors that were writing custom reports for budget center managers and financial executive staff members.
- Support development staff for an in house written student management system. This system was converted from an IMS database to DB2 with CICS as the online transaction manager. Provide backup and recovery, data transfers between development and production, performance tuning, support QMF ad hoc reporting and nightly batch processing.
- Assumed support role for legacy IMS databases. Responsible for software installation, CICS online access, batch processing, database engine troubleshooting.
- Support a web based procurement system with a DB2 for Z/OS back end. This system requires a multi-platform solution including DB2 UDB on Windows, DB2 Connect, Websphere for Windows and JDBC connections to the mainframe using DDF. Charged with maintaining and tuning extremely complex SQL queries for use by executive staff, procurement services staff, and outside vendors.
0-5 years of experience
Performed system and application recovery as well as database performance.
- Supported several applications ~ worked with application analyst on design, testing and tuning. Provided primary support for a life insurance application (ATLAS). Created DDL for new Databases, tablespaces and indexes in the unit test, system test and production system. Monitored the applications with BMC, IBM, CA and Strobe tools for DB2 as needed to accomplish acceptable performance.
- Identified inefficient SQL code and made recommendations for improvement. Modified or created indexes, or rewrote the SQL statement. Made recommendations to change COBOL code to make the process more efficient.
- As a DBA, created RACF (DB2 security) groups and granted the needed DB2 access authorities for individuals, application groups and production jobs.
- Implemented Resource Limit Facility (RLF) to control Dynamic SQL on all mainframe platforms resulting in over a million dollar savings in CPU from dynamic SQL. If the dynamic SQL statement exceeded its threshold it was not allowed to run.
- Created reports using SMF records which allowed me to work with analyst responsible for long running queries, either eliminating or tuning them to acceptable standards.
- Was also involved on the interview staff of DBAs. Performed technical interviews of DBA candidates to determine if they had the level of expertise they claimed to have. Would present hypothetical situations and ask them to explain how they would fix the problem.
6-10 years of experience
Develop and Implement production programs, JCL, Procs and DB2 components for IRS CADE system. Responsible for actual production implementation of developed software and database components. Develop and test programs, DB2 loads, unloads and creates for all environments. Including multiple test environments, QA and Production environments. COBOL, Syncsort, JCL, ENDEVOR and DB2 used daily for development. Provide ALC support developing and maintaining ALC for the IRS. Develop COBOL programs as necessary to support tax systems. Created Unit test cases and executed them. Also responsible for testing of all new modules and utilities for production system. Migrated modules through test to other Endevor systems.
- Provided CADE 2 support for scheduling, production problems and debugging of JCL. Monitor job execution and any issues that might require support. Control-M support, DB2 support and JCL support. InfoSphere Database replication and administration training.
- Used Strobe and Omegamon to resolve slow running programs. Tuned Database as necessary to eliminate these issues and made code changes and/or SQL changes along with index changes to resolve performance problems.
- Used DB2 Admin utilities as well as other IBM DB2 utilities to load, make image copies and other related DBA tasks.
Data Systems Administration Cover Letter Examples
Rate This Article
[Db2 Dba]
Last edited by: Gabriela Barcenas, CPRW, Content Writer II -
Gabriela Barcenas
CPRW, Content Writer IIGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
