Roles & Responsibilities: Below three are major role:  Server /Resource Administration & Setup  Server /Resource Monitoring & Controlling  Server /Resource Security & Compliance

Roles & Responsibilities:  Azure Dashboard monitoring, resource maintenance & support of various azure services Iaas & PaaS.  Database Administration Management & involving Daily/weekly/Monthly task.  Involved Migration of on-premises to cloud environment.  Capacity management without affecting current systems, Involving & implement for process improvement.  Azure Network Monitoring, Accelerated Networking, Web application Firewall, SQL Data warehouse .Load balancing (Masking Default Port ), SQL managed Instance.  Migrating/Upgrading Version to Version of azure resources. As an IaaS & PaaS admin, setting/collecting various alert/diagnosis reports for Pro-active & Reactive steps.  Azure Resource metrics alerts (VM, SQL DB & Elastic dB, SQL servers, Application Insight, storage)  Using automated Log, identify choked resource & prepare RCA / fix issues.  Work Experience in SQL Server2008 R2 & 2014, 2016 Installing, Configuring database servers and Administering SQL Server Production / Development Database.  Enabled Query Store for Standard SQL VM & trace Live Query performance & control within resource limit. Taking care growth of log files & Virtual Log file (VLF).  Planning and implementing Backup and Restore procedures on the cloud Like (Amazon S3 & Azure Storage).  Checking Performance for CPU/IO/ using DMV/Activity Monitor / Resource monitor to diagnose system Performance / Dead Locks / long running queries.Dealing with performance issues, building & rebuilding indexes.  Limited access to owners to keep resource in secure/ avoid unwanted issues, Define & Implement the Best Security mechanism and ensure zero loop holes.  Process Automation & Maintenance (backup, alerts, integrity checks, defragmentation, VLF count, stats update ,shrink logs, health checkup, validate backups)

Roles & Responsibilities:  Play as a Developer cum DBA for the whole DE & RMO related Project Like (Everest, Liberty, camelback, Iceberg, Unison, solitaire Etc.)  Most of the support function is done remotely via Incident Management System (IMS), & email.  The DBA team is handling the monitoring, backup & restore database, clean up the older records and maintain the minimum number of records in the LIVE production.  Following SLA (Service Level Agreement).  Work Experience in SQL Server 2000, 2005 &2008R2. Installing, Configuring database servers and Administering SQL Server Production / Development Database  Responsible for ensuring availability and performance of the databases that support the Production / Development system.  Creating configuring database, tables, index, procedures & triggers as per business requirement.  Track & monitor the Service request status & provide regular updates to Sr. Mgmt / On-Site partners.  Database Backup and Restoration Management, Backup automation including daily/monthly database backup processes, archival of databases.  Have enough experience in Users Management and granting permissions.  Monitoring and creating & taking care of all scheduled jobs in different production environments.  Checking Performance using Activity Monitor / Profiler / DTA to solve system Performance / Dead Locks / long running queries.  Running DBCC health checks, and fixing data corruption in user databases.  Dealing with performance issues, building & rebuilding indexes.  Ensure 100% availability of DB to all Production users.  Involved in Disaster Recovery procedures for production servers.  Using mirroring & Log shipping to taking care of critical projects & for DB availability.  Experience in implementing different types of Replication models like Snapshot & Transactional Replication

Roles & Responsibilities:  Extensively worked on CRM tools to configure and customize the CRM application.  Configuration of business objects definitions (business components, business objects, applets, views, screens) creation of join and join specification links to implement the business requirements using CRM Tools.  Configured static and Dynamic Pick lists based on Client Specifications.  Support includes monitoring of Databases, Applications, Servers, and File Systems.  Backup archive files. Involved Backup & restoration.  Prepared Data Mapping Sheet for the Import Process.  Prepared .ifb file for the Import Process