*Position: SQL Server DBA* *Location-Palo Alto CA*
*Duration-6 Months.* *With more of DEVELOPMENT DBA skills rather than production DBA* ------------------------------------------------------------------------------------------------------ Job Description - Essential Duties · Primary responsibility is implementing, analyzing, improving, enterprise-level system architecture, DB designs, and working with one or more development teams to realize future DB architecture. · Work with other Engineers, Managers, QA and IT/Operations teams to develop innovative DB solutions that meet market needs with respect to functionality, performance, scalability, reliability, realistic implementation schedules and adherence to development goals and principles. · Lead developer for OLTP and OLAP database architecture, design, development, testing and implementation · Maintenance and development of OLTP, OLAP, data warehouse databases. · Creating, maintaining, and updating database schemas for all databases using a database modeling tool. · Utilize novel approaches to solve complex technical problems and apply advanced technical principles, theories and concepts to develop innovative products · Replication design and maintenance · Enforces database standards (MS SQL Server 2008/2012) and best practices · Design and documentation for database backup and disaster recovery procedures · Advanced level database engineering support and assistance including design/implementation of distributed DBs, DB and Table partitioning, DB performance optimization etc. · Identify, investigate, and resolve database performance issues, database capacity and scalability issues and data distribution issues · Reviews database design changes with the team to determine the impact to the physical database and other systems · Manages and performs maintenance, backups and security for the development databases · Troubleshoots Production database issues · Performs capacity planning · Monitors Production & Development database and SQL Server performance · Mentors other members of the engineering and ops team in database related technology · Responsibilities include researching, analyzing, designing, proposing, and delivering solutions that are appropriate for the business and technology strategies. · Help design complex systems at the component and framework level, make strategic technology choices, and directly supervise the quality of designs and implementation of the overall platform, implementation and orchestration of components Required Knowledge, Skills and Abilities: · 10+ years as MS SQL Server DB experience · Proficiency in Microsoft SQL Server 2008/2012 in the following areas (10+ years): § database design; SQL Server architecture § SQL scripting; performance tuning; stored procedures § function and trigger design and coding § index implementation and maintenance; § database backup and recovery § SQL Server log shipping § SQL Server real-time replication § DB/Table partitioning and archiving § DB capacity planning · Expertise in n-tier application architecture, design including DB design · Significant DB experience in architecting, designing, and developing high performance, high volume scalable, online e-commerce related server/web-based SW products and services · The ability to extrapolate database schema to meet the business needs of the application · DW-based reporting system design and implementation experience including ETL tools · Strong server side architecture, design, development experience on Windows platform · Strong object-oriented programming and design interest with a pragmatic approach · 5+ years of experience using C# /.NET, java or C++ · 5+ years of experience developing Web Services (WSDL, SOAP) and REST *Thanks & Regards,* *Md Faisal Zahid* Technical Recruiter Technology Resource Group Inc. 3736 Hillsdale Court Santa Clara, CA 95051 Office : *408-709-1760 Ext: 865*, Direct: *408-933-9532* E mail id: *fai...@tresourceinc.com* <fai...@tresourceinc.com> | :*g-talk: ausafleo ym: ausafleo* *Fax:* 408-213-8316 *www.tresourceinc.com* <http://www.tresourceinc.com/> [image: Description: cid:image002.jpg@01D0C954.94169C50] *Disclaimer: *This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by reply REMOVE in the subject line and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. Technology Resource Group has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Technology Resource Group reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on company's. e-mail system [image: Description: cid:image003.png@01D0C954.94169C50] -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.