Oracle Manager
Resume:
Rajasree K
[pic] ***** Muirfield Dr
Odessa, FL-*3556
Email :
********.*********@*****.***
Phone: 813-***-****
Certification ID - SR2767848
As an ETL developer, Oracle SQL developer and Oracle 9i/10g DBA with over 6
years of IT experience. My main area of experience has been in database
administration, testing, creation of custom reports and ETL. My technological
forte is Oracle (SQL, PL/SQL), Oracle RAC, Oracle Streams, Oracle Data Guard,
Oracle Data Integrator (ODI), Informatica, SQL Server 2005/2008, SSIS/SSRS,
COZYROC, MS Access and Microsoft Office products.
Experience Summary
. Over 8 years of experience as Oracle DBA, PL/SQL and ETL developer in
development and production environments.
. Experience in maintaining Oracle 11g RAC on Linux with ASM
. Experienced in SQL Server/Oracle data migration projects
. Experienced in SSIS ETL software, SSRS and SSAS
. Experienced in COZYROC SSIS plugin software for integrating in
Microsoft CRM
. Experienced in Microsoft CRM, Microsoft CRM API's and, Experian QAS
. Ensured Oracle database systems operate efficiently and securely.
. Managed internal databases, from planning and testing stages through
implementation and support.
. In-depth understanding of security and backup procedures to ensure
database integrity.
. Background in developing backup and disaster recovery.
. Excellent Analytical and problem solving skills.
. Excellent knowledge in SQL*Plus, SQL and PL/SQL programming and
development.
. Experience with Sun/Solaris, RedHat/Fedora Linux, and Windows XP and
Windows 2000 environments.
. Experienced in Informatica PowerCenter 8.1.1, PowerCenter Designer,
PowerCenter Repository Manager, PowerCenter Workflow Manager,
PowerCenter Workflow Monitor
. Experienced in SQL Server and MS Access databases
. Experienced in Oracle Data Integrator (ODI) ETL software, Oracle Data
Quality
. Knowledge in ER Studio Data Architect software.
. Knowledge in Crystal Reports 2008 reporting software.
. Knowledge in Netezza Data Warehouse
Professional Certifications
. Oracle Certified Professional (Oracle 9i)
. Oracle Certified Associate (Oracle 9i)
. Certified Pharmacy Technician
Technical Skills
Below is a list of important hardware, software products, tools and methods
that I have worked with.
Databases:
. Oracle 9i, 10g, 11g, SQL Server 2005/2008 and Microsoft Access
Operating Systems
. Windows 2000, Windows NT/XP, UNIX, Linux
Applications/Tools
. SQL*Loader, SQL*Plus, Filezilla, Toad for Oracle, ODBC, RMAN,
Oracle Enterprise Manager, Oracle Net Configuration Assistant,
Oracle Database Configuration Assistant, Migration Tools, Oracle
Real Application Clusters (RAC), Oracle Streams, Golden Gate
Software
. SQL Server Management Studio, SQL Server configuration tools
Languages
. SQL, PL/SQL, RMAN Scripts, Windows Batch Scripts, Unix Shell
Scripts
ETL Tools
. Oracle Data Integrator 11g - ODI
. SSIS, COZYROC
. Informatica PowerCenter 8.1.1
Reporting Tools
. Crystal Reports 2008, SSRS
Job Schedulers
. Control M, Autosys, Oracle Scheduler and SQL Agent
Data Modelling Tools
. ER Studio, Toad Data Modeller, Erwin
Professional Experience
Hewlett and Packard, Enterprise Services
01/2011- Current
Data Engineer III
As an Oracle Application DBA for Con-Way/Menlo Transportation/Logistics
Project
Client: Con-Way Transportation, Menlo Logistics, Portland, Oregon
Con-way Freight is the premier provider of reliable, regional, inter-
regional and nationwide LTL service to customers large and small across our
integrated, single North American network of LTL operating locations. Menlo
Worldwide Logistics is a leading global provider of a wide range of
logistics, transportation management, freight brokerage and supply chain
services with operations in North America and 20 countries on five
continents.
. Responsible for Maintaining Oracle 11g, Oracle 10g/9i Production, UAT
and DEV data bases.
. Responsible for resolving Service Desk tickets, Work Orders and Change
requests related to PROD, UAT and DEV databases using HP Service
Manager 7 software.
. Creating and maintaining Oracle Database objects and Data Security
. Creating and maintaining Oracle users/roles
. Creating and maintaining Oracle Cron jobs for back up, restore,
gathering statistics, rebuilding indexes and checking invalid Oracle
objects.
. Responsible for Tuning SQL queries
. Responsible for monitoring total of around 350 Oracle PROD/TEST/UAT
databases as a part of Oracle DBA group
. Responsible for Oracle DB migrations, Oracle DB version upgrades,
applying patches data refreshing between PROD and UAT environments,
creating AWR/ADDM reports before and after migrations, compiling
invalid objects, Migration SQL tuning issues, troubleshooting user
grant issues. The bigger database migrated successfully is 8TB,
which is very business critical database for client.
Technologies:
Oracle 11g/10g/9i, Toad for Oracle, HP Service Manager 7, Oracle Enter
Manager (OEM) Grid Control, SQL, PL/SQL, UNIX Shell Scripts.
Hewlett and Packard, Enterprise Services
08/2010 - 12/2010
Data Engineer III
As an Oracle DBA and Talend ETL Developer for NJ-CASS Data Conversion
Project,
. Responsible for Maintaining Oracle 11g Mapping and Conversion
databases
. Responsible for Mapping/Data Conversion database backups and restores
. Creating and maintaining Oracle Database objects and Data Security
. Creating and maintaining Oracle users/roles
. Loading and Refreshing Mapping database structures to make in sync
with Source and Target databases
. Responsible for data mapping between NJ Benefits legacy database and
Curam NJ-CASS database
. Responsible for Tuning data loading queries
. Proactively monitoring Oracle databases and provide solutions in
timely manner for any issues arising
Technologies:
Oracle 11g, Toad for Oracle, SQL Developer, Talend Integration Suit
Enterprise Edition, SVN, Curam Version 6.0 Social Enterprise Management,
SQL, PL/SQL, UNIX Shell Scripts.
Hewlett and Packard, Enterprise Services
04/2009 - 07/2010
Svc Info Developer III
As an ODI and SSIS ETL Senior Developer for Florida ELIS Data Conversion
Project,
. Responsible for data mapping between EFS database and ELIS CRM
database
. Responsible for development of Oracle Data Integrator (ODI)
interfaces, Packages, creating and maintaining data sources using ODI
Topology manager.
. Responsible for creating and maintaining Oracle ODI Repositories for
various environments.
. Responsible for writing Oracle Functions and Packages for supporting
conversion process
. Responsible for performance improvements and trouble shooting for
Oracle Conversion process.
. Responsible for developing SSIS Data Flows, Control Flows and Creating
Packages
. Responsible for creating script components using Microsoft CRM API's
for inserting records into CRM Entities. Worked on COZYROC SSIS
plugin software for integrating Microsoft CRM.
. Responsible for creating script components for invoking Experian QAS
address validation API's to validate various source addresses and
contact information.
. Responsible for creating error and control reports for data conversion
process using Microsoft SSRS.
. Responsible for creating data cleansing SQL scenarios
. Created custom Java Code for comparing data cleansing scenario reports
between two different source data loads.
Responsibilities are creating mapping documents for mapping source and
target databases using custom mapping Excel macros. This project is for
converting VPK program legacy data. It's about converting around 8 years
of data to new ELIS Microsoft CRM system from 40 coalition databases.
Responsibilities also include work with DBA's to creating table structures,
column constraints, Oracle functions and PL/SQL routines. Also responsible
for creating ODI models, interfaces and packages for loading target ELIS
database and reporting tables. Apart from ODI responsibilities, I am also
responsible for mentoring ODI to other team members.
After technology stack changes, started using Microsoft SSIS instead of
Oracle ODI. My responsibilities include writing SSIS Data Flows, Control
Flows, Script components and Control packages.
DataZoomers Consulting Inc, Tampa
01/2008 - 03/2009
ETL Developer and Oracle DBA for development environment
. Responsible for maintaining Oracle 9i, Oracle 10g, 11g development
database.
. Responsible for development of Oracle Data Integrator (ODI)
interfaces, Packages, creating and maintaining data sources using ODI
Topology manager.
. Responsible for creating and maintaining Oracle ODI Repositories for
various environments.
. Responsible for development of SQL Query, PL/SQL package, procedure,
function on Oracle 9i database
. Responsible for performance improvements and trouble shooting for
Oracle 9i development database.
. Responsible for creating Oracle database users.
. Responsible for backup and restore of Oracle database using Oracle 9i
DBCA
. Maintaining Oracle backup and restore RMAN scripts
. Maintaining Oracle Security procedures and methods.
. Implemented 3 node Oracle 11gR2 RAC setup on Linux Servers with ASM &
TAF.
Responsibilities are creating ODI models, interfaces and packages for
loading reporting data warehouse from various data sources, which includes
SQL server and flat files. Implementing data quality operations (ODQ) like
cleansing, formatting and checking various constraints before loading into
final reporting warehouse, loading SCD tables.
Apart from ODI responsibilities, I am also responsible for regular Oracle
DBA activities like maintaining Oracle databases, backup, security, user
administration and restore.
Jewelry4us Inc, Tampa, FL
03/2006 - 12/2007
Oracle Database Administrator
. Responsible for Oracle 9i logical and physical database design,
implementation and maintenance on Windows XP for Inventory Management
and Customer Service applications.
. Responsible for migrating data from SQL Server 2005 to Oracle 9i.
. Created new databases and users: set up backups, export, and other
monitoring scripts using RMAN and user managed.
. Implemented database refresh using full export for table level and
full database de fragmentation, resulting in improved performance and
effective space management.
. Managing database security. Design, develop, and implement automated
data backup and restoration procedures. Provide technical support for
database maintenance and disaster recovery
. Identify, recommend, and implement all new database technologies and
Oracle license management.
MedWin Technologies Inc. Jacksonville, FL
02/2005 to 02/2006
Oracle DBA
The Clinical Correspondence project involves the management of patients
information as per the clinicians requirement and to view their basic
information captured using other products like iPM, iCM etc. Patient List
is used to organize patients based on some criteria, which will be decided
by the clinician who uses the application. Patient Search will retrieve
patients based on the search criteria given. Patient Details is a View,
which shows the demographic information, Care Provider and GP associations
of the patient, and other sensitive information based on the user rights
associated with a particular patient.
. Responsible for writing Oracle 9i SQL's and PL/SQL for Patient List,
Patient Search, Patient Details application. Also responsible for
testing the application.
. Responsible for creating new Oracle databases and maintaining them
. Responsible for RMAN Full/Incremental backup and recovery procedures.
. Responsible for Tuning the Oracle databases.
Education
. Bachelor of Science, Kakatiya University, 1997
. Post Graduate Diploma in Computer Applications, 1998
Work Authorization
. US Citizen
Training
. Oracle 9i, Introduction to SQL's
. Oracle 9i, Oracle Fundamentals I (Architecture)
. Oracle 9i, Backup, Recovery & Networking
. Oracle 9i, Performance & Tuning
. Crystal Reports 2008
. Oracle Data Integrator 10g/11g, Oracle Data Quality ETL software
. DataStage 7.5.2 Designer, Director, Administrator
. Informatica PowerCenter 8.1.1, PowerCenter Designer, PowerCenter
Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow
Monitor
. Netezza Data Warehouse Appliance Usage
Contact this candidate