Ananda Kumar Jayaraman has asked 0
questions and find answers to 1
problems.
Stats
27 EtPoint
9 Vote count
0 questions
1 answers
About
14+ Years of experience in SQL Server Database Administration and
Developer in SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL
2008(R2), SQL 2005 and SQL 2000 Expertise in TSQL Programming
Strong in building SSIS Package and SSRS reports Built a tool in
vb.net to migrate the data from various data sources dynamically into
SQL Server Built a tool to export the data from the database into
an excel sheet Strong in Data encryption technologies Strong in
programming in MySQL Strong in recovering the data from the
corrupted database Strong in setting up security model for Data and
Users Have hands on experience in handling heterogeneous data in
various formats. Liaise with 100+ clients for Data migration,
Reports and DB administration tasks Built own DR model for our DB
server as none of the existing options suit to our environment
Automated most of the DB maintenance tasks Have gained knowledge
in Mongo DB and Big data concepts Involved in preparing upgrade
scripts for database Troubleshoot Performance problems, fine tuning
of queries and Index Analysis Strong in Analyzing Execution plans
and Performance Counters Hands on experience in integrating ‘R’
Programming with SQL Server Strong in Powershell programming and
automated a few DB maintenance tasks using Powershell Implemented
Database mirroring and Log shipping Proficiency and expertise in
SQL Server Backup/Recovery, Disaster recovery and planning. Strong
experience in mentoring Team members and technical assistance to R&D
developers. Received most valuable person (MVP) award twice in ADP
Passed 70-229 in MCDBA Examination with the score of 954 in 2005