DB2 Database Administrator

DB2 DBA

The experience expected from applicants, as well as additional skills and qualifications needed for this job are listed below.

Salary Range: $115-$125k base + 10% bonus target

Location: Winston-Salem. NC

Hybrid - 2/3 days on Site

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 the clients 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 Serverenvironment 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:

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
B.S. degree in Computer Science/Engineering, MIS or equivalent

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