Senior Consultant
Systematic Computer Science
Total years of experience :22 years, 7 Months
• Responsible for core production databases.
• Performed Daily Routine DBA maintenance work.
• Restore production databases on test environment.
• Setup RMAN backups and configure RMAN for Hot and cold backup
• Used RMAN backup to restore on different servers.
• Installed databases 11 g r2 Oracle Binaries,
• Applied Patches CPU (SPU) to all Oracle Homes.
• Scripted database auto shut off and on with server reboot and implemented.
• Installed OEM configures dbconsole for databases.
• Installed Oracle Data Integrator and configured.
• Installed swingbench and connected to database.
• Working as Production DBA for RAC 11gr2.
• Managing RAC instances using OEM and command line srvctl.
• Created New Database service and implemented TAF.
• Performed Daily Routine DBA maintenance work.
• Resolved issues with Listener, SCAN
• Validated Backups and restores.
• Monitor Database and resolved performance issues.
• Performed export import using datapump and remap the schema.
• ASM space issue resolved, instead of adding hard disk resolved the issue by reclaiming space by shrinking Tablespace..
• Creating Documents for new Installation.
• Interacting with end-users for oracle application problems and Trouble-shooting technical and Monitor databases for performance and related issues and resolved any issues with Database.
• Rebuild indexes and created new Indexes for performance.
• Resolved many pending issues for database availability and performance.
• Gather information for 11gr2 RAC implementation (new installations on Linux).
• Currently maintaining Databases with no downtime.
• Maintained Production and test and development database.
• Corrected operating system related memory issues for better performance.
Synechron Technologies Nov 2012 - May 2013
Pune, India
Role: Associate Specialist (Other Technologies)
Responsibilities:
• Managed upgrade project from 11i/10g to R12/11g HA multi-country/multi-language implementation on linux in an 11g RAC environment.
• Architected and implemented 11g RAC in all non-production environments.
• Worked with Client to identify, install and troubleshoot extended support requirements.
• Delivered several pre-production and production instances able to acquire extended support status and documented patches, problem patches and solutions.
• Identified and resolved critical application issues including those relating to performance, Work Flow, forms, reports and concurrent processes.
• Responsible for release management that would ensure complete release success by extensive interaction with development and co-ordination with various other teams.
• Monitor all database activity for operational improvements to include, but not limited to; CPU, Disk and Memory utilization, replication and consistency of all parameters across the enterprise
Royal Technocrats Inc. Oct. 2011 - Aug 2012
Houston, TX
Role: Senior DBA
Client 1: Shell Trading US Company
Houston, TX
Role: Sr. Oracle DBA
Responsibilities:
• ETRM systems administration and managed Oracle databases.
• Implemented 2 non-production environments using ASM (RAC 11g)
• Created and defined non-global zone partitioning for upgrade projects.
• Solaris System Administrator responsible for creating user accounts, patching and mount points in non-global zones
• Configured RMAN and Netbackup for all SUN servers and ERP environments (PeopleSoft and Oracle)
• Re-engineered change management process for client. Created change management standards documentation.
• Client has outgrown current backup solution and thus I coordinated a team to evaluate viable replacement backup solutions.
• Defined and implemented standards for instance strategy. Trained development teams on deployment strategy.
• Identified and resolved critical application issues including those relating to performance, Work Flow, forms, reports and concurrent processes.
• Assisted developers and/or users with identifying performance issues and tuning queries and scripts
• Experience in configuring, installing and maintain RAC implementations
• Experience in Oracle application server infrastructure suite of products bundled with 10gAS
• Monitored databases and performs tuning enhancements to optimize their performance.
• Maintain Oracle Grid Control monitoring console to ensure all production systems are fully monitored and alerts/messages are configured appropriately and resolved.
• Monitored trouble ticketing system to ensure reported issues are resolved in a timely manner.
• Performed database related activities: troubleshooting, recovery, tuning of the database, user security, RDBMS software installation and upgrades, resolving Oracle errors and failures, auditing activities, and resource utilization.
.
Eresources Consultants Inc. Jan. 2006 - Sep. 2011
Naperville, IL, USA
Role: Programmer/ System Analyst
Worked on different projects in US during the tenure
Client 1: Gavilon LLC
Omaha, NE
Role: Oracle Apps DBA
Responsibilities:
• Developed SQL queries to get the data from Endur Openlink ETRM
• Generate reports for performance issues using Automated WorkLoad Repository (AWR)
• Analyze SQL tatements using Automatic Database Diagnostic Monitor (ADDM) for performance issues for third party applications.
• Involved in Application Upgrades for test and Prod instances.
• Created tables for 10g FLASHBACK TABLE technology.
• Monitor databases for performance and related issues and resolved them.
• Maintained documentation in SharePoint for user's reference.
• Interacting with end-users for oracle application problems and Trouble-shooting technical and functional issues.
• Created several crystal reports and modified the existing ones
• Applied interim patches and applied patches for bugs for Oracle databases.
• Troubleshoot performance issues and bugs
• Troubleshooting, backup and recovery, proactive database and system maintenance.
• Perform Analysis, Design and Implementation of Oracle databases.
• Developed various module reports like Broker Fee Report, Confirm Status Report, Option Exercise Report and detailed pricing (Tie-Out) reports
• Configuring user creation, their roles and privileges, profiles to control access over database objects.
• Created TAR and implemented Oracle recommendation.
• Played an active role in designing and configuring the system
• Participated in the creation of user and training manuals.
• Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs.
• Created Crystal Reports, Subreports and Templates and modified Confirms, Invoices as required by the Business Users.
• Extract data for workflow management into excel.
Client 2: HP, Houston, TX
Role: Oracle DBA
Responsibilities: • Migrate databases from 9i to 10g oracle RAC for multiple Applications for different business units and collected information for migration review.
• Created databases -- export and import data, Meta data, schema using oracle export -import utility, SQL loader. Datapump.
• Applied interim patches and patches for bugs for databases and CRS.
• Monitor and close ticket queues in OVSD, Monitor MOM reports and resolve it.
• Work with service groups to resolve issues and handle issue escalations.
• Scheduled Patching and applying patches.
• Registered databases in Oracle Enterprise Manager, RMAN catalog for Monitoring and backups.
• Used Recovery Manager (RMAN) to take full and differential incremental or cumulative incremental backups. Created Recovery catalog database, Cataloged user managed backups into RMAN
• Monitor for performance and related issues and resolved them.
• Created passwords verify function profiles and users for security.
• Implemented Data Guard, maintain primary and standby databases.
• Monitor instances, databases brought up the instances down due to errors, modified parameters and maintained spfile.
• Oracle Networking tnsnames, sqlnet, Oracle Names using netca
• Maintained nodes and crs for Oracle 10G RAC.
• Worked with 24X7 and large terra byte databases.
Client 3: Nike, Memphis, TN.
Role: Oracle DBA
Responsibilities:
• Troubleshooting and performance tuning, development consultations, production database tuning, production system maintenance management. Monitoring system implementation.
• Design Data model and implemented for Nike Winchester project, created Standby database for Dataguard implementation.
• Created tables, inserted data with CSV, txt files using sql loader
• Documentation of any modification, new projects added and deleted are recorded
• for referral at later stage if required.
• Worked in 24X7 distributed environment ready to support any time required by the IT team.
• Developed shell scripts to execute and automate to run Sql loader & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs
• Modified and added new database triggers, packages, procedures, functions, utilities for application development for the applications for better performance.
• Improve the performance by Using the TKPROF, Indexes, Explain Plan.
• Tune SGA, SQL and solved performance issues
• Wrote scripts for scheduling hot backups and tablespace management.
• Implemented Data Guard, maintain primary and standby databases.
• Changed passwords for privilege users and changing links (Dropping & recreating) with new passwords for security.
• Find about the distributed transactions pending in dba_2pc_pending, Purging rollback/commit the pending transactions as required.
• Perform Export and Import of User, Tables, Schemas and Database
• Managing Tablespaces, adding datafiles/resizing for the Tablespaces filling up, coalesce the tablespace, managed extents.
• Managing crontab file, rescheduling the failed jobs ( due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts)
Samir Photographic Supplies Aug.2000 - Oct. 2005
Riyadh. Saudi Arabia.
Role: System Engineer
Responsibilities: • Install and maintain the application software at server and client end.
• Created tables, views, procedure, scripts, sequence, and cursor using Oracle 8i.
• Tuning stored procedures for database performance, redesigning the database.
• Providing user's support as needed for the users.
• SQL/PLSQL was used comprehensively throughout the project.
• Assist for Migration of Forms 3.0 to Forms 4.5.
• Development of Forms 4.5, Reports 2.5, Graphics.
• SQL*LOADER was used to load the data into the tables. • Installation of Developer/2000 on Programmers machines. • Created record groups, Master-Detail Forms. • Application training and support to the users Monitoring and turning for optimum performance • Maintenance of Oracle Database. • Create different users and grant restricted privileges using roles. • Audit the login attempts, object accesses and database actions.