- Operating Systems
- Linux Redhat 7, Windows server 2016, 2012.HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.3,
- RDBMS
- Oracle 10g, 11g, 12c and 18cPostgreSQL 9.x – 11.x
- Languages
- SQL, PL/SQL
- Tools
- TKPROF, STATSPACK, TOAD, SQL DEVELOPER, OEM 13c
- Database Utilities
- SQL
- Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
- Loader, RMAN, DataPump, Export, Import
- Cloud Computing
- AWS and AZURE
- Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
- Provided 24X7 support for all the production and development databases.
- Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
- Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
- Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
- Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
- Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
- Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace file
| - AIX 5.3, Network attached storage, Scripts
- ASM, Enterprise, Sun Solaris 9
- C, Networks, Sun Solaris
- Capacity planning, Operating Systems, Microsoft SQL Server
- CPU, Operating system, SQL
- Client, Oracle 9, Switch
- Database Management, Oracle, Tables
- Database, DEVELOPER, TOAD
- Databases, Oracle Enterprise Manager, Troubleshoot
- DBMS, PL/SQL, Troubleshooting
- Disaster recovery, Peak, Unix
- HP-UX, Perl, Upgrade
- Linux, Processes, Upgrading
- Managing, RDBMS, Utilities
- Memory, Redhat, VM
- Windows, Redhat 7
- Migration, SAN
- NAS, Scheduling
- Implementing security measures
- Linux operating system
- Database development
- Relational Database Management
|