Heena

HEENA Mobile: - E-Mail:- PROFESSIONAL SYNOPSIS ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ ▪ 7+ years of experience in IT industry and 5 years of experience as a MS SQL Production Database Administrator Hands on experience on MS SQL Server 2005, MS SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2014, Windows Servers, Microsoft Azure, AWS and ITIL process knowledge Installation and configuration of SSIS , SSRS/Power Bi and SSAS. Developing packages ,managing rdls and cubes Excellent hands on experience on MS-Excel. Creation of various reports using Macros, Pivot and Lookup functions Creation of databases , Table and schemas. SQL Server and database security management, managing security by creating logins, users and assigning privileges Developed scripts for repetitive and time-consuming tasks using TSQL and Powershell Creation and monitor jobs for automating daily tasks like backups, checking integrity of databases, rebuild/reorganize indexes and update statistics Good experience in managing HA/DR of SQL Server, Technologies I have worked upon are Always ON, Log shipping, Mirroring, Clustering, Replication Respond quickly and effectively to day to day production & development operations and taking responsibility for resolving any issues Developed Backup strategies for Database Recovery, backing up database, backing up data files, log files, verifying the integrity of backup files and monitor failed backups Worked with Legato Networker tool for enterprise level backups and data protection Upgradation/Patching/Migration of MS SQL Server database Worked for migration of On-premises server to IaaS and IaaS to PaaS environment in AWS and Azure Resolve database performance issues, database capacity issues, etc by using different DMV’s and performance monitoring tools like Activity Monitor, perfmon and AppDynamics Performing the restoration on various environment Staging and production Good interpersonal, analytical and communication skills and Effective planner and works under tight schedules Have knowledge of other database platform like Oracle and AWS Aurora MySQL Work on Incident management, Change Management, Problem Management & SLA’s PROJECT EXPERIENCE ACCENTURE SOLUTIONS PVT LTD (December’17 to May’19) Designation : Infrastructure Senior Analyst Technologies : SQL2008R2,SQL2012/2014/2016,AWS,AZURE,Powershell, Legato Networker, Power BI Ticketing Tool : ServiceNow, Remedy Performance tool : Appdynamics Roles and Responsibility: ➢ Installing, Configuring and Administering SQL server2008, 2012,2014, 2016, Azure SQL and AWS RDS SQL. ➢ Designing Database and estimation of future requirements. ➢ Providing all guidance in all technical and function issues to team member whenever needed and resolving them ➢ Troubleshooting Performance Problems such as CPU utilization, Memory, I/O, Slow running queries, blockings ➢ Checking the general Health of the servers for identifying Bottlenecks ,monitoring of Scheduled jobs and backup failure ➢ Performing Database maintenance activities like Backups, Restoring, and Indexing etc. ➢ Creating Maintenance plans, SSIS packages and SQL Agent jobs for automation of the repetitive task. ➢ Monitoring the Disk spaces and backup failure on all the servers. ➢ Implementing SQL Standards and doing SQL audits ➢ Automating DBA tasks using PowerShell. ➢ Planning, administration, and implementation of Transactional Replication on MS SQL Server Databases and resolving issues related to it. ➢ Setting up HA Always ON for the production environments and resolving issues related to it. ➢ Work on many change request , Incident and Problem request in day to day operations to resolve issue after discussing with application teams ➢ Creation of Azure SQL and AWS RDS, Aurora, Dynamo DB and S3 bucket ➢ Backup restore from on premises to PaaS environments and IaaS to PaaS environments. ➢ Handling of various day to day issues on AWS and Azure DBs and issues related to Azure and AWS PaaS connectivity ➢ Knowledge of AWS and Microsoft Azure and keen to learn more on cloud technologies TATA CONSULTANCY SERVICES (April'16 to December’17) Designation : Infrastructure IT Analyst Technologies : SQL 2008R2,SQL2012/2014/2016, SSRS SSIS, T-SQL Ticketing Tool : ServiceNow, Remedy Performance tool : Microsoft Performance Dashboard Roles and Responsibility: ➢ Installing, Configuring and Administering SQL server 2008/2012/2014 ➢ Installing and configuring SSRS and managing the security of Reporting Server ➢ Responding and Resolving to SQL server related alerts ➢ Configured Mirroring and Failover Clustering and troubleshooted many issues related to HA ➢ Provide access on SSIS, uploading packages and creation of proxy accounts for users and troubleshooting SSIS related errors ➢ Decommissioning DB/Instance on demand ➢ Installation of Microsoft SQL Server 2008/2012/2014 on new Production and Test servers with latest Security updates involving Service Packs and Security patches and handling failed installation issues ➢ Creation of Linked server between SQL and ORACLE, DB2, TERADATA ➢ Responsible for managing Backup, Restore, and managing Maintenance plans and SQL agent jobs ➢ Troubleshooting Performance Problems such as CPU utilization, Memory, I/O, Slow running queries, blockings ➢ Extensively usage of tool like Windows performance monitor, event viewer, DMVs and profiler for issues troubleshooting HCL TECHNOLOGIES LTD. – IOMC (July’11-April’16) Designation Technologies Ticketing Tool Monitoring : Specialist : SQL 2000/2005/2008R2/2012/2014 ,T-SQL : ServiceNow, Remedy : BPPM, BEM,SCOM Roles and Responsibilities: ➢ Handling data centre operations and working with different support teams to resolve the Critical issues ➢ Monitoring the BPPM and SCOM tool and generation of incident tickets through those tools ➢ Creating daily/weekly/monthly quantitative and statistical business reports by using MS Excels data analysis program ➢ Working with Incident Management/Change Management/Problem Management as per ITIL process ➢ Handled around 700 instances of SQL Server 2000, 2005, 2008, 2008 R2 ,2012 and 2014 ➢ Took the reverse project transition KT for South Africa, Eurasia and successfully transformed the project into steady state without any escalations ➢ Maintain the environment up to date by updating with latest service packs, cumulative update and security patches ➢ Managing SQL Server Logins, Server roles, Database roles ➢ Creation of new databases, planning the location of data and Transaction log files on disks ➢ Experience with providing high availability and disaster recovery service like clustering, mirroring, log shipping and Transaction Replication ➢ Managing Indexes fragmentation by reorganizing and rebuilding with ONLINE in Microsoft Soft SQL 2008 server. ➢ Migration of SQL server from Virtual box to Physical box with wide infrastructure ➢ Importing/Exporting and attaching/detaching DBs as per user request ➢ SQL server auditing based on the parameter provided by the customer TECHNICAL EXPERTISE AND CERTIFICATIONS • • ITIL Foundation 2011 Certified. Microsoft SQL SERVER 2016 (70-764) Certified ACADEMIC CREDENTIALS • • MCA from MDU with 75 % Bachelor of Computer Application from MDU in 2011 with I Div 81.60 % • 12th from HBSE, Sonipat in 2008 with 82.80 % • 10th from HBSE in 2006 with 81.80 % PERSONAL DETAILS Date of Birth: 2nd Sep 1990 Languages: English, Hindi Address: C/O LifeX Toldbodgade, 61C 2Sal, 1253 København K Contact no: - I hereby assure you that all the information given above is correct to the best of my knowledge and belief. (HEENA)