Database Administrator
Niyam IT
full-time
Posted on:
Location Type: Hybrid
Location: Ashburn • Virginia • United States
Visit company websiteExplore more
Tech Stack
About the role
- 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.
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.
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 understands the value of flexibility. We offer remote work.
- Career Growth : Niyam 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 is to the industry and community.
- Great Environment : Niyam 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data architecturedata modelingPostgreSQLSQLETLCDCNoSQLcloud-based database servicesdatabase performance optimizationmicroservices architecture
Soft Skills
adaptabilitycollaborationanalytical expertiseproblem-solvingcommunication
Certifications
Bachelor’s degree in Computer SciencePublic Trust clearance