Sr. Consultant – Oracle Database Administrator - Aarav Global Products and Services Pvt. Ltd.
(2024-02)
Worked on the Mercury FX banking project supporting Oracle databases for international banking and foreign exchange operations. Handled database administration, backup and recovery, monitoring, patching, and performance support for production and non-production environments.
- Creates and maintains all databases required for development usage.
- Installs new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
- Implements and enforces security for all Oracle Databases.
- Excellent knowledge of Oracle backup and recovery scenarios.
- Creates new database users as required and provides technical support to application development teams.
- Performs both Oracle and operating system performance monitoring and the necessary adjustments.
- Works as part of a team and provides 7x24 support when required.
- Creates instances and databases with appropriate initialization parameters and database structures (data files, table spaces, etc.).
- Reviews and monitors system and instance resources to ensure continuous database operations (storage, memory, CPU, network usage, I/O contention).
- Applies Oracle database patches, creates database users, monitors, tunes, troubleshoots, and handles backup and recoveries.
- Cloned/Refreshed Oracle Databases and Oracle Applications; implements Hot, Cold and Logical backup plans.
- Responsible for setting and managing user accounts, granting required privileges to users.
- Optimizes queries and performs application tuning using TRACE FILE, TKPROF, EXPLAIN PLAN.
- Installed and Implemented Backup & Recovery procedures.
- Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning; provided 24x7 support for all production and development databases.
- RAC installation, troubleshooting and patching using Auto option; adding and deleting nodes for existing cluster.
- Implemented and managed real-time data replication using Oracle GoldenGate across heterogeneous environments (Oracle to Oracle / Oracle to non-Oracle).
- Installed, configured, and upgraded GoldenGate components including Extract, Pump, and Replicat processes.
- Performed initial data load and synchronization using GoldenGate utilities (GGSCI, Data Pump, etc.).
- Troubleshot replication issues such as lag, data inconsistency, and abends, ensuring minimal downtime.
- Configured bidirectional replication and conflict detection/resolution mechanisms.
- Supported zero-downtime database migrations and upgrades leveraging GoldenGate replication.
- Maintained GoldenGate security, including credential store and encryption configurations.
- Collaborated with application teams to ensure data integrity and consistency across systems.
- Implemented and managed Transparent Data Encryption (TDE) to secure sensitive data at rest, including tablespace and column-level encryption.
- Configured Oracle Wallet/Keystore for encryption key management and ensured compliance with security policies.
- Designed and deployed Data Redaction policies to mask sensitive data in real-time for non-privileged users.
- Conducted security audits and ensured database compliance with industry standards and internal governance.
- Managed user roles, privileges, and implemented fine-grained access control.
- Performed SQL query tuning using execution plans, indexes, and optimizer hints to improve performance.
- Analyzed and resolved performance bottlenecks using AWR, ASH, and ADDM reports.
- Optimized database performance by tuning SGA, PGA, and memory parameters.
- Implemented indexing strategies and partitioning to improve query efficiency.
- Monitored database performance and proactively resolved issues to ensure high availability.
Oracle Database Administrator - Mphasis Ltd.
(2020-02 - 2024-02)
Supporting enterprise-scale Oracle databases for global logistics operations and health insurance information management. Provided comprehensive database administration for multiple projects.
- Creates and maintains all databases required for development usage.
- Installs new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
- Implements and enforces security for all Oracle Databases.
- Creates new database users as required and provides technical support to application development teams.
- Performs both Oracle and operating system performance monitoring and necessary adjustments.
- Creates instances and databases with appropriate initialization parameters and database structures.
- Reviews and monitors system and instance resources to ensure continuous database operations.
- Applies Oracle database patches, creates database users, monitors, tunes, troubleshoots, and handles backup and recoveries.
- Cloned/Refreshed Oracle Databases and Oracle Applications; implements Hot, Cold and Logical backup plans.
- Optimizes queries and performs application tuning using TRACE FILE, TKPROF, EXPLAIN PLAN.
- Installed and Implemented Backup & Recovery procedures.
- Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning; provided 24x7 support for all production and development databases.
- Installation and configuration of Oracle 12c and 19c databases.
- Resolved issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX On-Call alerts.
- Database backup & recovery; coordinated with developers and users for database maintenance, security, backup & recovery.
- Creation of users and granting them privileges and roles; Export and Import Data as per user request.
- Implemented Oracle database backup & recovery solutions using RMAN.
- Extensive uses of Oracle Data Pump Exports/Imports utility for moving data among the servers.
- Applied CPU patches; provided 24x7 Production database and applications support with weekend on-call.
- Implemented and managed Transparent Data Encryption (TDE) to secure sensitive data at rest, including tablespace and column-level encryption.
- Configured Oracle Wallet/Keystore for encryption key management and ensured compliance with security policies.
- Designed and deployed Data Redaction policies to mask sensitive data in real-time for non-privileged users.
- Conducted security audits and ensured database compliance with industry standards and internal governance.
- Managed user roles, privileges, and implemented fine-grained access control.
- Performed SQL query tuning using execution plans, indexes, and optimizer hints to improve performance.
- Analyzed and resolved performance bottlenecks using AWR, ASH, and ADDM reports.
- Optimized database performance by tuning SGA, PGA, and memory parameters.
- Implemented indexing strategies and partitioning to improve query efficiency.
- Monitored database performance and proactively resolved issues to ensure high availability.
- Written scripts for automation of backups and cloning; monitoring all databases using 19C OEM.
- Schema refresh activities, DR switchover activities, troubleshooting developer TNS issues.
- Checking Listener connectivity issues, RMAN backup pieces in tape, logical backups using Data Pump utility.
- Analyzing the database and collecting updated statistics; RMAN block level recovery.
- Using Explain Plan to check query performance; checking DR sync reports daily.
- Working on ORA-01555 errors; checking Temp tablespace usage; cloning the database using RMAN.
