Sign in

SQL DBA

Company:
iteaminc
Location:
New York City, New York, United States
Posted:
December 03, 2018

Description:

Greetings from iTeam Inc!

iTeam Inc., Founded in 2006, is a technology based service provider that provides Complete technology business solutions and I.T. staffing services across The States. We Are an E-Verified company headquartered in Dallas, TX. We specialize in connecting Great companies with quality talent, In-addition to State and Fed Agencies. We provide services to companies like Qualcomm, Broadcom, Samsung, Texas Instruments, GM, Verizon, Lenovo and many more.

We are looking to get W2 consultants onboard for the requirement mentioned below.

Job Description

Job Title: SQL Server DBA

Job Location: New York City, NY

Duration: Long term contract

Employment Type: W2 Only, NO Corp to Corp

Requirement details:

3 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Experience in using DMV and dynamic management functions for finding out long running queries.

Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log Shipping and Database Mirroring.

Worked on configuring SQL Server with minimum privileged access.

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

Having Experience on Data center servers and handling 1.4 TB databases.

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Technical Education

Bachelors in Electronics and Communication Engineering, University of Madras, India

Masters in Computers and Information Systems Universty of Illinois, springfield(US)

Technical Expertise

Databases: MS SQL Server 2012, 2008, MS SQL Server 2005

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: database administration of MS SQL Server 2012,2008, 2005

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL LiteSpeed, Visio

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Eligible Work Authorization:

ü H1B Transfers

ü GC

ü EAD

ü USC

Benefits We Provide:

• GC Process (If needed)

• Excellent Salary

• Local Projects and long term projects (location preference for USC, Green

Card Holders and H4 EADs only)

• For GC’s and USC – very long term projects with State and Fed Agencies

• Other Standard Benefits

In interested to apply for any requirements from the above mentioned list, please

Send your updated resume.

Also feel free to call me anytime for any further query/assistance.

Thanks & Regards,

Sudheer Nagaradona IT recruiter

iTeam Inc.

■ Direct 469.828.9124

■ Address: 4101 McEwen Rd, STE 120

Farmers Branch, TX 75244