Sr SQL Database admin/SME
Send a job offer directly to this candidate
I am skilled in Microsoft Certified and have more than 10+ years of experience in SQL Server Database Administration, Management, Upgradation, and Migration of Production and Non-production environments.
Have good experience in Mongo DB installation and management.
Extensive experience with MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, and 2005 Versions.
Extensive Knowledge of Relational Database Management Systems.
Experience in upgrading SQL Server software to new versions, applying service packs and hotfixes as well as performing unattended installation.
Experience in Migration from SQL Server 2005 to SQL Server 2008/2008 R2/2012 and from SQL Server 2008 to 2012.
Experience in providing 24 x 7 Production Support and On-Call rotation!
Good understanding of Normalization / De-normalization and the database design methodology.
Proficient with SQL Server Disaster Recovery, Backup/Restore and creating Business Continuity Planning.
Experience in implementing SQL Server Security and Database User Permissions.
Expert in creating, scheduling, and monitoring SQL Server Jobs and Maintenance plans.
Exposure to third party tools like- Spotlight, Idera and Redgate for performance monitoring and for day–to-day DBA tasks.
Consummate knowledge of high availability SQL Server solutions including Mirroring, Log shipping, Replication and Always on Availability Group.
Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
Transformed data between servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS), SQL Server Integration Services (SSIS)
Experience in creating and deploying reports using SQL Server Reporting Services (SSRS).
Good Knowledge of Windows Active Directory.
Good Knowledge of Windows Failover Clustering.
Excellent communication skills, self-managing,
and teamwork spirit, work independently.
Good Knowledge on NoSQL databases like MongoDB (University Certified),
Good Understanding & Knowledge of Cloud computing architecture, technical design, and implementations, including Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS).
Supported Azure SQL database.
Created Azure Automation SQL Index maintenance plan.
Installed and Configured SQL Server 17 on windows 2012 servers, SQL Server 2019 on Windows 2016 servers.
Upgrade SQL 2012 database Servers to SQL 2016 servers, and from SQL server 2014 to 2019 SQL servers.
Created detailed documentation of steps taken during the migration process.
Created database log shipping from production to DR serves for disaster recovery.
Managed SQL Server user logins, database users, roles, and its permissions to new environment.
Involved on deploying database scripts and SSIS packages from Staging servers to production servers.
Helps installing Mongo DB servers.
Created SQL Server Agent Jobs to automate tasks such as to run Index Maintenance, Index Defrag, Rebuild, Update Statistics.
Works on decommissioning removed contracts/ databases.
Monitoring that backup have been made and successfully saved to a secure location and monitor disk space to ensure SQL Servers do not run out of disk space.
Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs, and Windows and
Monitoring that backup have been made and successfully saved to a secure location.
Supervising all the instances and databases are up and running 24/7 and troubleshooting error entries.
Work on Annual DR/ disaster recovery test.
Works on rotation on call schedule.
Worked on using Combine for deployment purposes.
Solar Wind/DPA (Database Performance analyzer) Performance monitor.
IDERA SQL Compliance Manager/ Created alert from IDERA SQL Compliance Manager to send an email to DBAs email, when a database on prod is dropped or created, user making Delete’s, User making updates.
Supported Azure SQL database.
Created Azure Automation SQL Index maintenance plan.
Created Elastic jobs on Azure SQL Database.
Upgrade service tier from General Purpose to business Critical.
Migrated MySQL server from old to newer version.
Create MySql replication for disaster recovery.
Granted access to MySQL users.
Created Amazon EMR Cluster.
Imported relational data from parquet files and hive tables using Spark SQL.
Administrating Microsoft Azure SQL Solution|
