SQL DBA

for OakTree Software, Inc. in Oklahoma City, OK

Report
Skills:
SQL Server, SSIS, SDLC, OLAP, 
Location:
Oklahoma City, OK
Area Code:
405 
Travel Req:
none 
Telecommute:
no 
Pay Rate:
Contact for Details 
Tax Term:
FULLTIME 
Length:
 
Posted:
11-24-2014 
Position ID:
190676 
Dice ID:
10101963 


A very successful company in Oklahoma City, OK is looking for a SQL DBA to join their growing team! This is a direct-hire, full-time position with amazing benefits and excellent compensation!

BASIC PURPOSE : This individual will be part of the database administration team. DBA team is responsible for performance tuning, backups, integration, ETL, database configuration, SQL server installation, database monitoring, troubleshooting database issues/timeouts, database modeling, SSIS packages, and completing tasks as assigned for the projects. 

MAJOR RESPONSIBILITIES: 
• Works with other team members collaboratively in understanding and resolving database issues including database performance problems 
• Installation of SQL Server (2000/2005/2008/2008 R2/2012) including Active-Active/Active-Passive clustering, AlwaysON configuration, Pre/post 
Configuration (OLAP vs. OLTP vs. Data Warehouse vs. Reporting), Physical files & filegroups configurations 
• Complete project tasks as assigned on time 
• Follow established processes for change control/SDLC 
• Provide on call support as needed to support operations of critical databases. We are 24 X 7 environment. 
• Able to understand and troubleshoot complex business logic in stored procedures, identify problems and provide solution 
• Works with other senior DBA members of the team and the server group to provide operational support and triage 
• Works with break-fix team to resolve production issues logged in Footprint/TFS 
• Proactively monitors the databases (performance, backups, security, database file sizes etc.) 
• Identify poorly performing queries, stored procedures, views etc., as well as take steps to improve performance this includes index design and 
maintenance 
• Other duties assigned as needed 
EDUCATION AND EXPERIENCE: 

Minimum Required Education: 

•    High school diploma
Minimum Required experience: 

•    Minimum of 3 years of database development and operational support in large scale SQL Server environment

SKILLS AND PHYSICAL DEMANDS: 

•    Strong understanding of the SDLC.
•    Strong proficiency in processing/transforming large XML files (XSLT, XSD etc.)
•    Strong SQL Server database operations background with Windows Server experience (DMVs, Profiler, Perfmon, DBCC etc.)
•    Strong proficiency in query optimization including Logical query processing, Resource (Disk/IO/Processor) utilization analysis, Retrieval and dissection of query execution plans
•    Prior experience with high availability (Clustering Vs. Mirroring Vs. Log Shipping Vs. Replications Vs AlwaysON) and disaster recovery (backup and recovery strategies)
•    Prior experience with SQL security and SQL auditing
•    SSAS skills is a plus
•    Experience with creating / consuming web services is a plus
•    Data modeling experience is a plus
•    Certifications related to Microsoft SQL Server is a plus

Typical physical demands: 

•    Requires prolonged sitting, some bending and stooping
•    Occasional lifting up to 25 pounds
•    Manual dexterity sufficient to operate a computer keyboard and calculator
•    Requires normal range of hearing and vision

OakTree Software, Inc.