Assistant Manager - Database
Medusind Solutions
مجموع سنوات الخبرة :25 years, 7 أشهر
Handled migration from Standalone to 2 node Cluster
Implemented Transactional replication with Push Subscription
Handled SAN migration for the databases involved in Cluster and Replication
Implemented Third party tools Idera SQL Safe and Idera SQL Diagnostic Manager
Handled memory configurations
Implemented backup and recovery strategies
Supporting replication using third party tool Redgate Data Compare
Expertise in Database Administration on Production Servers with Server Configuration, Performance tuning and maintenance
Designing and setting up Alwayson, Clustering and Log shipping
Expertise in Always-on Availabi(AAG) and HA/DR troubleshooting
Strong technical background along with the ability to perform business analysis
Administrating SQL Server high availability and DR strategies
Hands on experience in Log shipping and mirroring
Handled multiple cluster instances for SQL Server consolidation
Handling memory configurations for SQL 2012 on Windows 2012
Experience in Batch processes, Import, Export, Backup, Database monitoring tools
Hands on experience in the design and implementation of high availability solutions
Hands on experience in DR Processes
Handled data center migration
Experience in supporting VLDB and troubleshooting the problems
Handling Memory configurations
Proficiency and expertise in Replication, backup, recovery
Responsible for the upgrade of the databases
Troubleshooting production issues and raising high availability
Worked on Server consolidation
Experience in Migration and Upgrade
Experience in supporting very large databases (VLDB) and troubleshooting the problems
Responsible for setting up the DR plan and successfully executing the mock DR
Documentation of DR plan
Providing highly available database using SQL Clustering, log shipping
Responsible to monitor and troubleshoot log shipping
Involved in migrating SQL Cluster to new SAN HUS150
Build transactional replication using backup with reinitialization (since the database backup size exceeds higher than 150 GB)
Created a custom replication alert for replication in Idera
Worked with development team in analyzing data
Worked with powershell script to backup to a NAS box located in different domain
Implemented change management controls, processes and practices to deliver quality services
Made recommendation in terms of the data growth, software, tools
Removal of secondary log files to enhance the database performance
Worked in Reporting services to generate custom report
Designed the backups and recovery strategies for SQL Databases to meet the customer SLA requirements
Managed the entire database environment (Dev, QA, Beta, Prod, Release & DR)
Configured Idera Diagnostic manager across different environment
Management of Terabyte production clustered systems using Active-Passive clustering
Responsible for planning, implementing and documenting database structures for sql databases
Troubleshoot databases and custom application issues
Involved in optimizing the transactional replication
Handling monthly database refresh from production to lower environments for application testing
Visited onsite (USA) for a month to interact with the clients directly and also to provide support which ranges from deploying high availability solution, securing the sql server, queries to databases, performance tuning based on the input from the functional consultant etc.
Providing support for databases related to multiple products in a healthcare domain
Implemented High availability solution for disaster recovery
Involved in streamlining of various processes
Performance tuning and optimization of various queries in assistance with the development team
Setup maintenance jobs from the scratch
Implemented ticketing system
Database archival process
Installation of Oracle for various testing of the product across different flavour of databases
User management and access rights
Installation and configuration of database, associated database tools and performance monitoring
Upgradation of database from SQL Server 2005 to SQL Server 2008
Estimated Disk storage requirements for database software, database files and administration needs
Implemented and managed database clustering, failover as per business requirement
Developed, tested and implemented a robust database backup and recovery strategy
Database recoveries as per requirement
Participated in design, testing and implementing a disaster recovery plan
Installation of backup tools in a clustered environment
Monitoring of database activities which includes database status, logs, space utilization, locks and long transactions etc.
Suggested application level tuning changes for code, queries and SQL Objects which may not be performing upto the optimum database standards
Implemented Active-Passive Cluster
Implemented service account for SQL Server services
Monitoring of database performance using performance monitor, sql profiler
Managed security by defining roles and permission which are controlled through a windows account
Configuration of backup schedule as per the business requirement
Setting up of database maintenance jobs like shrink, index and update statistics jobs
Isolating the data and log files in the server to have a better performance
Changing the compatibility mode from old to new in SQL 2008
Handling of users queries ranging from database connectivity, data loading, data migration, database rename, performance issues etc
Conducted session for Performance tuning best practices
Controlling the user access by providing the windows account
Database log management
Adhoc rebuilding of indexes, shrinking of log files
Monitoring of SQL Agent jobs and notifying the user in case of failure
Providing best practices knowledge of customer business processes in relate to SQL Server databases
Responsible for maintaining & monitoring SQL Server System and Databases.
Align with proper standard process compliance including ITIL
Participate in and contribute to Release activities including spec reviews
Responsible for Installations, Upgradations, Patching of SQL Server
To resolve and rectify all Production Issues within SLAs
Maintain Backup and Recovery Plans for all Databases
Monitoring Jobs, Error Logs, Server Space, Health of Databases & Servers.
Responsible for Troubleshooting Operating System with respect to SQL Server.
Implement Rollouts and Changes to Database by following specific Standards and processes.
Replication setup, configuration and troubleshooting in Production Servers.
Database Mirroring setup, configuration, testing in Production Servers.
Troubleshooting of Cluster servers.
Knowledge of DTS / SSIS.
Supporting various client applications related to database.
Managing the tool like Remedy for incidents, change requests etc.
Generating reports using Idera SQL Compliance Manager
Database Migration tasks based on the compatibility of the application
Capacity planning for all the critical production servers
Performance monitoring using profiler and Windows Performance monitor
Log shipping setup, configuration and testing for the failover
User access rights, roles management
My responsibilities involved in implementing Peoplesoft project.
Installation of SQL Server 2005, Configuration of Active-Passive clustering on a two node servers.
Installation of PeopleSoft Components in Database
Installation of Application Server and Creation of Multiple nodes for load balancing
Creation of domain for Process Scheduler
Installation of Webserver and Configuring Webserver for Failover
Integration of PeopleSoft System with Firstsource LDAP Server on domain level
Managed the Products and development databases including performance tuning, capacity planning, SQL Server Clustering, database security configuration and database continuity.
Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL Code
Performed DBA duties including database backups, restores, performance tuning and capacity analysis
Creation of COP and reconfiguring the application to redirect to the new database on Virtual Infrastructure
Creation and configuration of Additional domain in Appserver and Webserver for COP instance to point to new COP database
SMTP configuration in Appserver configuration file to enable mail transmission
Troubleshooting problems pertaining to appserver, webserver, process scheduler and database
My role includes manage the client Datawarehouse project remotely to ensure that the Production database is available for Magnacare Analytical application, Decision Support System and other user queries. The Project I worked is for Magnacare, US. MagnaCare is an agile and responsive company offering custom-designed health plan solutions within the complex world of healthcare.
Diagnosed and resolved problems using the monitoring tools, error logs, scripts, stored procedures, DTS
Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
Monitor the jobs which runs in the background datawarehouse system
Resolving the issues such as locking, failure of data transmission from a legacy system to datawarehouse system
Florind Shoes is a part of KAR Group. The group has six units currently engaged in activities ranging from Leather processing to producing Finished Leather products. The Group supplies products to clientele like Florsheim, Cole Haan, Nike, Weyco, Hush Puppies and Deichmann.
Implementation of Ramco e.Applications comprising of modules (GL, AP, AR, PP, SOM, POM, PPM, Audit, EXIM etc)
Implementation of Wireless Network through Radio modems
Troubleshooting problems in Multiserver setup and maintenance of SQL Server and OS Security across domain
Work with end users to define, implement, and maintain their reporting requirements
Customization of the Financial Reports
Database Backup, Restore, Performance Tuning etc.
Provided technical support to internal developers.
McCreade Software, a wholly owned subsidiary of McCreade Systems LLC, NJ involved in implementing ERP Solutions to their Clients in USA. My role includes maintenance of database, support the developers, upgradation etc.
Certified for ITIL Foundation
Availed Inhouse Training on ERP from Ramco e.Applications.
Master of Computer Applications(MCA)
B.Sc., (Computer Sceinece ) - First Class