Senior Database AdministratorContinuum Solutions • Houston, Texas, United States
Dieses Stellenangebot ist nicht mehr verfügbar
Senior Database Administrator
Continuum Solutions
- Houston, Texas, United States
- Houston, Texas, United States
Über
Location: Houston, TX 77024
Onsite 100%
Duration: Direct Hire
Top Skills Required: 5+ years as a SQL DBA, PostgreSQL
*SUMMARY*
The Senior Database Administrator is responsible for the stability, performance, security, and availability of enterprise relational databases, with a primary focus on Microsoft SQL Server and PostgreSQL. This is a hands-on production role supporting 24/7 systems, including database operations, performance tuning, incident response, and deployment management. The role also owns SSAS Tabular models, SSIS ETL pipelines, and database deployments using Redgate tools, and works closely with application, reporting, and infrastructure teams.
*RESPONSIBILITIES*
*Database Operations (SQL Server & PostgreSQL)*
* Administer and support SQL Server and PostgreSQL across development, test, and production
* Perform backups, restores, patching, upgrades, maintenance, and integrity checks
* Monitor availability, performance, replication, and capacity; resolve production incidents
* Troubleshoot performance issues including blocking, locking, deadlocks, and resource contention
* Manage database security, roles, permissions, and compliance controls
* Plan and execute capacity and scalability initiatives
* Support high availability and disaster recovery strategies
*PostgreSQL*
* Tune PostgreSQL configurations (memory, autovacuum, WAL, checkpoints)
* Manage replication, failover, backups, and restores
* Analyze and optimize queries using EXPLAIN/ANALYZE and indexing
* Support schema changes and production deployments
* Enforce PostgreSQL best practices with development teams
*SQL Server, SSAS Tabular & SSIS*
* Administer and tune SQL Server for transactional, reporting, and analytical workloads
* Design and maintain SSAS Tabular models, including DAX, relationships, and refresh strategies
* Optimize Tabular model performance and processing
* Develop and support SSIS ETL pipelines
* Monitor ETL jobs and resolve failures
*Deployment & Operational Support*
* Use Redgate tools (SQL Compare, SQL Data Compare, SQL Monitor, Source Control) for deployments and monitoring
* Manage database releases, schema changes, and rollback strategies
* Maintain operational and recovery documentation
* Participate in on-call rotation and after-hours production support
* Perform root cause analysis and implement preventative measures
*REQUIRED SKILLS*
* 5+ years of hands-on DBA experience supporting SQL Server and PostgreSQL in production
*SQL Server*
* Advanced production administration and performance tuning
* Strong T-SQL troubleshooting and indexing skills
* Enterprise experience with SSAS Tabular and SSIS
* Knowledge of SQL Server HA/DR
*PostgreSQL*
* Production administration and performance tuning
* Replication, backup, restore, and maintenance operations
* Safe execution of schema changes and releases
*SSAS / DAX*
* Development and optimization of Tabular models
* Strong DAX and semantic model performance knowledge
*SSIS*
* Building, scheduling, monitoring, and troubleshooting ETL pipelines
*Tooling & Practices*
* Daily use of Redgate deployment and monitoring tools
* Experience with database DevOps, source control, and release management
* Strong understanding of relational database and data warehousing concepts
Pay: Up to $135,000.00 per year
Benefits:
* 401(k)
* 401(k) matching
* Dental insurance
* Flexible spending account
* Health insurance
* Health savings account
* Paid time off
* Vision insurance
Work Location: In person
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.