SQL Server DBA

Emery Llp
Houston, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 112K

Job location

Houston, United States of America

Tech stack

Microsoft Windows
Microsoft Active Directory
Cloud Computing
Data Recovery
Database Design
Disaster Recovery
Log Shipping
Microsoft SQL Server
SQL Azure
Performance Tuning
Powershell
Query Optimization
SQL Databases
T-SQL
System Availability
Database Performance
Amazon Web Services (AWS)
Information Technology
SQL Server Management Studio (SSMS)
Server Operating Systems & Platforms

Job description

The DBA should have expertise in AOAG (Always On Availability Groups) and transactional replication. The person should have experience supporting a 24/7/365 application and environment., * Installation & Maintenance: Install, configure, and upgrade SQL Server instances and related tools like SQL Server Management Studio (SSMS).

  • Performance Tuning: Monitor system health and optimize database performance through index management, query tuning, and addressing CPU or I/O bottlenecks.
  • Security Management: Implement role-based security, manage user permissions, and ensure data encryption at rest and in transit.
  • Backup & Recovery: Develop and test comprehensive backup and disaster recovery strategies, including Always On Availability Groups and Log Shipping.
  • Automation: Author and maintain scripts (T-SQL, PowerShell) to automate repetitive maintenance tasks and regular health checks.
  • Support & Collaboration: Provide 24/7 on-call support for critical outages and collaborate with developers on schema refinement and database design.

Requirements

Do you have experience in Windows?, Do you have a Bachelor's degree?, SQL Server Database Administrator (DBA) responsible for the installation, configuration, security, and performance of critical Microsoft SQL Server environments. This role ensures that data is consistently available, secure from unauthorized access, and optimized for high performance. Should have experience working in a large complex SQL environment., * Education: Bachelor's degree in Computer Science, IT, or a related field.

  • Technical Expertise:
  • Strong proficiency in T-SQL and database administration tools.
  • Hands-on experience with High Availability (HA) and Disaster Recovery (DR) options.
  • Familiarity with Windows Server environments and Active Directory.
  • Knowledge of cloud platforms like Azure SQL or AWS RDS is highly preferred.

Pay: $54.00 per hour

Education:

  • Bachelor's (Preferred)

Experience:

  • SQL Server Database Administrator : 8 years (Required)
  • AOAG (Always On Availability Groups) : 3 years (Required)
  • Azure SQL : 3 years (Required)

Apply for this position