Database Administrator

USM; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology services company in Austin, Texas, is seeking a Database Administrator with at least 5 years of experience in managing Microsoft SQL Server. The role includes responsibilities such as optimizing databases, implementing complex ETL processes, and troubleshooting issues. Candidates should have a strong background in SSIS, SSRS, and experience with database security and performance tuning. This is a great opportunity for those looking to advance their career in a dynamic environment.

Qualifications

• Minimum 5+ years of professional Database Administration experience.
• Experience in operational environments with Microsoft SQL Server.
• Must have experience using SSIS for data warehousing tasks.

Responsibilities

• Administer and optimize SQL Server databases.
• Implement complex data loading processes using SSIS.
• Troubleshoot and resolve database issues effectively.

Skills

Microsoft SQL Server

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

SQL Server Reporting Services (SSRS)

T-SQL Queries

Data Modeling (Erwin, ERStudio)

PowerShell Scripting

Tools

SQL Server 2012

Apache Subversion (SVN)

Job description

Job Description

• Minimum 5+ years of professional Database Administration experience in an operational environment particularly with Microsoft SQL Server or 2 years SQL Server and 3 or more years using a different DBMS.

• Minimum 8+ years extensive experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server programming
• Skills and Tools required for Microsoft SQL Server 2012
• Programmability & Development Tools - T-SQL Queries (DML, DDL, TCL), SQL Data Tools
• Security - User, Roles, Auditing
• High Availability - Database Backup & Restore, Log Shipping
• Scalability and Performance - Indexing, Partitioning
• RDBMS Manageability - PowerShell Scripting, Performance Report, Index Maintenance
• Data Modeling - Erwin (CA) and/or ERStudio (Embarcadero)
• Apache Subversion (SVN) - Versioning and Revision Control System
• Experience in troubleshooting and resolving database problems
• Experience using SSIS to implement complex normalization and transformation logic to load data into a data warehouse from disparate data sources.

Additional Information

If you are interested in above position, please share your updated resume to mohammedm(at)usmsystems(dot)com or can directly call me on 703-880-2641.