*Infrastructure SQL DBA* *Pay: $50/hr *
*Location: Union, NJ* *Length: 6-12 months contract* *FACE 2 FACE* *ONLY GC, USC* *MUST HAVE:* *They want a Systems Sql Server DBA, NOT an application DBA* *Communication skills must be impeccable* *Candidate must be collaborative but able to work independently.* high-availability features such as SQL Server AlwaysOn Failover Cluster, Active/Active or Passive Failover Cluster, Database Mirroring, Replication, and Log Shipping. RESPONSIBILITIES Participate in 24x7 on-call production support rotation. Provide database support for corporate projects. Provide database design input to project teams. Provide database support for auditing, including PCI requests. Install SQL Server 2005, 2008, 2008 R2, 2012 and 2014. Execute daily system log/status checks. Perform database problem troubleshooting and query tuning. Perform analysis of database load metrics. Prepare performance reports. Prepare database capacity reports. Assist in the establishment of procedures and processes for the following: Backup/Recovery, Database Maintenance, Patch Management, Applications Support, and Job Scheduling. Support infrastructure upgrades. Support annual disaster recovery test for selected SQL Server databases. Document processes, procedures and system events. Document new database environments and/or changes to current environments. Understand corporate goals and how SQL Server DBA responsibilities support corporate goals. Attend weekly department management meetings; report on the status of assigned projects and planned changes within the Database Administration group. Interact with business units, programming staff, other technical staff, and outside vendors. QUALIFYING EXPERIENCE, EDUCATION AND WORK ETHIC 5+ years’ hands-on experience installing/configuring/troubleshooting SQL Server 2005, 2008, and 2008 R2. 3+ years’ hands-on experience installing/configuring/troubleshooting SQL Server 2012 and 2014. 3+ years’ hands-on experience installing/configuring/troubleshooting SQL Server Reporting Services and Analysis Services 3+ years’ hands-on experience installing/configuring/troubleshooting high-availability features such as SQL Server AlwaysOn Failover Cluster, Active/Active or Passive Failover Cluster, Database Mirroring, Replication, and Log Shipping. 3+years’ hands-on experience with performance tuning. 3+years’ hands-on experience with database upgrades and patching. Proficiency with interpreting DB SAN storage layouts Proficiency using these tuning tools: Idera SQL DM, Execution Plan. Working knowledge of SSIS packages, stored procedures, triggers, and functions. Working knowledge of Windows Server and networking concepts. Working knowledge of MS-Excel and MS-Project software.. Ability to translate entity relationship diagrams into physical data models. Ability to prepare and review technical documentation BS in Business or Computer Science or equivalent experience and technical certification Precise, clear oral & written communication skills Strong multi-tasking ability Ability to work effectively with people from various departments and skill sets *Thanks and Regards* *Shweta Ojha* Sr. Technical Recruiter | Sage Group Consulting *Direct: *732-784-6492 *Email: *so...@sagetl.com *Gtalk: *sojha1290*|Ymail: *ojha1290 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.