Data Azure
Resume:
KIRAN GUNDA
www.linkedin.com/in/krajdba
adg0df@r.postjobfree.com
PROFESSIONAL SUMMARY
●7 years of IT experience in Database Administration, Design Development and Support of MS SQL
Server 2016/2014/2012/2008R2/2008/2005 in Production, Test, Development and Cluster Server
Environments.
●Knowledge on AWS EC2, IAM, S3, EBS, Elastic Load Balancer (ELB), auto scaling group services.
●Expertise in implementing different types of high availability and disaster recovery mechanisms like replication models, log shipping, database mirroring, always on and clustering.
●Experience with Azure Data Stack (IaaS, PaaS, Cloud Connect, Migrate Databases from/to Cloud).
●Ensure backup and recoverability of all enterprise Sql Server databases using Native SQL and Symantec NetBackup.
●Created Databases on Azure Sql Server and Migrated On-Premise databases to Azure SQL.
●Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler, DTA and SQL Query Analyzer.
●Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008/2008R2 and migration to 2012/2014.
●Expertise in performing administrative tasks, Database files management, Backup/Restore, Security management, Database Mirroring, Data integration and Synchronization and Isolation levels.
●Expert skills on SSIS (SQL Server Integrated Services) and SSRS (SQL Server Reporting Services)
●Extensive use of DTS/SSIS in SQL Server, Performance Tuning, optimization and Normalization, Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
●Experience with configuring and/or deploying EC2 instances
●Experience in Disaster Recovery Planning, Execution and Testing at a remote side.
●Expertise in reading and understanding execution plans and fixing query to execute with low cost using various operators depending on the scenario.
●Worked in OLTP and OLAP environments that includes Production (24x7), QA and development databases in SQL Server.
●Provisioning of AWS resources like EC2, VPC, EBS, AMI, S3 buckets, creation of subnets and all other operational tasks.
●Worked on 2-node (A/P, A/A) & 3-node (Active-Active-Passive) Clusters.
●Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
●Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
●Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.
●Extensive experience with IIS (Internet Information Services)6.0/7.0 using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008/2008R2/2012/2014.
●Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.
●Designed and implemented administrative tools to automate system maintenance, accounting, and performance monitoring using scripting toolbox (Mix of T-sql, PowerShell and Windows Cmds)
●Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
●Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, Default trace, change data capture(CDC), File stream, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
●Knowledge on Column Store Indexes, In-Memory OLTP, Contained Databases, Stretch Database, On-Premise Cloud vs Public Cloud.
●Experience in DTS Migration and Metadata Management, Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
●Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS, ADHOC and Crystal Reports).
●Experience in tuning of any SCOM management packs currently deployed.
●Experience in implementing High availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and Implementing SQL Server clustering (Active-Active, Active-Passive), (Multi Node Cluster).
TECHNICAL SKILLS
Database: SQL Server 2000/2005/2008/2008R2/2012/2014/2016, Azure
Web Servers: IIS 4.0/5.0/6.0, WebSphere 5.0, Apache
Network Services: TCP/IP, DNS, HTTP, SMTP, DHCP, Load Balancers, Named Pipes
OS: Windows NT/Windows 2000/2003/2008/2008R2/2012/2016, Unix, Linux
Applications: Active Directory, Citrix, SharePoint 2007/2010/2013
Tools: Commvault, Red-Gate (SQL Compare, Data Compare, SQL Monitor), Idera SQL Permissions, Surround SCM, Sql Sentry One, Visual Studio, Auto Promoter, Business Intelligence Tools SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services)
Languages: Transact-SQL, ASP, VB, HTML, PowerShell 1.0/2.0, ISE, VB.Net, ASP.Net
PROFESSIONAL EXPERIENCE
CHS INC., Inver Grove, MN Mar 2019 - Present
Role: SQL SERVER DBA (Systems Engineer)
CHS Inc. is a Fortune 100 business owned by United States agricultural cooperatives, farmers, ranchers, and thousands of preferred stock holders.it owns and operates various food processing and wholesale, farm supply, Cenex brand fuel, financial services and retail businesses, and is a co-owner of Ventura Foods, a vegetable oil processor.
Provide direct support for Microsoft SQL servers, databases and related enterprise applications.
●Monitors and optimizes system performance based on Microsoft best practices.
●Install, configure, secure and maintain technical Dev, QA and Production environments.
●Configure and Integrate 3rd party applications and add-ons. Regular review of event logs and performance monitors through the creation of alerts.
●Implement upgrades, enhancements and fixes following established change management procedures.
●Work with Microsoft Support and other 3rd party vendors in resolution of support issues on as needed basis.
●Adheres to technical standards, procedures and techniques for the resolution of enterprise database problems to ensure maximum application availability and performance.
●Designed and implemented administrative tools to automate system maintenance, accounting, and performance monitoring using scripting toolbox (Mix of T-SQL, PowerShell and Windows Cmds).
●Troubleshooting Oracle 11g and 12c database and servers.
●Install and configure Oracle 11g and 12c.
●Adheres to technical standards, procedures and techniques for the resolution of enterprise database problems to ensure maximum application availability and performance.
●Participate in scheduled and unscheduled weekend/after-hours system maintenance and support. Performs rotational on-call duty.
●Troubleshooting and resolving day to day issues such as job failures, transactional log issues, blocking and deadlock issues, permission issues etc
Environment: SQL Server 2005/2008/2008R2/2012/2014/2016, T-SQL, SSIS, SSRS, SSAS, Visual Studio, Database mirroring, MS clustering, Solar winds (DPA), Thycotic Secret Server, Commvault.
Patterson Companies, St Paul, MN Oct 2018 – Mar 2019
Role: SQL SERVER DBA
Patterson Companies Inc. is a medical supplies conglomerate primarily in the business of Veterinary and dental products (ranging from x-ray equipment to consumable products, dental Consumables make up the biggest part of the dental industry). Since 2003, it has also distributed General medical rehabilitative devices like braces and wheelchairs.
●Responsible for 24 X 7 critical production support to all Production, development and DR servers.
●Managed 250 Database Servers – monitoring, working incidents, providing support.
●Automated regular DBA activities like Backup, Restore and DB refreshes using Commvault/ Windows PowerShell.
●Set up maintenance tasks such as database backups, consistency checks using Commvault and SQL Server.
●Configured and Administered Always-ON with 4 Node Replicas with Synchronous and Asynchronous and Log Shipping.
●Applying SQL server packs and hotfixes (cumulative updates) on SQL servers as per the requirements.
●Configured Many Windows /SQL Clusters Hands-On both A-A and A-P.
●Performed SQL Server service pack and Windows Service pack upgrades.
●Resolved Security related issues to logins, users and application roles and linked Servers.
●Configured and managed AlwaysOn in Cluster Environment.
●Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster Recovery and planning.
●Performed in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities
●Setting up connection string and connecting AZURE databases from locally installed SQL SERVER Management Studio for developers.
●Working with SSRS, SSIS and Service, T- SQL.
●Develop SSIS package(s) and archiving strategy for core workflow table data for clients using SSIS 2012 / 2014.
●Extensive SQL coding (functions, stored procs, tests scripts)
●Troubleshooting and resolving day to day issues such as job failures, transactional log issues, blocking and deadlock issues, permission issues, etc.
●Monitoring Jobs & Alerts, CPU utilization, Data & log file sizes, Space availability in Storage Devices.
●Ensure all databases are backed up to meet the business requirement (SLA) RPO and RTO.
●All schema migrations via SSMS and migrated data through SSIS package to SQL Azure.
●Troubleshoot performance issues such as locking, blocking and deadlocks on production databases using tools like SQL Sentry one, SQL SERVER DMV's.
Environment: SQL Server 2008/2008R2/2012/2014/2016, T-SQL, SCOM, TTP, SQL Sentry one, SSIS, SSRS, Surround SCM, Microsoft Visual Studio, SQL Azure, Auto promoter, Idera SQL Permissions, MS clustering, Lite Speed
AT&T, Richardson, TX Aug 2016 – Oct 2018
Role: SQL SERVER DBA
AT&T Inc. is an American multinational conglomerate holding company headquartered at Whitacre Tower in Downtown Dallas, Texas. It is the world's largest telecommunications company, the second largest provider of mobile telephone services, and the largest provider of fixed telephone services in the United States through AT&T Communications.
●Planned and created, configured, managed AlwaysOn Availability Groups on sql server 2014 and sql 2016.
●Azure cloud as DR.
●Implemented data partitioning to improve the performance of large tables, reducing contention and increasing availability of data.
●Successfully Upgraded SQL 2008 to SQL 2012/2014
●Designed, implemented, configured SQL 2005/2008/2008R2/2012 DEV/QA environment
●Tested and applied latest service packs and hotfix for SQL 2005/2008/2008R2/2012/2014/2016.
●Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
●Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Service.
●Wrote SQL Server queries using joins, sub queries and correlated sub queries to retrieve data from the database.
●Lead in charge of migrating over 80 databases from SQL Server 2005 to SQL Server 2008/2008R2 SSMA and native scripts.
●Managed a database migration by integrating an application database to the main CRM database designed on the contact/party role principle. As part of a team, successfully converted and migrated 170 tables, 1400 Stored Procedures, 400 scalar and table-valued functions and views to the new schema.
●Automated many Day to Day Activities using SSIS PACKAGES/Batch Files/Agent Jobs.
●Setup and Configure New Always-ON Availability Groups.
●Extensively configured log shipping and addressing issues with it during day and on-call.
●Create, deploy, configure and monitor complex ETL/SSIS packages
●Experience with performing DR tests periodically for mission critical application.
●Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2008, 2008R2 and 2012, and 2016 versions.
●Implemented the restores of SQL Azure Databases with a clear understanding of Backup retention periods of the Azure Databases as per their Service tiers.
●Automated scaling in Azure.
●Installed and configured SQL 2005/2008/2008R2 Report and Analysis Services.
●Created DDL triggers for auditing any DDL change in SQL 2005/2008/2008R2.
●Worked on various projects for DBA Hotline's customers such as capacity planning, application/system performance, installation, migration, database design, maintenance procedures, documentation.
●Determined hardware and software requirements for SQL Server version 2005 and 2008/2008R2.
●Managed databases on multiple disks using Disk Mirroring and RAID technology.
Environment: Windows 2003/2008/2008R2/2012, SQL 2000/2005/2008/2008R2/2012/2014, T-SQL, Replication, SSIS, SSRS, Database mirroring, Azure, MS clustering, Lite Speed, SCOM, NETIQ, HP SM7, Red Gate, Citrix, Oracle, OEM, ASM
Edward Lifesciences, Irvine, CA Jan 2016 - July 2016
SQL SERVER DBA
Edwards Lifesciences is the global leader in patient-focussed medical innovations for structural heart diseases, as well as critical care and surgical monitoring. Driven by a passion to help patients, the company collaborates with the world’s leading clinicians and researchers to address unmet healthcare needs, working to improve patient outcomes and enhance lives.
●Installation and configuration/Maintenance of SQL Server 2012/2008R2/2008/2005 in all Environments
●Configured SQL server 2012 always-on availability groups with one secondary replica on windows server 2012.
●Configured and maintained Transactional Replication for reporting and fixed replication issues on the servers.
●Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in DEV and Testing Environment.
●Rewrote old stored procedures (since they were inefficient after the migration from the DB2 mainframe) and created new ones to meet business requirements.
●Implement side by side Migration of databases from SQL server 2008r2 to SQL server 2012.
●Worked and involved on database pre-deployment and deployment DBA activities on production servers.
●Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
●Working different High Availability strategies like Log shipping, clustering (Active/passive).
●Worked on troubleshooting long running queries, blocking, deadlock issues and temp db issues
●Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis. Monitoring Event Viewer, SQL Error logs for errors.
●Monitoring all the SQL server alerts like disk space issues and SQL job failures and fixing the issues.
●Configured Report Server Using Report configuration manager in SQL server 2008R2 and involved in deploying, delivering of reports using SSRS and troubleshooting for any errors that occur in execution.
●Involved in Capacity Planning and adding new storage space as needed.
●Benchmarked and recommended various DBA tools (BMC Smart, DBArtisan).
●Responsible for monitoring and controlling the DB2 instance operation and resources.
●Database Security Maintenance & Creating Linked servers.
●Updating the SQL accounts & service account passwords prior to expiry on all the servers as per the audit requirement.
●Documenting all the issues encountered and all the important activities accomplished in the environment.
●Used Remedy ticketing tool in Resolving database related incidents and requests, resolving incidents within defined SLA's and responding to database related alerts escalations.
●Actively participated in the staff meeting and discussed the issues, goals.
●Worked on call 24/7 Support on weekly basis.
Environment: Windows 2003/2008/2008R2, SQL 2000/2005/2008/2008R2, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, SCOM, DB2, MS clustering, Lite Speed, MOM 2005/2007, SAN and Red Gate, Citrix, DB2, Oracle, ASM
Los Angeles Unified School District (LAUSD), Los Angeles, CA Aug 2015 - Dec 2015
SQL Server DBA/Developer
Second largest in the nation, the Los Angeles Unified School District (LAUSD) enrolls more than 640,000 students in kindergarten through 12th grade, at over 900 schools, and 187 public charter schools. The boundaries spread over 720 square miles and include the mega-city of Los Angeles as well as all or parts of 31 smaller municipalities plus several unincorporated sections of Southern California. All youth achieving, the mission of LAUSD.
●With over 900 schools under LAUSD, the data will be increased to 100’s of GB every year with new enrollments
●Configured Various Replication Types between Primary Server and Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2008 Environment to Test the Software.
●Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2008/2008R2.
●Designed DR plan, database backup and restore plan to point in time
●SQL Server performance statistics collection, Server monitoring and performance tuning using perfmon, SQL Server profiler and Index tuning advisor
●User account management and connection troubleshooting issues with the application team.
●Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
●Experience writing SQL queries, Stored Procedures, Triggers, Functions, Creating Tables, Views and Indexes.
●Trained members of the Network Access team to handle SQL Server account management.
●Audit and generate monthly management reports using third party tool
●Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security)
●Experience in installation, configuration and administration of SQL Server 2005/2008/2008R2 Technical Lead in charge of migrating SQL Server 2005 to SQL Server 2008/2008R2
●Formulated and monitored policies, procedures, and standards relating to database management
●Provided project leadership within a functional database area of specialization
●Manage and resolve trouble tickets for database-related issues submitted by customers.
Environment: Windows 2003/2008/2008R2, SQL 2000/2005/2008/2008R2, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, SQL LiteSpeed MS clustering, Lite Speed, SAN and Red Gate
L&T InfoTech, INDIA Jun 2012 – Dec 2014
SQL Server DBA/Developer
Description:
About Company: Larsen & Toubro Limited is a technology, engineering, construction and Manufacturing company. It is one of the largest and most respected companies in India’s Private sector.
●Wrote stored procedures to audit SQL servers, establish and enforce security auditing mechanism and performance tuning, optimization.
●Managed and Administered the SQL Server 2008/2005 production and Non-production Servers.
●Configured and maintained Transactional and Snapshot replication.
●Involved in installing, configuration and administration of log shipping, Replication and Mirroring based on business requirement
●Developed and implemented customized maintenance plans to meet the needs and keep up to date with the glitches and fixes for performances issues.
●Document custom database installation procedures, security standards based on environment and SLA and keep updating the inventory of servers periodically.
●Involved in Change Management, Problem management activities using BMC Remedy tool before implementing database changes in production.
●Created the custom backup and restore strategy for production, development and test environments.
●On-call support during off-hours on rotation basis.
Environment: Windows 2003/2008/2008R2, SQL 2000/2005/2008/2008R2, T-SQL, Replication, SSIS, SSRS, SSAS, SQL LiteSpeed, Database mirroring, MS clustering, Lite Speed, SAN
EDUCATION
Jawaharlal Nehru Technological University, Hyderabad, India Aug 2008 – Mar 2012
Bachelor of Technology – Electronics and Communication Engineering
Northwestern Polytechnic University, CA, USA Dec 2014 – Dec 2015
Masters - Computer Sciences
Contact this candidate