Database Architect

About the position

The Database Architect 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.

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.
• 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.