oracle dba consultant

Adeel Shafaat

Location: Dayton, NJ

Number#: 518-***-****

E-mail ID: *****.*******@*****.***

SUMMARY

About 8 years of IT experience working as an Oracle Database Administrator, having hands on experience in Production,

Development, Implementation and Testing of Relational Database Management systems for Business solutions. Proficient in an

assortment of technologies with Oracle Software 11g/10g/9i/8i on Windows, Linux and Unix Environment.

• Performed Database tuning using AWR, ADDM, and ASH Reports.

• Experience in design, implementation and maintenance of business applications as a Database Administrator

of Oracle 12c, 11g, 10g, 9i in an Agile Environment.

• Experience in maintaining very large database up to 10 TB in Data warehouse.

• Performed exchange Partition on large tables to improve performance and storage management.

• Well experienced with schema changes, database design, database reorgs, and migrations between instances,

database upgrades and database tool upgrades.

• Performed Database Backup using RMAN Utility, Data Pump and Traditional Methods.

• SQL*Loader and various other tools to load data in table in various environments.

• Worked on SQL performance and tuning for better response time. Used SQL tracing and TK Prof for analyzing the

query.

• Experience in proactively supporting application teams for any database related requirements, and database

support documentation.

• Perform Data base refresh from production environment to staging and QA.

• Experience of 11 gR2 in RAC Environment.

• Knowledge of SAN, ZFS, and Linux Administration and configuration settings.

• Cloning of database from different Operating Environments using various strategies like HOT, COLD, Logical

and RMAN.

• Responsible and Performed code migration from Dev to Production environment.

• Experience in design & development of applications using ASP.NET, Web Services, C# and VB.NET

technologies.

• Experience using Data grid control for better execution plan.

• Installed patches, and Utilities in oracle database.

• Configured roles and privileges for any user which needed access to application.

• Experience in working with PGP key Encryption and Decryption testing for secure data transfer validation.

• Experience in writing SQL queries, stored procedures, in SQL Server 2005 and SQL Server 2008.

• Very good in BI and Data warehouse – ETL concepts such as data mining, data integration, data cleansing, data

transformation and data governance.

• Providing assistance in logical/physical data modeling using ERWIN, experience of creating PL/SQL Packages,

Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in

Oracle Databases.

• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.

• Have the ability to adapt fast in new technologies and environments.

• Experience in handling and coordinating multiple tasks in team environments and can, has worked individually.

• Achieved best performance and appreciation from many clients for the outstanding performance for

Administration Work.

Experience in writing various Shell / SQL / PL/SQL Scripts for automation and monitoring of databases.

Excellent verbal and written communication skills.

TECHNICAL SKILLS

Database : Oracle 9i, Oracle10g, Oracle 11g, RAC11g, RAC10g, SQL Server 2005, SQL Server 2008, MS

Access 97/2000

: Windows 95/98/NT/XP/2000,Win7,Win8 Windows Server 2000, 2003, Linux, Unix

Operating systems

Languages : SQL, PL/SQL, C#, C++, ASP.NET 3.0, Java, ASP, VB.NET, XML/XSL, CSS, Unix, Linux, Shell

Scripts.

Web : HTML, XML, ASP.net, JavaScript, JSP, Servlets, Web Services, Silverlight, LINQ, WPF, WCF and

Microsoft SharePoint 2010

Tools & Utilities : MS Office, Dreamweaver 3.0, Photoshop 7.0, Flash 5, SnagIt, Beyond Compare, AWR, ADDM,

Export/Import, RMAN,,SQL*Loader, Flashback,Erwin,Goldengate, TKPROF, Toad, OEM, SQL

Developer, Grid Control, Srvctl, Crsctl, Crs

PROFESSIONAL EXPERIENCE

T ROWE Price, New York, NY June, 13 – Current

Oracle DBA Consultant

Description

T. Rowe Price, headquartered in Baltimore, Maryland, is an investment management firm offering individuals and institutions

around the world investment management guidance and expertise. My role as a DBA was to improve performance issues, backup

and recovery procedures, create reports, install patches, tools, and securities for all production environments and non-production

environments.

Responsibilities

• Installation, configuration and upgrading of Oracle Database 11g, 12c and related products to Implement and

maintain database security.

• Validate the Scripts on high CPU Usage, performing analysis, providing solutions on changing execution plan

based on the use of Grid Control.

• Configured Dataguard for disaster recovery procedure using Physical Standby Databases.

• Writing of O/S Shell and Oracle scripts for automation and manual monitoring of databases.

• Meetings with various stake holders related to data issues/concerns with IT, Business User and PMs.

• Created Backup by using RMAN Utility, and export utilities for some of the crucial tables.

• Involved in Daily onshore and offshore meetings for status calls on requirements and performance related issues.

• Setup roles and privileges based on the request.

• Validation after the migration of the code changes for valid and invalid objects.

• Execute jobs in Data stage and monitor those reports on successfully completed.

• Verified on the ETL Jobs for failure reports and rectified the logs reports for reports being process or rejected

based on the business logics.

Configured Automatic Storage Management (ASM) for 11g RAC databases for reducing disk contention and providing

centralized management for Disks.

• Install Patches, and troubleshoot existing patches on production environment on Oracle Linux,

• Refresh Staging Database from the production environment.

• Monitoring and Administrating ORACLE RAC databases on ORACLE 11g, 12c Clusters .

• Cloning Database from different operating system to Linux.

• Created various Database triggers using PL/SQL.

• Experience in managing of schemas, partitioning of the table and Indexes.

• Performing database changes to increase the size when table spaces, data files run out of spaces.

• Verified TDD Document, SIT Results and AMS (Production Team) for various documents before commence of

the project requirements.

• Responsible for Upgrade Health Incentives project, from 11g and 12c Implementation.

• Set up execution plans for different application and related performance issue execution plans have been changed.

• Contributed for database inserts for QA Groups in order for the data not to be tampered for crucial tables.

• Setup/Document Standards and Policies for the installations, upgrades, operational and DBA procedures for

applying vendor/custom patches.

Environment: Oracle 12c, 11g, 10g, RAC 11gR2, Dataguard, ASM, SQL Developer, Windows Server 2003, Windows XP, 7,

App Engine, SQL, Quality Center HP, Microsoft Excel, Snag it, OEM, Microsoft Outlook, Share point, Grid Control,Data

Stage, PL/SQL, Unix, Linux, Shell Script.

Ernst & Young – Secacus, NJ Oct, 11 – June, 13

Oracle DBA Consultant

Description

E&Y is one of the fourth largest financial accounting firms, E&Y Manages thousands of application worldwide in 140 countries

using numerous Technologies. My main role as a DBA is to maintain numerous database backup, good performance,

implementation from 10g to 11g ensuring the applications and the requirements fits E&Y Standards. E&Y uses People Soft

Technologies for HR purpose and ensure proper business logic is evolved with quality assurance.

Responsibilities

• Re-tolled backup and recovery strategy and Evaluate hardware, capacity planning.

• Oracle Standby/Failover Administration.

• Worked with onshore and offshore model.

• Used SQL*Loader Utility to load files into database

• Design of Data Models using Erwin. Worked on designing of Dimensional Data Models.

• Helping Dev team to move database objects from Dev environment to PROD.

• Database Migration across various OS platforms and in between different databases.

• Used Security features such as FGA, Roles and privileges.

• Performing Various Backup methods and Recoveries using RMAN Utility.

• Used Data pump for backup based on certain specification of the requirements.

• Used Flashback utility to restore the erroneously deleted objects.

• Database cloning to setup Test & Development Databases.

• Good understanding of Data warehouse tasks ETL such as data mining, data integration, data cleansing, data

transformation and data governance.

Performed Table, Index Partitions for increased performance and for better storage management.

• Responsible for weekly status report, daily status report, share them with PM and BA for any deliver at risks and

status of the projects.

• Filling documentation for various applications in order to link ALM with TFS.

• Validated data using TOAD and executed various scripts for validation of data.

• Used Business intelligence to test the performance of the reports when new servers were installed.

• Responsible for the GHRDB Feed Views, and execute scripts to ensure the latest record based on business logic is

being pulled from the source tables. It will also to check the performance of the .sqr before hitting the production.

• Supported developers in logical design, SQL-tuning, schema refreshes and code migration.

• Review and tune initialization parameters, memory structures and physical data layout for optimal performance.

• Worked on SSIS Package on executing store procedure to populate data and understand the whole architecture of

the application.

• Worked on ASM on available disk space pertaining to a table space.

• Perform various security protocols of certain application, to improve the performance of the site while the security

is still intact with E&Y Standard.

• Responsible for GHRDB Upgrade project, from 10g and 11g Implementation.

• Held responsible for projects GHRDB, GHRS, HRSSC, Americas Business Intelligence, EY Cache Engine tool

and many other projects.

Environment: Oracle 11g, RAC 11gR2, ASM, XML, SQL*Loader, Grid Control, SQL Server Reporting Service, VPN, Base

Camp, Manage Service Desk Plus, OEM, Q trace,Notepad++,Edit Plus, Unix, Linux, Beyond Compare, SharePoint, Business

Intelligence, HTML,XML,PGP.

INCENTONE – Lyndhurst, NJ May, 11 – Oct.11

Oracle DBA Consultant

Description

Incent one is one of the Insurance provider that enables the use of technology and provides incentives to its partners and Alias,

with solution in maintaining the quality and assurance of their product. The company holds more than 2 million customers and

expected an implementation of BCBS which will add a staggering growth 8 million users to use their products. My role as

Database Administrator provide them efficiency solutions to their clients’ needs in order for the application to run smoothly and

report for any performance related Issues before and after the implementation. Task also included performing daily incremental

backups, and product customization to their needs in the best form possible which is beneficial to both their Clients and

IncentOne itself.

Responsibilities

• Provide solution based on the requirements of the clients to the offshore team in Hyderabad.

• Work with the BA Analyst in end to end solution for the log tickets in relation to product enhancement and

outstanding issues which clients are facing.

• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).

• Provide Support 24x7 Support and Maintenance for more than 40 Oracle database.

• Performed as a daily duty on prioritizing and coordinate DBA Related activities which included cloning of the

database, CPU Patches, upgrades and installations.

• Identify and resolve database performance and communicate them with the Dev team in residing for a solution.

• Monitor, review and resolve CPU, I/O Activity, memory and resource utilization issues using scripted Tools,

OEM, TOAD & PLSQL Developer.

• Code deployment and maintain version control. Perform validation on the new code changes and doesn’t impact

the performance.

• After discussing with the BA and product specialist discuss with the developers and create technical design

document.

• Validation of the file based on the schema referencing to each client.

• Work with the production tickets.

• Created store procedures and script to generate reports based on client requirements.

• Manually generated on risk factors using crystal reports based on automated process failed.

• Presented to the higher management to ensure proper test cases are implemented based on business needs.

• Excel format was also provided to the BA as a standard processes, with the level of effort, severity, screenshots,

and timeframe for any defects found in UAT environment..

• Experience using black boxing and White boxing for reliable output using web services.

• Testing cross browser functionalities and providing SLA rules to support the product.

• Used Firefox for regression testing to ensure it meets the SLA violation.

• Problem analytics and problem solving on missed requirements.

• Provide support to any Defects found in the UAT environment, review the requirements, through each stages of

development, and perform root Analysis at the defect occurrence.

• Keep track of the development life cycle, ensure QA and UAT environment are in sync for any changes occur.

• Work on IIS, report scheduler, and revenues reports.

Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon

requirements.

• Involved in the meeting with the Project Management, TSM, and BA.

• Worked with Error Reporting 2.5, 2.0 using SSIS, ETL, and flat file validations.

• Web service schema based on the HP document which WSE security standards

• Work with the CSM for affidavit forms and the process involved.

• Solved Clients issues provided by the CSM.

• Extracting data using EXDP and IMDP for backup, and move data from different operation systems.

• Year-end process and project plans for multiple clients’ discussion.

• Meeting with the CFO for the development and DBA Related activities in order to meet the deadlines to meet the

budget.

Environment: OEM, IIS, ASM, Oracle Database, XML, Microsoft Application Blocks, SQL Server Reporting Service, Bug

Tracker, J Query,10g Oracle Database, AJAX,SOS, CSS, JavaScript, VPN, Base Camp, Manage Service Desk Plus, Visual

Source Safe, Microsoft Outlook, HTML,XML,PGP.OEM

WEALTH MANAGEMENT SYSTEMS – Pompano Beach, FL Sep 10 – Feb

11

Junior DBA / .Net Developer

Description

WMSI is a financial provider which provides rollovers and technology services. The Project first task is to use an existing

application to have the look and feel of the application using master pages. These Master pages should incorporate different

FSP’s and IRA Providers. Second task was to build the Call Center Application with the existing architecture in another Call

Center Application, worked in the front end and the backend performing DBA related activities. Create store procedures and

provide a smooth functionality in between the pages. Developed numerous security features like PGP key emails and several

other functionalities of the application based on the clients requirements. Third task once the Dev code is pushed to QA, Create

all end to end test cases towards the applications to ensure no backend exceptions or complex store procedures trigger DDL

issues. Once all the three phases are completed Performing DBA Related activities for code migration, backup database for full,

incremental, and performance related issues using various DBA Methodologies tools.

Responsibilities

• Developed ASP.Net Web Forms pages using C#

• Converting files into higher version of the .Net Framework.

• Resolving bug issues when designing the site.

• Used function which used delegates and multithreading.

• Check all the validation controls using boxing and white boxing.

• Used Sql for Backend testing, extracting all the right iterate data.

• Generated Scripts for automated login process, and all the input validations for audits.

• Generated complex queries and match the results against the base to ensure accuracy for the desired result set.

• Merging of the code and perform several regression test on the application.

• Used JavaScript and HTML controls for Client Side validations.

• Implemented Ajax controls to aid in efficiency in the site.

• Worked with UI in enhancing the layout of the front end using XML Schema and CSS style sheet.

• These results are then formulated assigned to the right developer with the details of the error, screenshot and

severity levels if any defects found.

• Performed Use Case analysis of the requirement and plan development iterations.

• Involved in automation testing using QTP and Wrote external library functional using VB scripting to create

common methods for Objects and incorporated changes in Test Scenarios based on changes Requests.

• Created new users and maintain their roles and privileges.

• Developed middle tier and custom controls using C#.

• Developed Master Pages based on the company portfolios.

• Developed pages using CSS, JQuery and JavaScript to incorporate to the look and feel of the site.

• Responsible for maintenance and release of backend business objects.

• Monitored Server events logs, Oracle alert logs

• Daily Health Checkup of the database using AWR, ADDM.

• Taking Periodic Backup of the databases and the software using RMAN.

• Tested the loaded data and documented the errors and reporting.

• Run various Unix Scripts to check the performance related Issues.

Environment: C#, Net 2.0, COM. ADO.Net, IIS, SQL Server 2005,XML, Microsoft Application Blocks, SQL Server Reporting

Service, JQuery, AJAX,SOS, CSS, JavaScript, VPN, Filzilia, Visual Source Safe, HTML, XML, PGP, Oracle

9i,10g,OEM,RMAN,DBCA,Putty,DataPump

AYCO- A Goldman Sachs Company – Albany, NY Jan 09 – Sep 10

Junior DBA

Description

The prominent global financial services company with some 200 million customer accounts in more than 100 countries provides

consumers, corporation, governments, and institutions with a broad range of financial products and services. It involved in

development and database administrative work of Financial Application to best present their client with money saving solution

and retirements plans.

Responsibilities.

• Ensure all the objects are present and work with DBA for some invalid objects.

• Validate the store procedure when failed on running Sql objects.

• Used tools likes SQL Loader to load immense objects

• Improve the performance of the application which slow down the performance during job execution in

coordination

• Used IMDP/EXDP to recover and migrate some of the crucial tables.

• Perform analysis by using the AWR and ASH Report,

• Implemented changes based on the client requirements on an existing server side applications using MVC

architecture in Facets web application framework.

• Developed C# web-based tool for a major client for managing citations & reference thru auto-references saving

time & maintenance cost.

• Created and deployed XML Web Services (WCF) using ASP.net and C#, used them to generate the proxy class

files based on the web services and consumed in web application.

• As part of Phase 1, designed and developed C# web application based on functional requirement specification and

wire frames with ability to research settlement cases based on multiple criteria’s.

• Developed intranet web application in C# and displays sales data vast on query string parameters.

• Understand the flow of the business objects and the architecture of the application.

• Developed Application using Multi-Threading.

• Validation of code making sure malicious characters is not being entered.

• Applied different Validation Controls, from custom to compare validations.

• Applied Ajax extender in providing the ease to fill the form for the client.

• Building SQL queries to generate reports.

• Creating Store Procedure, Triggers, View, roles object. Defined functions and T-SQL.

• Working with the web designers for better look and feel.

• Developed and implemented C# Master pages, user controls, and Ajax callbacks.

• Worked with Director, Client Manager’s and team to implement new requirements and changes.

• Added log support to monitor request status and for troubleshooting errors.

Environment: C#, ASP.Net, MVC, ADO.NET, MS SQL Server 2000, Crystal Reports .Net, LINQ, Visual Source Safe, HTML,

Java Script, Microsoft Visio, CSS, JavaScript, XML, XSLT,WSE, Crystal Reports, MS Visual Studio 2008,WCF

NMT Shipping Service, New York, NY June, 07 – Jan 09

Web developer / DBA Support

Description

The project agenda was the development of a new application for the employees to provide quotes and services to their clients

based on their needs. The project included developing several tasks in entering data into the application which include weight,

length and width of the car. Based on this information a quote is deployed to the Employee then this information is given to the

client. Second task of the project once the client confirms the business to NMT. Detail information is entered from the client like

chassis number of the car. The Application provides the bill statement to the client, if the client has paid the bill a report is

generated to the manager of the number of clients paid in full. The entire process had to be tested and upon approval move to

Production on several releases. My role as a DBA for each of the release there is no performance issues upon generation of

scripts, maintain backup and recovery procedure, monitor database using custom scripts and reports, and code migration upon

completion of each task.

Responsibilities

Installing new versions of database software and perform maintenance functions of the database.

Installing 10g database and upgrade new release.

Compiling and debugging packages with in-house code, and assisting the developers

Created Scripts to perform hot and cold backups

Created new roles and assigned privileges to new users.

Cloning/Refreshing databases from hot/cold backups.

Monitor Database on high CPU consume memory is not taking place.

Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.

Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus.

Created indexes to improve the system performance.

Involving in creation of triggers and handling exceptions.

Developing various Business and ad-hoc Reports.

Creating Data Flow Diagram, Entity Relationship Diagram from Designer.

Various stored procedures were written to achieve the back end functionality.

Analyzed performance bottlenecks and provides appropriate solutions.

Development, Testing, Implementation and Training.

Environment: IIS, Oracle Database, Linux Enterprise,XML, SQL Server Reporting Service, Qtrace, PL/SQL, ALM, Notepad+

+,Edit Plus, SharePoint, Business Intelligence, HTML,XML,PGP.

EDUCATION

Bachelors in Information Science, University of Albany Albany, New York - 2007

Status: Permanent Resident

Contact this candidate