Database Architect - (Content Management Systems)

About the position

The Database Architect - Content Management Systems will oversee the design, implementation, optimization, and maintenance of structured content databases. This individual will play a key role in managing content repositories, ensuring seamless integration with content management systems (CMS), and supporting organizational goals by ensuring the availability, security, and performance of database infrastructure. The ideal candidate will have experience in with RWS Tridion Docs, Adobe Experience Manager, Content Cloud, Titan CMS or similar systems.

Responsibilities

• Develop and maintain structured content databases to support dynamic content delivery and reuse.
• Design scalable database schemas to store and manage structured content such as XML, JSON, and DITA-based information.
• Optimize database performance, ensuring high availability and reliability.
• Manage data modeling, indexing, and version control for structured content.
• Integrate databases with content management systems (e.g., Adobe Experience Manager, SDL Tridion Docs, or other CCMS platforms).
• Collaborate with developers to implement database-driven workflows and automated content delivery pipelines.
• Ensure seamless integration between databases, APIs, and enterprise applications.
• Implement integrated translations and accessibility technologies in delivery stages.
• Monitor database performance and execute tuning to maintain optimal efficiency.
• Troubleshoot and resolve database-related issues, including data integrity and application performance problems.
• Plan and implement database upgrades, migrations, and patches.
• Implement and maintain robust database security measures to protect sensitive information.
• Ensure compliance with data governance, privacy laws, and industry regulations.
• Regularly audit database access and security protocols.
• Lead cross-functional teams to define database requirements and implement solutions.
• Mentor junior database administrators and provide training on best practices for structured content management.
• Act as the subject matter expert for structured content databases within the organization.

Requirements

• Degree in Computer Science, Information Technology or a related field
• 10+ years of experience in database design and administration with a focus on structured content
• Experience with RWS Tridion Docs, Adobe Experience Manager, Content Cloud, Titan CMS or similar systems.
• Proven experience working with structured content formats (XML, JSON, DITA, etc.) and content repositories.
• Expertise in database technologies such as Microsoft SQL Server, Oracle, PostgreSQL, MarkLogic, or similar platforms.
• Strong understanding of structured content workflows and schema design.
• Proficiency in database scripting languages (SQL, PL/SQL, or T-SQL) and query optimization.
• Familiarity with CMS/CCMS platforms and their database requirements.
• Highly proficient user of Tridion Docs.
• Experience with API integration and database connectivity.
• Knowledge of data security standards and practices.
• Excellent analytical, problem-solving, and communication skills.

Nice-to-haves

• Experience with cloud-based databases (AWS RDS, Azure SQL, or similar).
• Knowledge of DevOps practices and tools for database automation.
• Certifications in database administration or content management (e.g., Oracle DBA, Microsoft Certified: Azure Database Administrator).

Benefits

• Medical, dental, and vision coverage
• Paid time off
• Disability insurance
• 401(k) with company match
• Life insurance and other voluntary supplemental insurance coverages
• Parental leave
• Adoption assistance
• Tuition assistance
• Employer/partner discounts