SQL DBA with NetApp

Job Title: SQL DBA with NetApp
Job Code: TJ_7475
Company Name: In-Time Infotech, Inc.
Job Location: Pittsburgh,Pennsylvania
Zip Code: 15201
Job Category/Title: SQL DBA with NetApp
Employment Category: Contract - Corp-to-Corp,Contract - Independent,Contract - W2
Travel Required: No
Interview Type: In-person
Required IT Skills:
Job Description: Roles & Responsibilities:

•Job Description:
• Senior MS SQL Server DBA with 6+ years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2014/2012/2008/R2/2005/2000/7.0 in Production, Testing and Development Environment’s.
• Experience in Data Migration from MS SQL server 2000/2005 to 2005/2008/R2/2012.
• Experience administering Oracle 10G environment
• Sound experience in Visual Studio 2010, with writing application in ASP.NET, C# and MS Access
• Extensive Monitoring of SQL Server with DMVs and Third Party Tools like IDERA, FOGLIGHT, QUEST
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like VERITAS NetBackup, Red Gate, TSM and LITESPEED.
• Expert skills in VMware and Virtual environments
• Expert skills in setting up CLONE process using RM (replication manager), SQL job and PowerShell scripts.
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities and Linked Servers.
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Experience in using different tools like DELPHIX to manage virtual database, APEX SQL for auditing and monitoring, BMC for multiple installation and patches at once, Attunity for replication, Netezza for data warehouse and reporting purpose.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive and Active/Active environments.
• Experience in developing and supporting all stages of systems life cycle including Analysis, Development, Testing, Implementation and Product Support using T-SQL, PL/SQL on Unix and Windows environment
• Moderate experience with T-SQL in developing Database Objects, Triggers, stored procedures, Functions.
• Developed Oracle based (SQL and PL/SQL) programs for the creation of ad hoc queries/reports, including requirements gathering, design, coding and unit testing.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming and Query Level Performance tuning
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, Triggers, Packages, Stored procedures, roles and granting privileges
• Tuning of SQL statements using EXPLAIN PLAN, TKPROF, Oracle Hints to improve the performance
• Proficient in Oracle tools such as TOAD and SQL Navigator.
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import /Export.
• Excellent communication skills and ability to develop solutions for client needs using agile methodologies.
• Good Team Player, Strong Interpersonal and Communication Skills combined with self-motivation, initiative and the ability to think outside the box.
Duration: 3M
No. of Posts: 1
Job Expiry Date: October 22,2016
Telecommute: No