*Microsoft SQL Database Administration* *Mountain View, CA*
*6+Months* *We need genuine resources – with photo ID proof*. *Microsoft SQL Database Administration* 8 to 10 years experience, Microsoft *SSIS and SSRS* experience, Experience in *constructs/development/deployment* of *OLAP and OLTP* databases, Backup & Recovery methodologies, Database security & Access Provides database development, maintenance and enhancements in support of PAMF Data Warehouse (and associated applications. Lead role in establishing database strategies in support of PAMF Warehouse solutions. Provides database optimization support to developers building Data Warehouse and Business Intelligence solutions. Database development • Builds databases, stored procedures and scripts in support of DW solutions designed by Data Warehouse development resources • Recommends database and fields naming conventions. • Assists in the development of database extracts. • Documents database models, scripts, stored procedures, promotion procedures and system architecture. • Establishes development guidelines designed to maintain optimum performance. • Advises Data Warehouse managementin the creation of development guidelines. Takes a new perspective on existing solutions, recommending new procedures and processes to achieve results. Performance tuning and monitoring of databases • Establishes guidelines for query structure to maintain adequate performance. • Proposes and implements enhancements that will improve the performance, reliability and data integrity of the system. • Reviews queries for performance issues. Identifies and performs routine maintenance to ensure high performance. Back-up and recovery • Recommends back-up schedule and strategy. • May set up and regularly monitors back-up as specified by SLA. • Adheres to enterprise disaster recovery policies and procedures. Performs database restores from back-up. Database security and access • Researches and recommends security and data access strategies. • Configures user database access based on approved policy, user roles and responsibilities. • Works with Security and Internal Audit to comply with corporate security standards. Audits data access as scheduled or requested. Capacity planning • Assesses impact of and recommends solutions based on current and future data volume needs. • Allocates and reallocates database resources. • Designs database system architecture to meet performance needs. • Researches and recommends database strategies to management. Supports developed applications • Adheres to all Enterprise Change Management (ECM) procedures per IS policy. • Makes configuration upgrades. • Identifies impact of enhancement requests. • Assists customers to identify and resolve problems. *Kuldeep Yadav* *Technical recruiter* *Net**2**Source Inc.* *[email protected] <[email protected]>* *Gtalk&Yahoo:: kd.intime* *Tel: (201) 340.8700 x 4**52**| Fax: (201) 685.8135* *Address: 15 Exchange Place, Suite # 500, Jersey City, NJ - 07302* *Website:* www.net2source.com *Microsoft Gold Certified Partner **|** Cisco Certified Premier Partner **|** Oracle Gold Partner** | **IBM Business Partner** | **ISO 9001:2008 Certified Company** | **NASSCOM Certified Company **| **E-Verified* -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
