We provide IT Staff Augmentation Services!

Dba Resume

Denver, CO

SUMMARY:

  • 6+ years of experience in Oracle Database Administration and GoldenGate, Performance DBA, tuning, development, patches, upgrades, migrations, configuration, database security, capacity planning, space management, Exadata, PL/SQL, troubleshooting and documentation.
  • Experience in testing and implementing RMAN scripts in Unix, Linux, Oracle11g.
  • Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments.
  • Experience in Very Large Multi - Terabyte Database (VLDB) and also performed migrations in this environment
  • Worked on Oracle Key vault, wallets and TDE encryption.
  • Participated in a team involving monitoring Exadata hardware.
  • Made effective use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • As a Golden Gate DBA, I am defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems.
  • Participated in team for analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • As a team assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Have good knowledge on logical and physical Data Modeling using normalizing Techniques.
  • Experience in creating Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Worked on Oracle databases in High Availability environments using Failover, Data guard and Cloning technologies.
  • Experience in Database problem resolution, dealing with Oracle, creation of SRs.
  • Performed extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
  • Proficient in migrating database from 11g to 12c by using Scripts and applied patches by Opatch utility.
  • Have hands on experience in using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM.
  • Experienced in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
  • Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
  • Provided 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
  • Expert in Partitioning Administration: creating, managing, purging and merging the partitioned tables.
  • Installed Imperva Agents for database monitoring.
  • Experience in Database creation with RMAN jobs and security implementations in Oracle.
  • Experience in using parameters to configure, install and manage ASM instance in RAC.
  • Experience in monitoring of systems using 12c Grid control.

TECHNICAL SKILLS:

Database: Oracle 12c/11g, RAC 11gr2, 10g, 9i,8i

Languages: SQL, PL/SQL, UNIX

Tools: RMAN, TOAD, Export/Import, OEM, RAC, AWR.

Operating System: Linux, Unix, Exadata machine

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

DBA

Responsibilities:

  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs/Archive logs and regular monitoring of Flash Recovery Area.
  • Migrated databases from version 11.2.0.1.0 to 12.1.2.1.10.
  • Database migration strategy to relocate databases to new Linux, AIX and windows servers.
  • Performed Migration and Upgradation of databases to 12c, 11gR2 and 11gR1.
  • Setup backup and recovery procedures using RMAN/Snapshot backup Mirroring for high volume databases.
  • Implemented Oracle Data guard for maintained oracle disaster recovery.
  • Configured retention period of FRA and RMAN backups.
  • Data migration between environments using expdp/impdp, transportable Tablespace and Oracle Schemas.
  • Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and SQL DEVELOPER and SSMS.
  • Worked with PL/SQL stored procedures and Triggers.
  • Applying upgrade patches, maintenance and interim patches on all the databases.
  • Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
  • Have automated/monitored backup strategies for different databases.
  • Experience in Database design on OLAP databases and maintained database security create and maintain users and roles, assign privileges.
  • Worked closely with application team to reduce any impacts on db level.
  • OEM13c Agents installation to monitor oracle databases.
  • Helped in setting up user accounts, privileges, profiles and roles.
  • Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
  • Database migration strategy to relocate databases to new Linux, AIX and windows servers
  • Configured RAC Physical standby database for RAC primary using ASM filesystem.
  • Performed installation, configuration of oracle server software and its related products.
  • Applying oracle security and patch sets.
  • Setup configuration of oracle RAC environments, and maintenance of oracle RAC databases.

Environment: PL/SQL Developer, Toad, ASM, Data Guard, Oracle 11g/10g, RAC, Oracle 12c, 11gR2, Oracle Streams, SQL*Plus, OEM, Grid Control.

Confidential, St. Louis, MO

Database Administrator

Responsibilities:

  • Performed installation, configuration of oracle server software and its related products.
  • Applying oracle security and patch sets.
  • Setup configuration of oracle RAC environments, and maintenance of oracle RAC databases.
  • Helped in setting up and configuration of OEM12c Cloud control and agent setup for databases monitoring.
  • OEM12c Agents installation to monitor oracle databases.
  • Helped in setting up user accounts, privileges, profiles and roles.
  • Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
  • Configured GoldenGate for extraction and replication of transactional Data Manipulation Language (DML) operations and Data Definition Language (DDL) changes.
  • Full scale Golden Gate implementation experience across different databases such as Oracle, Sybase and MS Sql Server.
  • Setup Golden Gate replication to replicate data across heterogeneous database platforms.
  • Setup and configuration of oracle GoldenGate replication(unidirectional) with conflict detection and resolution. Strong replication experience.

Environment: s: RAC, OEM 12c, Oracle 12c, GoldenGate, Linux, TOAD

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

  • Provided 24x7 production database on-call rotation support as a DBA
  • Manage end-to-end complex data migration, conversion and data modeling.
  • Maintained existing data migration program with occasional upgrades and enhancements.
  • Performed data migration enforcement tasks.
  • Analyzed data structures and movement evaluations.
  • Executed data migration in coordination with management and technical services personnel.
  • Performed source system data analysis in order to manage source to target data mapping.
  • Managed data migration workstream within the established project budgets and advise Project Manager of potential deviation.
  • Worked on installation, configuration, management and upgradation of oracle server software and its related products and applying oracle security and patch sets.
  • Checked with configuration and management of oracle RAC environments, and maintenance of oracle RAC databases.
  • Helped in setting up and configuration of OEM13c Cloud control for databases performance monitoring.
  • OEM13c Agents installation to monitor oracle databases, MySQL databases.
  • Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Involved in capacity planning and space management, setting up and monitoring alert logs for failures, monitoring lack activity.
  • Performed cloning of the primary database schemas, tables and full database level.
  • Created databases on CDB and PDB (12c multitenant) for development, testing and production
  • Took Databases Backup, restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
  • Experience in scripting various Unix Shells, PL/SQL and SQL scripts to monitor the database and system.
  • Maintained backup and recovery policies and procedures and performed periodic recovery tests.
  • Performed fine tuning of databases by tuning memory structures, data dictionary, redo logs and creating appropriate rollback segments.
  • Experienced in Data migrations which include migrating the source from flat file to the Oracle Database using SQL*Loader (control files).
  • Improvised database performance by database tuning and troubleshooting and performance monitoring, tuning of corporate databases, using tools like SQL trace, AWR, ADDM and SQL Tuning.

Environment: WinFTP, VM Ware, TOAD, Oracle 12c, OEM 13c, RMAN, DataGuard.

Confidential

Oracle DBA

Responsibilities:

  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Worked in designing logical and physical data models for star and snowflake schemas using Erwin.
  • Written sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • Upgraded database from 10.2.0.4 to 11.2.0.3 by applying patches using Opatch utility in different environments for latest features and also tested databases.
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Worked on XML along with PL/SQL to develop and modify web forms.
  • Created some Custom reports and Forms for the end users to check the details and errors.
  • Performed creation of database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
  • Meeting with the Client, and working RI Bridges tickets for the data fix scripts.
  • Provided support 24/7 for database systems including performance monitoring, performance tuning, troubleshooting and client support.
  • Worked with Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Worked hands on using the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  • Modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
  • Understood the Architecture by the kind of data modelling and the work flow by executing SQL scripts

Environment: Oracle OEM, Share Point, Jira, Jama, Windows 2010, RHEL 6.0, Pl/Sql Developer, RMAN, Data Guard, UHIP VPN Production Database. Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad.

Confidential

Oracle Database Admin

Responsibilities:

  • In-place Upgrade/Migration of 11g databases to 12c. Performed application tuning and performance monitoring.
  • Backup of database Logical and Physical (hot and cold) procedures and also using RMAN- complete and incomplete recovery of database
  • Interact with oracle through Metalink for ORA-600 Issues.
  • Installed key vault and configured database connections.
  • Created and encrypted new table spaces and dumped data from original table spaces.
  • Worked policies to flag unauthorized logins, monitor activity, generate reports & applied policies in Imperva.
  • Performed SQL query optimization by gathering statistics and by using explain plan.
  • Upgrade and Retirement of Databases/ Applications.
  • Installed and set up 11g RAC and applied TDE Encryption on RAC databases and monitored databases through OEM 12C.
  • Applied patches for the upgrades, bugs recovery, troubleshooting.
  • Maintained standby databases to ensure disaster recovery, high availability & data protection.
  • Coding stored procedures, Packages and functions and well tuning the SQL in the application.
  • Worked on 11g Features: Data Pump, Automatic performance and diagnostics and Flash Back Technology.
  • Responsible for creating tables and indexes, performance monitoring of queries, table space allocations, and data striping.
  • Installed Imperva agents in sniffing mode to track database activity.
  • Worked in a team to create 2- nodes and 3 node RAC environments for development and staging environment with oracle 12c .
  • Writing and maintaining SQL and PL/SQL scripts, complex code deployments.
  • Upgraded database from 9i to 10g for upgraded features.
  • Used RMAN for Cloning of the creating database in test and development environment.
  • Monitoring production systems to establish status and conduct proactive maintenance
  • Ensuring proper online and offline backup and Periodical reading and checking of backups taken.
  • Participate in an On-call rotation with other dba's to provide 24 x 7 coverage and monitoring service now tickets.
  • Documented all Oracle database installations and database operations.

Environment: Oracle 11gr2/12c, IBM-AIX, RMAN, Data pump, PL/SQL, exp/imp, TOAD, SQL*Loader, Imperva, TDE, Key vault.

Hire Now