Senior DBA - MSSQL, Postgres & Cloud Automation

APEX Fintech Services; Austin (TX); In loco; USD 120.000 - 160.000; Tempo pieno

Descrizione del lavoro

Apex Fintech Solutions seeks an experienced Senior Database Administrator to manage, maintain, and support Microsoft SQL Server and PostgreSQL environments across Development, UAT, and Production.

The DBA will ensure database availability, security, performance, backup and recovery readiness, replication reliability, and operational automation. Strong T‑SQL, PowerShell, and cloud platform experience preferred (GCP). Terraform/IaC skills are a plus.

Competenze

• 8+ years of hands‑on Microsoft SQL Server DBA and Postgres experience.
• Bachelor's degree in Computer Science, Computer Engineering, or equivalent work experience required.
• Experience supporting SQL Server 2016, 2019, and/or 2022.
• Strong T‑SQL scripting, query optimization, and performance‑tuning skills.
• Proficiency in PowerShell scripting for SQL Server administration and operational automation.
• Experience with SQL Server backup, restore, recovery, and disaster‑recovery processes.
• Strong knowledge of database security, user access management, roles, and permissions.
• Experience with SQL Server monitoring tools such as Idera SQL Diagnostic Manager (SQL DM) or similar platforms.
• Experience managing database storage, transaction logs, file growth, and capacity planning.
• Knowledge of database replication and data‑integration technologies.
• Experience supporting production incidents, root‑cause analysis, and change‑management processes.

Mansioni

• Administer and optimize high volume Microsoft SQL Server instances and PostgreSQL systems (including Cloud SQL) in highly available environments.
• Install, configure, patch, upgrade, and maintain SQL Server instances and databases.
• Manage database security, including user access, roles, permissions, and Active Directory integration.
• Perform database backups, restores, recovery testing, and snapshot activities.
• Monitor and optimize database performance, availability, storage, data files, and transaction logs.
• Execute SQL scripts for application deployments, schema changes, data population, and remediation.
• Develop and maintain PowerShell scripts to automate routine DBA tasks, including health checks, backups, maintenance, job monitoring, disk‑space validation, and reporting.
• Schedule, monitor, and troubleshoot automated database administration jobs and SQL Agent jobs.
• Respond to monitoring alerts related to disk space, transaction log growth, failed jobs, database availability, and performance issues.
• Investigate and resolve database connectivity, permissions, replication, and performance incidents.
• Support and maintain Fivetran HVR replication channels for on‑premises‑to‑cloud data movement.
• Troubleshoot replication failures and ensure data consistency across source and target systems.
• Support database change requests, technical requirement deployments, UAT testing, and production releases.
• Collaborate with development, infrastructure, security, application support, and data teams.
• Participate in scheduled maintenance windows and occasional after‑hours production support.
• Create and maintain DBA documentation, operational procedures, and runbooks.

Conoscenze

SQL Server

PostgreSQL

PowerShell

T-SQL

Cloud platforms (GCP)

Terraform

IaC

Formazione

Bachelor's degree in Computer Science, Computer Engineering, or equivalent

Strumenti

PowerShell

Google Cloud Platform

Terraform

Descrizione del lavoro

Apex Fintech Solutions seeks an experienced Senior Database Administrator to manage, maintain, and support Microsoft SQL Server and PostgreSQL environments across Development, UAT, and Production.

The DBA will ensure database availability, security, performance, backup and recovery readiness, replication reliability, and operational automation. Strong T‑SQL, PowerShell, and cloud platform experience preferred (GCP). Terraform/IaC skills are a plus.