[13890MSCRMCV] urgent REQ || Technical Architect || Raleigh, NC || FTE

Please share a profile on :

KAPIL@TRESOURCEINC.COM

Hope you are doing great !!!

Let me know if you have any consultant  

If yes then please provide me his/her availability, most updated resume in  MS word, contact details, visa status, Skype ID and reference(if any)

And please go through the requirement below :

 

Role: Technical Architect - SQL DBA

Location: Raleigh, NC

Start Date: ASAP

Duration: Full Time 

Client :  IGATE

Job Description :

Design, develop and maintain databases in MS SQL Server 2000, 2005 2008, 2008R2 & 2012 Databases. • Provide consultation on SQL Server Database issues to the development teams • Configure, manage and administer the log shipping between production and DR servers • Configure, manage and administer the database mirroring between production and DR servers • Manage and administer Windows Cluster SQL server Instances on cluster nodes • Work and Implement Linked Server concepts of MS SQL server for execution of Distributed transactions and remote stored procedures using heterogeneous data sources • Work on BCP and Bulk Insert operations for data uploading module and Create DTS / SSIS packages as for data transfer & transform across locations and multiple data source as per requirement • Tune stored procedures and distributed queries • Create Login's, Users, and permissions and managed Security issues of the Server and Databases according to Security Policies defined by the company • Manage and administer backups using built-in / 3rd party tools (SQL Litespeed) • Performance tuning and monitoring using different built-in and 3rd party tools • Effective Communication to be made through conference calls and emails with different teams • Provide lessons learned and knowledge transfer to Offshore team • Perform complex problem solving, determination and resolution of database related issues, understanding of multi-tiered application technology • Create jobs to automate repetitive tasks • Testing –unit testing & integration testing • Responsible for overseeing the quality procedure related to the project • Work closely with application development & Test teams when any issue in production environment and provide assistance in resolving and tracking issues with production applications • Provide input to management team that help to streamline and improve consistency in service levels • Ability to be highly self-directed when required and work closely within a team • Work on 24x7 on-call pager rotation • Manage the Service Request on shifts and solve the issues • Involve in setting up Database standards • Transaction logs management (filling up, adequacy, planning for growth) • Troubleshooting connectivity issues • Capacity Planning (estimate growth of Transactional Logs, Database Storage) • Scheduled the tasks for automation • Configure SQL / DB MAIL for sending server / database alerts • Involve in migration / Upgrade project within different versions of SQL Servers.

 

I would appreciate a prompt response….

Thanks & Regards.?

|| Kapil Bansal | Technical Recruiter ||

Technology Resource Group Inc. 
3736 Hillsdale Court Santa Clara, CA 95051

Office: 408-709-1760 Ext : 837

Gtalk : kapil.trg2  Yahoo: kapil.trg21 | Fax: 408-884-2409

kapil@tresourceinc.com |  www.tresourceinc.com

P Go Green! Print this email only when necessary. 

--
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at http://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.