Ambi Randria

My mission consists to administrate database : MS SQL (on premise and Azure), MongoDB in Replica Set, MySQL, MariaDB, to optimize the database with Dynatrace I installed and configured also the MondoDB Cluster on Premise during ma mission.

At the Domaine Performance & Sécurité Applicative team, I'm in charge of database performance and optimization on Premise and Cloud environnement (GCP, Azure, Oracle Cloud) for all Carrefour applications. I have a good knowledge of 4 databases : Oracle, PostgreSQL, MySQL, SQL Server. So my daily tasks consist : - to monitor the database with database tools like Graphana, Precise Oracle, Cloud Control 13c, Appdynamics. - to identify and to fix deadlock issue on production database - to help product owner to optimize the database, the procedures, the SQL queries. - to audit the database during the stress test or nominal test. At the end, I summarize my interventions (problem, solution) in an audit report. With BtoC team, I implemented the new oracle database on Cloud Oracle and migrated the data from on-premises to Cloud Oracle.

Bolivar-Emden is an international application used by traders to lend and to borrow securities at the market place. Working at Bolivar-Emden application, which is developed with Transact SQL technologies on SQL Server database, my job consists of : - Identifying the slow-running queries, the costly queries, and bottleneck issues - Proposing solutions to resolve the issues. - Implementing the propositions - Testing the solutions - Establishing the reading with the average improvement - Organizing final meetings with the developer team from London and the QA team from Mumbai

My mission on Connexis Cash could be resumed with three points: · Database administration · Database administration study · Oracle PL/SQL Developer As DBA, I administrate all database oracle cluster 12C : on UAT and on DEV, my principal tasks are : · Setup oracle software 12c on Linux server · Migrate data from Aix server to Linux server · Migrate data between two instances for example from UAT2 to DEV24 · Refresh data on development environment by production data using RMAN technology. · Resolving all oracle bugs on the database for instance : ORA-38760 : this database instance failed to turn on flashback database, ORA-00020 maximum number of processes exceeded · When the database shuts down, we restart it, fixing all bugs · Installing backup and restoring strategy of database As DBA Study : · Generating database schema with ORACLE SQL DATA-MODELER · Modifying database design with ORACLE SQL DATA-MODELER · Choosing and putting the good setting of parameters for each database instance for example : the value of RAM : sga_target, pga_aggregate_target · Optimization reporting request to improve execution time using partition table As Oracle PL/SQL developer I have developed SQL script : · to migrate user list from connexis to new UI. · to insert data from CX_AUDIT_LOG to new table in another schemaMy mission on Connexis Cash could be resumed with three points: · Database administration · Database administration study · Oracle PL/SQL Developer As DBA, I administrate all database oracle cluster 12C : on UAT and on DEV, my principal tasks are : · Setup oracle software 12c on Linux server · Migrate data from Aix server to Linux server · Migrate data between two instances for example from UAT2 to DEV24 · Refresh data on development environment by production data using RMAN technology.

Inside the CCAS EDF company, my missions consisted of administrate database, tunning SQL and database As Technical leader : - I helped Developers team, BA team to design the database - I valided the database conception, the SQL scripts before delivering for test. - I checked the bottleneck or slow-running queries at the application running in production As DBA (There were 4 SGBD at CCAS EDF : Oracle 11g, MS SQL Server 2014/2016, PostgreSQL, MySQL, Sybase): - I insured the dispnibility of the databases - I installed the new version - I did the backup and the restoration of the databases - I imported and exported the data from production to developement environment

As PL/SQL developer, my mission consisted to develop new outgoing flows of Ekip application.

After reading the technical specification document, my mission consisted to develop a new ETL with PL/SQL language that it used by marketing team to analyse the comportement of customer calling the numbers : 614, 618

Fidelia Assistance application is a full oracle application. My job consisted to develop some procedures and functions with PL/SQL which was called by Java Webservice.

Inside T-Systems, my job was to resolve all oracle bug on Carbase application. After, I must validate the solution with the customer online before closing the ticket.

As part of the database migration project of THELEM Assurances from AS400 to Oracle 9i, my mission is to develop PL/SQL batch validation scripts running on the new database according to the specifications written by the MOE.