Snehal Pandya
Edison,NJ
Summary
Knowledgeable Data Manager bringing 10 years and thorough, hands-on approach to analysis and handling of database systems in AWS . Expert navigation of complex data storage, development , deployment and migration with SQL server, MySQL, PostgreSQL and other databases.
Overview
17
17
years of professional experience
Work History
Database Manager
Ziff Davis
08.2013 - Current
- Developed and maintained multiple database systems on Microsoft SQL server, MySQL RDS/Aurora , Amazon RedShift, DynamoDB, PostgreSQL and Oracle.
- Created Tableau dashboards for weekly, monthly and yearly reports from SQL server, MySQL and other data sources and set up automatic refresh.
- Used AWS Database Migration Services and data pipelines to migrate database objects from SQL Server to PostgreSQL, Amazon RDS ,Amazon Aurora and external data sources.
- Generate weekly reports on MSSQL, MySQL, amazon Redshift, database health and any possible missing table indexes, sort keys and dist keys.
- Extensive experience using RDS, EC2, S3, Lambda, amazon Glu , IAM and variety of AWS services .
- Set up database application alerts and monitoring using AWS SNS, Clodtrail and CloudWatch , services.
- Set up and scheduled cost optimization, trusted advisor and other dashboards in Amazon Quicksight using AMzon Glu, Lambda, S3 and Amazon Athena.
- Used Jenkins to deploy packages to QA and Production servers
- Interface with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems.
- Maintain all user and system access across the board follow security compliance rules.
- Maintain multiple AWS accounts within organization.
- Set up CloudHealth accounts, perspectives and assets for different AWS and GCP accounts within organization.
- Set up EC2, S3, EBS volume, RDS, RedShift, ElastiCache, Elasticsearch cost and usage reports in CloudHealth..
- Set up Datadog performance and monitoring metrics and alerts for different database systems.
- Set up and refresh Google data studio reports using CloudHealth ,S3 and other data sources for different business units.
- Allocating system storage and planning future storage requirements for the database systems.
- Helped Operations team by generating monthly RIs, cost , performance analysis for different database systems across different accounts within organization.
- Handled regular updates and upgrades to RDS, RedShift, EBS volumes and other services.
- Used PowerShall, and Python scripts for different CI/CD tasks.
- Maintain Github repositories for database scripts and other deployment scripts.
Database Administrator
Ziff Davis
06.2011 - 08.2013
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Maintained staging , QA and Production SQL Server, MySQL and Oracle databases in AWS infrastructure.
- Set up Microsoft SQL server clustering using always on availability groups and database mirroring techniques.
- Set up and configured SSIS and SSRS for different business reports.
- Design, develop, test, deploy and maintain database security and audit solutions.
SQL Server Developer
Ziff Davis
01.2009 - 06.2011
- Enhanced database performance by optimizing SQL queries and stored procedures.
- Streamlined data management processes for faster retrieval of critical information.
- Conducted regular database maintenance activities to optimize performance and eliminate potential issues before they arose.
- Migrated SQL Server databases from datacenter to Amazon cloud..
SQL Server Developer
TLC Technologies
11.2006 - 12.2008
- Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects
- Install, configure and deploy MS SQL Server
- Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases
- Prepares users by conducting training; providing information; resolving problems
- Standardize and manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing
Education
Masters in Computer Science -
New York Institute of Technology
New York, NYBachelors in Computer Science -
D.Y Patil College of Engineering
Skills
- AWS , Google cloud computing
- Performance Tuning
- Database Administration
- Data Modeling
- Data Migration
- Troubleshooting
- Business Intelligence
Timeline
Database Manager
Ziff Davis
08.2013 - Current
Database Administrator
Ziff Davis
06.2011 - 08.2013
SQL Server Developer
Ziff Davis
01.2009 - 06.2011
SQL Server Developer
TLC Technologies
11.2006 - 12.2008
Masters in Computer Science -
New York Institute of Technology
Bachelors in Computer Science -
D.Y Patil College of Engineering
Similar Profiles
Uttam Kumar SutariyaUttam Kumar Sutariya
Business Development Executive/Sr.Research Analyst at Demandshore - Ziff Davis Company(Ziff Davis Performance Marketing)Business Development Executive/Sr.Research Analyst at Demandshore - Ziff Davis Company(Ziff Davis Performance Marketing)
Erica DevaneyErica Devaney
Editorial Director, CNET.com at Ziff DavisEditorial Director, CNET.com at Ziff Davis
Georgina KennedyGeorgina Kennedy
Product Leadership at Ziff DavisProduct Leadership at Ziff Davis