PL/SQL Developer v6.0.5 serial key or number

• Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
• Monitored of Customer Databases, physically located in U.S. and Remote Administration of fifteen Production Databases in UNIX environment.
• Configured parameter file, Listener and Net service names manually for production and physical standby databases in Data-guard environment.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/Standby databases.
• Communicated regularly with technical support, applications and operational staff to ensure database integrity and security.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities.
• Monitored database growth, provided capacity planning, and identified and resolved system bottlenecks.
• Installed and configured MySQL software and databases, including Server Management in Linux environment.
• Maintained and made modifications to the existing database management systems and associated applications.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Configure Data Guard to provide high availability using Physical stand by database.
• Provided inputs/feedback/consultation for database-related issues in projects ensuring timely delivery of applications.
• Monitored databases using Enterprise Manager and resolved issues based upon severity level.
• Created and executed functional test cases and database testing for deliverable applications.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Configured recovery catalog for databases to replicate target database control file.
• Maintain database configurations in compliance with release management and change management.
• Involved in database administration for monitoring and tuning of production database.
• Performed routine database tuning and administration activities for several Oracle databases.

Show More

• Work with developer in designing database tables, partitioning/indexing, developing PL/SQL stored procedures, triggers and performing queries optimization.
• Performed full PL/SQL development cycle including technical specifications and design.
• Experienced in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
• Experienced in Oracle10g RAC, RMAN backup and recovery, export/import, SQL, PL/SQL packages, and Linux shell scripts.
• Developed PL/SQL packages, procedures, views, triggers, and functions to support customer-specific business rules and reporting functionality.
• Prepared program specifications for PL/SQL Packages, procedures, and functions to do the data cleansing, migration and conversion.
• Design and develop SQL, PL/SQL and SQL+ scripts for database administrative tasks, custom report generation and data transformation.
• Developed PL/SQL stored procedures to allow Java applications to query data from an Oracle databases in the most efficient manner.
• Provide user support for new products comprising setting up roles, privileges, users and synonyms and modifying/creating PL/SQL packages.
• Created reports in Crystal Reports utilizing PL/SQL procedures and views to extract data for use within the DART application.
• Worked with SQL PL/SQL Oracle database developers by assisting them with their client software installations and resolving connectivity issues.
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Worked extensively on performance tuning including Query Optimization, PL/SQL Procedure Tuning, Instance / Memory / IO Tuning.
• Involved in the development of custom stored procedures, functions, packages, triggers, SQL and PL/SQL scripts.
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager (OEM) Tools, Query Analyzer and Explain Plans.
• Created PL/SQL packages and supporting documentation to support various third party Visual Basic Applications to interact with Oracle database.
• Created packages, stored procedures and user-defined functions using PL/SQL and Oracle Procedure Builder for various business operations.
• Implemented PL/SQL package to issue commit at set interval to optimize batch processing reducing redo log related waits.
• Assisted developers in the PL/SQL Packages, Procedures, Function Set Up and XML in Web Application Environment.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

Show More

• Design, document, implement and maintain all disaster recovery procedures Perform daily operational duties/security for all users of the databases.
• Prepared detail study of existing Oracle Databases backup and recovery procedures and planned for improvements in various disaster recovery scenarios.
• Develop backup/recovery procedures to include weekly cold backups, multiple daily hot backups and a standby database for high availability.
• Enhanced database performance, performed restores, applied database patches, implemented recovery procedures and assisted with regular system backups.
• Perform restorations, implement recovery procedures, handle performance tuning, capacity planning, database security, and monitoring.
• Design, Implement, and Document Automatized Backup/Restore, database maintenance, and Disaster Recovery Procedures.
• Designed and implemented disaster recovery procedures, cloning and refresh procedures, and change management procedures.
• Plan and document disaster recovery procedures and participate in disaster recovery drill on a yearly basis.
• Implemented effective backup and recovery procedures to provide 24x7 database availability to end-users.
• Implemented hot backup and recovery procedures to initialize 24X7 database support platform.
• Develop and implement recovery procedures that will reduce downtime associated with failure.
• Implemented disaster recovery procedures, and performed backups/restores, and data recovery.
• Implemented backup and recovery procedures and DataGuard setup for High Availability solution.
• Planned and implementation of Backup & recovery procedures and maintenance of Database.
• Established and maintained database backup and recovery procedures for point-in-time recovery.
• Implemented backup/recovery procedures using RMAN, performed database recoveries when needed.
• Develop and implement backup and recovery procedures and maintain security protocols.
• Ensured backup and recovery procedures, basic performance and application tuning.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Performed testing of backup and recovery procedures for newly installed databases.

Show More

• Monitor database performance trends to identify anomalies or errors, Report analysis, detect and resolved table-space fragmentation and migrations.
• Provided ongoing support of production database environment, space projection and reclamation, query performance tuning of existing applications.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• Administered performance and load test against deliverable hardware components and software applications using Rational Test Studio software.
• Implemented intelligent techniques in application logic to help database performance improvement and overall application performance improvement.
• Designed and coded utilities to support the database administration function and maintenance of RMAN-based backup/recovery operations.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• Developed and implemented database security and user management processes, and tuned applications to enhance performance.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Design and implement database backup/restore methodologies, responsible for troubleshooting performance and networking issues.
• Monitored and test system performance, prepared and delivered system performance statistics and reports.
• Enhanced existing database designs for improved longevity, reduced maintenance, and improved performance.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement.
• Worked with developers in resolving issues relating to database and application performance.
• Leverage performance tuning and optimization, using native monitoring and troubleshooting tools.
• Created recovery catalog, performed complete and incomplete recovery using RMAN.
• Tune database to ensure an acceptable level of performance and availability.
• Created Catalog database for monitoring backup information of backups using RMAN.
• Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Show More

• Frequent interaction with Developers, and working with them in developing the applications using SQL Trace and Explain Plan utilities.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, and AWR.
• Control and monitor user access to databases and maintain database security using Oracle audit feature or enable SQL trace.
• Performed SQL tuning based on reports generated by SQL Trace, ASH, AWR, Explain Plan.
• Performed application SQL Tuning using SQL Trace and Explain plan for existing queries used in application development.
• Performed application SQL tuning using SQL Trace/Explain plan and TKPROF and database tuning for optimum performance.
• Performed SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility an AUTOTRACE utility.
• Involved in Database Tuning and Improved Application performance using Explain Plan, TKPROF and SQL trace.
• Used Oracle utilities like SQL Trace, TK Prof and Explain Plan for performance tuning.
• Used the BMC tools to perform DB troubleshooting, SQL trace and databases tuning.
• Perform performance optimization using Explain Plan, SQL Trace, and Optimizer Hint etc.
• Experienced in dealing with Query execution plan, SQL trace, TKPROF.
• Monitored database and collecting statistics by using EXPLAIN PLAN, SQL Trace.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Implemented proactive monitoring using SQL Trace & TKPROF, EXPLAIN PLAN.
• Used SQL trace to assess the efficiency of the SQL statements.
• Handled Application level tuning (TKPROF/Explain Plan/SQL Trace).
• Completed SQL tuning using SQL Trace and Explain Plan.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF.
• Analyze the database using Oracle AWR/ADM report, STASPACK, TKPROF, SQL Trace and Explain Plan.

Show More

• Managed database security by auditing and mitigating vulnerabilities to comply with Oracle and Linux security requirements.
• Introduced and successfully implemented Ubuntu Linux operating system to Tele-Caller's desktops.
• Implemented custom Linux shell scripts to monitor databases that drastically reduced alerting.
• Performed UNIX/Linux system administration and maintenance (disk partitioning, creating/maintaining users, installing software applications, tuning, etc.)
• Configured an Oracle Linux environment, on PMI's production database server, to host the Agile PLM database instance.
• Upgraded Oracle databases from to on Oracle Linux using Virtual Box on Microsoft Windows 10 server.
• Install and configuration of Oracle Business Intelligent Enterprise Edition (OBIEE ) in Linux and administration tool in windows.
• Installed and configured on Red-Hat Linux ES Oracle Applications & 9i Real Application Clusters (9i RAC).
• Planned and documented process for upgrading existing databases from 10g to 11g and from SuSE Linux 9 to
• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Install 11g databases on Linux, apply patches in various environments and upgrade databases from to
• Installed Grid Infrastructure Software on new Linux Servers for 4 node RAC and Oracle Grid Control 11g Installation.
• Migrated databases from Windows to Linux * Taking Oracle HOT, COLD backups, RMAN incremental backups.
• Install, configure, and implement backup/recovery strategies using Oracle RMAN and Linux for daily database backups.
• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g.
• Project Name: Data Guard Implementation/ Oracle DBA Environment: Production and Non-Production on Linux/HPUX and NT.
• Supported 40 databases for production, development, test and staging purposes on Linux/Unix and Windows environments.
• Migrate Oracle databases in Windows and Linux servers, and upgrade the database on those servers.
• Experience in reading and editing the configuration file settings for PostgreSQL and other UNIX/Linux related programs.
• Involved in Installing and configuring of 11g Oracle Real Application Clusters (RAC) in Linux.

Show More

• Configured Physical Standby databases using data guard and converted Physical standby to Snapshot Standby and active data-guard depend on Business Requirement.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Experience in designing and configuring high-availability systems like Data Guard with physical standby with Data Guard Broker utility configured and used.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Configured and implemented physical standby database using Data Guard for high availability and providing critical solution with disaster recovery plan.
• Configured Physical Standby database using Oracle Active Data Guard for disaster recovery, business continuity and reporting purpose.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager.
• Created on-site physical standby database for reporting and off-site physical standby databases for disaster recovery.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Installed and Implemented High Availability database solutions using Physical standby setup of Oracle Data Guard.
• Used physical standby database method for upgrading databases which hosted critical application to reduce downtime.
• Implemented Disaster recovery for production databases using Data guard and creating physical standby databases.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Create multiple standby databases for Disaster Recovery using Oracle Data Guard Physical Standby technology.
• Configure and troubleshoot Logical and Physical standby databases using Data Guard and manually.
• Implemented standby databases consisting of physical standby databases created via RMAN duplicate command.
• Instantiated Physical standby database from Primary using Active Database Duplication for 11gR2 database.
• Implemented and administered 10g DataGuard Physical Standby Database for High Availability database services.
• Participated in the Implementation oracle 11g physical standby database for test database environment.

Show More

• Implemented UNIX shell scripts for automation of different administrative activities and notifications.
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Developed a complex set of UNIX shell scripts for application/database/server housekeeping.
• Aided system administration in UNIX disk implementation and management.
• Developed Unix scripts to automate the collection of database information
• Developed UNIX shell scripts & SQL scripts to perform the daily Database & OS monitoring, Server validation & health check.
• Developed automated procedures for database recreations, included DBCC, procedures, UNIX and Windows Shell scripts for automating database backups.
• Designed, wrote and implemented Oracle SQL scripts with Perl/UNIX commands and X windows interface for reporting and data analysis.
• Install, configure, customize, patch and migrate Oracle database server software on Unix O/S and MS O/S servers.
• Involved in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Automated the deployments of new versions, upgrades and patches of the DONCJIS application using SQL and UNIX shell scripting.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Stats pack snapshots and reports.
• Implement monitoring jobs for the day-to-day maintenance for Production databases and develop UNIX shell scripts for automating database maintenance work.
• Developed various UNIX Shell Scripts to automate the routine tasks and to extract and load data for month-end batch processing.
• Merged and mentored the Oracle Database Group and the UNIX support Group into a more efficient and customer focused team.
• Provide leadership in migrating backup/recovery solutions to EMC's BCV backup & recovery from RMAN & other Unix scripted Tools.
• Performed installations and upgrades in an Oracle7 and Oracle8 environments on UNIX HP servers (HP UX ).
• Developed PL/SQL packages, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Installed, created and configured Oracle 10g and 11g Oracle RAC Databases both on Windows and UNIX platforms.
• Performed Installations and configurations of Oracle Software 9i, 10g, & 11g on UNIX and Windows Servers.

Show More

• Designated Traveling DBA to support/implement database migration and replication to numerous countries around the world.
• Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists.
• Designed Disaster/Recovery Database for internal DBA group.
• Provided 24x7 remote support and on call Database support (rotatory weekly backup DBA from 12am - 6am) using RSA-VPN.
• Generated internal DBA team documents including problem resolutions documents, lessons learned, how to, and basic knowledge transfer documents.
• Applied Oracle Security patches * Created documents detailing DBA procedures for offshore DBA personnel * Created Performance Assessment and Capacity Review documents
• Performed all DBA tasks including software installation, database and user creation, backup and recovery, and performance tuning.
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team, Business owner and DBA Manager.
• Monitored and managed databases to maintain high level of performance and availability as well as performed other routine DBA tasks.
• Created detailed project plan to with tasks, dependencies, resources and dates for infrastructure, installation and DBA tasks.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.
• Participate in 24*7 on-call DBA support rotation and be flexible to work after hours for production needs as required.
• Developed new or modified existing solutions for HP's GDBA configuration management, capacity management, and POR infrastructure.
• Coordinate weekly meetings to solve current issues to be solved by the 24/7 Oracle Database group of DBA's.
• Lead DBA member of a project team formed to design and implement a centralized backup facility for Oracle databases.
• Experience with Oracle 8i and 9 at the developer and DBA level maintaining and updating a database storage warehouse.
• Coordinated and reviewed among DBA team for any new installations, upgrades and configuration changes to the existing environments.
• Worked as a development Oracle DBA and provided round the clock support to production, development and test databases.
• Perform various daily Oracle DBA functions including security and data fault tolerance for critical Department of Defense application.
• Created master build script for data migration for DR and Production and providing scripts to infrastructure DBA's.

Show More

• Upgraded over 50 production and UAT databases from Oracle 10g to Oracle 11gR2 on Linux and Solaris
• Implemented, and configured 12C cloud control, agents and registered 11g/12c databases on SOLARIS servers.
• Installed Oracle8i on Sun-Solaris and Windows and configured for production.
• Installed and configured Oracle 9i/10g on SOLARIS, REHL/HP-UNIX.
• Provided emergency database administration and problem remediation for the Intel/Solaris 8 Oracle 8i database system.
• Developed server/database installation and configuration standards used for all new Solaris and HP servers.
• Configured and managed databases on UNIX and Solaris environment.
• Migrated zoned environment to alternate Solaris 10 servers.
• Installed/Configured/administered Sun Solaris on Sun E Machines.
• Worked with Oracle on-Demand to successful Upgraded Oracle Applications R to R and R to R on RHL and Solaris versions.
• Experienced on Solaris with Oracle10g RAC (Real Application Clusters), including all options for storage and justifications for deployment.
• Support daily maintenance and database development request for an Oracle 10g Database Server operating on Solaris 10 and Windows Server.
• Designed, created and maintained Oracle 8i and 9i database versions hosted on a Unix platform with a Solaris operating system.
• Installed/Upgraded/Cloned new databases as per the tailor made requirement of the applications including ASM technology in Sun Solaris and Linux platform.
• Installed, configured and maintained Oracle Database 12c on Oracle Sun Solaris T SPARC servers and 11g on T SPARC servers.
• Install, Upgrade and configure Oracle database for various bit and bit platforms on Solaris and MS Windows
• Maintained the backup and recoveries on Sun Solaris server and NT clients for East Coast for a short time assignment.
• Upgrade of databases from to (Solaris and NT) Patch installation for all databases in all environments.
• Experience in Installation of Oracle 10g Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system.
• Performed backup of databases using RMAN scripts Environment: Oracle 9i databases, Customized Applications Java, Linux, Solaris.

Show More

• Performed DBA activities on user accounts and access rights on a Windows XP environment.
• Designed and Implemented new standard Windows server and Windows XP desktop image.
• Installed, upgraded and configured Oracle applications on Windows XP clients.
• Installed and Configured ORACLE 9i in Windows XP SP2 and Redhat Linux AS environments.
• Offered clients general support for Windows, Windows XP, Windows NT, OS/2, Novel and Mac systems.
• Maintain 20+ production instances on Windows XP// running Oracle 10g/11g that provide data to public-facing Web sites and various internal departments.

Show More

• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Reduce fragmentation and increase reliability by locally managed table spaces.
• Transported table spaces between production and development databases.
• Performed DBA tasks like creating tables, providing privileges, working with table spaces and allocations, kill ghost sessions etc.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Created and maintained reports of roles and user accounts, database table spaces, tables, and indexes Responsibilities:.
• Create table spaces, tables and indexes, sizing the system table space, allocating default table space for users.
• Developed scripts to create database objects (tables, indexes, views) - Maintain and monitor table spaces.
• Create new table spaces to meet the requirements in 11g RAC and created and migrated all the objects i.e.
• Configured various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• Organized the tables, indexes, high volume tables in an individual table spaces under different mount points.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Developed SQL scripts to monitor the growth of the tables and available free space in the table spaces.
• Established capacity planning of table spaces, tables, indexes, and databases to allow for growth potential.
• Created and maintained table spaces, tables, indexes, users, roles, privileges and security.
• Configured the logical design of the database by creating table spaces, rollback segments and objects structures.
• Created users, table spaces, tables, indexes, views, triggers, synonyms and sequences.
• Monitored and tuned rollback segment, temporary Table spaces, redo log buffer, sort area size.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.

Show More

• Gathered database requirements from client calls and planned database storage capacity and ASM capacity.
• Configured testing/exploratory environments for OID/SSL and RAC/ASM for evaluation purposes.
• Install, configure, maintain 75+ two node Oracle RAC, ASM databases, using Flashback Database and Data Guard.
• Configure Backup and Recovery setting for Oracle database10g and 11g for single instance on File system and ASM storage using RMAN.
• Worked with UNIX team, storage team for new LUN allocation, scanning disk as part of new ASM disk creation.
• Configured ASM instance, disk groups, failure groups, stripping and mirroring concepts using ORACLE 10g/11g databases in LINUX environment.
• Installed, Created and Administered Automatic Storage (ASM) instances for use with both single Instance and RAC set ups.
• Configured ASM disk groups, File system using Oracle 10g/11g, Configured 3 Disk Group of 3TB in Linux environments.
• Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied oracle patches on need basis.
• Designed and Configured Automatic Storage Management (ASM) and Real Application Cluster (RAC) for high availability databases.
• Explored, tested and successfully Implemented Oracle GG DB-LOGREADER API to extract huge volume of data from ASM DB.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• Partitioned the carved out space allocated in HP 3PAR SAN storage and configured UDEV rules for ASM disks.
• Worked on storage migration with EMC SAN team to create ASM file system with normal redundancy disk groups.
• Involved in fresh installation of and and RAC databases on ASM and NFS file systems.
• Worked on installation of ASM as well as NON ASM Oracle 10g Databases as per the requirement.
• Install, Configure, Maintain and Monitor databases using Oracle 11g/10g RAC with ASM as storage medium.
• Installed, configured and maintained 11g R2RACdatabase (2 node instances) with ASM on LINUX platform.
• Involved in performing migration from Oracle 9i, 10g to Oracle 11g Release1 RAC database with ASM.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.

Show More

• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment.
• Performed data modeling including reverse engineering using the Toad Data Modeling tool.
• Created standards documentation for new database security and auditing including TOAD restrictions.
• Monitored database for performance and optimization using Toad.
• Work with Toad for a comprehensive database development and administration tool to perform daily DBA tasks efficiently and function properly.
• Manage Database using Oracle Enterprise Manager (OEM) and Tools for Oracle Application Development (TOAD) and MS Project.
• Perform troubleshooting and performance/SQL tuning of critical databases, such as PeopleSoft by using Toad DBA module, Grid Control.
• Developed and Modified Tables, triggers, packages, procedures and functions using PL/SQL, SQL, TOAD etc.
• Developed Oracle PL SQL stored procedures, functions, packages using the debugging features of TOAD and SQL Navigator.
• Used Toad and SQL Developer to develop and debug PL/SQL scripts and to examine and update the database.
• Performed installation of Discoverer, Forms and reports, Toad, 9i Client on Client Computers of trainees.
• Installed Oracle Databases using management framework, and tools such as SQL Developer, Toad and DBA scripts.
• Utilize Oracle Designer, Developer, and TOAD, Quest's SQL Navigator for all software development.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad.
• Created scripts to generate new tables, views for enhancement in application using TOAD and SQL developer.
• Optimized queries and generated graphical SQL results from Oracle Enterprise Manager Console, Toad and Grid Agent.
• Used Toad with DBA option to aid in rebuilding indexes and tables when they were too fragmented.
• Installed and used Oracle 10g OEM Grid control and TOAD in monitoring and accomplishing Database Administration issues.
• Handled performance tuning and application monitoring with Quest TOAD Oracle DBA Module, and Oracle SQL Developer.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like SQL* TRACE, TOAD.

Show More

• Developed a performance tuning system using OEM grid for Oracle and implemented role-based security.
• Monitor performance of databases using OEM Grid Control to improve database and application availability.
• Performed OEM Grid control installation and configuration for monitoring and performance tuning.
• Configured OEM Grid control for Monitoring and Notification of databases.
• Installed and Configured OEM Agents and Targets on OEM Grid for different databases and worked on Alert Mechanism and Metric Collections.
• Implemented 10g OEM grid control for monitoring the database and applications * Expertise in using various AD and FND utilities.
• Experience in RMAN backup, Full and incremental backups, flashback technology, Enterprise Manager and Oracle OEM Grid control.
• Supported Oracle cluster Databases, Oracle Database Server 10g on Linux platform and monitored through the 10g OEM grid control.
• Performed Database health checks, and used the notification tool to send the alerts in OEM Grid Control.
• Experienced in Installation, configuration and setting up of OEM Grid Repository and 12c on Linux platform.
• Experience of installation and managing Oracle databases 8i, 9i and 10g using the OEM Grid Control tools.
• Helped the OEM team with OCM installations and set up OEM grid controls for the database instances.
• Helped to install ORACLE 10g/11g OEM Grid Control and setup monitoring and backup procedures on databases.
• Worked on OEM Grid Control 11g, scheduling and troubleshooting OEM jobs and deploying OEM agents.
• Performed database performance monitoring and tuning using OEM Grid to ensure databases run at peak performance.
• Worked on Oracle 11g OEM Grid Control and OEM Console for the effective DB administration.
• Experience in performing database related activities using Oracle Enterprise Manager Grid (OEM Grid).
• Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.
• Worked vastly with Oracle OEM Grid to create reporting mechanism, alerting and security standards.
• Configured the e-mail Notification for the alerts generated with the help OEM Grid Control.

Show More

• Generate and Analyze AWR reports for long running jobs and find out the root cause and document the same for reference.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained Performance statistics for problem detection & self-tuning purposes.
• Perform Database Monitoring and Performance Tuning by using AWR Stats pack, ASH Report and Explain Plan to ensure high performance.
• Well versed in reviewing AWR, ASH reports and , trace files to identify potential performance problems.
• Modified AWR retention policy from default of 8 days and 60 minutes to 21 days and 30 minutes frequency.
• Monitored scheduled jobs for backups, gathering statistics, AWR reports, status reports, disk space utilization report.
• Generated and used AWR report to monitor the performance of the SQL's executing and preparing the plans.
• Implemented advanced feature of Oracle 11g such as Automatic Workload Repository (AWR) for monitoring database performance.
• Generated and interpreted Automatic Workload Repository (AWR), Active Session History (ASH).
• Explored 10g's improved Automatic Optimizer Statistics Collection using Automatic Workload Repository (AWR).
• Monitor and optimize performance of the database using AWR and other oracle provided tools.
• Utilize Automatic Workload Repository (AWR) to generate snapshots of key performance data.
• Monitored AWR and ASH reports on a regular basis to identify potential problematic SQL.
• Created AWR report to tune the instance also used Oracle Enterprise manger to monitor.
• Perform database performance tuning activities using tools like AWR Reports and Explain plan.
• Streamlined processes using AWR and ASH to enhance quality and performance of SQL.
• Generated AWR to analyze problematic SQL's which are root cause for performance.
• Monitored the performance of the database using Cloud Control 12c and AWR reports.
• Tuned SQL Queries for better performance using Explain plan, AWR Report.
• Experience of Oracle Database monitoring and tuning using stats pack and AWR.

Show More

• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Involved in day to day activities like user/table management, performance tuning, backup/recovery database replication for high availability etc.
• Participate in a team to maintain and support for multiple oracle database and applications in high availability 24x7 heterogeneous environment.
• Resolved technical issues provided resolutions and made recommendations, ensuring high availability, performance and security of production databases.
• Set up, configuration and maintenance of Standby Databases for disaster recovery, high availability and data protection.
• Configured Clusters, Load-balancing, High availability and fail-over solutions & Web Server plug-in for WebLogic application server.
• Experience in Configuring Name-node High availability and Name-node Federation and depth knowledge on Zookeeper for cluster coordination services.
• Experienced in setting up unidirectional and Bi-directional replication using Golden Gate for High Availability and reporting projects.
• Performed performance tuning on high transaction and high availability database environment for e-commerce business-to-business java based applications.
• Deployed applications on multiple WebLogic Servers and maintained Load balancing, high availability and Fail over functionality.
• Installed and configured Data guard using physical and logical standby for high availability and reporting purpose.
• Support Oracle 11g WebLogic Server architecture planning, installation and configuration for performance and high availability.
• Supported, maintained and troubleshooting Oracle Golden Gate for data replication and high availability databases.
• Monitored database instances, and took preventive steps to ensure high availability and optimal performance.
• Maintained high availability and minimal downtime by designing and implementing standby database on all servers.
• Maintained data guard to provide high availability by implementing physical stand-by database and snapshot-standby databases.
• Optimize database accessibility by developing load balancing/high availability architectures and processes to eliminate down time.
• Supported mission critical Oracle databases, ensure high availability and compliance with business requirements.
• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
• Designed and configured Stand-by database and created hot-backup procedure for high availability operation.

Show More

• Assisted application development team in query tuning & optimization, partitioning, explain plan recommendations.
• Tuned the oracle PLSQL procedures and queries using explain plan and hints to improve the performance of the reports.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Optimized the database and stored procedures using Explain Plan and Oracle Trace logs by adding indexes to tables.
• Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.
• Tuned unorganized SQL queries by viewing explain plans and created /modified indexes to optimize the performance.
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Used trace reports, SQL*Trace and Explain Plan utility for tuning SQL statements and sessions.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Reviewed explain plans for new queries with developers via SQL*Plus and Oracle SQL developer client.
• Involved in Performance tuning which included creating indexes and modifying queries using explain plan utility.
• Explain plan used to diagnose the long running queries, tuning applied if it required.
• Tune SQL for better performance by using explain plan and create indexes wherever necessary.
• Use of explain plans to tune SQL queries, building indexes to improve performance.
• Use EXPLAIN PLAN to know if the execution plan for critical jobs has changed.
• Developed a web interface to quickly generate Explain Plans for executing SQL statements.
• Fine-tuned the Application programs using Explain Plan and monitored proper usage of Indexes.
• Tuned bad/expensive SQL queries, used tools like SQL*Trace, Explain Plan etc.
• Perform tuning of triggers, indexes and stored procedures using explain plan.

Show More

• Assisted in implementation of new setup across Customer regions and also as restore specialist for implementation solutions.
• Performed fail over testing to simulate production database disaster recovery using SRDF replication in Non-RAC setup.
• Hand on experience in installing, configuring GoldenGateUni-Directional and Bi-Directional setup in Linux operating systems.
• Implemented and monitoring Database and SQL-NET security, audit preparation and listener password setup.
• Provided technical expertise in assisting functional specialists with ERP module configuration and setup.
• Planned, Installed and Configured Golden Gate setup to achieve unidirectional replication.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Involved in replication setup, configuration and maintenance of replication processes.
• Created Standby database setup via Data guard for Database Disaster Recovery.
• Contributed towards 11g golden gate for unidirectional DML replication setup.
• Perform database analysis and setup database maintenance, monitoring scripts.
• Implement data security standards through Virtual Private Database setup.
• Installed Oracle GoldenGate and setup uni-directional replication.
• Plan GoldenGate setup to achieve Unidirectional replication.
• Planned and implemented AppWorx installation, user setup, security, job scheduling and creating the AppWorx database linked to Oracle.
• Performed the Auto setup of Oracle Recommended tools like RDA and OSW on Servers to monitor Databases and Hosts.
• Develop, test, and deploy database backup and restore procedures for HDR (replication) setup in all environments.
• Used data mover to move setup data, user preferences, security, purge messages, purge process scheduler data.
• Worked on Golden Gate setup & configuring the replication jobs & also implemented Golden Gate Director in 10g & 11g.
• Scale mainly on Purging, SOA/WebLogic tuning, DR setup, shell scripting, troubleshooting of day to day issues.

Show More

• Involved in the process of tuning and refining SQL queries and analyzed TKPROF, Explain Plan outputs for improving the performance.
• Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
• Tuned application with EXPLAIN PLAN and TKPROF, analyzing database objects, maintaining the security of the databases.
• Experienced in database tuning by modifying database initialization/memory parameters and queries using TKPROF, Explain Plan and OEM.
• Identify and Create indexes, materialized views for SQL Tuning of bad queries using Explain Plan and TKPROF.
• Performed the application tuning: analyzed SQL statement's performance by using Explain Plan and TKPROF utility.
• Used TKPROF utility for performance monitoring of databases and used Explain plan for monitoring the query execution.
• Provided technical support to the development team, and performed application performance tuning using the TKPROF utility.
• Involved in Performance tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Evaluate the performance of SQL statement using utilities like TKPROF, auto trace and Explain Plan.
• Performed SQL query optimization by gathering statistics and by using explain plan, TKPROF.
• Involved in Performance tuning by leveraging oracle explain plan, AWR and TKPROF utilities.
• Analyze complex SQL queries for development by using Explain Plan, TKPROF, statistics.
• Identified and tuned resource intensive queries using explain plan, TKPROF, AWR Reports.
• Used explain plan and stats pack/TKPROF utility to Improve response time of query.
• Performed SQL tuning by using Explain Plan and TKPROF and Oracle Enterprise Manager.
• Enabled and analyzed trace files using TKPROF analysis and system wide event tracing.
• Experience with TKPROF; explain plans, AWR and Automatic SQL Tuning.
• Tuned SQL queries using explain plan, TKPROF, SQL tuning advisory.
• Optimized SQL statements for maximum performance by using TKPROF and EXPLAIN PLAN.

Show More

• Completed performance analysis using ADDM and implemented valid recommendations on schema and storage level.
• Provided recommendations using ADDM reports.
• Collected reports using AWR, ADDM and snapshots analysis determining CPU bottlenecks, I/O capacity issues, high load SQL statements.
• Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR and ADDM Data.
• Installed agent and involved in registering of databases in OEM and created AWR, ASH, ADDM reports for performance troubleshooting.
• Carried out performance tuning activities using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Implemented database monitoring and tuning, application, and queries using ADDM, ASH, AWR, Explain Plan and OEM.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Used Oracle 10g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring performance related problems.
• Used Oracle Enterprise Manager (OEM) to view the performance of the database and pull out the ADDM report.
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Tuned PL/SQL, SQL with Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM).
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• Coordinate with testers to ensure QA environment is available during testing periods and provide appropriate AWR and ADDM reports.
• Troubleshooted Oracle database issues and optimization issues using AWR reports and Explain Plans, ADR, ASH, ADDM.
• Created performance health check report using OEM Grid control to analyze data in conjunction with AWR analysis by ADDM.
• Tuned database servers by using new 10g features ADDM, AWR, Keep/pin objects, tune recovery time.
• Tune SQL queries for better performance by analyzing AWR/ADDM Reports, SQL Trace, TKPROF and Explain Plan.
• Experience in analyzing AWR, ADDM, ASH reports in troubleshooting the contention and concurrency in the database.
• Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports.

Show More

• Migrated successfully databases on AIX using snap technology.
• Utilized GoldenGate to migrate database environment from AIX to Linux with minimal downtime including upgrading from 10gR2 to 11gR2 where applicable.
• Administered 14 development, test, and production Oracle Databases running under AIX Used by clients in a 24x7 environment.
• Experienced in Oracle installation, configuration, Oracle patching and migration running on (IBM-AIX, Linux and Windows) platform.
• Cloned four SCT Banner V databases for testing SCT Banner upgrade to V on AIX L from hot backup SnapShot.
• Worked as a Production/Development DBA in Installation, configuration, maintenance and tuning on Oracle11g and 10g on IBM-AIX
• Performed 11i to R12 upgrade with migration Oracle Database from AIX to RHEL to have full business enterprise features.
• Implement Oracle 11g RAC with 3 nodes using ASM and Platform Migration of database and applications from AIX to Linux.
• Performed server consolidation tasks to migrate databases and infrastructure to new hosted server facilities, upgrading both AIX and Oracle.
• Worked as an Oracle Consultant at UNM verifying NetApp SnapRestore on AIX L and RedHat Linux Enterprise Server 4.
• Installed and configured Oracle 10g/11g Databases on AIX and Linux Operating systems on Development, UAT and Production Systems.
• Migrated OEM 10g to OEM 12c Cloud Control active/passive platform which involved agent deployments to over Linux/AIX servers.
• Managed and monitored the databases on Windows and UNIX (HP and AIX) servers using OEM and TOAD.
• Experience to Perform database transaction and security audits Environment: Oracle Application Oracle Dual Node AIX
• Provided technical support for Oracle databases within various UNIX environments, including HP, Sun, and AIX.
• Maintained, supported and administered VLDB oracle (OLTP and DSS) databases running on HP-UX, AIX.
• Implement Oracle Critical Patches and version upgrades when needed for Sun, HP Unix and AIX OS.
• Monitored over AIX, Linux, Tru64, and HP-UX systems as part of the Tactical.
• Installed HACMP on AIX box with more than 8 nodes to share data among multiple computers.
• Set up OEM grid control 12C for multiple databases monitoring on AIX server and enterprise reporting portal.

Show More

• Performed Capacity monitoring and short and long-term Capacity Planning in collaboration with development resources, system administrators and system architects.
• Provide database administration, capacity planning, performance tuning, database migrations, and backup and recovery strategies and documentation.
• Coordinated capacity planning through in-depth trend analysis to calculate space utilization, application growth, and projected database sizing.
• Provided suggestions to system administer regarding disk configuration, RAID level according to database sizing and capacity planning.
• Performed Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.
• Provided capacity planning, tuning and administration support to application development efforts in Broad vision and PeopleSoft.
• Performed business database and application patching, database capacity planning, and Oracle ASM configuration and implementation.
• Involved in activities like allocating system storage and development plans for future storage requirements like Capacity planning.
• Performed capacity planning and reporting, monitoring of storage utilization, reclaiming space and optimizing space allocation.
• Handled database server tuning, application tuning, maintaining documentation, and Capacity planning and database security.
• Perform database administration activities such as modifications, enhancements, expansions, and capacity planning.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Installed and configured GoldenGate and Performs GoldenGate replication monitoring, tuning, and capacity planning.
• Provided IT managers with expert recommendations on capacity planning for the enterprise databases.
• Worked with capacity planning teams for new implementations and performed troubleshoot database issues.
• Managed database and application design and capacity planning for internal and external/regional projects.
• Performed ongoing capacity planning and expansion to meet organization requirements for data improvements.
• Experience in capacity planning/management, monitoring of database space and estimating growth requirements.
• Performed various tasks in administration of databases including capacity planning, instance creation.
• Monitor database growth and regularly review them and provide Capacity Planning for databases.

Show More

• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Installed and configured STATSPACK and monitored database performance.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
• Involved in monitoring and tuning the performance of the databases and application using OEM tuning pack, diagnostics pack and STATSPACK.
• Run the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, STATSPACK, and SQL TRACE.
• Conducted performance tuning using various tools like TKPROF, EXPLAIN PLAN, STATSPACK, data dictionary and dynamic performance views.
• Tuned the database using TKPROF and STATSPACK for optimum performance Setup the proper SGA size and other parameter variables.
• Perform performance tuning for the database using TKPROF, STATSPACK for optimum performance and to meet user's requirement.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Worked on Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Experience with Database reorganization, collecting statistics and monitoring database performance using STATSPACK, OEM, and TOAD.
• Performed monitoring and tuning using OEM, STATSPACK, TOAD, SQL tuning using Oracle standard tools.
• Tweak databases for performance and tuning using Explain Plan, hints, AWR/ STATSPACK and Enterprise Manager.
• Performed STATSPACK setup, collected statistics, generated and reviewed STATSPACK report for performance monitoring and tuning.
• Experienced in both application and query tuning, using AWR, ADDM, TKPROF and STATSPACK.
• Help with troubleshooting, analyzing STATSPACK reports/explain plan/SQL Trace and tracing user sessions for performance analysis.
• Monitor database performance via STATSPACK, Automatic Workload Repository, Database Control, and Quest Tools.
• Performed SQL query tuning (Optimization) using Explain Plan, TKPROF, and STATSPACK report.
• Check the performance of the database and tune when required using tools STATSPACK, EXPLAIN PLAN.

Show More

• Design, test, implement and document database upgrade and migration procedures using export/import migration utility.
• Performed various database maintenance tasks such as table/index analysis, database export and re-organization mechanisms.
• Plan and Schedule regular Database maintenance activities including export/import and chain row removal process.
• Refreshed test databases with production data using manual cloning procedure or export/import.
• Performed manual and automated Database refreshes on Oracle using logical export/import.
• Experienced on Data Replication using Snapshot, Materialized views, import/export.
• Updated development databases by using import/export and SQL loader utilities.
• Developed export/import files for other high security users upon request.
• Used import/export utility and DataPump utility to transfer data.
• Provide daily database exports for external applications reporting systems.
• Created/Configured test and development environments using Oracle export/import.
• Performed logical backup using export and import utilities.
• Performed monthly production database exports to refresh development databases
• Performed logical backup using full/partial export/import.
• Recovered database objects using export/import.
• Use Oracle's seeded Backup/Recovery module that use RMAN for OID Metadata Repository and LDAP export of OID Configuration files b.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Created, scheduled database maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, database exports.
• Set up a seven day incremental merge RMAN strategy for production databases and nightly export scripts for test and development environments.
• Executed backups using RMAN and hot backup, exports and imports, archiving old records and verification of such processes.

Show More

• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.
• Developed shell scripts to automate nightly logical backup of production database for routine refresh of application schema using Oracle DataPump utility.
• Installed GOLDEN GATE and demonstrated the GOLDEN GATE Uni-Directional Table/Schema functionality and provided architecture documentation with the steps of implementation.
• Performed database schema / object design and development, configuration, implementation, optimization, and maintenance.
• Implemented schema replication, information propagation from one database to another database using Oracle Streams.
• Experience with Star Schema simulated the functions of a multidimensional database and data warehousing.
• Implemented Physical and Logical standby database and schema replication using Oracle streams.
• Configured and maintained Schema level uni-directional Replication using GoldenGate in production.
• Developed database schema on duplicated database to match Development's schema.
• Documented Enterprise wide schematic database and application schematic diagrams.
• Optimized database implementation on SAN using various RAID schema
• Perform schema refresh using export/import.
• Implemented certification program whereby successful candidates were given schema privileges to streamline development, taking work off of the DBA staff.
• Have hands on experience in remapping a schema and check for invalid objects and fix them after the schema is rebuilt.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Implemented database and Schema Replication using Oracle streams in order to share and propagate data, events, and messages.
• Performed Physical and Logical Design of the database include Database creation, schema tables-paces, tables and indexes creation.
• Create Database and schema objects such as Tables, Views, PL SQL packages, procedures and functions.
• Export and Import of Portal Schema using Transport Set utility and Oracle Internet Directory Users with LDIF utility.

Show More

• Performed daily database administration tasks: Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Monitored alert logs daily to determine errors and inconsistencies to ensure system operated at peak performance.
• Performed daily database monitoring and maintenance including viewing alert logs.
• Monitor trace/alert logs/disk space/process memory.
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Monitored database performance (V$ dynamic performance views at peak load) and viewing Alert log files & Trace files.
• Verified daily backup procedures and monitored alert logs and trace files for abnormal status, researched and corrected errors that occurred.
• Developed UNIX shell scripts to perform tasks like moving files, to manage alert log, perform backup efficiently and quickly.
• Maintain Oracle 11g DBMS configuration files such as Data file, Control file, Alert log and Redo Log files.
• Monitor overall health of the database, checking the alert log file and trace files for errors and instance performance.
• Maintained daily analysis of the oracle alert log and resolved issues of major concerns that were generated in trace files.
• Configured and managed Shell Scripts for alert log, Instance check, High Load & Backup scripts from remote server.
• Perform Daily monitoring of instances by database auditing, alert log and trace file checking and automatic script scheduling.
• Maintained redo logs and archive them to tape, monitor alert log, trace files and audit logs.
• Involved in writing UNIX Shell scripts for automating tasks such as Space monitoring, alert log monitoring etc.
• Monitor alert logs and backup reports, taking corrective action where applicable to pinpoint abnormalities in system data.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Administered, maintained, developed and implemented policies and procedures for Managing DB Security and alert log entries.
• Fixed corrupted pages, corrupted indexes, and monitored alert logs, and online logs for error messages.
• Monitored alert logs, trace files, partition tables and indexes for better performance of the database.

Show More

• Created and monitored SQL server database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Supported application development project team while migration to Production, as well as SQL optimization and post-implementation storm support.
• Complete installation of custom applications to user systems allowing access to data in PostgreSQL databases.
• Installed configured and documented SQL developer database software tool packaging for mass distribution.
• Created and customized databases using SQL Server Management Studio.
• Performed database recovery using SQL Backtrack.
• Developed procedures using Dynamic SQL.
• Designed and implemented data load process that is running two or more SQL* LDR together to improve oracle database loading capacity.
• Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADISOR.
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Use of DTS packages with VB script to have process that make data transformations between Oracle and SQL Server databases.
• Developed Reports and SQL libraries to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Implemented SQL programming inclusive of stored procedures, functions triggers, DTS packages, scheduled jobs, and linked servers.
• Used SQL * Loader to load the bulk data into the database for converting legacy databases to oracle formats.
• Tune SQL slow statement by collecting/setting cost based optimizer statistics and also using hints to accommodate some particular queries.
• Created business reports from Oracle Workforce Management databases using Crystal Reports and SQL Server Reporting Services (SSRS).
• Involved migrating database to SQL Server /, past data need to be imported to MS SQL SERVER /
• Provided expert support for the external clients for requests ranging from SQL performance tuning to entire database performance tuning.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Work with developers to assist with SQL Tuning and encourage the use of corporate standards in application development.

Show More

• Performed database administration functions including object sizing, Table space maintenance and overall disk space management.
• Provided estimation for new environment database storage with UNIX administrators for space managements on various servers.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Monitored Database Sizing, Table space Management, Transaction Management, and Security Administration.
• Perform other regular DBA activities including space management and performance monitoring under various loads.
• Reorganized databases and Sizing of database objects for effective space management and optimal performance.
• Perform capacity Planning and implementation, database space management, Table space management.
• Performed database performance tuning, space management, troubleshooting and other administrative tasks.
• Performed database monitoring and space management, reviewing and implementing schema design.
• Space management on development and test environment to facilitate uninterrupted data loading.
• Worked extensively on Database space management, performance monitoring and alert management.
• Performed other DBA activities like including space management and performance monitoring.
• Performed data object space management, user creation and privileges management.
• Perform other regular DBA activities including space management and performance Tuning.
• Table space management and capacity planning for optimal space utilization.
• Performed manual space management as necessary before ASM was initiated.
• Estimated space management backed up recovery, created database security.
• Space management and capacity planning for future requirements.
• Experienced in memory allocation and space management tasks.
• Space Management and Monitoring Backup and Recovery Services.

Show More

• Monitored and troubleshot top CPU/memory consuming processes.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions.
• Applied Critical Patch set Updates (CPU) to the Oracle homes which are recommended by Oracle to fix minor bugs.
• Apply CPU (Critical patch update) and PSU (Patch set Update) in QA, Testing and Development Environment.
• Explain plan for SQL statements which are figured out as bottlenecks of CPU or Memory in day to day database administration.
• Used Enterprise Manager on Oracle10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• Performed Database Tuning for Oracle 8i & 9i server's kernel parameters, SGA, CPU utilization and redo log tuning.
• Clone oracle applications and databases and e-Business Suite patch application including Security patches and Critical Patch Updates (CPU).
• Upgraded and applied CPU patches and bug fixes as and when required and troubleshooting Day-to-Day User issues in various modules.
• Monitored database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Monitored and provided weekly reports on the server's memory, disk and CPU I/O using UNIX command-line utilities.
• Set proactive schedules for Oracle DB reorganizations, server restarts, and Oracle Critical Patch Updates (CPU).
• Fulfilled DBA daily activities including monitoring alert log, memory, disk I/O, CPU, database network connectivity.
• Applied the Quarterly CPU Oracle patches to the development, test and production databases and oracle application servers.
• Implemented Oracle CPU quarterly patches, client software applications, initial Oracle software loads for 9i and 10g.
• Created database backups, restored recovery scripts performance tuning including Memory, CPU, SQL & I/O tuning.
• Apply quarterly CPU patches to fix vulnerability in different version oracle databases as well as upgrading these databases.
• Killed sessions using more than its allocated memory and communicated the progress of the CPU to tech leaders.
• Generated CPU Utilization, Memory Utilization and Database growth reports using Oracle Enterprise Manager (OEM) 12c.
• Identified bugs and applied required patches like PSU, CPU and Interim Patches as per the oracle recommendations.

Show More

• Scaled up the HP-UX Kernel to accommodate a very large user base access by tuning the semaphore handlers and processes.
• Installed and configured Oracle 10g/11g RAC high availability using ASM (Automated Storage Management) on HP-UX, SUN SOLARIS.
• Utilized tools Exceed , UNIX HP-UX Common Desktop Environment (CDE), and the java Oracle Storage Manager.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX and HP-UX.
• Maintained Oracle (production and test) database instance on various platforms such as HP-UX, Windows NT platform.
• Implemented a GB DSS environment running Oracle on HP-UX in a Sun VERITAS Cluster environment.
• Installed and configured Oracle 10g Database on HP-UX and Linux advance Server on Development Test and Production Systems.
• Served as an Oracle 7.x Database Administrator for managing 80 GB of data on two HP-UX servers.
• Documented and supported the builds of new clusters to use Oracle 10g RAC on HP-UX and Linux.
• Performed HP-UX system administration tasks on HP hosting instances, including major disk space reorganization.
• Migrated SAP databases from HP-UX to LINUX platforms using Data guard and Golden gate technology.
• Performed backup the HP-UX administrator, when he was unavailable I was the contract.
• Migrated the repository and prototyping environment from Sun to HP (HP-UX ).
• Installed, configured, validated and documented Oracle RAC on three HP-UX 11i clusters.
• Succeeded of Upgrading oracle applications from to R from HP-UX to Linux.
• Experienced with HP-UX in securing critical applications are always-on and without any compromise.
• Administered various Oracle Database instances on HP-UX and Windows NT platforms.
• Lead Consultant on Oracle 10g RAC implemented with Service Guard on HP-UX
• Performed Test upgrade from Oracle E-Business Suite to on HP-UX server.
• Planned and implemented upgrade of 20+ HP / series machines to HP-UX

Show More

• Provide verification/validation support during production environment and infrastructure deployments.
• Performed installation and configuration of Database software, Listener, Patching and Database creation in development, staging and production environment.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Nestle Business Services: This project involved database administration for various customers in Development, Test and Production environments.
• Involved from tool evaluation to performing drill scenarios for backups and recoveries and implementing same in every production environment.
• Worked on Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment.
• Gathered statistics, tested proposed changes to configuration/layout and recommended changes for Production environment to solve performance problems.
• Monitored and quickly identify issues within SAP production environment which led to quicker problem identification and resolution.
• Complete Database monitoring and performance tuning activities on Development, System test, Pre-Prod and Production environments.
• Review / provide recommendations and approvals for application / product change requests before implementing into production environments.
• Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.
• Provided on-call rotation support for critical requests and issues on Production environments where immediate assistance is required.
• Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested.
• Implement backup and recovery high availability for OpenPages on cloud in a production environment.
• Performed Application & Database Cloning of Production environment to Test & Development environment.
• Assist developers to migrate custom applications from current production environment to test environment.
• Refreshed production databases to non-production environments in collaboration with development and testing teams.
• Installed and configured SQL Server and Oracle Disaster Recovery solution in production environment.
• Monitored production environment to ensure potential issues are addressed before an outage occurred.
• Implemented Oracle Reporting database using snapshots, materialized views from production environment.

Show More