Malathy R.

Malathy R.

Database Design and developement ,NoSql ,Postgre sql

Bangalore , India

Experience: 10 Years

Malathy

Bangalore , India

Database Design and developement ,NoSql ,Postgre sql

10 Years

Now you can Instantly Chat with Malathy!

About Me

  • 11+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000.
  • Experience in Database Administration on Production Servers with se...
  • Experience in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • Expertise in SQL Script for writing stored procedures, triggers and functions.
  • Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
  • Implemented the new SQL Server 2012 mechanisms like data compression, indexing, Contained Databases, security principals and AAG.
  • Worked on logical and physical data base modeling with UML tools.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Hands on experience in DR processes including Log Shipping and Database Mirroring.
  • Worked on configuring SQL Server with minimum privileged access.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Worked on SQL Server 2012 migration from SQL Server 2008 / 2005 and SQL Server 2000 into SQL Server 2005.
  • Worked on migration of SQL Server 2000 instances into the 2005 SAN server.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Working knowledge in Reporting Services (SSRS).
  • Knowledge on NoSQL Database (Mongo Database).
  • Worked on WCF, Rest API services

Show More

Portfolio Projects

AN360 Cloud app for Home security system

https://www.alarmnet360.com

Company

AN360 Cloud app for Home security system

Role

Backend Developer

Description

An360 is composed of different modules to provide the functionalities like account management, hardware configuration application, communication server and so on. The web portal is created for providing the better way for device configuration and management. This involves dealer account creation, customer account creation, device communication and various operation. The device operation can be performed by dealer remotely. The device communication with ValueNet was accomplished using webAPI and websocket server.

Show More Show Less

TSSCDOWNLOADER

Company

TSSCDOWNLOADER

Description

       TSSCDownloader is composed of different modules for managing account, configuring Honeywell product, device enrolment, and device operation remotely. TSSC downloader was basically developed to support low end security devices with various security feature which are used in residential premises. TSSCDownloader is security device configuration which provide support to dealer to configure and monitor the devices remotely.

Show More Show Less

Ticketing Cloud app

Company

Ticketing Cloud app

Description

   This application is used to raise employees concern as tickets. Tickets will automatically get assign to respective agent for resolution.  

 Portal has three modules:

 

  1. Employee:

  Employee module will help the employee to raise their concerns.

  1. Agent Module:

  Agent module will help the agent to resolve the tickets .The tickets will be assigned to particular agent based on location, Category, Service window and Sla.

  1. Admin module:

  Admin module helps for configuration and administration.

Show More Show Less

Outbound customer call app

Company

Outbound customer call app

Description

       This is an outbound campaign of Bank of America. This Project is used to take up the call made to the customers of BOA and giving them the details about the Product offers. Once customer will show interest about the product offered, Associates will collect the required details through phone. This Application is combination of Windows and Web parts. The login and getting the call is in windows part and collecting the details and closing the call through Web part. When the data is filled up in the web part same time it will be post back to the client’s URL through intranet .The URL post the data which consist of the data binded into XML strings.

Show More Show Less