What does a database administrator db2 do?
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. "
The three companies that hire the most database administrator db2s are:
- JPMorgan Chase & Co.2 database administrator db2s jobs
- Randstad North America, Inc.2 database administrator db2s jobs
- Lockheed Martin1 database administrator db2s jobs
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.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.
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.
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.
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
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











