BALAKRISHNA Oracle DBA balakrishnadba@gmail.com PROFESSIONAL SUMMARY • Around 7+ years of IT-experience with a strong command over Oracle Database Administration & Development on Windows, UNIX, sun Solaris and Linux Platforms. • Expertise in Oracle Database Administration (all versions of 8i, 9i, 10g) i.e. Installation, Up gradation and Configuration, Creating Databases, tablespaces, tables, data objects, Users/Roles, setting privileges, indexes, user logins/passwords, installing and configuring Recovery Manager RMAN, Analysis of Process requirement, Database Performance optimization, Database Tuning. • Oracle 10g, 9i, 8i, 8.x, 7.x Database Administration, Backup and Recovery, Performance Tuning, Network Administration, Standby Database, Oracle Parallel Server, Replication, OEM (Oracle Enterprise Manager), Data Warehousing, Resource Management. SQL*Loader, RMAN, Recovery Catalog, Designer 2000, Oracle Developer 5 and 6, SQL*Plus, PL/SQL, Data Modelling, Administered the Oracle Data warehouse. • In-dept knowledge of Database and System Tuning using STATSPACK, UTLBSTAT and UTLESTAT scripts. Query Optimization; Explain Plan, ADDM, and AWR. • Proficiency in script management and tuning complex SQL statements for better performance levels of execution. • Extensive experience in setting configuration parameters for optimal performance • Performance tuned the Oracle Databases. Developed Backup and Recovery Strategy. Developed scripts for Hot and Cold Backup using RMAN. Recovered the database in case of System or Media Failure. • Managed Tablespaces, Data Files and Database Growth. Performance Tuned the ORACLE Database and significantly improved the ORACLE Application Response Time. • Monitored, tuned, sized, analyzed, defragmenter and migrated Large Databases. • Database Performance Monitoring, Database Performance Tuning. • Expertise in PL/SQL coding for creating Packages, Procedures, Functions and Database Triggers. • Developed scripts for Hot and Cold Backup and Database Refresh. • Developed SQL*Loader, PL/SQL, and Import Scripts to facilitate the conversion. • Experience in configuration and implementation in the RAC environment. • Database Cloning, Hot & Cold back up of database. • Recovered the database in case of System or Media Failure. Administered SQL*Net v2 • Design and implement backup methods and disaster recovery strategies. • Extensive experience in shell scripting. Administered Disks and RAIDs using VERITAS Volume Manager. Created, Removed, and Resized Volumes. • Disk space management, handling Mount point for 100+ databases. • Monitor Database growth & provide Database capacity planning for applications expansion. • Installed and Configured Oracle Enterprise Manager (OEM) for Oracle Express and with Performance Pack. Did Enterprise-wide Oracle Database Administration and Monitoring using Oracle Enterprise Manager (OEM). • Installation of Windows, UNIX, sun Solaris and Linux Operating Systems, Oracle products like Oracle8i/9i/10g, Developer2000, WebDB, and other allied Software’s, Patches & Drivers on Client & Server systems. • Excellent understanding of SDLC, Data modeling, Software Project Management, software metrics, Software testing, Software quality, Software maintenance. TECHINICAL SKILLS Operating System: HP-UX 11.0, Sun Solaris 2.x, AIX 5.2, Red hat Linux AS 2.1, 3.0 AND WINDOWS 2000 Server/Advanced. Databases: ORACLE 7.X, 8.0.X, 8i, 9i and 10G. Scripting/Lang: PL/SQL, SQL, SQL*Plus/iSQL*Plus, ABAP/4, C & C++, HTML, DHTML. Shell scripting, core java. Tools: OEM, RMAN, Load Runner, Export, Import, Data pump. Business Objects5.0, Discoverer, Oracle Reports 3.0, 2.5, and 1.1, TOAD,SQLloader. PROFESSIONAL EXPERIENCE: Daymon Worldwide, Stamford, CT----------------------------------------------------Since JUN ’07 – Till Date Database Administrator: Roles & Responsibilities: - • Working as a DBA using Oracle 9i & 10g Database Management Systems. • I’m responsible for administering and maintaining the Databases for optimal performance on different platforms. • I’m Responsible for Handling Backups, Locking related problems, managing disk space against mount points, interacting with Unix Support team. • Involved in Designing, Implementation, Administration and Tuning of Oracle. • Involved in maintenance of existing scripts and enhanced the performance. • Coordinated with developers in tuning long running SQL queries to enhance system performance. • Responsible for Installation, Configuration and Administration of Oracle 10g, Oracle Express Server. • Enrolling users and maintaining system security. • Responsible for configuring the clusters in the organization. • Controlling and monitoring user access to the database. • Monitoring and optimizing the performance of the database. • Developed pl/sql wrapper packages for optimizing the performance of the database. • Planning for backup and recovery of database information. • Interacting with other persons/departments concerned with Database like Network Administrators, Application Developers, Application Administrators, Database Security officers, Actual Database users etc. Responsible: Database Management: - Management and multiplexing of control files, Redo Log files, Datafiles. Maintaining database Security and Manages Profiles and Users. Disk Space Management: - Setting storage parameters of Objects accordingly, Managing undo Segments, Managing Table Space, Analyzing & Estimating Storage of Object, Taking care of Mount points. Re-organization of entire database: - In Order to remove the Tablespace Fragmentation & thus Enhancing the Performance of the System and for the re-organization of the database the following major activities were Exported the entire database, Made the Index Script. Recreated separate table space for Index & Tables with Proper Sizing, Estimated the size of all the objects, Recreated and partitioned the objects in the Schema, Imported the database. Application Tuning: - For better Performance & best throughput of the Application, the major activities were: - 1. Explicitly assigned a large undo segment for large Transactions. 2. Checking of Index / Full table scan by using Explain Plan Utility & increase the performance of the Query accordingly. 3. Developed pl/sql packages for optimizing the performance. 3. Setting of the Object Parameters for Best Performance. 4. Observing the Row chaining & eliminating it. 5. Analyzing the Objects & Gather Statistics to tune the application. Database Cloning: - Test database configuration changes, database migrations, database backups through suitable method(s) without adversely affecting a production system. Installation and Up gradation: 1. Worked in database administration and Upgraded Database from 9.2.0.1.0 to 10.1.0.4.0. 2. Introduced distributed database procedures with a distributed database at all the Plants connected to a central database, to reduce Network traffic. 3. Linking of various databases (Distributed database processing). Taking care of day-to-day open tickets, Handling Backups, Locking related problems, managing disk space Against mount point, interacting with Unix Support team. Environment: Oracle 9i/10g, AIX 5.2, LINUX AS (2.1/3.0), RAC, RAID, datapump Import/Export, OEM, SQL*LOADER, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL, ADDM, and AWR. CAPITAL ONE, Richmond, VA ---------------------------------- APRIL’06-JUNE’07 Database Administrator: ROLES & RESPONSIBILITES: • Installed, configured and maintained Oracle 10g Real Application Cluster (RAC) for high availability. • Set up and maintained oracle disaster recovery site using DataGuard. • Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security. • Utilized RMAN for backup and recovery strategy. • Completed export and import of different databases using Oracle Export / Import utilities • Table fragmentation tuning, partitioning the large table by date. • Installed, configured and maintained Oracle database 10g, and upgraded Oracle 9i to 10g. • Used Oracle backup utility RMAN to implement Oracle backup and recovery strategies. • Provided all kinds of DBA support to development teams as well as production support to various applications. • Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers. • Trouble shooting and resolving any database and/or application issues or errors that occurred. • Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK. • Monitored the various database activities by developing shell scripts and using various tools. • SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor. • I was part of High availability database configuration and maintenance using VCS (VERITAS clustering services) fail over and Data guard (standby databases). • Patched Oracle Database Server 9i and 10g using Opatch. • Established database backup/recovery strategy for different databases. • Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure. • Setup and support of Oracle replication(replication and conflict solution). • Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement. • Developed scripts to monitor the storage usage, object status for daily job. • Monitored alert log file, monitored tablespaces and partitions that span across several tablespaces. • Worked with IT managers and application developers to ensure the database integrity, high availability and security. • Configured Single Sign-On (SSO) and Oracle Internet Directory (OID) to increase security and lower cost. • Refreshing and manipulating data in tables using PL/ SQL procedures. • Written stored procedures, functions and triggers. • Testing, Debugging and Documentation. • Writing Database Triggers. • Performance monitoring and tuning. • Analyzing tables and indexes for performance tuning. Environment: Oracle 9i/10g, HP-UNIX 11.0, Toad, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL. CONVERGYS Lebanon, NJ--------------------------------------------------------------------------MAR ’04 TO APRIL ‘06 Database Administrator: Roles & Responsibilities: • Created Oracle Test Environment server to test new software and patches before applying to the production server. • Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. • Documented every aspect of the DBMS environment, including hardware configuration, record maintenance, software updates, DBMS and application changes, and all other items related to changes made to the system. • Execute and tune Oracle queries. • Clustering and Load Balancing. • Migration of Oracle database from Unix to Windows 2003 Server • Apply cumulative Oracle patches. • Responsible for the evaluation and implementation of Oracle alert monitors. • Develop and implement backup/recovery script using RMAN. • Perform stress testing using DTM data generator. • Monitor database growth and provide database capacity planning for apps expansion. • Monitor and optimize the performance of the database and offering assistance to developers in optimizing their applications, queries, etc. • Replicated the Database server for testing environment purposes. • Provide excellent level of service by anticipating the future needs of users and perform capacity planning and sizing to meet increased loads. • Conduct Software support testing before applying to the Production Server. ENVIRONMENT: SUN SOLARIS 2.8,, Linux, Dell Power Edge Advance Server, Dell SAN Systems, DLT Tapes, Oracle 9i RAC Borders Group Inc Ann Arbor, Michigan---------------------------- MAR’03 – MAR ’04 Database Administrator: Roles & Responsibilities: - • Worked as an Oracle Database Administrator for Oracle database 9i, and instances running on Solaris and WinNT environment. • Installation, Configuration and Administration of Oracle 9i on NT & Linux environment. • Involved in managing Data Files, Control Files, Redo Log Files, and Initialization Parameter Files at physical database level. • Managed Tablespaces, Tables, Indexes, Synonyms, Sequences, Users and undo Segments at logical database level. • Migrated SQL Server databases to Oracle using Oracle Migration Workbench. • Used Database Configuration Assistant for Database creation. • Extensive expertise in maintaining security by creating profiles, assigning roles and implementing connect.ora file. • Setup Net8 connectivity between various computers. • Administered Oracle databases at physical and logical levels. • Designed and was responsible for Backup and Recovery of Database. • Developed SQL, PL/SQL scripts for various events in the database. • Tuning of clients Oracle environment, including Oracle, UNIX. • Tuning of SQL application embedded SQL statements, triggers, functions and procedure. • DBA work on Test, development, training and QA databases, scripting, debugging, trouble shooting, advising developers. • Database creation and Tuning consulting, Application Tuning (internal and for external clients) • Installation of the client software, Debugging, Tuning and also upgrading of client application, Oracle Server, Conversion of data, Exports/Imports, Data load. • Responsible for preparation of Oracle DBA course material to be used at client site. • Educating client IT staff; which included general Oracle RDBMS architecture, Database • Creation and Design, Backup and Recovery. Environment: Oracle 9i sun Solaris 2.6, HP-UNIX 11.0, Developer 2000, Designer 2000, RMAN, Diversify, Exp/Imp, Server Manager, SQL*Loader, TKPROF, Shell Scripts and kron Scripts CISCO, California-------------------------------------------------------JAN’02 - MAR’03 Database Administrator: Roles & Responsibilities: - • Worked as an Oracle Database Administrator for Oracle database 9i, and instances running on Solaris environment. • Installation, Configuration and Administration of Oracle 9i on Solaris environment. • Up gradation to 9i UNIX platform. • Involved in managing Data Files, Control Files, Redo Log Files, and Initialization Parameter Files at physical database level. • Managed Tablespaces, Tables, Indexes, Synonyms, Sequences, Users and undo Segments at logical database level. • In-dept knowledge of Warehouse Logical and Physical Design. • Used Database Configuration Assistant for Database creation. • Extensive expertise in maintaining security by creating profiles, assigning roles and implementing connect.ora file. • Setup Net8 connectivity between various computers. • Administered Oracle databases at physical and logical levels. • Designed and was responsible for Backup and Recovery of Database. • Expert level knowledge in SQL, PL/SQL and RDMS Concepts. • Tuning of clients Oracle environment, including Oracle, WinNT. • Tuning of SQL application embedded SQL statements, triggers, functions and procedure. • Database creation and Tuning consulting, Application Tuning (internal and for external clients) • Installation of the client software, Debugging, Tuning and also upgrading of client application, Oracle Server, Conversion of data, Exports/Imports, Data load. • Responsible for preparation of Oracle DBA course material to be used at client site - • Training/guiding client IT staff; which included general RDBMS architecture. • Creation and Design, Backup and Recovery. Environment: Oracle 9i, SUN SOLARIS 2.8, LINUX AS (2.1/3.0), RAC, RAID, Import/Export, OEM, SQL*LOADER, RMAN, STATSPACK, EXPLAIN PLAN, TKPROF, SQL, PL/SQL, and Windows NT/2000 AccuMed Billing, Inc., MI-------------------------------------------------------- FEB’01- JAN’02 Database Administrator: Roles & Responsibilities: • Worked on creation of databases, table spaces and users and development of production system architecture. • Automated the database creation using UNIX and SQL scripts • Set up logical and physical backups for these databases and wrote shell scripts for different kinds of backups • Monitored the databases using tools like Oracle Enterprise Manager and spread data among several disks to balance the I/O • Granted roles and privileges to users • Migrated Production database to higher releases using Migration utility and Exp/Imp tool • Monitored the data fragmentation on data files, rollback segments and performed periodic export and import to avoid fragmentation • Implemented basic replication in populating tables in databases used for archiving of data and reporting • Implemented Oracle Advanced Replication using snapshots, materialized views, and multimaster and refresh groups. Environment: Oracle 8.x, HP-UNIX 11.0, Win-NT/2000, replication, SVRMGR, replication, OEM, Erwin and Web Logic 4.5 Ocean Computers Globe, India--------------------------------------- OCT ‘00– JAN‘01 Database Associate: Roles and Responsibilities: • Installation, Upgrade and Configuration, Maintenance of Oracle 8i Database, Windows and Linux Operating Systems, allied Softwares & Drivers. • Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security). • Creating and supporting different development databases/instances. • Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration. • Space Management which includes table space creation, adding new datafiles. • Managing Import and export procedure. • Daily & Weekly Backups of Data i.e. hot/Cold backups. • Running various Data Recovery procedures in case of various kinds of failures. • Removing row chaining and Row migration for better performance. Other than this, I am also responsible for: - • Interaction with the Client to identify the requirement of the User/Clients representatives. • Analyze the existing systems and suggesting a new optimal system. • Evaluating the relative technical merits of alternative Computer or Software systems. • Working with System Analyst/development Team. • Commercial and complex Softwares installation, up gradation, troubleshooting. • Installation of Oracle 7,8i and D2K at client Server. Environment: Oracle 7.X/8i, AIX4.3, SUN SOLARIS 2.x, OPS, Import/Export, EXPLAIN PLAN, PL/SQL, and Windows NT