Anjali Tomar Email & Phone Number

Adelaide, Sa, Au

Adelaide, Australia

• Provide BAU support to manage, troubleshoot and resolve database issues for cloud and on-prem database• Installation and upgrade SQL Servers to latest version which is SQL Server 2019• Automation of monthly SQL Server patching via SCCM• Migrate on-prem databases to Microsoft Azure cloud• Provide support to data analytics platform which includes Azure Synapse, Data Lake and Data Factory• Major GIS upgrade from on-prem to cloud• Azure capacity planning, resource… Show more • Provide BAU support to manage, troubleshoot and resolve database issues for cloud and on-prem database• Installation and upgrade SQL Servers to latest version which is SQL Server 2019• Automation of monthly SQL Server patching via SCCM• Migrate on-prem databases to Microsoft Azure cloud• Provide support to data analytics platform which includes Azure Synapse, Data Lake and Data Factory• Major GIS upgrade from on-prem to cloud• Azure capacity planning, resource maintenance, cost analysis and reduction• Responsible for SQL licensing on-prem and in cloud• Provide support for Microsoft BI (SSIS, SSRS, SSAS, Power BI) suite solutions• Implemented CIS benchmark as part of PCI compliance on database environment• Applied and implemented security best practices and recommendations from Azure security center• monitor database using SolarWinds database performance analyzer tool, Whatsup gold, Azure alerts• Maintaining source code repository in Team Foundation server and Azure DevOps repository for cloud• Responsible for BCP of information management department• Managed IT disaster recovery (DR) project and successfully conducted annual DR test using VM replication• Coordinate stage shutdown and start-up of computer room equipment’s in extreme weather conditions Show less

Mumbai Area, India

• Monitoring and proactively supporting a 24/7 environment of 150+ multiple instance SQL Servers across multiple data centers on clustered, physical, and virtual infrastructure. These ranged from OLTP, Data warehouse and 3rd Party Hosted solutions, all subject to DR.• Worked on a Data Centre migration during the transition from one vendor to another and provided post migration support of database environment.• Performance Tuning of SQL Server using index tuning, profiler, PerfMon… Show more • Monitoring and proactively supporting a 24/7 environment of 150+ multiple instance SQL Servers across multiple data centers on clustered, physical, and virtual infrastructure. These ranged from OLTP, Data warehouse and 3rd Party Hosted solutions, all subject to DR.• Worked on a Data Centre migration during the transition from one vendor to another and provided post migration support of database environment.• Performance Tuning of SQL Server using index tuning, profiler, PerfMon, DTA, DMVs, analysis of heaps and missing indexes and creating indexes on tables• SQL Server builds advice that includes SQL Server 2012\​2014 \​2008R2 servers with SSIS\SSAS\SSRS • Review backup process and recovery model, add daily reporting to ensure all DB’s are backed up in line with business RPO and RTO and automated the restore process• Using SSIS for extract, transfer and to build an ETL Solution & Securing SSIS Packages• Up-gradation of SQL databases from SQL Server 2005\​2008 to SQL Server 2012\​2014• Provided DBA and development support for development groups in producing and implementing the database design, testing and releasing systems into the prod environment.• P2V for SQL Servers with different versions• Maintain the best customer satisfaction and customer experience by prompt, professional solution to solve the customer’s issue and good communication skill to delight the customer Show less

Mumbai Area, India

• Administered mission-critical, highly available, low latency database servers that include troubleshooting and implementing best practice while supporting customers in a shared environment• Creation dashboards using SSRS and Upgraded SSIS packages to SQL Server 2012 • Implemented a monitoring and alerting solution for system, DB, and hardware errors • Audited legacy SQL Servers during a discovery phase to determine unused databases• Upgradation, Implementation, and… Show more • Administered mission-critical, highly available, low latency database servers that include troubleshooting and implementing best practice while supporting customers in a shared environment• Creation dashboards using SSRS and Upgraded SSIS packages to SQL Server 2012 • Implemented a monitoring and alerting solution for system, DB, and hardware errors • Audited legacy SQL Servers during a discovery phase to determine unused databases• Upgradation, Implementation, and maintaining of SQL Server DB in AlwaysOn Availability group• Disk Capacity planning and Implementing SQL Server Auditing• Release management of database code through dev, test, UAT to live environment• Experienced with ‘On call’ support and 24X7 Support in an offshore environment. Show less

Mumbai Area, India

• Primary BAU Support of approx 50 SQL Server Instances including SQL Server 2000\​2005\​2008\​2008 R2 and 2012 and ensuring high availability and performance of SQL Servers databases• Regularly involved in applying for releases \application patches\service packs\Hot fix’s on the live server to keep the database at current patch level and Documenting processes and procedures• Experience to work on change requests, problem tickets and preparing root cause analysis document and… Show more • Primary BAU Support of approx 50 SQL Server Instances including SQL Server 2000\​2005\​2008\​2008 R2 and 2012 and ensuring high availability and performance of SQL Servers databases• Regularly involved in applying for releases \application patches\service packs\Hot fix’s on the live server to keep the database at current patch level and Documenting processes and procedures• Experience to work on change requests, problem tickets and preparing root cause analysis document and follow ITIL standards adopted by the IT Department• Managing SSIS, SSRS, SSAS and Cluster SQL Server in active-active and active-passive mode• To proactively check systems to pick up faults before the customer with the aim of increasing the availability of systems and thus reducing the amount of customer generated incidents• Deploying the SSIS packages, SSRS Reports and Administering security of SSAS cubes into prod• Maintaining database of SharePoint, Citrix ,SCCM, SCOM, VMware, Dynamics, CRM app• Involved in multiple Disaster recovery testing on different SQL Server stacks and Live DR tests• Decommission of Databases and SQL Servers Show less

Mumbai Area, India

Started out as a graduate, attended Capgemini in-house training and then joined DBA Shared Services. I learned SQL Server database administration via self-learning and under the guidance of senior team members. Initially, I worked on test and dev environment to grasp an understanding of client servers, various administration tasks and then gradually started working in the production environment. My roles and responsibilities as junior DBA were as follows:• SQL Server health check and… Show more Started out as a graduate, attended Capgemini in-house training and then joined DBA Shared Services. I learned SQL Server database administration via self-learning and under the guidance of senior team members. Initially, I worked on test and dev environment to grasp an understanding of client servers, various administration tasks and then gradually started working in the production environment. My roles and responsibilities as junior DBA were as follows:• SQL Server health check and working on incidents and work orders raised by ticketing tool • Configuring, scheduling and monitoring all maintenance plan, alerts and jobs (Backup/Restore, Database Consistency Checks,re-indexing, update statistics jobs) on all databases• Installing and configuration of SQL Server 2000/2005/2008/2008R2• Maintenance activities like checking error log, log files, Import, Export & monitoring table spaces• Implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users• Document weekly disk space usage, job failure, and abnormal database growth report• Setting up log shipping and mirroring in high safety and high-performance mode• Monitoring disk space, memory usage, CPU usage, block & deadlock and connectivity issues• Carrying out various SQL development tasks using T-SQL, creating tables, views, stored procedures, triggers, functions, and views on test environment Show less

Bachelor Of Engineering (B.E.), Information Technology, First Division

Hsc, Phy,Chem,Maths,Eng & Informatics Practice, First Divison

Ssc, Distinction