*Required Imm * * SURROUNDING TO OHIO
RATE MAX: 44/hr on C2C All Inclusive. Title: SQL DBA Location: Dublin, OH Duration: 3 Months* *Skills: SQL DBA, 5+ years of experience in managing MS-SQL Instances including SQL 7.0, 2000 and 2005 Instances, residing in NT 4.0, Windows 2000 & Windows 2003 environments.* * * *Major Accountabilities: Serve as interface between application and infrastructure teams and outsourcing partner. Developing requirements, managing demand and monitoring performance. Develop knowledge of specific set of databases supporting Client*s Medical Products warehouse operations. Understand and provide guidance regarding database administration as it supports application and business processes. Handles multiple medium to large scale projects with minimal direction and supervision. Responsible for all Database Administration duties in relation to Client*s Production, Staging and Test Databases & Instances for existing applications, including:* * * *Database Security & Integrity Optimizing database access and performance Developing & Maintaining Database Disaster Recovery Procedures Architecting, Implementation & Monitoring of Database Maintenance Plans Ensuring Standardized Administration practices are implemented Ensuring all Administration Practices facilitate scalability Provide thorough functional and technical evaluation of Database related products, as well as Database & Service Pack upgrades Provide technical assistance to O&T for all production database related issues or difficulties Develop and maintain Database Replication between Disparate Platforms Provide Database Clustering/High Availability Support Provide Database Technical Support for Development Teams Mentor and coach junior team members on specific projects, as well as database administration & development practices. Handle interactions with clients and project prioritization and scheduling.* * * *Required Skills: 5+ years of experience in managing MS-SQL Instances including SQL 7.0, 2000 and 2005 Instances, residing in NT 4.0, Windows 2000 & Windows 2003 environments. To include: database administration, analysis, design, maintenance, and performance tuning. Database Developer experience is desirable. Demonstrated proficiency with: SQL Server Instance installation/creation, service pack installs/upgrades SQL Server Cluster installs, principles, support & troubleshooting Query Analyzer Enterprise Manager SQL Server Management Studio SQL Server Surface Area Configuration SQL Profiler & Related Counters Database Security: User Accounts (Standard & Integrated/NT) Roles (Fixed Server vs. Database Roles Adherence to Security best practices SQL Server Client/Server Network Utilities SQL Server System Tables & Information Schema Views DB Backup & Disaster Recovery Strategies: User & System Database Backups Transaction Log backups Recovery Models Standardized Maintenance Plans Data Staging & Replication: Publishers, Subscribers, Replication Models (Snapshot, Transactional, Merge), Publications, SQL Replication Agents & associated jobs, replication troubleshooting Database Object creation & maintenance Database & Query optimization & tuning: Execution Plans (Estimated and Actual) Indexing Strategies Statistics Database Optimization Maintenance Plans Database Development Techniques: Queries Stored Procedures DTS Packages User Defined Functions Server Domain Migrations Administrative System Stored Procedures & Extended Functions Performance Monitor (PerfMon) and related counters.* * * *Non-Technical Skill requirements: Strong inter-personal and communication skills Capable of writing user and system documentation Ability to solve problems quickly and completely* * * *Thank you, Ashish Voice: 201 255 0319 x 271 Fax: 201 727 9296 Email : [EMAIL PROTECTED] * --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "USITSOFT" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/usitsoft?hl=en -~----------~----~----~----~------~----~------~--~---
