We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Denton, TX

SUMMARY

  • Expertise in Oracle database administration, Database design, development in Oracle 10g, 11g and 12c databases on Linux, UNIX, AIX, and Windows environment.
  • Experience in installing and Configuring Oracle Real Application Clusters (RAC) with Automatic Storage Management (ASM) for high availability databases..
  • Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
  • Rolling patch apply in oracle RAC environments as well as OS Cluster databases.
  • Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
  • RMAN backups are scheduled, monitoring and maintaining in Oracle 11g OEM grid .
  • Participat ion in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Setting up High Availability Oracle Golden Gate OGG systems on Oracle 11gR2 RAC environments Front - end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .
  • Experience in setup and configuration Golden Gate .
  • Replication and Extracting data and applying on production using Golden Gate .
  • Hands-on experiences in trouble shooting and performance tuning Oracle Golden Gate replications.
  • Experience as On-Call 24x7 production DBA support for Critical databases.
  • Password Vault administration and monitoring for secured oracle user’s password (SYS, SYSTEM and other users).
  • Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like tkprof, sql profile Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and (Automatic Diagnostic Repository) ADR .
  • Experience in maintaining Oracle Data Guard physical Standby Database and providing critical solution with strategic disaster recovery plans.
  • Experience in Data Guard setup in oracle 10g and Active Data guard in 11g and 12c.
  • Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases by using RMAN.
  • Database and ASM instance monitoring and administration for oracle 9i, 10g and 11g by using 11g OEM grid control tool.
  • Pro - actively monitored the database and its files growth rate and actively added adequate space for the datafiles and also in respective disk groups (Raw devices).
  • Allocating system storage and planning for future storage requirements.
  • Oracle Database Re-organization, index rebuilding for maintenance and administration.
  • Database refresh, schemas refresh, tables and partitions refresh by using impdp, expdp, Import and Export Utilities.
  • Cloned Database from Production to Test and Development.
  • Experience in migration of oracle database to higher version and installing patches.
  • Experience on handling very large database up to 8 TB
  • Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux 5.9, 5.10, 6.5, HP-UX 10.x/11.x, Sun Solaris, AIX, and Windows NT/ 2000/2003/2008.

RDBMS: Oracle 9i/10g/11g, 12c, Oracle 10g/11g Real Application Clusters (RAC).

LANGUAGES: C, C++, SQL, PL/SQL, JAVA, J2EE and Shell Scripting.

SOFTWARE/ APPLICATIONS TOOLS: OEM, DATAGUARD, Recovery Manager (RMAN), Data pump, STATSPACK, AWR, TKPROF, ADDM, ADR, Golden Gate, Exadata,SQL Loader, SQL Developer, TOAD, TPAM.

WEB TOOLS/REPORTING TOOLS: HTML, XML, BI, BO, crystal reports.

PROFESSIONAL EXPERIENCE

Confidential, Denton, TX

Senior Database Administrator

Responsibilities:

  • Supporting commercial RMS applications as database administrator for various databases.
  • Managing overall project delivery, quality and timely execution of Oracle Retail databases support across multiple application teams like Merchandising Systems (RMS), Store Inventory Management (SIM) and downstream external interfaces.
  • Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, Import/Export, SQL* Loader, Explain Plan, Tkprof, sql trace, analyze, hints, Oracle 11g AWR, ADDM etc.,
  • Backup and recovery using RMAN, expdp.
  • Switchover & Failover of DG Databases using DGMGRL Data Guard Broker
  • Setting up database auditing for database securities and monitoring.
  • Monitors service delivery in order to recognize trends proactively identify problem root causes; resolve service delivery problems.
  • Incident, Problem and Change management to review trend, database support metrics to assess and evaluate gaps and areas of improvements in database support and team's performance.
  • Coordinating periodic support meetings with client Senior Managers and Applications team partners, to prioritize Support activities and plan for support coverage and database maintenance.
  • Work management for Support team members by assigning and tracking issues to closure.
  • Follow communication and escalation path and involve respective stakeholders for fast resolution of issues.
  • Technical and functional consulting on Oracle Retail applications by coordinating with existing application teams and guide his Oracle retail support team lead and members on new initiatives
  • Responsible for discussing with client manger and AD team to arrange the resources for key releases and timeline based on the team’s availability and technical estimation.
  • Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like TKPROF, SQL PROFILE Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and (Automatic Diagnostic Repository) ADR.
  • Database and ASM instance monitoring and administration for oracle 11gR2 by using 11g OEM grid control tool.
  • Experience in Building, maintaining Oracle Data Guard physical Standby Database and providing critical solution with strategic disaster recovery plans.
  • Established clear working and process model for Onsite & Offshore team and executed the projects in shorter timelines by two geographical teams working without issues but with lower costs.
  • Experience as On-Call 24x7 production DBA support for Critical databases.
  • Contribution to ongoing security Audits to comply with client's security requirements.
  • Weekly status reporting to client Managers and Cognizant stakeholders.

Environment: Operating Systems: Red hat Linux 6.5 and Windows 2003/2008 RDBMS: Oracle Database Server 11g/12c, Programming Language/Tools: TOAD, PL/SQL, SQL Developer,RMAN

Confidential, California

Database Administrator

Responsibilities:

  • Expertise in Oracle database administration, Database design, development in Oracle10g and11g database on Linux, AIX, UNIX and Windows environment.
  • Database and ASM instance monitoring and administration for oracle 9i, 10g and 11g by using 11g OEM grid control tool.
  • TPAM administration and monitoring for secured oracle user’s password (SYS, SYSTEM and other users).
  • Database refresh, schemas refresh and tables refresh by using impdp, expdp, Import and Export Utilities.
  • Oracle database upgrade from 10g to 11gR2.
  • Managing Real Application Cluster in 10g and 11g.
  • Golden Gate configuration and implementation in Linux and Exadata environments.
  • Installing Oracle Real Application Cluster Versions 10g and 11g on Linux servers.
  • Rolling patch apply in oracle RAC environments as well as OS Cluster databases.
  • Responsible for Database administration work like applying PSU patches, Interim patches for the single instance.
  • Pro - actively monitored the database and its files growth rate and actively added adequate space for the datafiles and also in respective disk groups (Raw devices).
  • Performances tuning for database using ADR, AWR, ASH and ADDM reports analyze as well as query tuning explain plan /SQL TRACE/TK Prof report.
  • Backing and restoring the database by using RMAN/EXPDP/IMPDP.
  • Protecting Oracle Database Appliance - Tape Backup with CommVault Simpana.
  • Security Configuration for Oracle Database 11g.
  • Oracle Database Re-organization for maintenance and administration.
  • Allocating system storage and planning for future storage requirements.
  • DB link/materialized view creates need to be done.
  • Monitoring and detecting the locked objects and releasing the locks. Killing unwanted sessions.
  • The Database refresh, Schemas refresh and Tables refresh in Development and Test databases.
  • Monitoring Space and Index usage. Rebuilding Index on the needed objects.
  • Managing Privileges by creating roles, profiles, system and object privileges and granting to database users.
  • Performed SQL tuning on issue like slow running queries and hanging etc.,
  • Administrating database, managing users, profiles, tablespace, schema, rollback segments and instance.
  • Worked out privileges and Roles to be granted to the users
  • Database Objects Creation and Space Management and automate the house keeping procedure.
  • Day to day database activities like space monitoring, DB health checking and monitoring alert logs.
  • Good command over Utilities like RMAN, Export, Import, expdp, impdp, SQL*Loader, DB verify and DBID.
  • Working with FTP/TELNET/WRQ Reflection for Linux and RDP for windows.
  • Sensibly carried out checking Alert Logs and taken steps to rectify in case of any error messages.

Environment: Operating Systems: Redhat Linux, IBM-AIX and Windows 2003/2008 RDBMS: Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL, SQL Developer and TPAM

Confidential, Michigan, US

Sr. Tech Specialist

Responsibilities:

  • Installed Oracle 11g database on AIX and Red Hat Linux.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
  • Installed and administered Real Application Cluster (11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
  • Have worked on different environments like test, development and production databases.
  • Have worked on backup/recovery, performance tuning.
  • Worked on OLTP and OLAP database systems.
  • Responsible for upgrade & migrating databases from 10g to 11g, applying patches.
  • Database Restore using RMAN, Cold Backup and Export/import.
  • Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
  • Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
  • Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
  • Used impdp /expdp and SQL- loader to load data into tables.
  • Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
  • Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
  • Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
  • Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 5.1, HP -UX 11.23, Solaris, Windows XP, Oracle 10g / 11 g, RAC, OEM, Grid ControlRMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Hire Now