[Send email to request phone number] 78-7457
KRISHNA JAMMULA
SUMMARY
11+years of US experience in software industry with emphasis on Oracle
6.0/7.1/8.0/8i/9i/10g
Having around 5+ years of strong experience in Oracle 8x,9i and 10G Database
Administration, proficient in managing Development, Test and production
environment.
Handled the database administration activities and have good knowledge in
oracle internals and worked with events 10046(CBO).
Proficient in Installation, Setup, Configuration, Maintenance and Tuning of
Oracle 8i / 9i / under UNIX (Sun Solaris, LINUX Enterprise server 2.4, IBM AIX
servers ) and Windows NT/XP environment.
As a DBA, I have taken numerous Oracle implementations through full
infrastructure and performance optimizations including I/O optimization, SQL
Tuning and backup and recovery planning, testing and implementation.
Manage and maintain IBM AIX servers (Oracle DB).
Installed and configured oracle 10G OEM Grid control on AIX servers
Implement all maintenance requirements and changes, updates and upgrades of
Oracle DB.
Ensured that the proper disaster recovery procedures are in place.
Implemented, maintained and supported 10g RAC on IBM RS 6000 Hardware and GPFS
2.3 file system.
Working experience with BMC SQL BackTrack and Tivoli Storage Manager.
Supporting Oracle10G RAC database environment.
Experience in upgrading database from 9i (9.2.0.6)to 11g.
3+ year of experience in OWB 9i/10g developer and Administrator
Generated complicated forms using Oracle Developer 2000 Forms6i/9i/10g and
Reports 6i/9i/10g
Expertise in design and development of application in relational database,
client / App Server environment and web-enabled environment using Oracle
7.3/8.x/9i/10g and Oracle Data WareHousing.
Expertise in developing forms using Oracle Forms 4.5/5.0/6.0/6i/9i/10g.
Extensively worked with developing reports using Oracle Report
2.5/3.0/6.0/6i/9i/10g.
Extensively worked in deploying application into Web-enabled environment using
Oracle 9iAS/10gAS Application Server.
Extensively worked with database development writing stored procedures,
functions, packages, and data base triggers using SQL, PL/SQL.
Worked extensively with SQL Loader using control files for data ware housing
and data loading into database tables.
Extensively used Designer 2000/6.0/6i for generating ER diagrams, DFDs, and
database design.
Worked on UNIX, HP-UNIX, AIX-UNIX, Lunix, Zeus, Sun Solaris, VMS VAX, AS 400,
Ms-Dos, Windows NT and Windows 95/98/2000/XP operating systems.
Extensively used PL SQL Developer, Rational Rose and Security tool DBSIGN.
Experienced in usage of UNIX commands and writing shell scripts.
Developed PRO*C programs to the preprocessing for the batch reports and coded
customized PL/SQL packages, procedures and database triggers.
Work effectively independently or as part of a team.
Designed and coded screens and reports in Apex Application2.0/3.0(HTML db)
Design, development and deployment of large software products in both
Client/Server and Application Server Environment.
Proficient in database objects like stored procedures, functions packages, and
triggers.
Excellent written and verbal communication skills.
Created documents like SDD (Software Design Document) for the modules
Created documents for end users so that users can refer the document when they
are using application
Expertise in Performance Tuning of ORACLE databases dealing with Oracle
Parameters, SGA allocation, Creation and Maintenance of Indexes.
Proficient in SQL Query tuning using utilities such as Explain Plan,
Autotrace, tkprof, statspack.
Loading of data with SQL*Loader, expertise in utilities like exp and imp
Have designed and implemented Physical Backup & Recovery on disks and
Experience in extensive use of Logical Backup & Recovery using export/import
utilities
Experience with Dataguard/Standby Database.
Configuration, Maintenance and Troubleshooting of Oracle Network files like
Listener, tnsnames.ora.
Maintained Triggers for application and system audit and implemented Database
Security using roles privileges and profiles.
TECHNICAL SKILLS
GUI Tools: DEVELOPER 2000, ORACLE FORMS 3.0/4.5/6.0/6i/9i/10g,ORACLE REPORTS
2.5/6.0/6i/9i/10g,Graphics 2.0, Power Objects 1.0, Power Builder 4.0, and Visual
Basic, Oracle Designer 2000, Discoverer, Oracle Application Express 2.0/3.0,
Reporting Tools Crystal Reports, Sql Server XI/10/9.0,Business Objects XI/6.1.b,
Web Intelligence, MS-Office (Word/Excel/Access)
Data Modeling: Oracle Designer 2000, Erwin 2.6
DBA Tools for Oracle : Oracle Enterprise Manager, RMAN, Import, Export, Oracle
Data
Guard, Flash Back, Net8, Automate Storage Management(ASM),OEM Grid Control,
SQL*Loader, Quest TOAD DBA Module, Quest TOAD SQL Tuning module and STATSPACK.
Case Tools: TOAD (Tool for Oracle Application Developers) PVCS,Rational Rose
Languages: PL/SQL 2.3/8.0, SQL*PLUS 3.3/8.0/8i/9i/10g, SQL, Visual Basic,
COBOL, FORTRAN, BASIC, C, PRO*C, JAVA, HTML, JSQL, ISQL
Databases: ORACLE 7.x/8.x/9.x,/10g, MS Access
Data Warehousing: OWB 9i/10g
Web Servers: Oracle Application Web Server (OAS) 4, 9iAS, 10gAS
Internet: JAVA, JAVASCRIPT, HTML, JDEVELOPER, XML
Job Scheduling Tools : Oracle Workflow, OEM, Control M
Operating Systems: UNIX, MS-WINDOWS NT/XP, MS-WINDOWS 95/98/2000, MS-WINDOWS
3.11, Sun Solaris and MS-DOS
EDUCATION, TRAINING & CERTIFICATIONS
Certifications Brainbench Oracle Forms 10g (Transaction Id # 7206047)
Education 1990 1994 ~ Bachelor of Technology (Computer Science), India
PROFESSIONAL EXPERIENCE
6/02 - Present
NYSDOT,Albany,NY
Role: Oracle Database Administrator/Developer
Oracle DBA
Responsible for handling, Troubleshooting and supporting the Production,
Development, testing and QA Environments on IBM AIX servers.
Evaluated data models using tools like ERwin Data Modeler v 4.1 and ER Studio
Suite v 7.0.
Creation of physical models from logical models and compare models to models &
data bases and participate in the data model approval process.
Database Monitoring and performance tuning for Oracle 10g R2
database(10.2.0.4).
Design and implementation of database backup/recovery, database monitoring and
tuning.
Oracle Database security, user management, creation and assignment of roles,
monitor space requirements and maintain table spaces, creation and maintenance of
tables, indexes and other database objects.
Experience in implementing Oracle Enterprise Manager 10g GRID Control.
Experience in collecting and evaluating database performance statistics.
Applied patches on oracle server to upgrade it from 10.2.0.2 to 10.2.0.3 &
10.2.0.3 to 10.2.0.4.
Applied critical CPU patches including Apr 2009 CPU and July PSU 2009.
Performed Database cloning and oracle home cloning.
Worked extensively with tools like DB Artisan and OEM Grid Control.
Oracle Database security, user management, creation and assignment of roles,
monitor space requirements and maintain table spaces, creation and maintenance of
tables, indexes and other database objects.
Worked on scheduling periodic jobs in support of Oracle databases (backups,
statistics collection, log file clean-up, etc.).
Involved in NYSDOT system upgrade project (oracle 9.2.0.1, 9.2.0.5 to oracle
10.2.0.3).
Performed Backup and Recovery using RMAN integrated to Tivoli Storage Manager
on 10G R2 and 10G R2 three - Node RAC.
Performed day-to-day database administration tasks such as monitoring of
databases, database processes, rebuilding and reorganizing indexes, monitoring
disk space usage and archival, backup status, and other periodic maintenance
tasks.
Troubleshooting and identifying root cause of production/development issues
and resolve them based on the priority of helpdesk ticket to maintain high
availability.
Daily system verification and monitoring procedures to validate database
status and availability.
Expertise in RMAN backup, Database cloning using RMAN and troubleshooting RMAN
issues.
Developed shell scripts for database monitoring, RMAN backups and cleanup
jobs.
Expertise in Database creation, creation of database objects (tables, indexes,
keys, triggers, views),granting object permissions, database server installation
and patching, database backup and recovery, database export/import, listener
management, monitoring server performance, and performance tuning.
Have experience scheduling periodic jobs in support of Oracle databases
(backups, statistics collection, log file clean-up, etc.).
Migration of database objects from development to test tier, test tier to QA
tier and QA tier to production tier.
Monitored OS resource usage like CPU and memory using tools like TOPAS and OEM
grid control.
Maintained and scheduled materialized view refresh jobs for DWH reporting.
Installed, configured and Administered Oracle warehouse Builder (10.2.0.3) on
AIX 5L systems.
Refresh development/test databases from copies of production.
Developed and deployed materialized views for various data warehouse reporting
requirements.
Implemented, maintained and supported 10g RAC on IBM P570 Hardware and GPFS
file system.
Installed and configured 11G database for Grid control version 10.2.0.5.
Creating mappings in OWB10g for extracting data as per business needs,Creating
source and target tables in database using mappings from OLTP (Oracle and Sql
Server,DB2)
Review of Logical Data Model of ODS Tables. Review of Logical and Physical
Model of Star Schema including Dimension and Fact tables.
Technical Assistance for Development. Design and Develop of Logical and
physical Data Model of Star Schema including Dimension and Fact tables.
Developed different mappings to transform data from source to target. Used
Partition, Partition Exchange, Star Transformation Query Execution, materialized
views on the database Table key columns. Developed strategies for reconciliation
to be performed between transformed data in the Source area and the data in the
data warehouse
Create functional documents and Mapping Specifications. Design the data
extraction processes. Design the data mapping processes. Design the data loading
processes. Design reject-handling processes. Design the refresh processes. Design
scheduling scripts. Design the Balancing and Data Quality Process.
Involved in tuning of performance of created mappings
Instructed staff in best practices use of Oracle Warehouse Builder .
Utilized ControlM for the process scheduling along with the runtime repository
for Metadata on loading.
Reengineer the Data Warehouse to enable new capabilities such as Change Data
Capture and Partition Exchange for near real time data access thus enabling
access to an updated Data Warehouse several times during a day.
Oracle Developer
GSLA (General Soils Lab Approval).
The Geotechnical Bureau of the NYS Department of Transportation has an on-line
application that currently supports the activities of the Drill Tools Inventory
system, Soil boring analysis, General Soils Laboratory
DT:
DTS provides the bureau with the ability to maintain Stock of the Drill tools,
track the requests for new tools, order the tools from the Catalog, disburse of
the tools to the regions, report and maintain tools inventory. DTS includes also
tracking of high-value diamond bits on per item bases and reports on their usage
and disbursement to the regions.
BLAP:
The application provides the ability to record test results, approve results,
and produce the graphical Subsurface Exploration Log
It is comprised of over 20 SQL*Forms and Reports program that produces the
Boring Log.
GSLA:
GSLA provides the laboratory with the ability to log samples, record sample
receipt, schedule sample testing, maintain sample queues for testing, record
testing results, perform retests and record new results (if required), approve
test results, evaluate sources, and report test results. This subsystem is
currently comprised of over 150 SQL*Forms and numerous reports to provide the
aforementioned functionality Initially this application is created in Designer 60
from Oracle Corporation consultant.
I involved in migrating the whole application from Designer60 to Designer6i.
The entire database is migrated from Designer 60 to Designer 6i
I migrated all the forms/reports from Designer60 to Designer 6i and fixing the
errors that occur while migrating from Designer60 to Designer6i using
forms6i/Reports6i
And moved all the three applications in GSLA application to web Server.
Involved in testing the database which is migrated from Oracle8i to
Oracle9i/Oracle 10g
Currently all the application forms/reports are using forms10g/Reports10g
against 10g database
Used Ration Rose for tracking Bug fixes and Maintaining the versions
|
