IT JOBS: {SAP JOBS USA:119298} Urgent Need: Lead Administrator

Wednesday, 12 June 2013

{SAP JOBS USA:119298} Urgent Need: Lead Administrator - Database // Seattle, WA

Hi,

Urgent Requirement, please share your consultant profiles ASAP

Title: Lead Administrator - Database

Location: Seattle, WA

Duration: 6+ months

Job Description:

DBA SQL Server 2008

§ Installation, Administration and Maintenance of SQL Server Instances. (Installing SQL Server)

§ Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)

§ Create Users and assign permissions based on the level of database access the user would need. (Security)

§ Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)

§ Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

§ Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

§ From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

§ Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication)

§ Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

§ Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)

§ Documenting major changes to the SQL Servers. (General)

§ Apply Service Packs. (General)