SUMMARY

• Dynamic, Team player, Competitive IT Professional with 19 years of experience
• 18 years of experience as Oracle 12c/11g/10g/ 9i/8i/7.3 database administrator.
• 10 years of experience as Oracle RAC environment
• Experience in carrying Microsoft SQL Server DBA
• Experience as an Oracle application 11.5.8/11.5.9 - DBA includes Installation, Applications DBA (AD), Cloning (Rapid clone), Patching, and System Administration (OAM).
• 12 years of experience in Oracle Standby and Data Guard Technology
• Extensive experience in carrying DBA activities such as Oracle Server installation, database creation, Backup and recovery using shell scripts, RMAN and Oracle Secure Backup, EMC, Database tuning, Problem solving, Database Upgrades and Migration, Client/server connectivity. Experience with design and administration of large Oracle database running in SAN environment, set up critical, secure and complex database for bank environment.
• Experience in security technologies to protects data in database systems.
• Post-Installation Troubleshooting and Support of Development/QA and Production databases
• Expert in backup & recovery and Oracle disaster planning.
• Experience in doing end-to-end setup of multi tiers applications.
• Extensive experience in carrying OSI ( Confidential ) banking application.
• Experience in interacting with the UNIX, Linux, Networking, Application and Business Teams to get database environment setup.

TECHNICAL SKILLS

Oracle Application: Oracle 11.5.8/11.5.9 Application-DBA

Oracle Tools: SQL plus PL/SQL, TOAD, RMAN, ASMSQL Loader, Import/Export, OEM, Oracle Grid Control

Programming: PL/SQL and UNIX shell script

Operating systems: WindowsUNIX/Sun Solaries/HP Unix/AIX/Linux/IBM

Databases: Oracle 7.3/8i/9i/10g/11g, Unify 3.2, SQL Server, IngresInformix

OTHER SKILLS: MINCOM, Pascal, BASIC, COBOL, ACCESS/SQL, INFORMIX SQL, PL/SQL, FoxPro, Clipper, Accell/4GL, UNIX, Windows, Oracle Real Application Cluster, Java, Ingres II, Oracle Standby and DataGuard Technology and Microsoft SQL Server, SAN, EMC Storage, Pillar Storage, Apache, Web, Oracle Portal, Oracle Grid Control, Oracle Transparent Data Encryption (TDE), Oracle Data Masking, Oracle Secure Backup, Oracle Data Vault and Oracle Audit Vault.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• Setup OEM (Oracle Enterprise Manager) and Grid Control 12cR2
• Server setup and maintain Linux operating system
• Maintain Oracle Database Administrator 11g and 12C and SQL Server 2008 and 2008R2
• Oracle and SQL Server database performance and tuning
• Monitoring the Database backup and recovery process.
• Manages SAN storage
• Database and Server Hardening
• Control of maintenance activities Database and server
• Monitoring system access and use
• Identify potential service level problems before they occur and notify appropriate parties
• Work with developers to test applications and implement changes into production
• Ensure compliance in related tasks with company and regulatory policies and procedures

Confidential

Oracle Database Administrator

Responsibilities:

• Setup and maintain High-Availability and Disaster Recovery solutions for Oracle 10g/11g/12c database and Linux operating system
• Oversee Implementation and configuration of Oracle Real Application Cluster
• Review database design of application, providing conceptual and logical data model and translating into physical database
• Provide advising on database sizing, physical database layout, security, disk partitioning and network configuration
• Provide optimizing and tuning database to achieve optimized throughput for production
• Manage Storage Provisioning - Planning, Preparation, Implementation on EMC data system
• Approach to securing the database, network and operating infrastructure
• Provide regular report on the database health check, security check follow up and recommendations.
• Conduct troubleshooting on database, providing and monitoring follow up.
• Manage database instances for production and development to ensure strong development environment and smooth transition to production.
• Setup database backup encryption technology using oracle secure backup software.
• Setup sensitive data in the database should be encrypted.
• Responsible for Installation, upgrade, patching Oracle RDBMS software and LINUX
• Review application design to achieve the purpose of application such as flexibility and reliability.
• Provide support for Databases in 24*7 environment following SLAs and escalation policies
• Review operational excellence to achieve higher availability (24x7), including backup and restore policy; putting Standard Operating Procedure and making recommendations.
• Setup Confidential application for banking Application.
• Integrates Confidential Inc. Application with Oracle database and Microsoft SQL server database
• Responsible for SQL Server Database support, troubleshooting, planning and migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Monitoring of database size and disk space in Production, Staging & Development environments
• Security and architectural planning issues met as well as testing and training.
• Performed installation of SQL Enterprise 2008 R2 64bit version on Windows 2008 R2 servers on Enterprise systems of clustered
• Failover cluster testing and resolution on Dell servers as well as monitoring and backup
• Configured Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Creation and scheduling of Maintenance plans (database and log backups and cleanups
• Good Knowledge of using SSRS, SSIS (SQL Server Reporting Services).
• Installed and configured SQL Server Cluster server in SQL Server 2005 and 2008 R2 using Dell servers Performed Production support and on Call duties.

Confidential

Senior Oracle Database Administrator Consultant

Responsibilities:

• Installing and managing Red Hat Enterprise Linux, managing software packages, Network Configuration, and enhancing security.
• Deploys and manages multi-site, multi-vendor SAN storage environments.
• Deploys and manages storage and EMC Disk Library.
• Installation and configures Automatic Storage Management (ASM).
• Responsible for installing, troubleshooting, monitoring, managing and Configuring SQL server and Oracle databases
• Setup Oracle Secure Backup to centralized tape backup management with advanced features such as encryption, vaulting, and dynamic drive sharing.
• Setup Standby database/Data guard to achieve a highly available Oracle Database and Minimize the downtime associated with any outage and prevent data loss.
• Setup Confidential Inc banking application to integrate core data processing applications built on a single centralized Oracle and SQL server database.
• Responsible for general maintenance of the database, including adding storage as necessary, troubleshooting problems, backup and recovery.
• Performed Oracle DBA consulting services for client. Duties include Oracle configuration, Oracle database administration, Oracle monitoring and migration of data and code.
• Responsible for the implementation, maintenance, design extensions and support of mission critical database system.
• Responsible for installing, troubleshooting, managing and Configuring OSI ( Confidential Inc. ) database
• Capable to provide 24X7 supports in a critical production environment.
• Setup measurement of customer data security by selectively encrypting sensitive data before it is stored in the database.

Confidential

Senior Oracle Database Administrator Consultant

Responsibilities:

• Performing Database Administrator tasks in Oracle on AIX
• Performs the following verifications on IBM AIX 5.2:
• ORACLE HOME Directory Verification
• UNIX User/umask Verification
• UNIX Group Verification
• Memory/Swap Verification
• TMP Space Verification
• Real Application Cluster Option Verification
• Unix Kernel Verification
• Oracle Real Application Cluster: Implementation and configuration Oracle RAC on IBM pSeries 650 server cluster environment.
• Determining the Oracle RAC architecture
• Configuring the Distributed Lock Manager (DLM)
• Configuring the raw disks for Oracle RAC
• Installing Oracle RAC software
• Installing and testing Oracle Transparent Application Failover (TAF)
• Performance tuning for Oracle Real ApplicationClusters (RAC)
• Setup database backup and restore strategies using RMAN

Confidential

Senior Oracle Database Administrator Consultant

Responsibilities:

• Performing the following Database Administration tasks independently in Oracle 8i and 9i:-
• Installation of oracle software
• Database setup, database upgrades, space management, backup and recovery using either SQL Backtrack or RMAN, database cloning
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment
• Setup and maintain High-Availability and Disaster Recovery solutions.
• Working in Linux, BMC SQL BackTrack and BMC Patrol.
• Proficient in Unix system administration relevant to Oracle database management
• Supporting multiple and large oracle databases environment.
• Capable to provide 24X7 supports in a critical production environment.
• Proficient in Standby and DataGuard Technology
• Provide Oracle Production support in a critical production environment.
• Support GoldenGate Oracle Replication

Confidential

Senior Oracle Database Consultant

Responsibilities:

• Advising on database sizing, physical database layout, and disk partitioning and network configuration (with High-Availability in mind) on IBM AIX 5.2.
• Reviewing of database design of application, providing conceptual and logical data model and translating into physical database
• Reviewing of application design to achieve the purpose of application such as flexibility and reliability. In addition providing knowledge on effective use of Structured Development Methodology using CASE tools
• Reviewing operational excellence to achieve higher availability (24x7), including back up and restore policy; putting Standard Operating Procedure and making recommendations.
• Propose model and design for Disaster Recovery
• Optimizing and Tuning database to achieve optimized throughput for production
• Provide regular report on the database health check, follow up and recommendations.
• Conduct troubleshooting on database, providing and monitoring follow up.
• Advising and assisting in migration of database to new version.
• Managing database instances for production and development to ensure strong development environment and smooth transition to production.
• Mentoring BCA staffs to achieve higher competencies in Oracle database design and tuning, development tools and methodology
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment using oracle Tools (e.g OEM, TOAD, STATSPACK)
• Managing SQL Server database
• Implementation, Cloning (Rapid clone) and Patching of Oracle Application 11.5.8/11.5.9

Confidential

Oracle Database Administrator

Responsibilities:

• On going Database tuning, including the resolution of production performance issues.
• Regular database reorganisations, which are necessary to ensure optimal performance and availability
• Implementation of database change requests
• Provision of standard user access maintenance
• Ensuring License compliance, where it is within CSC control (it is common for DBMS licenses to be held by the client).
• Database upgrade planning and implementation
• Provision of database backup and restore strategies for both Production and Development systems.
• Capacity planning for databases
• Implementation of appropriate database performance monitoring and tuning software
• Restoration of data - specialist involvement in non-standard restore tasks

Confidential

Oracle Database Administrator

Responsibilities:

• Oracle Database Maintenance on IBM AIX 5.1
• Administer the AIX system and backup of Tivoli backup host system. Function as an information source for all backup issues.
• Performs analysis and design of backup processes and procedures at all levels of complexity. Works with internal clients to help identify the files and file dates required for recovery.
• Coordinates directly with vendors to implement new equipment and evaluate alternative solutions. Installs and configures the server and client portions of backup and recovery software for all locations.
• Management of the design of performance changes to the application, batch programs and tuning of the Oracle database, including the re-design of the database to achieve increased performance.
• Tuning of Disk I/O
• Tuning of oracle parameter
• Investigating tuning related to PL/SQL and PL/SQL that can help performance
• Specific tuning advancement in Oracle8
• Responsible for Optus Billing system Installation and Upgrade
• Upgrade of Oracle RDBMS
• Check database links & passwords; ensure we can connect with the user id, password connects string combination
• Check installation prerequisites
• Check link applications
• If new INSTALL or upgrade path exists (for each upgrade step)
• Check grants and synonyms, Recompile any INVALID objects, Analyze any changed objects
• Check post-install/post-upgrade, Check operational prerequisites, Check variables/environment list
• Verify directories list, Verify the existence of database objects

Confidential

Oracle Database Administrator

Responsibilities:

• Monitoring database performance and security.
• Problem resolution in a production environment.
• Provision of technical advises, relating to database, to management and clients.
• Providing Oracle Database support and administration services to ensure that service levels are met.
• Database Upgrades, Reorganizations
• Database Migration from HP-UX to Sun OS. Database Migration from oracle 7. * To Oracle 8I database.
• Installed and administrated Oracle 8I, Oracle OAS, WEBDB on various servers.
• Wrote database creation script, backup script, installed and administrated other Oracle products e. g. OAS 4.0.8, set-up and configuration of Single Master replication for 8i databases.
• Maintained NT Server operating system (under which the development database runs) defining and implementing database backup and security strategies, testing backups periodically for consistency and reliability.
• Performed media / object recovery in the event of database crashes or user accidents.
• Maintained NT Oracle8i services / configuration.
• Predicted future storage /resource requirements for database production.
• Proficient in Standby and DataGuard Technology

Confidential

Oracle Database Support Analyst

Responsibilities:

• UNIX environment set up and configuration
• Oracle RDBMS and Tools installation, migration and upgrades
• Database creation procedures, user management, database object rebuilding, space management consulting
• SQL*Net configuration, setup and tracing.
• Act as a liaison between customers and Oracle Customer Worldwide Customer Support
• Duties included all aspects of Oracle database administration including performance & tuning, Oracle installation and Oracle upgrade, database maintenance, and database recovery.
• Responsible for investigating, recommending and implementing all new database technologies

Confidential

Senior System Analyst & Oracle Database Administrator

Responsibilities:

• Day-to-day operation and maintenance of a mission-critical Oracle 7 RDBMS Database.
• Defined the DBA procedures and tasks from initial database sizing, setup, space allocation, user account creation and administration, security rules and procedures using the latest Oracle 7 security features and system resource (datafile, rollback, space limitations, temporary segments, et al) management.
• Monitored system performance and performed tuning as needed to optimize database performance.
• Performed as Unix and RDBMS (HP-UX) administrator.
• Backup and recovery planning and implementation.
• Served as a senior Oracle database administrator performing all duties to maintain the Oracle data repository

Confidential

Programmer

Responsibilities:

• Using the Data Integrity Subsystem to specify Data Integrity Subsystem Attributes for production data base columns and compile a DIS source file.
• Using Data Base Tools to generate data base statistics and data dictionary information; prevent problems related to shared memory and process management; perform day-to-day tasks such as database startup, shutdown and maintenance
• Using Data Base Recovery tools to recover from failure, including backup and restore procedure definition
• Configure the environment to maximize the performance of the UNIFY 2000 application.
• Create, update and modify the existing ACCELL/4GL application as per user requirement. Process involved getting user requirement, database and application design, coding and testing.
• Coding of application software for various Clients using Unify/Accell