Job Description :
Job Title: Sr SQL DBA More on SQL Server 2012 = MUST and Above
Location: Dallas -TX.
Duration: Contract to Hire – C2H

This is a senior level role, the core function is a production DBA, but will also be asked to develop, they can develop as much as they want, as well as participate in code review for the developers. Must be willing to work on releases and be very hands on.

The Database Administrator-Senior is responsible for the definition, creation and maintenance of the enterprise data model within the distributed computing environments (e.g., Windows, Intranet, Web Analyzes, tests and implements physical database design supporting various business applications including base definition structure, documentation, long-range requirements and operational guidelines. Ensures data recovery maintenance, data integrity and space requirements for physical databases are met through formulations and monitoring of policies, procedures and standards related to database management. Above all, ensures solutions meet business objectives and establishes and maintains a high level of user and trust and confidence in IT’s knowledge of and concern for users’ business needs. When not performing production DBA duties this person will also assist with development as needed. Willingness to work with customers of varying levels of technical expertise in a high pressure, complex environment.
Resolve problems and answer questions related to the RDBMS and its associative platform environment interdependencies and case management with vendor support when necessary.
Monitor and Performance Tune Database; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
Maintain database backup and recovery environment; Respond quickly to refresh data; verify implementation of correct backup strategy; develop recover procedures; support recovery from loss of data caused by user of system error.
Configure Update and Monitor Replication between database servers.
Install and upgrade RDBMS and related products; Keep RDMBS at current release and patch levels; install supporting products; provide current, stable production and development environments.
Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defrag database table spaces, tables, and indexes; provide application development staff optimal development environment with current data.
Provide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff; standardize environment and improve efficiency.
Plan capacity and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim dead space; optimize space allocation and avoid disk space starvation conditions.
Provide the appropriate tools, procedures, and facilities for creating and maintaining the entity data enterprise model.
Produce: database normalization schemas, logical to physical database mapping and data table parameters.
Manage the implementation and use of the enterprise data dictionary.
Develop rules, procedures and standards for the access and maintenance of shared data resources.
Review overall the physical database structures for data integrity, performance quality, recoverability, maintenance and space requirement considerations.
Participate in the evaluation and recommendation of DBA tools and new DMBS technologies.
Perform change management, impact analysis, research products, configure software, and establish standards and procedures that support the Company’s database environment needs.
Administer application-oriented databases and technical support for the various development, training, testing, and production requirements of relational database environments.
Assist in the definition and development of database documentation and standards.
Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance.
Position Requirements:
Self-Motivated with ability to prioritize and succeed with varying degrees of requirements
6 Yrs Sold SQL DBA and 10+ Years Overall IT Experience-
SQL Server 2008R2 and Above Experience( Client need SQL Server 2012 MUST )
Production DBA Experience and Troubleshooting
Development DBA Support Experience
Database Modeling Experience
Database Security
Performance Tuning – Statistics, Indexing Strategy and Maintenance
Database Backup and Recovery Experience
Replication Experience
Thorough Knowledge of T-SQL Development
SQL Server Reporting Services Management and Implementation Experience
SSIS Development and Troubleshooting Experience
Excellent Oral and Written Communication
Excellent Problem Solving Skills
Desired Skills
Windows, Network, & I/O Monitoring and Troubleshooting for Database Servers
Technical Architecture Experience (i.e. Determine CPU, Memory, Network and I/O requirements for application and database servers
Sox Reporting Experience
Informatica Cloud (ICS) Development Experience
Windows PowerShell