5 Database Administrators jobs in Australia
Senior SQL Database Administrator
Scoresby, Victoria
Leidos
Posted 9 days ago
Job Viewed
Job Description
**Description**
+ **Life Days** are the Leidos way of recognising that we all need extra time to take care of life. By working slightly more than the minimum weekly hours (2 hours per week for full-timers), you can accrue up to **12 days of leave** per year.
+ **Leidos Life Hub** provides access to discount offers or cashback rewards with over 400 Australian and International retailers.
+ This team operates from Melbourne and Canberra - 100% on-site.
+ Our Team supports a range of Defence modernisation programs - Candidates must be Australian Citizens and hold an active NV-1 Security Clearance with the ability to obtain a NV-2.
Our team feel Leidos is a great place to work. Learn more about our culture and benefits by visiting us here Work That Matters**
Leidos Australia delivers IT and airborne solutions that protect and advance the Australian way of life. Our 2000 local experts, backed by our global experience and network of partners, are working to solve the world's toughest challenges in government, intelligence, defence, aviation, border protection and health markets.
The team consists of highly skilled Database Administrators who support and maintain a large enterprise environment spanning multiple locations within Australia and overseas.
**Your New Role and Responsibilities**
Reporting to the IT Capability Manager, our team enhances the design, implementation, testing, and maintenanceof Microsoft SQL Server instances and associated infrastructure.
A snapshot of responsibilities includes:
+ **Support:** Manage large enterprise high-availability Microsoft SQL implementations.
+ **Database Design and Implementation:** Installing, creating, configuring, upgrading, and monitoring databases to ensure optimum performance.
+ **Performance Monitoring and Optimisation:** Regularly monitor database performance and optimise queries to ensure efficient query processes.
+ **Database Security:** Implementing and managing security measures to protect sensitive data and ensuring compliance with Australian standards.
+ **Support for Application Teams:** Support application teams for database-related incidents and requests.
+ **ITIL Framework:** Working within an ITIL framework for all work-related activities, including change, incident, and problem management.
+ **Continual Improvement:** Champion change on behalf of the team through proactive identification of improvement opportunities.
+ **Technical escalation:** Act as an escalation point for complex issues on behalf of the team.
**What You'll Bring to Make An Impact**
+ A high level of proficiency as a DBA managing Enterprise Microsoft SQL Server is essential.
+ An in-depth knowledge of the SQL Server Database engine.
+ Platform experience covering virtualisation, Windows clustering and associated technologies.
+ Experience in High Availability and Disaster Recovery scenarios (Always On Availability Groups, Clustering, Mirroring, Log shipping).
+ Experience undertaking backup and data recovery processes.
+ Experience with scripting via PowerShell to automate everyday tasks like SQL Server installations, Patching installations and health checks.
Don't worry if you don't tick all the boxes - if you meet most of them, we encourage you to submit your application. We're most interested in your strengths, what you want to learn and how far you want to go.
_Due to the nature of the role, you must be an Australian Citizen and hold an active NV-1 AGSVA security clearance._
**Diverse Team Members, Shared Values and a Common Purpose**
_Providing our customers with smarter solutions takes an incredible team with diversity of thought, experience and perspectives driving innovation. Inclusion is at the heart of our culture and is one of our core values. It's about creating a workplace where everyone can do important work, feels welcome, valued, and respected, and has equal access to opportunities to thrive. Paul Chase - Chief Executive, Leidos Australia._
Leidos Australia is an equal opportunities organisation and is committed to creating a truly inclusive workplace. We welcome and encourage applications from Aboriginal and Torres Strait Islanders, culturally and linguistically diverse people, people with disabilities, veterans, neurodiverse people, and people of all genders, sexualities, and age groups.
Our five Advocacy Groups (Women and Allies Network,Young Professionals, Defence & Emergency Services, Action for Accessibility and Abilities and Pride+) provide an opportunity for team members to connect and collaborate on shared interests, and work to support and celebrate our diverse community.
**Next Steps**
+ To apply for this role, follow the links or apply via our Careers page.
+ Recruitment process - 1 virtual interview and/or 1 face-to-face & background checks.
+ Applicants may also need to meet International Traffic in Arms Regulations (ITAR) requirements. In certain circumstances this can place limitations on persons who hold dual nationality, permanent residency or are former nationals of certain countries as per ITAR 126.1.
+ We are committed to making our recruitment process accessible to all candidates. Please contact our Careers team if you'd like to discuss any additional support during your application or throughout the recruitment process.
**Original Posting:**
For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
**Pay Range:**
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00154654-OTHLOC-PL-2D2460
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
+ **Life Days** are the Leidos way of recognising that we all need extra time to take care of life. By working slightly more than the minimum weekly hours (2 hours per week for full-timers), you can accrue up to **12 days of leave** per year.
+ **Leidos Life Hub** provides access to discount offers or cashback rewards with over 400 Australian and International retailers.
+ This team operates from Melbourne and Canberra - 100% on-site.
+ Our Team supports a range of Defence modernisation programs - Candidates must be Australian Citizens and hold an active NV-1 Security Clearance with the ability to obtain a NV-2.
Our team feel Leidos is a great place to work. Learn more about our culture and benefits by visiting us here Work That Matters**
Leidos Australia delivers IT and airborne solutions that protect and advance the Australian way of life. Our 2000 local experts, backed by our global experience and network of partners, are working to solve the world's toughest challenges in government, intelligence, defence, aviation, border protection and health markets.
The team consists of highly skilled Database Administrators who support and maintain a large enterprise environment spanning multiple locations within Australia and overseas.
**Your New Role and Responsibilities**
Reporting to the IT Capability Manager, our team enhances the design, implementation, testing, and maintenanceof Microsoft SQL Server instances and associated infrastructure.
A snapshot of responsibilities includes:
+ **Support:** Manage large enterprise high-availability Microsoft SQL implementations.
+ **Database Design and Implementation:** Installing, creating, configuring, upgrading, and monitoring databases to ensure optimum performance.
+ **Performance Monitoring and Optimisation:** Regularly monitor database performance and optimise queries to ensure efficient query processes.
+ **Database Security:** Implementing and managing security measures to protect sensitive data and ensuring compliance with Australian standards.
+ **Support for Application Teams:** Support application teams for database-related incidents and requests.
+ **ITIL Framework:** Working within an ITIL framework for all work-related activities, including change, incident, and problem management.
+ **Continual Improvement:** Champion change on behalf of the team through proactive identification of improvement opportunities.
+ **Technical escalation:** Act as an escalation point for complex issues on behalf of the team.
**What You'll Bring to Make An Impact**
+ A high level of proficiency as a DBA managing Enterprise Microsoft SQL Server is essential.
+ An in-depth knowledge of the SQL Server Database engine.
+ Platform experience covering virtualisation, Windows clustering and associated technologies.
+ Experience in High Availability and Disaster Recovery scenarios (Always On Availability Groups, Clustering, Mirroring, Log shipping).
+ Experience undertaking backup and data recovery processes.
+ Experience with scripting via PowerShell to automate everyday tasks like SQL Server installations, Patching installations and health checks.
Don't worry if you don't tick all the boxes - if you meet most of them, we encourage you to submit your application. We're most interested in your strengths, what you want to learn and how far you want to go.
_Due to the nature of the role, you must be an Australian Citizen and hold an active NV-1 AGSVA security clearance._
**Diverse Team Members, Shared Values and a Common Purpose**
_Providing our customers with smarter solutions takes an incredible team with diversity of thought, experience and perspectives driving innovation. Inclusion is at the heart of our culture and is one of our core values. It's about creating a workplace where everyone can do important work, feels welcome, valued, and respected, and has equal access to opportunities to thrive. Paul Chase - Chief Executive, Leidos Australia._
Leidos Australia is an equal opportunities organisation and is committed to creating a truly inclusive workplace. We welcome and encourage applications from Aboriginal and Torres Strait Islanders, culturally and linguistically diverse people, people with disabilities, veterans, neurodiverse people, and people of all genders, sexualities, and age groups.
Our five Advocacy Groups (Women and Allies Network,Young Professionals, Defence & Emergency Services, Action for Accessibility and Abilities and Pride+) provide an opportunity for team members to connect and collaborate on shared interests, and work to support and celebrate our diverse community.
**Next Steps**
+ To apply for this role, follow the links or apply via our Careers page.
+ Recruitment process - 1 virtual interview and/or 1 face-to-face & background checks.
+ Applicants may also need to meet International Traffic in Arms Regulations (ITAR) requirements. In certain circumstances this can place limitations on persons who hold dual nationality, permanent residency or are former nationals of certain countries as per ITAR 126.1.
+ We are committed to making our recruitment process accessible to all candidates. Please contact our Careers team if you'd like to discuss any additional support during your application or throughout the recruitment process.
**Original Posting:**
For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
**Pay Range:**
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00154654-OTHLOC-PL-2D2460
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
This advertiser has chosen not to accept applicants from your region.
0
Senior SQL Database Administrator
Canberra, Australian Capital Territory
Leidos
Posted 9 days ago
Job Viewed
Job Description
**Description**
+ **Life Days** are the Leidos way of recognising that we all need extra time to take care of life. By working slightly more than the minimum weekly hours (2 hours per week for full-timers), you can accrue up to **12 days of leave** per year.
+ **Leidos Life Hub** provides access to discount offers or cashback rewards with over 400 Australian and International retailers.
+ This team operates from Melbourne and Canberra - 100% on-site.
+ Our Team supports a range of Defence modernisation programs - Candidates must be Australian Citizens and hold an active NV-1 Security Clearance with the ability to obtain a NV-2.
Our team feel Leidos is a great place to work. Learn more about our culture and benefits by visiting us here Work That Matters**
Leidos Australia delivers IT and airborne solutions that protect and advance the Australian way of life. Our 2000 local experts, backed by our global experience and network of partners, are working to solve the world's toughest challenges in government, intelligence, defence, aviation, border protection and health markets.
The team consists of highly skilled Database Administrators who support and maintain a large enterprise environment spanning multiple locations within Australia and overseas.
**Your New Role and Responsibilities**
Reporting to the IT Capability Manager, our team enhances the design, implementation, testing, and maintenanceof Microsoft SQL Server instances and associated infrastructure.
A snapshot of responsibilities includes:
+ **Support:** Manage large enterprise high-availability Microsoft SQL implementations.
+ **Database Design and Implementation:** Installing, creating, configuring, upgrading, and monitoring databases to ensure optimum performance.
+ **Performance Monitoring and Optimisation:** Regularly monitor database performance and optimise queries to ensure efficient query processes.
+ **Database Security:** Implementing and managing security measures to protect sensitive data and ensuring compliance with Australian standards.
+ **Support for Application Teams:** Support application teams for database-related incidents and requests.
+ **ITIL Framework:** Working within an ITIL framework for all work-related activities, including change, incident, and problem management.
+ **Continual Improvement:** Champion change on behalf of the team through proactive identification of improvement opportunities.
+ **Technical escalation:** Act as an escalation point for complex issues on behalf of the team.
**What You'll Bring to Make An Impact**
+ A high level of proficiency as a DBA managing Enterprise Microsoft SQL Server is essential.
+ An in-depth knowledge of the SQL Server Database engine.
+ Platform experience covering virtualisation, Windows clustering and associated technologies.
+ Experience in High Availability and Disaster Recovery scenarios (Always On Availability Groups, Clustering, Mirroring, Log shipping).
+ Experience undertaking backup and data recovery processes.
+ Experience with scripting via PowerShell to automate everyday tasks like SQL Server installations, Patching installations and health checks.
Don't worry if you don't tick all the boxes - if you meet most of them, we encourage you to submit your application. We're most interested in your strengths, what you want to learn and how far you want to go.
_Due to the nature of the role, you must be an Australian Citizen and hold an active NV-1 AGSVA security clearance._
**Diverse Team Members, Shared Values and a Common Purpose**
_Providing our customers with smarter solutions takes an incredible team with diversity of thought, experience and perspectives driving innovation. Inclusion is at the heart of our culture and is one of our core values. It's about creating a workplace where everyone can do important work, feels welcome, valued, and respected, and has equal access to opportunities to thrive. Paul Chase - Chief Executive, Leidos Australia._
Leidos Australia is an equal opportunities organisation and is committed to creating a truly inclusive workplace. We welcome and encourage applications from Aboriginal and Torres Strait Islanders, culturally and linguistically diverse people, people with disabilities, veterans, neurodiverse people, and people of all genders, sexualities, and age groups.
Our five Advocacy Groups (Women and Allies Network,Young Professionals, Defence & Emergency Services, Action for Accessibility and Abilities and Pride+) provide an opportunity for team members to connect and collaborate on shared interests, and work to support and celebrate our diverse community.
**Next Steps**
+ To apply for this role, follow the links or apply via our Careers page.
+ Recruitment process - 1 virtual interview and/or 1 face-to-face & background checks.
+ Applicants may also need to meet International Traffic in Arms Regulations (ITAR) requirements. In certain circumstances this can place limitations on persons who hold dual nationality, permanent residency or are former nationals of certain countries as per ITAR 126.1.
+ We are committed to making our recruitment process accessible to all candidates. Please contact our Careers team if you'd like to discuss any additional support during your application or throughout the recruitment process.
**Original Posting:**
For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
**Pay Range:**
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00154654
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
+ **Life Days** are the Leidos way of recognising that we all need extra time to take care of life. By working slightly more than the minimum weekly hours (2 hours per week for full-timers), you can accrue up to **12 days of leave** per year.
+ **Leidos Life Hub** provides access to discount offers or cashback rewards with over 400 Australian and International retailers.
+ This team operates from Melbourne and Canberra - 100% on-site.
+ Our Team supports a range of Defence modernisation programs - Candidates must be Australian Citizens and hold an active NV-1 Security Clearance with the ability to obtain a NV-2.
Our team feel Leidos is a great place to work. Learn more about our culture and benefits by visiting us here Work That Matters**
Leidos Australia delivers IT and airborne solutions that protect and advance the Australian way of life. Our 2000 local experts, backed by our global experience and network of partners, are working to solve the world's toughest challenges in government, intelligence, defence, aviation, border protection and health markets.
The team consists of highly skilled Database Administrators who support and maintain a large enterprise environment spanning multiple locations within Australia and overseas.
**Your New Role and Responsibilities**
Reporting to the IT Capability Manager, our team enhances the design, implementation, testing, and maintenanceof Microsoft SQL Server instances and associated infrastructure.
A snapshot of responsibilities includes:
+ **Support:** Manage large enterprise high-availability Microsoft SQL implementations.
+ **Database Design and Implementation:** Installing, creating, configuring, upgrading, and monitoring databases to ensure optimum performance.
+ **Performance Monitoring and Optimisation:** Regularly monitor database performance and optimise queries to ensure efficient query processes.
+ **Database Security:** Implementing and managing security measures to protect sensitive data and ensuring compliance with Australian standards.
+ **Support for Application Teams:** Support application teams for database-related incidents and requests.
+ **ITIL Framework:** Working within an ITIL framework for all work-related activities, including change, incident, and problem management.
+ **Continual Improvement:** Champion change on behalf of the team through proactive identification of improvement opportunities.
+ **Technical escalation:** Act as an escalation point for complex issues on behalf of the team.
**What You'll Bring to Make An Impact**
+ A high level of proficiency as a DBA managing Enterprise Microsoft SQL Server is essential.
+ An in-depth knowledge of the SQL Server Database engine.
+ Platform experience covering virtualisation, Windows clustering and associated technologies.
+ Experience in High Availability and Disaster Recovery scenarios (Always On Availability Groups, Clustering, Mirroring, Log shipping).
+ Experience undertaking backup and data recovery processes.
+ Experience with scripting via PowerShell to automate everyday tasks like SQL Server installations, Patching installations and health checks.
Don't worry if you don't tick all the boxes - if you meet most of them, we encourage you to submit your application. We're most interested in your strengths, what you want to learn and how far you want to go.
_Due to the nature of the role, you must be an Australian Citizen and hold an active NV-1 AGSVA security clearance._
**Diverse Team Members, Shared Values and a Common Purpose**
_Providing our customers with smarter solutions takes an incredible team with diversity of thought, experience and perspectives driving innovation. Inclusion is at the heart of our culture and is one of our core values. It's about creating a workplace where everyone can do important work, feels welcome, valued, and respected, and has equal access to opportunities to thrive. Paul Chase - Chief Executive, Leidos Australia._
Leidos Australia is an equal opportunities organisation and is committed to creating a truly inclusive workplace. We welcome and encourage applications from Aboriginal and Torres Strait Islanders, culturally and linguistically diverse people, people with disabilities, veterans, neurodiverse people, and people of all genders, sexualities, and age groups.
Our five Advocacy Groups (Women and Allies Network,Young Professionals, Defence & Emergency Services, Action for Accessibility and Abilities and Pride+) provide an opportunity for team members to connect and collaborate on shared interests, and work to support and celebrate our diverse community.
**Next Steps**
+ To apply for this role, follow the links or apply via our Careers page.
+ Recruitment process - 1 virtual interview and/or 1 face-to-face & background checks.
+ Applicants may also need to meet International Traffic in Arms Regulations (ITAR) requirements. In certain circumstances this can place limitations on persons who hold dual nationality, permanent residency or are former nationals of certain countries as per ITAR 126.1.
+ We are committed to making our recruitment process accessible to all candidates. Please contact our Careers team if you'd like to discuss any additional support during your application or throughout the recruitment process.
**Original Posting:**
For U.S. Positions: While subject to change based on business needs, Leidos reasonably anticipates that this job requisition will remain open for at least 3 days with an anticipated close date of no earlier than 3 days after the original posting date as listed above.
**Pay Range:**
The Leidos pay range for this job level is a general guideline onlyand not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.
REQNUMBER: R-00154654
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an equal opportunity employer/disability/vet.
This advertiser has chosen not to accept applicants from your region.
1
Senior Oracle Database Administrator (DBA)
2601 Acton, Australian Capital Territory
PowerData Group Consulting
Posted 521 days ago
Job Viewed
Job Description
We are seeking a Senior Oracle Database Administrator (DBA) Open to : Must have Baseline Location : ACTOn-site at Canberra Offices (Majura Park) minimum 3 days per week The Role :We are looking for an experienced Senior Oracle Database Administrator (DBA), who can demonstrate experience with a broad range of tools and technologies.Requirements Essential criteria Background as a senior Oracle Data Base Administrator Proven experience as an Oracle DBA, with extensive knowledge of Oracle database administration, version 12c and 19c. Applicants must possess a minimum of 10 years of experience as an Oracle DBA, with at least 2 years focused on database migrations and cloud technologies. Oracle DBA Certification and OCI Architect Certification are highly desirable. Oracle Database and Cloud Infrastructure Migration Experience Demonstrated experience in migrating Oracle databases to newer versions and to cloud environments, preferably OCI.Cloud Proficiency Hands-on experience with Oracle Cloud Infrastructure (OCI) and familiarity with cloud services, tools, and best practices.Technical Skills Strong understanding of database architecture, SQL, PL/SQL, and Oracle RAC. Experience with Oracle Data Guard, Oracle GoldenGate, and backup/recovery techniques.Problem-Solving Excellent problem-solving and analytical skills, with the ability to troubleshoot complex migration issues and optimize database performance.Communication and Collaboration Skills Strong communication and collaboration skills, with the ability to work effectively in a team and communicate technical concepts to non-technical stakeholders.Desirable criteriaFamiliarity with Federal Government ICTOracle Database and Tools Experience • Minimum of 10 years of experience as an Oracle DBA, with at least 2 years focused on database migrations and cloud technologies. • Oracle certifications and training in Oracle technologies, cloud platforms, and data base administration are highly desirable.SAFe and/or Agile Experience/Exposure Familiarity with SAFe (Scaled Agile Framework) or other agile methodologies is a plus. Experience or exposure to agile practices will help streamline program deliverySecurity Clearance (NV1 or Baseline) Possession of an NV1 security clearance is preferable, with a baseline security clearance as a bare minimumSecurity Clearance (NV1 or Baseline) Possession of an NV1 security clearance is preferable, with a baseline security clearance as a bare minimum
This advertiser has chosen not to accept applicants from your region.
2
Z/OS Mainframe IMS DB2 Database Administrator
Sydney, New South Wales
Kyndryl
Posted 9 days ago
Job Viewed
Job Description
**Who We Are**
At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.
**The Role**
Within our Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations.
Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.
**Position Summary:**
The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects. Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.
+ To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
+ To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.
+ To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions.
**Key Areas:**
+ The successful candidate will perform IMS database and DB2 object changes coupled with administration and tuning to support our customers' IMS and DB2 environments.
+ The individual will need to work with vendor personnel to achieve timely solutions of database problems.
+ The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
+ The successful candidate will be called upon to perform a variety of IMS and DB2 database optimizations that will include general reporting and analysis of the efficiency of the IMS database and DB2 objects configuration and periodic review of IMS database and DB2 objects performance.
+ Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
+ To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
+ System programming knowledge of multiple DBMS's is a bonus.
+ The individual will need to participate in on-call responsibilities.
**Who You Are**
**Required Qualifications**
+ Bachelor's degree required and/or equivalent work experience.
+ 10+ years of professional experience in IMS and DB2 database administration.
+ BMC COPE and IBM tools for IMS and DB2.
+ IMS and DB2 systems programming support is a plus
+ Extensive experience with the following:
+ Knowledge of the best practices of software management, maintenance and documentation
+ Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
+ Evaluating change requests and determine impact to assigned clients
+ Vendor consultations for problems and questions
+ DR recovery of application objects
+ Troubleshooting and solving production database issues
+ Demonstrated ability to respond quickly and effectively to support requests from client
+ Supporting customer for after hours on-call
**Database Administration**
+ Deep knowledge of IMS database organization using access methods of VSAM and OSAM
+ Full function database organization types
+ HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
+ Definition and use of LOGICAL databases
+ HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
+ Fast Path databases (DEDBs)
+ Broad knowledge of DB2 for Z/OS database components and concepts
+ DB2 Program Preparation, Bind and Locking
+ DB2 Storage Concepts
**Database Design and related utilities**
+ DBD source coding and DBDGEN
+ PSBGEN source coding and PSBGEN
+ How databases are processed using secondary indexes (PROCSEQ=)
+ Correct usage of PROCOPT= to minimize database locking
+ ACBGEN
+ Online Change
+ IMS commands related to ACB and FORMAT changes
+ DB2 Entity Relationship Modeling and Normalization
+ DB2 Referential Integrity
+ DB2 and IMS Omegamon monitor
**Coding and usage of IMS and DB2 DBA utilities (including IBM, BMC, CA)**
+ Unload
+ IMS DB Prefix resolution
+ Reload
+ IMS DB Prefix update
+ Secondary index build
+ Image copy
+ IMS DB Pointer checker
+ IMS Performance Analyzer
+ Online and batch reorganization
+ DB2 RUNSTATS
+ DB2 SQL Performance optimization
+ Proficient in DB2 for z/OS DDL, DML, DCL
+ Experience with IBM DB2 V12+ and IMS V15
+ Experience with IBM DB2 Administration Tool.
+ Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation
+ REXX, ISPF, CLIST, or other database automation development skills/experience.
+ Experience with DB2 triggers
+ Experience with IBM Infosphere Data Replication (CDC) for IMS
+ Experience with IBM DB2 performance management and tuning;
**Support planned (disaster recovery) and unplanned (emergency) database recovery activities**
+ Knowledge of log archive and change accumulation utilities
+ How to perform a log archive on demand
+ Knowledge of IMS and DB2 DB recovery utilities
+ How to use DBRC to generate JCL for forward recovery and point-in-time database recovery
**Database monitoring**
+ Space management
+ Database dataset space reporting for proactive outage avoidance.
+ How to immediately fix an out of space condition for a VSAM database dataset
+ Experience with Omegamon for IMS and DB2
**Identification and resolution of performance issues**
+ Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
+ Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
+ Use of DFSDDLT0 utility to access data
+ Program/transaction monitoring - Familiarity with usage of IBM's IMS performance Analyzer product is a plus
+ Using DBRC to monitor database activity
**Being You**
Diversity is a whole lot more than what we look like or where we come from, it's how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we're not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you - and everyone next to you - the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That's the Kyndryl Way.
**What You Can Expect**
With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter - wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations. At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.
**Get Referred!**
If you know someone that works at Kyndryl, when asked 'How Did You Hear About Us' during the application process, select 'Employee Referral' and enter your contact's Kyndryl email address.
Kyndryl is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. Kyndryl is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.
**The Role**
Within our Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations.
Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.
**Position Summary:**
The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects. Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.
+ To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
+ To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.
+ To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions.
**Key Areas:**
+ The successful candidate will perform IMS database and DB2 object changes coupled with administration and tuning to support our customers' IMS and DB2 environments.
+ The individual will need to work with vendor personnel to achieve timely solutions of database problems.
+ The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
+ The successful candidate will be called upon to perform a variety of IMS and DB2 database optimizations that will include general reporting and analysis of the efficiency of the IMS database and DB2 objects configuration and periodic review of IMS database and DB2 objects performance.
+ Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
+ To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
+ System programming knowledge of multiple DBMS's is a bonus.
+ The individual will need to participate in on-call responsibilities.
**Who You Are**
**Required Qualifications**
+ Bachelor's degree required and/or equivalent work experience.
+ 10+ years of professional experience in IMS and DB2 database administration.
+ BMC COPE and IBM tools for IMS and DB2.
+ IMS and DB2 systems programming support is a plus
+ Extensive experience with the following:
+ Knowledge of the best practices of software management, maintenance and documentation
+ Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
+ Evaluating change requests and determine impact to assigned clients
+ Vendor consultations for problems and questions
+ DR recovery of application objects
+ Troubleshooting and solving production database issues
+ Demonstrated ability to respond quickly and effectively to support requests from client
+ Supporting customer for after hours on-call
**Database Administration**
+ Deep knowledge of IMS database organization using access methods of VSAM and OSAM
+ Full function database organization types
+ HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
+ Definition and use of LOGICAL databases
+ HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
+ Fast Path databases (DEDBs)
+ Broad knowledge of DB2 for Z/OS database components and concepts
+ DB2 Program Preparation, Bind and Locking
+ DB2 Storage Concepts
**Database Design and related utilities**
+ DBD source coding and DBDGEN
+ PSBGEN source coding and PSBGEN
+ How databases are processed using secondary indexes (PROCSEQ=)
+ Correct usage of PROCOPT= to minimize database locking
+ ACBGEN
+ Online Change
+ IMS commands related to ACB and FORMAT changes
+ DB2 Entity Relationship Modeling and Normalization
+ DB2 Referential Integrity
+ DB2 and IMS Omegamon monitor
**Coding and usage of IMS and DB2 DBA utilities (including IBM, BMC, CA)**
+ Unload
+ IMS DB Prefix resolution
+ Reload
+ IMS DB Prefix update
+ Secondary index build
+ Image copy
+ IMS DB Pointer checker
+ IMS Performance Analyzer
+ Online and batch reorganization
+ DB2 RUNSTATS
+ DB2 SQL Performance optimization
+ Proficient in DB2 for z/OS DDL, DML, DCL
+ Experience with IBM DB2 V12+ and IMS V15
+ Experience with IBM DB2 Administration Tool.
+ Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation
+ REXX, ISPF, CLIST, or other database automation development skills/experience.
+ Experience with DB2 triggers
+ Experience with IBM Infosphere Data Replication (CDC) for IMS
+ Experience with IBM DB2 performance management and tuning;
**Support planned (disaster recovery) and unplanned (emergency) database recovery activities**
+ Knowledge of log archive and change accumulation utilities
+ How to perform a log archive on demand
+ Knowledge of IMS and DB2 DB recovery utilities
+ How to use DBRC to generate JCL for forward recovery and point-in-time database recovery
**Database monitoring**
+ Space management
+ Database dataset space reporting for proactive outage avoidance.
+ How to immediately fix an out of space condition for a VSAM database dataset
+ Experience with Omegamon for IMS and DB2
**Identification and resolution of performance issues**
+ Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
+ Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
+ Use of DFSDDLT0 utility to access data
+ Program/transaction monitoring - Familiarity with usage of IBM's IMS performance Analyzer product is a plus
+ Using DBRC to monitor database activity
**Being You**
Diversity is a whole lot more than what we look like or where we come from, it's how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we're not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you - and everyone next to you - the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That's the Kyndryl Way.
**What You Can Expect**
With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter - wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations. At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.
**Get Referred!**
If you know someone that works at Kyndryl, when asked 'How Did You Hear About Us' during the application process, select 'Employee Referral' and enter your contact's Kyndryl email address.
Kyndryl is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. Kyndryl is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
This advertiser has chosen not to accept applicants from your region.
3
Z/OS Mainframe IMS DB2 Database Administrator
Melbourne, Victoria
Kyndryl
Posted 9 days ago
Job Viewed
Job Description
**Who We Are**
At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.
**The Role**
Within our Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations.
Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.
**Position Summary:**
The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects. Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.
+ To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
+ To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.
+ To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions.
**Key Areas:**
+ The successful candidate will perform IMS database and DB2 object changes coupled with administration and tuning to support our customers' IMS and DB2 environments.
+ The individual will need to work with vendor personnel to achieve timely solutions of database problems.
+ The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
+ The successful candidate will be called upon to perform a variety of IMS and DB2 database optimizations that will include general reporting and analysis of the efficiency of the IMS database and DB2 objects configuration and periodic review of IMS database and DB2 objects performance.
+ Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
+ To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
+ System programming knowledge of multiple DBMS's is a bonus.
+ The individual will need to participate in on-call responsibilities.
**Who You Are**
**Required Qualifications**
+ Bachelor's degree required and/or equivalent work experience.
+ 10+ years of professional experience in IMS and DB2 database administration.
+ BMC COPE and IBM tools for IMS and DB2.
+ IMS and DB2 systems programming support is a plus
+ Extensive experience with the following:
+ Knowledge of the best practices of software management, maintenance and documentation
+ Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
+ Evaluating change requests and determine impact to assigned clients
+ Vendor consultations for problems and questions
+ DR recovery of application objects
+ Troubleshooting and solving production database issues
+ Demonstrated ability to respond quickly and effectively to support requests from client
+ Supporting customer for after hours on-call
**Database Administration**
+ Deep knowledge of IMS database organization using access methods of VSAM and OSAM
+ Full function database organization types
+ HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
+ Definition and use of LOGICAL databases
+ HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
+ Fast Path databases (DEDBs)
+ Broad knowledge of DB2 for Z/OS database components and concepts
+ DB2 Program Preparation, Bind and Locking
+ DB2 Storage Concepts
**Database Design and related utilities**
+ DBD source coding and DBDGEN
+ PSBGEN source coding and PSBGEN
+ How databases are processed using secondary indexes (PROCSEQ=)
+ Correct usage of PROCOPT= to minimize database locking
+ ACBGEN
+ Online Change
+ IMS commands related to ACB and FORMAT changes
+ DB2 Entity Relationship Modeling and Normalization
+ DB2 Referential Integrity
+ DB2 and IMS Omegamon monitor
**Coding and usage of IMS and DB2 DBA utilities (including IBM, BMC, CA)**
+ Unload
+ IMS DB Prefix resolution
+ Reload
+ IMS DB Prefix update
+ Secondary index build
+ Image copy
+ IMS DB Pointer checker
+ IMS Performance Analyzer
+ Online and batch reorganization
+ DB2 RUNSTATS
+ DB2 SQL Performance optimization
+ Proficient in DB2 for z/OS DDL, DML, DCL
+ Experience with IBM DB2 V12+ and IMS V15
+ Experience with IBM DB2 Administration Tool.
+ Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation
+ REXX, ISPF, CLIST, or other database automation development skills/experience.
+ Experience with DB2 triggers
+ Experience with IBM Infosphere Data Replication (CDC) for IMS
+ Experience with IBM DB2 performance management and tuning;
**Support planned (disaster recovery) and unplanned (emergency) database recovery activities**
+ Knowledge of log archive and change accumulation utilities
+ How to perform a log archive on demand
+ Knowledge of IMS and DB2 DB recovery utilities
+ How to use DBRC to generate JCL for forward recovery and point-in-time database recovery
**Database monitoring**
+ Space management
+ Database dataset space reporting for proactive outage avoidance.
+ How to immediately fix an out of space condition for a VSAM database dataset
+ Experience with Omegamon for IMS and DB2
**Identification and resolution of performance issues**
+ Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
+ Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
+ Use of DFSDDLT0 utility to access data
+ Program/transaction monitoring - Familiarity with usage of IBM's IMS performance Analyzer product is a plus
+ Using DBRC to monitor database activity
**Being You**
Diversity is a whole lot more than what we look like or where we come from, it's how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we're not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you - and everyone next to you - the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That's the Kyndryl Way.
**What You Can Expect**
With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter - wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations. At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.
**Get Referred!**
If you know someone that works at Kyndryl, when asked 'How Did You Hear About Us' during the application process, select 'Employee Referral' and enter your contact's Kyndryl email address.
Kyndryl is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. Kyndryl is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.
**The Role**
Within our Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations.
Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won't find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.
**Position Summary:**
The Database Administrator creates, maintains, designs, monitors and troubleshoots client IMS databases and DB2 objects. Proficient with IBM IMS and DB2 database management utilities, develop and implement database recovery mechanisms and procedures for both IMS and DB2 components, and coordinate security measures to safeguard IMS and DB2 database integrity.
+ To lead DB2 z/OS projects and initiatives, working together with experienced DB2 z/OS and IMS DBAs.
+ To work closely with IMS and DB2 z/OS System Programmers on IMS and DB2 z/OS systems and tools upgrades.
+ To provide DBA support to a list of critical applications that use DB2 z/OS and IMS databases/transactions.
**Key Areas:**
+ The successful candidate will perform IMS database and DB2 object changes coupled with administration and tuning to support our customers' IMS and DB2 environments.
+ The individual will need to work with vendor personnel to achieve timely solutions of database problems.
+ The individual will be responsible for day-to-day database maintenance such as creating backups, performing restores, monitoring file extent growth, scheduling reorganizations, creating and maintaining DR procedures and overall support of customer needs and requests.
+ The successful candidate will be called upon to perform a variety of IMS and DB2 database optimizations that will include general reporting and analysis of the efficiency of the IMS database and DB2 objects configuration and periodic review of IMS database and DB2 objects performance.
+ Expertise and work efforts will focus on the development and support and/or the customization of new services and support efforts.
+ To ensure that all databases and environmental changes are appropriately tested and implemented in such a manner that there is no impact to the systems and clients.
+ System programming knowledge of multiple DBMS's is a bonus.
+ The individual will need to participate in on-call responsibilities.
**Who You Are**
**Required Qualifications**
+ Bachelor's degree required and/or equivalent work experience.
+ 10+ years of professional experience in IMS and DB2 database administration.
+ BMC COPE and IBM tools for IMS and DB2.
+ IMS and DB2 systems programming support is a plus
+ Extensive experience with the following:
+ Knowledge of the best practices of software management, maintenance and documentation
+ Establishing policies and procedures pertaining to database management, DR, maintenance and utilization
+ Evaluating change requests and determine impact to assigned clients
+ Vendor consultations for problems and questions
+ DR recovery of application objects
+ Troubleshooting and solving production database issues
+ Demonstrated ability to respond quickly and effectively to support requests from client
+ Supporting customer for after hours on-call
**Database Administration**
+ Deep knowledge of IMS database organization using access methods of VSAM and OSAM
+ Full function database organization types
+ HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
+ Definition and use of LOGICAL databases
+ HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
+ Fast Path databases (DEDBs)
+ Broad knowledge of DB2 for Z/OS database components and concepts
+ DB2 Program Preparation, Bind and Locking
+ DB2 Storage Concepts
**Database Design and related utilities**
+ DBD source coding and DBDGEN
+ PSBGEN source coding and PSBGEN
+ How databases are processed using secondary indexes (PROCSEQ=)
+ Correct usage of PROCOPT= to minimize database locking
+ ACBGEN
+ Online Change
+ IMS commands related to ACB and FORMAT changes
+ DB2 Entity Relationship Modeling and Normalization
+ DB2 Referential Integrity
+ DB2 and IMS Omegamon monitor
**Coding and usage of IMS and DB2 DBA utilities (including IBM, BMC, CA)**
+ Unload
+ IMS DB Prefix resolution
+ Reload
+ IMS DB Prefix update
+ Secondary index build
+ Image copy
+ IMS DB Pointer checker
+ IMS Performance Analyzer
+ Online and batch reorganization
+ DB2 RUNSTATS
+ DB2 SQL Performance optimization
+ Proficient in DB2 for z/OS DDL, DML, DCL
+ Experience with IBM DB2 V12+ and IMS V15
+ Experience with IBM DB2 Administration Tool.
+ Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation
+ REXX, ISPF, CLIST, or other database automation development skills/experience.
+ Experience with DB2 triggers
+ Experience with IBM Infosphere Data Replication (CDC) for IMS
+ Experience with IBM DB2 performance management and tuning;
**Support planned (disaster recovery) and unplanned (emergency) database recovery activities**
+ Knowledge of log archive and change accumulation utilities
+ How to perform a log archive on demand
+ Knowledge of IMS and DB2 DB recovery utilities
+ How to use DBRC to generate JCL for forward recovery and point-in-time database recovery
**Database monitoring**
+ Space management
+ Database dataset space reporting for proactive outage avoidance.
+ How to immediately fix an out of space condition for a VSAM database dataset
+ Experience with Omegamon for IMS and DB2
**Identification and resolution of performance issues**
+ Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
+ Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
+ Use of DFSDDLT0 utility to access data
+ Program/transaction monitoring - Familiarity with usage of IBM's IMS performance Analyzer product is a plus
+ Using DBRC to monitor database activity
**Being You**
Diversity is a whole lot more than what we look like or where we come from, it's how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we're not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you - and everyone next to you - the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That's the Kyndryl Way.
**What You Can Expect**
With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter - wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations. At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.
**Get Referred!**
If you know someone that works at Kyndryl, when asked 'How Did You Hear About Us' during the application process, select 'Employee Referral' and enter your contact's Kyndryl email address.
Kyndryl is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. Kyndryl is also committed to compliance with all fair employment practices regarding citizenship and immigration status.
This advertiser has chosen not to accept applicants from your region.
Be The First To Know
About the latest Database administrators Jobs in Australia !
4