Ahamed Thameem .P
Chennai
Summary
About 11+ years of extensive experience as a MS SQL DBA which involves supporting business critical production servers, automate DBA activities, performing installations efficiently, solving issues within Service Level Agreement, etc. Good Knowledge and experience in SQL Server - Installations, Configuring, and Administration Expertise in Production Environment of Maintenance and Administration of SQL Server 2000, 2005, 2008, 2012,2014 and SQL 2016 Databases. ITIL V3 Certified Engineer. Experience in Installing, Upgrading, Configuring, Migrating and Performance tuning in MS SQL Server 2000, 2005, 2008, 2008R2,2012 and 2016 Acquired in-depth knowledge of Data Centers, Healthcare Industries, Telecom Systems, Inventory Systems, Sales and Marketing Domains Experience in production support for Large Scale SQL server databases Good Experience on Configuration and troubleshooting Clustering, Replication Strong communication and interpersonal skills Fast learner & self-motivated professional with a high degree of attention and commitment towards work
Overview
14
14
years of professional experience
1
1
Certification
Work History
Associate Consultant
Tata Consultancy Services
10.2022 - Current
- Company Overview: Telefónica Germany operates second, third and fourth generation mobile networks, allowing customers to use GPRS, EDGE, UMTS up to HSPA+ and LTE for data connections. Most of O2 plans are available both in a pre- and postpaid version, including the all-in-one-flatrates called o2
- And o2 on for enterprise customers. Beside the core business, Telefónica Germany is one of the largest retailers for mobile phones and tablets without a SIM lock. It was the first operator offering both Apple's iPhone 4 and the iPad 2. Also, Telefónica Germany offers hosting services for large and midsized companies, serving some well-known portals including Spiegel Online and Sevenload. Together with Microsoft and Visionapp, Telefónica Germany provides a cloud service for Hosted Exchange.
- Allocating and Altering Space requirement of Data and Log files
- Designing Backup and Restore Policies
- Identifying and Resolving Abnormal Database Status
- Troubleshooting Cluster related issues using cluster administrator
- Responsible for Resolving Data Transfer related queries
- Provide assistance to resolve user queries
- Tuning T-SQL queries to improve performance.
- We work on Query Store in SQL 2016 to find the Root cause for the performance.
- Design and setup performance metrics, tuning and creating strategies for new projects.
- Work with the programming team, for optimal SQL Server behavior using query tuning and lock checking
- Providing disk management strategy based on database growth.
- Worked creating indexes and managing indexes for better performance.
- Monitored and modified Performance using execution plans and Index tuning.
- Working on PowerShell and generated health check and other report for performance
- Lead the implementation and management of Azure SQL databases for multiple clients
- Develop and maintain database migration strategies
- Optimize database performance and troubleshoot any issues
- Implement security measures to protect sensitive data
- Achieved 99.99% uptime for all databases under management
- Managed Azure SQL databases for small to medium-sized businesses
- Performed regular backups and disaster recovery procedures
- Assisted in database design and optimization projects
- Collaborated with developers to troubleshoot database-related issues
- Telefónica Germany operates second, third and fourth generation mobile networks, allowing customers to use GPRS, EDGE, UMTS up to HSPA+ and LTE for data connections. Most of O2 plans are available both in a pre- and postpaid version, including the all-in-one-flatrates called o2
- And o2 on for enterprise customers. Beside the core business, Telefónica Germany is one of the largest retailers for mobile phones and tablets without a SIM lock. It was the first operator offering both Apple's iPhone 4 and the iPad 2. Also, Telefónica Germany offers hosting services for large and midsized companies, serving some well-known portals including Spiegel Online and Sevenload. Together with Microsoft and Visionapp, Telefónica Germany provides a cloud service for Hosted Exchange.
InfraTechnology Specialist
Cognizant Technology Solutions
03.2017 - 07.2022
- Company Overview: Travelers are an insurance company that cares. Travelers takes on the risk and provides the coverage you need to protect the things that are important to you - your home, your car, your valuables and your business - so you don't have to worry. Travelers have been around for more than 160 years and have earned a reputation as one of the best property casualty insurers in the industry because we take care of our customers. Our expertise and focus on innovation have made us a leader in personal, business and specialty insurance and the only property casualty company in the Dow Jones Industrial Average. Every day, our approximately 30,000 employees and 13,500 independent agents and brokers in the United States, Canada, the United Kingdom, Ireland and Brazil help provide peace of mind to our customers.
- Tuning T-SQL queries to improve performance.
- Enabling Extended events to capture and to investigate for the better performance
- We work on Query Store in SQL 2016 to find the Root cause for the performance.
- Design and setup performance metrics, tuning and creating strategies for new projects.
- Work with storage/virtualization teams involving technologies like Avamar, TSM and Networker.
- Work with the programming team, for optimal SQL Server behavior using query tuning and lock checking.
- Worked on Autosys job to schedule backups and weekly maintenance job.
- Providing disk management strategy based on database growth.
- Troubleshooting various database issues and T-SQL queries.
- Worked creating indexes and managing indexes for better performance.
- Monitored and modified Performance using execution plans and Index tuning.
- Travelers are an insurance company that cares. Travelers takes on the risk and provides the coverage you need to protect the things that are important to you - your home, your car, your valuables and your business - so you don't have to worry. Travelers have been around for more than 160 years and have earned a reputation as one of the best property casualty insurers in the industry because we take care of our customers. Our expertise and focus on innovation have made us a leader in personal, business and specialty insurance and the only property casualty company in the Dow Jones Industrial Average. Every day, our approximately 30,000 employees and 13,500 independent agents and brokers in the United States, Canada, the United Kingdom, Ireland and Brazil help provide peace of mind to our customers.
Technical Lead
Cognizant Technology Solutions
05.2011 - 02.2017
- Company Overview: The Global Shared Services Center (GSSC) provides remote Infrastructure Management Services from its centers operating concurrently from India (Bangalore, Chennai & Pune) and Holliston (Massachusetts, USA). Cognizant's geographically distributed GSSC's form an effective delivery framework that ensures cost effective, high-quality. Global Shared Services leverages a highly automated platform and economies of scale to deliver a Best-in-Class Delivery Framework with emphasis on Non-linear growth and efficiency.
- Maintained and Administered SQL Server 2000, 2005, 2008, 2008R2 and 2012 Databases engines.
- Installation of SQL server, creating instance/cluster and customizing installation based on client's request
- Troubleshooting various database issues and T-SQL queries
- Maintained and strategized backup and restore scenarios
- Managed and maintained data distribution in all production and non-production databases servers.
- Database mirroring implementation and maintenance
- Allocating and Altering Space requirement of Data and Log files
- Designing Backup and Restore Policies
- Identifying and Resolving Abnormal Database Status
- Troubleshooting Cluster related issues using cluster administrator
- Responsible for Resolving Data Transfer related queries
- Provide assistance to resolve user queries
- Monitoring SQL Server Jobs
- Implementing and maintaining SQL server Replication
- Performing database refresh using transactional replication
- User creation and access related troubleshoot and fix
- DR activities and databases movement to other drives
- Providing disk management strategy based on database growth
- Maintenance of indexes and troubleshooting fragmentation issues
- Identifying and troubleshooting SQL server session blocks and deadlocks
- Adequate knowledge on configuring and maintaining Always ON feature
- Configuring database mail and mail alerts for instance and db level issues
- Performing SQL server upgrade and DR migration
- The Global Shared Services Center (GSSC) provides remote Infrastructure Management Services from its centers operating concurrently from India (Bangalore, Chennai & Pune) and Holliston (Massachusetts, USA). Cognizant's geographically distributed GSSC's form an effective delivery framework that ensures cost effective, high-quality. Global Shared Services leverages a highly automated platform and economies of scale to deliver a Best-in-Class Delivery Framework with emphasis on Non-linear growth and efficiency.
Database Admin
Cognizant Technology Solutions
04.2012 - 08.2012
- Company Overview: Corventis, Inc. is a pioneer in wireless cardiovascular solutions. The company's technology enables global personalized patient care by providing clinicians with actionable information for early detection of clinical events to support preventative and proactive treatment strategy.
- Generating daily/monthly reports as per clients requirement
- Updating patients records based on clients requests
- Basic Unix commands and scripting
- Creating SQL queries for clients ad-hoc requests
- Maintained at most responsibility and dedication towards work as it was a critical healthcare project
- Worked directly on clients production environment
- Adding new patient records and activating devices for their daily health tracking
- Technical troubleshoot for device malfunctioning and resolution
- Used basic DDL,TCL & DML commands in creating SQL queries
- Deletion and refresh of patient records through MSSQL
- Checking and editing scripts based on clients requirements
- Developing MSSQL Join queries for bulk results
- Immediate response to high importance requests
- Report generation for Pharma, US and Outside US patients
- Adhering to email etiquette practice while sending direct mails to clients
- Preparing weekly decks and PMR reports.
- Corventis, Inc. is a pioneer in wireless cardiovascular solutions. The company's technology enables global personalized patient care by providing clinicians with actionable information for early detection of clinical events to support preventative and proactive treatment strategy.
Education
Bachelor of electronics and communications engineering -
KLN College of information Technology
Madurai05.2010
S.E.V Matriculation Higher Sec School -
S.E.V Matriculation Higher Sec School
03.2006
Skills
- SQL Server 2000,2005,2008,2012,2016,2022
- Azure SQL
- MYSQL
- Mango DB
- Autosys
- Avamar
- TSM
- Networker
- Sentryone
- Insight
- ONTARGET
- Service NOW
- Remedy
- Windows Server 2000
- Windows Server 2003
- Windows Server 2008
- Windows Server 2008R2
- Windows Server 2012
- Win7
Certification
- Microsoft SQL Server Administration 70-764
- Microsoft SQL Server Provisioning 70-765
- CCP in SQL 2012 Brain Bench
- ITIL V3.0 External Certification
- Microsoft Azure Administration AZ-104
Disclaimer
I do hereby declare that all the information provided here is correct to the best of my knowledge.
Languages
- English
- Tamil
Personal Information
- Date of Birth: 06/09/89
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Affiliations
- Awarded star performer in Cognizant
- Best technology innovation award in 2011
Languages
Tamil
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Timeline
Associate Consultant
Tata Consultancy Services
10.2022 - Current
InfraTechnology Specialist
Cognizant Technology Solutions
03.2017 - 07.2022
Database Admin
Cognizant Technology Solutions
04.2012 - 08.2012
Technical Lead
Cognizant Technology Solutions
05.2011 - 02.2017
Bachelor of electronics and communications engineering -
KLN College of information Technology
S.E.V Matriculation Higher Sec School -
S.E.V Matriculation Higher Sec School
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Kalairani KKalairani K
Supply Chain Analyst / Buyer / Configuration Analyst (Team Lead) at HCL TechSupply Chain Analyst / Buyer / Configuration Analyst (Team Lead) at HCL Tech