May 2022 – Oct 2024 · 2 yrs 5 mos · Bengaluru, Karnataka, India · On-site

• ➢ Design and implement database structures that support business applications and goals.Work with development teams
• to design schemas that are efficient and scalable.
• ➢ Optimize data storage and retrieval methods.
• ➢ Monitor and optimize database performance.
• ➢ Analyze query performance and make recommendations for improvements.
• ➢ Index optimization and query optimization.
• ➢ Implement and manage backup strategies.
• ➢ Regularly test backup and recovery procedures to ensure data integrity and availability.
• ➢ Develop disaster recovery plans.
• ➢ Implement and manage database security policies and access controls.
• ➢ Monitor for security vulnerabilities and apply patches or updates as needed.
• ➢ Conduct regular audits to ensure compliance with security standards.
• ➢ Use monitoring tools to oversee database health and performance.
• ➢ Troubleshoot and resolve database-related issues or outages.
• ➢ Conduct root cause analysis and apply corrective measures.
• ➢ Perform routine maintenance tasks such as vacuuming, reindexing, and data purging.
• ➢ Ensure databases are up to date with the latest patches and updates.
• ➢ Manage and optimize storage.
• ➢ Maintain detailed documentation of database configurations, procedures, and changes.
• ➢ Generate reports on database performance, usage, and other metrics.
• ➢ Work closely with developers, system administrators, and other IT staff.
• ➢ Communicate database-related information to non-technical stakeholders.
• ➢ Provide technical support and guidance to other team members.
• ➢ Providing 24/7 production support
• ➢ Applying PSU patch to production, QA, Dev and Testing databases
• ➢ Maintenance of logical and physical structure of databases
• ➢ Created Datadog-log dashboard for tracking alerts for all the Databases ie. Mysql, Mongo, PostgresSQL
• ➢ Set up and controlled user access levels across databases to protect important data.
• ➢ Developed scripts and processes for data integration and maintenance.

Jul 2017 – May 2022 · 4 yrs 10 mos · Bengaluru Area, India

• ➢ Creating USER's and handling all activities(Mysql, Reshshift, Mongo, GIT-LAB,Mixpanel, Mandrill, AWS etc).
• ➢ Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• ➢ Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• ➢ Involved in data loading using Redshift and Mysql calling UNIX scripts to download and manipulate files.
• ➢ Created alerts for many projects those have an a high CPU utilizations in project, (Aws & Kibana alerts).
• ➢ Written SQL queries for project enhancement.
• ➢ Created tables and other database objects for the project enhancement.
• ➢ Handling main part in deployment release process weekly basis.
• ➢ Maintaining Create/Modify Batch jobs of oracle,Unix and Control M jobs and interfaces of Regular monitoring of failure alerts
• ➢ Handled job failures by understanding the root cause of job failure and fixing it by communicating with the source & consumer teams.
• ➢ The major part of my team included Constant Analysis, System Monitoring, and Responding to customer queries and also to Critical/Server business problems.
• ➢ The behaviors of existing and new jobs are captured and suggestions given for proper SLA improvement.
• ➢ Provide updates on long-running issues at least once every two hours.
• ➢ Resolving the L2 tickets based on SLA and Forwarding to L3 team if fix is required Interacting with onsite clients.
• ➢ Jira Tickets creation from email.

Jan 2015 – Feb 2017 · 2 yrs 1 mo · Bengaluru Area, India

• ● Monitoring all the recording service using Mysql and ubuntu.
• ● Deploying New Services and updating of service in the ubuntu server. Monitoring All the servers by using Zabbix Monitoring Tool.
• ● Managing MySql database that includes all the operation DDL,DML,DQL. Troubleshoot the servers and application issues.
• ● Experience in customer handling queries.
• ● Experience in database administrators, Cloud moments all activities.
• ● Reviewing of all the error logs and fixing issues,
• ● Experience in installing configuring and maintaining services like Apache & Mysql,
• ● Experience in Linux servers in virtualized environments.
• ● Remote support of on-site engineers and end users/customers during installation.
• ● Remote troubleshooting and fault finding if issues occur upon initial installation.
• ● Speaking with customers via email and phone for initial requirement capture.
• ● Participation in providing training to customers as required.
• ● Documenting troubleshooting and problem resolution steps.
• ● Resolving escalated customer complaints without the need for team lead intervention.
• Strong technical experience in Unix/Linux, Shell scripting, Server Management for REAL suite of products.