DBA - SQL Server & Postgre - Platform Modernization

DBA - SQL Server & PostgreSQL - Platform Modernization 

• Location: Hybrid / Philadelphia (local candidates only)
• Full-time / Regular / Direct employment (with client)
• US Citizen/Greed Card Holders only (No C2C / Visa)
  

Were working with a respected financial organization that's expanding its data infrastructure team with a seasoned Database Administrator experienced in SQL Server, PostgreSQL, and Snowflake. This role plays a critical part in maintaining and modernizing a highly secure, performance-sensitive hybrid data environment supporting real-time financial operations.

About the Role
As a core member of the firm's data architecture and engineering function, you'll manage both legacy and cloud-native database systems, support production environments, implement automation and high availability, and contribute to cloud migration and data modernization strategies. This is a hybrid position based in Philadelphia, requiring 2 day per week onsite, with flexibility based on team needs and performance.

Key Responsibilities

• Administer and optimize SQL Server and PostgreSQL databases across hybrid environments
• Architect scalable, normalized schemas and high-performance queries
• Tune queries using execution plans, indexing strategies, and performance metrics
• Configure high availability and disaster recovery strategies (Always On, clustering, replication)
• Manage roles, permissions, tuning parameters, and replication in PostgreSQL
• Maintain secure, compliant environments with appropriate access controls and encryption
• Automate deployments and health checks using scripting (PowerShell, Bash, T-SQL, or Python)
• Monitor infrastructure using observability tools and respond to performance or availability issues
• Support Snowflake-based data warehousing and integration pipelines
• Participate in data migration, automation, and cloud enablement initiatives
• Collaborate with Infrastructure, InfoSec, Development, and Data Governance teams
• Contribute to documentation, planning, and platform improvement efforts

Requirements

• 5+ years of DBA experience with SQL Server and PostgreSQL in production environments
• Expertise in query tuning, backup and recovery, HA/DR, and replication techniques
• Hands-on knowledge of Snowflake (SnowSQL, ingestion, performance optimization)

• Experience supporting PostgreSQL on Red Hat Linux

• Familiarity with AWS RDS, Azure Database, or other managed PostgreSQL offerings

• Proficient in scripting: Python, T-SQL, PowerShell, or Bash

• Comfortable with observability tools (e.g., Prometheus, SQL Profiler, custom alerts)
• Ability to clearly document technical processes and follow change control protocols

• Strong interpersonal and communication skills

• Background in financial services or other regulated, data-intensive environments is a plus

Education

• Bachelors degree in Computer Science, Information Systems, or equivalent practical experience

Why Apply?

• You'll join a collaborative data engineering team focused on modernization, automation, and cloud transformation
• Be part of impactful, business-critical initiatives in the financial domain
• Work with leading technologies (SQL Server, PostgreSQL, Snowflake, AWS/Azure)
• Enjoy a hybrid schedule with consistent work-life balance and team support

Interested candidates with strong database architecture, scripting, and cloud experience are encouraged to apply. This is a chance to make a measurable difference on a talented team that's helping transform data infrastructure for the future of finance.