We provide IT Staff Augmentation Services!

Sr. Database Administrator Resume

Los, AngeleS

SUMMARY:

  • Have over 12 years of focused experience in IT industry
  • Comprehensive experience as Oracle DBA in various fields like Insurance, Retail and Telecom, Extensive experience in relational database design, analysis, development, administration, implementation, trouble shooting and quality management.
  • Extensive experience in 11gr2 RAC, Exadata, ASM,RMAN, Data Guard, Golden Gate
  • Oracle Certified Professional ( OCP DBA) in 10g
  • Worked in 24x7 production environment and provided on - call and day-to-day support.
  • Comprehensive experience as performance Tuning/Table Partitioning ( OLTP and Data wareHousing )
  • Installing & configuring and supporting RAC/ASM environment
  • Clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
  • Worked with customer for different RAC related issue
  • Troubleshoot performance issues for the RAC instances
  • RAC database restore and backup & cloning
  • Upgrade of 10g R2 RAC to 11g R2 RAC
  • Patching RAC cluster and database
  • Installing & configuring golden gate environment
  • Performing Initial Data load, configure extract, datapump, manager & replicate process
  • Troubleshooting golden gate abend process, handcollison & lag issues,logdump
  • Implemented Oracle Golden Gate for table level replication with multiple extract replicate processes. replicating huge & mixed number of tables
  • Implemented Golden Gate from Oracle to replicating databases using Oracle Golden Gate between homogeneous and heterogeneous databases.
  • Migrated Non-ASM Single Instance to ASM RAC Instance.
  • Manage RAC environment for Day to Day Database administrator
  • Expertise in Oracle Data Guard and Physical Standby databases,
  • Expertise in Oracle Enterprise Manager (OEM), TOAD,
  • Expertise in DataPump ( Expdp,Impdp), SqlLoader, Materliazed View
  • Experience in Migration of DB2 to Oracle database
  • Expertise in Performance tuning the production database towards optimal performance
  • Experience in capacity planning, Space management, database Upgrades/Migration planning/implementing Backup/recovery strategies using RMAN
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and PL/Sql- Tables, Materialized views
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
  • Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g
  • Using SqlLoader to Load XML and flat files in oracle database
  • Extensively Used the XML SQL Oracle (Extract, ExistsNode, ExtractValue, XMLSequence, Append ChildXML) functions to generate, insert and manipulate XML files in Oracle 11g
  • Creating and translating business process specifications into design specs and XML business rules.
  • Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required. Session Tracing, AWR reports
  • Data Modelling using Erwin
  • Source data analysis, table design using Erwin, Improved designs for ease of data loading
  • Changed architecture and mapings as needed to improve performace
  • Business analysis and data model design for new tables related to ETL
  • Design and create database tables needed for application
  • Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Involved in handling the changes in compiling scripts according to the database changes
  • Developed reports using complex queries as per client request as a part of production support
  • Performed SQL tuning using Explain Plan, Hints and indexes
  • Responsible for performing code reviews
  • Created SQL*Loader scripts to load data into temporary staging tables
  • Data types conversion and mapping between different source

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/NT/XP, MS-DOS and UNIX,AIX,LINUX

Application Domain: Telecom, Retail, Health care, Insurance, Banking,SAP

Tools: MS Office,Brtool, Toad, SQL Developer, OEM, File zila, Putty, BMC Remedy

Databases: Oracle 9i/10g/11gr2 RAC, ASM, RMAN, Data Guard, Golden Gate

PROFFESIONAL EXPERIENCE:

Confidential, Los Angeles

Sr. Database Administrator

Responsibilities:

  • Working on 12c database and 11 g rac database
  • Resolve the performance issues of Oracle11g databases.
  • Handle daily production issues and migration of oracle database
  • Rman cloning, back up and recovery and export and import
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential, New York

Sr. Database Administrator

Responsibilities:

  • As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
  • Working on 12c database and 11 g rac database
  • Resolve the performance issues of Oracle11g databases.
  • Handle daily production issues and migration of oracle database
  • Rman cloning, back up and recovery and export and import
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential, New York

Sr. Database Administrator

Responsibilities:

  • As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
  • Working on 12c database and 11 g rac database
  • Resolve the performance issues of Oracle11g databases.
  • Handle daily production issues and migration of oracle database
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential, San Jose, CA

Sr. Database Administrator

Responsibilities:

  • As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
  • Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
  • Implemented High availability using Golden Gate Replication
  • Troubleshooting golden gate abend process, handcollison & lag issues,logdump
  • Resolve the performance issues of Oracle11g databases.
  • Handle daily production issues and migration of oracle database
  • Manage databases in a 24x7 mission-critical production environment
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential

Sr. Database Administrator

Responsibilities:

  • As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases at Confidential Project Europcar, Orange, Sequana, Gefco
  • Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
  • Installation of RAC and Managing RAC Environment efficiently
  • Managing Exadata database servers for two nodes clusters
  • Mentor other DBAs in effective use of RMAN software, and my scripts.
  • Resolve the performance issues of SAP Oracle databases.
  • Handle daily production issues and migration of SAP
  • Manage SAP databases in a 24x7 mission-critical production environment
  • Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
  • Implemented High availability using Golden Gate Replication
  • Troubleshooting golden gate abend process, handcollison & lag issues,logdump
  • Currently helping team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance.
  • Actively working with other teams for Server Consolidation & Database Consolidation.
  • Changes were made dynamically whenever possible to fulfill high-availability requirements.
  • Enforced need of regular data purging processes from production, design and development, to deployment.
  • Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
  • Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
  • Proficient in RAC Performance Tuning. Create and maintain materialized views.
  • Implementing and maintaining database security (create and maintain users, roles and assign privileges)
  • Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Monitored the production Oracle alert logs for database errors.
  • Monitored system resource availability and responded to system memory and data issues.
  • Expert with OEM Grid Control.

Environment: SAP application, BO application with Oracle Database RAC 11gr2Single Instance 10g & 11g . Database Backup Schedule with RMAN using netbackup and Tivoli . Storage used for storing data is ASM and file system disk.

Confidential, New York

Lead Database Administrator

Responsibilities:

  • DBA Lead and supporting 11gr2 RAC database
  • Provided production database support for Application
  • Helped other team members to complete PL/SQL code development and sql tuning
  • Managed and coordinated with other team for database deployment in production.
  • Provided support to QC and DEV database for application testing and coding.
  • Provided business reports to management from reporting database
  • RAC 11gr2 installation and configuration on prod and non prod database servers
  • Single sign on implementation of oracle virtual directory in 11g
  • Configure OIM ( Oracle identity manager) for application
  • Integration with OVD ( Oracle virtual directory) and Active directory
  • Understanding of Import users, account, roles, Policies, Business structure in OIM
  • Configure the Oracle Identity Manager Data Collection Scheduler
  • Import the Oracle Identity Manager (OIM) Data Into Oracle Identity Analytics
  • Configure Oracle Identity Analytics to Connect to Oracle Identity Manager
  • Scheduling Incremental Updates of Users, Accounts, User-Role Memberships, and Entitlements in OIM
  • Using DBMS Scheduler for batch jobs
  • Datapump expdp and impdp for data transfer

Confidential, Chicago, IL

Lead DBA and ETL Developer

Responsibilities:

  • Project Lead and supporting 11gr2 RAC database
  • Managing and coordinating with other team for database deployment in production.
  • Providing support to QC and DEV database for application testing and coding.
  • Developed PL/SQL packages, procedures and functions accordance with business requirements for loading data into database tables.
  • Involved in unit testing of stored procedures and functions.
  • Created materialized views and partitioning tables for performance reasons.
  • Worked on various backend procedures and functions using PL/SQL.
  • Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from production databases.
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL.

Environment: Java J2ee application, data stage, cdc, golden gate, Naca tool with oracle database 10g/11g

Confidential

Lead DBA and PL/SQL Developer

Responsibilities:

  • DBA Lead and supporting business online application
  • Production database support for Application
  • Helping team to complete pl/sql code development and sql tuning
  • Managing and coordinating with other team for database deployment in production.
  • Providing support to QC and DEV database for application testing and coding.
  • Provide business reports to management from reporting database
  • Sql loader to load the bulk data in database
  • Implementation of request for Change in database
  • Database Cloning from prod to non prod
  • Deploy the database build as release
  • Upgrade 10g to 11g single database instance
  • Database data testing
  • Writing Trigger, Procedure, Package for application
  • Writing queries and helping application for performance issue
  • Making business reports using sqls
  • Writing shell script for batch jobs
  • Support application testing for data validation

Environment: Java application, OLTP business with retail AT &T domain, UNIX and Win. NT

Confidential

Lead DBA and PL/SQL Developer

Responsibilities:

  • Actively managed 40 database instances
  • Provided 24*7 Support to database
  • Responsible for database installation, instance creation, patching and upgrading, also involved in storage space management and planning
  • Co-ordinated batch testing and load and performance testing
  • Provided support to additional support to other projects
  • Database backup and recovery
  • Trouble shoot database related issues
  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
  • Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
  • Created data mapping files for the data coming from different web services.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
  • Developed procedures using Dynamic SQL..
  • Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Worked with ETL team and architect to build data model for staging area.
  • Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.

Hire Now