PostgreSQL Database Administrator

About Niyam IT (Niyam)

Niyam 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 understands the value of flexibility. We offer remote work.
• Career Growth: Niyam 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 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.

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

Niyam is seeking a PostgreSQL Database Administrator to join our team in support of our work with a federal client. We offer competitive compensation and benefits. We are seeking a PostgreSQL Database Administrator to support a mission-critical federal environment responsible for designing building and maintaining robust database solutions across on-premise and AWS cloud this role you will develop and manage logical and physical data models perform database upgrades and ensure high availability backup and recovery for RDS/Aurora environments. You will collaborate closely with application security and infrastructure teams to support operations troubleshoot performance issues and optimize database efficiency using tools like AWS Performance Insights. The position also involves supporting ETL processes (including Informatica) writing triggers and functions and leading data migration effortsparticularly from Oracle to PostgreSQLusing services such as AWS DMS. Additionally you will contribute to continuous improvement initiatives participate in proof-of-concept efforts for emerging technologies and help define database standards and best practices while supporting release management and on-call production operations.

Roles and Responsibilities

• Build ERD physical and logical data models.
• Follow and establish DB standards.
• Understand PostgreSQL architecture.
• Upgrade PostgreSQL Databases.
• Support the Functional Business Application Development and Security Technical Teams to provide O&M and Release Management support for landscape components.
• Integrate and support cloud RDS Databases providing high availability backup.
• Participate in the design activities consistent with enterprise standards and Agency priorities for continuous improvement (e.g.: Robotics Process Automation Automated Testing etc.) to deliver value-added solutions.
• Participate proof of concept in new technologies.
• Design develop and implement approaches for historical data retention and archival storage backup and recovery solutions.
• Work in a collaborative team environment with other operational (e.g. OS DBA network security etc.) team members to troubleshoot and optimize performance.
• Write triggers and functions to support ETL.
• Migrate data across heterogenous Databases.
• Work on AWS services specifically AWS DMS RDS Lambda S3.
• Work on performance insight AWS service.
• Work with Informatica ETL tool.
  

Qualifications and Education Requirements:

• US Citizenship with ability to obtain a Public Trust.
• Bachelors degree in Computer Science Software Engineering Information Management Systems or a related discipline (equivalent professional experience may be considered in lieu of degree).
• At least seven (7) years of technical experience.
• Five (5) years of experience as Database Administrator and Developer in PostgreSQL and Oracle environments.
• At least (2) Two years of AWS DMS service experience.
• Familiarity with RDS upgrades.
• Experience working on AWS performance insight.
• Strong analytical and problem-solving skills to provide expertise to support application team.
• Strong written communication skills to document implemented solutions or workarounds.
• Good understanding of physical and logical data modeling.
• Capable of working in a team environment and collaborating with other teams like platform support developers production support etc..
• Experience utilizing performance monitoring tools to work with application developers to identify and correct inefficient database operations.
• Database Migration experience strongly preferred especially Oracle to PostgreSQL.
• AWS RDS experience especially Aurora.
• Experience working with AWS services such as S3 AND Lambda.
• Strong programming background for writing triggers functions and procedures.
• Must be available for Production on-call support.

Preferred Skills:

• Local to Ashburn VA and available to work onsite.
• Proven experience with Oracle to PostgreSQL migrations using AWS DMS.
• Strong background in performance tuning and query optimization in large-scale PostgreSQL environments.
• Hands-on experience with AWS Aurora (PostgreSQL) in high-availability production environments.

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 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