Manpreet Kour
Pune
Summary
Top-notch SQL database administrator with 5.5 years background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery,end to end migration,automation using PowerShell,HADR solutions such as Always On and Log Shipping. Collaborative and dedicated to improving and optimizing database performance.
Overview
6
6
years of professional experience
Work History
SQL Server Database Administrator
Barclays
01.2023 - Current
- To assist the customer and Incident Management team (24/7 support) to drive down the number of Incidents by identifying the root cause. Perform Post Incident Review on major incidents.
- Managing end to end migration for Tech Debt projects and migrating SQL server from version 2008 to 2014,2019,2022 as per project requirements. Support for GO-LIVE activities
- IBM Tivoli Data Protection manage for DB Backup and restoration, point to time recover.
- SSIS,SSRS and SSAS installations on application and SQL server boxes
- Decommissions of legacy databases and instances
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
- Analyzed business reports for prompt communication, follow-up and ongoing support.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment
- Designed and implemented TSQL queries for reporting and complex solution development.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Database Administrator
Amdocs
01.2022 - 01.2023
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Handling SSIS long running jobs and focused on index rebuild and performance issues.
- Performance tuning for application long running jobs.
- PROD to Stage DB refresh activity,index rebuild,dbcc,update stats etc covering up maintenance of databases
- Automated various DB tasks like Health check reports,Long running user queries,DB lag between always on primary and secondary server and so on
- Troubleshooting P1,P2 issues with Azure portal analysis (VM,Gateway,Analysis server etc)
- Cube restores using SSAS backup and restores
- Deploying code for ETL and DB servers every 15 days during code push for Stage and production.
App/Cloud Support Analyst
Accenture
08.2018 - 12.2021
- Experience as database administration for very large and complex databases in SQL Server 2016,2012,2008,SQL server 2008 R2 and 2005.
- Expertise in handling DBA related tasks on production servers with server configuration,performance tuning and maintenance with outstanding troubleshooting capabilities
- Strong technical background along with ability to perform analysis and write effective SQL queries and scheduling them via agent jobs
- 24*7 Production database on call support
- Implementation of SQL logins,roles and authentication modes as part of security policies for various categories of users,Rebuild indexes,SQL patching,configuring Always On,Log-Shipping
- Managing multiple projects with a count of 100+ servers
- Automating day to day tasks like health check reports, weekly reports using PowerShell
Education
Master of Science - MCA
Indira Gandhi Delhi Technical University For Women
Delhi, India05.2018
Bachelor of Science - BCA
Panipat Institute of Engineering And Technology
Panipat, India06.2015
Skills
- SQL Server Adminstartion
- Performance Tuning
- Capacity Planning
- Backup and Recovery
- Disaster Recovery
- Migration
- Always On, Log-Shipping
- ServiceNow
- T-SQL
- Azure
- PowerShell
- End-User Training
Accomplishments
.
- Automated processes to reduce workflow by 50-80 hours monthly for multiple tasks
- Received certification from client for outstanding performance in Amdocs within 6 months of joining the organization.
- Rewarded Value award at SmartOps India AT&T Townhall,under the category "We always deliver value to our customers!"
- Azure fundamentals certified AZ-900
- Microsoft training in-house for 5 days workshops in PowerShell and 3 days in Azure fundamentals
- Received 19 global recognitions for migrating more than 12-15 applications end to end that were part of Tech Debt in span of an year
Timeline
SQL Server Database Administrator
Barclays
01.2023 - Current
Database Administrator
Amdocs
01.2022 - 01.2023
App/Cloud Support Analyst
Accenture
08.2018 - 12.2021
Master of Science - MCA
Indira Gandhi Delhi Technical University For Women
Bachelor of Science - BCA
Panipat Institute of Engineering And Technology