Staff Software Engineer (PostgreSQL Admin)
Black Duck
Black Duck Software, Inc. helps organizations build secure, high-quality 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 industry-leading 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 customer-facing SaaS infrastructure. The ideal candidate is a proactive self-starter who excels in a fast-paced environment, demonstrates exceptional problem-solving 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 SQL-based 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 problem-solving.
- Advise on best practices for design and usage.
- Monitor systems and applications.
- Create and organize documentation.
- Provide off-hours and weekend support as needed.
- Administer and manage Hadoop and other database services.
- Participate in on-call 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 problem-solving, 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.