Requirement: Database Administrator
Job Description:We are seeking a Database Administrator to support our TSA STAR contract and the development and operation of a business intelligence application that provides operational visualization of checked baggage screening equipment nationwide. The application is being built using Microsoft Power Platform and Microsoft 365 tools, including Power BI and Dataverse, with a potential transition to a Microsoft SQL Server database backend. This role will own the reliability, integrity, security, and performance of the application's data layer. The Database Administrator will work with application developers, Power BI developers, and program stakeholders to support the current Dataverse environment and help evaluate, design, and implement a SQL Server backend if selected.
Key Responsibilities:
- Administer and support the application's Dataverse data layer, including tables, relationships, data types, business rules, security roles, and data quality controls in coordination with the Power Platform team.
- Design and maintain logical and physical data models that support equipment information, operational reporting, and nationwide visualization requirements. Develop and maintain data ingestion, transformation, validation, and reconciliation processes; investigate incomplete, inconsistent, or failed data loads.
- Partner with Power BI developers to support reliable refreshes, efficient queries, appropriate source connectivity, and consistent reporting data.
- Evaluate SQL Server backend options and migration readiness, including schema design, data mapping, dependencies, security, performance, and operational support needs. If a SQL Server backend is adopted, administer databases and implement appropriate indexing, query tuning, monitoring, backup and recovery, and maintenance procedures.
- Plan and validate any approved database migration, including test loads, reconciliation, cutover, rollback, and post-migration support. Implement least-privilege access, auditability, and data protection controls within the approved customer environment; coordinate access and configuration changes with authorized administrators.
- Monitor data availability and performance; troubleshoot incidents and document root causes, corrective actions, data flows, configurations, and support procedures.
Qualifications/Requirements: Hands-on experience administering and supporting production databases or enterprise data platforms, including relational data modeling, data integrity, troubleshooting, and performance optimization. Strong working knowledge of Microsoft SQL Server and T-SQL, including queries, views, stored procedures, indexing, access controls, and backup and recovery concepts. Practical experience with Microsoft Power Platform, including Dataverse configuration or administration and integration with Power BI or other business applications. Familiarity with Microsoft 365 environments and identity and access concepts, including role-based access. Experience building or supporting repeatable data integration processes and validating data across source systems and reporting platforms. Ability to work independently in a remote team, communicate technical issues clearly, and maintain useful operational documentation. Ability to satisfy the TSA personnel vetting, access, and onboarding requirements applicable to this position.
Minimum Qualifications: - Strong experience with ETL, data migration, and integration
- Strong knowledge of and experience with OData protocol
- Strong customer service skills
- Excellent oral and written communication
- Ability to analyze and solve complex problems
- Ability to follow security protocol to protect sensitive data
- U.S. Citizen
- Bachelor's Degree or better in Computer Science, Computer Engineering, or Management Information System
Highly Desired Qualifications:- Currently supporting a TSA contract with existing TSA vetting and access eligibility that may support an expedited transition, subject to TSA verification and approval. Candidates with recent TSA contract experience are also encouraged to apply.
- Experience supporting TSA, DHS, or other federal government business intelligence applications.
- Experience with Dataverse-to-SQL Server migrations or applications using both platforms.
- Experience with Power Query, Power Automate, Power Platform environment management, and solution deployment across development, test, and production.
- Experience with Power BI semantic models, refresh troubleshooting, and database design for analytics; familiarity with Azure SQL or government cloud environments is a plus.
Job: Full-Time
Location: Remote (DMV/NCR preferred)
Salary Range: $110,000 - $130,000
Assigned Forge JobTitle: Project Specialist
Essential Duties:- Problem Solving- Identifies and resolves problems promptly; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem-solving situations; uses reason even when dealing with emotional topics.
- Written Communication- Writes clearly and informatively; edits work for spelling and grammar; varies writing style to meet needs; presents numerical data effectively; able to read and interpret written information.
- Diversity- Demonstrates knowledge of EEO policy; shows respect and sensitivity for cultural differences; promotes a harassment-free environment; builds a diverse workforce.
- Ethics- Treats people with respect; keeps commitments; inspires the trust of others; works with integrity and ethics; upholds organizational values.
- Strategic Thinking- Develops strategies to achieve organizational goals; understands organization's strengths & weaknesses; analyzes market and competition; identifies external threats and opportunities; adapts strategy to changing conditions.
- Planning/Organizing- Prioritize and plan work activities; use time efficiently; plan for additional resources; set goals and objectives; organize or schedule other people and their tasks; develop realistic action plans.
- Professionalism- Tactfully approaches others; reacts well under pressure; treats others with respect and consideration regardless of their status or position; accepts responsibility for own actions; follows through on commitments.
- Innovation- Displays original thinking and creativity; meets challenges with resourcefulness; generates suggestions for improving work; develops innovative approaches and ideas; presents ideas and information in a manner that gets others' attention.
- Qualifications- To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements below represent the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
- Language Skills- Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, proposals, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
- Mathematical Skills- Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
- Reasoning Ability- Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to question activities and issues in all functional areas and make sound business decisions based on that data.
- Physical Demands- The physical demands described here are representative of those that an employee must meet to perform the essential functions of this job successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. While performing the duties of this Job, the employee is regularly required to sit, talk, type, or hear. The employee is frequently required to walk, use hands to finger, handle, or feel, and reach with hands and arms.
- Work Environment- The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.
This job posting sets forth the basic authorities and responsibilities of this position, which may be changed from time to time as shall be determined. To perform this job successfully, an individual must be able to satisfy each essential duty.
Benefits:Forge fosters a rich company culture built on a diverse, hard-working employee base. Our staff is the core of our success and the impetus behind our decisions. In today's corporate culture, there is no longer a line between work and home life. As a result, we focused our benefits approach on the whole family.
The Forge total compensation model is based on a "choose-your-own-adventure approach" allowing each employee to create a comprehensive package of benefits and perks tailored to his or her needs. Examples of benefits included in our total compensation package include:
- Complete Flextime
- 401k With Employer Matching
- Healthcare, Including Medical, Dental, and Vision
- Health Savings Account (HSA) And Pre-Tax Premium Options
- Supplementary healthcare and family support
- Extended Short-Term Disability and Long-Term Disability
- Healthcare Insurance Deductible Paydown
- Health and Wellness Programs
- Tuition Reimbursement, Student Loan Repayment, and Education & Training Stipends
- Cell Phone / Internet Stipends
- College Saving Plans with Employer Contributions
- Alternative Work Locations and Tele-Commuting
- Employee Referral Awards
- Retention, Signing & Performance Bonuses
- Commuter Benefits
- Paid Sabbatical
