Ashokkumar Mani

Presently working for Emirates Group client on a crucial evaluation of distributed database products such as Yugabyte, Postgresql, AWS RDS to find an alternative for transactional database workloads.
Successfully deployed and delivered Yugabyte database active-active replication (bi-directional distributed database) on AWS multi cloud regions and completed the POC on time.
Executing and working with yugabyte team for TPC -benchmark.
Upgraded mission critical database for massive upgrade projects from previous release of Oracle 11g, 12c to the Latest release (Oracle 19c) for multiple airlines applications.
Developing automation script for user creation then deployed to avoid manual intervention
Coordinating with performance benchmark team for multiple application team in order to optimize the DB SQL query and server performance.
Successfully Responsible for converting

AccelAero-ISA is (public joint stock company(semi government) - Air Arabia) provides aviation technology solutions for Centralized Reservation systems, Airport check in system and Crew management system, departure control like baggage clearance, travel and tourism, Revamp legacy Application, CI/CD Project, Database Stability and Scalability Architecture, Production, SIT and Development
Database Architect/DBA in Cloud Project for Production PostgreSQL Active -Passive replication Implementations, Oracle RAC DB 4 node clusters resting on OCI bare metal-Exa-data Support and Maintenance, AWS Cloud Databases Administration Oracle OCI and AWS Cloud for Multitier Applications, High availability Configuration and Maintenance.
Environment: PostgreSQL 11/10, Oracle 12c, 11g RAC, CloudFront, S3, Amazon RDS, PgAdmin4, Pgpool, pgbench, pgAnalyze, zabbix, Docker, SQL Server 2016 and 2017, MongoDB 4/3, RMAN, Datapump, OCI Cloud, AWS, 13c OEM, AWR, OCI & AWS(Hybrid), VMwareServer, Exadata-x8-Half-Rack, EC2, ELB, S3, Red hat Linux, ADDM, ASH, STA, SPM, EBS, AMI and python

Production support of Diverse databases like PostgreSQL, Oracle 12c Database Up gradation, SQL Server 2017 Installed for Finance application, Implemented Nine Nodes High Availability MongoDB Cluster, Database Optimization, DR Drill Execution, cloud database migration in Hybrid cloud environment. Design documentation, KT to vendor DBA’s for system Activities, Delivered Hadoop Cluster POC for joint venture.
 Fine Tuned SQL Query as per business logic and the requirements a
 PostgreSQL DR replication and monitoring, managed index and schema and recovered databases
 Wrote shell script for postgreSQL, mongodb and oracle databases and automated batch jobs
 Created shard database based on the requirements and Reported DB performance to the DEV team periodically
 Recommended Indexing strategies, designed MongoDB databases for data
 Supported development team for database creation on AWS RDS, EC2 instances in Linux Cent OS 7.x
 Installed, configured, Cloudera Hadoop cluster for POC
 Oracle Database Migration from on-premises to AWS Cloud projects for multi-zone cloud
 Documented database architecture, vacuum cleaned
 Wrote batch script for Microsoft SQL server database backups

in Volvo Group Project for Production, Standard and Basic Type Database Projects for Automobile, Cargo and Transport Live Application, Problem ticket coordination, Databases Maintenance, Support, Patching, Monitoring and System Built

Environment: PostgreSQL 10.x/9.x, PgAdmin, pgbench, pganalyze, zabbix, Oracle 12c R1, 11g R1, 10g, Oracle Data guard, Solaris, AIX, Redhat

Key Accomplishment: Recovered Production database, Fixed key problem in the Critical Database and condensed Incident counts.
•Designed PostgreSQL, Oracle, MongoDB Databases for different region for Volvo customer.
•Participated in planning and implementation of database backup, recovery and security procedures
•Applied Oracle PSU Patch and Troubleshooted the application and databases
•Planned and Managed 15TB Size Databases and Monitored by using OEM Cloud control
•Managed Data in MongoDB Capped Collections Expired data from TTL , Designed Architecture of table, schemas, database as per the Application requirement
•Exported and Imported of Data to and From MongoDB, Configured MongoDB on run time,
•Managed Capacity for databases and handled Log rotation( mangos, mongod, config), Disk usage
•Involved on Oracle database Server Performance tuning and Recommendations
•Optimized Database, Index and Created Databases Linux 6.x, 7.x, and AIX Operating Systems

Oracle DBA) in implementation of ITDR solution project for Shukran loyalty program Project (Landmark, DXB) and Air Asia Projects DB Optimization, Planning, Setup, Implementation on Pre -Prod and Database SQL Query Optimization, Code movement from Dev to Prod Instances, Database Performance and Index optimizations, Database hosted in Exadata Support, and Capacity planning and maintenance .

in DBA Maxis Telecommunication Project (client: IBM) ., M.Y., Which is the only integrated communications service provider and Maxis provide a variety of communication products, applications and value added services for consumers, large enterprises and small & medium business owners. The extensive reach and range of their network, products and services create a differentiated customer experience for both consumers and business.

Environnent : Oracle 11gR1/10g/9i, Oracle 10g RAC, Linux, Solaris, HP-UX, Maximo
Key Accomplishments: Database Auditing, Hardening, Application Performance issue improvement, Reduced the database critical events, Incidents tickets, Maintained 800+ Databases with size of 15TB < 20 DBA’s, Recovered database, Installed, Configured Oracle Clusterware and 10g R2 Oracle Real Application Database Cluster resting on Linux OS.
•Database auditing, Database hardening, Alert Log check and Coordinated Business user for performance issues. Enabled Audit trail features and SQL trace for specific application users.
•Configured, Managed RMAN Backups, Table space, users, roles and privileges and Defined backup policy
•Database, Schema and table refresh and Tables re-organization and Involved in Checking DB Health, Database Hardening, Monitored 800+ Databases with size of 15TB < 20 DBA’s. Installed, Configured Oracle 10g RAC Database, Monitored RAC 10g & ASM

C1000 IT Schuitema supermarket Retail project in Neither land, in this module; we had done End to end application misgration, deployment, customized test application by using AIA, BPEL tools. Migrated test application to production applications.

Environnent : Oracle SQL Developer, IBM Rational Clear Quest, Citrix, Subversion
Key Accomplishments: Migrated Application Development into Production environment, Managed AIA, BPEL(SOA) Suite Components which helped core team to deliver code into Production environment in time.
•Deployed, Configured, FTP, Locus, JMS, DB Adapters, AIA, BPEL components in Build Severs, moved codes to UAT
•Deployed Oracle Forms, Prod*C code in User Acceptance Test(UAT) and System Integration Testing(SIT) Servers
•Deployed SQL code, PL-SQL Query, Function, Trigger and Stored Procedure scripts in Test Environments for Development and ensured programming scripts are updated in subversion.