Guidesoft Inc. dba Knowledge Services

DB2 DBA

Posted Date 1 month ago(1/26/2018 11:22 AM)
Job ID
2018-10443
Job City
Carson City
Job State
Nevada

Overview

Long-term project for DB2 DBA at the State of NV in Carson City, NV!  Consultants must provide their own eqipment/software (under vendor supplied items).  

 

Knowledge Services,  established in 1994 and headquartered in Indianapolis IN, is a certified woman-owned (WBE) professional services organization with over 1500 employees located in offices throughout North America.  Founded by Julie Bielawski, CEO, Guidesoft, Inc. DBA Knowledge Services is an industry leader in Managed Service Programs (MSP), Employer of Record / Payrolling Services, National Recruitment, and Staffing Services.  We provide outstanding services to major organizations in various industries, including; IT, Healthcare, Entertainment, Media, Federal and State Governments, Public Utilities, Telecom, Manufacturing and more.

 

As such, Knowledge Services is committed to providing opportunities for growth – in our company, in each team member and in our relationships.  We believe titles do not define a person, but provide a framework to each person’s endless potential.  Our focus on improving our team, product and processes drive us every day.  We are guided by our four Pillars that set the foundation of who we are and how we conduct business:  Knowledge, Integrity, Innovation, and Service. 

 

Knowledge Services has benefit offerings to include the following!

 

  • Medical, dental, and vision coverage
  • Voluntary Life and AD&D coverage
  • Pet Insurance
  • Ticket and Event discounts!
  • The above are available provided contractors meet eligibility requirements

 

Responsibilities

  • Be responsible for providing State DBAs with supplemental expertise in the area of database technology;
  • Act as a resource to the Implementation Contractor’s technical design team in the establishment of the technical database designs;
  • Facilitate all aspects of the Implementation Contractor’s database design and database tuning activities;
  • Assist the Implementation Contractor in resolving technical database design issues;
  • Assist the State Technology Manager and the Implementation Contractor in maintaining standards and methodology for database design, deployment, maintenance and operation;
  • Ensure the Implementation Contractor’s methodology for database design is consistent with State standards and practices;
  • Through active analysis, be responsible for ensuring that all queries used by the NCSEAS application are efficient, use proper indexes and select the only data necessary to address a specific need;
  • Assist the State Technology Manager in collaboratively creating procedures that developers will use to identify new database tables and new or revised columns on existing database tables;
  • Assist the State Technology Manager and Implementation Contractor in estimating the database load and performance metrics;
  • Assist the State Technology Manager and Implementation Contractor in developing requirements for optimal operational memory, computing power, and data storage;
  • Participate in the review of the database design for the system and provide feedback relating to best practices and performance tuning;
  • Ensure modifications to the database design comply with the technical standards of the State and project;
  • Take active, lead role in performing all required database upgrades and patching throughout the course of the project;
  • Diagnose and address database performance issues as they occur;
  • Provide database deployment support for development, user acceptance testing, training and production environments;
  • Effectively communicate with Project Managers; and
  • Report to the State Infrastructure Manager

Qualifications

  • Over 5 years of experience administering DB2 LUW UDB, with most recent experience including DB2 LUW UDB 10+;
  • Experience in installing, configuring and upgrading DB2 LUW UDB databases using GUI and command line tools;
  • Over 10 years of experience creating, updating and tuning SQL queries, stored procedures, triggers and views in DB2 LUW UDB with most recent experience including DB2 LUW UDB 10+;
  • Physical database design, logical database design and capacity planning experience;
  • Performance tuning and maintenance of DB2 LUW UDB databases experience;
  • Experience in DB2 LUW UDB security management;
  • DB2 server architecture experience;
  • DB2 database clustering (HADR, etc.) experience;
  • Experience in developing and testing storage strategies and disaster recovery plans for DB2 LUW UDB database environments;
  • Experience in documenting policies, standards and procedures; and
  • Data Transformation Services experience.
  • Troubleshooting web application database connectivity
  • Setup, configuration and management of DB2 LUW UDB replication
  • Experience with SFTP
  • Experience with Job Scheduling in a LUW environment.
  • Experience with FileNet 
  • Experience with DB2 on z/OS

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.