Mysql
· Install and maintain the performance of MySql database servers.
· Develop processes for optimizing database security.
· Set and maintain database standards.
· Manage database access.
· Performance tuning of database systems.
· Install, upgrade, and manage database applications.
· Diagnose and troubleshoot database errors.
· Solid knowledge of Linux and experience in shell programming.
· Create policies and strategies for backup/recovery, upgrades, and migrations.
· Expert knowledge with DBA activities like create database, users, tables, views, stored procedures, checking profiles, roles, grant/revoke permissions, space management and troubleshooting, database monitoring and periodic performance tuning.
· CDC implementation using Kafka and Maxwell to capture changes till table level.
Percona
· Install and maintain the performance of Percona database servers.
· Expert knowledge with DBA activities like create database, users, tables, views, stored procedures, checking profiles, roles, grant/revoke permissions, space management and troubleshooting, database monitoring and periodic performance tuning.
· Percona Xtra-DB Cluster Implementation and Configurations.
• Create functions, scripts, stored procedures and triggers to support application development.
• Design, develop and implement database systems based on customer requirements.
• Optimize database systems for performance efficiency.
• Develop database tables and dictionaries.
• Ensure data quality and integrity in databases.
• Identify any issues related to database performance and provide corrective measures.
• Participate in database design and architecture to support application development projects.
• Perform data back-ups.
• Monitor Application related Jobs and Data Replications.
Teralight is Telecom company , its Prevail Software System provides bypass fraud Call Detection and other types of network fraud detection services via passive methodology, in which our system analysis the client’s provided CDRs and detects Bypass fraud in the network
• Serving more than 10 Telecom operators around the globe.
• Creation of Client Accounts for Client Tool.
• Generation and Updation of Reports per Client’s request.
• Generation of Reports on the basis of CDRs provided by Clients.
• Working on Backup Servers Replication.
• Working on Data Migration.
• Generation and Improvement of CSV data files for different clients.
• Ensuring smooth functioning of whole business process associated with or related to Database.
• Managing SIMBOX, VOIP / Internet bypass fraud detection with the help of Details CDR analysis and devising up to date rules to catch various frauds like grey traffic etc.
• Development of new controls for fraud detection and Revenue leakages in various areas based on CDR analysis by Research and Development.
• Monitoring the Voice, SMS and GPRS traffic of GSM Postpaid and Prepaid Subscribers.
• Coordinate closely with other business functions to design, develop, and implement best practices
• Resolving day to day queries provided by Our Telecom engineers along with daily Calls on Different Operators using TARGET CALL GENERATION (TCG).
Worked as Oracle Developer.
Primary Role is to work either in an individual capacity or with a team of consultants to complete assigned project tasks involving Oracle Financials within due timelines
• Meeting with clients for Application Demo.
• Propose all possible solutions to senior Management for identified issues.
• Studied, analysed business needs, gathered requirements, identifying gaps, designed and implemented Oracle Applications.
• Reviewed as-is (existing) business process and prepared to-be (new) process flows for multiple business scenarios.
• Prepared BP 40 document based on AS IS and BP 80 on TO BE using the flow charts.
• Assisted Technical team for Data Migration and Data Integration.
• Prepared test scripts, Master data scripts and assisted technical team for data migration.