Manager Oracle

Krishna Baddam

Oracle Database Administrator

******.*****@*****.*** PH: 312-***-****

SUMMARY

Over 4 years of experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux and Windows platforms.

• Experience in Configuring Single instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM).

• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.

• Experience in Performance tuning of oracle databases using Oracle Grid Control, STATSPACK, and tuning of SQL scripts using SQL Trace and TKProf

• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.

• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

• Excellent experience in various migration techniques like export/import, Datapump, backup restore, cloning, and data guard.

• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.

• Used ADDM (Automatic Database Diagnostic Monitor) AWR (Automatic Workload Repository) for analyzing the database performance and tuning.

• Creation and maintenance of database Standard Operating Procedures (SOP's). Experience with OLTP and batch processing in a large data processing environment

• Migrated single instance databases to multimode 10g/11g RAC environment for high availability and load balancing.

• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.

• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.

• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.

• Knowledge of Data Normalization and its normal forms.

• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.

• Experience in understanding business requirements for analysis, detailed design, database design & development of applications. Worked with various projects in large enterprise projects.

TECHNICAL SKILLS

Operating System : Red Hat Linux RHEL 2.1,3.x, 4.x ,5, Sun Solaris 9.0/10.0, and Windows 98/NT/2000/2003, HP-UX, IBM-AIX 5L.

Programming Languages: Java, PL/SQL, UNIX/NT Shell Scripting

Databases : ORACLE 7.x/8.x/9i/10gR2, RAC/11g/10g

Terminal Emulation: Putty, Telnet, Cygwin

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools & Utilities : RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM,

SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET

ODBC, Oracle Streams, Data pump, Data Guard, VMware

Methodologies: ER-Diagrams, UML, OOAD

Version Control: CVS, SVN, Perforce

J2EE Technologies: EJB 3.0,XML, XSL, XSD, Servlets, JSP, HTML, Ajax, JDBC and Taglibs.

IDE’s: Eclipse2.1,3.2, RAD 7.0

PROFESSIONAL EXPERIENCE:

Infosys Limited, Los Angeles, CA Feb‘12 –Till Date

Role: Oracle DBA

Infosys Limited is an Indian provider of business consulting, technology, engineering and outsourcing services. It has offices in 30 countries and development centers in India, US, China, Australia, UK, Canada, Japan and many other countries.

Responsibilities:

• Manage data architects, data administrators and client enhancement requests.

• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.

• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.

• Created tablespaces, tables, users for custom applications.

• Created and managed database objects such as tables, indexes, partition tables and views.

• Creation of Materialized views and partitioned the oracle tables to improve reporting performance

• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.

• Created and managed users, roles, privileges, profiles, schemas using OEM.

• Handling large database environments (Data warehouse) using ETL tool Informatica and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.

• Creating and rebuilding indexes and optimizing the code to improve the performance.

• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.

• Backup and recovery procedures using RMAN.

• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.

• Wrote Shell Scripting for managing day-to-day activities and automation of backup.

• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.

• Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.

• Experience ensuring the high availability and integrity of databases.

• Worked on Automatic Storage Management (ASM) for managing data in SAN.

• Wrote PL/SQL Procuders, functions, packages for various requirements in the database.

Environment: HP -UX 11.23, Linux 4.0, Windows 2003, Streams, ASM, Informatica, Business Objects Oracle 10g/9i , SQL*Plus, OEM, TOAD

Thomson Reuters, Chicago, IL May‘11 – Jan ‘12

Role: Oracle DBA

Thomson Reuters is the world’s leading source of intelligent information for businesses and professionals. It is also the industry leader in health care data, has created a family of healthcare indexes to meet the demand for information about United States healthcare trends, including consumer confidence, healthcare spending and workforce health

Responsibilities:

• Installed and configured oracle 10g and 11g on Solaris.

• Performed upgrade of oracle database from 10g to Oracle 11g with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.

• Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods.

• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

• Worked on database design, creation and configuration, space management and other database maintenance procedures in a multiple oracle production and development environments.

• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.

• Performed Data migrations from CSV/flat files using scripts and SQL Loader.

• Developed automated scripts for database creation and builds.

• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.

• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.

• Creating batch files and automating the tasks.

• Granting roles and privileges to end users.

• Scheduled various job using UNIX Crontab utility.

• Worked on import/export and Datapump utility.

• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.

• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.

ENVIRONMENT: Oracle 10g/11g RAC, SQL Loader, Windows 2008, Sun Solaris 10, FTP, putty, OEM Programming Language/Tools: TOAD, PL/SQL

Motorola Mobility, Libertyville, IL Dec‘09 – Mar’11

Role: Oracle DBA

Motorola Mobility is a diversified Mobility services company with operations around the world. It makes Android smart phones, tablets etc. I worked upon Projects dealt with Moto blur. It syncs all your friend’s pictures, emails, messages, Picasa, Face book, Twitter happenings, status etc at one place. Primary job was to provide support for several ongoing projects, in designing and implementing backup strategies. Also responsible for tuning the database to ensure high availability and high performance

Responsibilities:

• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.

• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases

• Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.

• Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager).

• Upgrading from Oracle 10g to Oracle 11g database

• Install and configure Database as of Oracle’s Optimal Flexible Architecture (OFA).

• Mentored and provided oversight and backup for the production Databases.

• Supported Test Databases for testing and research work

• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

• Used Flashback feature to recover a dropped table and also to recover a database.

• Performed a proof-of-concept of Oracle10g and Oracle11g databases on single RAC Cluster 11g.

• Involved in Capacity planning meetings & operations.

• Automating the daily routine activities backups using the DBMS_JOBS, DBMS_SCHEDULER.

• Monitoring of the queries with high response time and high disk reads per execution (Top SQL) and tuning the same using TKPROF, Auto trace.

• Used Automatic Workload Repository (AWR) for analyzing the database performance.

• Use TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.

• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.

• Implemented Change Control for the Production Databases as and when required.

• Communicated with Oracle support via the Metalink in order to troubleshoot important issues.

ENVIRONMENT: Oracle 10g and 11g, Sun Solaris 9, Windows 2008, Oracle Enterprise Manager – OEM (for monitoring the database), SQL Navigator.

Bharat Petroleum, Hyderabad, INDIA Apr‘08 – Aug ‘09

Role: Oracle DBA

This project involved the development of Inventory Control System for BPC; a corporation that

Specializes in the production and sale of pneumatic products. Required to develop modules to encapsulate the business transactions such as the activities of Stores, Purchases and Goods Inward departments.

Responsibilities:

• Creation of the Development, Test and Production Oracle 9i databases.

• Part of Migration team from 8i/9i test databases to 10g, my role was to test the migrated database in different scenarios with different loads, test different new features of 10g and how can we take advantage of those new features.

• Setting up and configuration of database with 10g in RAC environment with data guard.

• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN and Data Guard in RAC environment.

• Team member of Strategic planning team was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.

• Cloning of production database to the test environment using Recovery Manager (RMAN).

• Database Administration & Planning including logical design, physical design, backup & recovery.

• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.

• Setting Oracle Streams for bi-directional replication between two databases. Worked with application developers on setting of 9i advanced queuing for data transfer between various applications.

• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.

• Experience working with XML files, edited the XML document which were associated with the ORM tool HIBERNATE to configure and tune the queries.

• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.

• Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup.

• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.

• Documentation of Data Base Setup and administration of Server Environment.

Environment: Oracle 8.1/ 9.2.0/ 10.1/11, SOLARIS 8/9, AIX 5L, SQL, PL/SQL, Putty, TKPROF, Designer 2000/6i, Erwin Tools 4.5, TOAD 7.6, SQL*Loader, TDP 5.2, Legato Media Manager, RMAN, RAC, 9i Advanced Queuing

EDUCATIONAL QUALIFICATIONS:

• Masters of Computer Science, Illinois Institute of Technology, Chicago, IL, USA.

• Bachelor of Technology in Computer Science and Engineering, Jawaharlal Nehru Technological University, India

Contact this candidate