Job Description :
Job Title: Senior MSSQL DBA
Raleigh, NA
"U.S. Citizens and Independent Consultant those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time."
Contract duration: 6-12 Months
Would you require the candidates to meet you for in person interview : Skype/WebEx interview is fine.
Minimum years of experience: 9+ 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