Raleigh, NC, USA
1 day ago
IT - Senior Consultant - Infrastructure Management | Business Intelligence - DB | SQL Server
Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Creating a Windows Login Creating a SQL Login Assigning Logins to Fixed Server Roles Mapping Orphaned Users and Logins Creating an Operator Creating a Job Refresh & Scrambling Activities & Mgmt Processes Interfaces & DB Links Sql server service packs deployment SQL server installation SQL server upgrade from lower to high environment DB and Application Bounce process & Mgmt Processes. Backup monitoring and issue fixes Restoring a Database Recovery Processes. New Database Creation Implementing/support of Database Mirroring Implementing/maintenance of Log Shipping Implementing/support of Always on high availability Implementation/support of Clustering Implementaion/support of Replication Performing deployments Performing Cloning Log file/Data file shrinking, resizing and modification Environment Specific Automation like Startup/Shutdown/Cache Cleaning etc Scheduled Clean up activities New Batch Script Creation Performance Tuning actvities and process followed. Capacity Planning. Bouncing services - Approval process Daily Helth Check - QA Creating a Database User Creating a Custom Database Role Configuring Database Mail Creating a Database Maintenance Plan Performing a Full Backup Performing a Differential Backup Performing a Transaction Log Backup Export/import of database

Minimum years of experience*: 9+

Interview Process (Is face to face required?) Yes

Does this position require Visa independent candidates only? No

Confirm your E-mail: Send Email