FactSet creates flexible, open data and software solutions for over 200,000 investment professionals worldwide, providing instant access to financial data and analytics that investors use to make crucial decisions.
At FactSet, our values are the foundation of everything we do. They express how we act and operate, serve as a compass in our decision-making, and play a big role in how we treat each other, our clients, and our communities. We believe that the best ideas can come from anyone, anywhere, at any time, and that curiosity is the key to anticipating our clients’ needs and exceeding their expectations.
Irwin is pushing PostgreSQL to its limits with complex schemas, heavy analytics, custom triggers, and integrations. We are seeking a Senior Database Administrator to own, assess the reliability, performance, and scalability of our PostgreSQL databases.
You will be the go-to expert, working with engineering and architecture teams to optimize queries, maintain schema health, and scale our platform. This is a high-impact role with challenges and opportunities to shape our data infrastructure.
Responsibilities:
Lead query tuning, slow query investigations, and performance baseline enforcement
Develop materialized view strategies and incremental refresh tooling
Manage vacuuming, table health, and index hygiene
Oversee PostgreSQL major version upgrades and replication cutovers
Resolve concurrency issues, deadlocks, and optimize triggers
Manage connection pooling and workload balancing
Build frameworks for performance testing and observability dashboards
Support integrations (Snowflake, dbt, Reverse-ETL) and optimize data flows
Balance PostgreSQL performance across both OLTP application workloads and analytical/reporting workloads.
Lead the existing slow query backlog using tools such as EXPLAIN and EXPLAIN ANALYZE to diagnose planner behavior and execution of bottlenecks.
Partner with backend engineers to identify and eliminate recurring N+1 query patterns and prevent similar regressions.
Required Qualifications:
Extensive expertise in PostgreSQL internals, architecture, and administration
Demonstrated success optimizing complex queries and addressing performance bottlenecks
6+ years working as a DBA
Hands-on experience managing materialized views and supporting high-concurrency environments
Advanced skills in index design and execution of major PostgreSQL version upgrades
Exceptional communication abilities, with a record of accomplishment of mentoring and collaborating across technical teams
Bachelor’s degree in computer science or equivalent work experience
Preferred Qualifications:
Experience with Snowflake data warehousing
Working knowledge of dbt for data modeling and transformation
Familiarity with Reverse-ETL processes and business intelligence tooling
Additional Assets:
Experience implementing logical replication in PostgreSQL
Background supporting large-scale SaaS applications
Proficiency with PgBouncer and background job processing systems
Why Irwin?
Your work will directly improve reliability, reduce latency, unlock product capabilities, and empower our teams.
Interested?
Share your resume and tell us about your hardest PostgreSQL challenge and solution.
Company Overview:
FactSet (NYSE:FDS | NASDAQ:FDS) helps the financial community to see more, think bigger, and work better. Our digital platform and enterprise solutions deliver financial data, analytics, and open technology to more than 8,200 global clients, including over 200,000 individual users. Clients across the buy-side and sell-side, as well as wealth managers, private equity firms, and corporations, achieve more every day with our comprehensive and connected content, flexible next-generation workflow solutions, and client-centric specialized support. As a member of the S&P 500, we are committed to sustainable growth and have been recognized among the Best Places to Work in 2023 by Glassdoor as a Glassdoor Employees’ Choice Award winner. Learn more at www.factset.com and follow us on X and LinkedIn.
At FactSet, we celebrate difference of thought, experience, and perspective. Qualified applicants will be considered for employment without regard to characteristics protected by law.
What We Do
FactSet creates flexible, open data and software solutions for tens of thousands of investment professionals around the world, providing instant access to financial data and analytics that investors use to make crucial decisions. For 40 years, through market changes and technological progress, our focus has always been to provide exceptional client service. From more than 60 offices in 23 countries, we’re all working together toward the goal of creating value for our clients, and we’re proud that 95% of asset managers who use FactSet continue to use FactSet, year after year. As big as we grow, as far as we reach, and as successful as we become, we stay connected to our clients and to each other.
