Staff Software Engineer PostgreSQL Admin

Black Duck Software Inc. helps organizations build secure highquality software minimizing risks while maximizing speed and productivity. Black Duck a recognized pioneer in application security provides SAST SCA and DAST solutions that enable teams to quickly find and fix vulnerabilities and defects in proprietary code open source components and application behavior. With a combination of industryleading tools services and expertise only Black Duck helps organizations maximize security and quality in DevSecOps and throughout the software development life cycle.

Job Summary:

We are seeking a highly skilled Senior PostgreSQL Administrator to join our dynamic Cloud Operations team at Black Duck. This pivotal role involves close collaboration with Engineering Product IT and other departments to implement and manage our global customerfacing SaaS infrastructure. The ideal candidate is a proactive selfstarter who excels in a fastpaced environment demonstrates exceptional problemsolving abilities and is committed to ensuring seamless product availability for large enterprises worldwide.

Key Responsibilities:

• Implement and administer multiple PostgreSQL installations.

• Manage data extraction loading and transformation across various data assets.

• Maintain clusters including administration monitoring tuning and troubleshooting.

• Provide consistent database maintenance optimization and best practices for NoSQL and SQL databases and applications.

• Implement best practices for NoSQL and SQLbased heterogeneous environments.

• Support current infrastructure and lead projects through implementation.

• Perform installation upgrade and configuration procedures.

• Design and manage replication topologies.

• Set up and maintain backup strategies (PITR & snapshot dumps).

• Actively test and validate backup strategies.

• Tune performance based on application and business needs.

• Monitor critical problems using appropriate tools.

• Proactively set up alerts to prevent sudden issues.

• Engage in triage debugging and resolution of critical problems.

• Leverage community knowledge and reach out for novel problemsolving.

• Advise on best practices for design and usage.

• Monitor systems and applications.

• Create and organize documentation.

• Provide offhours and weekend support as needed.

• Administer and manage Hadoop and other database services.

• Participate in oncall rotation.

Qualifications:

• 6 8 years of PostgreSQL management experience.

• Practical experience with PostgreSQL including database availability storage data memory performance tuning installations patching upgrades migrations and advanced backup and recovery.

• Familiarity with big data platforms.

• Proficiency in Perl bash or equivalent languages.

• Demonstrated creative thinking advanced problemsolving and troubleshooting skills.

• Strong interpersonal and communication skills.

• Ability to work well under pressure.

Education & Work Experience:

• BS in Computer Science or equivalent experience.

Join us and be a part of a team that values innovation collaboration and excellence. Apply now to make a significant impact on our global SaaS infrastructure!

Black Duck considers all applicants for employment without regard to race color religion sex gender preference national origin age disability or status as a Covered Veteran in accordance with federal law. In addition Black Duck complies with applicable state and local laws prohibiting discrimination in employment in every jurisdiction in which it maintains facilities. Black Duck also provides reasonable accommodation to individuals with a disability in accordance with applicable laws.