Verdun Oil Company · 1 day ago
Senior Database Architect
Houston, TX
Full-time
Onsite
Senior Level
5+ years expVerdun Oil Company is seeking a Senior Database Architect to oversee the performance, security, and operational integrity of their relational database platforms, specifically Microsoft SQL Server and PostgreSQL. The role involves hands-on management of database operations, performance tuning, and collaboration with various teams to ensure reliable database environments that support critical business systems.
EnergyIndustrialOil and Gas
Responsibilities
Administer, monitor, and support SQL Server and PostgreSQL environments across development, test, and production
Perform routine and advanced DBA tasks, including backups, restores, patching, upgrades, index and statistics maintenance, vacuuming, and integrity checks
Proactively monitor database health, availability, replication, and performance; respond to and resolve production incidents
Troubleshoot query performance issues, blocking, locking, deadlocks, and resource contention
Manage database security, authentication, roles, and permissions in accordance with internal standards and compliance requirements
Plan and execute capacity management, storage growth, and performance scalability initiatives
Support and test high-availability and disaster recovery strategies for both platforms
Administer PostgreSQL databases, including configuration tuning (e.g., memory, autovacuum, WAL, checkpoints)
Manage replication, failover, and backup strategies for PostgreSQL environments
Analyze and optimize PostgreSQL query performance using EXPLAIN/ANALYZE and indexing strategies
Support schema changes, deployments, and operational maintenance in PostgreSQL production environments
Collaborate with development teams to ensure PostgreSQL best practices are followed in application design and usage
Administer and tune SQL Server instances supporting transactional, reporting, and analytical workloads
Design, deploy, and maintain SSAS Tabular models, including DAX measures, relationships, and refresh strategies
Tune Tabular models for performance, scalability, and efficient processing
Develop, maintain, and support SSIS ETL packages used for production data integration
Implement logging, monitoring, and error handling for ETL processes and resolve SSIS job failures
Use Redgate tools (SQL Compare, SQL Data Compare, SQL Monitor, Source Control) on a daily basis for deployments, monitoring, and change management
Support controlled database releases, schema comparisons, and rollback strategies across environments
Maintain clear documentation for operational procedures, recovery processes, and system configurations
Participate in on-call rotations and provide after-hours support for critical production issues
Perform root cause analysis and implement preventative controls to improve platform stability
Perform other related DBA duties as assigned
Qualification
Required
A Bachelor's degree in Computer Science, Information Systems, or a related field
A minimum of 5 years of hands-on DBA experience, with production responsibility for SQL Server and PostgreSQL
Expert-level experience administering SQL Server in production environments
Advanced T-SQL skills for troubleshooting, indexing, and performance tuning
Strong experience supporting SSAS Tabular and SSIS in enterprise environments
Familiarity with SQL Server HA/DR concepts and operational monitoring
Strong hands-on experience administering PostgreSQL in production
Knowledge of PostgreSQL internals, configuration tuning, and maintenance operations
Experience with replication, backups, restores, and performance troubleshooting
Ability to support PostgreSQL schema changes and operational releases safely and efficiently
Proven experience developing and maintaining Tabular models
Strong understanding of DAX and Tabular engine performance optimization
Experience supporting Power BI or similar reporting tools through SSAS semantic models
Strong experience building and supporting SSIS ETL pipelines in production
Familiarity with scheduling, monitoring, and troubleshooting ETL workflows
Daily hands-on use of Redgate tools for SQL Server deployments, monitoring, and source control
Experience implementing database DevOps and structured release processes
Full knowledge of the Microsoft software suite
Strong understanding of relational database design and data warehousing concepts
Experience supporting enterprise reporting and analytics platforms
Familiarity with source control and release management practices
Experience with database monitoring and deployment tooling
Preferred
Microsoft SQL Server or PostgreSQL certifications preferred
Company
Verdun Oil Company
Verdun Oil Company is an oil and gas company that focuses on acquiring and developing oil and gas assets.
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
$250M2015-12-29Private Equity· $250M
Recent News
Company data provided by crunchbase