• Designing, developing, and implementing automated solutions for managing and optimizing Db2z and IMS databases • Implementing structural changes through environments and access method analysis • Optimizing Db2z resource utilization by tuning queries and recommending indexes • Processing Database Support Requests and Change requests in production and non-production environments • Building and implementing database backup and recovery strategies • Preparing disaster recovery (DR) documentation and participating in DR activities • Maintaining complex zOS Db2 databases with respect to JCL, DDL, Security and Db2 customer support • Providing technical training and consultation to other members of the IT organization • Supporting day-to-day monitoring and maintenance activities for Db2 z/OS • Responding to Audit requests and providing necessary documentation

• Develop & maintain naming standards for database objects such as tablespaces, tables, indexes & views • Install, configure, patch, maintain, and upgrade Oracle and Sql Server software and related products • Troubleshoot and resolve Oracle and Sql Server errors and user requests • Develop, implement, and enforce database standards, security guidelines and operational policies and procedures • Migrate database objects through the lifecycle management process for the development team • Monitor and apply performance tuning techniques to ensure the databases operate at high levels • Evaluate Oracle and Sql Server enhancements and features • Design and develop capacity planning processes of all databases • Review proposed architectural data models to ensure applications are being designed in accordance with database best practices • Other duties as assigned

• Install, configure, and maintain Microsoft SQL Server instances on Windows Server. • Manage databases across development, staging, and production environments. • Perform patching, upgrades, health checks, and routine maintenance tasks. • Monitor database and server performance using SQL Server-native tools and third-party platforms. • Optimize queries, indexes, jobs, and overall database architecture. • Diagnose and resolve performance bottlenecks across storage, compute, and SQL layers. • Design, implement, and maintain robust backup and recovery strategies. • Support HA/DR solutions including Always On Availability Groups, Clustering, Log Shipping, and Replication. • Ensure Affinitiv’s systems meet defined RPO/RTO requirements. • Manage database-level security, accounts, roles, encryption, and auditing. • Work with Security and Compliance teams to meet internal and external standards. • Monitor activity for abnormal or high-risk events and act proactively. • Partner with Infrastructure, Network, and Application teams to support server builds and configurations. • Develop and maintain scripts to automate routine tasks. • Leverage monitoring for proactive oversight. • Improve database management efficiency through automation and tooling enhancements. • Work closely with software engineering, SRE, and product teams to support database needs in application lifecycles. • Provide database expertise for new application features, deployments, and architecture decisions. • Maintain clear, thorough documentation of database structures, configurations, and procedures.

• Install, configure, and maintain Oracle, SQL Server, and other DB platforms (MySQL, PostgreSQL, etc.). • Perform upgrades, patches, and migrations across environments. • Monitor database performance and implement tuning strategies. • Implement and maintain database security policies, user access controls, and encryption standards. • Ensure compliance with regulatory requirements (e.g., GDPR, HIPAA, SOX). • Design and manage backup/recovery strategies. • Analyze query performance and optimize SQL code. • Work closely with developers to design efficient schemas and queries. • Provide production support and troubleshoot database issues.