We provide IT Staff Augmentation Services!

Oracle Dba Resume

SUMMARY:

  • 4 Years of experience in oracle Database administration, Maintaining databases, Upgrades, installations, Migrations,CapacityPlanning,DatabaseSecurity,Documentation,Creating databases,4 - Node RAC configuration, Uni-Directional & Bi-Directional Golden Gate replication, DataGuard, Export/Import Datapump, Backup& recovery using RMAN, Performance tuning using AWR reports,OEM12c&OEM13c, plugin installation,Creation of database's MS SQL server's Versions 2005/2008/R2/2012 Creating Stored procedures, Triggers, users, Index, perform all DML & DDL operation.
  • Extensively used Database Administrative tools like Oracle Enterprise Manager OEM12c & OEM 13c, SQL*PLUS, TOAD .
  • Good Hands on Expereince in Installations & configuration of Oracle 11g upgrades to 12c, OEM13c.
  • Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Strong experience in capacity planning, implementing backup and recovery strategy for application and database.
  • Experience in migrating Code, database change management and data management through the various stages in development life cycle
  • Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs
  • Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and Develop Envinorment.
  • Extensive experience with MS SQL SERVER 2016, 2014, 2012, 2008 R2, 2008 and 2005 Versions.
  • Good Experience In MySQL ETL Tool SSIS, SSRS, SSAS .
  • Experience in Upgrading of Databases from 11g to 12c And Configuring the Golden gate on 12c databases
  • Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
  • Experience in installation of Agents on Hosts in both OEM12c & OEM 13c, Database Health checkup & Performance tuning running AWR report taking backups creating users by OEM 13c
  • Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
  • Good work Experience in SQL, PL/SQL, Stored Procedures, Functions, Constraints, Triggers, Indexes, Views, Materialized views, SQL Loader, TOAD.
  • Experience in Migration of Databases from one platform to another platform using export import datapump.
  • Experience in Performance tuning if any cause of Issues by generating AWR reports using sql script & OEM13c.
  • Experience in Creating and maintaining the catalog databases in Order to stores the backup information of the databases an extra copy.
  • Good knowledge of maintaining SQL authenticated and Windows authenticated logins /users and grant proper privilege in MS SQL server’s
  • Worked on databases ranging from 20GB to 5TB and Participated in monthly on-call DBA schedule and attended the conference calls and remediated various issues/tasks which occurred.
  • Extensive experience in performing the Daily health of the database and Capacity planning and genereal routine works regarding the databases.
  • Worked with Core Databases teams,Performance related team, Installations & upgrades teams and almost worked with all Teams present in Envinorment.
  • Good Knowledge in Set up the Uni-Directional & Bi-Directional Replication from source to target Databases .
  • Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN.
  • Converting data files across different platform using RMAN convert, Transportable Tablespace (TTS), Export/Import and Data pump (expdp/impdp).
  • Job scheduling using CRONTAB, at and batch utility at the OS level and Shell Scripting for automating DBA tasks.
  • Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc.)
  • Experience in Cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.
  • Database replication using snapshots, materialized views and advanced Replication methods
  • Good Experience in performing network configuration and involved in a Client-Server environment using, SQLNET, TNS names, LISTENER, Net Configuration Assistance and other configuration files.
  • Proficient in creating and administering users, creating profiles, roles to users granting privileges and administering password for users as desired from administration
  • Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
  • Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure the databases health.
  • Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
  • Expertise in various phases of System Development Life Cycle (SDLC) like analysis, design, Development, testing, implementation and Maintenance.
  • Well trained in managing successful relationships which can influence stakeholders and shares knowledge effectively Hardworking, result oriented good interpersonal and communication skills.
  • Excellent Communication Skills & 24 X 7 Production & Development database support and administration.

TECHNICAL SKILLS:

Operating systems: Linux, Windows XP/2000/NT, UNIX

Databases: ORACLE 10g/11gR1,11gR2,12c, Real Application Cluster, SQL server 2000/2005/2008/ R2

Tools: SQL PLUS, SQL*Loader, Export & Import Utility, Data Pump, RMAN, Data Guard, SQL Navigator, Oracle Reports, MS Office, XML Publisher, SSIS,SSRS,SSAS, Golden Gate,TOAD.OEM13c,OEM12c,RACLanguages: SQL, PL/SQL, Shell Script,T-SQL

Terminal Emulation: Putty, Telnet, FTP,MobaXterm

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

  • Manages and maintains data in all production and non-production databases and replication servers.
  • Maintains security database, generates reports, queries and documenting, Works with project teams to identify database changes needed to implement project
  • Performed Installation, Configuration, Designing, troubleshooting, performance tuning and production.
  • Implemented ASM on RAC. Managing disks and disk groups with ASM.
  • Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Deploying Plug-Ins, Discovering & Monitoring Targets using OEM 13c, Creating Roles and Administrators & Configuring Auditing Framework.
  • Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Stats pack and TKPROF utility. Participate in testing and the development of performance standards.
  • Re-organizing the DB table regularly by removing row migrations and fragmentation Providing the full database dumps and schema/table level dumps to DEV/QA database environments when needed. And also refreshed & migrated full DB using data pump
  • Worked With Core-DBA team Performing all the Authentication Operations creating the Users Giving Permissions, Taking Backups, Scheduling the Backups in Crontab.
  • Performed Manual Backup of the databases using RMAN scripting connecting to the catalog databases.
  • Scheduling the Backup of the databases in MS SQL servers by generating the Maintance plan.
  • Good Experience in setting up a Uni-Directional Golden Gate Replication and Bi-Directional Golden Gate Replication from source database to target database.
  • Good hands on Experience in 4-NODE RAC Configuration with ASK Disk group Creation.
  • Configured and implemented Oracle 11g ACTIVE DATA GUARD for Database Disaster Recovery by using DATA GUARD
  • Migration of the application data from different RDBMS to ORACLE Databases.
  • Migration of databases from non-RAC to RAC environments.
  • Configuration of Multiple Listeners in the server and Net Service Names for the target databases using TNS names, sql net, Listener.ora.
  • Database Backup Scheduling using both OEM 12c & OEM 13c and managing the backups using enterprise manager.
  • Monitor Database Performance by scanning the Oracle Data Dictionaries for each day and know the problem SQLs.
  • Involved in Configuration and maintenance of Standby databases for High availability using Oracle Data Guard for one of critical application at Enterprise level.
  • Created custom services for RAC database for distribution of load across the nodes
  • Datapump Export & Import useage for the Migration of databases from one platform to another platform generation of code from TOAD.
  • Work with development teams to implement change management for custom code migrated into environments.
  • Day to day activity of Monitoring maintenance plans, scheduled jobs and Database health check in SQL Server
  • Resolve help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.

Environment: s: Oracle 11gR2(11.1.0.1,11.1.0.4,12.1.0.1), Troubleshooting DG, SQL server analyzer, Windows XP, SQL*Loader, PL/SQL Developer Import/Export, RMAN, import & Export Data pump, Oracle Flashback, RAC, Golden Gate, Data Guard,TOAD,OEM12c& OEM 13c

Confidential

Oracle DBA

Responsibilities:

  • Responsible for, both manage and support 6 production databases and 15 development/test databases with sizes of databases varying from 50 GB to 550 GB.
  • Perform daily administration support for database backups, performance tuning and monitoring
  • Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
  • Worked with Data pump to take the logical backups of databases.
  • Worked in performing Point in time recovery using RMAN.
  • Resolve help desk tickets as assigned and provide 24-hour on-call support for problem analysis and resolution to system problems on a rotational basis.
  • Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
  • Standby database setup via 10g data guard for database Disaster Recovery.
  • Administration of databases- Physical and logical structures.
  • Export/Import data to/from PROD and Non Production systems as required.
  • Expertise in database backup and recovery management (Hot/Cold, Exp/Imp).
  • Identifying and resolving resource contention issues and monitoring database performance.
  • Troubleshooting based on application team errors
  • Security User Management, Privileges, Role, Auditing, Profiling, Authentication
  • Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
  • Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
  • Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
  • Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
  • Monitoring the data loading jobs and tuning the SQL queries.

Environment:: Environment: SQL*Loader, RMAN, Data Pump, Export, Import, Putty, FTP, Telnet, Windows Server, Linux, VMware, VirtualBox

Hire Now