Immediate Need - SQL Server DBA Need Local candidate Send resumes To - nav...@aureustechsystems.com
Job Title: SQL Server DBA Location: Beaverton, OR Duration: 4 months ? Must have SQL 2008 R2 Experience o Manage SQL R2 maintenance plan o Oversee system performance and tuning including compacting database regularly o Monitor backup jobs; test to ensure working correctly; define and test recovery process o Facilitate recovery of the database by BSD-IT staff and the software vendor, Horizon, in the event of a database crash. o Monitor server logs, disks, services, memory, scheduled tasks. Make recommendations for improvement, if necessary. o Ensure SQL server is set-up to best practice standards as defined by software vendor (Horizon), or to optimal standards based on need. o Troubleshoot and repair Microsoft failure of SQL 2008 R2 Scheduled Task for current vendor (FSA) electronic batch file electronic order ? Act as a liaison between BSD-IT and software vendor (Horizon) to identify and fix any gaps in Fastlane server maintenance and support. ? Analyze and manage preventative diagnostics for hardware ? Assist in creation of and facilitate any future electronic order systems with new vendors. NS Site PC's ? Oversee and manage desktop system performance and tuning for 50 sites o Identify areas causing poor performance and make recommendations for improvement 1) Explain the purpose of a maintenance plan and what you would set up in a typical maintenance plan. 2) Describe how SQL merge replication works 3) We are experiencing long delays with SQL on the client replicating to the up-stream database server. Explain what areas you would look at and how you would troubleshoot those areas. Very Truly, Naveen Kumar Senior Recruiter Aureus Tech Systems, LLC WBENC Certified Address: 17593 E Euclid Ave, Aurora, CO 80016 Desk: 201-855-5156 Office: (201) 546 3096 Email: nav...@aureustechsystems.com -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To post to this group, send email to sap-basis@googlegroups.com. To unsubscribe from this group, send email to sap-basis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-basis?hl=en.