Senior Database Administrator/ Developer with over 9 years of experience in mission critical operations, system administration and database engineering. Experience leading global programs and teams on both operational and strategic level. Proven decade long successful experience of implementing and guaranteeing SLA for mission critical and large data platform for Xbox, Exchange Online and Microsoft.com. SPECIALITIES SQL Server Software Architecture, Design, Best Practices and troubleshooting SQL Server and T-SQL: Performance analysis and delivering actionable insights Benchmarking SQL Server implementation with TPC-DS, TPC-H, TPC-C. OLTP: Architect, Design, Implement, and Optimize Automation of administrative and operational processes through PowerShell and TSQL Review existing processes and drive changes or institute new processes as necessary, including the areas of monitoring, upgrades, and tuning Generate high-quality project documentation, such as architecture designs, implementation plans, design documents etc. Provide technical escalation and be on call via pager during designated periods Recommend, own and drive application changes to improve application performance Design, implement, function test and load test packages, stored procedures, triggers and other database objects to support new and existing applications Develop, enforce and maintain appropriate database change control procedures for the database objects Develop and maintain expert-level knowledge in SQL Server internals and best practices for database architecture and physical data modeling SQL Server Database Administration on multi-terabyte production databases C# Code debugging Database Migration and consolidation maintaining SLA Designing and implementing Disaster Recovery solution Implementing SQL Server security best practices Proven proficiency in maintaining strict SLA / supporting /troubleshooting for large scale enterprise level highly available RDBMS system Designing /implementing / supporting SQL Server Storage Working knowledge on MongoDB and Oracle. TECHNICAL SKILLS 10 years of DBA experience designing and administering multiple Microsoft SQL Server databases in a 24/7 mission critical environment. 4 Years database development using TSQL procedures, functions, views. Strong knowledge of T-SQL, Stored Procedures, Functions, views and other objects. Creating/ Designing and Implementing ETL packages using SSIS. Ability to data mine and develop reports using a variety of reporting software packages with a high aptitude for learning new reporting software packages. Deep understanding of source code control and versioning methodologies, such as Team Foundation Server and Product studio. Good understanding of various TPC benchmarking standards/tools.
