SUMMARY:

• More than 12 years of IT experience as Senior Oracle Database Administrator in Production environment.
• Expertise in Oracle 11g/10g/9i/8i database administration in high availability production environment.
• Oracle 11g/10g/9i Real Application Clusters (RAC) installation and maintenance.
• Extensive experience in production database support.
• Expert in backup/recovery using RMAN, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
• Transforming Logical data model into Physical data models.
• Solid experience in disaster recovery (standby & DataGuard), routine maintenance for Oracle databases
• Solid experience in Oracle Recovery Manager (RMAN), advanced replication, and standby database using Data Guard 9i/10g/11g
• Database backup concepts and options such as user - managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Employing Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Performance monitoring/tuning/troubleshooting on Oracle, Unix, Linux, and Windows NT/2000/2003 servers
• Installation, configuration, upgrading and migration of Oracle software (9i, 10g) and tools. Applying patches under UNIX, Linux and Windows platform.
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts
• Excellent interpersonal and strong analytical, problem-solving skills
• Knowledge of Banking, Data Warehousing, Telecom and ERP technologies.
• IT Consultancy skills.
• Excellent written and verbal communication skills with all levels of personnel within a client organization.
• Persuading and influencing all levels of management in the design and implementation of an integrated Oracle solution.

TECHNICAL SKILLS:

Databases: ORACLE 11g Release 2 RAC, Oracle 10g RAC, 9iRAC, 9i/8.x/7.x. SQL Server 2008

DBA Tools: SQL developer, DBA Studio, Oracle OEM, TOAD, Spotlight, Quest CentralDB Artisan, SQL server Enterprise manager, Query Analyzer.

Operating Systems: Sun Solaris, HP-UX, IBM-AIX Linux (Redhat, SUSe, Oracle Enterprise Linux) & Windows 2000 professional.

Cluster Wares: Veritas, Oracle Cluster Ware

Case Tools: Platinum ERWIN, Sybase Power Designer.

Languages: Developer/2000, Developer 6i.

ETL TOOL: Oracle warehouse builder, IBM Datastage.

Hardware: Sun Sparc, IBM PC, HP Superdome, HP superdome 2, IBM Blades.

Volume Manager: Veritas Volume manager.

Storage: EMC SAN with SRDF, IBM San with PPRC.

ORACLE Tools: OS watcher, L-TOM, Oracle GoldenGate, Rapid Install, AD utilities, Oracle Universal Installer

High Availability: Physical Data Guard, Logical Data Guard.

Oracle Storage: ASM (with ASM Lib), Oracle 11g R2 ASM

Data Loading: Oracle data pump, SQL* Loader, Export/Import

Grid Infrastructure: ORACLE 11g R2 grid Infrastructure.

Messaging System: ORACLE advanced Queue, IBM Websphere MQ v 7

ORACLE Security: ORACLE Wallet, Oracle Transparent data encryption

ORACLE: Diagnostic10046 trace, systemstate dump, hang analyze, event tracing

Monitoring Tools: HP openview, Guardium, Oracle Enterprise Manager, Introscope 7, IBM Tivoli

Automation Tools: HP Server automation

Scheduling Tools: Control-M, Maestro

Data Modeling: ER-Diagrams, Star schema, Snow Flake schema, Sybase Power Designer, ER-Win

Oracle Financials: Oracle E-Business suite R12

Virtualization: Oracle virtual Box, Oracle VM, HP-UX VPAR, IBM-AIX LPAR

Version Control: PVCS

WORK EXPERIENCE:

Confidential

Senior Oracle DBA Consultant

Responsibilities:

• Installing Oracle 11g R2 Grid Infrastructure and Oracle 11g R2 RAC software on HP, Linux and IBM AIX platforms.
• Setting up multiplexed Oracle Data Guard environment as migration strategy to BDC data center.
• Performing Oracle Data Guard switch over between Production and DR servers using Oracle Data Guard Broker.
• Working with client to perform Pre-cutover activities before migrating Data Guard environment from CPO to BDC data center.
• Installing, Creating and managing new Oracle 11g R2 RAC Dev and PAT environment at BDC centre.
• Extensively using RMAN to backup and Recover 10 TeraByte of DB using IBM TSM media manager layer.
• Implemented Security in different levels of database. Utilizing Oracle Advanced Security options (Transparent Data Encryption using wallet).
• Applying quarterly released CPU and PSU patches to Grid Infrastructure and Oracle RDBMS.
• Performed data migration across databases and platforms.
• Worked with users, analysts, developers and system admins to realize root cause of performance issues, modelling, debugging and troubleshooting.
• Provide 24*7 production database support as well as development databases to ensure maximum availability of database for all applications.
• Database cloning/refresh from production to production reporting, and backup.
• Extensive experience with IBM TSM Tivoli monitoring, IBM TSM backup media manager layer.
• Converting Physical Standby database to Snapshot Standby database for User and application testing and vice versa.
• Working with Unix SA to patch Database servers.

Confidential

Senior Oracle/SQL server DBA

Responsibilities:

• Leading Team of 4 senior Production DBAs in Infrastructure migration project.
• Participating in planning and execution phases of Infrastructure migration project along with other teams.
• Demonstrating planning and execution activities to the senior management of the bank.
• Installing Oracle 11g Release 2 RAC software on HP (Superdome 2) &Red Hat Linux (HP proliant) platforms.
• Creating Oracle 11g RAC instances and databases which are failover and load balance enabled.
• Installed Oracle E-Business suite R12 on Oracle Enterprise Linux and HP-UX servers.
• Provide operational support, including troubleshooting and resolving database and application problems.
• Applying Oracle E-Business R12 Suite patches.
• Developed, analyzed, designed, and implemented the organization’s storage infrastructure/architecture to ensure high levels of data quality and availability.
• Managing physical database resources.
• Configuring and managing oracle’s clusterware and its components (voting disk, OCR, VIP & nodeapps).
• Installing and configuring Oracle GoldenGate on HP-UX & IBM-AIX servers.
• Setting up uni-directional and bi-directional replication using Oracle GoldenGate.
• Implementing, maintaining and testing backup & recovery strategies using RMAN utility.
• Migrating Oracle 10g Databases to Oracle 11g R2 (Oracle 11.2.0.3)
• Applying Oracle quarterly released PSU patches for Oracle 11g R2 DBs (Oracle 11.2.0.3)
• Setting up auditing, security standards as per Bank’s standards to be PCI compliant.
• Monitoring system and instance resources & architecture to ensure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).
• Providing 24*7 on-call technical support on rotation basis.

Confidential

Senior Oracle DBA (Production)

Responsibilities:

• Installation of Oracle 11g & 10g standalone as well as RAC software on Unix (Sun, HP, Linux and AIX) platforms.
• Creation of Oracle 11g & 10g Dbs.
• Applying quarterly released Oracle PSU and CPU patches to Dev, QA, UAT and Production environments.
• Participate in the design and maintain the physical models of multiple databases consistent with BA guidelines and the Information Strategic Plan.
• In collaboration with project teams, define access security and capacity requirements.
• Develop, implement and maintain the standards and procedures related to the creation, maintenance and usage of all database resources.
• Responsible for the database tuning and administration, backup strategies, data security.
• Work in close collaboration with the ongoing project and Operation teams.
• Designing, testing, correcting and optimizing systems to ensure that the objectives of the system are met and that the outputs produced are in accordance with client requirements.
• Identifying, monitoring, managing, and reporting risks, problems and change management requests
• Creating/managing and refreshing Materialized views manually.
• Creating & enforcing security and High availability architectural standards.
• Participating in Disaster Recovery exercises.
• Participate in monthly release activities for ROGERS.
• Providing On-Call DBA support on rotational basis to ensure databases are operational 24x7.
• Restored & recovered 2 TB DB using RMAN and Symantec Netbackup
• Stabilized execution plan which changed due to table segment size and DB initialization parameters.
• Ensuring DB is compliant with IBM security standards (ISec) by running security scans every quarter.
• Working with DB auditors (external and internal) to address DB security leaks.

Confidential

Senior Oracle DBA (Infrastructure/Production Support)

Responsibilities:

• Production support for existing Oracle Databases.
• Actively involved in Performance/tuning of DB applications.
• Actively Involved with Storage and System administrators in capacity planning.
• Installed Oracle 11g Release 2 Grid Infrastructure software on IBM AIX servers to use Oracle’s ASM.
• Installed ORACLE 11g Release 2 Database Software on IBM AIX servers.
• Applied ORACLE security patches for Oracle 11g R2.
• Installed and configured ORACLE messaging Gateway for message propagation between ORACLE AQ and IBM Websphere MQ.
• Installing, configuring and creating Oracle 11g RAC Infrastructure/DataBases architectures on AIX.
• Configured ORACLE restart on AIX server.
• Installed and configured Oracle 11g R2 32-bit client software on AIX servers.
• Integrating Oracle Database applications with IBM websphere MQ applications.
• Configuring DB for Inbound and Outbound message propagation.
• Managing and monitoring the Messages flow from Oracle’s Advanced queue to IBM MQ and vice versa.
• Monitoring Oracle Messaging Gateway.
• Working with IBM Tivoli Monitoring Agent development team in engineering IBM Tivoli agent for Oracle Messaging Gateway monitoring.
• Implementation of iSeC security standards.
• Developing RMAN’s Backup and Recovery strategies for High Availability of application.
• Using Oracle 11g Release 2 compression and Encryption capabilities to compress and secure the critical trading data.
• Production support/On-call rotation for existing Oracle Databases.

Confidential

Senior Oracle DBA (Production)

Responsibilities:

• Installed/Cloned Oracle Software (Oracle 10.2.0.4.0 ) on HP machine using Silent Installation method.
• Built Physical Standby DB for Confidential North America Operations.
• Database Production support/on-call rotation for existing Oracle production Databases.
• Participating in On-Going Performance/tuning issue.
• Successfully installed and configured Oracle Grid Control 10.2.0.1 (Oracle Management Server & Oracle Agent) on Linux Box.
• Successfully upgraded Oracle Grid Control to Oracle Grid Control 10.2.0.5.0.
• Installing and configuring Oracle GoldenGate on Linux servers.
• Successfully Migrated the character set of production DB from WE8MSWIN1252 to AL23UTF8 using csscan utility.
• Used Oracle 10g data guard (data guard broker, data guard observer) to automate database failover/switchover between primary and standby DB.
• Used ASMLib on Oracle Enterprise Linux to configure ASM disk for ASM instances.
• Created Logical Standby DB using ASM (Primary and Standby DB both used ASM).
• Providing 2nd Level on-call support on rotational basis.
• Working with auditors and application developers for remediation of audit action items.
• Installing/configuring/managing SQL server 2005 named Instances for Business reporting purposes.
• Production support for existing SQL server Databases.
• Actively participating with DB architects for Capacity planning for existing DBs.

Confidential, Brampton, ON

Senior Oracle DBA (Production)

Responsibilities:

• Converted Oracle 10g Non-RAC database to 10g RAC database.
• Installed Oracle E-Business suite R12 on Redhat Linux.
• Applying Oracle E-Business R12 Suite patches.
• Installing and configuring Oracle GoldenGate on AIX unix servers.
• Setting up Uni-directional replication using Oracle GoldenGate.
• Creating standby databases as part of the DR strategy and ensuring the Primary and standby DB are in sync with each other.
• Upgrade of DB running on Oracle 9i to Oracle 10g.
• Managing and supporting technical changes being implemented into the environment.
• Actively participating in Design (logical and physical), testing and implementation phases of Software Development life cycle for new projects.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Actively participating in DR exercise to ensure the restoration of business continuity in a real disaster scenario.
• Actively participating with application owners/ application developers to fine tune the application code and optimal utilization of DB and system resources. Statspack and AWR reports are thoroughly analyzed to obtain the performance problems.
• Using various Oracle tools like (OS watcher, L-TOM) to capture the run time events and operating system/IO statistics and events.
• Ensuring the successful backups are happening and storing on tape using Net backup.
• Participating in BCV and RMAN backups.
• Providing after hours On-call Support for database related problems as part of an on-call rotation.
• Documented Oracle physical and logical data models. Developed master data management models. Reviewed and optimized current Oracle table structures.
• Implemented Oracle Data Guard, Standby, Oracle Enterprise Manager 9i/10g/11g Grid Control. Configured OEM / Grid Control to generate alerts for critical thresholds.
• Maintaining Rogers' standards for database implementations and service.
• Installing/Administering SQL server 2005 Instances and DBs on Windows servers.
• Production Support/On-call rotation for existing Oracle and SQL server Databases.

Confidential, Toronto, ON

Senior Database Administrator (Production)

Responsibilities:

• Verifying the node reach ability, user equivalence, node connectivity, system requirements and kernel packages by using Oracle Clusterware CVU (Cluster Verification Utility) utility.
• Installation, configuration and management of Oracle 10g Clusterware (CRS, Voting Disk, OCR).
• Managing CRS (Cluster Ready Services) for start, stop and status checking.
• Managing Voting disk and OCR (Oracle Cluster Registry).
• Installation, configuration of Oracle 10g RAC software.
• Creating Real Application Databases which are Failover enabled and Load Balanced.
• Managing RAC DB using srvctl utility for various administration tasks.
• Installation and creation of Oracle 9i RAC software on VeritasClusterware.
• Creation of RAC DBs which are Failover enabled and Load Balanced.
• Installation, configuration of ORACLE 9i and 10g NON-RAC software on Sun Solaris platform.
• Migrating Oracle 9i Release 2 DB to ORACLE 10.2.0.3.0.
• Creation of RAC and NON-RAC databases on SUN Solaris platforms.
• Participating in the design, engineering, configuration, testing, and performance tuning of all Relational database management systems (RDBMS).
• Evaluating and recommending the acquisition of database and data management solutions to meet changing business requirements and to continuously optimize the business application environment.
• Coordinating and oversee ongoing maintenance and upgrades for all RDBMS's with internal teams and external service providers.
• Providing rigorous testing for new DBMS releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
• Providing project oversight for large-scale complex database application changes and implementation.
• Providing technical leadership in the Unix and Wintel based application environments working with the AEE group and the LOB CIO’s:
• Provides consulting services to application development teams to understand the World Markets DBMS standards and system infrastructure to optimize application performance attributes prior to production implementation
• Continuously develop and improve Confidential standards for software tools and system design
• Employ Confidential standards and industry best practices when designing and implementing new solutions.
• Actively provide leadership and technical expertise to ongoing problem identification/resolution and root cause analysis process for database environments:
• As a Level 3 escalation resource for problem determination and resolution of all issues encountered during development, quality assurance and user acceptance testing, production system integration, and all issues escalated by Level 1 and Level 2 Command Center staff post-production.
• Accountable for adhering to problem management process for DBMS related incidents consistent with Global processes to meet service expectations of regional customers.
• Provide mentorship to database engineers and Confidential Command Centre analysts in all aspects of database management, automation, trouble-shooting, and problem resolution.
• Accountable for problem determination, troubleshooting and resolution of database-driven application problems through use of system diagnostic utilities and industry recognized best practices.
• Participates in the improvement of support processes, subject matter expertise, and technical capabilities with the Database Services and Command Center teams to continuously improve service delivery and efficiencies.
• Participates as a team member in evaluating system resource utilization and storage usage/capacity, and makes recommendations to increase application performance to meet business and financial requirements.
• Support production environments, configuration, testing, and performance tuning of all Oracle database environments.
• Verify the database support requests and execute them in timely manner as the business SLA’s.
• Coordinate and oversee ongoing maintenance and upgrades for all Oracle with internal teams and external service providers
• Manage the production, deployment & maintenance of Oracle RAC. Provide expertise around optimizing performance and ensuring high-availability.
• Provide consulting services to application teams and possess good understanding of Confidential DBMS standards and system infrastructure.
• Provide rigorous testing for new Oracle server releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load (ETL) strategies, high availability strategies, disaster recovery, and other application design strategies.
• Managing problem/project tickets queue and maintaining communication with business team members.
• Consult with problem/project ticket owners in resolving issues and executing scripts as per the requirements.
• Continuously monitor the request queue and prioritize tickets in the queue as per the guidelines from the management.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.

Confidential, New York, USA

Senior Database Administrator

Responsibilities:

• Installation of Oracle software (10g, 9i/8.x) on SUN SOLARIS & Windows 2000 professional.
• Creation and configuration of oracle based databases on Sun Solaris and Windows platforms.
• Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of relational database management systems.
• Design/support in defining and modifying logical and physical database model for data warehouse and data marts.
• Managing users by assigning them privileges through roles, and quotas.
• Enforcing security using encryption/decryption and Fine grained access control.
• Entirely responsible for maintaining the Production, Test and Development databases of the company, which mainly includes the following:
• Managing files of a database.
• Replicating the data between production databases (Avis and Budget) residing on same server using snapshot master replication method and Oracle streams.
• Analyze SQL queries and make recommendations to Data Warehouse engineers and extraction programmers for possible alternates to accomplish the tasks.
• Execute backup procedures: COLD backup, HOT Backup with database in Archive log mode using RMAN & also Full and Incremental Database Exports.
• Execute restoration procedures of complete & incomplete media recovery using RMAN. Restoring full backup & Time based Recovery.
• Design and implement Networking between Oracle Servers on different operating Systems.
• Extensive hands on working experience of Oracle Utilities: Export, Import, SQL*Loader, RMAN.
• Hands on working experience of TOAD, Spotlight, OEM and DBA studio.
• Experienced in Partitioning large tables across physical disks to increase throughput and better management and maintenance.
• Provide 24x7 system support as a system DBA for Production and development systems on a rotational basis

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of ORACLE and MS SQL server 2000 software, installation and configuration of application database at customer sites.
• Diagnose and tune performance problems and locking conflicts using Oracle database monitoring and diagnostic tools (SQL TRACE, EXPLAIN PLAN, TKPROF, UTLBSTAT/UTLESTAT) and dynamic performance tables/views.
• Writing bespoke PL/SQL code (packages and procedures) to accomplish the requirements for the production and Admin modules of the ERP.
• Performing the Tuning and Maintenance of the application and database.
• Performing physical and logical backups of application database running on ORACLE and MS SQL server 2000.
• Tuning RDBMS to optimum levels of performance.
• Checking and controlling user access and authentications to the DB through roles and system/object privileges.
• Implementation of audit trails for key transaction/data.
• Provide rigorous testing for new DBMS releases and patches, configuration changes, indexing strategies, maintenance routines, upgrade and data migration strategies, data distribution (replication) strategies, extraction-transformation-load strategies, high availability strategies, disaster recovery, and other application design strategies.
• Creating and implementing the physical design form the logical design.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.
• Checking of CPU, memory and disk utilization and checking the existing constraints and indexes. Also checking and verifying rollback segments and temporary tablespaces.
• Provide 24x7 system support as a system DBA for Production systems on a rotational basis

Confidential

DatabaseAdministrator (ORACLE)

Responsibilities:

• Planning, Installation and deployment of Oracle based applications to 3rd party Sites.
• Writing bespoke PL/SQL code according to client specification.
• Writing Shell scripts to wrap PL/SQL code.
• Advising customer of coding techniques for optimum performance.
• Performing the Tuning and Maintenance of the product specific database.
• Performing physical and logical backups and advising Customer of Backup and Recovery routines.
• Tuning RDBMS to optimum levels of performance.
• Installation of Oracle Software at customer’s sites and Islamabad office on Sun and HP servers.
• Checking and controlling user access and authentications to the DB.
• Configuring the Sun and HP servers for the installation of ORACLE software and creation of DB.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.
• Overseeing the day-to-day requests for objects creation, user creation and structure modifications.
• Provide 24x7 system support as a system DBA for Production systems on a rotational basis.

Confidential

Computer Officer/DBA (ORACLE)

Responsibilities:

• Smooth functioning and management of Database. This included controlling user access, backup and recovery, storage management, application software upgrades, SQL Tuning, and automating support issues with bespoke program suites.
• Analyzing, designing, development and implementing new software to fulfill the needs of organization.
• Working for the welfare of 30 Database operators under my jurisdiction.
• Performance reviews for Oracle resulting in massive gains for Oracle based systems
• Administration and planning of In-house databases for high performance output.
• Taking Backups of database using oracle’s features for backups and restore.
• Providing Oracle Consultancy to other National Logistic Cell departments to integrate organization’s skill set.
• Tuning RDBMS to optimum levels of performance for optimal usage of database resources.
• Checking and controlling user access and authentications to the DB.
• Overseeing the day-to-day requests for objects creation, user creation and structure modifications.
• Checking of CPU, memory and disk utilization and checking the existing constraints and indexes. Also checking and verifying rollback segments and temporary tablespaces.
• Verifying that all instances are up and running and checking unusual entries in alert log and trace files on daily basis.