We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

San Francisco, CA

PROFESSIONAL SUMMARY:

  • 12+ years of experience as an Oracle Database Administrator having hands on experience in Production Support, Installation, Configuration, Upgrades, Patching, Performance Tuning, RMAN Backup and Recovery, ASM/RAC Administration, Golden Gate Replication, Cloning, Space management, Database Security, Auditing, Shareplex Replication, BCV Splits (EMC Snapshots, Backups & Recovery).
  • Progressive experience in Oracle database Design and Architect. Proven track record of providing strategic direction while deploying tactical technical solutions. Exceptional analytical and problem solving skills. Excellent ability to look at problems from a macro level and a detailed level, always keeping the appropriate business prospective.
  • Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g, 11g, 12c and 11g RAC and standalone in UNIX/LINUX and Windows 2008/2012 R2 environment.
  • Duties included Installation, Patching, Upgrading, Performance Tuning, Space allocation and Maintaining Oracle Server according to Oracle OFA Standards.
  • Work with application teams closely to implement the standard and best practices for Netezza database.
  • Hands on experience in Node Addition and Deletion on RAC databases
  • Experience in implementing Bi - directional data replication configuration using Oracle Golden Gate.
  • Expert with Data Guard, creation of Physical standby and resolving the gaps between primary and physical standby databases.
  • Good experience in working with Data Replication tools Oracle Streams, Materialized Views, Data Guard, and Golden Gate & Shareplex.
  • Configured Zero-Downtime Migration Replication using Oracle Golden Gate.
  • Excellent experience in executing ETL scripts that populate FACTS databases from external sources.
  • Good hands on experience and working on oracle 10g/11g/12c RAC, ASM, Data Guard and Oracle 12c OEM, Oracle 12c Transparent Data Encryption .
  • Worked on Data Mapping, Data Selection/Filtering and Data Transformation using Oracle Golden Gate.
  • Implemented Advanced Data Conflict Resolution methods using Oracle Golden Gate.
  • Worked (VLDB) Very Large Databases such as multi-terabyte Databases.
  • Good hands on experience in working on Flashback &Database Optimization techniques.
  • Active participation in Data Centre Migration.
  • Hands-on experience in Planning & Designing Oracle Backups and Recovery strategies like RMAN, export/import, Data pump, Hot/Cold Backup &Logical &Physical Backup.
  • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.
  • Experience on Netezza Mako appliances, Hands-on with Netezza replication 1.6 or later.
  • Regularly attending project meetings and provide management with statuses and updates on projects and assignments.
  • Performed Data file recovery from logical and physical block corruptions
  • Good understanding and Implementation expertise in RAC, ASM, Data Guard, Oracle DB security & Data masking like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.
  • Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability.
  • Good Experience in Monitoring the databases to ensure maximum database availability
  • Installing, Configuring, Administering, Cloning, Patching, Upgrading and Migrating the Oracle Technologies Database Products on Unix, AIX, Sun Solaris SPARC, Linux, Cent OS and Windows server family.
  • Work with Architect and planning teams to identify right technology investments and technical Architectural upgrades
  • Hands on experience with Switchover/Failover activities.
  • Expert in Support and Maintenance, Shell scripting, database upgrades and enhancements.
  • Hands on experience in migration of databases using Transportable Tablespaces .
  • Conducting Knowledge Sharing and Training sessions to Train staff to perform all aspects of on-going support of the databases.
  • Proficiency in Analytical, Presentation, written and oral Communication and Interpersonal skills.

TECHNICAL SKILLS:

Database Admin: ORACLE 12c,11g,10g/9i

RDBMS: Oracle, Microsoft SQL Server& DB2

High Availability: 10G,11G, RAC, DataGuard, ASM& Oracle Golden Gate

Languages: SQL, PL/SQL, Shell Script, C

Operating System: LINUX (4.x, 5.x, 6.x), Sun Solaris 8/9/10, SuSE Linux Advanced Server, and HP-UX 10/11.x, IBM AIX 5.1, 5.2,5.3 & Windows Server 2003/2008/2012 R2

Development Tools: SQL Developer, Toad, SQL*plus, SQL* Loader, JIRA

Database Tools: SQL*PLUS, TOAD, Putty, OEM (11g& 10g), RMAN, EBU, SQL* LOADER, Export/Import& Data pump (expdp and impdp).

Web Technologies: Html

Ticketing Tools: Remedy, Impact, JIRA & ITSME

Tuning Tools: TKPROF,EXPLAINPLAN,STATSPACK,AWR,ADDM, ASH

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Oracle Database Administrator

Responsibilities:

  • Working on Pre migration activities for OPS(Online Payment Services) and PYD (Payee Directory) databases migration to Exadata
  • Support Online Payment Services for various releases.
  • Supporting Various Failover Test plans on newly created 12c RAC Exadata environment.
  • Working on creating AQ/MQ's for Transfer Scheduling services.
  • Working on replacing the existing CDC streams replication mechanism with Triggers, as it was not supported in Oracle 12c Exadata environment.
  • Working on Alternative solution for AQ/MQ's gateway mechanism.
  • Providing support for SQL Query Tuning and Database Performance issues.
  • Participated in Bill Pay Batch Volume Testing procedures for Batch Services.
  • Working on Planning and Prerequisites for Volume Testing.
  • Monitor and analyse database activity to proactively identify and prevent Potential Performance problems.
  • Monitoring Table space size, resizing Table space, relocating data files for better disk I/O.
  • Creating Privileges, Roles and user Profiles. Granting resources to users.
  • Maintaining 100% SLA compliance with JIRA tickets.
  • Good experience in with the 11g/12c Oracle Enterprise Manager(OEM)
  • Taking AWR reports and analysing them periodically for better performance.
  • Monitoring the Performance of the system and resolving any issues to ensure stable performance.
  • Extensively worked on SQL tuning.
  • Good knowledge in working SQL & PL/SQL procedures, functions and triggers.
  • Extensively worked on database tuning and strong knowledge on using 11g and 12C Optimizers.
  • Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
  • Capturing Performance Metrics during Volume test process.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Baseline and new code run-times in the Batch and Database logs
  • Server-level statistics on both Batch and Database servers (using iostat & vmstat etc)
  • Process-level statistics on both Batch and Database servers using the ps unix command
  • Database-level statistics by enabling a logon trace trigger, which generates the raw database trace files. We use Tkprof to massage the raw db trace files and generate a report that includes Logical I/O's, Comparison of the number of parses to number of executions, SQL statements that do not use bind variables (:variable) & Statements that perform full table scans, multiple disk reads, and exhibit high CPU consumption.
  • Monitoring the critical System parameters and analysing and resolving any issues found during the monitoring.
  • Working on implementing the OPS Volume Testing framework.
  • Monitor the log files on the batch server and the db log table to make sure the jobs within the box progress without any issues

Environment: Oracle 11g&12c, Exadata, Sun OS 5.10, Linux (RHEL 4.x, 5.x 6.x), Toad 10.6, Visio& Shell Scripting.

Confidential, Richardson, TX

Senior Oracle Consultant

Responsibilities:

  • 24X7 production support and on call rotation as per the support roster.
  • Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle Security updates.
  • Involved in database migrations, cloning production system, for testing and development.
  • Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
  • Active participation on Node Addition and Deletion on RAC databases
  • Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Maximum performance mode.
  • Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
  • Working on Oracle 12c Installation, configuration and maintaining the databases
  • Involved in Implementing Oracle Golden Gate between Production databases Active - Active configuration with CDR implementation.
  • Work with application teams closely to implement the standard and best practices for Netezza database.
  • Worked on generating the reports using various Reporting tools.
  • Worked on Hadoop with Cloudera Manager to add services and nodes to the Hadoop cluster.
  • Manually starts and stops the Services in cluster when need.
  • Deploy parcels and packages to the Hadoop cluster using Cloudera Manager.
  • Took responsible for writing Shell scripts, SQL scripts and implementing auto manageable scripts.
  • Working on Space management, User management for smooth running of the databases.
  • Creating users, allocation to appropriate table space quotas with necessary Privileges and Roles for all databases.
  • Having good experience in Hadoop HDFS, HBASE.
  • Restarting and Refreshing the Hadoop cluster using Cloudera Manager.
  • Exploring rich, interactive visuals using Data Visualization on Integrated Cloud Applications.
  • Performed Switchover/Failover activities.
  • Creating the new jobs for report generation, Database monitoring and alert management.
  • Managing archive logs, DB-links, Partitions.
  • As part of daily activity, moving the TB's of data from production to backup system using Transportable Tablespaces.
  • Monitoring Table space size, resizing Table space, relocating data files for better disk I/O.
  • Creating Privileges, Roles and user Profiles. Granting resources to users.
  • Working on installing Oracle Enterprise Manager (OEM) and maintenance of the entire ORACLE 12c environment
  • Extensively worked on RMAN Backup & Recovery scenarios.
  • Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
  • Conducting Knowledge sharing sessions to Team members
  • Regular Team meetings with all the teams to track the progress of the work and issues.
  • Track testing and development progress and document the same. This is to ensure highest quality of solution is delivered using Integrated Test Client
  • Discussing with business entities and other stakeholders to resolve any issues related to the Project.
  • Monitoring the critical System parameters and analysing and resolving any issues found during the monitoring
  • Monitoring the Performance of the system and resolving any issues to ensure stable performance.
  • Good experience in implementing hot, cold and RMAN scheduled backups and Performance Tuning of SQL statements.

Environment: Oracle 11g&12c, Netezza database, Linux (RHEL 4.x, 5.x 6.x), Hadoop, Sun OS 5.8/5.9/5.10, Toad, Cloudera Manager Shell Scripting.

Confidential, Redwood City, CA

Principle Database Administrator

Responsibilities:

  • Involved in 24*7 production support for multiple (1000+) customers Oracle databases.
  • Responsible for Installation, Up-gradation, Migration, Applying Patches, Cloning.
  • Created new Cluster environments, ASM and databases as per the requirements.
  • Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 10g/11gand 12C databases
  • Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration.
  • Configured and deployed the High Availability, disaster recovery solution Data guard Physical Standby database in max-performance mode.
  • Creating Support pages using Oracle Application Express (APEX)
  • Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
  • Responsible for managing production, development & test databases and applications.
  • Extensively worked with export/import and Data Pump utilizes to migrate data from Sun Solaris to AIX
  • Working on designing complex spreadsheets in Excel, and experience in Visual Basic for Applications (VBA)
  • Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth
  • Extensively worked with indexes and table partitioning.
  • Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
  • Planning for storage spaces requirements and placing them for optimum I/O performance.
  • Tuning the databases for optimal performance.
  • Partitioning tables by determining the suitable methodology to improve performance and manageability.
  • Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
  • Provided application support to users and created a log of all the problems with solutions for future reference.
  • Experience in implementing hot, cold and RMAN scheduled backups and Performance tuning of SQL statements.

Environment: Oracle 10g, 11g, 12C, RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux( RHEL 5.x 6.x), Sun OS 5.8/5.9/5.10, Windows 2012 Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, Webster, NY

Senior Oracle Database Administrator

Responsibilities:

  • Handling high availability (24/7) database in onshore-offsite model.
  • Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle security updates.
  • Developing, Testing and Implementing RMAN Backup and Recovery Strategy on various non prod and prod for newly created 11g/10g databases
  • Involved in Implementing Oracle Golden gate between Production databases Active - Active configuration with CDR implementation.
  • Migration of around 2000 Schemas across 65 prod databases to New 5 Node PROD RAC database
  • Working on Database Optimization techniques.
  • Setup the Data Replication configuration using Shareplex tool.
  • Good hands on experience in working with Unified Modelling Language (UML) and Use Cases.
  • Preparing the deployment plans with pre and post installation steps
  • Created replication environments as physical standby for the prod databases using High availability feature Data Guard in Max performance mode.
  • Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Working on Application Lifecycle Management with Visual Studio Team Foundation Server (TFS)
  • Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose’s
  • Working on executing ETL scripts that populate FACTS databases from external sources.
  • Extensively worked with export/import and data pump utilizes to migrate data from Sun Solaris to AIX
  • Working with Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) in SQL Server 2008 with Import/Export Data, Bulk Insert.
  • 24X7 production support and on call rotation
  • Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008
  • Involved in database migrations, cloning production system, for testing and development.
  • Extensively worked with indexes and table partitioning.
  • Experience in Writing shell scripts, SQL scripts and implementing auto manageable scripts.
  • Planning for storage spaces requirements and placing them for optimum I/O performance.
  • Tuning the databases for optimal performance.
  • Partitioning tables by determining the suitable methodology to improve performance and manageability.
  • Implemented custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
  • Provided application support to users and created a log of all the problems with solutions for future reference.
  • Experience in implementing hot, cold and RMAN scheduled backups and performance tuning of SQL statements.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard,Shareplex,TFS, OEM 10g/11g Grid Control,SQL Server 2008 RMAN, AIX OS 5.1,5.2,5.3, Toad, UML, PL/SQL, SQL*Plus.

Confidential, Jersey City, NJ

Senior Oracle Database Administrator

Responsibilities:

  • Handling high availability (24/7) database in onshore-offsite model
  • Handling Performance issues at application level and database level
  • Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
  • Providing support to the data warehouse jobs and tuning queries.
  • Upgrading the databases from 9i to 10g and 11g
  • Installation, configuration and maintenance of standby databases using Dataguard
  • Cloning the Oracle home and upgrades.
  • Creating health monitoring Unix shell scripts
  • Scheduling the health scripts using cron tab, mailx.
  • Working with DB2 utilities for maintenance (Reorgchk/Reorg/Runstats), data movement (Export/Import/Load/Move/Look)
  • Troubleshooting DB2 database issues using db2diag, db2pd, db2dart, db2inspect, db2trace, db2support, db2top, explain plan, db2exfmt and snapshots. Partitioning of huge tables.
  • Working closely with the application teams on scheduling the patching windows.
  • Cloning the databases regularly for the reporting databases and stage environments.
  • Tuning the database level performance issues.
  • Taking AWR reports and analyzing them periodically for better performance.
  • Creating SOX level auditing scripts and making the validations and changes as required.
  • Creating Backup schedules and taking periodic backups both offline and online using RMAN
  • Participating in corporate DR drills and ensuring the data protection.
  • Trouble shooting the application server issues.
  • Defragmentation of the tables using exp/imp, Reorg and shrink
  • Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
  • Creating shift schedules
  • Maintaining stringent response / resolution SLAs.
  • Creating partitions for partitioned tables periodically
  • Managing materialized views and refreshes
  • Creating DB links to heterogeneous environments for the data warehouse
  • Periodic index management, index rebuilding.

Environment: Oracle 11g/10g/9i,DB2 V9.7 RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Linux(RHEL 4.x, 5.x), Sun OS 5.9/5.10,AIX OS 5.1, 5.2, 5.3, Toad, Performance Tuning Shell Scripting, PL/SQL, SQL*Plus.

Confidential, New York, NY

Senior Oracle Database Administrator

Responsibilities:

  • Creating New RAC database as per the requirement.
  • Working on Space management, User management for smooth running of the databases.
  • Refreshing data from prod to lower environments for testing
  • Creating the new jobs for report generation, Database monitoring and alert management.
  • Creating RMAN backup strategies as per the requirements.
  • Creating, adding new disk groups and members to ASM for new databases
  • Resolving user issues immediately and closing the issues on timely manner
  • Monitoring jobs, troubleshooting on failure and addressing alerts
  • Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
  • Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Monitoring table space size, resizing table space, relocating data files for better disk I/O.
  • Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
  • Performed large data loads through SQL*Loader.
  • Managing archive logs, DB-links, partitions.
  • Involved in database schema creations
  • Monitoring the growth of the database to ensure the smooth functionality of daily activities.
  • Performing logical and online backups.
  • Monitor and resize Oracle database objects (table spaces, tables, and indexes).
  • Creating privileges, roles and user profiles. Granting resources to users.
  • Importing of schemas and tables.
  • Plan and implement appropriate backup and recovery strategies for the database.
  • Rebuilding indexes for faster access and to reduce disk I/O.
  • Observing Logs generated every day.

Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential

Oracle Database Administrator

Responsibilities:

  • Checking health systems of Oracle Database.
  • Installed Oracle10g RAC with ASM on Raw devices
  • Handling different database issue and resolving those within SLA.
  • Installed Grid control and maintaining the databases through the Enterprise Grid Control
  • Implemented RMAN backup and tested various recovery scenarios
  • Implemented Backup Policy and Move the backups to the Tape drives at regular intervals
  • Generated the Entity-Relationship diagrams using ERWIN tool
  • User Administration & Security Implementation (Role Based and / Privilege Based)
  • Schema refreshment & Database Up gradation
  • Used Data pump utility
  • Backup & Recovery of database
  • Linux & HP-UX System administration like installing Operating System Patches, Job scheduling, Space management etc
  • Oracle10g Application Server administration
  • Supporting all the Transactional modules on www.portal.gsi.gov.in
  • Creating shell scripts for automating manual jobs
  • Creating and Maintaining the Database & Tuning the database for optimal performance
  • Involved in Oracle database logical and physical Backups
  • Ensure the completion of all daily backups.
  • Monitoring database growth and space management.
  • Checking the alert logs regularly
  • Configuring the database to archive mode
  • Maintaining database security by creating users and profiles
  • Resolving user process error
  • Monitoring Database Performance by Dynamic Performance views.

Environment: Oracle 10g/9i, Toad, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Suse Linux Advanced Server and AIX 5.1/5.2/5.3, TOAD, Performance Tuning, Shell Scripting, PL/SQL, SQL*Plus

Confidential

Oracle Database Administrator

Responsibilities:

  • Creation of New databases as per the requirements for UAT, DEV and Test.
  • Resolving connectivity issues with the database from clients
  • Creating oracle clients on application end
  • Creating new scripts to automate the monitoring jobs for faster response.
  • Scheduling the backups and jobs to maintain the better performance of DB
  • Performing exports and imports based on the application user requests
  • Application trouble shooting with respect to Database issues.
  • Backing up databases.
  • Providing security privileges to developers.
  • Creating and Maintaining the Database & Tuning the database for optimal performance
  • Involved in Oracle database logical and physical Backups
  • Ensure the completion of all daily backups.
  • Monitoring database growth and space management.
  • Checking the alert logs regularly
  • Managing Users and Giving appropriate permission’s.
  • Managing Default Temporary Table space
  • Creating and Managing Table space with Multiple Block Sizes.
  • Involved in database schema creations and writing queries.

Environment: Linux, Windows 2003 server and Oracle 9i, 10G.

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

  • Creating New RAC database as per the requirement.
  • Working on Space management, User management for smooth running of the databases.
  • Refreshing data from prod to lower environments for testing
  • Creating the new jobs for report generation, Database monitoring and alert management.
  • Creating RMAN backup strategies as per the requirements.
  • Creating, adding new disk groups and members to ASM for new databases
  • Resolving user issues immediately and closing the issues on timely manner
  • Monitoring jobs, troubleshooting on failure and addressing alerts
  • Performed heavy data loads using SQL *Loader, Export, Import for backing certain tables.
  • Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Monitoring table space size, resizing table space, relocating data files for better disk I/O.
  • Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
  • Performed large data loads through SQL*Loader.
  • Managing archive logs, DB-links, partitions.
  • Monitor and resize Oracle database objects (table spaces, tables, and indexes).
  • Creating privileges, roles and user profiles. Granting resources to users.
  • Importing of schemas and tables.
  • Plan and implement appropriate backup and recovery strategies for the database.
  • Rebuilding indexes for faster access and to reduce disk I/O.
  • Observing Logs generated every day.

Environment: Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DBArtisan, DataGuard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

  • Installation of oracle9i/10g software on Red hat Linux
  • Managing Users and Giving appropriate permission’s
  • Design & developed table structures, PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security
  • Creating and Managing Table space with Multiple Block Sizes
  • Monitoring the growth of the database to ensure the smooth functionality of daily activities
  • Plan and implement appropriate backup and recovery strategies for the database
  • Monitoring & Tuning Unused Indexes
  • Backup & Recovery of database and General Performance Tuning
  • Linux Operating System Job scheduling, Space management etc
  • Creating and Maintaining the Database & Tuning the database for optimal performance.

Environment: Oracle 9i/10g, Toad,Sun OS 5.8/5.9/5.10, Toad, Shell Scripting, PL/SQL, SQL*Plus.

Hire Now