Skip to main content
Database Administrators
Ananda Kumar Jayaraman's user avatar
Ananda Kumar Jayaraman's user avatar
Ananda Kumar Jayaraman's user avatar
Ananda Kumar Jayaraman
  • Member for 9 years, 6 months
  • Last seen this week
  • Chennai, India
Profile Activity
Stats
101
reputation
0
reached
2
answers
0
questions
Communities
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
Badges
This user doesn’t have any gold badges yet.
This user doesn’t have any silver badges yet.
1
bronze badge
Top tags
-2
Score
2
Posts
100
Posts %
-2
Score
2
Posts
100
Posts %
-2
Score
2
Posts
100
Posts %
Top posts
answer
0
TSQL insert table using view -- performance issue
Jun 22, 2015
answer
-2
TSQL insert table using view -- performance issue
Jun 19, 2015
Top network posts
View all network posts
13
SQL Multiple LIKE Statements