OBJECTIVE
A dedicated professional, targeting senior level assignments in AWS Data Engineer, Database Developer or Database Administrator with an organization of high repute across IT, Product Based Industry PROFILE SUMMARY
PROFILE SUMMARY
- Masters in Computer Application professional offering 10 years of experience in Database Administration, Data Engineer, Data Analysis, Data scientist and Web Development.
- Analyze and plan for testing and implementation new technologies to enhance database posture, including major MySQL version upgrades.
- I have experience setting up slave servers and implementing selective database replication. I am also experienced in setting up multichannel replication.
- Our top priority is to ensure the utmost level of availability for our database systems and infrastructure.
- Keen interest in the areas of Statistical Modelling, Predictive Analytics, Data Visualization, Machine Learning and Web Development.
- 8 Years’ experience using and deep knowledge of MySQL, MariaDB, PostgreSQL Database.
- 2 Years’ experience as AWS Data Engineer.
- I also have experience with AWS, EC2, S3, lambda, Glue, Athena, Dynamodb, Kinesis, Redshift, Percona, Python, PySpark, Pandas, Numpy, Matplotlib.
- Monitor the DB performance for slow queries, indexes and various other DB metrics.
- Advanced and updated knowledge of database security, backup and recovery and performance of monitoring standards.
- Having experience of running own organization.
- Also have a wide experience in working Govt., Private as well self-owned organization.
Education and Qualifications
2012 - Master of Computer Application
Pt. Ravishankar Shukla University, Raipur (C.G.), INDIA
2009 - Bachelor of Computer Application
Guru Ghashi Das University, Bilaspur(C.G.), INDIA
Current Position
BS Fintech Private Limited , Bangalore as Database Administration
Duties:
- Optimize database systems for performance efficiency.
- Perform space management and capacity planning for database systems.
- Creating complex functions, scripts, stored procedures, and triggers to support application development.
- Perform data back-up and archival on regular basis.
- Test databases and perform bug fixes.
- Develop security procedures to protect databases from unauthorized usage.
- Using Services (S3,RDS, AWS Glue, Redshift, Glue, Lambda, Python, EC2 and SQL)
- Database using MySQL
- Big data technologies PySpark
Past Positions
National Informatics Centre Services Inc. (NICSI), Raipur as Database Administration
Duties:
- Installed, Maintained and upgraded MySQL, MariaDB, PostgreSQL.
- Point-in-time-Recovery, Physical and logical backup, Incremental Backup and Restore using Percona XtraBackup, Users and Privileges Management
- Administration of the database including performance monitoring and testing.
- Creating backup copies of database.
- Developed and created ER diagram, views, index, stored procedures and functions.
- Involved in the design of Physical Database schema, data modeling and performance tuning.
- Monitoring of database size and disk space in Production Environment.
- Using Services (S3,RDS, AWS Glue, Redshift, Glue, Lambda, Python, EC2 and SQL)
- Writing complex queries for SELECT, UPDATE, and DELETE in Redshift.
- Restoring a Redshift cluster from a snapshot.
- Copying data from S3 into Redshift tables.
- Copying JSON data from S3 to Redshift tables.
- Setup a Python virtual environment for Redshift.
- Creating a multi-node Redshift cluster.
2013-2014 Pt. Ravishankar Shukla University ,
Raipur
Duties: Assistant professor
Duties: Web Designing , Content uploading.
Other Skills
- Spoken languages: English (elementary proficiency), Hindi
- Programming Languages: PHP, MySQL, Python, C++ (expert), Java,Django, Jquery, Ajax, moment.js, Codeigniter(Expert), Numpy, Pandas, sklearn, tensorflow
- Machine Learning: Classification, Clustering, Regression, Anomaly Detection, Recommendation, Time Series
- Visualization: Matplotlib, Seaborn, Bokeh
Journal Publications
R.D. Nirala, Shiva Manhar “Visual Improvement for Dense foggy & hazy weather images,Usig Contrast enhancement techniques” ISST Jouranal of Electrical & Electronics Engineering Vol. 7 No1 jan – june 2016 pp 53-62. ISSN 0976-7363.