We provide IT Staff Augmentation Services!

Oracle Sr Database Administrator Resume

Austin, TX

OBJECTIVE:

Seeking a challenging position in the field of database management for Oracle database Administrator where I can leverage my business knowledge and data management skills to speed and secure the company’s data with new functionalities for high availability of databases, design databases, replicating data between datacenters, ensure standards and work with management to ensure database integrity and work towards achieving company’s expectations.

PROFESSIONAL SUMMARY:

  • Over 10+ years of experience in Information Technology in administering multi - Terabyte ORACLE 11g,10g,9i and 12c databases.
  • Experienced with Installation, Configuration, Monitoring, Upgrading and Migration of Oracle databases between ORACLE 9i, 10g,11g and 12c databases on different operating systems like Linux,Sun Solaris, Confidential -UX & AIX.
  • Experienced in OEM-Oracle Enterprise Manager. Experienced in End-to-End Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
  • More than 8 years worked as Oncall DBA for 24x7 support, providing DBA support for highly critical business databases.
  • Worked on Data Center Migration for all Production and non-Production oracle databases for OLTP.
  • Experienced in database trouble shooting the production database issue/problem and Performance Tuning.
  • Experienced in RMAN backup. Plan best Backup strategies for all production databases through RMAN. Worked on and lead DR(Disaster Recovery) drills/tests.
  • Experienced on Oracle software INSTALLATION, New DATABASE CREATION and CONFIGARTION as per customer requirements.
  • Experienced on DATABASE UPGRADE from oracle lower version to higher versions.
  • Experienced on PATCHING. Responsible for Patching all Oracle software binaries to meet the compliance requirements. Support and represent from DBA team for yearly Auditing.
  • Experienced on High Availability DATA GUARD, RAC(Real Application Clusters), GoldenGate, attunity replicate, ASM, Oracle Enterprise Manager(OEM).
  • In the current role I have been involved in planning and organizing database projects to achieve specific goals. Collaborated with implementation managers, development and quality control teams with other engineers to drive guidelines, methodologies, documentation and implementation.
  • Driven continuous improvement, may include design, definition of roadmaps, standardization of processes and methodologies. Work with business management team for forecasting and aligning with plans for database for new upcoming projects.
  • Delivered projects as per ITIL practices like resource management, capacity management, incident management and problem management for IT service management and focused on aligning IT services with the needs of business.
  • Supported and maintained Production and Non-Production Oracle databases of various OLTP applications in various industries like Banking, Healthcare, Telecom, Life science, Insurance and Financial and Service Industry.
  • Experienced on Oracle Database Migrations. Extensively worked on Data Center Migration for all Production and non-Production oracle databases. Migrated OLTP databases and Data Warehouse databases to different data center as per customer need.
  • Planning and implementing DATA REPLICATION methods from Primary site to DR site using Data Guard, Golden Gate, Aync and Attunity replicate.
  • Experienced on implementing Physical Standby databases using Oracle DATA GUARD feature for High Availability configuration.
  • Experience on ATTUNITY REPLICATE tool for oracle. Worked on implementing Attunity Replicate software, Configured Replication jobs between OLTP databases and data warehouse databases across different data centers.
  • Performing and support daily operational tasks and support Application team for data refresh from Production to Development and QA/UAT.
  • Responsible for setting up of databases for Development and QA environment. Refresh and RMAN CLONING of databases. Database logical data Refresh through oracle Data Pump for Export and Import data.
  • Experienced in Physical Database Design and Implementation, Capacity Planning, Performance Trending, Disaster recovery planning.
  • Responsible for Release and Implementation cycle for Implementing and Deploying database changes for applications.
  • Install/configure required tools OEM (Oracle Enterprise Manager), TOAD, SQL developer and client specific Datapoint tools in customer systems as per customer requirements.
  • Co-ordinate with customer/development/QA teams to handle and implement new conversion projects. Responsible for creating UAT environments for state customer testing before conversion Go-Live. Plan/design and configure new production databases.
  • Automated Refresh jobs that run weekly and monthly as per application team requirements and the state User Acceptance test databases.
  • Responsible for plan and create required users, schemas, application specific roles and profiles, objects, sizing of databases, space management and monitoring database health through centralized database through OEM and corn jobs through shell scripts.
  • Responsible for Disaster Recovery (DR) drills/tests.Co-ordinate with different teams and completely successful of all DR tests. Work with Storage team, NetEngg team, Unix administration team for capacity planning of SAN storage requirement/addition for databases servers.
  • Proactive monitoring system resources, understanding and understanding and troubleshooting database issues in Production Staging Environment. Support Application team from database and assist Operations team, application/QA teams for any database related assistance and co-ordinate for change and release implementation. Responsible for representing DBA team in CCB(Change Control Board) meetings. Involve and co-ordinate with change/release implementation team for reviewing and involved in decision making on database changes. Responsible for reviewing and execution of db scripts in production environment submitted by application team as per implementation process.
  • Primary database point of contact for Net Backup Upgrades. Co-ordinate with Tape backup team for regular backups of databases. Set up databases and backups in lab to test and measure different backup and recovery scenarios. Responsible for database Clone thr’ RMAN.
  • Ability to work collaboratively with other departments to resolve issues with solutions and ability to prioritize a work load and meet project deadlines.
  • Worked with middle ware administration team to trouble shoot Apache-TomCat and WebLogic issues and support/provide DBA support.
  • Willing to work on new technologies like Cloud technology AWS, Oracle Cloud and willing to adopt new generation technologies to contribute to achieve company’s expectations and targets.
  • Good team player with good communication, written and presentation skills with strong aptitude towards learning new technologies.
  • Worked/experienced on Oncall support 24/7 thus providing database support for mission critical production databases.

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g and 12c

Operating Systems: Linux - Red Hat, Solaris, IBM-AIX Power systems, Windows - NT/2003/XP and Confidential -UNIX

Tools: Oracle Enterprise Manager, TOAD, SQL Navigator, Ontarget, DataPoint, Confidential Open View

Domain: Telecom, Banking, Insurance, Financial and Service Industry

EMPLOYMENT HISTORY:

Confidential, Austin, TX

Oracle Sr Database Administrator

Responsibilities:

  • Responsible for highly critical Oracle databases for EPPIC payment process DBA support and responsible for presenting project status updates to internal stake holders and customer periodically.
  • Infrastructure designing of databases for Disaster Recovery, High- Availability and database Reliability. Also planning and implementing design changes and representing DBA team for Release and Change management.
  • Responsible of database administration activities to keep up the health and improve database performance and also database upgrade and patching to keep the highly critical databases up to the newer versions of oracle.
  • Responsible for OEM configuration for all highly critical production databases.
  • Responsible for End to End Installation and implementation of Oracle Enterprise Manager version 12c.
  • Responsible to Database Capacity planning in co-ordination with storage teams, Plan best backup strategies for database backups to secure data through RMAN.
  • Database Reliability and Performance basically, designing scalable database interfaces to enable efficient user access to data with load-balancing processes.
  • Make sure Data Replication between production and DR sites are in Sync and up to date. Implemented Oracle Data Guard. Client specific ASYNC for data replication. Used Oracle Golden Gate to replicate data between databases for highly critical databases.
  • Experience on Attunity Replicate software for oracle. Worked on implementing Attunity Replicate software, Configured Replication jobs between Production OLTP databases and data warehouse databases across different data centers.
  • Responsible for Data Replication from Transaction Applications to Data Warehouse Databases.
  • Installation of Attunity Replicate softwares on both Production and UAT environment.
  • Configure Replication Jobs in Attunity for data syncup from Primary Databases to Data Warehouse databases.
  • Implemented & configured more than 70 replication Jobs both for Master tables & Transaction tables data sync.
  • Database Security included maintaining the physical and virtual security of databases is generally more in the purview of database administrators, analyzing the security needs of the organization. Interact with customer management to understand the project forecast and plan.
  • Extensively worked on data center Migration. Migrated OLTP databases and Data Warehouse databases to different data center as per customer need.
  • Co-ordinate with customer/development/QA teams to handle and implement new conversion projects. Responsible for creating UAT environments for state customer testing before conversion Go-Live. Plan/design and configure new production databases.
  • Responsible for Oracle database Installations, Physical Standby Oracle Data Guard configuration, Implementing Data replication thr’ Golden gate and Async, configuring RAC database and administration of all highly critical databases.
  • Setting up of databases for Development and QA environment. Refresh and CLONING of databases with RMAN.
  • Database Refresh through oracle Data Pump for Export and Import data.
  • Automated Refresh jobs that run weekly and monthly as per application team requirements and the state User Acceptance test databases.
  • Responsible for database UPGRADE and Patching. Responsible for plan and create required users, schemas, application specific roles and profiles, objects, sizing of databases, space management and monitoring database health through centralized database through OEM and corn jobs through shell scripts.
  • Co-ordinate with infrastructure teams/engineers like Storage teams, Network Engineering teams, Unix administrators for the support in order to implement and achieve the deadlines within SLAs. Co-ordinate with security team to work towards all the compliance set for databases as per standards and planning of Patch Upgrade of oracle binaries/software.

Environment: Oracle 9i,10g, 11g and 12c, Oracle Enterprise Manager 12c, RMAN, Data Guard, Golden Gate, RAC, ASM, RedHatLinux

Confidential

Oracle DBA

Responsibilities:

  • Proactive Monitoring System Resources, understanding and troubleshooting Database issues in Production Staging Environment.Responsible for planning, installation of oracle binaries, creating and maintaining Production//Dev/Test databases.
  • Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and recovery. Logical backup using and full/ partial export/import and Data Pump for database refresh.
  • Primary database point of contact for Net Backup Upgrades. Co-ordinate with Tape backup team for regular backups of databases. Set up databases and backups in lab to test and measure different backup and recovery scenarios. Responsible for database Clone thr’ RMAN.
  • Responsible for Patch upgrade of oracle software and responsible for plan and perform database Upgrades. Co-ordinate with other engineering teams for capacity planning and databases migrations.
  • Co-ordinate with application team/programmers and the release management team for identifying the issues and responsible for implementing the changes in new database environment.
  • Setup of databases for Development and QA environment. Refresh and CLONING of databases with RMAN.
  • Database Refresh through oracle Data Pump for Export and Import data.
  • Configured and created Physical standby databases for highly critical databases. Assist Application team to migrate monthly and weekly reports to the reporting database thus reducing load on primary database in order to achieve max utilization of production primary database for the business.
  • Extensively worked on database Migration. Migrated OLTP databases and Data Warehouse databases to different data center as per customer need.

Environment: Oracle 9i,10g, 11g and 12c, Oracle Enterprise Manager, RMAN, Data Guard, ASM, RedHatLinux

Confidential

Oracle DBA -Operations

Responsibilities:

  • Primary responsible was on Database modernization. I was responsible for all the database Upgrades, Patching and Migrations from oracle lower version to higher versions. Represent DBA team for CCB(Change Control Board) for change requests review and approval. Proactive Monitoring System Resources, understanding and troubleshooting Database issues in Production Staging Environment.
  • Along with modernization activities, I was the point of contact to support the Merck Archiving team for the database support. Responsible for application specific schema migrations.
  • Responsible for Capacity planning, coordination with storage and unix administrators and net backup team. Responsible for database migration activities.Co-ordinate with offsite database administrators to plan and implementing the database activities as per customer requirements. Making action plans for smooth performance of the db upgrade and migration and project as per the agree delivery.
  • Successfully migrated standalone production databases from non-ASM to ASM environment. Implemented and configured Physical standby oracle dataguard databases and monitoring standby databases to make sure to sync with production databases.
  • Plan Disaster Recovery(DR) drills/tests.Co-ordinate with different teams & completely successful of all DR tests.

Environment: Oracle 9i,10g, 11g and 12c, Oracle Enterprise Manager, RMAN, Data Guard, Golden Gate, RAC, ASM, RedHatLinux

Confidential

Oracle DBA

Responsibilities:

  • Responsible for Installation, Configuration, Monitoring, Upgrading and Migration of Oracle databases between ORACLE 9i, 10g and 11g databases. Supported and maintained highly critical production and non-production oracle databases of various OLTP environments. Responsible for creating refresh of Dev,UAT and QA databases using oracle datapump for export and import of data as per application and customer requirements.
  • Worked on database MIGRATIONS, UPGRADES and CLONE databases. Plan and configure RMAN backups to secure databases. Responsible for database recovery.
  • Automated data refresh jobs and configured to run on weekly basis to reduce human work hours.
  • Responsible for creating and implementing Physical Standby Oracle Data Guard databases. Manage to make sure the standby databases to make sure to sync with primary production databases.
  • Worked on oracle 11g RAC installation and implementation. Successfully migrated highly critical standalone database to RAC database.
  • Responsible for Disaster Recovery (DR) drills/tests.Co-ordinate with different teams and completely successful of all DR tests. Work with Storage team, NetEngg team, Unix administration team for capacity planning of SAN storage requirement/addition for databases servers.
  • Proactive monitoring system resources, understanding and understanding and troubleshooting database issues in Production Staging Environment. Support Application team from database and assist operations team, application/QA teams for any database related assistance and co-ordinate for change and release implementation. Responsible for representing DBA team in CCB(Change Control Board) meetings. Involve and co-ordinate with change/release implementation team for reviewing and involved in decision making on database changes. Responsible for reviewing and execution of db scripts in production environment submitted by application team as per implementation process.
  • Support Unix team for OS upgrade and work with Custom/Application Engineers team for any database support.
  • Responsible for supporting production databases for Oncall support 24*7 providing remote DBA support for all database administration activities. Along with my daily DBA activities, I was the contact for Operations Maturity (OM) team to support/update on continuous project Improvement Plans, Auditing and conduct Project Monthly Review meetings. Preparation of Volumetric ticket analysis and monitoring the ticket queues to make sure all tickets are resolved within the agreed SLAs.

Environment: Oracle 9i,10g and 11g, Oracle Enterprise Manager, RMAN, Data Guard, Golden Gate, RAC, ASM. AIX and RedHatLinux

Confidential

DBA Consultant

Responsibilities:

  • DBA point of contact for all the database tasks related GINIUS and RIH project for Confidential custom clearing applications. Worked on SourceForge tool and Nexus tool which is used for ticketing system, handle online queries of developers / users and resolving them remotely and providing them solutions.
  • Monitoring and fixing the issues if any with the Daily Jobs and weekly Jobs. Perform database backups and database logical backups. Perform daily activities to monitor health of the database.
  • Space management, sizing the database objects, monitoring file systems and tablespace growth. Create new users, roles and assigning privileges on it, granting the roles to the users, and profiles. Create, allocate and modify database storage structures.
  • Performing database Upgrades from lover version to Oracle 10g. Responsible for oracle database Patching. Plan and creating new production databases for the new applications as per customer requirements. Create Physical standby databases for new projects and managing the physical standby database in sync with the primary database.
  • Co-ordinating with Application team for the execution of scripts in the releases. Responsible for execution of DDL scripts provided by the application team for new Objects creation and Object changes in the releases.

Environment: Oracle 9i,10g and 11g, Oracle Enterprise Manager, RMAN, Data Guard, RHEL (RedHatLinux), AIX, Windows

Confidential

Oracle DBA

Responsibilities:

  • Implemented Datapoint based alert Monitoring system of over 250+ production databases including script based monitoring for Database, Backups and exports, listeners, Archive log destinations & alert log monitoring thr’ scripts.
  • DBA Point of Contact (POC) for all the tasks related Net - i project for Confidential -Nextel applications. Representing from DBA team for the database Migration activities and successfully completed db migrations of over 40 plus production databases.
  • Extensively worked on oracle database Upgrades to new versions. Worked on Cloning of the databases as per client requests. Plan and creating new production databases, configuring the init.ora parameter file and setting initial parameters.
  • Create, allocate and modify database storage structures. Create users, roles and assigning privileges on it, granting the roles to the users, and profiles. Space management, sizing the database objects, monitoring file systems and tablespace growth. Perform daily activities to monitor health of the database.
  • Generating AWR and StatsPack Reports for study and tuning the database. Handling user-managed backups and RMAN backups based on business requirements and company management demand.
  • Perform data exports and import as per customer need through DataPump. Worked on Oncall for database assistance to take care of databases.
  • Managing the standby database in sync with the primary database. Responsible for creation of Standby databases for required production database as per client requirements. Keep close monitoring with the production and standby database to make sure standby databases are in sync with Primary databases.

Environment: Oracle 9i,10g and 11g, Oracle Enterprise Manager, RMAN, Data Guard, ASM. AIX and RedHatLinux

Hire Now