Logo
Spectraforce Technologies

Sr. DB2 DBA

Spectraforce Technologies, Jacksonville, Florida, United States, 32290

Save Job

Job Title: Sr. DB2 DBA Duration: 6 months with possible extension

Location: 100% Remote (Jacksonville, FL)

Interview: Panel interview- Video required

Required (must have):

10 or more year's professional experience as an application z/OS DB2 DBA on V11+.

8 or more years LUW DB2 including installing, supporting, configuring, and upgrading DB2 LUW subsystems.

Job Description:

In depth knowledge of the DB2 zOS architecture.

Experience with Netezza Performance Server database administration

Experience with DB2 Purescale environment

Experience working with IBM on opening cases and working with them

Experience in configuring and supporting Tier‑1 mission critical databases as an application z/os DBA and LUW systems/infrastructure DBA.

Good knowledge of capacity planning and architecture design for database server deployment.

Proven experience in working in a mission critical environment in a multi‑terabyte database platform, including analytics workloads.

Good understanding of data warehouse concepts including data marts, data Lakehouse and data lakes.

Perform routine maintenance on several database environments including application of updates, patches, and hotfixes for LUW servers

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 Nimsoft, Dynatrace or Datadog or 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.

Experience with automation tools such as Control‑M.

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.

Experience in working closely with the application development teams to resolve any performance related issues and provide application support.

Db2 tools, JCL, Perf monitoring (Omegamon) and Query monitor for z/os DB2

Required Education: Related Bachelor's degree in an IT related field or relevant work experience

Position is offered by a no fee agency.

#J-18808-Ljbffr