Production Database Analyst
Location:
Dallas , Texas
Posted:
July 12, 2016
Reference:
04010-149495
The Database Analyst will monitor and maintain the integrity, security, and availability of the organizations SQL Server databases in an optimal fashion. This individual will have operational responsibility for development, test, and production environments and is responsible for Change Management. One of primary responsibilities of this position is to schedule, verify, and audit the backups of the databases. In addition, the DBA will conduct performance monitoring and troubleshooting using the built-in tools and with a working understanding of execution plans. Disk space usage and growth needs to be monitored to assist with capacity planning which could involve moving databases between servers or recommending hardware upgrades. While development and data analysis is not a responsibility, strong knowledge of T-SQL in regards to creating triggers, stored procedures, functions, and scripting is important. The person applying for this position must have a high attention to detail yet be able to see the large picture to understand the impact of changes and activities across systems. This person will be operating as the sole DBA and therefore must be self-reliant, able to work independently, and able to think through and resolve issues without constant management direction, yet also be able to collaborate and work in partnership with other teams. Strong organization skills are required to document procedures and issue resolutions for backup DBA coverage. This position also has exposure to HIPAA data and therefore a track record of integrity is also necessary. Required Technical Skills At least 2 years as an operational DBA using Microsoft database technologies Experience with the installation and customization of SQL Server 2012 Experience with troubleshooting and resolving database problems Experience with database backups and restores, including knowledge of recovery models Good working knowledge of T-SQL Knowledge of SAN storage, RAID levels, and disk partitioning related to database files Experience with creating and monitoring automated maintenance jobs Knowledge of indexes and statistics including duplicate index detection and defragmentation Knowledge of transactional replication including setup and troubleshooting Basic familiarity with Integration Services and Reporting Services Required Soft Skills A four year formal education or equivalent work experience Good documentation skills Willingness to learn with the ability to pass that knowledge onto others Good communication skills to both technical and non-technical users Desire to help others Ability to self-prioritize work with minimal supervision Optional - Pluses Links to personal blog or published articles on the internet Links to online profiles at community sites such as StackExchange or SQLServerCentral Proof of membership in professional associations and certifications Active attendance in local user groups Experience with 3rd party database tools, particularly from Red Gate Basic knowledge of Microsoft PowerShell Familiarity with any .Net programming language If this role looks interesting to you, please email your contact information and resume to Cole.Pietsch@RHT.com for immediate consideration!

A little about us:
Founded in 1948, Robert Half (NYSE: RHI) is the world's first and largest specialized staffing services firm.

Know someone who would be interested in this job? Share it with your network.