DHRUV JOSHI
Noida, India **th Sept ‘** +91-971**-*****
*****.*********@*****.*** GitHub LinkedIn
Associate Database Administrator with 3+ years of experience in data management, analytics, and enterprise database systems. Experienced in SQL Server administration, database performance tuning, backup and recovery, and data pipeline support for high-volume transactional systems. Skilled in cloud data platforms and automation using Python and SQL. Background in analytics, cloud services, and business intelligence with growing expertise in data engineering and AI-driven analytics. Adept at collaborating with cross-functional teams to ensure data availability, integrity, and performance in mission-critical environments. Work Experience
Hitachi Rail GTS, Delhi
Database Administrator [Jan 2026 – Present] •
• Administer SQL Server databases for enterprise transactional and reporting systems. Monitor database health, performance, and availability using SQL Server tools and scripts.
• Perform database backups, restores, patching, and disaster recovery procedures to ensure business continuity.
• Optimize queries, indexes, stored procedures, and execution plans to improve system performance.
• Implement data validation, reconciliation, and auditing for transactional and operational datasets.
• Manage database security including user roles, permissions, and access control policies.
• Support database migrations, schema design, and upgrades for legacy and modern applications.
• Collaborate with application and infrastructure teams to resolve database-related incidents.
• Automate routine DBA tasks using SQL scripts and Python to reduce manual effort and errors.
• Assist in designing data pipelines and reporting layers for analytics and compliance needs. Infosys Limited, Chandigarh
Data Analyst [June 2022 – July 2025]
• Collected and analyzed customer data to identify trends, behavior patterns, and retention risks impacting customer lifetime value.
• Built predictive models to forecast customer churn and segment customers for cross-sell opportunities.
• Created and managed dashboards using Tableau and Power BI to monitor KPIs related to customer engagement, success, and adoption.
• Collaborated with Marketing, Finance, and Operations teams to translate data insights into business strategies.
• Developed scalable ETL workflows using SQL, AWS Glue, Lambda, and DMS to support real-time and batch analytics.
• Ensured high data quality with validation, cleansing, and anomaly detection processes.
• Delivered presentations and reports to senior stakeholders, driving decisions aligned with customer value. Education
Banarasidas Chandiwala Institute of Professional Studies, GGSIPU University [Aug 2020 – June 2022]
• Completed MBA (Marketing and Operational Analytics). Ambedkar Institute of Advanced Communication Technologies and Research, GGSIPU University [June 2016 – June 2020]
• Completed Bachelor of Technology in Electronics and Communication Engineering. Relevant Projects/Certifications
SuperMarket Sales Analysis Link
• Conducted an exploratory data analysis on supermarket sales data using Python, Pandas, Matplotlib, and Seaborn.
• Analyzed customer demographics, purchase behavior, and sales trends.
• Identified key insights to enhance business strategies and improve customer satisfaction. Tableau Dashboard Link
• Created a comprehensive dashboard that analyzed transaction data to identify popular payment methods, frequency of use, and demographic preferences. The insights derived helped tailor marketing strategies to different customer segments, optimize payment processing, and enhance customer satisfaction. AWS Certified Cloud Practitioner - CLF C01 Certification Link
• AWS Anomaly Detection in Real-time by using data generated from Kinesis Data Streams and Process using Kinesis Data Analytics.
• Event-driven Serverless Data Processing with AWS Lambda, SNS and SQS using Amazon Event Bridge as event trigger and S3 as storage.
• Migration of Database with DMS from on premise system to AWS cloud or vice versa.
• Making a Serverless Dashboard using AWS Athena, QuickSight and S3 storage. Google Data Analytics Professional Certification Link
• Hands-on experience in data wrangling, visualization, hypothesis testing, and communicating results to stakeholders. Technical Skills
Programming Languages: Python, SQL
Libraries/Frameworks: NumPy, Pandas, Matplotlib
Tools / Platforms: Git, SAP MM (P2P cycle, WM)
Databases: MySQL, AWS RDS, SQL server
BI & Analytics: Tableau, Power BI
Cloud & Data Engineering: AWS S3, Glue, Lambda, Kinesis, DMS, Athena