SQL Server Development DBA - mid level

Innovar Group has an immediate need for a Mid and SR SQL Server Development DBA's for a valued client in Englewood, CO. The DBA's are responsible for administering SQL Servers and their databases in a software development role.

 

RESPONSIBILITIES:

· Designs logical and physical databases with data modeling tools

· Writes scripts and processes for development

· Reviews database design changes with the team to determine the impact to the physical database and other systems

· Scripts database objects to comply with current standards

· Utilizes company version control tool

· Supports Application Development staff with respect to database objects

· Supports production issues for cubes, Data Warehouse Reporting, and ETL jobs

· Manages and performs maintenance, backups and security for the development databases

· Troubleshoots database issues

· Enforces database standards

· Configures and maintain SQL Server and database settings

· Performs data migrations

· Responsible for database backup and disaster recovery

· Monitors database and SQL Server performance

· Implementation and maintenance of replication concepts

· Performs capacity planning

· Applies updates and upgrades to non-production database environments · Document as necessary

· Implements approved database technologies

· Attends product specification meetings with project team members to determine the scope and limitations of the project

· Participates with review of QA test plans

· Works closely with other team members

· Other duties as assigned

 

EDUCATION and/or EXPERIENCE: High school diploma or equivalent required. Bachelor’s degree in Computer Science or related area preferred. Minimum two- (2) years of DBA experience required.

 

KNOWLEDGE, SKILLS AND ABILITIES · Experienced in Microsoft SQL Server 2000 and 2005 in the following areas: database design; SQL Server architecture; T-SQL programming; performance tuning; stored procedure, function and trigger design and coding; index implementation and maintenance; database backup and recovery; SQL Server replication

· Understanding of n-tier application designs

· Mathematical skills including basic algebra and statistics

· The ability to extrapolate database schema to meet the business needs of the application

· Ability to perform multiple tasks concurrently

· Strong PC skills including thorough knowledge of Microsoft Office suite

· Ability to be flexible and adapt to any given situation

· Excellent customer service attitude, communication skills (written and verbal), and interpersonal skills

· Excellent organizational and time management skills

· Excellent analytical and problem-solving skills

· Ability to make timely and sound decisions

· Detail oriented

· Ability to work independently and in a team based environment

· Ability to work efficiently in a fast paced environment

· Ability to work under pressure and in high stress situations

· Ability to be self-motivated

 

CERTIFICATES, LICENSES, REGISTRATIONS

Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Systems Engineer (MCSE), Microsoft Certified Technology Specialist (MCTS), and/or Microsoft Certified IT Professional (MCITP) a plus.