Database Administrator

NiyamIT•Ashburn, VA

1d•Hybrid

About The Position

Niyam is seeking a Database Administrator to join our team in support of our work with a federal client. We offer competitive compensation and benefits. You will have the opportunity to apply your knowledge, skills and experience to building a truly modern application that is new development and cloud native. You will work in a SecDevOps environment that includes continuous integration/continuous deployment and test automation in a consistent agile software development framework. If you thrive in a culture of innovation and bring creative ideas to solve complex technical and procedural problems at the at the team and portfolio levels, then this opportunity is for you! This full-time position will be hybrid to Ashburn, VA.

Requirements

US Citizenship with ability to obtain a Public Trust.
Bachelor’s degree in Computer Science, Information Systems, or related field.
At least seven years of experience with databases, including designing, implementing, and optimizing database systems.
Experience with data modeling, tuning, scaling, security, backup, recovery, and integrity of RDBMS, specifically PostgreSQL in AWS.
Solid understanding of concepts such as data types, indexing, performance tuning, query plans.
Ability to take high level requirements and work with Product Architects to create a data model to store transactional data.
Understanding of Oracle, Microsoft SQL Server, or MySQL, as well as understanding of NoSQL databases like DynamoDB, MongoDB, Cassandra, or Couchbase.
Strong SQL skills for querying, analyzing, and managing data, as well as creating and maintaining stored procedures, triggers, and views.
Experience with CDC (change data capture) concepts and usage.
Knowledge of security best practices, including encryption, authentication, and access control, to ensure that sensitive data is protected and compliant with government regulations.
Experience with cloud-based database services such as Amazon Web Services (AWS) RDS, Google Cloud SQL, or Microsoft Azure SQL Database.
Experience with data integration tools and techniques, including ETL (Extract, Transform, Load) processes, and queue-based messaging systems to ensure seamless data flow between systems.
Familiarity with microservices based architecture and its impact to data storage.
Skills in analyzing and optimizing database performance, including indexing, partitioning, and query optimization.
Ability to work effectively with cross-functional teams, including developers, data analysts, and business stakeholders, to gather requirements and communicate complex database concepts.
Experience helping customers and mission users conceptualize and prioritize their data analysis and visualization needs.

Nice To Haves

Local to Ashburn, VA and available to work onsite.
Experience with NoSQL databases such as DynamoDB, DocumentDB, or Mongo.
Experience with geospatial data management.
Experience with Apache Kafka for messaging and data streaming.
Experience with data governance platforms such as Collibra.
Experience in Continuous integration, Continuous Deployment (CI/CD) and DevOps processes and tools.
Experience implementing or migrating to Cloud environments like Amazon Web Services (AWS), Google Cloud, or Microsoft Azure.

Responsibilities

Provide high-level architectural guidance, technical innovation, and analytical expertise to teams across federal client.
Champion all aspects of data architecture, analytic methodology, and visualization functions including engineering standards, governance processes, and providing vision and context to explore and effectively utilize emerging technologies.
Work with database developers and administrators across multiple product teams.
Serve as a data and technology expert across a broad and diverse set of mission critical applications
Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
Analyze project-related problems and create innovative solutions involving technology, analytic methodologies, and advanced solution components.
Deliver deployable software in short sprints.
Demonstrate adaptability and collaborate effectively with a technically diverse, geographically distributed team.