SQL Server Database Administrator

SQL Server Database Administrator-89994

Description

On-Call rotation; Including Holidays and Weekends.

Summary

Provides SQL Server-based expertise in support of Production TSYS Back End databases. Ensures high availability, optimal performance and advanced planning of future growth trends as they relate to ensuring client application uptime. Participates in on-call rotation and is heavily engaged with architectural and performance tuning discussions and projects with major stakeholders within the organization. Works with other DBA team members to ensure cross-training throughout the breadth of SQL technologies and performs within the confines of formalized change control processes.

Responsibilities Include:

Responsible for ensuring availability and performance of the databases that support the system
Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning
To proactively monitor the database systems to ensure secure services with minimum downtime (SQL Server 2005/2008)
Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management
Responsible for troubleshooting and problem solving of SQL development
Responsible for improvement and maintenance of the databases to include rollout and upgrades
Responsible for implementation and release of database changes according to agreed timescales and costs

Required Job Skills:
Experience with SQL Server 2005 and/or SQL 2008/R2
Experience in Large Volume Database (Minimum 1 TB)
Experience with high availability solutions, database mirroring, performance tuning
Working knowledge and experience using SQL Profiler, Netmon and other 3rd party monitoring tools
Working knowledge and experience with disk layouts and architectural considerations
Working knowledge and experience in planning Disaster Recovery mitigation strategies
Ability to effectively multi-task in a changing environment
Solid troubleshooting skills and the ability to troubleshoot software, hardware, and networking issues
Clear written communication skills
Good understanding of security groups, OU's, and user privilege maintenance

Highly Desirable Job Skills:
Experience with Server 2012
SQL Server Auditing planning, implementation and support
SQL Server Reporting Services (SSRS) implementation and administration
SQL Server Integration Services (SSIS) package design and execution
Active Directory experience in a multi-domain, multi-forest environment
Prior experience with distributed application implementation and Prod/Staging/Test environment deployments.
Prior experience with load-balanced/scale-out deployments on VM-based ESX hosts
Ability to originate or edit scripts (PowerShell, TSQL

Qualifications

Education/Experience

Four year college degree and 4 or more years professional experience or 6 or more years professional experience. Appropriate TSYS experience is preferred.

Behaviors

Teamwork

Cooperates in a team environment

Demonstrates initiative

Understands the importance of quality customer service

Develops job knowledge

Treats others with respect

Takes responsibility for his/her actions

Manages and resolves conflict

Embraces diversity

Supports the development of DBA I, DBA II

Adaptability

Portrays a positive attitude

Flexible; adjusts to change

Ability to follow direction

Accepts supervision/guidance

Complies with Company standards/policies/procedures

Displays professionalism in both conduct and dress

Performs well in critical situations

Consistently meets customer expectations

Communications

Effective verbal/oral written communication

Provides timely updates on projects to management

Asks for help/seeks advice

Listens well/utilizes information

Shares ideas and information

Develops rapport with customers

Develops correspondence skills

Participates in Right Steps process

Attends required meetings as specified in TM-M

Attends team, department, division meetings

Skills and Competencies

Ability to think logically

Good technical skills (ie industry products, testing, etc )

Develop extensive knowledge of TSYS

Excellent customer service skills

DBS (DB2 related vendor products, QMF, File-aid DB2, SQL, Image Copy, Reorg, Unload/Reload, Recovery, Log Analyzer, Omegamon Monitor)

IMS (DBDGEN, PSBGEN, ACBGEN, IDCAMS, DL/I, File-aid IMS, Image Copy, Reorg, DBRC, Unload/Reload, Gast Path Analysis, DSI, Log Analyzer, Recovery Change Accum, )

Develops coplex test plans and completes required testing for assigned projects

Oracle

Associated relational database competencies
Organization:
Attends to detail

Manages time and priorities productively

Accurately estimates time required to complete a task

Conducts meetings effectively

Manages multiple tasks effectively

Accepts responsibility

Creates and maintains accurate documentation

Develops and follow project plans

Meets deadlines

Working Conditions

Irregular

Use of a pager when on call

Decision Making

Participates in the decision-making process and acts quickly to carry out decisions

Demonstrates effective problem solving skills

Practices confidentiality

Follows through with tasks assigned

Recognizes problems/issues and brings to management's attention

Recognizes risk associated with decisions

Recognizes level at which decisions must be made

Identifies ways to improve the process

Job: Technical Support
Primary Location: US-Colorado-Golden
Organization: Total System Services, Inc.
Schedule: Full-time
Job Posting:
Unposting Date:
Recruiter: Stephanie Danielle Johnson