PostgreSQL Database Administrator - hybrid Philadelphia

Established in 1832, Janney Montgomery Scott LLC is a full-service financial services firm, providing comprehensive financial advice and superior service to individual, corporate, and institutional investors. At Janney, our mission is to be the highest standard of success in financial relationships.

Through our wealth management approach, we focus on the delivery of strategic financial plans
that utilize a variety of financial products and services best suited to help individual investors
and families meet their financial goals. Janney is equally committed to providing our corporate,
municipal and institutional clients objective advice for the successful execution of their unique
business plans. Janney serves clients through a network of professionals in branch offices primarily located along the East Coast.

The Janney Information Technology department has been a major contributor toward Janney
productivity with successive years of record enterprise growth. The culture focuses on valuing
individual contributions toward team accomplishments where employees have much say in their
job. Janney IT has been recognized within the financial services industry including: a CIO
100 Honoree, Enterprise Mobility excellence within financial services, Computerworld Premier 100 IT Leader, WealthManagement.com in the category of Technology for Broker-dealers with less than 1000 Advisors, and most importantly - awarded 10 of the last 11 years by either InformationWeek or Computerworld as one of the 100 Best Places to Work in IT. Computerworld has ranked Janney #17 of 27 Midsize organizations recognized in the 100 Best Places to Work in IT for 2024.

Job Summary:

We are seeking a highly skilled and experienced PostgreSQL Database Administrator to manage and maintain our PostgreSQL databases. The ideal candidate will be responsible for the design, implementation, and maintenance of robust, scalable, and secure PostgreSQL environments. This role demands deep technical expertise, excellent problem-solving skills, and a strong ability to work both independently and as part of a collaborative team.

Key Responsibilities:

• Database Design & Architecture: Design and implement PostgreSQL databases that are scalable, robust, and meet the business needs.
• Performance Tuning & Optimization: Identify, diagnose, and resolve database performance issues using techniques such as indexing, query optimization, and hardware resource tuning.
• Backup & Recovery: Develop and manage database backup strategies, including point-in-time recovery, replication, and disaster recovery solutions.
• Security Management: Implement and manage database security policies, ensuring compliance with data protection standards and regulations.
• Monitoring & Maintenance: Implement monitoring tools to ensure database health, uptime, and performance. Proactively manage capacity planning and scaling.
• Automation & Scripting: Automate repetitive tasks such as backups, monitoring, and database deployments using scripting languages like Bash, Python, or SQL.
• Database Upgrades & Patch Management: Plan and execute PostgreSQL upgrades, migrations, and patching activities with minimal downtime.
• Documentation & Best Practices: Maintain detailed documentation of database configurations, procedures, and standards. Promote best practices within the team and across the organization.
• Collaboration: Work closely with development teams, providing guidance on SQL query optimization, schema design, and database integration.
• Incident Management: Respond to and troubleshoot critical database issues, ensuring minimal impact on business operations.

Qualifications:

• Education: Bachelor s degree in Computer Science, Information Technology, or related field (or equivalent work experience).
• Experience: 5+ years of experience as a PostgreSQL Database Administrator.
• Certifications: PostgreSQL certifications (preferred but not required).
• Technical Skills:
• In-depth knowledge of PostgreSQL architecture, configuration, and internals.
• Proficiency in SQL query tuning, index management, and performance optimization.
• Experience with high-availability solutions like replication, clustering, and failover techniques.
• Hands-on experience with backup, recovery, and disaster recovery planning.
• Familiarity with cloud-based PostgreSQL deployments (AWS RDS, Google Cloud SQL, etc.).
• Strong scripting skills (Bash, Python, or similar).
• Knowledge of database security best practices and regulatory compliance.
• Experience with monitoring tools like pgAdmin, Nagios, Zabbix, or similar.

Soft Skills:

• Strong analytical and problem-solving abilities.
• Excellent communication and teamwork skills.
• Ability to work independently and manage multiple tasks in a fast-paced environment.
• Attention to detail and commitment to maintaining high standards.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.