SQL Server Database Specialist

SQL Server Database Specialist

SQL Server Database Specialist

Location:

Webster, New York
Category:

Database Administrator
Type:

Contract
Posted:

1/16/2012
Apply Now
Back to Job Listings

Modis has joined forces with Ajilon Consulting's leading IT staffing division to create an IT recruitment powerhouse! Modis has become one of the world's largest providers of information technology services and solutions by creating a culture where people and details are never averaged into a process. Our growth record and industry leadership is a result of our unique culture of treating every challenge as unique and delivering a solution that is perfectly suited. We listen. We innovate. We're accountable!

SQL Server Database Analyst / Administrator will service the critical information needs across the organization. In this highly visible position, you will work closely with application developers and receive exposure to senior management as you work with various team members from different departments across the organization. In order to succeed, you will need to be comfortable juggling several projects at once and handle the occasional quick turnaround. You will assist in analytics, as well as building and tuning queries. Specifically, you will be central in helping to drive our database technology roadmaps for the business.
Responsibilities
. Work with the product management and engineering teams to design the databases for our next generation solutions
. Analyze performance and query optimization for database tuning to ensure that our applications maintain a high level of performance
. Produces solutions that ensure high availability and preserve data integrity
. Responsible for participating in initiatives to analyze and improve data quality
. Assist developers by providing need information, data, and education
. Support Development with SQL backups along with manage and monitor SQL backups a crossed multiple environments
Required Skills on SQL Server Versions 2000, 2005, 2008
. Create complex analytic queries on large data sets
. Create stored procedures, triggers, and functions
. Analyze trends in key metrics
. Generate code to extract, transform and load data from production data sources to the data warehouse
. Performance tuning of key queries.
. Database architecture design and planning with a high degree of documentation
. Database architecture installation, configuration including best practices
. Operational best practices and expertise on Database Maintenance plans for index management, database statistics, consistency checks and housekeeping tasks.
SQL Server database architecture performance monitoring and tuning
. Experience with the design and configuration of High Availability and Disaster Recovery features including Log Shipping, Database Mirroring and SQL Clustering
. Database Backup and Recovery solutions including SQL Server native backups, Red-Gate and SAN based backups.
. Experience with data propagation design and configuration including SQL Server replication.
. SQL Server Monitoring tools implementation and support
. Custom replication setup using SSIS applied to reporting and warehouse ETL usage
. Excellent verbal and written communication skills required with the ability to present findings and recommendations.
. Knowledge of server and storage hardware configurations including typical server specifications and storage planning for SQL Server.
. Experience with T-SQL code optimization and SQL Server performance trouble-shooting, with expert knowledge of Perfmon and SQL Profiler.
Skills:
* DBA - MS-SQL Server
Apply Below!
Contact Information:
Note: All fields are required
s
First Name:Last Name:

E-mail:
City:State:-- Select State --AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyomingDaytime Phone:

Preferred Location:Alberta - Modis CalgaryAlberta - Modis EdmontonArizona - Modis PhoenixBritish Columbia - Modis VancouverCalifornia - Modis BurbankCalifornia - Modis El SegundoCalifornia - Modis Foster CityCalifornia - Modis SacramentoCalifornia - Modis San DiegoCalifornia - Modis San FranciscoCalifornia - Modis San JoseCalifornia - Modis Walnut CreekColorado - Modis Colorado SpringsColorado - Modis DenverConnecticut - Modis HartfordDelaware - Modis DelawareFlorida - Modis Ft. LauderdaleFlorida - Modis JacksonvilleFlorida - Modis TallahasseeFlorida - Modis OrlandoFlorida - Modis TampaGeorgia - Modis AtlantaIllinois - Modis Oakbrook TerraceIllinois - Modis ChicagoIowa - Modis Cedar RapidsIowa - Modis Des MoinesKansas - Modis Kansas CityKentucky - Modis LouisvilleMaryland - Modis BaltimoreMaryland - Modis LaurelMaryland - Modis DC, MDMassachusetts - Modis BostonMassachusetts - Modis Government Services Group - BostonMichigan - Modis DetroitMichigan - Modis DetroitMinnesota - Modis BloomingtonMinnesota - Modis MinneapolisMissouri - Modis St. LouisNebraska - Modis OmahaNew Jersey - Modis PiscatawayNew York - Modis AlbanyNew York - Modis New YorkNew York - Modis RochesterNew York - Modis SyracuseNorth Carolina - Modis CharlotteNorth Carolina - Modis RaleighNorth Carolina - Modis CaryNova Scotia - Modis HalifaxOhio - Modis CincinnatiOhio - Modis ClevelandOhio - Modis ColumbusOntario - Modis OttawaOntario - Modis TorontoOregon - Modis PortlandPennsylvania - Modis HarrisburgPennsylvania - Modis MediaPennsylvania - Modis PhiladelphiaPennsylvania - Pittsburgh-Modis Solutions NEPQuebec - Modis MontrealSaskatchewan - Modis ReginaSouth Carolina - Modis ColumbiaTennessee - Modis ChattanoogaTennessee - Modis KnoxvilleTennessee - Modis NashvilleTexas - Modis AustinTexas - Modis DallasTexas - Modis Fort WorthTexas - Modis HoustonTexas - Modis HoustonTexas - Modis San AntonioVirginia - Modis McLeanVirginia - Modis RichmondVirginia - Modis ViennaWashington - Wasser StudiosWashington - Modis SeattleWisconsin - Modis Milwaukee
How did you hear about us?


I was referred by a friend
At a college job fair
At a general job fair
Link from another website
Internet Search
Other
Resume:
Option 1:Upload a Resume
We accept .doc, docx, .html, .htm, .txt, .rtf, .wps, .wpd, .pdf

Option 2:Enter Below
Questions or Comments:






Search Jobs



-- Select Job Category --Software/Web DeveloperProject ManagerAnalystData WarehouseQuality AssuranceSystem AdministratorDatabase AdministratorWeb Server AdministratorMiddleware/EAI/EDIContent/Document ManagementERPTechnical/Desktop SupportNetwork/TelecomCall CenterIT ManagementeCommerceDatbase DevelopmentProject AdministratorOther
Choose location and/or zip code:
-- Select State --AlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyoming



- Select Range -within 5 mileswithin 15 mileswithin 25 mileswithin 50 miles




Modis Locations:
- Select a location -PhoenixManhattan BeachGlendaleSan DiegoSan FranciscoSan JoseWalnut CreekDenverHartfordWashingtonFt. LauderdaleJacksonvilleOrlandoTampaAtlantaChicagoCedar RapidsDes MoinesKansas CityLouisvilleBalimore - LaurelWashington, tonDetroitBloomingtonMinneapolisSt. LouisOmahaPiscatawayNew YorkRochesterSyracuseRaleighCharlotteCincinnatiClevelandColumbusHarrisburgMedia/Delaware ValleyPittsburghPhiladelphiaColumbiaChattanoogaAustinDallasFort WorthHoustonSan AntonioTysons CornerRichmondSeattleMilwaukee
Share: