| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PROFESSIONAL SUMMARY:
Oracle, Exadata, IBM, Microsoft Certified Database Administrator, with m ore
than 8 years of Professional IT experience that includes Oracle ExaData
implementation, Architecting Warehouses / ODS, OBIEE Implementation,
Maximum Availability Architecture, Database Consolidation and Virtualization.
Support deployment, configuration and optimization of the Exadata
environment.
Assist the DBA team to incorporate existing monitoring, access, and
access mechanisms into the Exadataenvironments. Provide application
architectural guidance to the development team based on best practices on
Exadata.
Architect and design partition and index strategy for Warehouse
databases on Exadata.
Knowledge in Configuring Single instance and multimode Oracle Real
Application Clusters (RAC), Automatic Storage Management (ASM), Data
guard.
Knowledge of Oracle DBA tasks Installation, Patching, Cloning, and
Upgrade of Oracle Databases.
Knowledgein Backup&Recovery, Disaster Recovery options, Oracle
Recovery Manager (RMAN).
Experience in working with Grid Control and Oracle Enterprise Manager
(OEM). Grid Control for
Experience as On-Call 24x7 production DBA support.
Knowledge in Installing and configuringASM and RAC for high availability
databases.
Knowledge in Oracle Golden Gate installation, configuration, troubleshooting
GG issues
Performed Strategic Planning, Logical and Physical Data Modeling &
Application Tuning.
knowledge in Performance Tuning (I/O, Memory & SQL Tuning etc) by
using tools/utilities by Automated Workload Repository (AWR), Automatic
Database Diagnostics Monitor (ADDM).
knowledge with SQL, PL/SQL coding, stored procedures, triggers,
cursors,packages,UNIXShell Scripting, Indexes, Logical and Physical database
design to implement the business logic.
Knowledge in maintaining Oracle Data Guard like PhysicalStandby
Database and providing critical solutionwith strategic disaster recovery plans with
different recovery procedures and methods.
Skilled in Hot/Cold Backup and Recovery and Cloning of databases using
RMAN.
Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
Cloned Database from Production to Test and Development.
Knowledge inmigration of oracle database to higher version and installing
patches.
Exporting and Importing of dumps using expdp and impdp.
Knowledge of new features in 11gR2, like RAC-One Node and
replicationusingOracle
Golden Gate.
Experience on handling very large database (vldb).
Delivering Oracle Database performance-tuning services for customers with
EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG,
AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle
databases using sqltrace utilities.
Data loading using SQL*LOADER, Logical backups using full export and
DATAPUMP.
TECHNICAL ENVIRONMENT KNOWLEDGE:
OPERATING Sun Solaris 8/9/10, AIX 5.2/5.3/6.1,Red Hat Linux RHEL
SYSTEMS: 7.3/8/9,HP-UX 10.x/11.x and Windows NT/2000/2003.
RDBMS: Oracle 8i/9i/10g/11g, Oracle 10g/11g Real Application
Clusters (RAC), SQLServer2005
LANGUAGE SQL, PL/SQL, C#, C, C++, XML, Shell Scripting.
S:
SOFTWARE/ OEM, DATAGUARD, Recovery Manager (RMAN),
APPLICATIO Datapump, STATSPACK, AWR, TKPROF, ADDM,
NS TOOLS: ERWIN, OWB,VERITAS Backup, DTS, Developer 2000,
SQL Loader, TOAD.
WEB HTML, XML, Discoverer, DBI, BO, crystal reports.
TOOLS/
REPORTIN
G TOOLS:
EDUCATIONAL QUALIFICATIONS:
Dallas Baptist University: Masters in Business Administration 2005-2008
(INFORMATION TECHNOLOGY MANAGEMENT) DALLAS/USA
PROFESSIONAL EXPERIENCE
GE Transportation (GENPACT), ERIE, PennsylvaniaSeptember 2014 till
date
Role : Oracle DBA
General Electronics, (Transportation) is one of the biggest branch in GE
portfolio which manufacture Railway engines and carts. My role as in Exadata
team member is a support role for the Transexadata project. This project
provides the business solution for the GE Transportation business.
Responsibilities:
DBA support as the TransExadata project.
Support Informatica Team and OBEII team, as on Database job request.
Monitoring OEM for DEV, QA, and PROD environment for any incident.
Created PARTIONING of its types like Range, List & Hash by the specific
use.
Extensively worked on Data ware house Query tuning, of views, material
views.
Created materialized views, table partition for Tuned databases.
Created indexes, rebuild indexes and maintained indexes.
Involved in user creation and user access control. Involved in Schema
creation and management.
Used Stats pack, TKPROF utilities for Tuning and analysis.
Involved in session management and monitored the critical wait events in
the database.
Involved In query optimization and using rule based optimizers and cost
based optimizers.
Tuned SQL queries to pull data from data warehouse tables.
Tuned production database performances and was instrumental in SQL
tuning that improved application response.
Verizon, Irving, Texas Aug 2012 Aug2014
Role: Oracle DBA
Verizon Communications Inc. branded as Verizon, is an American broadband and
Tele communications Company and a corporate component of the Dow Jones
Industrial Average. The application we worked on provides the web-based interface
for credit card implementation for its corporate customers. E-statement server
provides the facility for the clients to view their Statements, transaction history,
merchant details, and disputes. It also provides the facility to inquire about the
transactions. Card management modules allow maintaining the accounts i.e.
creating new accounts, modifying the existing accounts etc.
Responsibilities:
Support the deployment, configuration and optimization of the Exadata
environment
Provide assistance to and perform hands-on activities on behalf of the
database administration team to optimally configure the Exadataservers
Assist the DBA team to incorporate existing monitoring, access, and access
mechanisms into the Exadata environments.
Work with the team assisting Implementation, installation and deployment
of Oracle BPMS 11G.
Assist with the creation of automating administrative processes using UNIX
and oracle scripts.
Perform the implementation and migration of tables and other database
objects to Exadata
Provide application architectural guidance to the development team based on
best practices on Exadata
Architect and design partition and index strategy for STAGING, ODS, EDW
and Data Marts on Exadata.
Administration of RAC, configuring and monitoring daily backups,
troubleshooting errors, to improve performance.
Managing Security, User groups and Users by using roles, grants, privileges
and Profiles.
Creating new environments for data loading and manipulation for various
states in the US, according to the specification provided by Century Link.
Assisting the ETL team to improve performance by analyzing SQL
statements, reorganizing database objects and design indexes to improve
response of queries.
Involved in the documentation of every task involved in the recovery issues
or backups.
Setting up and monitoring Cron jobs to schedule database backups with the
help of RMAN scripts and daily night exports.
Monitoring Growth of tables and undertaking necessary re-organization of
tables and indexes as and when required.
Used Explain Plan to monitor the query execution and views to make sure
the operations run without roadblocks.
Troubleshooting Database performance issues using Automated Workload
Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Creation of various database objects including materialized views.
Troubleshooting errors and using the expdp/impdputiliy on a very regular
basis for copying data across schemas.
Running scripts and monitoring the load process to avoid roadblocks in ETL
jobs running for a long duration.
Troubleshooting expdp/impdp errors in a RAC environment , configuring
storage accordingly.
Monitored Database growth and provide Database capacity planning for
applications expansion.
Upgraded from 9.2.0.x to 10.2.0.x.
Performing Database Administration activities like space management, user
and roles administration, schema management, checking alert log of all the
databases.
Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD,
Solaris8, 9.
Edward Jones Financial Corporation TEMPE, AZ Jan
2009 Aug 2012 Role: Oracle DBA
Edward Jones financial services company is one of the largest insurance and
financial services companies in the world, focusing on domestic property and
casualty insurance, life insurance and retirement savings, asset management, and
strategic investments. We combine our wealth management, investment banking
and asset management businesses with our Swiss operations to deliver superior
financial solutions.
Responsibilities:
Work with the team assisting Implementation, installation and
deployment of Oracle BPMS 10G.
Installing Oracle 9i and upgraded it to latest 9i patch set on HP-UX 11.23.
Migrating applications from non-clustered oracle 8i/9i databases to new 10g
RAC Database environments.
Monitoring and supporting Applications using OEM 9i Grid Control.
Configured two node Oracle 9i RAC cluster.
Created PARTIONING of its types like Range, List & Hash by the specific
use.
Implemented Oracle Streams for Replication.
Implemented schema level, table level and bidirectional oracle streams.
Performing Database Administration activities like space management, user
and roles administration, schema management, checking alert log of all the
databases.
Registering Databases to RMAN Catalog.
Planning and scheduling Backups, RMAN, taking Logical Backups.
Managed Export/Import and Datapump.
Installed and configured Oracle GoldenGate and troubleshooting GG issues.
Environment: Oracle Grid Control, Oracle 9i, HP-UX 11.23
SPRINT, Reston, VA Feb2008Dec2009
Role: Oracle DBA
Sprint Nextel offers a comprehensive range of wireless and wire line
communications services bringing the freedom of mobility to consumers,
businesses and government users. Sprint Nextel is widely recognized for
developing, engineering and deploying innovative technologies.
Responsibilities:
Installed 9i, 8i, database
Backup of database.
Wrote control files for SQL * loader to load data into data warehouse.
Provided database related services to their development and QA
environments.
Was actively involved in constant site enhancements along with developers
code and data push between different servers and testing and moving to
production.
Data exports from production and staging databases.
Tuned SQL queries to pull data from data warehouse tables.
Tuned production database performances and was instrumental in SQL
tuning that improved application response.
Wrote SQL scripts for DB monitoring, and online backups.
Implemented database related security measures that proved very effective.
Implemented Oracle Replication to enable database fail over incases of
system or database crash.
Backup and recovery using Cold & Hot and export methods.
Wrote database triggers, functions and procedure by using PL/SQL.
Automated a no. of database related jobs.
Set multiple destinations for archives redo logs for safety.
Environment: Oracle 9i, RHEL 4, WINDOWS Server 2000,
SQL*LOADER, PL/SQL.
Siemens Medical Solutions Irving , TX June2007- January 2008
Role: Oracle DBA
Siemens is often at the forefront in responding to new trends in the healthcare
industry and has built its operations through internal growth, strategic alliances
and mergers and acquisitions. Worked with SEDA SoarianEnterprise Data
Architecture Clinical and Financials.
Responsibilities:
Database Installations, Creations and Upgrades of 8i/9i on Windows
2000/NT
Assuring appropriate backup and recovery procedures to be in place to meet
the Companys requirements.
Worked closely with developers in Designing Schema / tuning PL*SQL/
SQL code
Created materialized views, table partition for Tuned databases.
Created indexes, rebuild indexes and maintained indexes.
Involved in user creation and user access control. Involved in Schema
creation and management.
Performed Database Tuning for Oracle 8i & 9i servers including
reorganization, SGA, kernel, redo log tuning, Rollback tuning.
Implemented automated backup strategy using the UNIX shell script cron
utility.
Used Statspack, TKPROF utilities for Tuning and analysis.
Involved in session management and monitored the critical wait events in
the database.
Involved In query optimization and using rule based optimizers and cost
based optimizers.
Environment: Windows 98/NT/2000, HP-UX, Oracle 8i/9i, Toad V8.0, Net8,
Database Tools/Utilities.
|
