Temporary IBM DB2 Purescale DBA
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
How to Apply
For immediate consideration, please send your resume directly to Lory Weir at lory@hornetstaffing.com. You can view all of our open positions at www.hornetstaffing.com148 total views, 0 today