Technical Exposer: Database mirroring, log shipping Replication and related technologies. Experience in Installing, configuring, managing and troubleshooting of MS SQL Server 2*************4, 2016 , 2017 and applying Service Packs on cluster as well as standalone environment. Handled SQL Server Upgrades & Migrations from SQL Server 2008 R2 to SQL Server 2012 versions. Experience in planning and implementing DB Security by creating Logins, Users, Roles and assigning permissions according to the requirement. Handled Installation and configuration of Analysis Services, Reporting Services and Integration Services. Experience in configuring and troubleshooting SQL Server backup (Full, Diff & Log), and Database Refresh from Production to Test/Development environment. Performing Root Cause Analysis on variety of issues, identifying strategies to prevent them in future. Ability to work independently and drive team members to exceed Customer expectations and working as a good team player. Ability to work under pressure with tight deadlines to meet SLA’s. Should have Knowledge of Azure Services viz. VMs, Storage Accounts, Vnet, Subnet, Vnet peering, Manual/Auto Scaling, and have understanding of IT Infrastructure. Build a new Azure SQL Database or migrate to it from an on premise SQL Database. Experience in Microsoft SQL Server database backup, recovery & restore, monitor and tune an Azure SQL Database. Basic knowledge with AWS cloud services: EC2, S3, RDS. Past experience in developing software solutions with an object oriented programming language as.NET and non object oriented programming language like asp. Knowledge and working experience on SQL/PowerShell programming and JavaScript scripting languages. Knowledge on MS PowerPoint, Excel, Access, Project, or other analytical tools associated with project management. Good Knowledge/expertise Worked on number of deployment solution on the database platform for the application. Involved in recommendations on all incident/Request/change management. Good communication skills and ability to convince manage project partners and senior management. Sound knowledge on ITIL processes.
Incident and Change Management: Incidents detection, ownership, tracking, monitoring, communication and maintaining various sql database server incidents records with Vendor support solutions. Handled critical change requests like database upgrades, high availability implementation like mirroring always on and other day to day operational tasks.
Management of Project Transition: |
SQL Version & other databases | MS SQL 2**************/12/**********,Mysql5.**********i,Sysbase12.5.2,DB2, NOSQL MONGODB | Operating System | Windows 2************2/2016 Server, Windows 98/XP | Ticketing Tools | SNOW ,BMC Remady,Petrol, ,Clear Quest, Citrix | Monitoring Tools : | Zenoss ,MLM, NetIQ and SCOM | Third Party Backup | VERITAS Netback up, Tivoli SQL, Light Speed, Avamar, Idera SQLdm | Cloud Technology | Microsoft Azure,AWS | DevOps | Jenkins,Git. |
Project (1) NTT DATA Client: Wolters Kluwer: July 2013- till date TMNAS: May 2020- till date Hilton :- March 2021- till date Position in the project: Database Advisor for SQL server Contribution Provide production support and Responsible for solving critical production problems and performed point in time recovery plan Centers. Responsible for Monitoring and managing high availability configuration for SQL Servers
(Cluster /Replication/ mirroring / Log shipping). Installing, configuring and maintaining database software, service packs, patches, upgrades and utilities Creating managing and troubleshooting sql server agent job, corporate milestones for database consolidation and data migration and Sync of Mirroring, Always On and log shipping when it goes out of sync. Installing and configuring SSIS,SSAS and SSRS. Perform Daily health check all Data center servers and any major Incidents in Environment. Creating maintenance jobs for database running on weekly basis and Strong knowledge in implementing database backup and recovery strategies. Creating user logins and assigning permission as required. Used DBCC command to troubleshoot issues related to the database consistency. Conducted performance tuning using SQL profiler and windows performance monitor. Monitoring of database size and disk space In Production, Staging & development environment. Reviewed DB script from the development team before releasing them into the production. Provide L1 support on AWS cloud services: EC2, S3, RDS. Knowledge and working experience on SQL/PowerShell programming and JavaScript scripting languages. Knowledge on MS PowerPoint, Excel, Access, Project, or other analytical tools associated with project management. Good Knowledge/expertise Worked on number of deployment solution on the database platform for the application. Communicating with stakeholders and client with respect to incident/Request/change management.
Project (2) iGATE Computer System Client: MetLife (US): June ************** Duration: 17 Months Position in the project: Senior Associate DBA Contribution: Extensively worked on Database tuning for optimal performance, SQL statement. Installing, configuring and maintaining database software, service packs, patches and upgrades. Optimization, monitoring for 500+ databases. Performance monitoring using windows. Performance monitor, SQL Profiler and DMV’s. Troubleshooting performance issues. Database Performance optimization by finding and diagnosing slow-running queries. Manages SQL Server Security, which includes User and Server logins Authentication modes, Administering Server Database Objects permission, Database Roles Creation and updating Monitoring of SQL servers(Error log check, Job status check, SQL services check) Performance monitoring using windows performance monitor. Creating new management plans, Creating SQL Jobs. Responsible for doing build QA for server before going into production environment and DBA QA after the LUN expansion of Cluster server.
Project (3) iGATE Computer System) Client: Stone River: Nov ************* Duration: 07 Months Position in the project: Database Administrator Contribution: Responsible for solving database migration tickets using third party tool DBSolo. Installation of SQL Server 2000/2005/08 SQL Server 2005/08 Service pack installation/Patch updating Monitoring of SQL servers(Error log check, Job status check, SQL services check) Responsible for database backups and restores. Trouble shooting production issues. Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor. Responsible for service requests. Project involves rotational night shifts.
Project (4) Wipro InfoTech Client : IndiGo Airlines: March ************** Duration: 8 Months Position in the Project: Database Administrator with Sybase. Contribution: Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation. Performed installation of SQL Enterprise 2000/2005 64bit version on Windows 2003 servers. Performed database backup restore on Sybase, user creation and assign permission to user. Monitoring and backup reporting setup with Microsoft Operations Manager and backup teams. Creation and scheduling of Maintenance plans (database and log backups and cleanups) Implemented disaster recovery solution at the remote site for the production Databases using Log Shipping. Managing SQL server database using SQL Enterprise Manager / Management Studio Planning and configuring Database backup and recovery. Worked on Oracle Database and Toad for database administration for Oracle. Developed software solutions with an object oriented programming language as.NET and non object oriented programming language like asp, also used JavaScript scripting languages. Worked on on SQL programming for use of software developer as per the requirement.
Project (5) CellNext Solution Client : LIC & ABN AMRO Bank: Sept ************** Duration: 17 Months Position in the Project: Database Administrator. Contribution: Responsible for Solved critical production problems and performed point in time recovery plans. Monitoring of database size and disk space in Production, Staging & Development Environments. Creating, Managing and Troubleshoot SQL Server Agent Jobs, corporate milestones for database consolidation and data migration and performed installation of SQL Enterprise 2005/2008 64bit version on Windows 2003/2008. Creation and scheduling of Maintenance plans (database and log backups and cleanups) Implemented disaster recovery solution at the remote site for the production databases using Log Shipping. Used DBCC commands to troubleshoot issues related to database consistency. Used Index tuning wizard to redesign and created the indexes for better performance. Implemented trigger and stored procedures and enforced business rules via checks and constraints.
Project (6) DOEACC Client : Delhi Govt: Aug ************* Duration: 21 Months Position in the Project: Assistant Engineer Contribution: Installation of SQL Server 2000/2005/08. SQL Server 2005/08 Service pack installation/Patch updation. Management of SQL Servers, databases, storage management for databases sizing from 40 to 50 GB. Responsible for General Database Administration and Performance. Data Migration from legacy to master tables using DTS-import and Export wizard. Worked on software project for the client using .Net and host on web
|
