location : Hyderabad Development Center
5- 13 yrs experience
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
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
No comments:
Post a Comment