
Senior Database Architect
9th Way Insignia
contract
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $96,370 - $98,684 per year
Job Level
Senior
Tech Stack
ETLMS SQL ServerSQL
About the role
- Provide full-spectrum database architecture and DBA support across the EASS eCMS portfolio, ensuring performance, data integrity, scalability, and compliance with enterprise standards.
- Architect, administer, and optimize SQL Server environments, including schema management, stored procedures/functions, indexing strategies, query optimization, and performance tuning.
- Design and implement database structures, create tables, and establish data relationships to support application enhancements and integrations.
- Produce optimized SQL queries and data structures that support enterprise reporting and analytics consumption needs.
- Develop and maintain a comprehensive data dictionary and ensure regular updates to reflect schema and data model changes.
- Analyze database performance improvement opportunities and support modernization efforts, including streamlining data movement patterns that support service reliability and reporting.
- Support identity and encryption-related implementation and maintenance activities impacting database access and protection, coordinating with security and platform stakeholders.
- Produce and maintain recurring database reporting artifacts, including schema management reports, system performance reports, and security compliance reporting.
- Ensure database work supports auditability, operational readiness, and predictable release implementation through clear documentation and disciplined change control.
- Collaborate with engineering, integration, and reporting teams to ensure database changes are implemented, tested, and deployed predictably and safely.
Requirements
- Master’s degree in Computer Science, Electronics Engineering, or other engineering/technical discipline (required); ten (10) additional years of directly relevant experience may be considered in lieu of meeting the degree requirement.
- Five (5)+ years of experience performing senior-level database architecture and/or DBA responsibilities in enterprise environments.
- Demonstrated expertise with Microsoft SQL Server, relational data modeling, T-SQL, stored procedures, indexing, query optimization, and performance tuning.
- Experience supporting data movement and reporting needs (e.g., ETL patterns, integrations, and analytics consumption).
- Proven ability to produce and maintain technical database documentation and recurring operational reports (e.g., data dictionary, schema change documentation, performance and compliance reporting).
- Strong stakeholder communication skills and ability to coordinate work across engineering, security, and reporting teams in a structured delivery environment.
- Ability to obtain and maintain a Public Trust clearance at the Tier 2 (Moderate Risk) level (active preferred).
Benefits
- Medical
- Dental
- Vision
- Voluntary Life Insurance
- 401(k)
- Basic Life A&D
- STD
- LTD
- PTO
- Telehealth
- paid holidays
- FSA
- HSA
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
database architectureDBA supportSQL ServerT-SQLstored proceduresindexingquery optimizationperformance tuningdata modelingETL
Soft skills
stakeholder communicationcollaborationstructured deliverydocumentationcoordination
Certifications
Master’s degree in Computer SciencePublic Trust clearance (Tier 2)