SQL Server Database Administrator (Radford, VA)
Location: Radford Virginia
Description: AppLabs is employing SQL Server Database Administrator (Radford, VA) right now, this occupation will be placed in Virginia. More details about this occupation opportunity kindly see the descriptions. This position is for a MS SQL database administrator. The successful candidate will maintain SQL database environments in an enterprise environment consisting of approximatel! y 650 Windows servers. This position will be responsible for development and sustainment of SQL 2008 clusters and migration of various disparate SQL environments onto new clusters. The successful candidate will also standardize, consolidate, and optimize the existing SQL environments. They will monitor and maintain database performance. Adhere to ITIL (Information Technology Infrastructure Library) practices for Change Management. Collaborate with internal and external customers to gather requirements for special processing. Work and track issues to resolution using the BMC Remedy ticket system.
Essential Job Functions
Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files. Develops complex data retrieval queries and optimizes data queries within programs for performance and maintainability. Determines data to collect and analyzes information a! s appropriate.
Analyzes and determines informational ! needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for complex databases. Recommends and implements course of action based on analyses.
Defines logical attributes and inter-relationships and designs complex data structures to accommodate database production, storage, maintenance and accessibility to enhance performance.
Tests designed applications utilizing database management software and/or general programming software to enhance performance. Determines test's) to use and collects appropriate data as has been established.
Installs, implements and supports complex systems within user base; creates and updates database installation instructions and design changes for client use.
Monitors and coordinates installation and upgrades of hardware and software as necessary to enhance database performance. Researches various hardware and soft! ware products; recommends solution and implements approved products.
Provides work guidance and leadership to less experienced personnel. Acts as technical project leader on assigned projects.
Utilizes standard corporate tools to record change and problem activities for tracking purposes.
Responsible for design, installation, configuration, security and maintenance of highly available enterprise database systems.
Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios.
Establish and maintain database policies and standards.
Troubleshoot performance problems and propose short term fixes and long term solutions.
Generate database schema definitions and modifications as required.
Refresh data from one environment to another at the request of the application development staff.
Follow and maintain in-house documentation for repeatable processes, including data! base feature installation, disaster recovery, and common problem resolu! tion.
Follow ITIL (Information Technology Infrastructure Library) practices for Change Management.
Qualifications
Basic Qualifications
Bachelor's degree or equivalent combination of education and experience
Bachelor's degree in computer science, management information systems, or related field preferred
Four or more years of experience in database design or maintenance
Experience working with software installation/upgrading procedures
Experience working with file and system maintenance procedures
Experience working with database creation techniques and database management systems (DBMS)
Experience working with performance modeling and benchmarking skills and relational databases
Other Qualifications
Good analytical and problem solving skills
Good programming skills for database management and general software
Good communication skills for providing d! ocumentation to support personnel, customers, and managers
Good leadership skills to guide and mentor the work of less experienced personnel
Ability to work in a team environment
Ability to anticipate problems and take decisive action
Willingness to travel
Ten or more years experience with SQL Server Enterprise Edition and all facets of database administration.
Five or more years experience with SQL Server High Availability features: failover clustering, log shipping, database mirroring.
Five or more years experience with Windows Server 2008 R2 and Microsoft Cluster Services.
Installation and configuration experience with SQL Server, SQL Server Service Packs and Cumulative Updates.
Experience with PowerShell 2.0 (or higher).
Strong documentation skills.
Strong interpersonal skills and willing to be a team player.
Participate in 7x24 on-call support rotation and expect! ed to work during mission critical situations
Working knowledg! e of DoD Security Technical Implementation Guides (STIGs), Security Readiness Review (SRR) scripts, and Information Assurance Vulnerability Management (IAVM).
Experience with SQL Server 2012.
Experience with SQL Server Reporting Services (SSRS).
Experience with SQL Server Analysis Services (SSAS).
CSC is an Equal Opportunity Employer M/F/D/V
- .
If you were eligible to this occupation, please email us your resume, with salary requirements and a resume to AppLabs.
If you interested on this occupation just click on the Apply button, you will be redirected to the official website
This occupation starts available on: Wed, 13 Nov 2013 14:59:03 GMT