Senior Database Administrator

Valiant Technologies LLC; Austin (TX); On-site; USD 76,000 - 108,000; Full time

Job summary

Valiant Technologies LLC in Austin, TX seeks an experienced Senior Database Administrator to lead SQL Server administration and production support across multiple environments. The role requires hands-on SQL Server engineering, backup/recovery planning, and HA/DR implementation, with strong ETL/SSIS experience.

The ideal candidate will install, configure, and upgrade SQL Server instances, optimize performance, and manage security and access.

Qualifications

• Strong Microsoft SQL Server administration and engineering.
• Install, configure, maintain, patch, and upgrade SQL Server environments across production and non-production systems.
• Build and configure new SQL Server environments and provide ongoing administration and support for existing databases.
• Strong stored procedures, views, triggers and query troubleshooting.
• Performance tuning, indexing and execution-plan analysis.
• Security, logins, roles/permissions and database access management.
• Develop, Support, and troubleshoot SSIS and ETL processes, including failed jobs and connectivity issues.
• Ongoing maintenance of existing databases: monitoring, health checks, index and statistics maintenance, integrity checks, SQL Server Agent jobs.

Responsibilities

• Install, configure, and maintain SQL Server environments.
• Provide ongoing administration and support for production and non-production databases.
• Perform performance tuning and query optimization to support business applications.
• Manage security, logins, roles, and access controls for databases.
• Develop and troubleshoot SSIS/ETL processes and jobs.
• Maintain backups, recovery plans, and DR procedures for databases.
• Configure and manage High Availability and Disaster Recovery (HA/DR) setups.
• Coordinate with networks for firewall and connectivity issues affecting DB access.
• Automate repetitive tasks using PowerShell and T-SQL scripts.
• Collaborate with application teams on changes and releases impacting databases.

Skills

SQL Server administration

Production support

Performance tuning

T-SQL

PowerShell scripting

Backup and recovery

HA/DR design

AOAG / WSFC

Windows Server

Security and access management

Tools

SSIS

WSFC

AOAG

SQL Server Agent

Windows Server

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior Database Administrator
Location: Austin, TX
Duration: 11 Months + Extension
Bill Rate: $67/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

• 8+ years overall, with strong hands-on SQL Server administration and production support experience

Must-have:

• Strong Microsoft SQL Server administration and engineering
• Install, configure, maintain, patch, and upgrade Microsoft SQL Server environments across production and non-production systems
• Build and configure new SQL Server environments and provide ongoing administration and support for existing business-critical databases
• Strong stored procedures, views, triggers and query troubleshooting
• Performance tuning, indexing and execution-plan analysis
• Security, logins, roles/permissions and database access management
• Develop, Support, and troubleshoot SSIS and ETL processes, including failed jobs, connectivity problems, data processing issues, and performance problems.
• Ongoing maintenance of existing databases: monitoring, health checks, index and statistics maintenance, integrity checks, SQL Server Agent jobs, and capacity/storage management
• Troubleshooting and resolving database incidents, outages, blocking/deadlocks, failed jobs and performance issues, including root-cause analysis
• Supporting SQL Server on Windows Server across internal networks, including service accounts, Windows/Active Directory authentication, ports and firewall rules
• Working with network and infrastructure teams to resolve firewall and connectivity issues between users, application servers and database servers
• Develop and maintain backup and recovery strategies using full, differential, and transaction log backups
• Design, implement, administer, support, and troubleshoot SQL Server High Availability and Disaster Recovery (HA/DR) solutions
• Implement and support SQL Server Always On Availability Groups (AOAG) and Windows Server Failover Clustering (WSFC)
• Support multi-node and multi-datacenter Availability Group architectures, including synchronous and asynchronous commit modes
• Understand and support WSFC quorum configurations, including File Share Witness and Cloud Witness
• Support and troubleshoot log shipping and other SQL Server disaster recovery technologies where applicable
• Conduct periodic DR exercises, failover testing, and failback testing to validate database recoverability and operational readiness
• Develop, test, maintain, and improve detailed HA/DR procedures and disaster recovery runbooks
• Understand business requirements for Recovery Point Objective (RPO) and Recovery Time Objective (RTO) and ensure database recovery strategies support those requirements
• Scripting with PowerShell, T-SQL and batch to automate and maintain databases and applications on servers (maintenance, deployments, monitoring and alerts)
• Supporting application releases, including database changes, deployment and post-release checks
• Documenting database designs, configurations, support procedures and runbooks
• Working closely with application, development and testing teams on defect triage and fixes

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.