Location: San Antonio, Texas
Employment Type: Full-Time
Work Arrangement: Onsite

Position Summary

The Junior SQL Database Administrator supports database development, administration, integration, and application programming activities. Working closely with senior database administrators, developers, business intelligence teams, and analysts, this position helps ensure database reliability, structured data storage, system availability, security, and effective support for reporting and analytics requirements.

The Junior SQL Database Administrator assists with database architecture, schema development, stored procedures, Microsoft Dataverse administration and integration, data pipelines, system monitoring, backup and recovery activities, and database security. The position also supports application design, coding, testing, debugging, maintenance, and technical documentation across the application development lifecycle.

Key ResponsibilitiesDatabase Administration and Development

• Assist with database architecture, configuration, administration, and maintenance activities.
• Support the development and modification of database schemas, tables, views, indexes, functions, and other database objects.
• Develop, update, test, and maintain SQL queries and stored procedures.
• Assist with troubleshooting database errors, data inconsistencies, connectivity issues, and application-related database problems.
• Support database upgrades, patches, migrations, and configuration changes under the direction of senior database administrators.
• Help maintain accurate and current technical documentation for database structures, configurations, procedures, and support activities.

Microsoft Dataverse Support

• Support the configuration, administration, and maintenance of Microsoft Dataverse environments.
• Assist with developing and maintaining Dataverse tables, columns, relationships, views, business rules, and security roles.
• Support integrations between Microsoft Dataverse, SQL databases, Microsoft Power Platform applications, reporting tools, and other enterprise systems.
• Assist with troubleshooting Dataverse data, permissions, connectivity, and integration issues.
• Support data migration, synchronization, transformation, validation, and reconciliation activities involving Dataverse.
• Help maintain data integrity, security, and governance within Dataverse environments.
• Work with Power Apps, Power Automate, Power BI, and development teams to support Dataverse-based applications and reporting requirements.

Database Monitoring and Performance

• Monitor database availability, system health, storage capacity, resource utilization, and performance indicators.
• Assist senior database administrators with query optimization, indexing strategies, execution plan analysis, and database performance tuning.
• Identify database performance concerns and escalate issues requiring advanced analysis or corrective action.
• Support implementation of database optimization and performance-improvement recommendations.
• Assist with analyzing system logs, database alerts, and performance reports.

Data Protection and Recovery

• Support data lifecycle management activities, including database backups, restores, retention, archiving, and disposal.
• Assist with testing and executing backup and recovery procedures.
• Participate in disaster recovery planning, testing, documentation, and execution.
• Help verify the completeness and recoverability of database backups.
• Support continuity-of-operations activities involving databases and integrated applications.

Database Security and Compliance

• Assist with implementing and enforcing database and Dataverse access controls, user permissions, roles, and security configurations.
• Support database security monitoring, vulnerability remediation, and audit-readiness activities.
• Help ensure database environments comply with applicable Department of Defense cybersecurity, information assurance, and data-protection requirements.
• Maintain database records and supporting documentation required for security reviews and audits.
• Assist with reviewing database activity, identifying unauthorized access attempts, and escalating potential security concerns.

Data Integration and Business Intelligence Support

• Assist in developing and maintaining extract, transform, and load and extract, load, and transform processes.
• Support data integration pipelines between SQL databases, Microsoft Dataverse, applications, reporting platforms, and other data sources.
• Perform data extraction, transformation, validation, reconciliation, and loading activities.
• Work with business intelligence teams to develop queries and datasets supporting dashboards, reports, and analytics.
• Validate dashboard data to confirm completeness, accuracy, and alignment with source systems.
• Assist analysts and developers with resolving data quality, mapping, and integration issues.
• Support reporting solutions that use data from Microsoft Dataverse and relational database systems.

Application Programming Support

• Support application program design, coding, testing, debugging, implementation, and documentation.
• Develop or modify programs based on technical specifications provided by engineers, technical architects, senior developers, or other technical personnel.
• Update, repair, modify, and expand existing computer programs and database-supported applications.
• Assist with analyzing business and functional requirements for applications and database solutions.
• Participate in application systems analysis and programming throughout the development lifecycle.
• Follow established coding, testing, configuration management, and documentation standards.

Collaboration and Technical Support

• Work collaboratively with senior database administrators, developers, engineers, analysts, business intelligence teams, and Government stakeholders.
• Participate in technical meetings, design reviews, testing activities, and troubleshooting sessions.
• Provide database, Dataverse, and data-integration support to application development and reporting teams.
• Communicate technical issues, findings, risks, and recommended actions to senior team members.
• Perform other duties as assigned.

Required Qualifications

• Six years of progressive experience demonstrating proficiency in database administration, SQL development, application programming, data integration, or a related technical discipline.
• Hands-on experience working with Microsoft Dataverse, including tables, relationships, security roles, data management, or system integrations.
• Foundational knowledge of SQL and relational database structures.
• Experience developing or modifying SQL queries, database objects, stored procedures, or database-supported applications.
• Experience integrating Microsoft Dataverse with SQL databases, Power Platform applications, reporting tools, or other enterprise systems.
• Basic experience with data integration, data transformation, and data validation processes.
• Understanding of database backup, restoration, security, and disaster recovery concepts.
• Knowledge of application program design, coding, testing, debugging, and technical documentation.
• Ability to understand the business or functional requirements supported by an application or database.
• Willingness and ability to learn database performance tuning, query optimization, and advanced administration concepts.
• Ability to work collaboratively with senior database administrators, developers, analysts, engineers, and technical architects.
• Strong analytical, troubleshooting, organizational, and communication skills.
• Ability to work onsite in San Antonio, Texas.
• Ability to satisfy the requirements associated with an ADP/IT-II position and a Tier 3 investigation.

Education

A bachelor’s degree in computer science, information technology, information systems, software engineering, data management, or a related field is desired.

Equivalent education, technical training, certifications, or relevant professional experience may be considered in place of a bachelor’s degree, subject to applicable contract requirements.

Certification Requirements

The selected candidate must possess or obtain and maintain an approved DoD 8570.01-M Information Assurance Technical Level II certification in accordance with applicable contract requirements.

Qualifying certifications are subject to the certifications identified in Section 3.0, Commercial Certificates, of the governing contract or task order.

Preferred Qualifications

• Experience administering Microsoft SQL Server or another enterprise relational database management system.
• Experience with SQL Server Management Studio, SQL Server Integration Services, or similar database and integration tools.
• Experience developing or maintaining ETL or ELT pipelines.
• Experience with Microsoft Power Apps, Power Automate, Power BI, and Dataverse-based solutions.
• Experience supporting Dataverse data migrations, environment management, security configuration, or application lifecycle activities.
• Familiarity with database performance monitoring, execution plans, indexing, and query optimization.
• Experience supporting Department of Defense, Defense Health Agency, Military Health System, or other Federal Government systems.
• Experience working in a regulated, audited, or cybersecurity-focused technical environment.
• Current IAT Level II certification.
• Favorable Tier 3 investigation or eligibility to obtain one.

Equal Employment Opportunity

Alkanna Consulting, LLC is an equal opportunity employer. Employment decisions are made without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state, or local law.

Pay: $70,000.00 - $80,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid time off
• Retirement plan
• Vision insurance

Work Location: In person