Senior Cyber Security Admin - EY Ernst & Young - Kochin, Kerala, India
(2025-01)
Software Engineer | Oracle DBA - LUXOFT TECHNOLOGY - Bangalore, India
(2023-01 - 2024-12)
System Engineer | Oracle DBA - TATA CONSULTANCY SERVICES - Kochin, Kerala, India
(2022-01 - 2023-12)
Senior System Engineer | Oracle DBA - COGNIZANT TECHNOLOGY SOLUTIONS - Bangalore, India
(2019-01 - 2022-12)
- Proactively monitoring the database & assisted in troubleshooting and resolving 200+ weekly database related tickets, achieving a 100% satisfaction rate.
- Managed database storage objects, including tablespaces and datafiles, while monitoring database usage and growth trends. Ensured optimal storage management by adding, resizing, and reorganizing data files/tablespaces as required.
- Configured and monitored archiving processes, ensuring proper storage utilization and smooth database recoverability.
- Created and configured new databases using DBCA and manual scripts, including initialization parameter setup, storage structure design, tablespace creation, and character set configuration.
- Created and configured database links to enable seamless cross-database communication and data sharing.
- Executed DDL and DML scripts based on project and business requirements for schema creation, modification, and data management.
- Performed post-activity database health checks to validate system performance, availability, and integrity.
- Created and managed database user accounts, assigning roles and privileges as per security and business requirements.
- Performed logical backups Data Pump of tables, schemas, and databases for disaster recovery and migration purposes.
- Planned and scheduled hot and cold backups to ensure database recoverability and business continuity.
- Worked closely with the Linux administrators to ensure smooth execution of database operational tasks, including startup, shutdown, and agent decommissioning.
- Worked on capacity planning for tablespace usage trend reports monthly remediate accordingly to reduce utilization alerts.
- Performed regular patching of Oracle databases (11g, 12c, 19c) to ensure security, stability, and compliance, including Data Guard environments.
- Upgraded DEV and QA databases from 11g → 12c and 12c → 19c on Linux platforms, ensuring minimal downtime and successful migration.
- Performed switchover operations during planned maintenance activities. On a quarterly basis, perform DR drill activity to test application functionality and worked on disaster recovery by converting physical standby to snapshot standby.
- Configured Transparent Data Encryption (TDE) across multiple databases by creating keystore wallets, setting encryption passwords, and enabling auto-login configuration.
- Migrated local TDE keys to Fortanix HSM on both on-premises RAC and OCI databases, ensuring secure key management and integration with enterprise security frameworks.
- Monitoring log shipping and standby databases for sync with primary & taking necessary action to make the databases in sync with primary.
- Generate AWR reports to know the database's performance and identify any bottlenecks, locking sessions and long running sessions.
- Performed decommissioning of schemas and databases as per client requirements, ensuring proper data archival and compliance with policies.
- Experienced in Oracle Cloud Infrastructure (OCI), including provisioning databases across multiple database homes.
- Problem solver with a passion for technology; skilled in grasping the big picture and applying appropriate & practical technologies that meet business needs while minimizing risks.
- Provided knowledge training to new joiners in queue management and database management basics.
