We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

0/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • 8+ years of experience as an Oracle DBA in very large Production, Test, Design and Development environments in diversified domains
  • Experience in Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Capacity Planning, Backup & Recovery, Disaster Recovery, Performance Tuning.
  • Experience in administration and 24x7 support of Oracle databases, ExaData, Multi Node RAC cluster databases, Confidential .
  • Installations, applying patches and supporting Exadata machines, cell nodes. Used special features of Exadata like smart scan, hybrid columnar compression etc.
  • Configured and build Golden Gate Extracts/Replicats for multiple databases following best practices.
  • Experience in configuration, implementation of Oracle 10g RAC/11g RAC.
  • Experience in Oracle 9i, Oracle 10g, Oracle 11g, OEM 11G, 12C Grid control on AIX platform software installation, PSU Patching and configuration and cloned Oracle Databases for development and testing.
  • Experience in design and implementation of Backup & Recovery procedures and used new features/technologies like BCV Snapshot to optimize system maintenance.
  • Proficient in using Oracle utilities like Export/Import Data Pump, Flashback Recovery, Data Guard, ASM and OEM.
  • Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. tablespaces, rollback segments) and responsible for setting and managing user accounts, granting required privileges to users.
  • Experience in optimization and tuning SQL queries using SQL TRACE, TKPROF, EXPLAIN PLAN, STATS PACK, ADDM, ASH and AWR. Customization and development of Korn shell scripts.
  • Experience in the management of schemas, partitioning the tables & indexes to improve the performance.
  • Proficient in SQL, PL/SQL programming and performing SQL tuning and assist developers with coding PL/SQL.
  • Experience in using RMAN for Backup and Recovery. Experience in designing and implementing Hot, Cold and Logical backup plans.
  • Knowledge on Oracle Support processes for technical requests with Metalink.
  • Result oriented, self - motivated, Team player, ability to work independently.
  • Excellent analytical and problem-solving skills and excellent written and verbal communication skills

TECHNICAL SKILLS

RDBMS: Oracle 12c, 11g R2, 10gR2, 9i, Exadata, SQL Server, MySql

Tools: Confidential, TOAD, Delphix, Shareplex, OEM, Sql Developer

Operating Systems: ODA, Linux, HP-UX, Sun Solaris, AIX and Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python, Go Lang, Java, C.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

Data Modeling: Informatica, Erwin

Other: BCV Snap

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Sr. Oracle DBA

Responsibilities:

  • 24x7 Support to production databases and critical project’s including participating in a weekly on call rotation.
  • Prerequisites, installation, configuration, migrations, upgrades and administration of Oracle database 12c/11g on Linux VM machines and physical servers.
  • Installation, configuration, database creation and supporting of Oracle 12c /11g databases.
  • Installed CPU and one-off standalone patches & patch set update (PSU).
  • Setup encrypting the RMAN backups of production databases using wallet encryption.
  • Implemented Kryptos, converting password based authentication for oracle users to SSL certificate based authentication.
  • Worked extensively with data pump for expdp/impdp and RMAN duplication process for refreshes and creating standby databases.
  • Working experience on upgrading and migration project, Upgraded databases from 11g to 12c.
  • Configured Dataguard using physical standby and active dataguard for high availability and reporting purpose and setup DG Broker configuration.
  • Supported annual DiRT (disaster recovery) exercise on multiple databases with a data center outage. And also supported database failover and switchover situations.
  • Installed SQL Server 2012/2016 and created new database, setup backup and created mirror databases. Supported database switchover from principal to mirror database.
  • Resolved performance issues on sql server database, rebuilt fragmented indexes. Created missing indexes in comparison with other databases.
  • Supported MySql databases, created backup and supported database recovery.
  • Locking/unlocking tables and dropping triggers for migration, supported migration and improved the performance of the oracle databases after migration.
  • Used puppet paltform to automate most of the DBA tasks like schema refreshes, switchovers/failovers, applying psu patches, creating databases, creating restore points, database start/stop, creating awr reports, user account unlock.
  • Created new schemas, constraints, indexes, synonyms, and tablespaces.
  • Created DB links, roles and users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the users with SQL queries, truncating partitions.
  • Involved in discussions with different application teams during the deployments and enhancing the performance.
  • Worked on Customization and development of shell, python scripts to gather statistics, backups, and DB checks.
  • Performance tuning using AWR, ASH, ADDM, Explain plan, Tkprof, Statspack. Perform SQL tuning and assist developers with coding PL/SQL.

Environment: Oracle database 12c, 11g, Oracle 11g RAC, RMAN, DataPump, Linux, VM, SQL Server, MySql

Confidential, Deerfield, IL

Sr. Oracle DBA

Responsibilities:

  • 24x7 Support to production and critical project’s including participating in a weekly on call rotation
  • Prerequisites, Installation, configuration, migrations, Upgrades and administration of Oracle database and Confidential 10g/11g/12c on ODA, AIX, Unix, Sun Solaris servers.
  • Installation, configuration, database creation and supporting of Oracle 10g /11g databases.
  • Migrated production databases from ODA 4-x machine to ODA 5-x machine and migrated databases from ASM to ACFS
  • Installed CPU and One-off standalone patches & patch set Upgrade (PSU).
  • Involved in setting up replication solution with Confidential in Dev, Test and Production environments and configured Confidential Processes on Source, Target and Middleware environments.
  • Configured and build Golden Gate Extracts/replicats for multiple databases following best practices.
  • Configured and build heartbeat monitoring in Golden Gate. Configured error handling for restart, skipping transactions, handling collisions, logging, production support and status reporting in GG.
  • Involved in implementing Confidential writing to a Flat File’s and JMS (Message Queues) along with replication to the tables.
  • Experience in optimization and tuning SQL queries using SQL TRACE, TKPROF, EXPLAIN PLAN, STATS PACK, ADDM, ASH and AWR.
  • Creating New Schemas, Constraints, indexes, synonyms, and tablespaces.
  • Creating DB links, Roles and Users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the Users with SQL queries, truncating partitions.
  • Working experience on Upgrading and Migration project, Upgraded databases from 10g to 11g and 11g to 12c.
  • Configured Data Guard using physical standby and Active dataguard for high availability and reporting purpose. And setup DG Broker configuration.
  • Involved in discussions with different application teams during the deployments and enhancing the performance.
  • Finding long running transactions and recycling the processes which are causing the issue.
  • Worked on Customization and development of Korn shell scripts to monitor statistics, backups, and DB checks.
  • Performance tuning using AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK. Perform SQL tuning and assist developers with coding PL/SQL.
  • Configured Confidential to pump data into Message Queues, XML files. Performance testing of MQ (Message Queues) and work closely with other teams to compare the results.
  • Involved in Hardware/Software upgrades of machines in different environments. Worked on design documents and developing high-level end-end workflow diagrams

Environment: Oracle database 10g, 11g, Confidential, Oracle 11g RAC/ 10g RAC, TOAD, RMAN, DataPump, HP-UX, IBM AIX, Sun Solaris, Linux

Confidential, Denver, CO

Sr. Oracle DBA

Responsibilities:

  • 24x7 Production database administration support of Oracle and Exadata databases.
  • Installed, administered and monitored the Confidential on Oracle, Exadata and Cloud environment replication
  • Highly involved in Performance Tuning issues like Automatic Diagnostics and server health checks, session locks, long running transactions.
  • Raised SR on new issues and worked closely with Oracle Representatives on Oracle Internal/Exception & Core dump errors.
  • Worked on Node evictions, ASM Disk failures, ASM Rebalancing, etc.
  • Worked on Migration project, migrated databases to new servers with 11gR2.
  • Experience in Oracle 9i, and/or 10g databases including patching, upgrades, administration, tuning, backup, recovery and IT Oracle Database Administrator Page 1 of 2 refresh/cloning processes.
  • Installed, configured and administered Oracle Clusterware, Automatic Storage Management (ASM) and created ASM Disk Groups and created Oracle 11g RAC DB’s.
  • Installed and configured Data Guard using physical standby for high availability and also performed Disaster recovery Test on critical environments.
  • Worked on Upgrading databases from 9i to 10g and 10g to 11g.
  • Worked extensively on RMAN, Used RMAN for Point in Time Recovery and for Full DB refreshes and schema level refreshes.
  • Worked extensively with DATA PUMP for expdp/impdp.
  • Worked on shell scripts to monitor statspack snapshots, daily RMAN & Net backups, Confidential monitoring and DB checks.
  • Database cloning to setup test and development database.
  • Involved in sizing & capacity planning for databases based on the future business growth requirements.
  • Logical & Physical database design
  • Responsible for optimizing the queries and application tuning.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Creating New Schemas, Constraints, index’s, synonyms, tablespaces.
  • Creating DB links, Roles and Users, assigning grants/roles, index rebuilding, recompiling invalid objects, Stop/Start RAC DB Stack’s, helping the Users with SQL queries, truncating partitions
  • Performance tuning using AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK.
  • Involved in Capacity Planning for databases based on the future business growth requirements.

Environment: Oracle ExaData, Confidential, Oracle 11g RAC/ 10g RAC, Informatica, TOAD, RMAN, SQL*Loader, DataPump, HP-UX, IBM AIX, Sun Solaris, RedHat Linux, Windows

Confidential, Denver, CO

Oracle DBA

Responsibilities:

  • 24x7 Production database administration support of Oracle and Exadata databases.
  • Installed, administered and monitored the Shareplex on Oracle, Exadata and Cloud environment replication
  • Highly involved in Performance Tuning issues like Automatic Diagnostics and server health checks, session locks, long running transactions.
  • Raised SR on new issues and worked closely with Oracle Representatives on Oracle Internal/Exception & Core dump errors.
  • Worked on Node evictions, ASM Disk failures, ASM Rebalancing, etc.
  • Worked on Migration project, migrated databases to new servers with 11gR2.
  • Installed, configured and administered Oracle Clusterware, Automatic Storage Management (ASM) and created ASM Disk Groups and created Oracle 11g RAC DB’s.
  • Installed and configured Data Guard using physical standby for high availability and also performed Disaster recovery Test on critical environments.
  • Worked on Upgrading databases from 9i to 10g and 10g to 11g.
  • Worked extensively on RMAN, Used RMAN for Point in Time Recovery and for Full DB refreshes and schema level refreshes.
  • Worked extensively with DATA PUMP for expdp/impdp.
  • Worked on shell scripts to monitor statspack snapshots, daily RMAN & Net backups, Confidential monitoring and DB checks.
  • Database cloning to setup test and development database.
  • Involved in sizing & capacity planning for databases based on the future business growth requirements.
  • Logical & Physical database design
  • Responsible for optimizing the queries and application tuning.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Creating New Schemas, Constraints, index’s, synonyms, tablespaces.
  • Creating DB links, Roles and Users, assigning grants/roles, index rebuilding, recompiling invalid objects, Stop/Start RAC DB Stack’s, helping the Users with SQL queries, truncating partitions
  • Performance tuning using AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK.
  • Involved in Capacity Planning for databases based on the future business growth requirements.

Environment: Oracle ExaData, Confidential, Oracle 11g RAC/ 10g RAC, Informatica, TOAD, RMAN, SQL*Loader, DataPump, HP-UX, IBM AIX, Sun Solaris, RedHat Linux, Windows

Confidential, Deerfield, IL

Oracle DBA

Responsibilities:

  • 24 X 7 Production database administration, support, monitoring, proactive problem recognition and resolution of database issues.
  • Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, and Oracle Standby.
  • Performed database cloning to setup Test and Development database.
  • Installation and Maintenance of Standby database.
  • Experience in Disaster Recovery Drills, documented database and application validation steps.
  • Conducting sizing & capacity planning for Oracle databases.
  • Upgrading Production and Development databases to Oracle 10g.
  • Installation, Configuration and Administration of Oracle 10g RAC.
  • Applied RDBMS patches, security patches, proactive monitoring of databases and applications.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Responsible for optimizing the queries and application tuning.
  • Provided support to Application Database Administrators in designing the database.
  • Installed and Implemented Backup & Recovery procedures.
  • Used RMAN for backup and recovery and performed backup validations.
  • Implemented Hot, Cold and Logical backup plans.
  • Customization and development of Unix shell scripts.
  • Management of schemas, objects partitioning the tables & indexes.
  • Automation of data load using Korn shell scripting and SQL*Loader.
  • Responsible for setting and managing user accounts, granting required privileges to users.
  • Defining and Implementation of Backup and Recovery strategies
  • Perform other regular DBA activities including space management and performance monitoring.
  • Effective troubleshooting of Performance tuning problems in Oracle database.
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK, AWR report.

Environment: Oracle Database 10g RAC, Oracle 11g, HP-UX, Sun Solaris, Linux, Oracle GRID Control, SQL Navigator, TOAD, RMAN

Confidential, Kansas City, MO

Oracle DBA

Responsibilities:

  • 24x7 Production database administration support.
  • Installation and Configuration of Oracle 10g/11g Database on AIX, Sun Solaris and Linux based systems.
  • Installed, configured and administered Oracle 10g RAC/Oracle 11g RAC
  • Installed, configured and administered Automatic Storage Management (ASM)
  • Administered and managed Production, Test, and Stage and Development databases involving various types of applications.
  • Administered Data Warehousing environments and OLTP applications.
  • Highly involved in performance tuning based on type of applications (data warehousing and OLTP).
  • Monitored and maintained databases with sizes ranging from few hundreds of GB to TB’s .
  • Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.
  • Worked on shell scripts to monitor statistics, backups, and DB checks.
  • Review database environments, such as database settings, monitoring oracle user processes.
  • Working knowledge in Oracle Grid control. Maintaining the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.
  • Upgradation of databases from 9i to 10g, 10g to 11g and 9i to 11g.
  • Partitioned large tables to get the better performance and manageability.
  • Performance tuning using AWR, ADDM, EXPLAINPLAN, TKPROF, STATSPACK.
  • Configured and Monitoring Confidential for Replication of data from source to destination.
  • Involved in Capacity Planning for databases based on the future business growth requirements.

Environment: Oracle 11g RAC/ 10g RAC, Oracle 9i, Grid Control, TOAD, RMAN, RedHat Linux, Sun Solaris 10, AIX 5.3, DB2

We'd love your feedback!