Job ID :
15421
Company :
Internal Postings
Location :
Raleigh, NC
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
26 Aug 2018
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