Samra C.h
Oracle Database Administrator
Hire this person
Send a job offer directly to this candidate
About
Information Technology professional with over 5 years of experience as Oracle Database Administrator and Cybersecurity Administrator, dedicated to driving organizational growth through database support. Proven ability to leverage technical skills and industry knowledge to enhance system performance and safeguard sensitive information. Committed to continuous personal and professional development, ensuring alignment with the latest technological advancements and best practices.
Experience
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.
Education
BSC - Computer Application - Sacred Heart College (2019-03)
High School - Computer Science - St Mary's Girls Higher Secondary School (2016-03)
