Position: Database Aminstrator
Category: SQL
English level: fluent
Years of experience: 6

Help in implementation, creation and management of multiple applications for back end and website.
2014–2016
SQL DBA Consultant/ Database Engineer
Responsibilities:
Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
Implemented Extended Events to replace custom scripts for monitoring & troubleshooting issues
Design & Implemented In-memory tables in 2016 OLTP database server
Use of Query Store feature for monitoring performance of database systems
Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc.,
Have Good understanding & experience on different RAID levels
Good knowledge on Networking concepts and Protocols
Experienced in Securing data with Dynamic Data Masking, Always Encrypted, Row-level security
Configuring database instances for Development and Testing purpose
Design, implement and administer databases on MS SQL Server 2014/2016 platforms for OLTP
Experienced in providing analysis on High availability/Disaster recovery & scalability
2016–2020
SQL Server DBA/ Consultant
Responsibilities:
Responsible for schema & Data Migration using TFS, sqlPackage & Red Gate tool from Dev, Test, and QA to Prod Environment
Managed Final Builder configuration for database deployments to DEV/TEST
Use of Dacpac & SSDT for automated/Manual database deployments
Experienced in designing database and code with proper Isolation level to avoid locking and deadlock scenarios.
Implemented Columnar Data Store Index for faster response
Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics
Proficient in analyzing I/O, CPU, Memory issues and providing fix using Ignite tool and DMVs
Troubleshooting log file space issues, tempDb contention
Good knowledge on Continuous Integration and Continuous Delivery Pipeline for 3-tier Application