Product Specialist
Tata Consultancy Services (TCS)
Total years of experience :10 years, 0 Months
Business Unit: AWS
Actively monitoring the performance of cubes within the EDW PROD Servers daily, identifying and analyzing failure trends to optimize
operational efficiency
Processing failed cubes swiftly and informing the Integration team to cease related jobs, ensuring consistent data integrity and workflow
continuity
Regularly participating in technical discussions and decision-making for defining business requirements, liaising with Business Analysts
and client teams to align on deliverables and expectations
Utilizing SSIS Packages to trace Source and Destination SQL tables, identifying the causes of missing data and rectifying discrepancies
Refining and generating SSRS reports, integrating data from SSAS packages to Excel reports for enhanced data visualization and analysis
Purging unnecessary data from Database tables, maintaining the optimum performance of cubes and ensuring system effectiveness
Leveraging knowledge in SSIS, SSRS, and SSAS to validate data from data mappings, verifying the accuracy and coherence of integrated
data
AWS DBA (EKS, EC2, S3) - Medtronic
Business Unit: AWS
Actively addressing SQL Database-related concerns, such as Backup/Recovery, and incorporating databases within the availability group
of Always-on, ensuring continuous data availability and security
Managing the containerization of Kubernetes within the AWS Cloud, optimizing deployments and enhancing resource utilization and
efficiency
Resolving various Kubernetes issues by creating namespaces and pods, and restoring pods by creating contrast environments, ensuring
system stability and resilience
Handling diverse challenges within the Critical Manufacturing Execution System (CMES), such as creating and upgrading various
application environments within the AWS Cloud, maintaining seamless operational flow and integrity
Tackling a range of SQL Database issues within the AWS Cloud, including validating SQL Log file paths in PROD, Dev, and Stage
environments and monitoring the usage of SQL resources, to ensure structured and efficient database management
Monitoring SQL DB alerts utilizing CloudWatch, Cloud9 within AWS Cloud, and responding to alerts related to full SQL DB Drives,
managing data and log files effectively within the AWS Cloud
Determining the optimal tool for monitoring SQL DB alerts within the AWS Cloud by analyzing various parameters, ensuring effective
alert management and quick response to maintain database health
SQL Server DBA - Meijer
Actively provided support in Database administration tasks, including configuration management, backup/recovery, performance
optimization, and space management, ensuring optimal system functionality
Executed database deployments and provided extensive support for application releases, facilitating seamless integration and
deployment
Assisted developers with MS SQL Server inquiries and resolved related issues promptly, enhancing team collaboration and knowledge
sharing
Undertook SQL administrative tasks including implementing maintenance plans, creating and modifying database objects, and
configuring and deploying MS SQL Server. This included meticulous performance tuning, monitoring, troubleshooting, and optimization
of databases to ensure optimal performance and reliability
Executed T-SQL queries to modify database tables, views, and managed database backups, restoring them to other SQL Server instances
as necessary to maintain data integrity
Addressed and resolved database space-related issues and monitored the DPA alert tool for critical database anomalies, preventing
potential data loss and disruptions
Administered and implemented changes to databases, allocated user access at both server and database levels, and generated DACPAC
snapshots for both PROD and Non-Prod databases, allowing user interaction with different pipelines
Oversaw the deployment of databases and monitored SQL Servers post the completion of maintenance plans, ensuring continuous
stability and optimal performance
Conducted bridge calls with developers and Application teams to resolve critical Database issues, fostering resolution and mutual
understanding among teams
Managed Database migrations from On-Premise to IBM Cloud, executed log shipping, replication, and collaborated on clustering for DR
testing to ensure data continuity and integrity
Served as a dedicated and pivotal resource, assuming ownership of all DB related tasks and executing them with precision and efficiency
Master of Computer Applications from MCA (NIT-Warangal) - 2007