Software Engineer
Send a job offer directly to this candidate
Having 18+ years of experience in IT industry. Having experience in designing, developing and maintaining large business databases.
Experience of managed and optimized databases across production and development environments, overseeing installation, configuration, and performance tuning. Exposure in design and development of database using SQL Server. Hands on experience in SQL Server backup and restoration of database.
Experience in designing relational database model, implementing and testing as per business need.
Experience in data migration using tool like DTS, Bulk Insert and BCP (Bulk Copy Program). Extensive experience in creating and Managing Tables, creating Views & Other Database Objects like procedures, triggers, functions. Managed large-scale datasets by designing and implementing table partitioning strategies, reducing maintenance times and enhancing database manageability.
Experience in Query Optimization, Index Tuning, Execution Plans, Dynamic Management Views (DMVs). Crating new logins, configure permissions, maintaining logins. Collaborated with cross-functional teams to troubleshoot database-related issues, enhancing application performance and user experience.
Experience in configuring and managed SQL Server Agent for automating routine tasks, such as backups, index maintenance, and alerting, ensuring consistency and efficiency in daily database operations.
Experience in configuring and maintained SQL Server transactional replication to synchronize data across distributed environments, ensuring high data consistency and minimal latency. Developed and automated backup and recovery strategies, achieving zero data loss in disaster recovery tests.
Experience in managing SQL Server database change requests, coordinating with development and operations teams to assess, implement, and validate changes while minimizing risk to production systems. Established and documented database change control procedures, including version control, pre- and post-validation steps, rollback plans, and testing protocols to ensure accurate change implementation. Have good problem solving and analytical skills.
Analyse user requirement and design database as per requirement. Maintenance and troubleshooting in production environment.
Project Associate at Index Solutions (Present)
DiagnoSearch Life Sciences Pvt. Ltd. (2006-06 – 2019-05)
SoftCore Solution (THANE) (2005-01 – 2005-04)
Application Developer and Database Administrator
Enterprise Resource Planning (ERP) System - Developed and managed a localized ERP solution designed to integrate core business processes including Inventory, Procurement, Sales, and Finance. The system centralizes departmental data to provide real-time visibility into operations, streamlining workflow automation and reducing dependency on manual documentation.
Application Developer and Database Administrator
Laboratory Information Management System (LIMS) - LIMS is to manage subject's data in clinical trials. It is used to manage Projects, Logistics, accessioning (i.e., register samples in LIMS), Reporting and data transfer to another platform. Software is integrated with machine. It sends instruction to machine and receives data from machine without any manual intervention.
Inform – EDC - System is used to capture data of subjects in clinical trials.
Case Report Form System - System is used to capture data of subjects in clinical trials.
Interactive Web Response System (IWRS) - It is used to enrol subject, randomise subject and manage study drug supply.
Data Transfer Application - It is used to transfer clinical data trails in desire format as per client's requirement.
Master In Computer Application (2008)
B.Com (2005)
