B Vamsi Krishna

Batchali VAMSI KRISHNA

Vamsi Krishna

Professional Background Over 7+ years of experience in Oracle DBA. Experience in Data Modeling, Design, Development & production support

Educational Qualification Bachelor of Engineering (B.E) Computer Science & Engineering

Technical Skills HARDWARE OPERATING SYSTEMS LANGUAGES Databases GUI TOOLS & UTILITIES DOMAIN KNOWLEDGE

: : : : : :

Pentium,RS-6000,RAC,RAID Windows NT, Sun-Solaris, Sco-Unix, HP UNIX, VAX/VMS, AIX PL/SQL,C,C++.Pro*C, Unix Shell Programming Oracle 7.x/8.x/9.x/10g, Oracle Applications 11i, Ms- Access Developer 2000,VB RMAN, Quest.com, Oracle Enterprise Manager, Erwin, Designer 2000, MS-Visio,Tkprof, RMAN,pro c,pro c++ : Logistics, Banking, government, Insurance

Professional and Project Experience Organization Duration Client Project Name Role Description

: : : : : :

Polaris Software Lab Ltd, Chennai Oct’05 till date In-house Intellect Consultant Intellect Lending 9.5.0 application was deployed in PACE SIT Environment by SEDBA and PVCS has been used for Version Control.

Project Details : Intellect Lending is a complete lending management product catering to various functions of Loan management. The product caters to Retail and Corporate Loans. The product captures all the information through out a loan life cycle. It supports various business requirements of lending; generating proposals, sales, booking, foreclosure, maturity closure, rescheduling etc. It caters to various business processes like delinquency, post dated cheques, standing instructions, top up loans, rollover loans, component rollover, charges & waivers and excess refund & excess adjustment etc. Responsibilities: • •

Configured Standby Database in manually managed mode. Shell scripts and Cron jobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements. Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls to GE-Capital Bank.

Page 1

Batchali VAMSI KRISHNA

Vamsi Krishna

•

By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning. • Performed Smoke testing during the installation of every full build for the Intellect Lending 9.5.0 application to validate the fitness of the application for testing. • Functionality testing has been performed against the identified modules. The testing was primarily intended to facilitate the Business Scenario execution, to identify the defects at the earliest so that the Business Scenario execution can be smooth. • The functional test cases do not cover inter-module integration, which was covered in the identified Business Scenarios • Programming in pro c,pro c++

Organization Project Name Client Role Duration Team Size

: : : : : :

Satyam computers Ltd Glass GE Money Bank, Austria Sr. Oracle DBA Mar’05 to Sep’05 5

Project Details : Pan Credit – a Lending software package was obtained by GE-GCF, to cater their Lending and Leasing Business needs. Suitable software modifications are made to the product to meet the requirements of GE Capital Bank, Austria. Satyam is entrusted with the maintenance of this product by GE-GCF. The maintenance includes activities like bug fixing, support during online and batch processing in the live environment, performance enhancements, software releases and configuration management etc., Production servers are located at Copenhagen. Satyam access the servers through GTN Link and provides offshore operations and Database Administration. All the three servers (Pan Credit production, Data warehouse, Test/Standby) are configured in Sun Clustering to make sure high availability of the system. In case of production down (one-node fails) the other node automatically takes over without notice of users. Disk mirroring (striping across the disks) is implemented for optimum performance gain. Cron jobs take care of switching from one node to another node in case of any failure. Verities Volume manager is used to configure Disk groups and Verities Net Backup R3.2 is configured to automate the physical Backup of the Database. CSC (Computer Science Corporation) is responsible for high availability of System and takes care of Operating System and Satyam co-ordinates with CSC for smooth maintenance of operations. Satyam is responsible for the following Page 2

Batchali VAMSI KRISHNA

Vamsi Krishna

1. Maintenance of three production databases and twelve Test Databases.(Size of each Database is 60 GB) 2. Database Administration. 3. Offshore Batch runs 4. Raising Change controls to CSC for necessary privileges or permissions. Responsibilities: • • • • • • • • • • • • • • • • • • • •

Configured Standby Database in manually managed mode. Shell scripts and Cron jobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements. Scripts are developed to monitor the growth of the Database and purging policy is implemented at frequent intervals by raising change controls to GE-Capital Bank. By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning. User names are changed to new names as per business requirement during migration time. Suggested for the Backup strategy as per affordable downtime of production system. Worked on Recovery manager to recover the Database. Also involved in SQL performance tuning. Creation of database links Estimating the size of Databases. Creating Databases Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4 Executing and monitoring offshore Batch run operations (End of the Day and Start of the Day of operations of GE-Capital Bank Monitoring Standby Database whether all the logs transferred to Standby site and applied properly. Checking the Alert Logs of production Databases for any errors reported by Oracle. Adopting change control Mechanism (Lotus Notes Server) for replicating the changes made to the production Databases. Export and Import of databases from one database to another databases. Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required. Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database) Attending specific requests from online, bug fixing, Bulk rate, Data warehouse Teams. Adhering the process as per GE Security guidelines.

Organization Project Name

: :

Satyam computers ltd Bplpg Page 3

Batchali VAMSI KRISHNA Client Role Duration Team Size

: : : :

Vamsi Krishna British petrolium Sr. Oracle DBA June’04 to Feb’05 8

Project Details : This project is in study phase which has to be implemented in 3 tier architecture. This project was implemented in backend oracle where data is taken from DB2 and Loaded in oracle Through SQLLoader and designed the database . Responsibilities: • • • • • • • • • • • • • • •

Database Design, Backup & Recovery, Tuning the Database and Analyzing the Database, Coding PL/SQL & Shell Scripts, Database Maintenance, Data warehousing. Database Design, Data Modeling using Erwin software design of medium/large business applications Design methodologies Database (SQL)design E-R Modeling. Design and Development Of database design Design/Code reviews

Organization Project Name Client Role Duration Team Size

: : : : : :

InfoTech Enterprises Ltd Logos Metro Retail Group, Germany Sr. Oracle DBA Nov'03 to May’04 40

Project Details : This Project is for the client Metro Retailer with more than 22,000. Outlets worldwide. Client already had application on FoxPro, which had to be migrated to oracle with Oracle Server as Back-end and Forms &Reports as Front End with Data warehousing. Scope included: Maintain Customer support Database, Testing Database, Design database.

Page 4

Batchali VAMSI KRISHNA

Vamsi Krishna

Responsibilities: • • • • • • • •

Database Design, Data Modeling using Erwin software design of medium/large business applications Design methodologies Database (SQL)design E-R Modeling. Design and Development Of database design Design/Code reviews

Organization Project Name Client Role Duration Team Size

: : : : : :

Indian Soft Technologies Customer Support Database Maintaince United Bank Of Switzerland, Singapore Sr. Oracle DBA Feb'03 to Oct'03 4

Project Details : There were about 50 different databases, which were residing on different platforms. The project aimed to monitor all the databases and provide customer support. For Maintaining the database Enterprise manager was loaded on Windows NT System for monitoring the space of tablespaces, Rollback Segments, Security For users, networking etc.., Online Backup's were preferred since database was running for 24 hours. Tape drives were used for storing the export files and system files like data, redo log files etc Responsibilities:           

The activities included the database administration of the various databases assigned to the division for the internal as well as external clients. Installation of the Databases, Environment Building to OFA compliancy Control File Maintaince Backup Cold, Hot, Online, Exports Performance Tuning Remote sessions tracing Recovery Manager (RMAN) Implementation and strategies Database Designing using ERWIN Various Database Recovery scenarios verification in advance Altering the Database objects and files during maintenance Implementation of RAC Technology

Page 5

Batchali VAMSI KRISHNA

Organization Project Name Client Role Duration Team Size

: : : : : :

Vamsi Krishna

Indian Soft Technologies Customer Support Database Maintaince Code Links Data Services DBA Nov'02 to Jan'03 6

Project Details : The parent company was having database of insurance company, where if any problem occurred, mails were sent with details. There was a direct connection to the database through leased line and telnet, from where database was assessed. For resolution rewriting and fixing the problem was done.. This database was present in Minneapolis USA, where they were using for Insurance Company. The data was published for online sharing Enquiry. The size of the database was about 20GB.Daily around 3 MB of data will be inserted inside the database. For Marinating the database Enterprise manager was loaded on Windows NT System for monitoring the space of table’s paces, Rollback Segments, Security for users, Networking etc.., Online Backup's were preferred since database was running for 24 hours and tape drives were used for storing the export files and system files like data, redo log files etc.., Responsibilities: • • • • • • • • • • • • • • • • •

Jobs Scheduling, Exports/ Imports, Space Management, Hot and Cold Database Backups and recovery Shell Scripting, Restoration Tuning Memory, SGA, I/O, OTIMIZATION,SQL-tuning ,Security Management, Remote Database Access Security management 24 x 7 Monitoring, troubleshooting and maintaining Database Recovery, Automation of the Database Start up and Shut down. Database Migrations, Writing Stored Procedures, functions, packages, triggers. The loops were developed to create the temporary tables, handle the records dynamically and This involved lot of records comparison for the selection as the best records needed to be updated as the final address for the client Snapshots creations and Refreshing, Managing the network and service changes on the network of the databases,

Page 6

Batchali VAMSI KRISHNA • • • •

Vamsi Krishna

STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables. Writing shell scripts. Loading data into the database from the flat files with SQL*Loader Implementation of RAC

Organization Project Name Client Role Duration Team Size

: : : : : :

Indian Soft Technologies Online Information Management System Hyderabad Race Club DBA July'02 to Oct'02 6

Project Details: The main aim of the project was to maintain the departments like Oracle HRMS, Oracle Payroll, Racing Accounts, Administration, Secretarial Department Accounts, Racing Accounts, Racing department, Tote, Civil Engineering & Electrical Engineering Privileges, Reports. Since the organization was working for 8 hours, it was recommended to take cold backups. The size of the database was about 100 GB and every day 15MB transactions were inserted. Daily Entire export was taken and stored in tape drives. Shell scripts were written for taking the entire database export and incremental exports. The total size of this database was about 50GB.Daily around 5GB of data was inserted. This database is on SunSolaris. Here database was replicated to another server. Whatever the data present in primary was updated to secondary. For the sake of reports organization used secondary database. If there was any problem in the primary database, secondary became online. There was a standby database for the development only some of the data were exported in this standby daily. Online Backup's were preferred for this database Daily export was taken. Hourly incremental and cumulative exports were taken Responsibilities: • • • • • • • • •

Contributed in Database Installations, Database Recreations, Moving the database on the network 24 x 7 support on pager call duty, Troubleshooting and Problem resolution Exports/ Imports, Hot and Cold Backups Shell Scripting, Restoration Space Management, Tuning Memory, SGA, I/O, Security Management,

Page 7

Batchali VAMSI KRISHNA • • • • • •

Vamsi Krishna

Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations Snapshots creations strategizing and troubleshooting DBA JOBS scheduling, monitoring and maintaining, Jobs scheduling with CRON TAB Altering the Database objects and files during maintenance

Organization Project Name Client Role Duration Team Size

: : : : : :

Indian Soft Technologies Computerization Of Ration Card Electronic Corporation Of India Ltd DBA Sep'00 to June'02 8

Project Details: This was one the largest Database where daily around 50MB transactions were getting inserting. The main server was running on Sun-Solaris Platform where Database was replicated for the Security sake. The total size of the database was about 500 MB of data. The main database was located at the headquarters from there around 20 places are connected to the central database through leased line. Every day there were roughly 0.5 GB data inserted inside the database. Every week all the data was taken into tape drives, with hot backups. Database was about 1 terabytes of data with 500 data files and tablespaces. Scope included Creating database, managing oracle instance, control files, redo log files, table spaces, data files, rollback segments, temporary segments, tables, indexes, roles, profiles, users, auditing Backup & recovery considerations, oracle export & import utilities Tunings the shared pool, buffer cache, redo log buffer etc., Responsibilities: • • • • • • • • • • •

Load data using SQL*Loader Scripts for Complete and Hot backup, Tuning the database, SGA sizing, Give technical guidance to team members. Create database-links, Create snapshots, views, remote procedure calls on the remote databases, Granting roles and Security Management using roles and privileges, Developing stored procedures, packages, functions and database triggers . Tune the complex SQL queries,

Page 8

Batchali VAMSI KRISHNA •

Vamsi Krishna

Develop Forms, Menus and Reports for VASP integration as well as other independent processes,

Organization Project Name Client Role Duration Team Size

: : : : : :

Indian Soft Technologies Vehicle Management Electronic Corporation Of India Ltd DBA Dec'99 to Aug’00 4

Project Details: Since the organization was working for 24 hours, it was recommended to take hot backups and tuning has been done. The size of the database was about 40 GB and every day there will be about 5MB transactions will be inserted. Daily Entire export will be taken and stored in tape drives. Shell scripts were written for taking the entire database export and incremental exports. Tuning was done for the database for better performance Responsibilities: • • • • • • • • • •

Maintaing the space for tablespace and rollback segments. Performance query tuning for SQL statements Auditing the database Maintaing standby database Replication implementation Distributed database for production and development Security policy, application architecture, interfaces, document sequence, flex fields Folders, report & form registration, form development, (template.fmb, appstand.fmb) Queries find windows, upgradition, cloning or copying, oracle alerts, and Installation Of Database

Organization Project Name Client Role Duration Team Size

: : : : : :

International Computers India Ltd Automated Timesheet system International Computers India Ltd DBA Oct'98 to Nov'99 5

Project Details : Since the organization was working for 24 hours, it was recommended to take hot backups and tuning had been done. The size of the database was About 40 GB and every day there will be about 5MB transactions were getting inserted. Daily Entire export was taken and stored in tape Page 9

Batchali VAMSI KRISHNA

Vamsi Krishna

drives. Shell scripts were written for taking the entire database export and incremental exports. Tuning was done for better performance. Responsibility: The activities included the database administration of the various databases assigned to the division for the internal as well as external clients. • Installation of the Databases, Environment Building to OFA compliancy • Control File modifications and Security • Backup Cold, Hot, Online, Exports • Performance Tuning • Remote sessions tracing • Recovery Manager Implementation and strategies • Database Designing with ERWIN • Various Database Recovery scenarios verification in advance • Altering the Database objects and files during maintenance

Personal Profile: Name as in Passport

:

Batchali Vamsi Krishna

DOB

:

20-02-1973

Passport No

:

F2745793

Place of Issue

:

Hyderabad

Valid Up to

:

2015

Type of Visa holding (if any)

:

H1B/B1 VISA

Date Of Issued

:

14-03-2005

Contact info

: [email protected]/91-0-9884491779

Page 10