Position: SQL Server DBA
Location-Palo Alto CA
Duration-6 Months.
------------------------------------------------------------------------------------------------------
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
· Strong analytical and troubleshooting skills
· Enthusiasm for tackling complex problems
· This is an ideal position for a team-player who is hard-working, self-motivated, pro-active and
thrives in a dynamic fast-paced environment and is ready to hit the ground running
· Strong communication skills, both written and verbal
· Enjoy working with intelligent, talented, and hard-working colleagues, but self-motivated
· BS in Computer Science or other technical field or equivalent work experience; MS preferred
Thanks & Regards,
Payal Jain | Technical Recruiter
Technology Resource Group Inc.
3736 Hillsdale Court Santa Clara, CA 95051
Office: 408-709-1760 Ext : 834, Direct: 4085025518
G talk: trgpayaljain | YM: trgpayaljain | Fax: 408-884-2409
payal.jain@tresourceinc.com | www.tresourceinc.com
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 the Technology Resource Group. e-mail system
Payal Jain | Technical Recruiter
Technology Resource Group Inc.
3736 Hillsdale Court Santa Clara, CA 95051
Office: 408-709-1760 Ext : 834, Direct: 4085025518
G talk: trgpayaljain | YM: trgpayaljain | Fax: 408-884-2409
payal.jain@tresourceinc.com | www.tresourceinc.com
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 the Technology Resource Group. e-mail system
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment