SQL Database Developer -AND - SQL DBA Positions - Microsoft Corp Hyd

LOCATION FOR BOTH POSITIONS IS HYDERABAD 

COMPANY : MICROSOFT CORPORATION 

POSITION:1

Title SQL DBA  Dev /  Lead  

Are you ready to join the Engineering Delivery Integration group as a Senior Lead Production Engineer?  Would you like to contribute to the building and managing of world class services supporting Xbox 360, Zune, Microsoft Games, and all other Microsoft products sold at retail?  Join Microsoft Entertainment and Devices and make the Digital Entertainment Lifestyle a Reality!

As a member of the E&D Information Systems team, you’ll drive the supportability and manageability of our applications, guiding the product team through the release and deployment phase and help ensure the readiness of our Production Support team. You will interact with program and solutions management, development, and test to ensure we deliver quality applications that meet our customer requirements. You’ll play a key role throughout the product development cycle, collaborating on designs, features, and driving quality requirements and ensuring the product is ready for a high-availability production environment. You’ll design, develop and own appropriate monitoring solutions and provide Tier 3 Production Support.  You will provide leadership and direction to junior Production Engineering team members and vendor staff.

Core job responsibilities:

·         Facilitate and coordinate release management process driving increased Release agility, quality, and supportability.

·         Deliver on key SLA’s and availability metrics.

·         Provide Subject Matter Expertise for production and UAT environments and application(s). 

·         Lead or participate in individual, team or cross team projects that enhance the quality or efficiency of support. 

·         Troubleshoot issues independently and collaborate with project teams directly without guidance from others. 

·         Improve organizational learning through accurate recording of problem management data and trend analysis.

·         Reduce the number and business impact of incidents, problems, and known errors as problem management resolves and eliminates the root causes of incidents.

·         Deliver and drive continuous improvement of the ITIL/MOF disciplines including Release, Change, and Problem management.

·         Provide clear and effective project status reporting on a periodic basis to systems team stakeholders (and clients).

·         Provide leadership, supervision and guidance to a team of junior engineers.

Basic (Minimum) Qualifications:

·         6+ years of database-related experience in a production environment

·         2 years of technical team leadership experience

·         SQL Server, OLAP experience and competency

·         T-SQL stored procedure development, analysis, and troubleshooting, performance and tuning

·         Knowledge of Windows 2003 / 2008 server and IIS

·         BS in Computer Science, Information Systems, Engineering or related field (or equivalent additional industry experience.)

Preferred Qualifications:

·         Experience with performance tuning, failover technologies and strategies

·         SQL Administration including performance tuning and data analysis

·         Database implementation, DB internals

·         MCSE, MCDBA , MCPITDBA or equivalent work experience/training.

·         In-depth knowledge of Microsoft technology and software including Windows, IIS, SQL, ASP/ASP .NET, BizTalk.

·         MS in computer science, information systems or engineering

·         Experience working in a 24X7 environment.

·         1 -2 years experience with Digital Asset Management technologies

·         1 -2 years experience with Adobe In-Design Server

·         In-Depth knowledge of FTP

·         Knowledge of software lifecycle methodology and Microsoft Operations Framework (MOF).

·         A passion for customer support.

 

POSITION :2 

STANDARD TITLE: SENIOR DATABASE ENGINEER

Job Description Format

Introduction to group/job  Join Microsoft’s fastest growing division and make the Digital Entertainment Lifestyle a Reality!

Entertainment & Devices Manufacturing & Supply Chain (E&D Mfg & SC) Systems improves business performance continuously by delivering world class systems solutions.

As Database Engineer for E&D Mfg & SC Systems based in India, you will be part of the team working in maintaining high performing and scalable SQL systems (Largely BI) to enhance the productivity and competitiveness of Microsoft Entertainment & Devices, you will be driving initiatives to design/build World Class BI/SQL platform to support our Business clients Long range plan and Enterprise Architecture Pillars. This position will own the E&D SQL stores by setting industry best practices, standards and procedures, and ensuring the SQL platform is highly scalable, available, and secure. You will act as E&D final point for escalation for any SQL related issues and questions. Currently our group owns 400+ physical servers with 5 different BI application focusing different business segment (XBOX Live BI, Manufacturing & Quality Analtyics, Sales & Marketing and Operational Data Warehouse etc.,), current storage foot print is ~80TB with huge growth projection.

The E&D Mfg & SC Systems group reports into E&D Mfg & SC, developing and supporting critical business systems for all functions of the division, from Manufacturing through Operations, Sales and Marketing and Finance, Business Performance and Strategy.  Our systems support the extended retail supply chain not only for E&D products but for all Microsoft products sold at retail (e.g. Xbox 360, Zune, Vista, Office, Hardware products and Games for Windows etc).  While embedded in the E&D Division we are also closely affiliated with the corporate Microsoft IT group, leveraging multiple shared services to deliver world class solutions to our demanding client base.

Roles/Responsibilities 

·      Work with Project team/Architects and provide technical expertise and support of database administration and tuning. Continue to seek improvements in product performance that can be achieved through changes in database schema, logical and physical data organization, and tuning & configuration.

·         Work with Project team/Architects for new development efforts, and provide technical expertise and participate in the design and implementation of a database schema that conforms to industry standards yet meets all application specific requirements

·         Apply the "Database-Specific Operational Best Practices Checklist" 

·         Perform design review of all database changes/projects

·         Performance-tuning and optimization (review blocking, do root-cause analysis of performance bottlenecks and escalate appropriately).

·         Plan future-state infrastructure (storage capacity planning, server SKU recommendations, newest SQL Server features, etc.)

·         Setup database failover mechanism (DB Mirroring, log-shipping, etc.) and perform disaster recovery excercises.

·         Maintain, review and implement the "SQL Server Configuration Standards Checklist"  (Writing in Progress).   Make sure all servers are in compliance.

·         Fine tune SQL monitoring by ensuring that all SQL Errors are captured proactively.

·         Create knowledge base articles for alerts/issues for DBA (Service operation) team to resolve issue without escalating to database engineering team.

·         Plan for high availability through SQL Always on technology

BASIC QUALIFICATIONS:

-         BSc in Computer Science or similar Engineering degree

-         5+ years of experience as a SQL Database Engineer

-         3+ hands on Production DBA experience in handling VLDBs, especially in areas like tuning, disaster recovery and high availability.

-         Strong SQL skills (Level 400) and experience in database design, schema design, and SQL performance tuning and optimization

-         Experience and knowledge in designing scalable and failover database systems

-         Experience in configuring, implementing and supporting high availability strategies with SQL Always on technology.

-         Outstanding customer service/focus skills Demonstrated ability in handling complex. technical issues and providing timely solutions.

-         Demonstrated ability to define and follow best practices and business processes.

-         Excellent written and verbal communication skills

-         Understanding of multi-tiered application technology.

-          Excellent understanding of Microsoft Windows 2000/2003 operating system

-          Good understanding of  OS and Infrastructure / Network layer is value added

PREFERRED QUALIFICATIONS: 

-          Experience in Designing and Implementing enterprised wide BI solution 

SQL Dev - Microsoft Hyd

Location :  Hyderabad 

Company : Microsoft Corp 

Title: IT Software Development Engineer 2

Job Description/Responsibilities:

This position is responsible for developing several units of functionality usually making up part of an application. Examples include designing and implementing process workflow, simple schemas, read only access etc.  “Simple” is defined as a limited number of requirements, isolated or a limited number of interfaces, low transaction volume, and/or deployment in a single region.   The position may include working on multiple development projects simultaneously ensuring that they are being developed in line with all internal standards and best practices. SQL and .Net experience as well as structured software development methodologies is required.

As IT Software Development Engineer 3 this person will be responsible for:

• Code and test applications in accordance to design specifications and standards.
• Code and test SQL Server database applications that support the requirements defined by users and analysts.
• Design as per architectural directions simple to medium complexity modules/features
• Responsible for developing major subsystems on high risk business systems under deadline pressure
• Responsible for successful completion of development aspects of projects in conformance to project goals and requirements
• Deliver assignments according to a schedule
• Analyze applications and make necessary changes to optimize performance
• Analyze and troubleshoot existing processes and optimize code in order to improve performance whenever possible
• Develop and enforce coding practices designed to promote code reusability; assist in defining and updating the team standards to improve the development process and quality of deliverables
• Participate in design reviews and code reviews
• Assist Test and Production Support teams with installation of the application
• Design and code database applications that perform efficiently, are operationally stable, and meet the business requirements.
• Accurately estimates work/time required to complete tasks within their skill set
• Assist with the creation of project plans.
• Communicates and defends design, requirements, feature set, functionality and limitations of subsystem to team members and development lead.
• Fosters  proactive and cooperative relationships within the project team
• Participates in project team activities and contributes to documentation requirements consistent with methodology.
• When necessary, participates in the creation of new guidelines and procedures.
• Act in lead role (if required), and oversees the design and development for smaller, lower risk business systems
• Exercises independent judgment in selecting methods and techniques for obtaining solutions.
• Ensures that team’s code meets specifications and is easily maintainable.
• Participates in project team activities and contributes to documentation requirements consistent with methodology
• Prepares presentations and status reports.
•  Fosters  proactive and cooperative relationships exist within the project team
• Proficient with and guides others in using development tools.
• May make recommendations on staffing and hiring decisions.

Requirements/Qualifications and Previous Work and Related Experience (including educational requirements):

·         Excellent English communications skills, both written and oral. Must be able to effectively communicate technical and business problems in a non technical manner to multiple groups (customer groups, project team, IT support groups)

·         Understands networking

·         Strong understanding of how to design applications for optimal network performance

·         Proficiency in multiple program languages, especially c# and vb.net, ASP/ASP.Net, n-tier development environment and HTML scripting languages (Javascript.Jscript,VbScript) or similar application structures

·         A solid working knowledge of SQL Server, Windows NT, and development practices for working with a team of developers.

·         Experience working with relational database management systems and client-server technologies

·         Strong leadership skills

·         Sound problem resolution, judgment, negotiating and decision making skills required.

·         Strong analytical and organizational skills.

·         Able to participate in a team environment, communicate effectively and promote cooperative relationships.

·         Ability to work under pressure and be able to work to tight deadlines.

·         Must have a strong understanding of software architectures and MS products.

·         Demonstrated experience with a Software Development Life Cycle Methodology and information systems development. Experience with agile development methodologies and PSP/TSP would be an advantage.

·         Strong knowledge and ability to apply latest technology, standards, capabilities and limitations of technology.

·         Demonstrated knowledge of relational database and client-server technologies.

·         Promotes cooperative relationships

·         Ability to work with multiple people, resources and partners, remotely if necessary

·         BS/BA in computer science or related field

·         Minimum of five to eight years of related developer experience – or – An equivalent combination of training and related work experience

Microsoft certification desirable

SQL+OLAP/ ETL- Microsoft BI

Job Role: Senior BI Application Engineer/BI Architect (Microsoft BI)




Introduction

The Partner Integrated Reporting (PIR) Team at BI Engineering Group - MSIT (India) is looking for a well-qualified person who has prior experiencing in design and implementation of 2-3 end-to-end BI Solutions on Microsoft Technology Stack. This is an IC role. The BIE Team at MSIT India deliver BI solutions for key Microsoft Businesses e.g. Consumer, Partner, Sales and Marketing etc. The PIR Team at BIE is responsible for delivering BI capabilities to Microsoft Partner Teams for enabling key reporting capabilities around the Partner Business of Microsoft. The PIR Team is engaging in a new effort for the upcoming year to deliver enhanced BI capabilities to Microsoft Partner Teams (Next Generation PIR Effort). The PIR Team is looking for a Senior Technical Lead who can help drive the Technical and Architectural direction of the Next Generation PIR across the entire BI SDLC.



Job Position

• Should have excellent communication skills. Able to talk efficiently and effectively with the global development team and have the talent of challenging technically.

• Should have 7+ Years of IT Experience with at-least 4 years in the Design and Development of end-to-end BI Projects

• Should have exposure to complete SDLC for building a BI Application (Requirement Analysis, Design, Development, Deployment and Support)

• Displays high degree of Confidence and ability to work in ambiguous situations

• Should be able to Lead the Technical Architecture / Design for the BI Application

• Should be effective at Cross Group collaboration

• Should have capability to influence Architecture / Design for Medium to Complex components for the BI Application (within and across the Organization)

• Evangelizes Technology Patterns and Best Practices

• Must able to lead a project with less dependency and control the project with respect to schedule and quality.

• Displays great negotiation skills and displays ability to influence others

• Excellent Team Player

• Be an active participant on design, development and support of the project.

• Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects



Responsibilities:

• Ability to drive Application Development Plans for Medium to Complex deliverables or for entire Release

• Dimensional Modelling (Physical and Logical)

• Design and develop ETL and relational Staging and Data Mart Databases.

• Design and develop multi-dimensional Schemas.

• Design and develop reporting systems for internal and external partners.

• Contribute to development methodologies and best practices in the BI space

• Active participation in technical investigations and prototyping

• Evangelize on Microsoft BI Platforms and build tools to enhance Team Productivity

• Define, Optimize and Manage the Version Control Strategy for the Project



Technical Skills:

• Strong Breadth in Microsoft BI Technology Platform (with Strong Depth in 2 Technology Areas)

• Essential: Strong SQL Server Fundamentals and T-SQL Skills (SQL Server 2005+)

• Experienced in Design and Development of Microsoft OLAP Cubes (SQL Server 2005+)

• Experienced in Design and Development of Application ETL based on the Best Practices leveraging Microsoft ETL Tools

• Experienced in Design and Development of Microsoft Reporting Technologies (SQL Server Reporting Services, ProClarity or Performance Point)

• Experience on Microsoft Tools for Project Planning – Microsoft Project

• Experience on Modelling Tools like ERWIN and Microsoft Visio

• Experienced in Performance Tuning specific areas of a BI Application (Database Code, ETL, Reporting, OLAP)

• Experienced in Version Control Tools and Collaboration like Visual Source Safe, VS DB Pro and VSTF

• Exposure to Microsoft Collaboration platform like Microsoft SharePoint Portal

How to  apply

If you  have received a mail  from me Pls reply to  that mail  with the required details

If you  have reached this site directly  ...pls  send in your resume to  kurien@crest.in with SQL /OLAP as the subject . Pls mention ur Current  and exp CTC details in the mail 

Softwre Development Engineer 2 - Microsoft Corp hyd

Company : Microsoft Corp

Location :  Hyderabad


Good communication




- 5-8 years of exp.



- Strong on Sql, SSAS, SSIS, Integration skills



- Worked and hands on experience on .Net suite of technologies like C#, Asp.Net, VB.Net



- Working experience on Biztalk