"Alerted.org

**Description:** We are seeking a skilled and experienced Postgres Subject Matter Expert (SME) to join our team. The ideal candidate will have in-depth knowledge and expertise in all aspects of Postgres database administration and management. The Postgres SME will be responsible for ensuring the efficiency, security, and optimization of our database systems to support our organization's data management goals.

Responsibilities and Duties:

+ Design, deploy, and maintain high-performance Postgres database environments

+ Troubleshoot and resolve database performance issues

+ Implement database security best practices and ensure data integrity

+ Develop and optimize SQL queries and stored procedures

+ Collaborate with cross-functional teams to design and implement database solutions

+ Manage database backups and recovery procedures

+ Stay current with industry trends and best practices in Postgres database technology

Qualifications and Skills:

• Bachelor's degree in Computer Science or related field

• Proven experience as a Postgres database administrator or SME

• Advanced knowledge of Postgres database administration, including configuration, tuning, and monitoring

• Proficiency in SQL and PL/pgSQL programming

• Strong analytical and problem-solving skills

• Excellent communication and collaboration abilities

• Relevant certifications (e.g., PostgreSQL Certified Professional) a plus

Candidates must be US citizens and have an existing secret security clearance.

Compensation Ranges

Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees.

EEO Requirements

It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment.

Physical Requirements

The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, "light office duties' or "lifting up to 50 pounds" or "some travel" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.

Disclaimer

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

125,000-173,000

EEO Requirements

It is the policy of ASM that an individual's race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.

All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.