SQL 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
Sanjeev Thakur
Technical recruiter
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at http://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment