OnBenchMark Logo

RamKarthik

Senior Lead SQL DBA
placeholder
Location Bengaluru
view-icon
Total Views54
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 9 Year
  • Cost
    Hourly Rate$11
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 06, 2024
Key Skills
MS SQL ServerTSQLPowershellAutoamtion
Summary
  • Having 8+ years of experience in Implementation and Administration of Database system using MSSQL 2005/2008/2008 R2& 2012, 2014,2016,2017,2019.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities for Microsoft SQL Server 2000/2005/2008/2008R2/2012.
  • Configure and Managing SQL Server in Azure IAAS.
  • Configure and Managing SQL Server in AWS RDS.
  • Involved in SQL Server technologies like Backup / Recovery, Indexing and Reorganization.
  • Good backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers and Functions.
  • Good T-SQL Programming skills. Experience in query optimization & performance tuning.
  • As SQL Server DBA, I have extensive knowledge in database maintenance, Automation and High Availability.
  • Hands on experience in SQL Server agent Job configuration, Alerts and SQL mail configuration.
  • In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database.
  • Run the Database consistency to check the logical and physical integrity.
  • Providing highly available database and application infrastructure according to Business Continuity requirements using SQL Server Always On Solution.
  • Configuring and maintenance Replication, Clustering, Database Mirroring and Log shipping.
  • Hands on experience in SQL Sentry Query Plan Explorer /Red Gate SQL Monitoring and Backup Tools.
  • Hands on experience in SQL Server Partitioning/File Stream & DMV’s for Memory trouble shooting.
  • Having a basic knowledge about SSRS.
  • Upgrade/Migration SQL Server from lower to higher version.
  • Installing and patching the SQL Server.
  • Hands on experience in DR activities on the SQL servers.
  • PowerShell scripting.
  • Handling TB size of databases.
  • Hands on experience about Performance tuning the SQL server.
  • Experience in upgrading the SQL Server database instances with latest service packs and hot fix
  • SQL server DB mail and linked server creation on request from the users
  • Experience in assigning, updating and revoking privileges, roles & profiles to database users
  • Capable of Planning and work to an imposed structured timetable to meet deadlines, ability to learn new skills rapidly and work well with wide range of people, ability to identify and resolve problems, disciplined, communication and presentation skills
  • Have done automations using PowerShell Forms/scripts and scheduled Windows tasks
  • Strong knowledge on Transactional Replication. Able to fix the replication errors(PK Violation, Row not found etc..) using code.
  • Basic knowledge about Azure SQL, Paas
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon