Data Management and Database Administration Specialist
About the role
Come Build the Future with Us At Trellis Company, we're passionate about creating opportunities that change lives. Our vision is to connect people to education-to-employment pathways that transform their lives. For more than 40 years, we've helped individuals achieve educational and career success through innovative solutions, strategic partnerships, and mission-driven service. Today, we're building on that legacy by partnering with employers, educational institutions, workforce organizations, and community leaders to create stronger connections between learning and employment while expanding pathways to economic opportunity. Our mission is to develop and advance initiatives that grow individual economic mobility and expand community prosperity. At Trellis, you'll find the purpose of a mission-driven nonprofit combined with the energy and innovation of an organization focused on the future. Your ideas matter, your work has impact, and your contributions help create brighter futures for individuals, families, and communities. Join Trellis and help create pathways to opportunity, economic mobility, and lasting success. Job Summary The Data Management and Database Services Specialist provides advanced technical expertise for the administration, security, performance, governance, availability, and lifecycle management of Trellis enterprise data platforms. The position serves as the organization's primary technical resource for IBM Db2, Microsoft SQL Server, cloud-hosted database services, enterprise data management solutions, and data governance technologies. Responsibilities include database architecture, administration, monitoring, optimization, backup and recovery, disaster recovery, cloud data platform management, data governance, data quality, metadata management, and support of enterprise analytics and artificial intelligence initiatives. The position works collaboratively with business stakeholders, application owners, cybersecurity personnel, analytics teams, vendors, and technology staff to ensure enterprise data assets remain secure, reliable, compliant, discoverable, trusted, and aligned with Trellis business objectives and regulatory requirements.
Responsibilities
- Database Administration and Operations: Serve as the primary technical administrator for IBM Db2 and Microsoft SQL Server database environments; install, configure, patch, upgrade, monitor, maintain, and support enterprise database platforms; administer databases operating on mainframe, distributed, virtualized, and cloud-hosted platforms; monitor database availability, capacity, performance, storage utilization, and operational health; troubleshoot and resolve database incidents, service interruptions, performance issues, connectivity problems, and data integrity concerns; design and implement indexing, query optimization, statistics, maintenance, and performance-tuning strategies; coordinate production database changes with application owners, developers, project teams, vendors, and business stakeholders; maintain database standards, inventories, dependency maps, configuration records, architecture documentation, and operational runbooks; maintain enterprise metadata, business glossaries, data inventories, ownership records, and data lineage documentation; develop and maintain documentation of data flows, integrations, interfaces, and dependencies; participate in 24x7 operational support, including on-call responsibilities, as required.
- Backup, Recovery, and High Availability: Design, implement, monitor, and maintain database backup and recovery strategies; administer database replication, clustering, failover, log shipping, and other approved high-availability solutions; develop and maintain database disaster recovery procedures and supporting evidence.
- Cloud Data Platform Management: Administer enterprise cloud database and data platform services; manage Azure SQL Database, Azure SQL Managed Instance, SQL Server hosted in Azure, and other approved cloud database technologies; support Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, and other approved data services; support migration and modernization of legacy data workloads using approved cloud-native services; implement monitoring, governance, security, lifecycle-management, resiliency, and cost-optimization controls for cloud data environments; evaluate cloud data architectures for scalability, performance, availability, recoverability, supportability, and cost efficiency.
- Data Architecture and Integration: Review application, database, reporting, analytics, and integration designs for alignment with enterprise data