SQL Server DBA/ Developer

 Job Description

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.