Database Administrator

TECHNOVIZ LLC; Madison (WI); On-site; USD 90,000 - 120,000; Full time

Job summary

Technoviz LLC in Madison, WI seeks a DB2 UDB Database Administrator to analyze data for manufacturing and insurance/product ratios, design logical and physical databases, and install, maintain, backup, and troubleshoot DB2 UDB systems.

The role includes performance tuning, replication, data movement, and space and security administration, with hands-on work on IMPORT/EXPORT/LOAD and DB2MOVE to ensure reliable production support.

Qualifications

• Bachelor degree in Computer Science, Engineering (any), Information Technology or Business or related plus 1 year experience as a Computer Software Professional or BS equivalent (3 year bachelor plus 1 year) and 1 year experience as Computer Software Professional.
• Jobs based in Madison, WI. No travel (US or Intl), but 40% chance of relocation to unanticipated locations throughout the U.S.

Responsibilities

• Analyze data for manufacturing and consumer ratio of insurance, drugs and pharmacy products.
• Create logical, physical database designs for DB2 UDB.
• Install, maintain, backup, restore and troubleshoot problems with databases.
• Work with RDBMS database design, writing stored procedures and SQL queries.
• Engage in production support for DB2 UDB including backup and recovery, replication, data movement, performance tuning, capacity planning and provisioning, space administration and security role administration.
• Work in data movement utilities such as IMPORT, EXPORT, LOAD and DB2MOVE.
• Perform database administration tasks such as running reorg, runstats, import, export, Explain, db2advis, taking snapshots, checking memory and performing backup and recovery using TSM and NetBackup.

Skills

DB2 UDB

SQL queries

Backup & recovery

Performance tuning

Capacity planning

Security administration

Education

Bachelor degree in CS/Engineering/IT/Business

Tools

DB2 UDB tools

DB2MOVE

TSM

NetBackup

Import/Export

LOAD

Job description

JOB REQUIREMENTS:

Analyze data for manufacturing and consumer ratio of insurance, drugs and pharmacy products. Create logical, physical database designs for DB2 UDB. Install, maintain, backup, restore and troubleshoot problems with databases. Work with RDBMS database design, writing stored procedures and SQL queries. Engage in production support for DB2 UDB including backup and recovery, replication, data movement, performance tuning, capacity planning and provisioning, space administration and security role administration. Work in data movement utilities such as IMPORT, EXPORT, LOAD and DB2MOVE. Work in database administration tasks such as running reorg, runstats, import, export, Explain, db2advis, taking snapshots, checking the memory and performing backup and recovery using TSM and NetBackup.

OTHER EXPERIENCE AND QUALIFICATIONS:

Position Requires: Bachelor degree in Computer Science, Engineering (any), Information Technology or Business or related plus 1 year experience as a Computer Software Professional or alternatively BS equivalent (defined as 3 year bachelor degree plus 1 year experience) and 1 year experience as Computer Software Professional. Jobs based in Madison, WI. No travel (US or Intl), but 40% chance of relocation to unanticipated locations throughout the U.S.

Email resumes to [e-mail] or mail to Technoviz, LLC, 8517 Excelsior Drive, STE 105, Madison, Wisconsin 53717.