Resume
G Ashwini E-Mail: ashwinigamjala@gmail.com
D/o Muthyam, H.no: 3-47, Rampur, Cell: 08910016598
Narsapur(G) Mandal, Nirmal Dist, Telangana - 504306
--------------------------------------------------------------------------------------------------------------------------------------------
Profile:-
⮚ Resourceful Database Administrator able to respond to a wide range of challenges with a
focused and creative approach. Highly effective at problem solving and decision making.
4 years of progressive IT experience.
Skills Summary:-
⮚ Good knowledge in Microsoft SQL Server (2008, 2012, 2014, 2016, 2017 & 2019) Database
Administration and have knowledge on Azure SQL Servers.
⮚ Expertise in Database Administration on Production Servers with server configuration,
performance tuning and maintenance with outstanding troubleshooting capabilities.
⮚ Strong technical background along with the ability to perform business analysis and write
effective documentation and specifications.
⮚ Administering SQL Server High Availability and Disaster Recovery strategies.
⮚ Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT
ETL operations.
⮚ Experience in using DMV and dynamic management functions for finding out long
running queries.
⮚ Experience in Disaster Recovery Planning and Security Management operations.
⮚ Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster
recovery and planning.
⮚ Having hands on experience in DR processes including Log shipping and Database
Mirroring.
⮚ Troubleshoot performance problems, fine-tuning of databases and index Analysis.
⮚ Worked on SQL Server 2019/2017 migration from SQL Server 2014, 2012, 2008 &
2005.
⮚ Experience on 64 bit SQL Server 2019, SQL Server 2017, SQL Server 2014, SQL Server
2012 / SQL Server 2008 R2 systems and MSCS Configurations.
⮚ Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and
Application support.
⮚ Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created
DTS package for data transfer between the two environments.
⮚ Experience in supporting Very Large databases (VLDB) and troubleshooting the
problems.
⮚ Strong experience in mentoring team members and writing documentation.
⮚ 24 X 7 Production Database on Call Support
Public
A good team player with excellent communication, analytical and inter-personal skills
Current Engagement: -
Working as SQL Database Administrator in HCL from 15th Mar, 2021 – Till
Previous Engagement: -
Worked as SQL Database Administrator in Tata Consultancy Services. under payroll of FORAY
SOFTWARE PRIVATE LIMITED from 02-September-2020– 11th March 2021.
Total Experience: -
4years
Technical Expertise: -
Databases: MS SQL Server 2017, 2016, 2014, 2012 & 2008
Database Administration of MS SQL Server 2016, 2014, 2012, 2008 &
DBA:
2005
Operating
Windows 2016, 2012, 2008 Advanced Server, NT & Windows 9x
System:
Tools: Backup Utility, BI, SSIS
Educational Qualification: -
⮚ Master of Computer Applications (MCA) from Osmania University, Hyderabad, Telangana.
⮚ Bachelor of Science (B. Sc.) from Kakatiya University, Telangana.
⮚ Intermediate (MPC) from S.S.R Junior College, Board of Intermediate, Telangana.
Public
Project 1: -
Project Title : SQL Server DBA Operation Support
Client : US
Role : SQL Server DBA
Environment : MS SQL Server 2019,2017, 2014 and 2012, Win Server 2016 & 2012, Citrix tools
Duration : Mar, 2021 – Till
Job Responsibility:-
⮚ 24 x 7 Production Database on Call Support.
⮚ Restoring database from production to development and test servers as per requests.
⮚ Created and maintained users and user groups
⮚ Performed daily backups and developed recovery procedures.
⮚ Creating always-on groups and adding the DBs to AG groups based on the requirement.
⮚ Checking the health of AG databases.
⮚ Checking of the database consistency using DBCC commands to minimize complexity.
⮚ Monitoring the SQL Server and OS lever issues by setting Pefrmon counters.
⮚ Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
⮚ Tuned the SQL queries using performance monitoring tools. & Involved in tuning the database.
⮚ Capturing and tuning the long-time running query’s thru Use full DMVS.
⮚ Involved in Index operations (Rebuild & Reorganize) and database maintenance.
⮚ Maintaining and Managing the Database Mirroring & Replication.
⮚ Maintaining the issues in ticketing tools.
Project 2: -
Project Title : Cymer SQL Migration
Client : US
Role : SQL Server DBA
Environment : MS SQL Server 2017, 2016, 2014, 2012 and 2008, Win Server 2008,2012 & 2016,
Citrix tools
Duration : Sep, 2020 – March 2021
Job Responsibility: -
⮚ Migrating the databases from lower versions (SQL Server 2008, 2012 and 2014) to SQL Server 2017.
⮚ Migrating all Jobs from cross domains
⮚ Migrating all users from cross environments by contacting the AD teams
⮚ Migrating DB mail profiles, operators.
⮚ Migrating all SQL Alerts,
⮚ Migrating Linked servers
⮚ Checking the health of AG databases.
⮚ Checking of the database consistency using DBCC commands after migration.
⮚ Capturing and tuning the long-time running query’s thru Use full DMVS.
⮚ Involved in Index operations (Rebuild & Reorganize) and database maintenance.
Public
Project 3: -
Project Title : HPN
Client : US
Role : SQL Server DBA
Environment : MS SQL Server 2016, 2014, 2012 and 2008, Win Server 2008 & 2012, Citrix tools
Duration : Sept 2020- March 2021
Job Responsibility: -
⮚ 24 x 7 Production Database on Call Support.
⮚ Restoring database from production to development and test servers as per requests.
⮚ Created and maintained users and user groups
⮚ Performed daily backups and developed recovery procedures.
⮚ Creating always-on groups and adding the DBs to AG groups based on the requirement.
⮚ Checking the health of AG databases.
⮚ Checking of the database consistency using DBCC commands to minimize complexity.
⮚ Monitoring the Sqlserver and OS lever issues by setting Pefrmon counters.
⮚ Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
⮚ Tuned the SQL queries using performance monitoring tools. & Involved in tuning the database.
⮚ Capturing and tuning the long-time running query’s thru Use full DMVS.
⮚ Involved in Index operations (Rebuild & Reorganize) and database maintenance.
⮚ Maintaining and Managing the Database Mirroring & Replication.
⮚ Maintaining the issues in ticketing tools.
(G Ashwini)
Public
