IBM DB2 LUW Database Systems Administrator
IBM DB2 LUW Database Systems Administrator
Posted on :
05-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Skills:
- Ability to administer IBM DB2 LUW database systems; skilled to perform IBM DB2 LUW tuning including SQL tuning; ability to perform IBM DB2 database backup restore and disaster recovery design and deployments; able to automate routine daily IBM DB2 database system management tasks such as database deployments and refreshes.
- Possess excellent communication skills to effectively interact with internal and external management teams developers network and infrastructure teams.
- Possess skills to install/upgrade IBM DB2 LUW databases from lower version to latest supported version such as 11.1.x and above.
- Possess skills to install maintain support IBM DB2 LUW server software and related features including HADR with auto failover.
- Possess skills to install maintain and support IBM DB2 LUW Client on Linux and Windows platforms.
- Possess skills to install maintain support IBM DB2 LUW monitoring software such as IBM DB2 Data Management Console and recommend improvements for operational efficiency following best practices. Ability to create project plans for major tasks assigned.
- Ability to provide technical support and maintenance of the IBM DB2 LUW database systems to ensure their integrity availability and performance.
- Ability to document and refine database upgrade procedures following best practices and store on the sections MS SharePoint site.
- Possess skills to collaborate effectively with customer application groups and technical support groups to resolve performance and/or technical issues.
- Possess skills to perform capacity planning space management and data maintenance tasks for IBM DB2 LUW database systems including management of data and log files.
- Possess skills to perform database backup/recovery of IBM DB2 LUW databases utilizing enterprise class backup software such as CommVault.
- Possess skills to prepare change management documents using an enterprise class change management tool such as Cherwell.
- Possess skills to manage and maintain security to IBM DB2 LUW systems via authentication and authorization of access users following best practices.
- Possess skills to support ADABAS/Natural database systems following the sections established processes and procedures.
- Possess skills to provide 24x7x365 database systems support of IBM DB2 LUW and ADABAS/Natural database systems for troubleshooting and problem resolution including afterhours and weekends as needed to maintain maximum system uptime and minimize service disruptions. Jenkins Ansible MS PowerShell for workflow automation; MS Azure SQL and related Azure technologies; MS SQL Server Always on clustering services on SQL Server 2016 and above.
Experience Required:
- Minimum of eight (8) years of experience in systems development analysis programming or testing.
- 10 years experience in IBM DB2 LUW database systems administration including installing and upgrading to new versions and applying maintenance processes; install configure maintain troubleshoot HADR auto failover.
- 10 years experience in developing automation scripts using WMI PowerShell Perl Python Jenkins Ansible or Unix/Linux shell scripts etc.
- 10 years experience in using a DevOps GIT source code management tool.
- 5 years experience of working with IBM DB2 LUW database systems in a RedHat Linux platform environment installing new software releases applying maintenance patches and fixes and performing regular database administration support services including monitoring and troubleshooting.
- 5 years experience working with IBM Data Management Console installing and configuring new releases and setting up monitoring profiles.
- 5 years experience in supporting monitoring and troubleshooting ADABAS/Natural database systems.
- 5 years experience in utilizing DBeaver to monitor DB2 resources and usage. Supporting Linux RedHat database systems running in a VMware virtualized platform.
- 5 years experience in managing systems in any Cloud platform such as Amazon Web Services Microsoft Azure Google Cloud Platform or Oracle Cloud Infrastructure.
- 5 years experience in SQL Server installations configurations management and monitoring and system administration tasks at the level of a SQL Server Database System Administrator.
- 5 years experience in managing large MS SQL Server farms (300 servers).
- 5 years experience in developing scripts to automate routine manual database server functions using tools such as Jenkins Ansible or similar tools.
- 5 years experience in migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure.
- 5 years experience in building and managing Azure SQL Managed Instance services. Building configuring and managing MS SQL Server Always On cluster services.
- 5 years experience working with Commvault Backup client as a tool to perform SQL Server database Backup and Restore including the experience managing SQL Server backup and restore in native SQL Server Management Studio. Microsoft SQL Server experience on SQL Server 2016 and above.
Education Required:
Possession of a bachelors degree in an ITrelated or Engineering field. Additional qualifying experience may be substituted for the required education on a yearforyear basis.
Certification Preferred:
IBM DB2 Database Administrator Certification
Additional Information:
Local to Southern California. A hybrid work schedule (onsite plus remote) will be discussed in the interview.
Trinus Corporation a leading provider of technology solutions and services with over 25 years of experience is a certified WBE/MBE/SBE/SDB firm accredited by WBENC NMSDC and SBA. Our mission is to shape the future of work by aligning the right mix of people process technology and innovation to efficiently meet our clients business objectives. At Trinus we understand that finding the right opportunity is pivotal in your career journey. Our staffing services go beyond mere placements; they are about matching your skills and aspirations with the perfect fit. To learn more about us please visit our website
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
