Senior Associate Database Administrator

Role summary

PostgreSQL administration

• Provide L2/L3 production support, troubleshoot issues, and configure replication for high availability.
• Manage SSL certificates, authentication, database users, roles, and privileges.
• Plan disaster recovery, including point-in-time recovery; optimize queries and perform maintenance such as VACUUM and ANALYZE.
• Automate administrative tasks and reports; monitor environments with Dynatrace and collaborate with application teams.

Cassandra administration

• Provide L2 production support, troubleshoot using logs and diagnostics, and manage production clusters, replication, and quorum settings.
• Manage certificates, authentication, roles, and permissions; upgrade versions and perform routine health checks.
• Use DSE OpsCenter for monitoring, repairs, compactions, backups, and cluster maintenance; automate tasks with UCD templates and Git.

IBM Db2 administration

• Support IBM Db2 LUW, HADR, SQL replication, and Tivoli System Automation high availability.
• Perform Fix Pack upgrades, maintenance, backups, restores, and disaster recovery testing.
• Troubleshoot with Db2 diagnostic utilities, tune queries, manage transaction logs and access, and monitor performance.

Shared operational responsibilities

• Maintain ServiceNow asset records, generate monthly resource utilization and currency reports, and coordinate database license management.
• Identify and remediate vulnerabilities; support audits with documentation and evidence; maintain quarterly access control lists.
• Perform proactive monitoring, incident resolution, root cause analysis, automation, and planned production changes while following security and change standards.

Platforms and tools

• Databases: PostgreSQL, Cassandra, IBM Db2 LUW; required experience also includes Microsoft SQL Server and Oracle.
• Tools include Dynatrace, DSE OpsCenter, IBM Tivoli, shell scripting, Tivoli Workload Scheduler, UrbanCode Deploy, Git, Ansible, and ServiceNow.
• Technologies include Kerberos, LDAP, SSL certificates, replication, HADR, TSA, and point-in-time recovery.

Required experience

• Experience administering IBM Db2 LUW, with experience in PostgreSQL, Cassandra, Microsoft SQL Server, and Oracle.
• Experience managing public or private cloud, especially migration from on-premises to cloud, and database patching.

Preferred experience

• Automation experience, especially IaaS, and vulnerability management are preferred.
• Experience with on-premises AD FS and Microsoft Active Directory and/or Azure AD is preferred.