PROFESSIONAL SUMMARY:

• 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 data platform for Xbox, Exchange Online and Confidential .com.
• SQL Server Software Architecture, Design, Best Practices and troubleshooting
• SQL Server and T - SQL: Perform analysis and delivering actionable insights
• 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

SKILLS:

• Ability to own and drive issue to resolution, sense of urgency with strong troubleshooting skills.
• Self-starter.
• Great team members, mentor.
• Strong analytical skills.
• Excellent Customer handling skills.

TECHNICAL SKILLS:

• Over 9 Years of Database Administration Experience in all SQL versions.
• Over 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
• SQL Server Always ON Solution, Replication, Mirroring, Log shipping, Windows and SQL Server Failover Clustering, Windows NLB
• Working knowledge on SQL Server Integration Service, SQL Server Analysis Service, SQL Server Reporting Service
• Windows Server 2012, SQL Server 2012 / 2014 / 2016 CTP 3
• Working knowledge on System Center Operations Manager
• Familiarity with ITIL processes and ER diagram, SYSINTERNALS, WINDBG and several others performance tuning and test tools
• Stay current with technology trends and developments in the industry and participate in service development

WORK EXPERIENCE:

SCOM Engineer /Sr. SQL Server DBA

Confidential

Responsibilities:

• Supporting / Managing SCOM backend SQL Server production databases.
• Provide architectural input for
• Troubleshooting / break fixing SCOM and SCOM backend SQL Server production environment.
• Implementing automation for backup processes and other database maintenance as needed.
• Plan, design and Implement automation for administrative processes.
• Mentor other team members on SQL Server best practices
• Stay abreast of industry best practices and new methods and technologies, and constantly update our own practices to take advantage of these new methods and technologies
• Develop application expertise

Sr. SQL Server DBA

Confidential

Responsibilities:

• Developing Backend table schema and SQL Server objects as needed.
• TSQL performance tuning.
• Supporting/ Managing/ Take ownership of Studios BI and Studios OLTP and OLAP SQL Server 2012/ 2014 database environment.
• Developing Backend table schema and SQL Server objects as needed.
• TSQL performance tuning.
• Supporting/ Managing/ Take ownership of Studios BI and Studios OLTP and OLAP SQL Server 2012/ 2014 database environment.
• Create /Automate several operations processes to improve Capacity Planning/ monitoring / actively reducing number of incidents and overall service health.
• Collaborate and Design/ Evaluate different DR Solution to meet business goal.
• Resolve complex system issues and incidents escalated from lower support tiers.
• Continuously improve system and database performance, automation, operations and processes.
• Participating in 24/7 on call rotation.
• Take ownership and execute planning/ documenting and Deploying several database environments /Automating tasks for Confidential Game Studios and BI backend infrastructure running on SQL Server 2008R2/2012/2014, maintaining SLA for uptime.
• Diagnosing and Troubleshooting SQL Server and Windows OS issues.
• Documenting Storage Architecture /help implementing appropriate RAID level for Data warehouse servers.
• Setting up clustering /AG environment in SQL Server 2012/2014
• Driving several change management processes improving existing monitoring and change management processes.
• Documenting several operational processes, help reducing number of incidents and overall service health.
• Help improving proactive monitoring /auditing of database environment, automation of Monitoring and alert notification.
• Implementing DR using SQL Server 2012/2014 Always On and other features in Production.
• Creating /Troubleshooting backup and other automation scripts using TSQL and PowerShell
• Help implementing code review process using code flow.
• Reviewing/Improving and implementing TSQL code best practices.
• Writing code design spec/ TSQL script for SQL maintenance tasks.
• Troubleshooting OLTP /OLAP production Server issues.
• Mentoring team members and customers as required.
• Participating in on call rotation and training as required.
• Evaluating /using different reporting tools such as SSRS to implement reporting on System/SQL Server processes and health.

Service Engineer

Confidential

Responsibilities:

• Take ownership to automate backup / Index and other maintenance DB scripts to deploy on 200+ SQL servers running on SQL Server 2008R2 /Widows 2008.
• TSQL Code review and Performance tuning.
• Participating in 24/7 on call rotation.
• Taking ownership and Collaborating with HP and different teams to plan and successfully execute time sensitive project maintaining strict SLA: Replace HP Adaptec Controller on 101 production servers running on Windows Server 2008 and SQL Server 2008 R2 maintaining SLA
• Review and improve/automate SQL Server /Windows monitoring
• Updating/ debugging existing PowerShell and C# scripts to manage the big infrastructure.
• Designing and Developing backend table schema, creating and implementing Stored procedure/Views etc.
• Supporting/ Managing/ Capacity Planning/ Improving monitoring /Automating tasks for Confidential backend infrastructure running on SQL Server 2008 R2 and Web store, maintaining SLA for uptime
• Testing /Implementing SQL Server 2012 Always On and other features in test environment before implementing in in Production.
• Taking part in TSQL and PowerShell code review/ debugging.
• Reviewing/Improving and implementing SQL Server Security best practices
• Writing design spec/ TSQL script for SQL maintenance tasks, working with development team to implement it
• Working with monitoring team to help improve/ update SQL and overall environment monitoring
• Driving and accomplishing the project to replace Adaptec controllers on 100 DB servers maintaining SLA
• Troubleshooting Web store / SQL Server and DB issue
• Participating in C# and other training by Confidential Engineering Excellence
• Participating in security training
• Mentoring team members.

SQL BI Developer /Sr. SQL Server DBA

Confidential

Responsibilities:

• Design, Create and Implement ETL packages using SSIS.
• Design and Implement SSRS reports.
• Designing and implementing backend objects.
• TSQL performance tuning.
• Taking ownership of backend infrastructure and providing operational support.
• Troubleshooting retail CMDB, SCOM OLAP test and production on SQL Server 2008 R2 and SQL Server 2012 environment including VMs.
• Planning /implementing Retail OLTP physical and logical database. Designing/implementing database object schema based on business needs.
• Meeting SLA and implementing SQL Server 2008 DR strategies SQL Server failover clustering on VMS/Replication for production environment running SQL Server 2008 R2.
• Implementing /Managing /Supporting and troubleshooting Windows/SQL Server 2008 R2 clustering environment.
• Proactive capacity planning for SCOM and CMDB database.
• Taking ownership and provide solution for SQL Server OLTP performance methodology.
• Implementing SQL configuration and security best practices.
• Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
• Auditing and Documenting all environments, processes and storage best practices.

Sr. SQL Server DBA/ DEV

Confidential

Responsibilities:

• Taking ownership of SQL Server OLTP test and production SQL Server 2005 / 2008 R2 environment
• Design, document and create monitoring tool replacing existing monitoring system to reduce / minimize monitoring cost
• Meeting SLA and designing/ implementing/ creating / testing SQL Server 2005/ 2008 DR strategies including backup/ restore, Mirroring, Log Shipping and Failover Clustering for production environment running SQL Server 2008 R2 and SQL Server 2005.
• Supporting and troubleshooting Windows/SQL Server 2008 R2 clustering environment
• Planning downtime and patching all production SQL Servers.
• Capacity planning and guiding system admin for the appropriate storage and RAID LEVEL for SQL Server and SQL Server Clustering environment.
• Troubleshooting any SQL Server related issues, work with MS CSS team to resolve SQL crash issues in production.
• Create ad hoc SSIS packages to migrate and transform retail data.
• Designing and implementing multi-site clustering environment in 2008 R2.
• TSQL Code review, code and server performance tuning.
• Re design and implementing / automating SQL Server monitoring processes.
• Implementing SQL configuration and security best practices.
• Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
• Upgrading SSRS reports and SQL Server database engine to 2008 r2
• Auditing and Documenting all environments, processes and storage best practices.

BI developer / DBA

Confidential

Responsibilities:

• Develop/ Deploy / Update/ Troubleshoot SSRS report, TSQL code and SSIS packages.
• Planning / implementing different SSRS reports out of SCOM DW for monitoring.
• Generating SSRS report out of TFS data
• Build Crystal Reports as required.
• Working with program managers to gather data points for SSRS report development.
• Planning /Migrating existing SharePoint and Excel based reports to SSRS platform.
• Writing TSQL code, design indexing, test and tune all the codes for optimized performance.
• Secure/ Administer SSRS lab servers.
• Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
• Upgrading SSRS reports and SQL Server database engine to 2008 r2
• Auditing and Documenting all environments, processes and storage best practices.

SQL Server DBA

Confidential

Responsibilities:

• TSQL and batch scripting to automate SQL admin tasks.
• Performing logical and physical data modeling.
• Supporting/patching large production environment; implementing and troubleshooting database mirroring, replication, web store, taking part in database modeling and documentation. Work as a release engineer.
• Investigating and troubleshooting SQL Server performance issues. Troubleshooting SQL Server related issues filed as bugs in product studio, implement RFCS.
• Review TSQL code and help product group optimizing TSQL applications for best performance.
• Received training at Confidential on escalation process and Confidential environment as a whole.

SQL Server DBA

Confidential

Responsibilities:

• Working with networking and web system engineer closely to resolve any application, server or network related issues as and when required.
• Planning and implementing disaster recovery solutions.
• Implementing additional monitoring system to meet SLA.
• Building. Configuring new servers with Windows 2008 R2, SQL Server 2008, Reporting Server 2008 RTM, SQL Server 2008 R2.
• Communicating with customer; planning and migrating SQL 2000, SQL 2005 databases to Windows 2008R2/SQL 2008 environment as part of TAP commitment: ensuring to meet SLA during the migration. Troubleshooting any post migration issue.
• Administering, troubleshooting issues running reporting servers 2008 RTM.
• Troubleshooting customer issues for backend application hosted on MSCOM production environment, taking part in customer’s architecture review and evaluates them from backend perspective. Educating and guiding MSCOM customers to tune TSQL code, introduce best practices and to get started with new Database application etc.
• Migrating SQL server 2000 and SQL server 2005 SSRS environments to SQL 2008 SSRS.
• Administering, configuring and troubleshooting server instances participating in transactional and transactional peer to peer replication or Mirroring principal in transactional replication.
• Supporting windows network load balancing for availability of database servers.
• Administering, configuring and troubleshooting servers with databases in mirroring.
• Troubleshooting, reviewing and tuning TSQL code.
• Configuring, troubleshooting log shipping.
• Planning and executing solutions based on customer requests.