SUMMARY:

• IT Professional with 7 years of industry experience as Confidential DBA. Worked mainly in Confidential Performance Optimization/Physical Implementation specialist as well as Ter - adata DBA.
• Worked on Data warehousing projects for Insurance and Manufacturing Do-mains. Clients - WellPoint, Confidential Motors and Dixons Carphone Warehouse, Confidential and Confidential .
• Extensively worked in Performance Optimization/DBA roles.
• Experience with Physical design best practices, PI and SI choices, Statistics au-tomation, Access Rights cleanup, Tuning of queries/business reports, compres-sion
• Access Rights, Space Management and Password Reset.
• Hands on Loading Utilities like Multiload, Fastload through Confidential Studio.
• Hands on Shell Scripting through Bteq.
• Experience in Opening and Closing Incidents for changes in production through HPSM.
• Optimized bad queries after which there performance Improved by 30-40%.
• Used Viewpoint extensively for monitoring purposes.
• Analysed and resolved TPT Issues while loading.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2007,2008 r2 and SUSE Linux

Databases: Confidential v12,v13.10, v14.10,Oracle 11g

DBA Tools: SQL Assistant, TARA GUI, Confidential Statistics WizardABU Netbackup, Confidential Administrator, PMONViewpoint, Confidential Manager, DBS Control, Priority Scheduler, Confidential Database Query Log and Tera- data Studio, PDCR and Tableau.

Confidential Client Tools: MLoad, Fastload

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Confidential 14.10

DBA

Responsibilities:

• Deployment of Data from one environment to another.
• Viewpoint Monitoring on regular basis.
• Creating new users through the request in Horizon Identity Manager.
• Providing Access rights to the users.
• Working on Ad-hoc requests on daily basis.
• Tuned Long running queries which were performing badly and hampering the per-formance of the system.
• Took active part in Production Release for the deployment.
• Resolved TPT issues while running loads.
• Worked on creating new users, reset passwords and providing roles to the Users.
• Taking backup of Tables and Databases through Data Stream Architecture (DSA).
• Worked on Tableau for pulling performance reports for the client.
• Worked on TDM ( Confidential Data Mover) for moving tables from one environment to another.

Confidential

Environment: Confidential v13.10, v14.10, SUSE Linux

DBA

Responsibilities:

• Worked on Incidents and CO’s on various Issues.
• Provided Space to the particular Database and User through Confidential Adminis-trator.
• Creating Users and giving the Access Rights
• Optimized Bad queries by collecting Multi and Single Columns Stats for the bet-ter Performance of the System.
• Done Optimization on Long Running reports by recommending proper PI and Stats Collection.
• Taken Manual Backups and monitoring them through TARA GUI.
• Taking Backup of Table Manually through Incidents raised by users.
• Worked on TASM related changes.
• Approving Change Orders on regular basis.
• Worked on Loading Utilities like Fastload and Multiload.
• Worked on Shell Scripting through Bteq to implement Change Orders and Inci-dent.
• Hands on Confidential Load Utilities like Fastload and Multiload.
• Used SQL Assistant extensively for pulling data from DBQL and for Performance Tuning as well.
• Used Viewpoint in tracking Bad queries and removing Blockings in the System.
• Hands on TASM for changing the Rulesets through Viewpoint for the better per-formance of the system.
• Creating and Refreshing Views on client requests after new table creation.
• Solved Ad-hoc requests from different users related to their job failures in MLoad.

Confidential

Environment: Confidential v13.10

DBA

Responsibilities:

• Provided primary index and sec index recommendation for sub-optimal Ta-bles.
• Designed process for automated stats collection
• Worked on MVC Analysis to reduce IO consumption for the better perfor-mance of Tables.
• Recommendations for Stats collection for business critical tables
• Viewpoint Monitoring.
• Have taken Backup through ABU Netbackup and TARA Gui Utility.
• Performance tuning of Business Reports.
• Providing weekly reports to the client regarding the performance of Confidential System.
• Worked on Access Rights Table to reduce size of the Table.
• Creating and Refreshing Views.
• Tracking Bad Queries and tuning them.
• Changing concurrency of the throttle if there is some delay in that Particular throttle.
• Raising and Monitoring incidents in Confidential At Your Service (TAYS).

Confidential

Environment: Confidential v13.10, SUSE Linux

DBA

Responsibilities:

• Worked on Code Review by using Confidential Statistics wizard.
• Worked on DDL QA Check Process to find out any discrepancy available in DDLs Generated.
• Worked on DDL Generation using remote desktop (SYBASE) which were required for the DDL QA Check Process.
• Knowledge and worked on Backup and Recovery on TARA GUI.
• Worked on giving Access Rights to users on Insert and Select on Database and also used Confidential Administrator for finding out different Rights held by the user..
• Worked on Stats Collection request given by the client team.
• Worked on Release Data Copy on T10 in Wellpoint.
• Created Proxy id’s for the users.
• Optimization of bad queries.
• Hands on System Monitoring through Viewpoint and remove any blockings or re-lease the jobs in Delay queue.

Confidential

Environment: Confidential v12.0, SUSE Linux

DBA

Responsibilities:

• Creating and managing Confidential database and environments.
• Managing users, roles and profiles in Confidential database.
• Current Space usage analysis and recommendation regarding the utilization of space.
• Good Knowledge of Confidential SQL Assistant, Confidential Administrator, Confidential Statistics Wizard.
• Monitoring the sessions and their resource usage.
• Checking stale statistics on the table and collected stats where required.
• Generating DDLs through SYBASE for the DDL QA Check process and later on for Migration.
• Used TARA Server for Backup and Recovery of Data