DB2 Database Administrator - The Clearing House

Position summary:

The Engineering role will be responsible for architecting, implementing, and the day-to-day activities related to the Enterprise Infrastructure & Services (EIS) Database portfolio within TCH Operations and Technology with oversight and governance for key systems administration initiatives ensuring the integrity of the distributed database services for our customer facing applications and corporate systems portfolio.

Essential functions and responsibilities:

• Provide subject matter expertise and support all aspects of the Db2 and SQL Server environment including administration and maintenance, business continuity, backup and recovery, capacity management, change management, security management, and installation\configuration management in production and non-production environments.
• Work with other technical staff to coordinate activities and implementations, follow and document procedures, respond, track, and escalate systems incidents
• Follow change management and configuration management procedures and guidelines
• Serve as technical lead /mentor /representative and provide technical guidance and mentorship
• Serve as representative for all technical issues/discussion with peer support teams
• Manage and delegate daily technical group tasks and efforts to appropriate staff/skills
• Oversee and manage BAU projects such as infrastructure software upgrades, patch management and continuous improvement
• Provide oversight for technical deployment plans and system utilization reports
• Extensive knowledge of core infrastructure components such as high availability/federation/replication
• Provide assistance and problem support to infrastructure partners, application developers, business analysts and business users while assessing impacts and communicating effectively
• Recommend innovative solutions aligned with the organizational initiatives and recognized problem areas
• Architect, deploy and champion adherence of an enterprise approach facilitating best practice methodologies to stakeholders across the estate
• Create, maintain and present detailed technical documentation and executive summaries for key stakeholders, including senior management
• Ability to facilitate productive meetings at the work group and steering committee levels of TCH

Additional responsibilities include:

• Work with Senior Managers and Business Users to design effective Business Analytics & Data Visualization Dashboards, assist with Data Analysis, Data Cleansing and Data Transformation
• Work closely with internal and external partners to guarantee continuous infrastructure availability
• Suggest and implement standard processes and procedures, continuous improvement, and automation efforts across the enterprise
• Provide technical leadership advice and industry best practices as first contact to stakeholders and clients pertaining to enterprise infrastructure related requests
• Perform special projects and initiatives as assigned
• Serve as technical lead/mentor/representative and act as proxy for manager when required

Qualifications required:

• B.S. degree in Computer Science/Engineering, MIS or equivalent
• 5-10 years as a Db2 subject matter expert in IT/financial services
• Deep knowledge of Db2 11.5 (and later) Database Administration techniques and strategies in a High Availability HADR environment
• Database Administration experience in a Db2 environment utilizing high availability / disaster recover features.
• Extensive knowledge of core infrastructure components such as high availability/federation/replication
• Ability to travel up to 10% (between NYC and NC)
• Strong facilitation skills with working committees and steering committees
• Experience with cloud technologies
• Very good knowledge within the Infrastructure ecosystem in execution of implementation initiatives, capacity management efforts, and design of high availability and backup & recover solutions
• Positive track record of delivering large scale complex projects & initiatives
• Ability to communicate with highly technical/quantitative as well as non-technical partners

Qualifications desired:

• Master’s degree or education/training/certification in an IT related field
• Experience configuring and maintaining Db2 Q-Replication or SQL Replication
• Technical Project and\or Product Management Experience
• Proficient with Dell/EMC Data Domain and Power Protect Data Manager (PPDM)
• Database Administration experience in a SQL Server 2019 and above environment utilizing high availability / disaster recover features.
• Extensive experience designing and developing enterprise software solutions
• Experience with agile development methodologies
• Experience working across large infrastructure environments and distributed across multiple data centers
• Experience with cloud technologies
• Extensive knowledge of core infrastructure components such as high availability/federation/replication

Physical demands and work environment:

• Ability to remain seated for long periods of time while working on computer or editing.
• Ability to work under highly stressful deadlines.
• Ability to handle multiple tasks simultaneously.
• Ability to prioritize appropriately
• Ability to sit and review information on a computer screen for long periods of time