Technical Services Consultant
Information Turnkey Systems
Total years of experience :14 years, 8 Months
- Experience as On-Call 24x7 production DBA support.
- Extensive knowledge on database administration for Oracle 9i, 10g, 11g, 12c, 18c and 19c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
- Involved with installation and maintenance of Oracle RAC and standby database for High Availability and Disaster Recovery purpose.
- Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris and RHEL.
- Hands on experience in Oracle 10g/11g/12c/18c/19c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
- Good experience RAC Clusterware administration, Configuration and Patching.
- Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
- Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
- Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
- Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
- Good experience in writing/editing UNIX Shell Scripts.
- Expertise in upgrading Oracle Development and Production databases.
- Extensive knowledge and experience on managing very large Data Warehouse databases.
- Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
- Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD, ASMLIB and ASMFD
- Experience in Flash-Back Technology.
- Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
- Experience in Capacity Planning and Bench Marking.
- Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
- Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.
• Supports on Oracle Database and RAC Administration.
• Supports for Oracle hardware (Sparc, x86 and Database Appliances).
• Supports for HP Tandem Non-stop Systems Software and Hardware(S Series, NS Series) and NTI Products (DRNet, DRNet/MPS, DRNet/Open, and FileSync).
• Works on UINX Operating Systems (Solaris, LINUX, and AIX)
• Supports on SUN Cluster, VERITAS Cluster and VERITAS volume manager
• Support on Symantec NetBackup Administration on Windows and UNIX for backup and restore solutions.
• Supports for Hitachi Storages (VSP, USP_VM, and NSC55) and Storage & Network switches (Brocade and CISCO).
• Supports for Hitachi Universal Replication (HUR Async) and local replication (Shadow Image and Snapshot).
• Supports for EMC storage (VNX Clarion).
• Work experience on NUTANIX Enterprise Cloud computing systems.
• SAP Basis; troubleshooting the issue for Database, OS and Network.
• Supports for Host Security Module (HSM) in Banking Industries.
• Supports for Security and Monitoring Management Products (Comforte TOP and XYPRO)
• Supports for Backup Encryption (Secure Tape).
• Works with using Toad Application for Database tools, analysing the data and Managing Indexes.
• Able to Configuring RMAN and Data Guard for Oracle RAC and single database.
• Knowledge on HP NonStop NB Series Systems.
• Work Experience Maintaining Security Users adding and Deleting on Guardian Environment, OSS (Open System Services) and security tools Safeguard, Comforte Products (SSH, TOP Software and Secure Tape) and SNTP (Synchronization of Network Time Protocol).
• Work Experience NonStop Subsystem Facilities TACL, OSS, MACRO’s, FUP, DUP, FTP, SFTP, TMFCOM, Mediacom, Spoolers, and NSKCOM, Meascom, EMS, TSM and OSM tools.
• Creating and run macros on TACL and working knowledge with TAL.
• Experience on configure Data resources Network configuration (DRNet) and MPS (Multi Platform Support) to Replicate the Data NSK to Open platform.
• Knowledge in Base24 ATM switches application and architecture.
• Maintaining Tape Devices, SWAN’s, Spoolers and System Consoles.
• Managed LAN network lifecycles on a Windows platform, from software and hardware applications to equipment layout and technical support.
• In-depth knowledge of Maintenance and Troubleshooting, including Desktop support, Notebook, Configuration, and Workstation issues from initial problem analysis to final end resolution.
Master Science in Information Technology, Major: Computer software and Hardware
Post Graduate Diploma in Software Engineering