DB2 LUW DBA DATABASE ADMINISTRATOR

Alpha Technologies Inc USA; New York (NY); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology company is seeking a skilled database professional in New York, NY. The role involves planning and executing database upgrades and migrations, providing performance tuning support, and monitoring production databases. Candidates should have extensive experience with various database systems including DB2 z/OS, Oracle, and SQL Server, alongside skills in automation and best practice advising. Competitive compensation offered along with flexible communication options.

Qualifications

• Extensive experience with planning, documenting, and performing database upgrades and migrations.
• Ability to provide performance tuning support for development teams.
• Familiarity with metadata, metrics, trending, and automation.

Responsibilities

• Create upgrade strategies with checklists and milestones.
• Advise developers on best practices for implementation.
• Monitor production databases for optimal performance.

Skills

Performance tuning

SQL Tuning

Database monitoring

Automation

Best practice advising

Tools

DB2 z/OS

Oracle

SQL Server

Hadoop

MySQL

MongoDB

PERL

Shell Script

Data Studio

Optimal Performance Manager

Job description

Extensive experience with planning, documenting and performing upgrades and migration, setting up new database environments. Design and plan upgrade strategies including coordination with the applications and business users. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures.

Provide performance tuning support to development teams for resolving issues with space usage, stored procedures, SQL Tuning and application monitoring.

Understand metadata, metrics, trending, and automation.

Advise developers for best practice, rollout implementation support.

Implement fixpacks and security patches when required.

Familiar with Performance Expert and OPM (Optimal Performance Manager). Configure, test, and install.

Monitor production databases and dbm settings, adjusting for optimal performance and throughput.

Technical expertise in the following desirable: DB2 z/OS, Oracle, SQL Server, Hadoop, MySQL, MongoDB, PERL, Shell Script, Data Studio, AD.

Additional Information

Send me your resumes at vince@alphait. us