Tamil Selvan Email & Phone Number

Chennai, Tn, In

Chennai, Tamil Nadu, India

Contributions: • Administering large Oracle, and PostgreSQL database’s ability to do performance tuning/index Maintenance experience of backing up and restoring Oracle, and PostgreSQL databases on a regular basis.• Installed, configured, and maintained Oracle and PostgreSQL Databases.• Working Closely and proactively with the development team to identify and implement Areas of Improvement and provide guidance on best practices and performance Enhancements, performance tuning, and troubleshooting of mission-critical databases with help of Oracle performance tuning tools like AWR, Addm, Ash, sqlt, Oradebug, Sql trace, Sql monitor, Oem and SQL plan management.• Usage of Partitions to improve query performance and manageability.• Performing daily Archive log file backup and checking Alert Log files.• Monitoring databases to optimize database performance and diagnose any issues.• Perform database cloning/exp/imp to set up identical databases in the production and development environments.• Skilled in performing Cloning/Refresh database with cold, hot, and RMAN procedure.• Performance tuning which includes creating indexes, analyzing tables and indexes, explain the plan.• Responsible for all backup, recovery, and upgrading of Oracle and PostgreSQL databases.

Chennai

• 24x7 Oracle Production Database Administration including Oracle 11g/12c RAC.• Installed, configured and maintained Oracle Databases.• Implemented cloud services IAAS, PAAS, and SaaS which include Openstack, Docker and Openshift in IBM Cloud.• Managed Docker orchestration and Docker containerization using Kubernetes.• Attended Advanced Python Training Program.• Managing, troubleshooting and resolving oracle database, RAC and applications issues.• Implementation of High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.• Maintained standby databases, in both local and remote locations, for fail-over purposes.• Monitored/managed 2 node RAC environments, and RMAN database backup and recovery.• Involved in Upgrade/Migration of the oracle databases from Oracle 11g to Oracle 12c and Sun Solaris to OEL (Oracle Enterprise Linux).• Worked on wallet and TDE (transparent data encryption) for encrypting the sensitive data, using column encryption and tablespace encryption.• Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder • Worked on migrating Oracle databases to AWS RDS using utility AWS Database Migration Service (DMS).• Worked on converting schema from one DB engine to AWS RDS using AWS Schema Conversion Tool (SCT).• Worked on AWS Oracle databases for App migration into private cloud.• Worked on AWS Database Migration Services for migrating data from Oracle to RDS.• Defining and Setting backup and recovery procedures.• Tuning the database using AWR,ASH,ADDM and statspack and custom scripts.• Usage of Partitions to improve the query performance and manageability.

Chennai, Tamil Nadu, India

• Working in 24x7 production environment and provided on-call and day-to-day support.• Manage and support the 100+ Oracle Database Servers.• Installation of Oracle 10g/11g in Linux, Aix, SunOS Platform.• Monitoring the growth of Database, Tablespace, and Disk level.• Day-to-day monitoring like availability of the system, listener, database, and trace file.• Implemented backup and recovery procedures of databases in Sun Solaris and Red Hat Linux environment.• Provided disaster recovery by configuring and maintaining a physical standby database using oracle Data Guard• Upgrading the 10g databases to 11g.• Export/Import of oracle databases.

Chennai, Tamil Nadu, India

• Collecting the IDD functional Requirements from various Mobile Service Providers.• Involved in Sensor interfacing Electronics Design using OrCAD Capture tool.• Coding the Application and Flashing the same into 8051 Microcontroller of IDD.• Installing the IDD unit at Cell Site and Real-time Testing.• Circuit Debugging the Faulty IDD units and Servicing.