SQL DBA- con-5 months Cary,NC *Job Description :* Description: 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, 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 prov
-- *Thanks & Regards* *Ishant Bawa* *IT Recruiter* *HMG America LLC* *:**7326451989* *E : **i <vishal.sha...@hmgamerica.com>shant.hmgamer...@gmail.com <shant.hmgamer...@gmail.com>* *W: **www.hmgamerica.com <http://www.google.com/url?q=http%3A%2F%2Fwww.hmgamerica.com&sa=D&sntz=1&usg=AFQjCNF42xF1LAsW8PGbBgid9tQ5MPzSYw>* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To post to this group, send email to corptocorp@googlegroups.com. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
