Database Administrator Team Member
Resume:
Harish Kommineni
Email: ***************@*****.***
Cell no: +1-832-***-****
LinkedIn: https://www.linkedin.com/in/harish-kommineni-98b85015/
Professional Summary:
9+ Years of experience in IT working extensively in multiple roles on SQL Server Database Administrator (MS SQL Server 2019/2017/2016/2014/2012/2008R2/2005), Azure, Snowflake and Azure cosmos DB.
Expertise in designing and developing database solutions for industry verticals like health care (Insurance, Claims, Enrolment, Plans & Benefits) Retail and oil gas domains
Azure/Snowflake:
Working as Cloud Administrator on Microsoft Azure, involved in configuring virtual
machines, storage accounts, resource groups.
Managing day to day activity of the cloud environment, supporting development teams with
their requirements.
Provide technical guidance on building solutions using Azure IAAS/PAAS and other services.
Discussing with architect on the data modelling to create appropriate tables.
Involved in designing the Azure data warehouse.
Analysed the code in case of any errors and modified the scripts and tested the functionality of the piece of code.
Participated in daily project sprints, responsible to define user stories and tasks.
Planned and executed Sprint planning and release managements in Devops.
Yearly performing IRM Password change activities on AZURE IAAS and PAAS.
Experienced in creating Cosmos Databases, containers and items.
Managing Throughput and Request units, Consistent levels.
Monitoring the Azure cosmos logs and Analysed the logs fix the issue in timely manner.
Preparing Monthly dashboard report on Cosmos Database.
Experienced in Snowflake database warehouse support,
Implement Client -approved physical database administration solution and procedures.
Create and maintain Database / warehouse / User / Schemas/ File format/ Stage in Snowflake.
Implemented RBAC in snowflake and used these principles to apply Data Protection Laws.
Implemented Snowflake database security changes as per requirements.
Implemented Network Policies for managing network configurations to Snowflake service.
Implemented Dynamic Data Masking policies for Column-Level Security.
Worked on performance tuning issues and provided solutions to users to resolve the issues.
Worked extensively on snowflake’s data sharing to share the data to non-snowflake customers.
Used cloning and time travel to retrieve the dropped data in case of abnormalities.
Create Resource Monitor, Managing resource monitoring Credit Usage for Warehouses.
Education:
Master of Computing Software technology from Robert Gordon University, UK 2010.
Bachelor of Computer Science engineering from JNTU University, India 2008.
Certifications:
Azure Data Engineer Associate (DP-203)
Azure Architect (AZ-300)
Microsoft Certified Technology Specialist
ITIL Foundation Certificate in IT Service Management.
Technical Skills:
Programming : C, SQL,Python and Power shell
OS Platforms : Windows and Linux
CLOUD Technologies: Microsoft Azure, SQL Data warehouse, Azure Log analytics
Databases: SQLServerDatabaseAdministrator (MSSQLServer 2019 to 2005), Azure SQL,Azure Cosmos DB
Tools : TSM, DD BOOST for SQL Server, Jenkins, UiPath, SSIS, SSAS, SSRS, Power BI, Microsoft Azure
Professional experience:
Client: Walgreens
Senior Database Engineer, Houston, Texas July -2022 to till date
SQL Server administration including:
Hands on experience in maintaining application databases. Involved in configuring Replication, Log Shipping, Mirroring, and Cluster.
Experienced in creating Cosmos Databases, containers and items.
Managing Throughput and Request units, Consistent levels.
Monitoring the Azure cosmos logs and Analysed the logs fix the issue in timely manner.
Preparing Monthly dashboard report on Cosmos Database.
Involved and lead the SQL migrations and patching activates on standalone and cluster servers
Good understanding of SQL server architecture. Experience in performing regular Backups and scheduling tasks.
Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and Profiler.
Hands of experience on Databases Migrations.
Performance Tuning, Query Tuning, SQL Profiler and Performance Counters
Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 to 2019.
Hands on Experience as SQL Server Database Administrator with proven track record of Administration experience, competent team member and technical skills.
Designing databases and ensuring their stability, reliability, and performance.
Design, create, and implement database systems based on the end user's requirements.
Onsite-offshore coordination, Service Management and client coordination.
Managing security, which includes monitoring and controlling access through Active Directory Security Groups and validate the access control list to avoid unauthorized access and IP compliance.
Configuring the audit alerts to capture the failed login attempts and monitor the unauthorized user access to the databases and remediate them.
Configuring/Monitoring/Troubleshooting Always On, database mirroring, log shipping, Mirroring, replication and Cluster.
Closely worked with business clients to understand priorities and impact to provide timely and accurate reports to management and end-users.
Analysed the code in case of any errors and modified the scripts and tested the functionality of the piece of code.
Participated in daily project sprints, responsible to define user stories and tasks.
Client: Optum (UHG)
Senior Database Engineer Aug -2021 to May 2022
SQL Server administration including:
Hands on experience in maintaining application databases. Involved in configuring Replication, Log Shipping, Mirroring, and Cluster.
Experienced in creating Cosmos Databases, containers and items.
Managing Throughput and Request units, Consistent levels.
Monitoring the Azure cosmos logs and Analysed the logs fix the issue in timely manner.
Preparing Monthly dashboard report on Cosmos Database.
Involved and lead the SQL migrations and patching activates on standalone and cluster servers
Good understanding of SQL server architecture. Experience in performing regular Backups and scheduling tasks.
Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and Profiler.
Hands of experience on Databases Migrations.
Performance Tuning, Query Tuning, SQL Profiler and Performance Counters
Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 to 2019.
Configuring/Monitoring/Troubleshooting Always On, database mirroring, log shipping, Mirroring, replication and Cluster.
Closely worked with business clients to understand priorities and impact to provide timely and accurate reports to management and end-users.
Worked on evaluating the issue and bugs tracked during the testing phase for remediation.
Provide technical guidance on building solutions using Azure IAAS/PAAS and other services.
Analysed the code in case of any errors and modified the scripts and tested the functionality of the piece of code.
Participated in daily project sprints, responsible to define user stories and tasks.
Professional experience:
Projects:
Client: Chevron
Tech Lead DBA, March 2017 - Aug 2021
Tech-Mahindra, India
Responsibilities:
Lead for team of 12, onsite-offshore coordination, Service Management and client coordination.
Experience in installation, configuration, upgrading & administration of MS SQL Server 2005 to 2017.
Ensure quality of the reports prior to releasing to production.
worked on SSRS to develop various dashboards and reports.
Configured Reporting services in Microsoft SQL Server versions and changing password change activity as per yearly audit.
Supporting database of business critical ETRM application (Solarc Right Angle S11/S15, GARM, Energy credit, Biztalk, DMT).
User Management (Creating users, assigning profiles\roles depending on user’s specification according to the organizational policies)
Managing security, which includes monitoring and controlling access through Active Directory Security Groups and validate the access control list to avoid unauthorized access and IP compliance.
Configuring the audit alerts to capture the failed login attempts and Monitor the unauthorized user access to the databases and remediate them.
Configuring/Monitoring/Troubleshooting Always On, database mirroring, log shipping and replication.
Involved in trouble shooting and fine-tuning of application database and windows environments for its performance and concurrency.
Providing Technical Support on IIS Web servers and solutions as per the Client standards and guidelines.
Implement custom configuration of applications and operating procedures on the servers by coordinating with 3rd party application development consultants.
Closely worked with business clients to understand priorities and impact to provide timely and accurate reports to management and end-users.
Involved in assessing and provided technical advice and recommendations to plan for new project and initiatives to enhance existing database applications/system performance and avoid security vulnerabilities.
Validation of Hot Fix release process of application and database changes in all environments (Non-production(s) and Production).
Worked on evaluating the issue and bugs tracked during the testing phase for remediation.
Preparation of documentation as per client defined process and quality standards.
Interacting with the support teams so that the database environment is always available without any downtime
Secure the database environment following the Information Security and Standards of client.
Automating Administrative Tasks by creating alerts, jobs, scheduling jobs.
Perform Health check on the database servers frequently.
Develop and test a backup and restore strategy.
Perform Health check on the database servers frequently.
Trouble shooting SQL server Performance Issues.
Provide 24X7 on-call support.
Projects:
Client: Microsoft:
Support Lead DBA July-2016 to March -2017
Tech-Mahindra, India
Responsibilities:
On this Project, I worked as SQL DBA, performing DBA’s activity like Installation, Configuration, Backup & Recovery, System Monitoring, System Operations. I also worked on new RDBMS PostgreSQL. I was responsible for complete relocation activities for both MSSQL and PostgreSQL databases. I also worked in Change Management, Incident Management for handling Change requests and Incident Management Process adhering to SLA policies.
As a team member, was responsible for
Analysis of the specifications provided by the clients.
Provide L3 level support for Microsoft Applications within VLIT project.
Investigate and resolve issues within SLA at L3 level.
Investigate RCA and create PRs to address the BUGs identified in Applications.
Configure and Troubleshoot Log-Shipping and Replication issues.
Database management and maintenance.
Testing various CRs for BUG fix, Code fix and enhancement of Application functionality.
Also involved in monitoring tool SCOM, installation, configuration and maintenance.
Provide On-Call Support.
Create PDCs for Production data changes.
Projects:
Client: Nestle
Senior Developer/DBA Sep-2013 to July-2016
Wipro, India
Responsibilities:
Developing, Maintaining, Migrating and Upgrading from SQL 2005 to SQL 2008r2 to 2012 backups and restoration of the Production databases.
Share knowledge by effectively documenting work.
Manage security of database structures and corporate data held within databases.
Use of DTS/ SSIS package to extract data from External data source to SQL.
Capacity Planning of the Servers, Monitoring the CPU, Memory utilization, Performance tuning and Disk Spaces on servers.
Check the Integrity of the databases and tables, monitoring the event logs.
Configuring the Database Mail, Monitoring Replication, Mirroring and Log Shipping.
Contact this candidate