Suneel Chittiboyina

Oracle Database Administrator @Hewlett Packard Enterprise

Hyderabad, IN

Provided 24/7 support for all the production and development databases.• Installation and configuration of Oracle 10g and 11g databases.• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.• Responsible for installing, migrating, patching and configuring the Oracle environment.• Generate AWR,ADDM & ASH reports in order to analyze the Database performance on a Daily Basis.• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.• Create Database Links from one database to another in order to access data (DB objects) on the CR.• Performed large batch jobs, and tuning of SQL queries and database systems.• Created User accounts, Roles and granting required access permissions and privileges to the users.• Partitioning and re-organization of tables and Rebuilding of Indexes for reclaiming the space.• Responsible in configuring and backing up an oracle database by using Cold backup.• Add/resize/rename/remove data files to add additional space to tablespaces to avoid threshold limit.• Provided support to Application Database Administrators in designing the database.• As per the End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, synonyms, procedures and schema refreshes and maintain Track sheet for them.• Issues related to Space Management, Tablespace Management, User Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.• Maintain Daily Checklist on a Hourly Basis and DB & Log file sizes of DB and SQL Database servers.• Maintain Audit Report, DB Daily Dashboard Report and Daily Backup Dashboard Reports of all DB’s.• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring the growth in all the databases.• Configured scripts to monitor activity with database.