PROFESSIONAL SUMMARY:

• Over 14 years of IT experience with Database Administration/Application Support, Oracle Developer, System Administration, Linux, Sun Solaris, AIX and Windows environment within several industries: Telecom, Finance, Manufacturing, Engineering, Oil and Gas and Safety Industry
• Gathering client’s application requirements, upgrading, patching and fixing bugs with a variety of databases such as Exadata 8i, 9i, 10g, 11g(could and non cloud) and 12c.
• Worked as Technology Architect for various Golden Gate Projects for replication, Consiliation to Dataware house
• Proficient knowledge and execution in Oracle Golden Gate, REAL APPLICATION CLUSTER (Solaris/Linux) on Oracle 10g and 11gr2, SDLC (PRODUCTION, USER ACCEPTANCE TEST, DEVELOPMENT), Performance Tuning, backup and recovery through Datapump/RMAN, Cloning Database, Loading Data, Creating database objects, Fusion middleware(Weblogic, RCU, Form & Report, OSSO, OID)
• Proficiency in creating and managing user, roles, privileges, profile, schemas
• Manage day - to-day database administration tasks like Database creation, User creation, Performance tuning, Tablespace usage, Monitoring alert log, trace file, monitoring disk usage, database backup logs etc.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 10 SPRAC, Red Hat Linux, HP-UX, AIX, Windows NT/2000/2003/2005 Server, Windows 7/Vista/XP/2000/98

RDBMS: Exadata, Cloud base Oracle databases 12c, 11gr2, 11gr1&2/10gr2/ 9i/8i, OEM 12c SQL Server 2008, MySQL 4.1, Cassandra

Programming Language: SQL, PL/SQL, C, Java

Scripting Languages: Linux/Solaris/AIX Bash Shell Scripting, HTML, CSS, JavaScript, VBscript, Java, C, C++

Tools: AWS, Devops, Actifio, Oracle Golden Gate, Jenkins, Fusion middleware(Weblogic, RCU, Form & Report, OSSO, OID), Oracle SQL Developer, OBIEE, Oracle Streams, Data modeling using Erwin or SQL developer, Toad, Informatica (ETL), Blade Logic, Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: OLTP, OLAP, SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import, Statspack, AWR, SQL tuning, TKPROF extensively, Oracle Golden Gate

PROFESSIONAL EXPERIENCES

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Gather client requirements.
• Actifio installation and configuration
• Deploy scripts using Jenkins
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Oracle OEM 12c/ OEM 13c server and client
• Involved in installation and configuration of Oracle 11gr2/12c database on Prod and non-prod
• Involved in resolving high CPU% utilization issue
• Database patching
• Configure Oracle ASM
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Installation, configuration of Golden Gate.
• Plan database scalability as per growth on all database environments.
• Deploying scripts using Jenkins/Gits.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c/13c Agent into prod and non-prod server.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Software:Oracle 11gr2/12gr2, Golden Gate, VNC Viewer, Linux, Putty, Cisco VPN client, WinScp, Windows 2010, MS Office, MicorsoftLync Messenger.

Hardware: Linux, HP, Dell, Laptop, firewall, Cisco Routers, Dell/Cisco switches, HP printers, VOIP Phones etc.

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Gather client requirements.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Oracle OEM 12c/ OEM 13c server and client
• Involved in installation and configuration of Oracle 11gr2 database on Prod and non-prod and in Cloud environment.
• Involved in high CPU% utilization issue
• Database patching
• Configure Oracle ASM
• Upgrade 11g to 12c OEM.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Upgrade 11gr2 database to 12c in Dev environment.
• Plan database scalability as per growth on all database environments.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Software:Cloud computing, Oracle 10gr2/11gr2, Golden Gate, VNC Viewer, Linux, Putty, Blade Logic, Cisco VPN client, WinScp, Windows 2010, MS Office, MicorsoftLync Messenger.

Hardware: Linux, HP, Dell, Laptop, firewall, Cisco Routers, Dell/Cisco switches, HP printers, VOIP Phones etc.

Senior Database DBA

Confidential, Alpharetta, GA

Responsibilities:

• Gather client requirements.
• Develop Database object like Procedure, function, Packages etc.
• Support Indigo, EBDR, EProgesa database OLTP applications.
• Provide Golden Gate support to replicate data from Oracle to MS SQL server
• Install Oracle database in SAN/NAS
• Database performance
• Database patching
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Analyze Data
• Prepare Business report as per client need
• Data modeling using Toad/SQL Developer
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Prepare engineering documents

Software: Cloud computing, Oracle 10gr2/11gr2/12c, Golden Gate, VNC Viewer, AIX, Putty, Cisco VPN client, WinScp, Windows 2008, MS Office, Skype for Business.

Hardware: AIX, Dell, Laptop, firewall, Cisco Routers, Dell/Cisco switches, Konika Printer, VOIP Phones etc.

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Gather client requirements.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Resolve day today Golden gate issue
• Involved in Migration from Solaris to Linux database in 12c cloud environment on Prod and non-prod.
• Oracle OEM 12c server and client
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Involved in installation and configuration of Oracle 11gr2 database on Prod and non-prod and in Cloud environment.
• Involved in high CPU% utilization issue
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Upgrade 11gr2 database to 12c in Dev environment.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all databases.
• Handle user management and storage management.
• Database performance and tuning
• SQL query optimization
• Upgrade databases from 10g to 11g
• Manage RAC using Oracle Cluster ware, Grid Control
• Trouble shoot high CPU utilization
• Trouble shoot Active Data Guard issue
• Trouble shoot Golden Gate issues
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Install and setup Oracle Enterprise Manager 12c Agent into prod and non-prod server.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to performance tuning
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Manage MySql database backups.
• Involved in setting up and maintain Dataguard oracle 10g and 11g.
• Addressed any issues raised in Alert logs and trace files.
• Able to work on ITIL Framework
• Prepare engineering documents

Software:Cloud computing, Oracle 10gr2/11gr2, Golden Gate, VNC Viewer, Linux, Putty, Blade Logic, Cisco VPN client, WinScp, Windows 2010, MS Office, MicorsoftLync Messenger.

Hardware: Linux, HP, Dell, Laptop, firewall, Cisco Routers, Dell/Cisco switches, HP printers, VOIP Phones etc.

Senior Oracle DBA

Confidential, Buffalo, NY

Responsibilities:

• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Involved in Migration from DB2 on Mainframe Database object into Oracle on Linux Database Objects.
• Involved in RE-Data Modeling of Database Objects.
• Educate and guide DB2 developers to develop programs in Oracle environment.
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Install and Configured Oracle 11gr2 database on Physical and Virtual servers.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all database environments.
• Handle user management and storage management.
• Manage RAC using Oracle Cluster ware, Grid Control
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit with Oracle 11gr2 Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11gr2 and ASM
• Install and setup Oracle Enterprise Manager 12c on Linux environment.
• Account holder of all Database servers as environment.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to database performance
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Scheduling jobs using Crontab.
• Involved in database replication using Golden Gate
• Develop, edit, test of Shell scripts
• Involved in setting up and maintain Dataguard.
• Addressed any issues raised in Alert logs and trace files.
• Document all installation and configuration steps

Software:Oracle 10gr2/11gr2, Golden Gate, VNC Viewer, Linux, Putty, Blade Logic, Cisco VPN client, WinScp, Windows 2010, MS Office, MicorsoftLync Messenger.

Hardware: Linux, Dell Laptop, Firewall, Cisco Routers, Dell/Cisco switches, HP printers, VOIP Phones etc.

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Gather client requirement to provide database for Qfund application.
• Involved in Configuration of 4 nodes RAC on Red Hat Enterprise Linux Server release 5.8 with Oracle 11gr2 on ASM LUN on EMC Power Path/Multipath/DMV.
• Exadata interaction
• Provide support to Data Center as when needed
• Involved in installation and configuration of Oracle Golden Gate on prod and non-prod.
• Installing and configure Informatica and perform Data extraction, Transformation and Loading into Target side
• Focal point for creating and managing databases 11g for all new projects in Validation environment (Linux, Windows, Exsi VMware) where application is based on J2EE.
• Manage OLAP and OLTP applications
• Install Oracle database in SAN/NAS
• Install and configure MySql server.
• Install and Configured Oracle 11gr2 database on Physical and Virtual servers.
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Plan database scalability as per growth on all database environments.
• Standardization of Database environment in all database environments.
• Handle user management and storage management.
• Manage RAC using Oracle Cluster ware, Grid Control
• Automation database activities using Shell script and crontab
• Configure and schedule RMAN Backups
• Data refresh using traditional export/import and datapump.
• Perform capacity planning required to create and maintain the databases
• Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit with Oracle 11gr2 Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11gr2 and ASM
• Install and setup Oracle Enterprise Manager 12c on Linux environment.
• Account holder of all Database servers as environment.
• Migrate Sql server data to Oracle database using T-SQL and PL/SQL.
• Maintain Small/Medium/Large oracle Databases used in different projects.
• Help developers to write best SQL and PL/SQL queries in regards to database performance
• Focal point for creating and managing databases for all environments as Development/training/UAT/Prod environment.
• Develop, test and run Shell scripting for automation database activities.
• Scheduling jobs using Crontab.
• Involved in database replication using Golden Gate
• Develop, edit, test of Shell scripts
• Involved in setting up and maintain Dataguard.
• Addressed any issues raised in Alert logs and trace files.
• Document all installation and configuration steps

Software:Oracle 10gr2/11gr2, Golden Gate, VNC Viewer, Linux, Putty, Blade Logic, Cisco VPN client, WinScp, Windows 2010, MS Office, MicorsoftLync Messenger.

Hardware: Linux, HP, Dell/HP Laptop, Firewall, Cisco Routers, Dell/Cisco switches, HP printers, VOIP Phones etc.

Confidential

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Oracle Golden Gate Team Lead for Balance Manager and Mediation
• Manage OLAP and OLTP applications
• Reviewing Database failover settings of RAC databases.
• Design and develop Oracle Golden Gate for Balance Manager Mediation
• Create and maintain Data Dictionary of specific Balance Manager and Mediation Databases.
• Involved in configuring Oracle Golden Gate on Solaris and Linux
• Involved in Data Domaining project
• Install Oracle database in SAN/NAS
• Using Informatica ETL
• Data Modeling
• Create Database Dictionary
• Create engineering documentation for Oracle Golden Gate
• Monitoring RAC environments
• Involved in designing Oracle RAC 11gr2 for ATT applications on Solaris and Linux
• Involved in installing Oracle 11gr2 RAC Solaris and Linux
• Create engineering documentation for Oracle RAC 11gr2
• Involved in configuring Oracle 11gr2 RAC Solaris and Linux
• Design, develop and test Failover of databases
• Capacity planning
• Resolving daily Database issues
• Provide database solutions to ATT’s ADBA and PDBA groups.

Software:Oracle 10gr2/11gr2, Golden Gate, VNC Viewer, Linux, Putty, Blade Logic, Cisco VPN client, WinScp, Windows 2010, MS Office, Q Messenger.

Hardware: Sun Solaris, Linux, HP, AIX, Laptop, CyberRoam firewall, Cisco Routers, Cisco switches, HP printers, VOIP Phones, etc.

Confidential

Senior Oracle DBA

Confidential, Alpharetta, GA

Responsibilities:

• Get client requirement to provide database for Qfund application.
• Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.8 with Oracle 11gr2 on ASM
• Focal point for creating and managing databases (9i, 10g, 11g) for all new projects in Validation environment (Linux, Windows, Exsi VMware) where application is based on J2EE.
• As Team of Database Administrator me am responsible to insure dat proper documentation for all projects steps are documented and submitted, so dat IT professional working POC/Dev/Stg/Prd environment follows the clear instruction from ETS document
• Data transformation using Informatica
• Manage OLAP and OLTP applications
• Replication database using Golden Gate
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Help developers on sql/plsql performance and tuning.
• Database Management using Oracle OEM 12c.
• Account holder of all Database server which are in Linux environment.
• Create and edit shell script on database servers.
• Install and configure application with Jboss.

Software:VMware Esxi, Oracle 10gr2/11gr2, VNC Viewer, Linux, Putty, Cisco VPN client, Team viewer, WinScp, Windows 2007, Weblogic, Form & Report, OEM Grid Control.

Hardware: Linux, Windows, Dell Desktop and Laptop, CyberRoam firewall, Cisco Routers, Cisco switches, HP printers, VOIP Phones, etc.

Senior Oracle DBA

Confidential, Nashville, TN

Responsibilities included:

• Involved in 1st phase production implementation.
• Involved in testing Oracle Golden Gate in staging environment.
• Involved in testing Oracle Golden Gate in Test environment.
• Define and Document Golden Gate Architecture and procedures for Cummins.Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit with Oracle 11gr2 on ASM and Develop, edit, test of shell scripts.
• Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11gr2 on ASM
• Focal point for creating and managing databases (9i, 10g, 11g) for all new projects in Validation environment (Solaris, Linux, AIX, Window) where application can be based on J2EE or non J2EE based.
• As Team of Database Administrator me am responsible to insure dat proper documentation for all projects steps are documented and submitted, so dat IT professional working Dev/Stg/Prd environment follows the clear instruction from ETS document.
• Account holder of all Database server which are in Solaris/Linux/AIX/Windows in our environment.
• Maintain 120 OLTP databases Small/Medium/Large oracle Databases used in different projects/applications using export/import, RMAN, cloning database, performance tuning, upgrade, patching database and resolve daily issues.
• Assist developer to tune SQL and PL/SQL tuning.
• Create and edit shell script on database servers.
• Data Modeling
• Install and configure Fusion Middleware (Weblogic, RCU, Forms & Reports, OSSO, OID).
• Using Microsoft SharePoint for project tasks

Software:Oracle 10gr2/11gr2, VNC Viewer, Linux, IBM Lotus Notes, Putty, Blade Logic, Cisco VPN client, Team viewer, WinScp, Windows 2007, IBM Lotus Notes 8.5, Weblogic, Form & Report, Seibel, Oracle 11i, IBM SterlingOracle Golden Gate Monitor, Oracle Golden Gate Director, OEM Grid Control.

Senior Database Administrator of Datacenter

Confidential, Matawan, NJ

Responsibilities included:

• Handle user management and storage management.
• Migrate Oracle 9i to 10g or 11gr2, applying security/CPU patches
• Configure and schedule RMAN Backups
• Data refresh using export/import, datapump
• Perform capacity planning required to create and maintain the databases
• Involved in Configuration of 2 nodes RAC on Sun Solaris 10 SPARC 64 bit with Oracle 11gr2 Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11gr2 and ASM
• Install and setup Oracle Enterprise Manager Grid Control on Solaris/Linux environment.
• Account holder of all Database server which are in Solaris/Linux/Windows in our environment.
• Maintain 32 DB Small/Medium/Large oracle Databases used in different projects.
• Data Modeling using Sql Developer/Erwin
• Install, configure and manage Sybase database for internal inventor system.
• Help developers to write best SQL and PL/SQL queries in regards to database performance
• Focal point for creating and managing databases (9i, 10g, 11g) for all new projects in Dev/Stg/Prod environment.
• Shell scripting for scheduling jobs etc.
• Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Migrated Oracle 10g on Solaris to Oracle 11gr2 on Linux
• Develop Test and run Shell script for database configuration
• Involved in database replication using Golden Gate
• Develop, edit, test of Shell scripts
• Involved in setting up Dataguard
• Addressed any issues raised in Alert logs and trace files.
• Collaborated in memory tuning and SQL tuning
• Manage SQL server 2005
• Document all installation and configuration steps
• Maintain Run Book of daily incident and solution provided
• Worked remotely from New Jersey office.

Software:Oracle 10g/11gr1/MySQL, Toad, SQL Developer, Linux, Putty, Cisco VPN client, Team viewer, Winscp, VMware, Windows 2007Vista/XP/2k

Hardware: HP/IBM server, IBM Lenovo Desktop and Laptop, CyberRoam firewall, Cisco Routers, Cisco switches, Dlink Wirless router, HP printers, VOIP Phones, etc.

Confidential

Senior Oracle DBA

Responsibilities

• Conducted needs assessment for new projects
• Installed, configured and maintain Linux RAC on 10gr2 using ASM.
• Handle user management and storage management.
• Migrate Oracle 9i to 10g to 11gr2, applying security/CPU patches
• Configure and schedule RMAN Backups
• Data refresh using export/import
• Involved in Configuration of 2 nodes RAC on Red Hat Enterprise Linux Server release 5.4 with Oracle 11gr2 and ASM
• Account holder of all Database server which are in Solaris/Linux/Windows in our environment.
• Maintain 32 DB Small/Medium/Large oracle Databases used in different projects.
• Perform capacity planning required to create and maintain the databases
• Tweaking Database performance using STATPACK, AWR, SQL TUNING, TKPROF.
• Help developers to write best SQL and PL/SQL queries
• Focal point for creating and managing databases (9i, 10g, 11g) for all new projects in Dev/Stg/Prod environment
• SQL and Database performance tuning
• Data Modelling using ERWIN
• Performed daily backup of MYSQL database
• Involved in database replication using Oracle Streams
• Develop Test and run Shell script for database configuration
• Involved in setting up Data Guard
• Addressed any issues raised in Alert logs and trace files.
• Collaborated in memory tuning and SQL tuning
• Document all installation and configuration steps
• Maintain Run Book of daily incident and solution provided
• Knowledge transition

Software:Oracle 10g, Toad, SQL Developer, Linux, Putty, Cisco VPN client, Team viewer, Winscp, VMware, Windows 2007Vista/XP/2k

Hardware: HP/IBM server, IBM Lenovo Desktop and Laptop, CyberRoam firewall, Cisco Routers, Cisco switches, Dlink Wirless router, HP printers, VOIP Phones, etc.

Confidential

IT /Database Administrator

Responsibilities included:

• Provide 24*7*365 database support
• Install Oracle Databases 8i/9i/10g
• Involved in developing In-house ERP solution on Oracle Developer 2000
• Database tuning SQL and memory tuning
• Developed fully Booking system application (which evolved getting requirement, data modeling, template design, database design, API design, Application testing, Commissioning application and support)
• Migrate Oracle 9i to 10g or 11gr2, applying security/CPU patches
• Managed Oracle ERP and Booking System database servers
• Perform capacity planning required to create and maintain the databases
• Resolve day today database and application issues
• Creating SQL/PLSQL, Procedures, Stored Procedures
• Configure Oracle Standby servers for all Production databases.
• Implement and enforce security for all Oracle databases
• Schedule backup using RMAN and restore if needed
• Write and edit Shell scripts
• User creation and space management
• Resolve database performance issue using Statpack/AWR etc.
• Performed database and backup and restored when needed
• Maintain Daily Run Book
• Document installation, configuration, issue faced and their solution.
• Developed applications using Oracle Forms & Oracle Reports
• Support In-house Oracle ERP/Booking System
• Monitor Database and File server backup done without any error
• Involve in setting and troubleshooting of Oracle Dataguard
• Maintained Active Directory and DNS
• Troubleshoot EPBAX System problems, Supervise Network cable laying and Server setup
• Procured Servers, Desktop Computers, Laptops, Switches, Routers and IT peripherals Managed Nortel and Cisco IP Phone systems
• Managed Pisys Simulator server and video server

Software:Oracle 8i/9i/10g databases, QISC ERP & Booking System application, Windows 2000/2003 Server & Professional, Pisys Offshore Oil Rig Simulator, Active Directory, MS Exchange 2000, ISA Server 2004, Norton Antivirus 9.1 Corporate Edition, TDSI Door Access system, Oracle 8i/9i, Developer 2000,Windows XP, Office XP, Office 2000, Project 2000, Outlook 2000, Photo Shop6.0 and Corel Draw

Hardware: Dell Power Edge Series Servers, Dell Optiplex GX series of Desktop, Laptops(HP, Sony, Compaq), HP (Scanner, Printers), ADSL modem, Nashuatec(Printer, Scanner & Fax), Elco Touch Screen, Compaq and Epson Projector, Sony 10X digital Camera, Smartboards, Vivotek IP Cameras, Cisco Router, switches (Cisco, D-Link, 3 Com, Dell), LG DVD/CD writer, VGA Splitters, Fiber Optics cables, Logitech Wireless keyboard, mouse, Logitech web cam, LAN Tester, Pinnacle Fire wire, SP 35 Card printer, Pinnacle Fire wire, Sony Plasma TVs