Post job

What does a database administrator db2 do?

Updated January 8, 2025
7 min read
On this page

Database administrator db2 responsibilities

Here are examples of responsibilities from real database administrator db2 resumes:

  • Lead multiple infrastructure planning and implementation including instance strategy, technical platform selection, architecture design, backup and recovery strategy.
  • Provide DBA support for various applications on AIX and Linux.
  • Work on a data migration project from AIX to Linux system.
  • Design, create, implement, maintain, tune and support DB2/UDB databases on UNIX and z/OS.
  • Install mainframe and file server components, process schedulers, client-server databases, BMC software, and other relate products.
  • Create JCL jobs for subscription management and monitoring.
  • Support numerous java base applications, JDBC and SQLJ.
  • Design and code XML document storage and transfer applications using Java.
  • Provide DBA support for all IMS tools including BMC and UBS products.
  • Support a web base procurement system with a DB2 for Z/OS back end.
  • Create tables/indexes and promote to various subsystems, including production using BMC change manager.
  • Provide on-call coverage for a worldwide 7x24 online distribute OLTP application on an AIX platform.
  • Involve in writing several UNIX shell scripts to monitor table space usage, buffer pool usage.
  • Experience working with ETL tools to extract DB2 data from ZOS to staging tables in distribute platform.
  • Develop ETL routines using DB2 load, unload utilities, DB2 connect, (data warehousing) and imports/exports.

Database administrator db2 skills and personality traits

We calculated that 5% of Database Administrator DB2s are proficient in DB2 DBA, DB2 Database, and Mainframe. They’re also known for soft skills such as Analytical skills, Communication skills, and Detail oriented.

We break down the percentage of Database Administrator DB2s that have these skills listed on their resume here:

  • DB2 DBA, 5%

    Maintained SAP Databases of more than 15TB database size and worked as DB2 DBA for SAP R3 systems.

  • DB2 Database, 5%

    Performed day-to-day administration of DB2 databases, including security, backup/recovery, capability planning and performance tuning.

  • Mainframe, 4%

    Provided support for mainframe DB2 insurance applications databases.

  • Database Design, 4%

    Performed Physical Database Design, collaborating with architects in deciding the partitioning keys, DDL implementation, modification and design.

  • Linux, 4%

    Created and managed the Operational Level Agreement document and process; produced website for the DB2 Linux Unix and Windows team.

  • Windows, 4%

    Do Production Deployments during maintenance windows.

"db2 dba," "db2 database," and "mainframe" are among the most common skills that database administrator db2s use at work. You can find even more database administrator db2 responsibilities below, including:

Analytical skills. One of the key soft skills for a database administrator db2 to have is analytical skills. You can see how this relates to what database administrator db2s do because "dbas must monitor a database system’s performance to determine when action is needed." Additionally, a database administrator db2 resume shows how database administrator db2s use analytical skills: "performed database administrative tasks for db2 object creation, database performance monitoring and tuning and application tuning. "

Communication skills. Many database administrator db2 duties rely on communication skills. "most database administrators work on teams and need to communicate effectively with developers, managers, and other workers.," so a database administrator db2 will need this skill often in their role. This resume example is just one of many ways database administrator db2 responsibilities rely on communication skills: "served as primary technical support contact for a large international telecommunications customer (rogers) in an oracle rac environment. "

Detail oriented. database administrator db2s are also known for detail oriented, which are critical to their duties. You can see how this skill relates to database administrator db2 responsibilities, because "working with databases requires an understanding of complex systems, in which a minor error can cause major problems." A database administrator db2 resume example shows how detail oriented is used in the workplace: "monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. "

Problem-solving skills. For certain database administrator db2 responsibilities to be completed, the job requires competence in "problem-solving skills." The day-to-day duties of a database administrator db2 rely on this skill, as "when database problems arise, administrators must troubleshoot and correct the problems." For example, this snippet was taken directly from a resume about how this skill applies to what database administrator db2s do: "design and implement monitoring procedures using both z/os and desktop solutions. "

See the full list of database administrator db2 skills

Choose from 10+ customizable database administrator db2 resume templates

Build a professional database administrator db2 resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your database administrator db2 resume.
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume
Database Administrator DB2 Resume

Compare different database administrator db2s

Database administrator db2 vs. Data modeler

A data modeler is responsible for designing and creating network systems and applications for efficient and secured data storage solutions. Data modelers work closely with the data management team to identify business needs and execute data modeling techniques for comprehensive analysis. They also strategize in improving existing data systems, upgrading infrastructure, and configuring information for compatibility with every business unit. A data modeler must have excellent technical skills, as well as a strong command of programming languages to modify and optimize data models for smooth navigation and access.

If we compare the average database administrator db2 annual salary with that of a data modeler, we find that data modelers typically earn a $12,447 higher salary than database administrator db2s make annually.Even though database administrator db2s and data modelers are distinct careers, a few of the skills required for both jobs are similar. For example, both careers require z os, linux, and ibm db2 in the day-to-day roles and responsibilities.

There are some key differences in the responsibilities of each position. For example, database administrator db2 responsibilities require skills like "db2 dba," "db2 database," "mainframe," and "database design." Meanwhile a typical data modeler has skills in areas such as "data analysis," "data architecture," "physical data models," and "tableau." This difference in skills reveals the differences in what each career does.

Data modelers tend to make the most money working in the pharmaceutical industry, where they earn an average salary of $115,205. In contrast, database administrator db2s make the biggest average salary, $107,009, in the manufacturing industry.On average, data modelers reach higher levels of education than database administrator db2s. Data modelers are 5.6% more likely to earn a Master's Degree and 1.2% more likely to graduate with a Doctoral Degree.

Database administrator db2 vs. Database internship

A database developer/database administrator specializes in designing and developing database programs and systems, maintaining and updating them regularly. They are in charge of understanding project needs and guidelines, establishing and implementing test systems to identify potential risks and issues, fixing and upgrading components, and storing data according to protocols. They may also produce and present reports to managers and participate in creating security and recovery plans to protect company data. Moreover, as a database developer/database administrator, it is vital to be proactive at dealing with issues while adhering to company standards.

On average, database interns earn a $3,142 lower salary than database administrator db2s a year.Only some things about these jobs are the same. Take their skills, for example. Database administrator db2s and database interns both require similar skills like "database design," "linux," and "windows" to carry out their responsibilities.

While some skills are similar in these professions, other skills aren't so similar. For example, resumes show us that database administrator db2 responsibilities requires skills like "z os," "db2 dba," "db2 database," and "mainframe." But a database internship might use other skills in their typical duties, such as, "pl/sql," "python," "microsoft sql server," and "database management."

In general, database interns achieve lower levels of education than database administrator db2s. They're 5.9% less likely to obtain a Master's Degree while being 1.2% more likely to earn a Doctoral Degree.

Database administrator db2 vs. Database manager

A database engineer is responsible for maintaining the security of an organization's network databases, preventing unauthorized access and activities, and upgrading data infrastructure. Database engineers manage the volume of stored data, ensuring that the information would not affect the traffic flow and navigation. They also design database according to business requirements and needs, conducting multiple quality checks before releasing the final outputs for high functionality. A database engineer must have excellent technical skills, as well as extensive knowledge of programming languages and database administration, to create efficient system networks.

An average database manager eans a higher salary compared to the average salary of database administrator db2s. The difference in salaries amounts to database managers earning a $11,573 higher average salary than database administrator db2s.By looking over several database administrator db2s and database managers resumes, we found that both roles require similar skills in their day-to-day duties, such as "database design," "linux," and "windows." But beyond that, the careers look very different.

Some important key differences between the two careers include a few of the skills necessary to fulfill the responsibilities of each. Some examples from database administrator db2 resumes include skills like "z os," "db2 dba," "db2 database," and "mainframe," whereas a database manager is more likely to list skills in "data management," "data entry," "project management," and "data integrity. "

Database managers earn the best pay in the professional industry, where they command an average salary of $104,998. Database administrator db2s earn the highest pay from the manufacturing industry, with an average salary of $107,009.When it comes to education, database managers tend to earn lower degree levels compared to database administrator db2s. In fact, they're 6.9% less likely to earn a Master's Degree, and 1.5% less likely to graduate with a Doctoral Degree.

Database administrator db2 vs. Database engineer

Database engineers tend to earn a higher pay than database administrator db2s by an average of $16,600 per year.While both database administrator db2s and database engineers complete day-to-day tasks using similar skills like z os, database design, and linux, the two careers vary in some skills.

Even though a few skill sets overlap between database administrator db2s and database engineers, there are some differences that are important to note. For one, a database administrator db2 might have more use for skills like "db2 dba," "db2 database," "mainframe," and "windows." Meanwhile, some responsibilities of database engineers require skills like "python," "troubleshoot," "aws," and "database administration. "

Database engineers enjoy the best pay in the technology industry, with an average salary of $117,631. For comparison, database administrator db2s earn the highest salary in the manufacturing industry.In general, database engineers hold similar degree levels compared to database administrator db2s. Database engineers are 0.5% less likely to earn their Master's Degree and 1.1% more likely to graduate with a Doctoral Degree.

Types of database administrator db2

Updated January 8, 2025

Zippia Research Team
Zippia Team

Editorial Staff

The Zippia Research Team has spent countless hours reviewing resumes, job postings, and government data to determine what goes into getting a job in each phase of life. Professional writers and data scientists comprise the Zippia Research Team.

Browse computer and mathematical jobs