SQL Database Developer - Microsoft hyd

Company  : Microsoft  Corporation 

location : Hyderabad Development  Center 

  5- 13 yrs experience 

STANDARD TITLE: SR SE 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



How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to leelakrishna@crest.in with SQL Developer as Subject
...Include CTC details in your mail

SQL DBA with Release experience 6+yrs - Microsoft Corp - Hyderabad

Company : Microsoft  Corporation 

Location ;  hyderabad


( PS : Generic  SQL DBA positions also available with Microsoft )



This position provides application change and release support for existing and new technologies in pre-production and production environments. Working closely with development, system test, analysis and service operations to ensure application revisions occur under controlled conditions to ensure code is successfully applied to the UAT/Pre-Prod/production environments.

This position has build automation, scripting, and release implementation responsibilities and requires a mix of technical abilities, coordination and problem solving skills.  The Service Build Engineer interacts and partners directly with Development teams, Service Release Managers, Support Teams, and Program Managers, as well as Test groups.

The position is accountable to the Service Release Manager, and responsible for deploying changes effectively to the controlled environments.  This includes all aspects of the end-to-end release process:   plan, design, build, test, accept and deploy.   Position coordinates, automates, deploys and communicates release implementation status and owns release implementation issues to resolution.

This role works with Service Release Manager to ensure appropriate environments are available and setup. This position is responsible for defining the workflow and schedule to implement the release in the Production/Pre Production environments, as well as performing the release implementation activities. Service Build Engineer establishes the release build approach, assembles and integrates release components.

Responsibilities include creation of service installation plans, procedures and scripts, creation of service release deployment and validation plan.  Other responsibilities are to develop manual deployment procedures and/or automated deployment scripts, and interface with corporate procurement to order and acquire the necessary service release components.  The Service Build Engineer has responsibility to validate the quality of all service components, including ensuring that components meet organizational standards, design specifications and documented baseline. 

Position identifies automation needs and works with appropriate teams to drive the automation, and ensures the release is correctly defined in the Configuration Management System.

Who we are looking for:

Microsoft IT is looking for a highly motivated individual who wants an opportunity to make a difference using their experience to help drive the application build process across MSIT.  This role is based in Redmond, will interface with colleagues in other regions, and be a part of a team working to constantly improve the build process and environment management.  If you care about what you do and have a passion for innovation and quality, this is the role for you.

Excellent technical and communication skills are required.

A minimum of 5-7 years’ experience in IT or related fields is required and a BA/BS degree in computer science or related technical field is preferred.

Experience working with a mixed global offshore/onshore model preferred (some international travel may be required).

Experience with web-based applications, enterprise environments, and high-availability production concepts & implementations is required.

Expertise with Microsoft technologies including MS SQL Server, Windows Server, Internet Information Services (IIS), .NET is required,  Experience with C#, ASP.net, and automation scripting preferred.  Experience with the release management role and/or the Microsoft Operations Framework general concepts also preferred.

How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to leelakrishna@crest.in with SQL DBA as the subject ...Include CTC details in your mail