asif karim

* My responsibilities were * Monitoring of server performance like checking up the CPU usage status and I/O status. * Participated in Knowledge Transfer sessions with previous owner of servers. * Troubleshooting for the data availability to the system users. * Installation and configuration of SQL server, SSIS, SSAS, SSRS. * Commissioning and Decommissioning of POLYSERVE instances. * Setting up the server according to RBS standard, checking before sending the server to PROD, DEV, UAT environment. * Applying the recent available patches for SQL servers. * Setting-up Transactional, Merge Replication and troubleshooting the replication * problems. * Setting up the log shipping and troubleshooting the errors. * Troubleshooting any SQL related error coming from PROD, DEV and UAT environment.

* I was working as Track Lead (Database) with HCL for client Anglo American which is one of the largest mining company in world and my roles and responsibilties are as below * As a Track Lead, I was responsible for my team performance and all the work related to SQL DB environment. * Motivating and guiding the team for resolution. * Attending all the meeting with stake holder and internal management. * Ensuring the SLA timelines must be maintained, if breached providing the justification. * Involved in Sev1 calls and providing the RCA. * Preparing different kind of reports for internal management meetings for SQL DB Track. * Setting up the server according to AA standard, checking before sending the server to PROD, DEV, UAT environment. * Applying the recent available patches for SQL servers. * Working on different project works involving build, migration and troubleshooting. * Environment: SQL Server 2005 and 2008, 2008R2, 2012, 2014, * Windows server 2003, 2008 R2, 2012

* As technical specialist I was responsible for technical escalations from level 1& * level 2 supports team members. * Participated in Knowledge Transfer sessions with previous owner of servers. * Involved in implementation of high availability & disaster recovery solution. * Responsible for suggesting SIPs. * Responsible for creating SOPs which will work as knowledge base for team members. * Responsible for troubleshooting for escalated issues. * Installation and configuration of SQL server, SSIS, SSAS, SSRS. * Responsible for bringing the solution or system in production after proper testing in * UAT/SIT environment and handing it over to concerned team for support, maintenance and system stability. * Setting up the database environment according to BG standard, and implementing * hardening before sending the server to PROD, DEV, UAT environment. * Attending change & release management calls. * Participation in project works with multiple teams. * Working on different project works involving build, migration and troubleshooting.

* I was working at designation of Assistant Manager at India's biggest toll plaza which was having more than 400000 transaction per day, and it i was managing its In premise database servers ( SQL server & Oracle). My roles and responsibilities were * Analysis of Space Availability on All Servers, Backups (Database and Image backup of All plazas) * Supervision Of Scheduled Jobs. * Monitoring of server performance like checking up the CPU usage status and I/O status. * Rebuilding indexes and updating statistics on a weekly basis. * Truncating the inactive log and shrinking the file size. * SQL Programming to generate reports using reporting tools. * Participated in Knowledge Transfer sessions with previous owner of servers. * Creation of users with specific rights for different applications. * Presentation of data to management and stakeholders (NHAI & MCD). * Troubleshooting for the data availability to the system users. * Environment: Windows server 2003, 2008 SQL server 2005, 2008 * Oracle 10g & 11g

* I started my IT career with Satyam as an ELTP and then promoted to Software Engineer, I was working on SQL server as database administrator & my roles and responsibilities were * Analysis of the existing setups and specifications of the Project. * Routine DBA activities like analysis of Space Availability, Backups (transaction log, complete and differential) and Scheduled Jobs. * Monitoring Snapshot and Transactional Replication between the servers and trouble shooting in necessary conditions. * Setting up of full-proof Disaster Recovery Mechanism. * Monitoring of server performance by a third party tool called Quest during peak periods of server utilization. * Create and re-evaluate Indexes and made needed modifications for better performance. * Scripting stored procedures and creating DTS packages for varied purposes as and when required in the project. * Participated in Knowledge Transfer sessions with previous owner of servers. * T-SQL development and writing T-SQL queries * Environment: SQL Server 2005, windows server 2003

Consultant at Wipro Infotech