MS SQL Server DBA cum Developer

Re-architect, manage, tune, and grow our Microsoft SQL Server Data Base and related e-commerce applications including design, and develop next generation web services, platform applications, and core server side system infrastructure that support B2C solutions-supply chain based. You will have a chance to work with a very talented team to make your mark on the client’s critical system infrastructure built with Microsoft technology that is used by hundreds of thousands of customers and that processes millions of transactions daily.

It would involve working on DB technology architectures, design, implementation, and performance issues.  It  calls for  significant MS SQL Server DB Administration expertise and experience but also one with server-side application design, development and coding experience in MS .Net/C# platform

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.
  
  
  • 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
  
  
  
  

• Utilize novel approaches to solve complex technical problems and apply advanced technical principles, theories and concepts to develop innovative products

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