Who ❤️ PJ →

Full Search

This job listing has expired and may no longer be relevant!
16 May 2023

Temporary IBM DB2 Purescale DBA

Hornet Staffing – Posted by Hornet Staffing Anywhere

Job Description

Job Type                 :         Contract

Contract length    :       06 Months

Pay Rate                 :         $ 54.10– 71.42 /Hr

 Remote Job Description:

  • Database Administrator should be very strong working knowledge of IBM DB2 Purescale cluster from Operational/Systems DBA to setup and support IBM DB2 LUW databases on AIX platform. Experience with Netezza, Sailfish appliances is a plus.
  • Bachelor’s degree in an IT related field or equivalent work experience.
  • Looking for a Purescale SME, with hands on working experience in setting up and managing Purescale clusters.
  • In depth knowledge of the DB2 LUW architecture of EE.
  • Experienced in installing, configuring and upgrading DB2 LUW databases and Purescale clusters.
  • Experience in configuring and supporting Tier-1 mission critical databases as a systems/infrastructure DBA.
  • In-depth knowledge of operating system AIX and hands on working experiences on AIX.
  • Good knowledge of capacity planning and architecture design for database server deployment.
  • Troubleshooting Purescale cluster issues, working with IBM opening PMR’s to resolve issues.
  • Proven experience in working in a mission critical environment in a multi-terabyte database platform, including Enterprise Data Warehouses (EEE).
  • Good understanding of data warehouse concepts including data marts and data lakes.
  • Perform routine maintenance on several database environments including application of updates, patches, and hotfixes
  • Creating databases, migrating database objects from non-production to production environment.
  • Designing and building data models, schemas, views, and tables to support application requirements
  • Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools such as Guardium.
  • Extensive experience designing and executing backup and recovery concepts and procedures
  • Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning/
  • Experience in using Splunk and other event management and performance monitoring tools.
  • Good understanding of licensing options and optimization.
  • Experience in scripting languages (shell or python or Perl) for automating DBA administrative tasks. Ansible experience a plus.
  • Experience with automation tools such as Control-M.
  • Experience in implementing DB2 LUW STIG implementation, testing, and other vulnerability remediation.
  • In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
  • Provide 24 x 7 Support to Critical production systems.
  • Knowledge of Project Management Methodologies
  • Experience in working closely with the application development teams to resolve any performance related issues and provide application support.
  • The Senior IT Database Administrator (Senior DBA) provides consultation related to database management and administration.
  • The Senior DBA’s perform detailed data flow analysis ensuring the highest levels of efficiency in database and query design in distributed data flows.
  • Senior DBA’s administer database systems to protect the confidentiality, integrity and availability of data.
  • The Senior DBA is responsible for maintenance, control and testing of complex databases which provide orderly methods of data storage and controlled access to data.
  • Senior DBA’s also maintain complex query language for established database systems, design and execute backup and recovery schemes and implement disaster recovery procedures.
  • The Senior DBA serves as a subject matter expert providing consultation to end-users and project team members on database management, query development, system requirements and database change management initiatives and providing technical guidance to other DBAs.
  • Consults on database, architecture and related infrastructure technologies to all areas and levels within IT.
  • Consults on exploiting opportunities involving multiple hardware and software systems, issue resolution, providing innovative business solutions, etc. to both internal and external customers and partners.
  • Provides technical leadership on the implementation of leading-edge database technologies and the design and implementation of large-scale technical solutions based on business requirements.
  • Develops and ensures compliance with all system, disaster recovery and security audit policies.
  • Writes complex programming/scripts.
  • Participate in disaster recovery design, testing and execution
  • Monitor and evaluate database performance and adjust database configuration as appropriate
  • Provide technical leadership to other DBAs
  • Design process for database change management issues related to environment migration
  • Make highly complex physical changes to current databases, often this requires working after hours
  • Maintain operational documentation (e.g., procedures, task lists, architecture blueprints)
  • Provide subject matter expertise to corporate projects and initiatives
  • Work with users and IT partners to understand requirements for a physical database design
  • Provide database consulting expertise to corporate projects and initiatives applying PMM and development life cycle concepts
  • Address customer concerns and issues related to database management
  • Evaluate database performance and adjust configuration appropriately
  • Provide production support for outages, restore/recovery events
  • Optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
  • Other duties as assigned

 

 

Share this role online (there may be a referral fee*)

How to Apply

For immediate consideration, please send your resume directly to Lory Weir at lory@hornetstaffing.comYou can view all of our open positions at www.hornetstaffing.com

Job Types: Temporary. Salaries: Not Disclosed.

148 total views, 0 today

Apply for this Job