Sr SQL DBA Expert

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • Confidential
  • 5-8 years
  • Views
  • 08 Nov 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services, IT/ Technology - Data Center/ Manage Infrastructure Services
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-

Job Posted By

O.P. Chawla