Senior DB2 DBA

Job Title: Senior DB2 DBA

Location: New Haven CT – Remote

Duration: Full-Time

Job Description:

Full Life Cycle Administration Primary skills DB2 Z/OS, DB2 LUW - Secondary skills SQL Server and Snowflake

Capable of leading DB2 Z/OS AND DB2 LUW projects

Recommends, installs, configures, monitors, and maintains Database Management Systems both on premises and in the cloud

Enforces Data Governance Policies, including database transactions and security audits

Strong understanding of database structures, theories, principles, and practices

Provides Database Administration services in support of information technology and business project activities, often serving as a member of a project team

Troubleshoot, manage, and resolve incidents, problems, service requests, and change management assignments associated with Database Management systems across the enterprise

On-call and/or after-hours work as required

Design Database Backup solutions that are highly recoverable for all Databases across the enterprise. Frequently requires engagement with internal departments, external partners, and/or vendors

Monitors Database performance and responds to issues for all supported Database Management Systems

Monitor, optimize, and allocate physical data storage for all supported Database Management Systems

Analyze and review proposed Database Management Systems based on industry experience, research, vendor interaction, proof of concepts, labs, and compliance.

Install, set up, and configure Database Management Systems in support of information technology and business project activities, serving as a member of a project team

Upgrade, maintain, and administer Database Management Systems across all platforms, including initial installations, patches, and hotfixes

Enforce Data Governance Policies for all Database Management Systems across the enterprise

Work with application development staff to develop database coding standards, quality assurance policies and procedures, and provide recommendations for Database performance tuning

Accountable for the management and resolution of incidents, problems, service requests, and change management assignments for all supported Database Management Systems

Provides support & services (evaluate, diagnose & resolve) to other internal ITS departments for diagnosing Database performance issues and recommending solutions

Accountable for the backup and recoverability of all Databases across the enterprise

Responsible for monitoring Database performance and responding to issues for all supported Database Management Systems

Responsible for monitoring, optimizing, and allocating physical data storage for all supported Database Management Systems

Participates in disaster recovery & business continuity testing for all Database platforms

Skill Qualifications

DB2 Z/OS, DB2 LUW

Additional bonus skills: SQL Server and Snowflake

Strong oral and written communication skills

Self-starter with good work ethic and attitude

Willing to transfer knowledge on DB2 technologies

Ability to research, recommend, and develop cost-effective solutions

Analytical and problem-solving skills

Sound judgment in decision making

Requires application of specific Database Management Systems-related technical skills and expertise

Formulates and presents recommendations for resolving complex issues and problems to the Manager

Participates in the identification and evaluation of alternative design options and tradeoffs

Reviews, verifies, and improves designs against specifications.

Proven analytical and problem-solving abilities

Ability to effectively prioritize and execute tasks in a high-pressure environment

Strong interpersonal and oral communication skills

Skilled at working within a team-oriented, collaborative environment

Ability to present ideas and solutions in business-friendly and user-friendly language

Highly self-motivated and self-directed.

Keen attention to detail

Operating Systems: Windows OS, Linux\Unix, Z\OS (Mainframe)

Database Management Systems: SQL Server on Premise, SQL Server Azure, DB2 LUW (Windows and Linux), DB2 on z\OS, Snowflake

Database Management tools and applications: SQL (SQL Server and DB2), stored procedures, Cron scheduling and VI Editor (Linux), SPF Editor and JCL (Mainframe), BMC Main view

Database Management scripting: in-depth knowledge of SQL, Stored Procedures in a relational Database environment

Network connectivity Protocols & Services: Including but not limited to ODBC, JDBC, FTP

Education and Experience Qualifications

Required:

BS or BA in Computer Science, Information Systems, or related field, or equivalent combination of experience and training

7 to 10+ years of experience in the administration of Database Management Systems or equivalent combination of training and experience

A reasonable, good-faith estimate of the minimum and maximum for this position is $60/Hr to $70/Hr with Limited benefits