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 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.
Confirm your E-mail: Send Email