Engineer Security

Srikanth Bandaru

+1-425-***-**** Bothell, WA adhjyq@r.postjobfree.com

Sr SQL database Lead II

Results-focused IT professional combining 17+ years of experience in programming and developing systems to drive initiatives in innovation and efficiency. Leverages extensive Database, Data Warehouse and Business Intelligence to transform complex business challenges into scaled growth solutions. Accomplished in leading technical teams in taking projects from concept to launch. Credited with strong ability to identify trends, develop competitive strategies and execute strategically planned projects. Experienced in maximizing the user experience with innovative requirements design.

Agile Methods

Product Development

Root-Cause Analysis

Integration & Migration

Software Development

SQL AWS Migrations

Microsoft SQL Azure

Process Re-Engineering

Disaster Recovery

Key Metric Analysis

Technical Proficiency

Scripting and Languages Exposure Python, TSQL, C#, ASP.net, HTML, XML, VB.NET, Java Script, XML,

Software and Supported Platforms: Atlassian (JIRA, Confluence, HipChat), MS SQL Server, Mongo PostgreSQL, Visual Studio, Power Designer, Iron Speed, PowerBI,

Certification

Amazon Certified Solutions Architect

Developing and Implementing Web Applications with Microsoft® Visual Basic® .NET and Microsoft® Visual Studio® .NET

Designing and Implementing Databases with Microsoft® SQL Server™ 2000 Enterprise Edition

Designing and Implementing Distributed Applications with Microsoft® Visual Basic 6.0

Designing and Implementing Desktop Applications with Microsoft® Visual Basic 6.0

Key Accomplishments

Established a team within a Fortune 500 company to provide global database operational support 24/7 across multiple technologies.

Directed the development of an enterprise solution, bundling of software releases for automated deployment.

Improved the end user experience by creating a web based solution that provides self-service, streamlining efforts and eliminating mid-level operational support requirements.

.SQL 2016 migrations to AWS.

oConfiguring Hybrid model (DAG)

Datacenter migrations with 0 impact

Professional Experience

Microsoft March 15th, 2020 -Current

Support Azure & On prem MSSQL CTP Billing systems & (M$) XBOX SQL machines 24/7 for all DBA related task (performance / backup maintenance / operation support / On call triage)

Migration on prem machines to Azure

Build and testing Automation using PowerShell for SQL Database migrations from On-prem to Azure.

Planning building and SQL migration On Premises as well as Migration to AWS successfully without impacting the business

Improved results by focusing on driving operational maturity to minimize risks in the environment and ensure acceptable uptime to optimize performance within the cost structure

Build Automating scripting for monitor SQL databases and Backup process.

Expedia Inc 2008 – 2008 – 2020 March.

Lead DBA II, Information Technology

Advanced effectiveness by defining requirements, outlining deliverables and prioritizing the workload for a team of 20 database administrators and service teams.

Planning building and SQL migration On Premises as well as Migration to AWS successfully without impacting the business.

Increased efficiency and customer satisfaction rose from 82% to 95% by establishing a global database operational support team that provided 24/7 coverage using “follow the sun” methodology.

Improved results by focusing on driving operational maturity to minimize risks in the environment and ensure acceptable uptime to optimize performance within the cost structure.

Boosted delivery time by 300% and drove standardization across the organization by identifying areas for automation and managing development of processes for testing and integration.

Reduced overall refresh time from 14 days to 3 hours by revamping the management of resources for DB design, physical design and modeling.

Server delivery times changed from 1 week to 1 day driving an automation project with configuring SQL Cluster / SQL AAG 2016

Automation project designed and developed for auto deployments of DB Code for data updates which changed the dependency from DBA team.

Designed & Lead the team in building a system for ExpediaGroup & Finance Team to track the inventory of license for different technologies with One Click of button.

Successfully Accomplished projects related to data center closure, End of life hardware and security compliance saving millions of dollars to Expedia group in a year.

Exposure to NoSQL Technologies PostgreSQL, MongoDB (building Mongo clusters / PostgreSQL replication / deploying scripts and troubleshooting issues)

AQUA STAR, Seattle, WA 2006 – 2007

Sr. Database Developer

Involved in the Database Administration activities like User Management, Security, Backup / Recovery.

Championed efficiency and migrated the current manual EDI process to a fully automated process by leading multiple subcontractors and also utilizing in house resources.

I was the primary point of escalation for all the problems with IIS and SQL servers

Inherited a legacy reporting application with a 60% to 80% weekly failure rate and drove improvements to achieve a 95% monthly up time.

Resolved data warehouse issues by architecting, developing and proposing appropriate solutions.

Modernized design and functionality of a web-based reporting application in collaboration with Officers and Executive members.

Developed ASP HTML pages and wrote client side validation using JavaScript.

Developing role based security

Weyerhaeuser, Eugene, OR 2007 – 2008

Database Lead,

Led the DB group to analyze and implement database tasks. Communicated with other teams about functionality implementation options and approaches.

Performed data modeling and database design.

Played SQL DBA role in product planning, performance trouble-shooting, tuning and supporting. Provided product improvement suggestions to other teams.

Performed data migration between different data sources

Developed core parts of project.

UBS, Chicago, IL 2005 – 2006

Database Lead,

Microsoft SQL Server 2000 installation on Windows NT/2000.

Database creation, capacity planning, creating/maintaining users, implementing backup plans.

Monitoring MS SQL Server performance and network issues.

Responsible for designing and implementing new databases and table structure depending on campaigns and reports requirements by the client.

Technical solutions on security with respect to Windows NT

Provided support and technical training to users.

Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Creating reports required by the business people.

Configuring the IIS on the IIS servers and implementing SSL for the websites

Microsoft, INDIA 2003 – 2005

Release System Engineer,

Microsoft SQL Server 2000 installation and configurations Windows NT/2000.

Database creation, capacity planning, creating/maintaining users, implementing backup plans.

Monitoring MS SQL Server performance and network issues.

Responsible for designing and implementing new databases and table structure depending on campaigns and reports requirements by the client.

Technical solutions on security with respect to Windows NT.

Deploying Databases to Different Environments

Daily support, troubleshooting, monitoring, optimization and tuning of SQL Server.

Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Creating reports required by the business people.

Configuring the IIS on the IIS servers and implementing SSL for the websites

Tecra System India Pvt Ltd 2000-2003

Software Engineer

Education & Development

Computer Science, SV University INDIA

Bachelor Of Computer Science, INDIA

References

Steve Johnson : 253-***-****

JayaKumar Krishnan : 916-***-****

Contact this candidate