Mainframe Db2 DBA Resume Samples

Description :

1. Altered the DB2 Objects in Production and Test Environments.
2. Responsible for analyzing index requirements and designing appropriate indexes.
3. Implemented and scheduled production DB2 jobs.
4. Granted the privileges on DB2 objects for Application Users.
5. Supported the Application team to resolve the DB2 issues.
6. Reviewed the JCLs, DDLs, Grants, Changes, and Scheduling details created by the team members.
7. Supported and maintained production to test database downloads.

Experience

0-2 Years

Level

Entry Level

Education

BSc in CS

Description :

1. Developed, managed, and tested backup and recovery plans.
2. Ensured that storage and archiving procedures are functioning correctly.
3. Communicated regularly with technical, applications, and operational staff to ensure database integrity and security.
4. Managed the security and disaster recovery aspects of a database.
5. Provided excellent customer service by monitoring and responding to Technical Services related incidents, service requests, and project tasks.
6. Interacted with cross-discipline support teams to resolve issues, and develop, and deliver solutions.
7. Provided training to IT and business units on the use of mainframe System Software.

Experience

7-10 Years

Level

Senior

Education

MSc in IS

Description :

1. Worked closely with Audit and Security teams to address outstanding items and prioritize remediation tasks, notifying IT Security of possible exposures.
2. Completed required PMO documentation, time entry, and status reports, and contributed to the annual budget process.
3. Designed and managed database architecture, integration, data modeling, and environments, including developing and maintaining related objects, security, and audit measures.
4. Managed database performance, capacity, and availability, including data recovery and DBMS software implementation, upgrades, and patching.
5. Consulted with multiple client groups to provide strategic datadatabase solutions and advise on data analysis principles, methods, and trends.
6. Designed complex data transformation strategies for business intelligence or data migration and led data mapping and model conversion projects.
7. Developed and maintained database support documentation, providing oversight, mentoring, and leadership to less experienced staff.

Experience

10+ Years

Level

Management

Education

BSc in IT

Description :

1. Performed Database Administrator functions with IBM DB2 for zOS and IBM IMS.
2. Managed backup and recovery procedures and Database Performance Issues.
3. Monitored Space usage; plan to close the Space Gaps by taking necessary action
4. Provided on-call support for deployments and critical database issues.
5. Followed standards, wrote, maintained, and documented monitoring scripts needed in support of applications.
6. Worked with the Mainframe DB2 team, area management, and related technical support groups in the process of engineering mainframe database solutions.
7. Evaluated, installed, configured, and maintained DB2 for zOS, related software products, and supporting tools.

Experience

5-7 Years

Level

Executive

Education

MBA

Description :

1. Supervised database activity and assisted developers and business clients in the utilization of databases.
2. Provided support for Disaster Recovery tests, database infrastructure changes, application changes, and business operations.
3. Supported backup and recovery of DB2 databases.
4. Responded to alerts related to the DB2 database environment.
5. Assisted in the configuration and setup of distributed database connections using JDBC
6. Mitigated risk by following established procedures and monitoring controls, spotting key errors, and demonstrating strong ethical behavior.
7. Diagnosed and resolved complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution.

Experience

2-5 Years

Level

Junior

Education

BSc in SE

Description :

1. Worked with developers to diagnose and resolve database-related application issues, supporting schema maintenance and data distribution.
2. Provided expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and resolution.
3. Communicated effectively with customers in both oral and written forms and coordinated training for assigned infrastructure functions within a diverse and dynamic system environment.
4. Ensured daily operations ran smoothly by managing tasks such as installation, performance monitoring, access, security, back-ups, scheduling, inventory management, and order processing, within a diverse environment with multiple vendors and sites.
5. Planned and scheduled installations of new or significantly updated products and analyzed system performance.
6. Resolved resource competition issues, and recommended system configurations based on costs, specifications, and organizational policies.
7. Communicated effectively with IT counterparts, addressing performance problems and maintaining relational database integrity while considering constraints, linked tables, consistency, and data-level security.

Experience

0-2 Years

Level

Fresher

Education

MSc in DS

Description :

1. Assessed and integrated new technologies, established standards, and recommended operational changes to optimize resource use.
2. Managed data-related decisions, including data sharing, location, usage, security, integrity, flexibility, and resource allocation.
3. Established and enforced metadata standards, reviewed and approved logical data models, and conducted training in data modeling and design.
4. Navigated a diverse and dynamic planning environment with multiple remote locations and varied standards, integrating multiple systems from public and private organizations.
5. Supported multiple DB2 subsystems simultaneously, supported client and internal requests for building all types of DB2 objects.
6. Created and managed DB2 objects like Databases, Table spaces, Tables, and Indexes in Production and development regions.
7. Managed and maintained Db2 databases on mainframe systems, ensuring optimal performance and availability.

Experience

7-10 Years

Level

Consultant

Education

BA in Math

Description :

1. Managed DB2 table changes to support application design.
2. Supported Application Group Change Management migration of DB2 code, STPs, and security for production migrations
3. Supported Custom Archive purge procedures and jobs as required
4. Assisted the Application group with SQL development as required
5. Used Change Control procedures for system changes that impact the DB2 database instances that support CICS, DB2 stored procedures or packages, or other environments.
6. Led DB2 Application support for Disaster Recovery with the Outsourcer for database recovery with the outsourcer's technical DBAs,
7. Managed, reviewed, and communicated database projects with the Application, Infrastructure, and Outsourcer.  DB2 upgrade or required changes with the outsourcer.

Experience

7-10 Years

Level

Consultant

Education

DBA Cert

Description :

1. Developed scripts (JCL, REXX) to manage, maintain, and provide reporting on vital database activities and execution of jobs.
2. Designed, developed, implemented, and provided operation support for database security.
3. Prepared disaster recovery (DR) documentation and participated in DR activities to ensure database recovery at the DR site was within set Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
4. Planned and executed Db2 software upgrade activities.
5. Managed and maintained our enterprise-level DB2 databases on zOS. 
6. Administered and maintained DB2 databases on IBM zOS mainframe environments, including installation, configuration, upgrades, and patching.
7. Monitored and optimized the performance of DB2 databases, identifying bottlenecks, and implementing performance tuning strategies to ensure high availability and responsiveness.

Experience

5-7 Years

Level

Executive

Education

BSc in CE

Description :

1. Implemented and managed database security, including user access controls, encryption, and auditing, ensuring compliance with industry standards and company policies.
2. Responsible for troubleshooting and resolving issues related to DB2 database operations, including providing support for complex technical problems and developing root cause analysis.
3. Ensured data integrity and availability by managing replication, data migration, and data archiving processes.
4. Maintained comprehensive documentation of the database environment, including configurations, processes, and procedures.
5. Worked closely with application developers, system administrators, and other stakeholders to design and implement database solutions that meet business requirements.
6. Participated in the development and testing of disaster recovery plans to ensure data continuity in the event of a disaster.
7. Ensured that database systems comply with regulatory requirements and participate in regular audits.

Experience

2-5 Years

Level

Junior

Education

MSc in Cyber