Data Management and Database Administration Specialist

Texas Guaranteed Student Loan Corp•Round Rock, TX

1d•$85,913 - $132,174•Hybrid

About The Position

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.

Requirements

Advanced knowledge of IBM Db2 administration, architecture, security, backup, recovery, monitoring, and optimization.
Strong knowledge of relational database theory, SQL, database design, logical and physical data modeling, and data integrity principles.
Knowledge of Azure database and data services, including Azure SQL, Data Factory, Data Lake Storage, Synapse Analytics, and Microsoft Fabric.
Knowledge of metadata management, data cataloging, data lineage, business glossaries, data governance, data stewardship, and data quality concepts.
Knowledge of master data management, reference data management, information classification, retention, privacy, records management, and secure disposition principles.
Knowledge of ETL, application integration, hybrid data architectures, reporting platforms, analytics, and AI data-governance principles.
Knowledge of security controls including encryption, masking, tokenization, auditing, DLP, privileged access management, logging, and vulnerability management.
Understanding of applicable NIST-based controls, and related compliance obligations.
Ability to automate activities using PowerShell, Python, or comparable approved technologies.
Ability to evaluate technical risks and translate business, security, compliance, availability, and performance requirements into practical solutions.
Ability to plan and execute upgrades, migrations, maintenance, recovery testing, and complex production changes.
Excellent analytical, troubleshooting, organizational, documentation, and problem-solving skills.
Ability to manage multiple priorities, operational incidents, and technical initiatives simultaneously.
Skilled in utilizing AI-enabled tools and technologies to improve efficiency, enhance work quality and outcomes, and support innovation and continuous process improvement.
Ability to work independently and collaboratively with business stakeholders, peers, management, professionals, and vendors.
Bachelor's degree in Computer Science, Information Systems, Data Management, Database Administration, Information Technology, or a related field.
Five years of progressively responsible database administration or closely related data-platform experience.
Experience supporting business-critical production database environments.
Experience performing database installation, configuration, patching, upgrades, backup, recovery, performance tuning, capacity planning, and disaster recovery testing.
Experience implementing database security controls, privileged access, and access-review processes.
Experience supporting regulated or compliance-driven environments and sensitive data.
Experience developing technical documentation, operating procedures, recovery plans, and support standards.

Nice To Haves

Student loan industry experience.
Hands-on IBM Db2 administration experience.
Hands-on Microsoft SQL Server administration experience.
Experience supporting cloud database technologies, data integration, or modernization initiatives.
Azure SQL Database or Azure SQL Managed Instance administration experience.
Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, or Power BI semantic-model experience.
Experience with database and infrastructure automation using PowerShell or comparable technologies.
Enterprise data governance, metadata management, data catalog, data lineage, master data, or data-quality experience.
Experience supporting analytics, reporting, machine learning, or AI solutions.
Experience supporting audits, security assessments, vulnerability remediation, access reviews, and disaster recovery exercises.
Microsoft Certified: Azure Database Administrator Associate.
Microsoft Certified: Azure Data Engineer Associate or successor data-engineering certification.
Microsoft Certified: Fabric Analytics Engineer Associate.
Microsoft Certified: Azure Fundamentals or Azure Data Fundamentals.
IBM Db2 Database Administrator certification or comparable IBM certification.
Certified Data Management Professional (CDMP).

Responsibilities

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.
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.
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.
Review application, database, reporting, analytics, and integration designs for alignment with enterprise data standards.
Support development and maintenance of enterprise data architecture standards, naming conventions, and design patterns.
Design, develop, review, and support tables, indexes, stored procedures, views, schemas, and related database objects.
Support extract, transform, and load processes, application interfaces, and other approved data-integration methods.
Evaluate designs for scalability, integrity, security, recoverability, performance, and operational supportability.
Evaluate, adopt, and apply AI-enabled technologies to support strategy, improve workflow efficiency, automate routine tasks, and enhance data-driven decision making.
Support data platforms used for reporting, business intelligence, analytics, machine learning, and artificial intelligence workloads.
Help ensure analytics and AI solutions use trusted, governed, appropriately classified, and authorized data sources.
Implement and maintain database security controls in partnership with Enterprise Security Services.
Administer database roles, privileged and service accounts, and access permissions using least-privilege and role-based-access principles.
Support encryption, data masking, tokenization, auditing, logging, monitoring, and data-loss-prevention controls where appropriate.
Implement proactive monitoring, alerting, health checks, capacity management, and performance baselines.
Participate in change-management processes and ensure database changes include testing, implementation, validation, and rollback procedures.
Develop corrective and preventive actions that improve reliability and reduce repeat incidents.
Automate recurring administration, compliance evidence collection, monitoring, and reporting activities using approved scripting and orchestration tools.
Research, evaluate, design, and recommend database, governance, and data-platform technologies.
Review vendor proposals, technical designs, licensing implications, support models, and implementation plans.
Develop knowledge-transfer materials and cross-train technology staff to reduce single-person dependency for critical database services.
Act as a good steward of Trellis resources through responsible management of licensing, cloud consumption, storage, support costs, and technology investments.
Participate in technology governance and architecture review activities.
Maintain awareness of emerging database, cloud, governance, analytics, security, and AI technologies.
Perform other duties and special projects as assigned.