SQL Developer

Job Title: SQL Server Developer/ DBA

Location: Irving,TX

Duration: 12+ Months

Mandatory Skills:

• Experience with SQL 2008 R2, 2012 and component services like SSIS ETL, SSAS, SSRS
• Configuring SQL Server monitoring utilities to minimize false alarms
• Ensuring that new database code meets company standards for readability, reliability, and performance
• Providing developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
• Designing indexes for existing applications, choosing when to add or remove indexes
• Assisting developers with improving the performance of that query by tweaking it or modifying indexes
• Conducting SQL Server lunch-and-learn sessions for application developers
• Advising developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.)
• Being a subject matter expert on database design, performance issues, disaster recovery, backups, database maintenance and database archiving
• DR knowledge with Always On, SQL log shipping, DB mirroring, Replication
• Experienced with SQL installation on standalone and cluster servers
• Assess and tune Data base/SQL performance
• Database migration from ADABASE, DB2 and Access
• Creating Packages, cleansing Data and ETL development process
• Content Manage In addition, the candidate must demonstrate ability to write T-SQL queries to fulfill ad-hoc requests and data integrity checking and have demonstrated ability to write T-SQL stored procedures for code re-use. The candidate must also have experience with DTS / integration service data transformation and manipulation tools.

Desirable Skills:

• Business Objects
• Crystal Reports
• LDAP
• Java Media Framework
• OLE Programming with J-Integra
• HP Quality Center

Job Type: Contract

Education:

• High school or equivalent

Location:

• Irving, TX