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