Parveen Kumar
MYSQL-DBA | SQL || PostgreSQL-DBA | PYTHON | AWS | AZURE | SQL SERVER | LINUX | Bash Scripting
- Role
- Techn Infra Support Analyst at Accenture
- Location
- Gurugram, HR, IN
- LinkedIn followers
- 500 followers
About Parveen Kumar
I have spent years specializing in MySQL database administration, where I’ve honed my…
Experience
Techn Infra Support Analyst
Nov 2024 — Present · Gurugram, IN
Major Duties that I perform as a MySQL Database Administrator (DBA):1. Database Installation and ConfigurationInstall, configure, and upgrade MySQL server and related tools.Ensure proper setup of database environments (development, testing, production).2. Database Design and ArchitectureDesign database schemas, tables, indexes, and relationships.Optimize database structures to ensure efficient storage and performance.3. Performance Monitoring and OptimizationMonitor database performance and troubleshoot slow queries.Use tools like EXPLAIN and performance_schema to identify bottlenecks.Optimize database parameters and query execution plans.4. Backup and RecoveryImplement and manage database backup strategies (e.g, mysqldump).Test and ensure disaster recovery plans are effective.5. Security ManagementManage user roles, privileges, and authentication mechanisms.Implement measures to secure data (e.g, encryption, secure connections).Monitor for unauthorized access or security breaches.6. High Availability and ScalabilitySet up and maintain replication (Master-Slave, Master-Master).Configure MySQL clusters (e.g, Group Replication).Manage load balancing for scaling applications.7. Troubleshooting and Problem ResolutionDiagnose and resolve database errors, outages, and connectivity issues.Perform root cause analysis and prevent recurring problems.8. Upgrades and PatchesPlan and execute MySQL version upgrades.Apply patches to address security vulnerabilities and bugs.9. Automation and ScriptingAutomate routine database tasks using scripting languages.Develop and maintain scripts for backups, monitoring, and alerting.10. Documentation and ReportingDocument database configurations, policies, and procedures.11. Collaboration and SupportWork with developers to optimize queries and database access patterns.Support application teams in troubleshooting database-related issues.
Education
GITM Gurgaon
Bachelor of Technology - BTech
2015 — 2019
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.