Sr Database Administrator - MSSQL Server/Postgres/MongoDB

Apex Fintech Solutions • Austin, TX

4d • Hybrid

About The Position

Apex Fintech Solutions is seeking an experienced Senior Database Administrator to manage, maintain, and support Microsoft SQL Server and PostgreSQL environments across Development, UAT, and Production. The role is responsible for database availability, security, performance, backup and recovery readiness, replication reliability, and operational automation.

The DBA will administer high-volume database systems, support production incidents and deployments, and collaborate with development, infrastructure, security, application support, and data teams. The position includes participation in scheduled maintenance windows and occasional after-hours production support. The work environment is hybrid, with three days per week in an office.

Requirements

• At least 8 years of hands-on Microsoft SQL Server DBA and PostgreSQL experience.
• Bachelor’s degree in Computer Science, Computer Engineering, or equivalent work experience.
• 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.
• Experience with a cloud solution; GCP is preferred.
• Familiarity with Windows Server, Active Directory, and Git/version-control practices.

Nice To Haves

• Experience with Fivetran HVR data replication.
• Experience supporting data migration and on-premises-to-cloud integration projects.
• Experience in regulated, financial services, or other highly controlled environments.
• Knowledge of formal change-management processes, including DCRs and technical deployment requirements.
• Experience with Google Cloud Platform (GCP).
• Familiarity with Terraform and Infrastructure as Code (IaC) practices.

Responsibilities

• 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 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 involving 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.

Benefits

• Healthcare benefits, including medical, dental, vision, and EAP.
• Competitive PTO.
• 401(k) match.
• Parental leave.
• HSA contribution match.
• Paid Calm app subscription.
• External learning benefits.
• Tuition reimbursement.
• Hybrid work schedule with flexibility to work from home and from a primary office.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior