Oracle Sql

Ramakrishna Tutupalli

Cell# 212-***-****

Status : EAD

Email : abnj0m@r.postjobfree.com

SUMMARY:

• Over sixteen (16+) years of experience in IT field and over 12 years in Design, Development, Deployment and

Administration of Oracle 7.x/8.x/9i/10g/11g Databases in UNIX and Windows environments.

• Over four (4) years in applications development using 'C', UNIX SHELL SCRIPTS, SQL, PL/SQL, PRO* C,

JAVA, JDBC, EJB, XML, C++, PERL, HTML, Oracle Developer/2000 & Oracle Designer/2000, ERWIN.

• Currently supporting Oracle 9i/10g/11g Databases of size Tera bytes for Web-based applications of

under 24x7 high –availability on Solaris 2.x/AIX 5.x/Linux servers for a leading Financial Company.

ORACLE HIGHLIGHTS:

• Oracle server Installation, configuration, Administration & Troubleshooting.

• Upgrades & Migrations

• Dataguard & Standby

• RAC & Oracle Streams

• Performance tuning & Data modeling ( ERWIN)

• Unix shell scripting & Advanced Replication

• Datawarehousing ( VLDB ), OLTP & Partitioning

• SAN & Veritas Netbackup.

• EMC symmetrix & BCV backup

TECHNICAL SKILLS:

Hardware:

SUN-ULTRA, Pentium-II, SGI Octane/O2, Micro VAX, HP 9000, SUN E5K/E10K, SUN 2900, IBM RS6000, DEC α,

HPLH6000R, SUN CLUSTER 2.2, SUNT5240, EMC Storage Devices,

Compaq Proliant, Pentium

O/S:

Solaris 2.x, SCO-UNIX, IRIX 6.x, Open VMS, WIN/2000, LINUX, NT 4.0, HP-UX 10.x/11.x, AIX 4.3 5.x, DEC UNIX

4.0, Win/9.x, NOVELL, Compaq Tru64

Languages:

C, SQL, PL/SQL, PRO*C, UNIX SHELL SCRIPTS, JAVA, HTML, PERL, C++, C#

RDBMS:

Oracle 7.1/7.3.4/8.0.5/8.1.6/8.1.7/9.2/10.2.0.3/11.1.0.6, SQL Server 7.0/2000, Sybase, Revolution 2000

GUI:

Oracle Developer/2000 (Forms 6.0, Reports 6.0), .net

CASE:

Oracle Designer/2000, ERWIN

Tools:

RMAN, OEM, SQL*Loader, Export/Import, SQL*Net, NET8

ERP:

Oracle Applications 11i, PeopleSoft 8.x, SAP, Oracle Financials 10.x

Others:

BMC SQL_BACKTRACK, RMAN, BMC PATROL, Quest TOAD, VERITAS, CRM, SIEBEL, Oracle Discoverer 2000,

NETBKUP, WebLogic server, ATG Dynamo, Quest SharePlex, IVR, Outlook 2000, MS office 2000

PROFESSIONAL WORK EXPERIENCE:

Sr. Oracle Database Administrator Sept’ 2008 – Till date

Bank of America securities, NYC

( Trading, Equities, Fixed income, Global Markets & Prime Brokerage)

• Installed, Configured & Designed oracle 9.2.0.6/10.2.0.3/11.1.0.6 on Solaris 2.x/Aix 5.x/RHEL 5.x servers.

• Supported 100 production & 200 QA/Dev oracle 10.2.0.3 databases for Trading, Equities & prime Brokerage

Applications on 24/7 basis for OLTP and Datawarehouse environments in Dataguard/RAC/STREAMS

Advanced replication/ASM/VCS/EMC SRDF configurations

• Implemented and Supported & troubleshooted Oracle 10g Dataguard & Broker in production environment

for Failover sites as well as performed DR test.

• Supported Credit risk datawarehouse of size tera bytes using partitioned tables and ETL using Informatica.

• Implemented and supported oracle 10g Streams replication between US & UK sites for Global markets.

• Designed, implemented & architected Portfolio tool build integrating countrywide, BoFA & Merril

trading data into common platform which is Oracle 10.2.0.4 running on RHEL5

• Managed Portfolio tool build project from Database requirements, backup strategy, storage

requirements

And implementing in Dev/QA/PROD/DR environments.

• Implemented and RMAN database backups ( Disk & netbackup tape ) and restored as per special request.

• Upgraded multiple oracle 10.2.0.3 production databases to oracle 10.2.0.4 and later applied april CPU 2009

patch.

• Migrated production databases from oracle 9.2.0.8 to 10.2.0.4 version.

• Migrated test database from oracle 10g to 11g and implemented oracle 11g new features.

• Extensively used AWR/ADDM/ASH/explain plan/Grid control and performed application and database tuning.

• Monitored database alerts using Foglight.

• Performed oncall support for every 6 weeks.

• Extensively used Datapump for database refresh

• Pro-actively provided Database support to application developers as well as customers for troubleshooting as

well as

Improving performance of the applications.

• Implemented multiple DB releases as per change control process for multiple trading & equity applications.

• Automated Database backups/Datapump export scripts using PERL & unix shell scripts.

• Implemented & supported Database security procedures for global trading databases.

• Extensively used Raw devices and unix filesystems for storing trading data.

• Extensively used OID for all Prod/QA/DEV databases in trading domain.

• Performed capacity planning for multiple production/QA/development databases.

• Guided offshore & onshore DBA team on Various DBA issues and activities.

• Performed BCV backup for VLDB databases.

• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end.

• Audited production/Dev/QA databases as well as compliance reporting.

• Monitored & resolved foglight alerts from Multiple production databases for various issues.

• Interacted & resolved issues with help of oracle customer support for TAR’s raised in metalink.

• Knowledge of SQL server databases and T-sql programming.

Environment: Oracle 9.2/10g/11g, SQL, PL/SQL on Solaris 2.x/AIX 5.x/RHEL

Sr. Oracle Database Administrator Aug 2003 – Aug’ 2008

Citibank, NYC, NY

Projects: Global Wealth Management (Private Banking, Smith Barney,

Legal and Compliance, Investment and Actimize)

• Installed, Configured & Designed and deployed Oracle 9i/10g databases on Solaris 2.x/Aix 5.x/Linux

servers in Production/UAT/ Development environments Globally

• Independently handled Production databases for Global Wealth management

Group (Legal & compliance, Investment Research, Private banking, Smith Barney

groups).

• Supported 150 production and 200 development databases for OLTP as well as

VLDB on 24x7 (ONCALL, OFF HOURS and BUSINESS HOURS).

• Planned & Designed Database Capacity requirement for various financial applications.

• Designed & Implemented Actimize vendor application in oracle 10.2.0.3 database on Solaris server.

• Designed & Created and architected Business Intelligence databases of size Tera bytes involving BI/ETL

tools.

• Managed BI / Actimize/ Risk system/BASEL/CCS/Legg Mason trading system Projects in Private

banking,

SB & Legal and compliance groups.

• Performed Data integration, Cleansing & transformation in private bank datawarehouse.

• Designed and implemented transactional/ODS and datawarehouse systems for Private bank and Legal &

Compliance groups.

• Implemented ETL solutions using Abinito and oracle procedures in transactional/ODS and datawarehouse

systems

• Extensively used pl/SQL blocks and conversant with bulk insert statements.

• Performed Data modeling using Erwin tool.

• Deployed & implemented various application schemas for multiple projects successfully in dev/UAT/Prod

Environments.

• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end.

• Implemented Security features like Roles & privileges in datawarehousing as well as

Transactional databases as per Database security guidelines

• Performed Database and Application Tuning using OEM/TOAD/Shell

scripts//STATSPACK/TKPROF/EXPLAIN PLAN/AWR/ADDM

Implemented Database releases in UAT/PROD environments as per Change control process

• Installed two node RAC software and configured databases.

• Extensively used srvctl, crs_, crsctl commands in RAC databases.

• Built parallel queries on RAC databases.

• Created services for various application needs.

• Applied various patches to RAC databases.

• Extensively worked in monitoring of databases for fragmentation, capacity planning, checking on errors in

alert.log files for ORA-600 & ORA-7445 and resolved thru’ metalink / SR’s.

• Extensively coordinated with storage/ SA teams for multiple projects in SmithBarney/PrivateBanking/Legal &

compliance.

• Extensively worked on Perfomance tuning of SQL queries and databases In Dev/UAT/PROD environments.

• Extensively used exp/imp, SQL*loader for logical backups and refreshing of Databases.

• Coordinated with Backup group for database backups using BCV and later

Used for COB test as well as for recoveries.

• Coordinated with Storage group for configuration of SAN to Databases on Solaris servers.

• Designed, Configured & tested CCS database ( SIEBEL CRM) in Oracle 10.2.0.2 in Dev/UAT/PROD

environments in EMC/SRDF mode.

• Implemented and supported Partitioned tables in all the environments.

• Extensively used RDA/streams for health check of databases.

• Implemented Shareplex for database replication in Oracle 10g databases.

• Extensively used vi, awk, sed and CRON utilities in day to day DBA activities.

• Implemented Oracle security patches for every six months.

• Followed Change control procedures for problem resolution and implemented DB releases in UAT/PROD

databases.

• Extensively used Export/Import & Datapump utilities for refreshing databases.

• Extensively used shell scripts for backups with Compression techniques.

• Implemented Oracle Streams for database replication for reporting as well as Batch loading puropose.

• Performed Database recoveries whenever required.

• Implemented Grid control & ASM in Oracle 10g databases in test environment.

• Implemented various Oracle 9i/10g features in development & Production databases.

• Automated Database shutdown & Startup and backups using Korn shell scripting

• Configured &Supported Oracle 9i/10g dataguard in production environment.

• Monitored & Managed Oracle 9i/10g databases using OEM/TOAD/GRID control & shell scripts.

• Monitored unix servers using various administrative utilities.

• Configured BMC SQLBACKTRACK/RMAN to Netbackup server for logical and hotbackups

• Documented the various database from Project study to Project went live as well as During BAU.

• Configured & tested Oracle 9i/10g databases in Dataguard mode including failover and switchover

modes.

• Guided, trained and managed 8 oracle DBA’s for multiple projects.

• Involved in setting up of backup jobs for FS and databases using Autosys scheduler

• Documented Design strategies of DBA projects.

• Designed & Architected Logical & Physical databases as per application requirements.

• Designed and implemented DB security procedures for different users as per Application requirements.

• Performed Cloning of databases as per request from the development team.

• Reorganized fragmented tables in production databases whenever required.

• Implemented DDL & DML as per the database releases in Production & development Environment

• Planned, Designed & Upgraded Oracle 9.2.0.4 databases to oracle 9.2.06.

• Planned, Designed & Upgraded Oracle 9.2.0.6 databases to oracle 9.2.0.8

• Planned, Designed & migrated Oracle 9.2.0.8 to 10.2.0.3

Environment: Oracle 9.2/10g, SQL, PL/SQL on Solaris 2.x/AIX 5.x/LINUX

Oracle Database Administrator Feb 2000 – July 2003

Worldcom, Colorado springs, CO

Projects: MALTS (OLTP)/METIS datawarehouse

• Administered databases of nearly 2 TB in size.

• Installed, Configured, & designed Oracle 8.1.7/9.2 databases On Solaris 2.x, HP-UX 11.x, AIX 5.x servers in

Production environment

• Established and maintained Oracle Advance security and integrity controls.

• Designed logical & physical data modeling and created high quality databases using

ERWIN tool.

• Designed, architected & Managed Logical structures like Tables, indexes, clusters,

Database links, Snapshots & physical structures like db files, log files.

• Replicated, monitored & managed Oracle 8.1.7/9.2 databases using Quest Shareplex

• Configured Users to Oracle databases using SQL*NET & Net8.

• Configured & Supported BMC PATROL on unix servers for database monitoring facility to SOS

• Configured & supported EMC RAID /SRDF on unix servers in SAN environment

• Monitored unix servers using administrative utilities

• Designed database tables using various normalization techniques and database Design rules.

• Supported Oracle production and development databases on 24x7 high -Availability.

• Provided On-call support for more than 100 production & 200 development Databases.

• Installed, configured BMC sqlbacktrack on Solaris 2.x servers to ADSM server for logical and physical

backups & performed Database disaster recoveries whenever required.

• Planned and performed database recoveries.

• Created Partitioned Tables, indexes & materialized Views in Oracle 8.1.7/9.2

databases as per specifications.

• Configured & tuned Oracle 8.1.7/9.2 databases for Multi-threaded Architecture for load

Balancing as per required for certain applications.

• Created database monitoring scripts in development & production boxes

• Created & implemented export & import and backup shell scripts as per specifications.

• Developed & tested 10000 lines of SQL, PL/SQL code in database triggers, stored procedures,

functions & Packages as per requirement.

• Performed Database & application tuning

• Planned, Designed & Migrated Multiple databases from Oracle 7.3.4 to 8.1.7

• Planned, designed & migrated multiple databases from Oracle 8.1.7 to 9.2.

• Configured & supported Oracle 8.1.7/9.2 production databases for distributed database option as per

requirements.

• Refreshed Oracle databases using Export/Import utilities on test, development & Production servers.

• Automated weekly & monthly reload of data into OLTP & Data warehousing databases using SQL*LOADER

in direct, conventional & parallel mode.

• Oracle application server/ 9iAS was installed & configured for high-availability

Databases using n-tier solutions for web-based implementation

• Configured & Supported Oracle 8.1.7 databases for parallel server using Sun Cluster 3.0

• Configured & supported Oracle 9.2 databases with Real Application Cluster option.

• Configured, implemented & Supported Oracle 8.1.7/9.2 databases for Multi-master, Standby,

Snapshot, Symmetric replication & Oracle Advanced replication as per Specifications from

Application staff.

• Configured OEM (performance & diagnostics) & DBA studio to Oracle 8.1.7/ 9.2 databases and monitored,

tuned, planned for Capacity of databases.

• Configured RMAN with veritas Netbackup to Oracle 8.1.7/9.2 databases for database backups & performed

Disaster recoveries whenever required.

• Cloned Oracle 8.1.7/9.2 production databases as per specifications.

• Configured & tested BEA Weblogic server & JDBC in J2EE for Oracle 8.1.7/9.2 Databases and

implemented Web-Based applications.

• Reorganization of databases (Tables, Indexes & clusters) performed as and when required.

• Configured & supported Oracle production databases for Intermedia option.

• Configured & supported Oracle 8.1.7/9.2 databases using two phase commit and Data synchronization.

• Implemented Oracle Standby/DataGuard databases on Oracle 8.1.7/9.2 as per specifications from

Mission critical application staff.

• Configured & tested Oracle 8.1.7/9.2 databases for Advanced Queuing as required by certain applications.

• Monitored Oracle 8.1.7/9.2 production databases using Quest Toad, DB-Artisan, spotlight

• Documented Oracle production databases as per DBA standards.

• Configured & supported Oracle 8.1.7/9.2 production databases for Oracle LDAP & Oracle internet Directory

option.

• Configured & tested Oracle 8.1.7/9.2 databases in failover mode as required for certain Applications.

• Hiring of new Consultants

• Guided junior level DBA's in advanced DBA activities.

ENVIRONMENT: ORACLE 8.1.7, 9.2, SQL, PL/SQL on Solaris 2.x, HP-UX 11.x, AIX 5.x

Sr. Oracle DBA/Developer March 1999 – Jan 2000

National Remote Sensing Agency, Hyderabad, India

Project: Integrated Information Management Software

Developed and tested 40000 lines of SQL & PL/SQL code required for Stored Procedures, Triggers, functions and

packages and deployed the application with Oracle 8.0.5 as backend. IIMS is basically designed for data

management of various series of satellites (IRS, SPOT, LANDSAT, ERS). This data is processed and maintained in

a very large database ranging several gigabytes. It automates entire production environment of Data product

generation, starting from user order processing to until the product is dispatched to the user. By generating

/providing necessary decision making reports and graphical charts to the management and reducing the turnaround

time of data product generation

Environment: Oracle 8.0.5, SQL, PL/SQL on Solaris 2.x servers

Oracle Database Administrator March 1994 – Feb 1999

National Remotes Sensing Agency, Hyderabad, India

Project: OLTP: DPS

• Installed, Configured & designed Oracle 6.0/7.1.1/7.3.4/8.0.5 databases on Solaris /

SCO/HP-UX /windows 3.x/95/98/NT Servers

• Configured, implemented & supported Oracle Web servers 3.x to Oracle 7.3.4 databases for supporting Web

based applications

• Created logical and physical database as per specifications.

• Created database tables using various normalization techniques &Database design rules.

• Performed logical data modeling using Designer/2000 tool.

• Configured & tested SQL*NET & NET8 from database to user end.

• Established and maintained database Security and Integrity controls

• Migrated Oracle Databases from Oracle 6.0 to 7.0

• Migrated Oracle production databases from Oracle 7.3.4 to 8.0.5

• Automated data loading into database tables from ancillary files using SQL*LOADER.

• Created and implemented logical & physical backups

• Established database recovery procedures

• Managed & monitored the Database space requirements.

• Developed & tested 50000 lines of Database triggers, Stored procedures,

Functions, and Packages as per requirement from project specifications

• Performed logical exports and imports of database, users, and tables as and when required

• Supported Oracle Production and development databases on 24x7

• Provided ON-CALL support for more than 200 production and 300 development databases.

• Performed automatic monitoring of users, tablespaces, tables, indexes & auditing of database.

• Developed and implemented database & application tuning strategies

• Reorganization of database performed periodically for best performance.

• Configured & supported Distributed Databases on Oracle 7.3.4/8.0.5

• Configured & supported Oracle 7.3.4 /8.0.5 databases for Parallel server.

• Configured & supported Oracle production databases for snapshot & symmetric replication.

Environment: Oracle 6.x/7.x/8.x running on Solaris /SCO/HP-UX /windows 3.x/95/98/NT

Programmer/Analyst Nov 1992 – Feb 1994

National Remote Sensing Agency, Hyderabad, India

Project: DiskLoad (Device Driver)

Developed & tested 60000 lines of UNIX shell scripts (device drivers) for transferring remote Sensing raw (digital)

data from high density digital tape recorders through Frame sync and decomm unit into SUN ULTRA computer

required for further processing.

Data is transferred in bytes from High-density digital tape thru ‘FSDU and SCSI unit to SUN ULTRA. Start time and

stop time of disk load data depends on Sensor type associated in data.

Environment: Solaris 2.x on SUN ULTRA

Developer & QA Engineer June 1991 - Oct 1992

National Remote Sensing Agency, Hyderabad, India

Developed software programs in 'C' language for converting Remote sensing digital data into imagery data for

display purpose as well as for transferring data into computer media.

• Backup of system & application software taken periodically.

• Developed software programs in 'C' language for downloading accession information from CCT media to IIMS

database.

• Performed Remote Sensing data processing on VAX/VMS & Unix based computers

• Developed & tested 5000 lines of ‘C’ code in Display programs for providing Image display of

Remote sensing data.

Environment: SCO – Unix, C’ on SCO Unix based computers

EDUCATION:

Special Diploma in Electronics Engg. Govt. Polytecnique, Hyderabad, India

BS, Electronics & Telecommunication Engineering, New Delhi, India

Contact this candidate