MS SQL Data Base Administrator

Role: MS SQL Data Base Administrator

Role: MS SQL Data Base Administrator (SQL Admin)

Contract Type: TP

Duration: 12+ Months

Start Date: ASAP

Location: anywhere from Europe

  • SQL Server DBA,

  • Azure SQL Server

  • High Availability (AlwaysOn, Replication)

  • Backup

  • Performance Tuning

  • SQL Server on Linux

  • Resolving critical issues with proper analysis and share the Root cause analysis with permanent fix.                                                                                                                                                                            

  • Managing SQL Server in (Development, testing and production) environments.                                                                                                                                                                             

  • DB background includes database configuration, maintenance, troubleshooting and managing day to day operation activities.                                                                                                                                                                          

  • Provide assistance to the application team in indentifying database problems.                                                                                                                                                                          

  • Exposure in Database upgradation and Migration.                                                                                                                                                                        

  • Worked and managed clouds based databased infrastructure.                                                                                                                                                                

  • Installed and configured MSSQL  2005/2008/2008R/2012/2014,2016,2017.                                                                                                 

  • Applied Database patches and cumulatvie Hotfixes.                                                                                                                                                                      

  • Architecture of the existing SQL Database Environment to be migrated                                                                                                                                                                        

  • Uderstanding of Windows administration to manage the database independenty.                                                                                                                                                                             

  • Extensive work on High Availabilty and Disaster Recovery Solutions includes (AlwaysOn, Clustering, Mirroring, Logshipping and Replication).                                                                                                                                                                                

  • Security Management (Logins, Users, Database/Server Roles and Granting/revoking permissions).                                                                                                                                                                     

  • Have Implemented AlwaysOn Availability Groups in SQL Server 2012, 2016 and 2017 (In Cloud (AWS or Azure) and On-Prim Environment).                                                                                                                                                                           

  • Expert in Performance Tuning by analyzing blocking, index fragmentation, execution plans, DMVs, native tools SQL Server Profiler, Query Plan, Database Tuning Advisor and Event Viewer.                                                                                                                                                                          

  • Experience troubleshooting SQL Server jobs, Backup compression, Support for large and Complex Databases.                                                                                                                                                                           

  • Expert in VM ware and Cloud DB infra deployment.                                                                                                                                                                     

  • Database Consolidation and Solution Design for SQL Server Database technology.                                                                                                                                                                      

  • Exposure in CDC  and Database Audit.                                                                                                                                                                      

  • Assessing and auditing existing Projects for value-add and SIP to the client in terms of optimize operational and technical streams.                                                                                                                                                                             

  • Automate the daily task using Powershell.                                                                                                                                                                            

  • Sound knowledge (Access Control, Incident Management, Capacity Management, Problem Management, Release Management, Change Management, Service Management.                                                                                                                                                                          

  • Support Database on AWS, Azure or Goole Cloud.                                                                                                                                                                         

  • Worked on Database migration from On-prime to cloud.                                                                                                                                                                          

  • Expertise in Database cluster deployment and Management.                                                                                                                                                                              

  • Expertise in Azure SQL Single Database , Elastic Pool, Managed Instance, IaaS environemnt                                                                                                                                                                        

  • Understand and HandsOn DMA, DMS tools for Assesment and Migration of Databases                                                                                                                                                                     

K&K Social resources & development GmbH, is an international recruiting agency who is providing technical resources in European region since 1993. This position is for our client who is actively hiring candidates.

 

 

 

Follow us on social Media