Please mention DailyRemote when applying
See how much of this job your resume covers, and what’s missing.
Want a recruiter to go through it line by line?
Get professional reviewQuestions interviewers often ask for this role, with sample answers.
One click makes a copy of your resume for this role, scores it against the posting, and proposes edits line by line. Your default resume is never changed.
Upload your resume and we draft a letter for this exact role, tailored to what it asks for.
The Senior Database Administrator will own and maintain the Azure Synapse cloud data warehouse, ensuring data security, performance, and reliability. They will collaborate with data engineers and dashboard developers to support federal public health analytics through agile development cycles.
Senior Database Administrator/Analyst(1099 Contractor)
At Fearless, we are seeking a part time, 20hrs a week, Senior Database Administrator / Analyst to own the cloud data warehouse behind a federal public health program's internal analytics platform. The platform brings together surveillance, program performance, and funding data in a single repository and serves it to leadership and program staff through interactive Power BI dashboards. This role is the team's database expert: designing and enhancing the Azure Synapse warehouse, keeping the data model and data dictionary current, tuning performance, and ensuring the data remains secure, backed up, and reliable. You'll work closely with a data engineer who builds the pipelines that load your warehouse and with dashboard developers who depend on your data model, all within two-week agile sprints covering both new development and ongoing operations and maintenance. This is a fully remote role.
Your Responsibilities in this Role:
● Design, build, and enhance the Azure Synapse Dedicated SQL data warehouse, including tables, views, stored procedures, and the data loads that feed Power BI dashboards.
● Add new data sources and data elements to the repository as program needs evolve, and run impact analysis before schema changes.
● Build and maintain the logical data model and data dictionary, and document data requirements for each dashboard view.
● Define data refresh strategies and schedules, and contribute data items to sprint planning and backlog reviews. ● Tune warehouse performance through distribution and partitioning strategy, indexing, statistics, and workload management.
● Implement role-based and row-level security so users see only the data their role allows, along with encryption and access logging.
● Maintain the backup and recovery plan, test restores, and coordinate with the agency's cloud platform team.
● Validate data quality by identifying duplicates, errors, and inconsistencies, and document validation processes. ● Prepare test data and support performance, security, beta, and user acceptance testing for each release.
● Promote database changes from development to test to production following the agency's change and release processes.
● Store all database code in source control using GitHub and keep technical documentation current.
● Monitor repository health and usage, and report metrics that inform maintenance and improvements.
● Follow federal data security, privacy, and governance requirements, including annual confidentiality training for HIV surveillance data.
PROJECT SPECIFIC SKILL AND EXPERIENCE REQUIREMENTS
Required Experience
● Minimum of 8 years of experience in database administration, database development, or database analysis.
● Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent work experience.
● Ability to pass a federal background investigation and obtain public trust clearance
● At least 3 years of hands-on experience with Azure SQL data platforms, with Azure Synapse Analytics Dedicated SQL Pool strongly preferred.
● Advanced T-SQL skills, including stored procedures, views, CTAS, and query performance tuning.
● Demonstrated ability to design logical and dimensional data models for analytics and reporting, including star schemas and data dictionary maintenance.
● Proven track record tuning performance in cloud data warehouses through distribution strategy, partitioning, indexing, and workload management.
● Deep knowledge of database security implementation, including role-based access, row-level security, encryption, and audit logging.
● Hands-on background managing backup, recovery, and restore testing in cloud environments.
● Proficiency with Git-based source control and deploying database changes across development, test, and production environments.
● Experience working on agile delivery teams, including sprint planning, backlog refinement, and user acceptance testing.
● Clear technical writing for data models, data dictionaries, and other technical documentation.
Preferred Experience
● Azure Databricks and PySpark for data validation and transformation.
● Power BI data models and working knowledge of DAX.
● Azure DevOps for backlogs and CI/CD of database changes.
● Azure Data Factory or other Azure data integration tools.
● Azure Monitor and Log Analytics for health and usage monitoring.
● Background supporting federal health agencies or public health programs, especially CDC enterprise cloud environments or surveillance data systems.
● Familiarity with federal security and privacy practices, including FISMA, HHS policy, and Section 508 accessibility standards.
● Microsoft certifications such as Azure Database Administrator Associate (DP-300) or Azure Data Engineer Associate (DP-203).
Physical Requirements:
Life at Fearless
We're a digital integration consultancy on a mission to build a better tomorrow. At Fearless, we combine technology, people, and organizational development to solve meaningful problems. Through iterative development, we deliver smart, user-friendly solutions that make technology work better—for everyone.
But great technology is only part of the story. What truly sets Fearless apart is our Purple Culture and our commitment to building meaningful partnerships with the people who help us deliver exceptional results.
What Makes Us Purple?
Whether you're a team member, contractor, or partner, our Purple Culture influences how we collaborate, communicate, and solve problems together.
Being Purple means you:
We're proud to be an equal opportunity organization. We believe diverse perspectives make us stronger, and we welcome individuals from all backgrounds, experiences, and identities.
Compensation & Engagement Details
Fearless is committed to offering competitive contract rates that reflect the expertise, experience, and value our independent contractors bring to client engagements. Final rates are determined based on experience, qualifications, project requirements, and market considerations.
This position is structured as an independent contractor (1099) engagement and is not eligible for employee compensation programs or benefits.
Why Partner with Fearless?
When you partner with Fearless, you'll have the opportunity to:
Independent Contractor Requirements
To engage with Fearless as an independent contractor, the following documentation must be provided prior to the start of work:
Additional documentation may be required depending on the nature of the engagement.
Reasonable Accommodations
Fearless is committed to providing reasonable accommodations for applicants and candidates with disabilities. If a reasonable accommodation is needed to participate in the application or interview process, please contact the Human Resources Department at hr@fearless.tech.
So, What's Next?
We've refined our engagement process to ensure alignment between Fearless, our clients, and our contractor partners.
If there's mutual alignment, we'll reach out to begin the interview and evaluation process. Depending on the role or project, the process may vary slightly, but typically includes:
1. Introductory Conversation
We'll connect to:
2. Skills Assessment (If Applicable)
For some engagements, we'll ask you to complete a role-specific assessment or work sample to better understand your capabilities and approach.
3. Skills & Business Fit Conversation
This conversation allows us to:
Where You Can Partner with Fearless
At Fearless, we’re proud to partner with talented independent contractors across the United States. We are currently able to engage 1099 contractors residing in all 50 states. For contractors who may be interested in future full-time employment opportunities with Fearless, please note that our current W-2 employment footprint includes the following states:
Alabama, Delaware, District of Columbia, Florida, Georgia, Maryland, New Jersey, New York, North Carolina, Ohio, Pennsylvania, South Carolina, Tennessee, Texas, and Virginia.
While contractor engagements are available nationwide, eligibility for future W-2 opportunities is contingent upon residing in one of our approved employment states at the time of consideration.
#LI-Remote
Stop the endless job search. Our AI finds and applies to the best jobs for you.
Featuring 217,934+ Jobs in Database Administrator
Answer easy questions
217,934+ jobs across 15+ categories
Get your best job matches
Only hand-screened, legit jobs
Find a remote job faster
No ads, scams, or junk
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”