Creation of Migration script in Bash from Production to Staging/QA Environment in AWS RDS. Copy of database in different servers and snapshot of AWS RDS instance. Creation of script to Mask client’s sensitive data. Backup and Restore Data Debug Database Issues on Live Data Configure Database Software Develop and Test Methods to Synchronize Data Install Database Software Optimize Queries on Live Data Set Security Permissions for Database Work Closely with Development Teams with Regards to Database Updates and Design Troubleshoot Database Errors providing user training, support and feedback Minimise database downtime and manage parameters to provide fast query responses Monitor database performance, implement changes and apply new patches and versions when required Develop solution architecture and technical design of the applications. Restructure the database from unnormalized to normalized database from legacy to upgrade application Cross database migration, from MS SQL server 2012 to PostgreSQL using shell scripting. Cross database migration, from MS SQL server 2012 to MySQL using shell scripting. Creation views, functions and stored Procedures as per the requirement like implementing logs, pagination sorting etc on data to be shown on frontend. Performance tuning of queries. Creation of triggers to monitor unknown values in legacy tables and make the changes as per the requirement of SRS. Installation of Operating System (CentOS 7 / Redhat RHEL 7) and packages using YUM and PIP. Maintains database performance by troubleshooting problems. Secures database by developing policies, procedures, and controls. Prepare documentations and specifications Performs routine tests and modifications to ensure that a database is performing and running correctly Monitor root cause analysis and resolutions Install upgrades and maintain systems Deploy database change scripts provided by third party vendors Document the company’s database environment Automated Backend process through Shell Scripting, extensively optimized Batch Processes. Extensively developed Stored Procedures and Triggers, data feeds to downstream systems. Maintain security database, including creating and modifying tables, monitoring traffic, and importing and synchronizing data. Establish modules to identify and remove duplicate client data and applications. Wrote PL/SQL module to migrate and reconcile data from third parties into database. Created multiple programs to ensure correct data transfer and communications between Oracle database and SQL Server. Application and database monitoring and reporting bugs in application. Provide SQL Scripts to resolve client issues. Manage internal systems/network access, monitoring, backup/restore, upgrades Automating command input or entry using shell scripting. Customizing administrative tasks. Database and log Analysis while resolving client issues. Coordinating with L3 Team located in Sweden for resolving the issue.