SUMMARY

• Oracle Certified Professional with over 10 years of IT experience as ORACLE Data Architect/DBA coupled with over 8 years of exposure in SQL Server/Sybase/MySql/Unix Administration.
• Seeking a challenging position as Senior Database Administrator/ Senior Oracle Apps DBA in IT.
• Expertise in Database infrastructure support, backup and recovery, monitoring and performance tuning, installation, upgrades, TAR support, database tuning, advanced SQL, Oracle patching, data integrity, UNIX scripting on Solaris, Linux, HP - UX and AIX Unix platforms and project management.
• Proficient in Oracle RAC, Enterprise Manager Grid Control, Data Guard, Replication, Relational Databases, Data Modeling and management of Schema objects.
• Possess hands on experience in installation, administration and configuration of Oracle Application 11i & R12 integration of Oracle ERP with Maximo and other legacy systems apart from maintenance of SQL/Server, MySQL and Sybase Databases.
• Skilled in Sun Solaris/HP-UX/Linux Administration and DataCenter operations
• Deft in analyzing organization requirements and accordingly suggesting business solutions, leveraging latest technologies, defining the IT vision and setting up the future roadmap.
• Effective analyst, problem solver and communicator able to forge solid relationships and build consensus across multiple organizational levels.
• Recognized for consistent achievements in cutting-edge information systems management, team management and cost-effective systems implementation, operations and its optimization.
• A personality with strong business acumen, excellent inter-personal relationship, possessing strong leadership and team building capabilities.
• Knowledge of international work cultures by virtue of overseas exposure in Dubai.

TECHNICAL SKILLS

Operating System: Sun Solaris 8,10 Windows 2000/NT 4.0, Windows (98,XP Pro, 2000 Pro), DOS, AIX, HP-UX 11.3, Red Hat Linux 9,Alpha Open VMS

Data Base: RDBMS Oracle 11g,10g,9i, 8i, 7.3, Microsoft SQL Server 7, 2003, 2005, Sybase 11.5, MySQL 5.6

Oracle Products: Oracle Forms 4.5/5.0,6i, Oracle Reports 2.5/3.0, 6, SQL / SQL*Plus, SQLJ and PL/SQL, SQL*Net/Net8, Oracle Enterprise Manager, Server Manager, Server Utilities (SQL*Loader, Export, Import), Oracle Discoverer 9i,10g

Applications: Oracle Applications Rel. 11.3 on AIX; Oracle Applications Rel. 11i On NT/2000/Solaris/AIX; Oracle Applications Rel. 11.5.10.2, R12 on Solaris/Linux; Maximo 4.5, 6.1.2 on Sun Solaris/AIX, JD EDWards Enterprise E8.10

Languages: UNIX Shell programming, COBOL, PASCAL, BASIC, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• My primarily responsibility is to act as a DBA Architect and technical advisor to ensure availability, performance and integrity of databases.
• Install, administer, maintain, and monitor Oracle 11g, 12c /SQL Server/MySQL databases in the B2B production environment and programs installed on databases in the B2B production environment.
• Install and test upgrades to databases/Applications including service packs, patches, hot fixes and releases in a UAT/Test environment and propagate it to Production.
• Troubleshoot and fine tune Oracle/SQL Server and MySQL databases. Create service request using My Oracle Support and SQL Server support for critical issues and bugfixes.
• Provide mentoring and Tier 3 support to Tier 1-2 technicians(Help Desk/Application Developers), Liaise with Regional Technicians (Montreal) and a variety of enduser departments specifically in support of B2B production Database and Applications.
• Manage Data Warehouse Databases using informatica as ETL and Microstrategy as reporting tool.
• Provide recommendations to improve and enhance B2B Database and application environment both technically and procedurally and ensure maximum efficiency of database.
• Create technical documentations and edit and test vendor provided documentation.
• Enforces database infrastructure policies and standards, Design and implement backup policies of Oracle, MySQL and SQL Server (On Sun Solaris/RedHat Linux and Windows 2008 Server platform).
• Proactively identify & develop plans to mitigate risks within the database infrastructure and implement and close IT Audit team recommendations.
• Manage Windows backup(Virtual Environment) on Veeam and Unix/Linux base backup on datadomain.
• Upgrade Veeam backup & Replication 6.5 to version 8.
• Cloning Oracle, SQL Server and MySQL production to UAT and DEV instances. Setup MySql replication and clustered DB in B2B Production environment.

Confidential

Senior Database Administrator

Responsibilities:

• Management of SAP ERP Business suit 6 with prime responsibilities of architecture, implementation and management of all 5 landscapes including maintenance and support of HP-UX clustered environment.
• As a SAPDB Administrator, responsibilities include but not limited to performing day-to-day technical tasks for a project, including all project activities. Duties span all Practice Areas involved (i.e., Design/Build/Run, Operations Architecture, System Administration, Database, ERP and other technical frameworks.
• Provide SAPDB administration Support for OLTP Systems, Performance monitoring & tuning, Problem analysis & resolution, and other activities required to maintain system integrity and maximize uptime.
• Experience in applying Support Packages and Upgrades for SAP modules. Setup, schedule and monitor batch jobs and interfaces, Plan and execute SAP release maintenance, system refreshes, client-copies & upgrades.
• Responsible for Oracle database analysis, performance tuning, Oracle database monitoring, Table Space administration and reorganization using RMAN and expertise in using DBA COCKPIT, it is a platform independent tool to monitor and administer database Actions and plan DB activities through DBA Planning calendars
• Used BRTOOLS tool to add data files, Monitor space utilization, monitoring file systems, Log monitoring, file system checks, create and rebuild indexes
• Designing and implementation of Backup solution based on VERITAS Netbackup version 6-7 & HP Data protector version 6, Integrate and schedule online SAP DB backup through HP Data protector, integrate and schedule online Oracle and SQL Server through netbackup.
• Upgrade Netbackup Master Server and Media Server from version 6.5 to 7 and Integrate with backup exec used by several other remote business units.
• Implement new tape libraries, netbackup appliance 5220 and migrate all netbackup v7 client base licenses to capacity base license.
• Perform HP-UX v 3.1 System and Cluster administration, system administration in a highly available HP-UX environment managing6 ServiceGuard clusters.
• Setup SCM to monitor HP-UX Unix servers through Centralized Monitoring System.
• Implement security related vulnerability fixes on DB as well as HP-UX environment.
• Manage SQL Server 2003 and 2005 instances serving Sharepoint and Windows based systems.
• Administrate JD Edwards instance with Enterprise One E8.10 Tools Release 8.97, Using IBM Web Sphere 6.1 as web services, Database as Oracle 10.2.0.4in cluster environment.
• Cloning Oracle, SQL Server and MySQL instances. Configure and setup MySql replication and clustering.

Confidential

Senior Database Administrator

Responsibilities:

• Oracle Database Administrator assigned charge of monitoring, optimization and tuning of database; introduction of Back up and Recovery Procedures with the aim of minimizing downtime apart from performance of regular database back up and maintenance of Back up Server.
• Installation and configuration of
• Oracle 10g RAC on 2-node Sun Solaris platform and Oracle E-business Suite 11.5.10/11.5.9 in RAC environment on Sun Solaris 10 (2Web Nodes, 2 Concurrent Processing /Database Nodes) in Shared APPL TOP and physical load balancing.
• Oracle E-Business Suite R12 single node instance for production instance migration drill.
• Migration, upgrading, maintenance and day to day administration & capacity planning of six production and twelve non-production Oracle 10g R2 instance on 2 node RAC Environment (16 Servers).
• Upgrading of Discoverer 9i instance to 10g apart from integration with three production Oracle ERP Application instances.
• Administration of two separate instances of Maximo 2 node RAC DB Oracle 10g and 2 node web logic application server, interface with Oracle ERP 11.5.9; management of Security and Data Oracle & Sybase Access Control.
• Administration and support of Sybase version 11.5 used by Reuters Treasury Suite of applications for management of the organization’s front, middle and back office treasury operations.
• Drafting and implementation of database policy and procedures (Database security policies, Backup and Recovery strategy, Upgrade/Migration plan and DB Audit procedures).
• Configuration and support of ADI (20-30 users); development of pro-active monitoring scripts and alerts for monitoring of Oracle Database and Application processes apart from notifying administrators in case of failures.
• Implementation of scripts for Cold, Hot and RMAN Back up.
• Optimization of database performance through analysis of database objects, generation of statistics, partitioning tables.
• Creation of indices and materialized views; identification of bottlenecks apart from taking Oracle traces and providing output of TKPROF and explaining plan utilities to the development team.
• Also involved in providing 24/7 support as core member of the support team.

Confidential

Senior Database Administrator

Responsibilities:

• Management of Oracle eBiz Suite on Fujitsu Siemens Flex Frame Architect with prime responsibilities of architecture, implementation and management of all middle tier and back-end database related tasks apart from maintenance and support of FlexFrame Architecture(4 RAC DB Nodes and 2 Shared Appl Top nodes).
• Provide leadership to a team of DBAs, Application Administrator, System Administrator and Developer through assignment of tasks, mentoring and monitoring of performance and schedules.
• Ensure regular database capacity planning in alignment to database growth and system utilization, trend analysis and prediction of future database resource requirements.
• Coordinate with other team leads and their technical teams to ensure adherence to delivery schedules; troubleshooting for all tiers of (Apache, Forms, Concurrent, Admin, Jinitiator and database).
• Implementation of SSO project for Oracle eBiz Suite at over 20 business units; setting up of disaster recovery and High Availability Architecture with dataguard apart from daily health check up of Dataguard.
• Centralization of all database monitoring and reporting using Oracle Grid control; implementation of database monitoring and tuning, application, and queries using TKPROF, Explain Plan, OEM, TOAD and custom scripts for optimum performance within testing, development, and production environments.
• Installation and configuration of Oracle E-business Suite R12/ 11.5.10/11.5.9 in RAC environment on RedHat Linux Platform (2Web Nodes, 4 Concurrent Processing /Database Nodes); upgrading of Oracle RAC DB from 9i to 10g R2.
• Handling storage usage of all databases, including rearrangements of database logical structure and tables based on requirements; involved in Oracle instance tuning, Oracle SQL tuning and Oracle application tuning.
• Planning and implementation of a comprehensive Oracle backup & recovery architecture using RMAN apart from creation of corporate documentation standards.
• Development of all E-Business cloning routines, backup and startup scripts to be used across various servers.
• Function as Senior Oracle Database Administrator assigned charge of DBA activities of various in-house projects, handling Oracle database design, performance optimization, installation and maintenance.
• Provide the organization with Best Security practices for Oracle 10g including securing access to default accounts, securing the network using encryption, using Single Sign On, enabling database auditing, enable application auditing for HR related tables apart from documentation of all security practices and creation of daily managements reports.

Confidential

Senior Technology Manager

Responsibilities:

• Responsible for DBA services on 24/7 2 node RAC DB oracle 10g implemented on Sun Sparc Solaris platform; ensure availability, integrity, security and optimum performance of the Oracle ERP Apps, CRM and legacy Database.
• Installation and configuration of Oracle Servers on Sun Solaris platform (Test, Stage and Production Servers) apart from providing support to the Application Servers; planning and implementation of Fail over and Fallback System for the Production DB server in case of crash using Standby Database.
• Development of SQL Loader scripts for weekly and monthly loading of MIS data from the CRM, OEX and other Portals to BI Database; performance of various Oracle Database and Tools upgrades from RDBMS version 8.x through 10g R2.
• Handling various application and database performance tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Installation and configuration of Oracle E-business Suite 11.5.10.2 in RAC environment on Sun Solaris (2 Web Nodes, 2 Concurrent Processing/Admin and 2 Database Nodes).
• Configuration of Load Balancing for Application Server and Shared Application Top apart from configuration of Parallel Concurrent processing, Workflow Notification Mailer, OAM and OEM10g.
• Cloning of Oracle Applications production system for Testing, UAT and development using RAPID clone; configuration of E Business suite instance in DMZ apart from configuration of Oracle Web Cache for E Business suite Instances.
• Application of Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack and one of Patches; capacity planning for PROD, TEST, DEV and patching instances for E-Business Suite
• Setting up of Discoverer EUL integrated with Oracle apps 11.5.10.2 and provide technical support for Discoverer Administrator.
• General system administration of existing corporate infrastructure and maintenance of clustered servers and high-availability of network infrastructure; design, implementation and maintenance of multi-tier, fully redundant production server architecture.
• Management of Sun Sparc base servers Running Apache, Application and DB; monitoring of physical operation of all equipment, including servers, Tape library, SAN and network rack.
• Day-to-day monitoring and administration of Sun Cluster environment; writing cron jobs and shell scripts for automation of daily routine jobs.
• Designing and implementation of Backup solution based on VERITAS netbackup version 4.5 to 6.

Confidential

Database Administrator

Responsibilities:

• Maintenance and administration of over 120 Database of Oracle, SQL Server and SYBASE; installation and creation of Oracle instances, management of databases apart from fine-tuning of both application and database configurations on UNIX, VMS and NT.
• Setting up and administration of E-business suite 11i Rel 11.5.9 with GL, AP AR and Inventory modules; integration of E-business instance with Maximo application apart from installation, maintenance and fine tuning of MS SQL Server DB.
• Handling major DBA activities like implementation of basic replication, backup and recovery, reviews, implementation of application developers' codes, monitoring logs and resolution of all related issues apart from analysis and optimization of SQL code.
• Development of backup scripts (consisting of three type of backup strategy - hot backup, cold backup, exp/imp, bcpin& out & DB dump)on the database, user and table levels for varying size of databases.
• Execution of all DBA & System Administration related tasks of Oracle Financials 11i, supporting and maintenance of ORACLE apps database, applying patches, maintenance of concurrent manager, creation and registration of users, printers, menus and responsibilities.
• Cloning of database from Production to test environment for all the major databases of 8i,9i, Oracle ERP, SQL Sever& Sybase; setting up of MAXIMO (ERP) apart from creation of interface of MAXIMO to Oracle ERP and its maintenance.
• Maintenance, administration and tuning of two major databases of SYBASE (HRMS & Free Zone Application); configuration and customization of Forms Server & Reports Server with 9i Application Server.
• Setting up and configuration of ORACLE Enterprise Manager for a variety of purposes with primary usage of monitoring all corporate databases.
• Writing of VMS scripts for daily, weekly & monthly purging & archiving; provide 24/7 support for the databases.
• Automation of database administrative process including job scheduling, logs, events and alerts for analysis of Schema, synchronization of data among remote databases apart from refreshing snapshots and batch jobs.
• Identification and re-organization of tablespaces, tables, indices during monthly or weekly downtime.

Confidential

System Analyst/ DBA

Responsibilities:

• Refreshing of test instances from production using exp/imp; application support on DRS (Document & Revenue System) across the Middle East region.
• Specification and development of bespoke regional requirements interfacing with the code DRS system and with third party's systems such as DPA (EDI, LOAD list, Manifest).
• Liaison with Service Group personnel based in London and with business users across the Middle East to provide direct user support.
• Troubleshooting and support of in-house developed systems; involved in user training & documentation.
• Analysis and designing of applications to integrate with DRS to meet local requirements using MS Access.