SQL Database Administration

Orlando, Florida

Post Date: 09/21/2017 Job ID: 25303 Industry: Other Area(s)

SQL Database Administrator

The DBA will help to run scripts against the SQL database and perform data conversion from exiting ticket information to newer ticketing system.

 

Specific Skills & Abilities:

1.            Knowledge of T-SQL (required)

a.            Merge statements

b.            CTE’ s

c.            Stored procedures & functions

d.            Building views

e.            Query optimization

f.            Indexes

g.            Transactional Queries

h.            Using T-SQL to create on demand ad-hoc reports.

2.            SSRS Experience

a.            Experience creating SSRS reports

b.            Report Model experience is a plus

3.            Experience administering SQL 2008 – SQL2012 SQL instances

a.            Performance monitoring and optimization

b.            Setting up new SQL instances and databases

c.            Definitely a plus if they’ ve worked on SQL instances in a clustered environment.

4.            Experience working requests through a Change Management System

a.            Moving requests from Dev to UAT to PROD.

5.            Experience with SQL Server Analysis Services is a plus

a.            Building cubes

b.            Staging data for use in Analysis Services

6.            Experience building and modifying SSIS packages

7.            Experience with database mirroring and transactional replication

 

Education Requirements:

Bachelor’ s degree required
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: