Ananda Kumar Jayaraman
380
reputation
1
6
- 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