• Over 14+ years of IT experience in Database Administration and Support of MS SQL Server 2016/ 2012/2008R2/2005 in Production, Test, Development Environments.
• Experience in implementing high availability using Server clustering (Active-Active, Active-Passive) in Windows 2008/2012/2016 environment.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008-2016.
• Experience in Disaster Recovery Planning.
• Migration experience from MS SQL Server 2008 to 2016.Along with Datacenter move.
• Master in performing database files management, backup/restore, security management, Database Mirroring, data integration, data compression and synchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Extensive experience in Capacity Management and assigning storage for cloning environment.
• Extensive experience in setting up Cloning environment and troubleshooting issues.
• Expert in configuring/Migrating SQL server 2012 – 2016 with Always on.
• Hands on experience in Metal 3.1 and Informatica 9.0/9.1 a data warehouse tools used in EDW for the ETL flow.
Cloning, Mirroring, Clustering, Replication ,Always ON, Web Services, ETL, SSIS, SSRS, SSAS, Siebel 7.7 , Informatica ,Metal, ,SQL Azure. | T-SQL, PowerBuilder, Power Shell, VB Script, Python ,Jupyter , Spyder,Anaconda,Java,C/C++ |
- Increased overall database performance, reduced fragmentations, and minimized failures by implementing various upgrades and migrations strategies.
- Performed Datacenter migration from scratch in minimal downtime.
- Consolidating environments to save cost on licensing.
- Migrated all SQL servers from one datacenter to another with minimal downtime.
- Planning and migrating data to another storage which is optimal and cost saving.
- Maintained, restructured, and optimized databases by removing performance bottlenecks, devised and integrated solutions.
- Troubleshot and resolved technical issues; alleviated bottlenecks to ensure optimal functionality
- Develop and monitor standards and procedures for database environment Perform database software installs, configurations, patches, and upgrades
- Performance management of the application using various tools like New Relic and Data Dog.
- Created alerts to keep the environment up and running 24 /7 .
- Performance tuning for the SQL server queries and optimizing.
- Developing scripts for refreshing Test environment with production data.
- Effectively migrating SQL server MDS environment to MDS 2016 which effectively improved performance of the systems.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Tested programs and databases to identify issues and make necessary modifications.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Planned and implemented security measures to safeguard vital business data.
- Developed and implemented performance improvement strategies and plans to promote continuous improvement.
- Led projects and analyzed data to identify opportunities for improvement.
- Working on planning Azure migration for section of databases .
- Implementing high availability using Server clustering (Active-Active, Active-Passive).
- Setting up HLB for IIS servers for load balancing using Active – Active clustering.
- Implementing alerting systems for the applications
- Creating customized monitoring tool using PowerShell scripts.
- Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
- Incident Management and problem management
- Performed DBCC utilities and fixed data corruption in application database
- ·Monitored and modified Performance using execution plans and Index tuning.
Ensured the packaging/processing deliverables are completed on time. - ·Automation in monitoring servers and databases.
- Setting up cloning & mount points for the application.
- Upgrading SQL server katmai to CTP5, CTP6 , RTM
- ·Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
- Setting up environments with cloning infrastructure and troubleshooting
- Work with business to accommodate maintenance window with minimal downtime due to application criticality
- Build Support for Dev teams to triage build issues.
- Create schedules for applying builds and refreshing the environment with the production backups.
- Consult production team to understand the risks before any release.
- Tracking issues that come across during the build through product studio.
- Managing the source code control aspects of windows releases.
- Installing and configuration of SQL Server and Siebel 7.5.2
- Applying the development code to test environment.
- Restoring the Databases after every Phase of testing.
- Configuration of Siebel environment and setting up Siebel gateway, Enterprise servers.
- Troubleshooting the Job related, Siebel administration and IIS related issues.
- Upgrading the Siebel Database using Siebel configuration tools
- Upgrading SQL 2000 to Yukon (SQL 2005)
- Data science ,University of Washington
- Azure Database Administrator Associate (Microsoft)
Training :
- Completed training in DP-050T00 Migrate SQL workloads to Azure
- Completed training in DP-100T01 Designing and Implementing a Data Science Solution on Azure
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score
could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
- Personalization
- Strong Summary
- Target Job
Resume Overview
School Attended
- BLDE A's
Job Titles Held:
- Senior Database Administrator
- SQL DBA /Module Leader (Client Microsoft)
- Siebel Administrator (Client : Microsoft)
Degrees
- Bachelor of Engineering
By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy
