Database Administrator

NiyamIT • Fairfax, VA

23h • Remote

About The Position

Niyam is seeking a Database Administrator (DBA) to join our team in support of a high-impact federal program. The role is ideal for an experienced DBA with deep expertise in relational and cloud-based database systems, data integration, and data warehouse management. The ideal candidate will be proficient in both structured and unstructured data systems, ETL processes, and Azure Synapse Analytics. Prior experience supporting federal agencies or working in a FedRAMP-compliant environment is a plus. Position currently allows remote work. This position is contingent on award of contract.

Requirements

• US Citizenship with ability to successfully complete a federal background investigation.
• Bachelor’s degree in Computer Science, Information Systems, Software Engineering, or related field .
• 7+ years of experience in database administration, including relational databases and cloud-based data warehouses.
• Strong experience with Microsoft SQL Server, Oracle, and Azure Synapse Analytics.
• Proficiency in ETL tools and data integration platforms (e.g., Azure Data Factory, Informatica, Ab Initio, SSIS).
• Experience with structured and unstructured data management, data modeling, and schema design.
• Familiarity with data governance, security policies, and federal compliance requirements (e.g., FedRAMP, Section 508).
• Strong scripting skills for automation (T-SQL, Python, or PowerShell).
• Knowledge of performance tuning, query optimization, and workload management in cloud environments.
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.

Nice To Haves

• Prior experience supporting federal agencies or working in a FedRAMP-compliant environment is a plus.

Responsibilities

• Design, implement, and maintain relational databases (MS SQL Server, Oracle) and cloud-based data warehouse solutions, including Azure Synapse Analytics.
• Evaluate, recommend, and configure DBMS products to meet agency or project requirements.
• Define database schema, indexing strategies, and data organization to optimize performance and query efficiency.
• Collaborate with security teams to configure and enforce data access policies, including row-level security, column-level security, and data masking.
• Develop and maintain ETL processes for data ingestion, transformation, and synchronization between multiple systems (e.g., Salesforce, agency-specific applications).
• Analyze existing database configurations and schemas, identifying gaps and implementing enhancements to support consistent, high-quality data structures.
• Integrate Azure Synapse with other Azure services, including Blob Storage, Data Factory, Analytics Service, Power BI, and SSRS.
• Optimize database performance, monitor workloads, and manage resource prioritization to ensure timely reporting and efficient processing.
• Execute bulk data cleansing, normalization, and loading operations.
• Develop and maintain stored procedures, scripts, and automated jobs to support database operations.
• Support ongoing operations and maintenance, including monitoring via Azure Monitor and Log Analytics, ensuring high availability, failover readiness, and performance optimization.
• Ensure compliance with federal data management and governance policies, including encryption at rest, redundancy, and disaster recovery planning.
• Participate in Agile development processes including sprint planning, code reviews, and backlog grooming.

Benefits

• Flexible Work Hours: Life doesn’t always fit into a 9-to-5 schedule. We offer flexibility to help you manage your work-life balance effectively.
• Remote Work: Niyam IT understands the value of flexibility. We offer remote work.
• Career Growth: Niyam IT is not just a job; it’s a career journey. We provide a supportive environment for your professional development and offer fully paid opportunities for training and advancement within the company.
• Great People: Our people are the blueprint of who Niyam IT is to the industry and community.
• Great Environment: Niyam IT fosters a great environment where innovation, collaboration, and personal growth thrive.
• Diversity & Inclusion: We believe in the strength of diverse perspectives. Your unique ideas are welcomed and celebrated every day at Niyam IT.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level