We provide IT Staff Augmentation Services!

. Senior Database Administrator Resume Profile

Merrimack, NH

Professional SUMMARY

  • Awarded as the best employee for my tremendous performance as a team member in 2007.
  • Took the initiative in making the necessary changes in the designing of the Database and Backup strategies.
  • Initiated in speaking to the team members to analyze the problems and issues by escalating it to the higher level.
  • Initiated in conducting the weekly meetings for DBA's and developers to discuss the issues and plan the maintenance activities well before in order to avoid the database downtimes.
  • Experienced in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods Created and designed Oracle best practice documents for the DBA's which has the environment details, understand the Technical, Functional concepts, Process and Structure of the Database. These documents where very useful for the developers and DBA's in identifying and analyzing the problems for resolving the errors in quick time to meet the SLA.
  • Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
  • Extensive experience as Oracle Server DBA and proficient in Oracle 9i,10g,11g software installations, database Capacity Planning, Backup Implementation, Tuning Oracle 9i,10g on Unix and Linux platform
  • Extensive experience in Application Development, Database development and 24x7 production system support handling large databases using Oracle 11g, 10g, 9i, 8x, 7.x, on various platforms like AIX 4.3.to 5.3. ASM ,Solaris 5.9/RedhatEL 4.0/ ScoUnix 5.3.2/UnixWare 7.0/ HP UNIX 11.0 and WinNT 4.0/2000/2003
  • Certified Oracle DBA with over 10 years of Exposure on Production, Systems Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
  • Rewarded for Training and Knowledge Transfer to the fresher's in Oracle 9i/10G.

Technical skills

Databases : Oracle 11G/10G/9i/8i, Exadata, SQL Server 2000, Sybase

Oracle High Availability : 10G/11G RAC, ASM, Advanced Replication, Data Guard

Oracle Tools : Reports 6i, SQL Plus, OEM 12 C

Oracle Utilities : SQL Loader/Expdp /Impdp/RMAN

Operating Systems : Linux/Solaris 8.0/HP UX/Windows 2003 server

Storage Technologies : SAN EMC DMX, BCV, SRDF, OCFS, Oracle ASM

Backup Recovery : RAMN IMP/EXP, flashback, Legato, Net Backup, EMC, GC

Languages : SQL, PL/SQL, Shell Scripting Visual basic

Other Tools : Erwin, TOAD, SCP, FTP, VNC, X Manager, Exceed

Professional Experience:

Confidential

Senior Database Administrator

Responsibilities

  • Maintain and Monitoring of Oracle 11G DG physical standby databases, manually apply the missing logs to standby from primary.
  • Applied BUG patches which are caused by Ora- errors.
  • Applying PUS patches for both RAC and Non RAC databases.
  • Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
  • Monitor and Maintain the Autosys jobs.
  • Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
  • Extensively worked on 12C grid control to Monitor and Maintain the Databases
  • Performed switch over and fail over on Standby database using datagaurd broker.
  • Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
  • Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
  • Resolving the locks on the database.
  • Created Plans for PL/SQL to find out the issue causing the performance.
  • Monitor batch process and resolve them if they run more than expected time, Resolving locks, long running jobs,
  • Find out the proper execution plan to improve the performance of the query.
  • Monitoring performance using AWR reports and ADDM Reports.
  • Tune SQL and PL/SQL, analyze them to find out the performance issue.
  • Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
  • Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment

HP UX, Solaris, Linux, AIX, Oracle 10g, 11g, RAC, 12C OEM, ASM, Golden Gate, Exadata, Delphix, Autosys, Sybase.

Confidential

Senior Database Administrator

Responsibilities

  • Applied BUG patches which are caused by Ora 600 and Ora 7445.
  • Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size. Upgraded multiple production RAC environments from 10gR1 to 10gR2.
  • Install and configure Oracle databases on various platforms. Backup, restore, modify, monitor and tune databases as required. Identify and tune problematic SQL. Monitor RAC configurations.
  • Install, monitor and tune Oracle Application Server/Fusion Middleware software. Upgrade systems from Oracle Application Server to Weblogic.
  • Deploy Java code in Oracle Application Servers, Fusion Middleware Servers, Weblogic, Apache Tomcat, Jboss and WebSphere servers.
  • Maintain security protocols such as SSL and SSO. Monitor system performance to identify and recommend solutions for performance.
  • Applying PUS patches for both RAC and Non RAC databases.
  • Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
  • Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
  • Implemented shared appltops on NFS mounted disks across web farms supporting dedicated Apache servers for Discoverer and Configurator,
  • Performed switch over and fail over on Standby database.
  • Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
  • Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
  • Resolving the locks on the database.
  • Monitoring performance using AWR reports and ADDM Reports.

Confidential

Senior Database Administrator

Responsibilities

  • Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
  • Applied BUG patches which are caused by Ora 600 and Ora 7445.
  • Upgraded multiple production RAC environments from 10gR1 to 10gR2.
  • Installed and managed Oracle Fusion middleware and configured the tech stack for Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.
  • Applying PUS patches for both RAC and Non RAC databases.
  • Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
  • Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
  • Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
  • Performed switch over and fail over on Standby database.
  • Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
  • Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
  • Resolving the locks on the database.
  • Monitoring performance using AWR reports and ADDM Reports.
  • Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment

HP UX, Solaris, Linux Oracle 9i, 10g, 11g, RAC, ASM, OCFS2

Confidential

Senior Database Administrator

Responsibilities

  • Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
  • Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
  • Designed logical and physical Data Models of database at schema levels using ERWIN.
  • Upgraded multiple production RAC environments from 10gR1 to 10gR2.
  • Involved in Migration of databases from Windows 2003 to UNIX and UNIX to Windows 2003.
  • Applying patches on 3 nodes and 2 nodes RAC databases.
  • Responsible for RAC Systems Support and maintenance of database sizes of more than 20TB
  • Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups.
  • Installed and managed SOA Middleware components for Dev, Stage and Production instances
  • Applied Middleware Patches to patch level the instances
  • Applied BUG patches which are caused by Ora 600 and Ora 7445.
  • Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
  • Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
  • Performed switch over and fail over on Standby database.
  • Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
  • Monitoring performance using AWR reports and ADDM Reports.
  • Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
  • Audit of the Data/Database objects for auditors.
  • Extensively used SQL Loader to migrate the legacy data to the new instance
  • Installed and configured Oracle 10gRAC maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters, Oracle Management Server, and OEM on Red Hat Linux 4 Advanced Server with 2 nodes server side load balancing using ASM.
  • Installed and configured Oracle Enterprise Manager to monitor the Databases.
  • Maintenance of Oracle 10G DG physical standby databases. Configuring Data Protector using RMAN to take DB backups.
  • Experience in High availability design with VERITAS Cluster and Volume Management.
  • Experience in monitoring the VERITAS Net Backups.
  • Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR and OEM.
  • Involved in Physical and Logical design of Data MODEL using ERWIN.
  • Designed, Implemented and Tested Backup Recovery strategies for database using Data Pump and RMAN Utilities.
  • Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
  • Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery
  • Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
  • Experience with ecommerce applications in Java/tomcat.
  • Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
  • Documentation of Data Base Setup and administration of Server Environment.
  • Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
  • Created and Maintained Users and Roles with Appropriate Privileges and Profiles
  • Audit of the Data/Database objects for auditors
  • Involved in evaluation and capacity planning process of deciding the central storage hardware for the new RAC environment.
  • Attending meetings with developers, managers and the users to discuss the change or enhancements to the legacy system
  • Involved in DB Upgrade from 8i to 9i for Oracle Applications
  • Extensively used SQL Loader to migrate the legacy data to the new instance
  • Checks for Oracle database.
  • Installation, creation, configuration and Performance tuning of database.
  • Performance tuning for Oracle Day-To-Day Maintenance and management of the several different databases in development, test, and production environments.
  • Understanding the existing Database Structure and suggesting the database reorganization.
  • Oracle 10g Installation and Configuration.
  • Upgraded databases from 9.2.0.1 to 10gR2 and applied critical patches update CPU for latest versions.
  • Actively involved in installation and configuration of Real Application Clusters RAC running on 2 node clusters.
  • Involved in project of upgradation of standalone databases to 10g RAC environment.
  • Worked on SAN
  • Maintained and Monitored the VERITAS Net backups.
  • Configured Bigfile Tablespace for Very Large Scale Database VLSD .
  • Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size.
  • Wrote shell script, which generate Statspack Report at regular interval.
  • Resolved performance issues by Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
  • Automated the Database refresh process from Production to TEST environment.
  • Data loading using Oracle SQL Loader and also developed SQL Loader script to load data with fine tune setting for optimum performance of the SQL loader.
  • Extensively used new features of 10g like Import, Export and Data Pump logical backup.
  • Wrote a shell script for taking backup using Export/Import.
  • Involved in Physical and Logical design of Data MODEL using ERWIN.
  • Automation of lot of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
  • Created Database link to access the object on remote database and scrip to check the connectivity among all the databases.
  • Audit of the Data/Database objects for auditors.
  • Monitored and tuned Rollback Segment, Temporary Tablespace, Redo Log Buffer, Sort Area Size, and Flash Recovery Area.
  • Storage Management, Managing Space, Tablespaces, Segments and Extents, Rollback Segments Data Dictionary.
  • Granted and Revoked privileges and roles to the users on different objects depending on their work requirement and provided the necessary security to the database.
  • Supported test and development environments to ensure smooth transition of applications into production.
  • Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

Environment

HP UX 11.00, Linux, AIX, Oracle 8i, 9i,10g and SQL server, My SQL

Hire Now