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
· 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 ENGINEERJob 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
No comments:
Post a Comment