Job Description :
VDart We are a Global Information Technology Services & Workforce Solutions firm headquartered out of Atlanta, GA with presence in US, Canada, MX, UK, Belgium, Japan & India. Founded in 2007, Our team of over 2550+ professionals continually create impact for our customers worldwide in solving complex technology challenges with cutting edge technologies. We specialize in providing the Fortune 1000 companies, niche hard to find skills in technologies including Social, Mobile, Big Data Analytics, Data Sciences, Cyber Security, IoT, Cloud, Machine Learning, and Artificial Intelligence. With delivery centers in the UK, Mexico, Canada, and India, we provide global workforce solutions to our customers covering EMEA, APAC & Americas. VDart is an award-winning organization recognized by Inc 5000 Hall of Fame; Atlanta Business Chronicle*s Fastest Growing Companies; NMSDC*s National Supplier of the Year; Ernst & Young*s Regional Entrepreneur of the Year and more. Title: MS SQL Database SME Location: Los Angeles CA Duration: Long Term Job Description: Excellent Work experience in SQL Server Database Administration and Database Migration Project s. Installation and configuration of MS SQL Server 2008, 2008R2 and 2012 in Windows environment. Installation of standalone and Cluster Server. Configuring and maintaining all type of Database Backup and Recovery operation. Performing Database Maintenance Activates like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals. Regularly monitor database growth, jobs, SQL Services & Resolving space management issues like TempDB Contention, Data and log file space issues. Refreshing Database from Production to Test Environment Enrolling users, Controlling and monitoring user access to the database and maintaining System Security. Upgrading the database from lower version to higher of SQL Server. Maintain Database changes from Development, QA to production. Good Experience on Upgrading and Migration of SQL Server. Find & fixing Orphaned Users through Stored Procedures in migration. Hands-on Experience on high availability solution like Log Shipping, Database Mirroring & Transactional Replication and also experiencing in DR activities. Configuring, monitoring and troubleshooting the log shipping, Database Mirroring & Replication Having knowledge on Clustering, Always ON & Performance Tuning. Identifying and Resolving Blocking and Deadlock issues. Worked with Dynamic Management View(DMV's) and DBCC Commands Responding to alert which we receive in the form of Tickets through mail from third party monitoring tools. Closing the tickets with in the SLA time and Monitoring the SLA. Troubleshooting various problems that arise in a day-to-day work and fixing the issues Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems; Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions. Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions. Provides database support by coding utilities, responding to user questions, and resolving problems. Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations. Accomplishes information systems and organization mission by completing related results as needed. Key Words: MS SQL DBA, Cluster Server, Always ON, Performance Tuning If your skills match our requirements, Click here to Apply. Be sure to reference the job number and title in the subject line. Referral Program: Ask our recruiting team about how you can be a part of our referral program. If you refer a candidate with the desired qualifications and your candidate accepts the role, you can earn a generous referral fee. We want to hire the best talent available and are committed to building great teams and partnerships. We are Equal Employment Opportunity Employer. VDart Inc Alpharetta, GA Click here to Apply Follow us on Twitter for the hottest positions: @VDart_Jobs Follow us on Twitter: @vdartinc
             

Similar Jobs you may be interested in ..