Rupesh Verma
DB Specialist
Summary
A results-driven IT professional with a total of 10.5 years of experience, specializing in database management for 9.5 years and database analytics for 2.5 years.
Excellent communication and collaboration skills, capable of effectively conveying complex technical concepts to both technical and non-technical stakeholders. Passionate about leveraging data to unlock actionable insights and drive business growth.
Overview
11
11
years of professional experience
4
4
Certifications
3
3
Languages
Work History
DB Specialist
Amdocs
Gurgaon
11.2016 - Current
- Performance Trend Analysis: Analyze AWR data over time to identify performance trends, such as CPU utilization, I/O throughput, response times, and resource contention. This helps in understanding how the database performance has evolved and detecting any anomalies.
- Database Growth Analysis: Monitor and analyze AWR data to track the growth of the database, such as data file size, tablespace utilization, and segment growth. This aids in capacity planning and ensures sufficient space availability.
- Active Session Analysis: Identify the most active sessions and their associated activities based on AWR data. This helps in understanding the workload patterns, resource consumption, and potential contention points within the database.
- Conducted in-depth data analysis on remedy service tickets for all EMEA accounts, identifying patterns, trends and insights. Using this analysis, do visualization and eliminate redundant task using automation
- Issue Identification: Utilizing NLTK's text analysis capabilities to identify issues within textual data present in remedy summary and resolution section for all accounts
- Got chance to work in several databases like Oracle, Mysql, Postgresql , MSSQL Server, Mongo DB in different projects
- Designed, implemented, and maintained complex database architectures, including schema design, indexing strategies, partitioning, high availability etc
- Conducted database performance tuning and optimization, identifying and resolving bottlenecks to enhance system efficiency.
- Worked as a team lead in four out of seven EMEA accounts at Amdocs, successfully managing and overseeing key projects and teams.
Database Administrator
Mcarbon Tech Innovation
Noida
07.2016 - 11.2016
- Assisted in SQL query optimization and tuning for improved database performance
Database Administrator
Telemune Software Solutions
Noida
07.2013 - 11.2016
- Assisted in database administration tasks, including database installation, configuration, and maintenance. data migration projects,database design and schema development
- Conducted regular database backups and performed data restoration when necessary.
- Collaborated with cross-functional teams to troubleshoot and resolve database-related issues.
Executive Internet Marketing
Indiamart
Noida
10.2012 - 10.2013
- Managed and executed SEO strategies to enhance website visibility, increase organic traffic, and improve search engine rankings.
- Conducted keyword research, on-page optimization, technical SEO, monitored analytics, performed regular audits, and continuously optimized SEO tactics to drive measurable results.
Skills
DB specialist
Data Analysis and Visualization
Statistical analysis
Problem Solving Skills
Machine Learning (MLDLC)
Scripting and Automation
Big Data Skills
Additional Information
- B.TECH in Computer Science from N.C College of Engineering, Israna, Panipat, Haryana, India (2012) with 79%
- Higher Secondary Examination from DAV Public School, Panipat India(2008) with 79%
- All India Secondary School Examination from DAV Public School, Panipat India(2006) with 82%
Certification
Oracle Database SQL Certified Expert
Accomplishments
- Win advanced category award in AMDOCS Got Talent 2021 - Leg movement with headstand
Timeline
Amdocs Smartops python Certification
01-2023
DB Specialist
Amdocs
11.2016 - Current
Database Administrator
Mcarbon Tech Innovation
07.2016 - 11.2016
Database Administrator
Telemune Software Solutions
07.2013 - 11.2016
Oracle Database 10g: Administration II
03-2013
Executive Internet Marketing
Indiamart
10.2012 - 10.2013
Oracle Database 10g: Administration I
09-2012
Oracle Database SQL Certified Expert
05-2012