Resume

Sign in

Sql Server Data

Location:
Bellevue, Washington, United States
Posted:
November 09, 2018

Contact this candidate

Resume:

Karunakar Kotha

LinkedIn

Professional Summary

More than 8 years of IT experience in the field of Information Technology that includes analysis, design, development and testing of Database applications. Excellent in database performance tuning, database design, high availability and disaster recovery.

Very good understating of SQL and NOSQL Databases Professional experience in Database Migration /Database upgrade and maintenance of SQL and NoSQL databases this includes Big Data Ecosystem experience.

Experience in dealing with SQL components like SQL profiling, extended views, DMV’s, replication, log shipping and always on, Good understanding/knowledge of Hadoop Architecture and RDBMS and No SQL Technologies Cassandra, MongoDB, Big Data.

Technical Skills

Databases

MS SQL, MySQL, MongoDB, Elasticsearch

Visualization

Tableau, MS Excel, Power BI

Cloud Technologies

AWS, Microsoft Azure

Tools

Sentryone,Solarwinds,CommVault,Idera,Foglight,

Big Data/Hadoop

Hadoop 1x/2x(Yarn), HDFS, Map Reduce, Hive, Pig, Sqoop, Flume, Kafka, Spark, Storm, Zookeeper, Oozie, Ambari

Programming/Scripting Languages

Python, SQL, Pig, Hive, PowerShell

Platforms

Windows. Unix

Professional Experience

Vertafore May 2015-Present

Sr Database Administrator

Responsible for maintaining and administrating SQL databases /Mongo databases. Initiated a lot of fine tuning mechanisms to tune the database as well as the queries to complete a set of given jobs or tasks in optimal time.

Involved in estimation and migration SQL instances from on premises to AWS EC2 Instances, building, and deploying a multitude applications utilizing AWS stack (Including EC2, S3 and EMR), focusing on high-availability, fault tolerance, and auto-scaling.

Responsible for database partitioning, Index tuning, database performance, actively involved in all database architectural designs and provide the best Microsoft standards to implement.

Responsible for Database Performance Tuning and Optimization (PTO) using SQL native monitoring and using third party tools using Sentryone, Foglight and SQL compliance manager.

Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data, Designed and deployed SSIS packages in production environment to implement business logics, Create, deploy, configure and monitor complex ETL/SSIS packages.

Rewrote queries, stored procedures, and created missing indexes for better performance, Monitored and fixed nightly maintenance; optimized and improved DTS and SSIS packages.

Configured and implemented high availability features log shipping, replication and Always on, responsible for managing Always on nodes and instances running on multiple datacenters. Identified the long running queries, complex dynamic queries and modified to get the best execution plan, duration and stats.

Implemented the replication, sharding and configured multiple routers to access the application, responsible for identifying and fixing the performance issues for long running queries.

Responsible for provide 24 X 7 on call critical production support to all 100 Production databases, shared domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Esurance, San Francisco July 2012 – May 2015

Database Engineer

Implementation of fail over clustering. Implementing warm stand by servers and raid 1 –5 technologies.

Interacting with Design and implement database logical and Physical Schemas.

Database designing using Erwin Data modeling tool.

Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.

Created and monitored database maintenance plans for checking database integrity

Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).

Responsible for database backups & restoration and scheduling backup strategies.

Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.

Running DBCC consistency checks, and fixing data corruption in user databases.

Planning, implementing and troubleshooting Snapshot and Transaction Replication.

Prepared Estimates for Database, table size growth.

Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.

Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).

Continuously interacted with users to gather the business requirements.

Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.

Worked with BCP and DTS to load text files from heterogeneous data sources to SQL Server. Maintaining the data, database backups and restoration, backup strategies, scheduling backups.

Created and managed the database triggers and subprograms.

Involve in the creation of Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Installed, configured and administrated SQL server 2005, SQL server 2008 R2 and 2012(Database Engine).

Installed, configured and administrated SSIS (SQL server 2005/2008/2012).

Installed, configured and administrated SSRS (SQL server 2005/2008/2012).

Setup of SQL services clustering

Microsoft Corporations, Redmond, WA January 2012 to July 2012

Sr Database Administrator

Installing and Configuring SQL Server 2012 Denali, Supporting the business 24*7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.

Worked closely with Microsoft SQL Server Denali core development team for any issues and bugs to report, Responsible for developing new databases, testing and analyzing database applications considering users’ suggestions and requirements.

Implementing and configuration of SQL 2008/2012 servers Database Engine, Reporting Service, Integration Service. s. Database Optimization and Performance tuning in very large database environment. Re-design the query for achieve the optimal performance. Index optimization (Check the index usage and fragmentation level, defrag indexes, check statistics, fill-factor), backup and restore of databases.

Restore the database on the different dev and test environments. Mange the version of SQL server code in the environment using Team Foundation system. Very good experience of using TFS on day to day tasks-SQL development involves design and coding of stored Procedure, Tables, Indexes, constraint, SSIS packages for ongoing support for the projects.

Zinio Systems, San Francisco, CA September 2011- December 2011

Data Administrator/Developer

Installed and configured SQL Server 2008 R2, Developed SQL scripts for maintaining administration tasks.

Involved in database design, database standards, T-SQL code reviews, Configured Active/Active and Active/passive SQL Server Clusters, Configured transactional and snapshot replication

Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats. Responsible for SQL server Edition upgrades and SQL Server patch management.

Supporting the business 24*7, maintaining 99.999 uptimes, depending on the application and business SLA requirements. Created a mirrored database on the report server using Database Mirroring with High Performance Mode.

Created database snapshots and stored procedures to delta load data from the snapshot database to the report database.

Created SSIS Packages to migrate slowly changing dimensions, Involved in data modeling for the application and created ER diagram using Erwin.

Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

Trouble shooting and supporting all user problems by using SQL server profiler and network traces, windows logs etc.

Hands on experience on SQL Server Data Collector. Change Data Capture (CDC) to capture the events and changes.

Migrating DTS Packages to SSIS Package.

Monitoring the event logs and server error logs for troubleshooting.

GE Money (London, UK) Jan 2009 – August 2011

SQL DBA

Installation, configuration of MS SQL Server 2000, 2005 for development and testing purpose.

Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration. Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers. Created and monitored database maintenance plans for checking database integrity• Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).

Responsible for database backups & restoration and scheduling backup strategies.

Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.

Running DBCC consistency checks, and fixing data corruption in user databases.

Planning, implementing and troubleshooting Snapshot and Transaction Replication.

Prepared Estimates for Database, table size growth, Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.

Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber),Expertise in Security Issues such as creation and granting permissions on various Objects.

Monitoring the event logs and server error logs for troubleshooting, Performance tuning, finding the CPU Bottlenecks, SQL Server Bottlenecks. Performance tuning in Database level, T-SQL level and operating system level.

Upgraded all the servers from 7.0/2000/2005. Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.

Responsible for SQL server Edition upgrades and SQL Server patch management.

Supporting the business 24*7, maintaining 99.999 uptimes, depending on the application and business SLA requirements.

Trouble shooting and supporting all user problems by using SQL server profiler and network traces, windows logs etc.

Mahindra Satyam Computers, Hyderabad India Jan 2008 – Jan 2009

SQL Developer / SQL Server DBA

Upgraded all the servers from 7.0/2000/2005. Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.

Responsible for SQL server Edition upgrades and SQL Server patch management.

Analysis and Design, Design and implement database logical and Physical Schemas, Database designing using Erwin Data modeling tool. Continuously interacted with users to gather the business requirements. Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.

Install and Configure SQL database server 2000 and 2005 for development and production environment for multiple customer. Involve in the creation of Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality, Scheduled jobs for backup, and created alerts for error reporting.

Involved in testing, bug fixing and documentation for the project, Estimating of Table sizes and Record sizes.

Responsible for database tuning using normalization and application tuning. Maintenance of Development, System test, Assemble test and Integration Servers and databases. Creation of Development and Production environment. Backup recovery schedules, Backup scripts, BCP. Query tuning, Index Tuning and performance tuning. Integration of Third party Databases.

Educational Qualification

Bachelor’s Degree in Electrical and Electronics Communication, JNTU, Hyderabad

Certificate in Cloud Data Management and Analytics, University of Washington,Seattle

Certificate in Big Data Technologies, University of Washington,Seattle

Big Data Projects:

https://www.slideshare.net/karunakar09/bigdatasp17finalprojectteamdhawks-170*********

https://www.slideshare.net/LeoSalemann/twitter-sentiment-analysis-during-an-episode-of-snl

Phone: +1-704-***-****

Email: ac7m83@r.postjobfree.com



Contact this candidate