Job Description
Job Description
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 environmentsArchitect scalable, normalized schemas and high-performance queriesTune queries using execution plans, indexing strategies, and performance metricsConfigure high availability and disaster recovery strategies (Always On, clustering, replication)Manage roles, permissions, tuning parameters, and replication in PostgreSQLMaintain secure, compliant environments with appropriate access controls and encryptionAutomate deployments and health checks using scripting (PowerShell, Bash, T-SQL, or Python)Monitor infrastructure using observability tools and respond to performance or availability issuesSupport Snowflake-based data warehousing and integration pipelinesParticipate in data migration, automation, and cloud enablement initiativesCollaborate with Infrastructure, InfoSec, Development, and Data Governance teamsContribute to documentation, planning, and platform improvement effortsRequirements
5+ years of DBA experience with SQL Server and PostgreSQL in production environmentsExpertise in query tuning , backup and recovery , HA / DR , and replication techniquesHands-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 offeringsProficient 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 protocolsStrong interpersonal and communication skills
Background in financial services or other regulated, data-intensive environments is a plusEducation
Bachelors degree in Computer Science, Information Systems, or equivalent practical experienceWhy Apply?
You'll join a collaborative data engineering team focused on modernization , automation , and cloud transformationBe part of impactful, business-critical initiatives in the financial domainWork with leading technologies (SQL Server, PostgreSQL, Snowflake, AWS / Azure)Enjoy a hybrid schedule with consistent work-life balance and team supportInterested 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.
