Create and implement automation for AWS cloud platform as well as monitoring and alerting purposes. Migrated Oracle DBs to PostgreSQL Servers using ora2pg tool. Good experience in maintaining codes in GIT. Configured Grafana to monitor the PG Databases. Query Optimization and performance tuning of long running queries. Implemented Data Redaction in Oracle 19c. Upgrading databases from 11g & 12c to 19c. Working on Google Cloud Platform (GCP) services like compute engine, cloud load balancing, cloud storage, cloud SQL and stack driver monitoring. Setup GCP Firewall rules to allow or deny traffic to and from VMs instances based on specified configuration. Creating and managing cloud SQL instances using PostgreSQL 13 & MySql 8.0 and configuring the DB. Good experience in managing services using GCP console. Deep technical know-how of GCP container implementation for databases. Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities. Expert of writing shell scripting, Perl script for Linux/Unix. Expertise in snapshot, import/export, DB optimization with the help of explain plan. Implementing of logical and physical backups.

Establish and maintain security and integrity controls. Running Health check, ExaChk and SunDIAG Reports. Running ILOM snapshot report to check for any hardware issues. Coordinating with Oracle F.E to replace faulty hardware part in the Exadata component. Experience with managing physical Exadata Servers in the Data Centres. Converted Oracle and SQL Server databases to PostgreSQL & MySQL. Work on strategies to move databases from on prem to AWS Cloud. Create bash scripts to automate backups and upload copies to AWS S3. Create and implement automation for AWS cloud platform as well as monitoring and alerting purposes. Query Optimization and performance tuning of long running queries. Managing and supporting Oracle 10g. Creation of users and assigning custom roles to provide access. Good knowledge on replica sets election process and voting members to elect new primary. Adding and removing shards from sharded cluster. Analyzing profiler output and take actions to resolve issues. OPS manager installation and configuration for sharded clusters.

• Performing Image upgrade of the Exadata Machines.
• Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
• Migrated Databases from X3 to X7 machines.
• Upgraded Databases from 12c to 19c.
• Applying interim patches to Oracle Home.
• Upgrading OEM 13.2 to 13.3 and deploying plugins.
• Implementing ISCD on O.S as well as Databases as per the bank’s policies.
• Troubleshooting Network issues in the X7 Machine at the Data-Centres.
• Exadata machines maintenance and management experience.
• Configuring Backup I.P, NTP servers in the Exadata boxes.
• Solid skills to configure Exadata to meet company internal security requirement.
• Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

Good experience in migrating SQL Server databases to MySql using MySql Workbench. Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines. Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries. Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements. Establish and maintain security and integrity controls. Running Health check, ExaChk and SunDIAG Reports. Running ILOM snapshot report to check for any hardware issues. Coordinating with Oracle F.E to replace faulty hardware part in the Exadata component. Experience with managing physical Exadata Servers in the Data Centres. Upgrading OEM 13.2 to 13.3 and deploying plugins. Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues. Implementing ISCD on O.S (OEL & HP-UX) as well as Databases as per the banks policies. Troubleshooting Network issues in the X7 Machine at the Data-Centres. Exadata machines maintenance and management experience. Configuring Backup I.P, NTP servers in the Exadata boxes. Solid skills to configure Exadata to meet company internal security requirement. Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching. Design & manage PostgreSQL database schemas. Experience designing database structures, indexes, views, partitioning. Implementing of logical and physical backups. Monitor and manage database indexes for enhancing the performance.

• Monitoring Exadata Db-Servers and Cell-Servers, InfiniBand and Admin Switches using OEM, CellCLI and DCLI.
• Running Health check, ExaChk and SunDIAG Reports.
• Checking out the effectiveness of Flash Cache.
• Applying Bundle Patches, One-Off Patches.
• Performing Image upgrade of the Exadata Machines.
• Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
• Participated in half-yearly Emergency Preventive Maintenance activity.
• Checking out for the queries whether it is using Smart Scan or not.

My roles and responsibilities in the project: Monitoring Exadata Db-Servers and Cell-Servers, InfiniBand and Admin Switches using OEM, CellCLI and DCLI. Running Health check, ExaChk and SunDIAG Reports. Checking out the effectiveness of Flash Cache. Configured IORM and Instance caging Applying Bundle Patches, One-Off Patches. Performing Image upgrade of the Exadata Machines. Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state Participated in half yearly Emergency Preventive Maintenance activity. Checking out for the queries whether its using Smart Scan or not.

• Performing Load testing for SQL Queries and tuning the Queries when required.
• Deploying SQL Queries called as ‘Rule Query’ in the Production UI.
• Scheduling and Maintaining jobs using PL\SQL blocks.
• Tuning Queries, SQL, PL\SQL.
• Implemented TDE in Oracle 11gR2.
• Implemented Data Redaction in Oracle 12c.
• Upgrading databases from 11.2.0.4 to 12.1.0.2.

Leveraging deep integrations into retailers point-of-sale systems, Incomm provides connectivity to a variety of service providers that allow consumers to conduct everyday business at more than 500,000 points of retail distribution. Whether those consumers are activating prepaid products, paying bills, enjoying real-time discounts through a membership card, purchasing digital goods in-store or adding funds to an online account, Incomm is there to provide unique gift-gifting opportunities, cater to on-the-go shoppers, deliver added value through loyalty programs and serve cash-based consumers. My roles and responsibilities in the project: Performing Load testing for SQL Queries and tuning the Queries when required. Deploying SQL Queries called as Rule Query in the Production UI. Scheduling and Maintaining jobs using PLSQL blocks. Tuning Queries, SQL, PLSQL. Implemented TDE in Oracle 11gR2. Implemented Data Redaction in Oracle 12c. Upgrading databases from 11.2.0.4 to 12.1.0.2.

• Analysis of the specifications provided by the clients
• Administrating Exadata Servers
• Handling Incident tickets to ensure 24x7 database availability
• Implementing change requests in plan time.
• Coordinating with clients & other team to fulfill their requirements.
• Identifying blocking users in application transaction
• Creating Users with quota Management and assigning the relevant profiles
• Granting specific privileges and roles to the users
• Implemented invalid login attempts auditing
• Re-organization of tables and logical structures to remove fragmentation
• Resolved oracle performance issues involving disk I/O, CPU Usage, Query tuning.
• Performed capacity planning in order to be ready for space requirements
• Trouble shooting databases issues to be in-line with SLA.

Sweden Project includes all the Sweden Customer databases which logica supports from offshore. This project has its own Ticketing tool (Service Center) & Multicenter (Servers monitoring and for taking control). All customer servers are listed into Multicenter from which the logins, alert details and all other details related to the server can be found.

Sanofi S.A. is a French multinational pharmaceutical company headquartered in Gentilly, France, as of 2013 the worlds fifth-largest by prescription sales. Below were my roles and responsibilities: Analysis of the specifications provided by the clients Administrating Exadata Servers Handling Incident tickets to ensure 24x7 database availability Implementing change requests in plan time. Coordinating with clients & other team to fulfill their requirements. Identifying blocking users in application transaction Creating Users with quota Management and assigning the relevant profiles Granting specific privileges and roles to the users Implemented invalid login attempts auditing Re-organization of tables and logical structures to remove fragmentation Resolved oracle performance issues involving disk I/O, CPU Usage, Query tuning. Performed capacity planning in order to be ready for space requirements Trouble shooting databases issues to be in-line with SLA. Ensuring regular RMAN backups & archive backups to the Networker Backup Server. Installation and Creation of Prod, Dev and Test environments