Database Administrator
One97 Communication Ltd (Paytm)
Total years of experience :10 years, 4 Months
Responsibilities:
• SQL and no SQL server installation and configuration in on premises and cloud environment.
• DB server performance monitoring and optimization.
• Database migration and version upgradation.
• DB server cost optimization by downgrading/terminating the idle server; By deleting the outdated snapshot, AMI and S3 bucket data.
• EBS volume encryption and backup.
• DB backup using diferent technology like by dump utility, snapshot and through life cycle manager.
• User privileges review and management.
• Server and DB configuration review actively for time preventive action and downtime reduction.
• Database audit and security.
• EBS volume encryption and optimization.
• Database monitoring and alerting setup.
• Big tables alteration without any downtime with third party tolls like PT OSC and GH-OST.
• Database sharding technology implementation for MySQL and MongoDB.
• Query writing to extract data from DB as per the requirement and slow query optimization.
• Database task automation like mail triggering on deadlock condition, slow queries; Backup, duplicate index, configuration diference mail triggering.
• Open AI integration with DB like for translating human language in SQL query and giving privileges to execute DML query directly on the DB with limitation of set of rules.
• Managing team to increase productivity and reduce jerk in database operation.
Responsibilities:
• MySQL, MSSQL, MariaDB, MongoDB and PostgreSQL server installation, configuration, migration, upgradation and patch installation in Linux and windows environment.
• Migration of on premises databases to cloud and data center.
• Replication and PR DR setup for high availability of databases and 24x7 hour site operational.
• Cluster set up and maintenance.
• User access review and privileges management.
• Writing SQL query and optimizing the slow queries.
• HLD making for databases servers.
• Working closely with apps developers for database development.
• Database backup, archiving, restoration, and recovery.
• Database performance monitoring, optimization, issues analysis, resolution and RCA.
• Creating the bash script for lengthy and repetitive task.
• Scheduling/automating task in the servers using bash script cronjob and bat configuration windows schedular.
• Data security, data masking and documentation.
• Monitoring tool setup and vendor team coordination.
• EBS volume encryption and management.
Responsibilities:
• SQL and NOSQL server installation, configuration, monitoring and
performance tuning.
• DB server upgradation, migration and user management.
• Daily DB issue troubleshooting and its resolution. RCA preparation and
presentation for outage.
• SQL query writing and slow query optimization.
• Database maintenance, HA availability/scalability and DR/delay DB setup.
• DB server performance monitoring and alerting setup.
• Working with the audit and security team for data securing and
maintaining standard while working.
• Managing the crontab, Replication and scripting task.
• Planning for server hardware specification for new server and old server
upgradation.
• Router, switch and firewall configuration.
• DNS and DHCP configuration.
• Iptables management.
Responsibilities:
• Database Server installation, configuration and monitoring.
• Database performance monitoring, performance tuning, upgradation, Migration, patch installation and crash recovery.
• Database backup scheduling & restoration, Monitoring set up.
• SQL query writing and optimization; Daily DB issue troubleshooting and its resolution. RCA preparation and presentation Infront of higher management.
• User access and privileges management.
• High availability (HA) setup and performing DR drill.
• Assisting development team in database designing, query optimized query writing and providing testing DB infra.
• Linux and windows server installation, configuration and administration.
• Router, switch and IP phones configuration.
• C5, C4, rater etc. software installation for VoIP communication.
• Network packet analyzing through Wireshark to troubleshoot the issue in VoIP calls.
• Leading project delivery to client, FAT, SAT and AT.
Responsibilities:
• To configure, test and maintain LAN/WAN equipment like Router, Switch, Firewall and related services.
• Resolving network related issues on daily basis.
• Optimize network performance by supervising performance, addressing network problems and breakdowns.
• To design, install and configure the Wireless and Wired Network.
• Handling customer complaints and Team management.
• Wi-Fi small cell installation.
Responsibilities:
• Linux OS installation, configuration.
• To maintain and monitor Linux servers and application patch level, disk space and memory usage, user activities on day-to-day basis.
• Linux server OS and database issues troubleshooting.
• MySQL & MSSQL server installation and configuration.
• Database health checkup and performance monitoring.
• Database backup and restoration.
• LAN/WAN support deployment and configurations of routers, switches, wireless AP, firewalls, windows server and network storages.