Database Administrator

eNcloud; Katy (TX); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Encloud Services LLC in Katy, TX seeks a Database Administrator to optimize SQL Server performance and maintain high availability. You will build and troubleshoot SQL Server clusters, patch servers, and manage SSIS/SSRS deployments across client locations.

The role requires a Master’s in CS or related field and 1 year of experience, with proficiency in PowerShell, T-SQL, Azure/AWS/GCP, and BI tools. Expect travel to varied client sites as needed.

Qualifications

• Master’s in Computer Science, Engineering, or related and 1 year of experience.
• Experience with SQL Server clustering and HA technologies is expected.

Responsibilities

• Tune performance for maximum resource utilization.
• Support SQL Server clusters and patching to minimize data loss.
• Create, manage, and troubleshoot SSIS packages.
• Administrate and install SQL Server Reporting Services (SSRS).
• Design, implement, and maintain high availability (Always On, Replication, Log Shipping).
• Recover databases in DR scenarios and restore master DB when needed.
• Automate tasks with PowerShell; create SMO objects with PowerShell.
• Work at unanticipated client locations.

Skills

Performance tuning

SQL Server

High availability

Cluster management

PowerShell

Education

Master’s in Computer Science or related

Tools

PowerShell

SSIS

SSRS

Azure

AWS

GCP

Tableau

Hadoop

Job description

Encloud Services LLC has multiple openings in Katy, TX: Database Administrator

Job Duties and Responsibilities

• Performance tuning for maximum resource utilization using PerfMon and PAL and PS-Diag.
• Perform Cluster Building and Troubleshooting to support SQL Server Clusters. Patch SQL Servers and resolve Patching issues to turn over servers with no Data-Loss.
• Create, Manage, troubleshoot SSIS packages.
• Manage, Administrate and Install SQL Server Reporting Services.
• Design, implement, and maintain High availability and troubleshoot High Availability options to optimum performance including Replication, Log Shipping, Mirroring and Always On technologies.
• Recover Databases from real-time DR situations by restoring Master Database.
• Perform Scripting and Automation with POWERSHELL 3.0 and 4.0. Create SMO objects with PowerShell.
• Utilize SQL SERVER AZURE database administration, C, T-SQL, PowerShell, Bash, Python, HCL, YAML, MSSQL, Azure, Azure SQL Databases, AWS, GCP SQL Profiler, Query Analyzer, Business Intelligence Development Studio (BIDS), EMC Networker, PSS-Diag, PAL, SQL-Quest, DDBoost, Redgate Compare, Solarwinds, Microsoft SQL Server Reporting Services (SSRS), Tableau, MS SQL Server Integration Services (SSIS), Hadoop, Dremio, Azure Data factory, Windows NT, Linux.
• Will work in unanticipated client locations.

Requirements: Master’s in Computer Science, Engineering, or related and 1 year of experience.

Job Category

IT