Job ID :
13474
Company :
Internal Postings
Location :
ROANOKE, VA
Type :
Contract
Duration :
6 months
Salary :
open
Status :
Active
Openings :
1
Posted :
11 Jun 2018
Job Seekers, Please send resumes to resumes@hireitpeople.com
Minimum years of experience:10 +years

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.