Database Administrator

About Niyam IT (Niyam)

Niyam IT was founded in 2007 by a group of consultants who shared a unique vision: a technology company steeped in orderly process yet driven by passion and innovation. Over the following decade we fine-tuned our craft and built an impressive track record of successful outcomes securing our reputation as the go-to provider of smart innovative solutions.

Today Niyam is at the forefront of the industry leading the way in crafting mission-critical technologies for Emergency Preparedness & Response Natural Resource Management Law Enforcement & Justice Health IT and Global Citizen Services.

What We Offer:

• Flexible Work Hours: Life doesnt 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; its 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.

Join us in creating a workplace where innovation diversity and well-being thrive. Your journey at Niyam IT awaits. Apply today!

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.

Roles and 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.
  

Qualifications and Education Requirements:

• US Citizenship with ability to successfully complete a federal background investigation.
• Bachelors 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.
  

Application Deadline:This position will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.

Niyam IT Inc. is an Equal Opportunity (EEO) Employer. All qualified applicants will receive consideration without regard to race color creed religion sex sexual orientation gender identity pregnancy marital status partnership status age citizenship status veteran or military status medical condition genetic information national origin disability unemployment status or any other characteristic prohibited by federal state and/or local laws.If you require a reasonable accommodation due to a disability to complete your application or if you face challenges using our online application system and need an alternative way to apply please reach out to us at 1 703.429.2450 or email

Required Experience:

Senior IC