SQL Server DBA

SQL Server DBAIntegrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.Job DescriptionPosition: SQL Server DBADuration: 1 YearLocation: TX-500 W Dove Rd-Southlake (TX0549)Direct Client: Immediate interviewJob ResponsibilitiesPlanning, building, implementing, administering, and maintaining SQL SERVER databases in the Commercial Data Systems (CDS) organization. Builds and successfully integrates complex, multi-Terabyte OLTP databases with minimal supervision. Ensures optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring. Troubleshoots issues to resolution.Maintains database security and enterprise policy guidelines according to best practices. Recommends new and improved guidelines to ensure high availability and stabilityWorks directly with internal customers to plan, evaluate, and design network databases in accordance with team and company standards. Conducts benchmark tests to gauge hardware capacity and meet application capacity requirements. Documents business and technical requirements. Creates technically viable, cost-effective system designs and develops customer-focused implementation strategies. Mentors other DBAs in the group.Provides tasks and timelines to support the creation of project plans with appropriate updates for those tasks throughout the project lifecycle.Performs On-Call duties as assigned on a rotational basis. Occasional overnight travel to other company work locations as required.QualificationsMinimum Bachelor's degree in Computer Science, Electrical Engineering or other related degree, relevant military experience.Sql Server DBA with 5+ years of SQL Expertise in SQLServer release 2008. At least 5 years of sql server DBA experience in an enterprise environment supporting all aspects of a sql server Database Server with emphasis on 2-tiered and 3-tiered architecture.Experience in newer SQL Server releases/high availability solutions and release upgrades is strongly desired.Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers. Deep knowledge about Relational Database design and analysis; extremely proficient in SQL.A minimum of 5 years of experience is required in the following skillset:SQL Server replicationSetup bi-directional replication technologyCreate and maintain table partitionsEnsure changes are deployed without impacting replication.Design, develop and maintain SSIS packages and SSRS reportsWindows operating system and storage to be able to design high performance environmentSQL development including package/ procedure/ trigger/ XML/scripting development in a multi-user production environment.Development experience in either development environment or automation of production activities would be a plus.Golden Gate replication (SQL Server/Oracle) experience a plus (1 Year)Must possess excellent organization skills.Must be able to prioritize and support multiple concurrent projects with inputs from multiple groups.Able to work independently with accuracy and attention to detail.Proficiency with MS Excel, Word, PowerPoint, and Access.EnvironmentMust have the ability to function in a tight knit team environment and must be willing to work Change Control Windows on a very regular basis.Must be willing to challenge yourself with regard to learning new applications as well as new Oracle components that support new platforms on fairly short timelines.Must have strong verbal and written communication skills.Must be able to work independently with accuracy and attention to detail.