Mssql Server Database Administrator

Summary

Overall 9 years of experience in database design and implementation, database development, database administration and production server support for MS SQL Server versions 2005/2008/2012/2014/2016.
Experience in installing, configuring, managing, migrating, monitoring and troubleshooting SQL Server 2005, SQL Server 2008/2008 R2/2012/2014/2016 and SQL Server 2017 databases. Applying hot fixes and service packs on 64 bit clustered and standalone server environments.
Managed upgrades and migration of SQL Server 2005 databases to SQL Server 2005/2008 and SQLSERVER 2008R2, 2012, 2104, 2016 and 2017 respectively on clustered and non-clustered environments.
Experience in establishing and implementing high availability solutions such as Database Mirroring, Replication and Log shipping, ALWAYS-ON and Failover Clustering in MS SQL Server.
Engaged in performance tuning and optimization of the various SQL Server environments (Including tuning of indexes, stored procedures and dynamic SQLs).
Hands on experience in SQL Server Profiler, Windows performance monitor and Activity monitor.
Extensive knowledge and experience on Data migration.
Experience in creating a centralized server and implementation of monitoring scripts in production environment.
Knowledge in T-SQL.
Experience in providing 24x7 technical support for large number SQL Server database systems.
Knowledgeable of SQL Server development involving coding stored procedures, triggers and other T-SQL functionality.
Flexible, Enthusiastic and Project Oriented team player with good communication.

Expectations

Installation and configuration of SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008 and 2005.
Involved in Database Designing and Capacity planning for new environments.
Migration of servers from SQL 2005, 2008R2, 2008, 2005, 2012 to 2016.
Setting up ALWAYS-ON for SQL server databases 2012, 2014, 2016.
Supporting application team in setting up the projects.
Involved in requirement analysis and capacity planning for database design, maintenance.
Installed SQL Server and applied service packs and hot fixes for SQL server 2014, 2012, 2008 r2.
Automated SQL SERVER by using central management server and PowerShell. Setup the automatic alert system for database growth, backup failures, job failures, memory status, long running queries, CPU pressure.
Involved in Deployment and Development of SSRS and SSIS packages.
Automated the SQL SERVER installation by creating script for post installation steps.
Created scheduled jobs to automate routine housekeeping tasks.
Engaged in backup, restoration and recovery operations.
Planned and implemented database security measures.
Developed T-SQL scripts for backup verification to a tape to find out database growth verification.
Was involved in fine tuning stored procedures and queries.
Administered SQL Server 2012, 2014 and 2016 by ALWAYS-ON and maintained creating user logins with appropriate users/groups/roles and granting the privileges to users/groups.
Provided 24X7 production database support for SQL Server databases.

Employment Preferences
Expected Base Salary

*,*00,000 EUR / year

Academic Degree
Experience

Total Professional Experience

9 years

Enterprise Experience

9 years
COVID-19 Vaccination Status
Contact Candidate

Contacts

Send a connection request to the candidate to get their contact details.

Contact Candidate