About Me
I am a core Oracle DBA with a good experience on other RDBMS like postgreSQL and mySQL. Overall i have around 9 years of experience.
... Show MoreSkills
Database
Operating System
Others
Networking & Security
Development Tools
Software Engineering
Web Development
Positions
Portfolio Projects
Company
DBS Bank Exadata Support
Description
- Performing Image upgrade of the Exadata Machines.
- Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
- Migrated Databases from X3 to X7 machines.
- Upgraded Databases from 12c to 19c.
- Applying interim patches to Oracle Home.
- Upgrading OEM 13.2 to 13.3 and deploying plugins.
- Implementing ISCD on O.S as well as Databases as per the bank’s policies.
- Troubleshooting Network issues in the X7 Machine at the Data-Centres.
- Exadata machines maintenance and management experience.
- Configuring Backup I.P, NTP servers in the Exadata boxes.
- Solid skills to configure Exadata to meet company internal security requirement.
- Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
Tools
SQL DeveloperCompany
Voya Financials Inc
Description
- Monitoring Exadata Db-Servers and Cell-Servers, InfiniBand and Admin Switches using OEM, CellCLI and DCLI.
- Running Health check, ExaChk and SunDIAG Reports.
- Checking out the effectiveness of Flash Cache.
- Applying Bundle Patches, One-Off Patches.
- Performing Image upgrade of the Exadata Machines.
- Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
- Participated in half-yearly Emergency Preventive Maintenance activity.
- Checking out for the queries whether it is using Smart Scan or not.
Skills
Oracle ExadataTools
ToadCompany
Incomm Holdings Inc.
Description
- Performing Load testing for SQL Queries and tuning the Queries when required.
- Deploying SQL Queries called as ‘Rule Query’ in the Production UI.
- Scheduling and Maintaining jobs using PL\SQL blocks.
- Tuning Queries, SQL, PL\SQL.
- Implemented TDE in Oracle 11gR2.
- Implemented Data Redaction in Oracle 12c.
- Upgrading databases from 11.2.0.4 to 12.1.0.2.
Tools
SQL DeveloperCompany
SANOFI AVENTIS
Description
- Analysis of the specifications provided by the clients
- Administrating Exadata Servers
- Handling Incident tickets to ensure 24x7 database availability
- Implementing change requests in plan time.
- Coordinating with clients & other team to fulfill their requirements.
- Identifying blocking users in application transaction
- Creating Users with quota Management and assigning the relevant profiles
- Granting specific privileges and roles to the users
- Implemented invalid login attempts auditing
- Re-organization of tables and logical structures to remove fragmentation
- Resolved oracle performance issues involving disk I/O, CPU Usage, Query tuning.
- Performed capacity planning in order to be ready for space requirements
- Trouble shooting databases issues to be in-line with SLA.