Oracle Data
Resume:
PROFESSIONAL SUMMARY
*+ years of experience in IT, with exclusive experience as an oracle database administrator in installing, configuring and upgrading Oracle Software 12c/11g/10g/9i on Sun Solaris, OEL, RHEL, IBM-AIX, HP-UX and Windows Platforms
Provide day-to-day, hands-on technical support of Oracle based production and development systems running on various platforms.
Coordinated development and deployment activities very well with project teams and contributed heavily in pre and post deployment stabilization.
Good experience in taking Hot/Cold backups, Import/Export and Cloning of databases.
Experience in taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
Performed Database refresh from production to pre-prod, development and testing environments.
Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
Thorough knowledge in fulfilling DBA daily activities in schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
Supported back-end databases for applications developed using IBM WebSphere Application Server, IBM Data Stage, Informatica, SAP BOBJ Data Integrator, Xcelsius and Qlikview with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
Solid experience in database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
Have good knowledge and experience in designing database schemas per business requirements.
Proficient in Index rebuilding and Index tuning.
Good understanding of database block corruption.
Experience managing production OLTP and OLAP database.
Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing at different levels.
Experience in troubleshooting and resolving problems during the regular maintenance of Oracle database.
Installation, Upgrade and Configuration of Oracle 11g/12c
Excellent experience in configuring and tuning of Oracle 10g/11g RAC, Data guard and ASM for high availability of database.
Sound knowledge in installing Oracle security patches.
Possesses excellent analytical, problem-solving and learning skills as well as a keen interest in the emerging technologies.
Good written and verbal communication skills, self-motivated team player and good analytical thinking.
Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
TECHNICAL EXPERTISE
Operating systems
All UNIX Flavors, Red Hat LINUX, SOLARIS, Windows Advanced Servers 2003/2005.
Databases
Oracle 12c, 11gR2, 10gR2, 11g RAC and Oracle 9i
Tools & Utilities
SQL*Loader, OEM, SQL Developer, Grid Control, Putty, Export/Import, Data Guard, AWR,ADDM, Data Pump, RMAN,ASM, Toad, SCP, FTP, TKPROF, GoldenGate,
Languages
C, Unix shell scripts, SQL, PL/SQL
Protocols
HTTP, TCP/IP, FTP, SFTP, SSH, TELNET
WORK EXPERIENCE
Ford, Michigan MI Oct 2015 - Till date
Role: Sr. Oracle DBA
Description:
Ford’s IT team delivers a wide range of technical solutions to power the business, from large enterprise data centers to mobile apps. The databases covered more than 400 companies with daily frequency of data which consisted of data collected by Ford Equity Research and The data also include select fundamental data as well as standard financial metrics. As a part of service delivery team taking care of database integrity and worked towards avoiding any unscheduled downtime.
Responsibilities:
Responsible for Oracle 11gR2 installation, configuration the application, responsible to install, create database.
Installation and configuration of Oracle RDBMS 11gR2 on Oracle Enterprise Linux.
Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager Grid Control, monitor users, tablespaces, memory structures, rollback segments, logs and alerts.
Involved in Golden Gate installation, configuration and testing on Dev and Test environments.
Experience in fulfilling DBA daily activities, including schema management, user management (creating users, privileges, roles, quotas, tables, indexes, and sequence), monitoring, scheduling jobs, UNIX Shell Scripting. Performance tuning which includes creating indexes, analyze tables and indexes, explain plan.
Managing, troubleshooting and resolving oracle database and applications issues.
Recovery of Database using oracle recovery manager RMAN (Performed full recovery and point in timerecovery).
Responsible to monitor database performance using AWR, ASH and ADDM using Oracle Enterprise Manager Database and Grid Control, generated reports as needed.
Extensively used Toad, Remedy, SQL developer to manage and maintain oracle databases.
Experienced in creating duplicate databases using RMAN.
Performed applying latest Oracle patches and security patches for Oracle databases.
Creating and Managing tablespaces, roles, quotas & tables.
Responsible to develop UNIX shell scripts to automate support tasks.
Responsible for network configuration and involved in a Client-Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
Enhancement of the existing PL/SQL objects like Procedures, Functions, Packages, views, materialized views.
Database & Instance configuration using Grid control.
Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments and ADDM, ASMM, etc.
Environment: Oracle 11g and 10g, RAC, OEM, RMAN, DBCA, Data Guard, TOAD 12.1, UNIX, OEL, RHEL, AIX, Windows XP, ASM, RMAN, Golden Gate.
Capital One, Virginia VA
Role: Oracle DBA Aug 2014 - Sept 2015
Description:
Capital One’s Technology department provides scalable infrastructure for our entire enterprise managing both internal and customer-facing technology. Currently, it is putting in place an “Always On” infrastructure. The exciting innovations will connect the business units and create a seamless experience for customers.
Responsibilities:
Installation, configuration, and maintenance of Oracle 11g/12c on RHEL 4.5 and 11g on RHEL 5
Responsible for setup and implementation of 2 and 4 RAC on Oracle 11g
Configured ASM with high redundancy for high availability
Creating and maintaining Databases manually as well as using DBCA
Implemented and managed Oracle Data Guard on Oracle 11g.
Upgrading the Oracle 10g to the latest Oracle 11g Release 2 .
Monitoring of Oracle Instances, Users, Tables, Tablespaces, Memory Structures, Rollback Segments, Redo Logs, Archive Logs and Alert
Creation of users and granting the users required privileges and roles
Involvement in space management, rectification of lock problems, managed quotas
Configuration of Listener and Net Service names using NETCA .
Managing backup strategy for all production databases
Provide at least double redundancy for all development databases
Database backup & Recovery for non-archive and archive database with RMAN commands
Used ETL(SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
Creation, managing and monitoring of database objects like Tables, Indexes, Views, Tablespaces, Undo Tablespaces
Used Data pump for exporting and importing tables, schemas and table spaces
Implemented Data Guard on production database
Develop and enforce both database and OS-level security policies for data protection
Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting
Managed more than 4 databases using OEM Grid Control
Rollback segment creation and assignment for transaction as per departmental requirement for process
Hands on experience working on High Availability Environments
Responsible for auditing tables using Triggers
Post installation process, kernel upgrade, applying support packs and add-ons
Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, Data Pump, FLASHBACK and RMAN
Cloning databases with RMAN and also with user managed
Loading of external tables into Oracle using SQL loader
Scheduling the databases backup using Crontab
Monitored database and tuned performance using OEM and STATSPACK
Environment: Oracle 12c, 11g and 10g with RAC and ASM, ORACLE 9i, SQL, PL/SQL, Toad, CRONTAB, O/S: RHEL 4.2, Windows 2003 with Active Directory, Oracle Enterprise Manager (OEM), RMAN, Export/Import, ASM Packages
AstraZeneca, Wilmington, DE
Role: Senior Systems Executive Nov 2012- Aug 2014
Description:
AstraZeneca is a global, science-led biopharmaceutical business and our innovative medicines are used by millions of patients worldwide. The DBA will work in and help manage a complex Oracle production pre-production testing and development environment. This environment consists of Oracle databases. Oracle DBA ensures database integrity and works towards avoiding any unscheduled downtime, which may affect the business continuity.
Responsibilities:
Installation, Upgrade and Configuration of Oracle 11g/12c
Installed and configured RMAN for 11g
Oracle DBA production support on Solaris, Linux, HP. Mostly physical database tuning and Housekeeping Actives.
Migration of different applications from development database to test database and then to production database
Defragmentation of database using export import
Table Partitioning, Creating Index Organized tables, locally managed tablespaces, undo tablespaces, data objects, setting privileges, indexes, user logins, passwords (security)
Writing scripts for backup and recovery, Import and export procedure
Set up Standby database, implemented and administered Data Guard for higher availability and Disaster recovery
Setup common archiving, nightly exports and backups, recovery procedures and strategies for 24x7 availability using RMAN hot backups
Deciding the naming conventions of data file, redo log files, table spaces, and segments
Writing scripts for backup and recovery, Import and export procedure
Unix Shell scripting for automating startup/shutdown of databases
Setting up new environments (Development, Production etc)
Scripting of Backup and recovery policy and procedure for Oracle database
Refreshing the Test or QA environment with Production data
Automate routine the task through shell scripts
Performance and tuning of Oracle Databases
Backups and recovery through RMAN or Export & Import
Using of Toad software tool
Experience in installation and configuration of Oracle Golden gate
Used Crontab to schedule jobs and to automate many DBA tasks
Extensively used Oracle Enterprise Manager to do the daily tasks.
Environment: Oracle 10g/11g, RAC, ASM, RMAN, Data Guard, OEM, TOAD, UNIX, Linux 4.0 & 5, Sun Solaris 5.9/5.10, Windows XP.
Active Brains Pvt. Ltd., Hyderabad, India
Role: Oracle DBA June 2010 - Oct2012
Description:
Active Brains is passionate to deliver reliable, consistent, cost effective, high quality, breakthrough solutions & services along with a wide range of innovative, customized, upbeat solutions and services in areas of web based solutions to manage IT Services and Applications to businesses around the globe.
Responsibilities:
Managed security patched installation on Oracle 10g R2
Planning and implementing DR & high availability solutions using Oracle 10g Standby Database using Oracle Data guard
Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities
Contributed in the logical and physical database design as per client requirements.
Created and managed database objects such as tables, indexes, partition tables and views as well as managed the database refresh process from production to non-production environments
Maintaining and troubleshooting oracle network files like listener, tnsnames.ora and sqlnet.ora
Gained good knowledge on SCAN listeners
Creating and managing users, roles, privileges, profiles, schemas
Managing tablespaces and undo tablespaces
Modified the Parameter file (init.ora) as per the requirement needs
Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating database, DBUA (Database Upgrade Assistant) for Upgrading database and NETCA (Network Configuration Assistant) for creating Client-Server environment using Listener, TNS names etc.
Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped
Developed Scripts for transferring data from production server to testing/development servers
Provided 24/7 on-call production database support
Monitored database performance on a daily basis. Heavily involved in SQL tuning and database tuning based on reports generated by SQL Trace, TKPROF Reports, STATSPACK
Managed data in SAN with hands on involvement in Automatic Storage Management (ASM)
Environment: Oracle 9i/10g, RMAN, Data Guard, OEM, TOAD, UNIX, Linux 4.0, Sun Solaris 5.9/5.10, Windows XP
Pennywise Solutions, Hyderabad, India
Role: Jr. Oracle DBA May 2008 - Jun 2010
Description:
PennyWise Solutions is a full service digital and software solutions provider with in-depth understanding of Social, Mobile, Analytics and Cloud (SMAC) to deliver integrated digital solutions.
Responsibilities:
Collaborated with application developers for tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
Coded procedures using PL/SQL language
Day to Day DBA Operations management
Resolved On–Call issues
Task included Monitoring, Ticket resolution and Work/ Change requests
Archived the SLA defied by client
Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces
Database monitored using scripts
Troubleshooting and performance tuning of Databases
Performed data migration as a part of enterprise data warehouse project.
Upgrades of databases (8.1.7 to 9.2.0.5)
Database size ranging from 20 GB to 80 GB
Environment: Oracle 9i, RMAN, Data Guard, UNIX, Linux 4.0 & 5, Sun Solaris
Contact this candidate