We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Auburn Hills, MichigaN

PROFESSIONAL SUMMARY:

  • 10 + years of IT Experienced Oracle 10g Certified Professional in Oracle Database Administration, management of large databases and data warehouse environments providing 24/7 support of both development, deployment and production administration of 11g/10g/9i databases on Various on Unix and Windows based Platforms
  • Specific Areas of expertise include:
  • Install and manage very large Oracle Databases serving Customer’s UAT & Production environment hosted over Enterprise Server & Storage
  • Hands on experience with planning and deploying Enterprise grade Hardware Infrastructure that supports Very large IT & Telecom databases
  • Deploy Oracle Grid Infrastructure on both SPARC & x86 platforms featuring RAC, ASM over EMC SAN and Data Guard
  • Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
  • Implemented Data Guard with high availability and performance configurations and Participated in Data Guard Failover tests
  • Hand - on experience in installation, upgrades, patching and strong troubleshooting skills with experience spanning across both Single & RAC databases
  • Plan Golden Gate setup to achieve Unidirectional & Bidirectional replication
  • Test initial Data Load option of GoldenGate during environment build
  • Extensively used RMAN in performing backup, disaster recovery, and for cloning/replicating of the Production databases
  • Performance Monitoring & Tuning of Oracle Database using tools like AWR, ADDM, ASH and TKprof
  • Experience in various facets of System level (Solaris & Linux) & Storage (EMC SAN) administration including Installation and Maintenance.
  • Considerable experience in RMAN backup & recovery involving media & ASM disk-group failures
  • Hands on experience in supporting ASM instances and provisioning & de-provisioning capacity to ASM.
  • Install GoldenGate software in Test region to perform POC
  • Perform POC for testing DDL and DML replication across Databases
  • Handling batch jobs for tablespace and datafile capacity management, partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Scheduling and other housekeeping tasks.
  • Responsible for supporting 24*7 operations of Production databases hosted in multiple regions and duties included raising Oracle SR support to deal with bugs and issues associated.
  • Hand-on experience in migrations like from Non-Oracle DB to Oracle DB, Non RAC to RAC and non ASM to ASM
  • Extensively used SQL & PL/SQL (Packages, procedures, functions, triggers...etc.) and query performance monitoring & tuning using tools like explain plan, trace and TKprof
  • Proficient with Export/Import, Data pump, Erwin, SQL Loader, SQL Developer and Toad.
  • Working knowledge with business objects tool (SAP BOXI) and ETL’s.
  • Hands-on experience in preparation of RAC environment & Data Guard setup on Virtual Machine’s
  • Offer internal seminars on various aspects of database management and performance tuning

TECHNICAL SKILLS:

Database Administration: Oracle 9i, 10g & 11g, MySQL, Sybase

Operating Systems: UNIX, RHEL 5/6, Solaris 10, Windows Server

High Availability: Real Application Clusters (RAC) 10g & 11g, Data Guard and GoldenGate

Oracle Utilities: Exp & Imp, Data pump, RMAN, DATAGUARD, GoldenGate, Explain Plan, TKprof, ASH, AWR, ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: TOAD, Erwin Data Modeler, Secure CRT, XShell, Putty, SQL Developer, SQL Loader

Others: VERITAS Volume Manager, EMC storage (SAN & NAS), F5 Load Balancer

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, Michigan

Senior Database Administrator

Responsibilities:

  • Migration of the Oracle 11g databases from Non RAC to RAC.
  • Upgradations of Oracle 11g databases from 11.2.0.1 to 11.2.0.4 using patch set
  • Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
  • Installation and configuration of Oracle GoldenGate
  • Prepare GoldenGate parameter files for Extraction and Replication
  • Configure DDL synchronization in oracle GoldenGate.
  • Implementing Initial Load, Data synchronization, data pump for Replication in oracle GG
  • Setup GoldenGate Database User with necessary privileges
  • Integration & Troubleshooting issues related to 3PP applications

Confidential, Plano, Texas

Senior Database Administrator

Responsibilities:

  • Planning and deployment of Confidential Customer Management Solution (ECMS) across regions
  • Grid environment prerequisite handling and cluster verification using CLUVFY
  • Assess hardware readiness specifically x4170 servers and EMC-VNX unified storage
  • EMC-VNX Storage configuration & deployment using Unisphere management software
  • Oracle Grid Infrastructure installation and configuration.
  • RAC Database creation over Oracle GI setup
  • RAC Service configuration and testing with integrated front end load balancer (F5)
  • Service configuration and testing via SRVCTL
  • Site readiness assessment for Geo-Redundancy setup (Physical Standby)
  • Bandwidth and throughput recommendation between primary and secondary sites
  • Site configuration and failover testing using Data Guard Monitor (DGMGRL)
  • Setup GoldenGate Database User with necessary privileges
  • Plan and Implement Data Replication between Heterogeneous Databases
  • Prepare GoldenGate parameter files for Extraction and Replication
  • Perform Large scale Structure and Data Migrations across multiple environments
  • RMAN backup configuration to NAS (EMC VNX)
  • Load balancer (F5) setup for frontend load balancing of HTTP and SOI requests
  • Document Server Installation/Upgrade, Storage Configuration & Host Integration procedures
  • Monitor/troubleshoot and maintenance of GoldenGate replication
  • E2E Responsible for offering UAT test cases (functional and non-functional) to customer
  • Troubleshooting the issues related to Oracle RAC,DataGuard and Product level
  • Oracle upgradations from 10g to 11gR2 as part of Confidential product installations.
  • Plan and execute data migration from Classic SYBASE database to Oracle database using proprietary DMI scripts.
  • Analysis of legacy ECMS 2x server with classic DB version including Hardware, Software, PC’s installed, local adaptations & major issues with legacy system.
  • Migration strategy and draft migration project plan with timelines.

Environment: Oracle 10g 11gR2, RAC on ASM, Geo-Redundancy using Data Guard, F5 Load Balancer, EMC VNX Storage, Sun Solaris 5.10, RHEL 5

Confidential

Senior Database Administrator

Responsibilities:

  • Second Line and Emergency Support (24*7) for Confidential DWS & ECMS
  • Resolve client escalations related to database outages caused by server/storage failure
  • Restoration and Recovery of Production databases on media failure and disaster situations.
  • Resolve high priority escalations related to Oracle ASM availability and VERITAS Multipathing
  • Provision or De-provision ASM disk-group capacity online
  • Report and validate RMAN backups using crosscheck facility
  • Handle archive log gaps reactively as part of standby gap analysis
  • Oracle Database, SQL & PL/SQL Query Performance Monitoring & Tuning of using tools like AWR, ADDM, ASH, Explain plan, traces and TKprof
  • Troubleshoot issues related to SQL loader and ETL transformations.
  • Handling of Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files
  • Validate and recover datafile for physical and logical corruptions using RMAN / dbv
  • Schedule and Monitor Data pump export of monthly and daily partitions
  • Monitor table & index partition statistics for improve database performance
  • Perform root cause analysis of historical issues using ADDM and AWR reports
  • Performing database re-organization as required, Table & Index partitioning to monitor performance issues and ensuring maximum uptime of the database
  • Development and Testing of RMAN scripts on Development databases for media failure and disaster recovery situations.
  • Establishing back-up policies and Restore activity, backup using User Managed Backup (Data Pump) and Recovery Managed Backup (RMAN).
  • Apply One-Off and CPU/PSU Patches on Production systems as part of intermittent change package rollouts.
  • Handle Memory management advisories, Proactive Space management and Database capacity planning
  • Troubleshoot and resolve performance escalations on the Oracle10g & 11g Databases.
  • Handle CSR across Oracle, Storage and System domain for customers across regions
  • Core member of L2 CRS 24*7 Emergency Recovery Team
  • Worked closely with System Administrator to unearth database issues triggered by Kernel and Storage issues.
  • Troubleshoot and resolve the issues related High Availability
  • Document Server Installation/Upgrade, Storage Configuration & Host Integration procedures

Environment: Oracle 10gR2 & 11gR2, VLDB/RAC on ASM, Geo-Redundancy using Data Guard, EMC CX-240, Sun Solaris 5.10, RHEL 5

Confidential

Database Administrator

Responsibilities:

  • Manage Users and User Profiles in a typical Multi-user online transaction processing system.
  • Administration of Schema, Storage and Database Resources pertaining to Customer transactions and reporting databases.
  • Diagnose and Troubleshoot Oracle database issues within the required time frame
  • Monitor and Maintain Operating system resources to ensure optimal database performance.
  • Coordination with customer to diagnose and troubleshoot issues to ensure smooth performance of daily batch processes and month end reporting processes
  • Script and Schedule logical backups using Export and Import for Auditing, Reports and Reconciliation and ensure completion within the backup window.
  • Implementation of Full and Incremental Database backups using appropriate RMAN scripts.
  • Archival of Schema scripts, binaries and metadata for recovery purposes.
  • Installation of Oracle 10g Database software on Solaris 10 platform.
  • Scripting, Monitoring and Maintenance of scheduled RMAN backups
  • Configuration and Maintenance of the Recovery Catalog
  • Database Administration in SAP oriented platforms
  • Development and Testing of RMAN scripts on Development databases for media failure and disaster recovery situations.
  • Perform Logical Backups of Historical data to augment Physical Backups.
  • Performance monitoring and tuning using TKPROF, EXPLAIN PLAN, AWR, ADDM for the Better performance.
  • Experienced with handling fairly large amount of data using Partition and Sub-Partitions
Environment: Oracle 10g and 9i, Sun Solaris 5.9/5.10,RHEL 5, Windows Server,OEM, RMAN, Export/Import, Datapump,SQL, PL/SQL, TOAD, Erwin, STATSPACK,ERWIN Data modeler

Confidential

Database Administrator

Responsibilities:

  • Creating the data warehouse database.
  • Physical database design using ERWIN data modeler.
  • Creating and managing database objects, users, roles, privileges and profiles.
  • Monitoring databases, which include basic health checks, growth of objects, and performance of the databases.
  • Maintaining the BO databases.
  • Installing, upgrading and applying patches to the database
  • Scripting, Monitoring and Maintenance of scheduled RMAN backups
  • REFRESH/CLONING of Database and applications for development & testing
  • Monitor and gathering table & index partition statistics up to date
  • Performed Tuning of various SQL queries to improve the performance of the database.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Reverse Engineering the physical data model using ERWIN data modeler and generating the scripts.
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Providing the customer requested data/tables using export&import and datapump jobs.
  • Handling the client’s requests on time
  • Creation and maintaining Production and Development databases.
  • Monitoring databases, which include basic health checks, growth of objects, and performance of the databases.
  • Scheduling batch jobs for tablespace and datafile capacity management, partitioning performance tuning, statistics gathering.
  • Checking alert log and trace files on daily basis.
  • Managing resources, Users, Privileges and Roles.
  • Moving of objects across databases using Data pump, Export and Import.
  • Partitioning of tables for performance.
  • Data refresh from production to test and development.
  • Configuring Listeners and troubleshoot connectivity issues.
  • Performed Hot and Cold Backups using shell scripts.
  • Collecting database objects statistics regularly for to improve database performance
  • Written nightly scripts and scheduled using CRONTAB.
  • Administration of ASM - addition, dropping disks rebalancing....
  • Perform backups and recovery using RMAN.
  • Testing RMAN backups every quarterly.
  • Creating the duplication database using RMAN backups
  • Installing, upgrading and applying patches to various versions of oracle
  • Raising Oracle SR support to deal with bugs and issues associated.

Hire Now