JENCY JAIN
Chennai
Summary
Accomplished Oracle DBA with 9+ years of experience, currently leading database operations and cloud migrations at Radial Omnichannel Technologies. Proficient in AWS database services, Oracle to PostgreSQL migration, and performance tuning. Strong expertise in Oracle 11g/12c/19c, AWS, RMAN, Data Guard, and RAC. Adept at modernizing legacy systems and ensuring high availability and scalability in hybrid and cloud-native environments.
Overview
11
11
years of professional experience
1
1
Certification
Work History
DBA – Lead Analyst
Radial Omnichannel Technologies India Pvt. Ltd.
01.2020 - Current
- Leading the migration of Oracle databases to PostgreSQL on AWS to reduce licensing costs and modernize infrastructure.
- Utilized AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) for heterogeneous database migrations.
- Designed and implemented highly available RDS instances with automated backups, failover, and monitoring using CloudWatch.
- Performed data extraction, transformation, and loading using Ora2Pg, achieving schema and data compatibility for PostgreSQL.
- Automated backup and snapshot strategies using AWS Backup and Lambda scripting.
- Ensured database security through IAM roles, encryption at rest/in-transit, and VPC peering.
- Provided 24/7 support for AWS-hosted environments and hybrid setups, with proactive tuning and incident management.
- Administered Microsoft SQL Server 2017 instances, including installation, configuration, and patch management.
- Configured and managed log shipping and database mirroring to ensure high availability and disaster recovery.
- Conducted regular system health checks, index optimization, and query performance tuning using SQL Profiler and Execution Plans.
Oracle/DB2 DBA – Technical Lead
Cognizant Technology Solutions
01.2015 - 01.2020
- Led Oracle RAC/ASM configurations and upgrades from 11gR2 to 12c in on-premise enterprise environments.
- Implemented and managed Oracle Data Guard for disaster recovery and high availability.
- Tuned database performance using AWR, ADDM, and SQL profiling techniques.
- Handled Oracle Streams-based replication and production-to-non-prod refreshes.
- Administered DB2 environments on Z/OS, including stored procedures and partition management.
- Collaborated with Oracle Support for critical bug resolution and security patching.
Education
B.Tech - Aerospace Engineering
Karunya Institute of Technology
01.2015
Skills
- Oracle 11g/12c/19c
- Microsoft Sql Sever 2008/2017
- Db2
- Mongo DB
- Mysql
- Sybase
- AWS
- Postgres
Certification
- AWS Certified Solutions Architect – Associate (Pursuing)
- AWS Technical Essentials Day- Completed 2023
- Master of cloud Computing- Fita Academy
Timeline
DBA – Lead Analyst
Radial Omnichannel Technologies India Pvt. Ltd.
01.2020 - Current
Oracle/DB2 DBA – Technical Lead
Cognizant Technology Solutions
01.2015 - 01.2020
B.Tech - Aerospace Engineering
Karunya Institute of Technology
Similar Profiles
SNEHAL BHAGATSNEHAL BHAGAT
Vice President of Human Resources at MAX Protection Services Pvt LtdVice President of Human Resources at MAX Protection Services Pvt Ltd
SANGEETHA GSANGEETHA G
Software Analyst at Radial Omnichannel TechnologiesSoftware Analyst at Radial Omnichannel Technologies
SHEIK AFFRINSHEIK AFFRIN
Quality Analyst at Radial Omnichannel Technologies, Empowering Bpost GroupQuality Analyst at Radial Omnichannel Technologies, Empowering Bpost Group
Srinithi MSrinithi M
Process Associate at HanDigital Pvt LtdProcess Associate at HanDigital Pvt Ltd
Sri Ranjith SSri Ranjith S
Splst, Development at Standard Chartered BankSplst, Development at Standard Chartered Bank