Oracle Database

Title:Senior Database Administrator/Unix Systems Admin

******@*****.***

Document

Source below

NAME: Choudaraiah Akula

ADDRESS: **** ***** ******* ****

CITY: Fairfax

STATE/PROVINCE: VA

ZIP/POSTAL CODE: 22031

COUNTRY: USA

EMAIL: ******@*****.***

PHONE: 703-***-****

CANDIDATE ID: 214813

CITIZENSHIP: US

Citizen

EDUCATION:

EXPERIENCE: 10

WILL RELOCATE: Yes

RELOCATION INFO: VA

JOB WANTED: Any

RATE NEEDED:

HOMEPAGE:

COMMENTS:

HOTSKILLS: oracle,hp-ux,sun solaris,sql,pl/sql,sql loader,shell scripts,unix,nt

ESUME

Objective:

Seeking a position as an oracle dba/unix admin

Having 7 years of experience as an Oracle database administrator/architect

Areas of expertise:

Parallel Server, Distributed and Replicated databases.

Database design and Performance tuning.

Client/Server Architecture TCP/IP Protocols

Unix administration of HP-UX and Sun Solaris

Education:

MS

in Computer Science, Bowie State University, Bowie, MD

BS

in Mechanical Engineering, JNT University, Hyderabad, India

Summary of Experience:

Having 7 years of experience as an Oracle DBA including support to production databases,

development & testing databases and System Administration for HP-UX and Sun solaris.

Designed and developed oracle database using full life-cycle software methodology

(business requirements, analysis, design, application development (coding), testing

(including volume testing) and deployment).

Area of expertise includes Database design (logical and physical), Creating Databases,

Performance tuning of databases, Recovering databases, Performing On-line and Off-line

database backups periodically and Creating Standby databases for 24/7 availability.

Developed oracle database architecture including capacity planning database server

design, storage architecture, physical database design, high availability and backup and

recovery methods.

Providing 24/7 production database support to AT&T customer account data management

(CADM) database of 1.2 Terra-byte on SUN E10K Cluster configuration. Database files were

soft-linked to raw slices of 2 & 1 Gb. size spread over 7 controllers to balance I/O.

Periodic re-organization of heavy hit tables and indexes during weekend maintenance.

24/7 On-Call support to production and development databases

Developed shell scripts (proactive cron jobs) to monitor production databases to avoid

running out of space in table and index segments.

Support to Hot backups of Database with Veritas Net backup to tapes using features of

RMAN

Migration of database from 732 (HP) to 805 (SUN) and 805 to 8i on SUN E10K.

Recovered database from backup media when database crash due to media failure.

Performing Export and Import of the database to speed up query processing, to avoid index

stagnation, to reduce chaining of rows and to increase data density.

Configured and deployed Oracle replication master to master database and master to

snapshot database.

Expertise in third party tools like Shareplex & Spotlight and very familiar with SRDF.

Developed Stored Procedures, Packages and Triggers to synchronize multiple databases.

Configured system global area (SGA) including relocation of memory to increase the shared

memory segment size, manipulation of tablespaces on raw partitions, tuning the database

as for application needs, Creation of Snapshots and providing dba support to application

developers and application dbas.

Oracle OPS including setup, install and maintain oracle parallel server

Expertise in Software Development of relational database including design and development

of databases, using ERWIN, PROC, PL/SQL, SQLPLUS, UNIX/C Programming and Shell scripts.

Configuration of RAID5 using Sunsoft Solstice Disksuite 4.0 on Sun Sparcstation20s

Installation and Configuration of Servers for storing Image files.

Experience

11/2001

PresentSenior Database Administrator/Unix Systems AdminVerizon Newport News, VA

Environment: Oracle 8.1.5/8.0.5 Sun Ultra (solaris 2.6)/Hp 9000 (hpux 11)

Responsible as an oracle dba for 24/7 availability of 4 development databases and 2

production databases and as an unix administrator for 8 HP 9000 and 2 Sun Ultra servers

Administration of oracle parallel server database which serves as the data repository for

the Genesys CTI system. The database contains the leads list for outbound campaigns which

hold customer data for outbound screen pop, call event data generated by T-Server and

agent data such as login information.

Upgraded hp-ux 10.2 to 11 on HP 9000 servers and configured print services on HP servers.

Trouble shoot problems in bringing up servers and disk configuration by interacting with

HP and Sun support personnel.

Configured kernel parameters as per the increased load on HP 9000 servers.

Support to Java and web developers in setting up databases and creating shemas.

02/99

10/2001Senior Database AdministratorAT&T

Herndon, VA

Environment: Oracle 8.1.7.1/8.0.5.1 Sun E10K (solaris 2.6)/Hp 9000 (hp unix 10.2) AIX NT

Responsible for availability of database 24/7 and database design and development as per

the needs of changing business requirements.

Periodic purge of data and support to application DBAs and Java development projects.

Configured and deployed Table and Index Partitioning as per the requirements of business

logic in 8171 database.

Database design as per application requirement including development, testing and

deployment.

Configured and set up standby database for production database.

Set up and deployed oracle multi master replication and developed routines for conflict

resolution in oracle 8.1.7.1

Set up replication using Quest Shareplex.

Support as a development dba for J2EE and weblogic projects.

Backup (Cold and Hot) and Recovery of database using RMAN 8.1.7 and VERITAS Netbackup

version 3.4, including setting up scripts for alternate client restore and duplicating

production database on to a different host. Rman level0 and level1 backups were taken and

restored on the same host.

Configured and deployed oracle parallel server with 3 instances using Sun cluster 2.0

Monitoring the application and database performance and recommending the changes for

performance improvement at Hardware level, OS level and Database level. HW-controller load

balancing, raw-partitioning, rollback segment tuning and tuning shared-memory segments.

Raw device mappings and disk I/O load balancing.

Fine tuning of large transaction processing queries for optimal performance.

Support to large transaction databases of sizes 900 Gig, 1.2 Terra-byte in volume testing

and production databases.

Recovered database couple of times once when the system datafile corrupted and when the

database has to be restored from backup and roll-forward by applying the archived log

files.

Ported databases of 900 Gig from Hp 9000 to Sun E10Ks.

Migrated databases from 7.3.2 to 805 and upgraded 805 to 817.

Re-org of tables and indexes when ever they got fragmented.

Parallel query management and optimization for data scrubbing and data extracting jobs.

Database administration of 1.2 Terra-byte using raw partitions in production and disaster

recovery environments.

Performance tuning of database (setting initialization parameters) and application

(tuning application queries).

05/98

02/99Senior Database Administrator

Qwest/Lci International Telecommunication Balston VA

Environment: Oracle 8.0.5, 8.0.4 and 7.3.4. Hp Unix 10.2, Sun Solaris 2.5, NT

Responsible for maintenance, security, availability, tuning and upgrading of 4 production

databases and 12 development & product assurance databases.

Designed and developed database for billing system using logical and physical data

modeling using Erwin data modelling tool.

Responsible for Billing system, Lec rejects and Conversion production databases.

Responsible as a production dba for 2 People Soft (Oracle) databases.

Configured and deployed Oracle replication master to master database and master to

snapshot database (read only).

Online redolog management, archiving of redo log files, rollback segment management,

control file management which include multiplexing and moving of control files, managing

job queues with initialization parameters and DBMS_JOB package

Upgraded the databases from Oracle 7.2.3 to 7.3.4.

Migrated Oracle 7.3.4 databases to 8.0.4/8.0.5

Extensively worked to create and maintain of snapshots (read only) and snapshot logs and

troubleshot the refreshing problems of snapshots.

Duplicated several databases from one production machine to another development/testing

machine which involves copying of data files, redo log files and initialization files and

creating new controlfile from backup controlfile command.

Recovered database using backup controlfile and archived redo log files

Used SQLAB to monitor the performance of database and to tune the queries using explain

plan for optimal performance

Establishing security through profiles and roles and periodically analyzing the tables.

Created integrity constraints on tables and triggers to maintain referential integrity on

remote objects.

Configured SQLNET on different client and server machines.

Support to application developers in Java and web development projects and developing

database procedures/triggers.

01/95

04/98Sr. Systems Engineer/DBA/System Admin

Wang Mclean, VA. I-NET Bethesda, MD.

Environment: Oracle 7.3.3 & 7.2.2.4, PROC 2.0, PL/SQL 2.0, SQLPLUS 3.1, Solaris 2.5

Project: Microfiche to Digital Conversion of Bureau of Navy Personnel Records (BUPERS)

and FAA personnel

Responsible for Database Administration and System Administration. Configured Sun

Sparcstation20 server on the network for storing image files.

Designed and developed database using Entity relation attribute modeling for FAA

personnel to convert microfiche to digital (electronic format) .

Performance tuning of bad response queries.

Developed several shell scripts using BORN and KORN shells and stored procedures using

PL/SQL to speed up the production and to improve response time of end users.

Trouble shooting both oracle system and application software for optimal performance.

Configured Sun Sparcstation20 servers on the network with an external raid5 of 60 gig

disk storage distributed over 2 SCSI controllers. (The raid5 was configured using Sun

Solitice disk-suite 4.0).

Installed Solaris 2.5 operating system and 2.4.2 Sun Prestoserve hardware and software on

servers to improve i/o.

Developed stored procedures and triggers to check database integrity and serve various

purposes in the process flow of BUPERS project.

Developed various daily progress reports using SQLPLUS

Responsible for Database Administration and System Administration.

Developed database model for converting Navy personnel records using Erwin

Responsible for developing imaging software systems and conversion of data using PROC and

PL/SQL.

Providing support to end users in the flow process of BUPERS production site.

Developed several application programs using PROC, Creating users, stored procedures,

packages to reduce network traffic and to improve response time.

Recovered database from 8mm backup DAT tape when database crashed from hard disk failure.

Added data-files and created users to database system by analyzing the process flow of

BUPERS project.

Perform database backups periodically (on-line every day and off-line on weekends).

Carried out database export and import monthly to defrag the database and to increase the

i/o .

Developed shell scripts and stored procedures to increase monthly throughput.

Worked on Lenzar scanners (LenzarPro 4000) to process images.

Trained technical staff members to troubleshoot problems on the system.

Developed shell scripts to perform on-line and off-line database backups that includes

data files, control files and archive-log files.

Developed scripts to run database space usage and to monitor disk space utilization.

Configured Sun Sparcstation20 server on the network with an external raid of 110 gig disk

storage distributed over 3 SCSI controllers. (The raid was configured using Sun Solitice

disksuite 4.0).

Installed Solaris 2.5 operating system and 2.4.2 Sun Prestoserve hardware and software on

servers to improve i/o.

11/94

12/94Programmer/AnalystSNC Inc

. Germantown, MD

Environment: Oracle 7.0.16, PROC 1.5, PL/SQL 2.0, SQLPLUS 3.0, Solaris 2.3, NT, TCP/IP

Project: Digital Conversion of Microfiche and Film for FAA Registry Contract.

Responsible for development of imaging software for FAA on Solaris 2.3.

Developed code for dumping data from database to files and exporting data to remote

database using Solaris 2.3, Oracle 7.0.16, C, PROC 1.5 on FAA Registry Conversion

Project.

HW/SW Skills:

Software: HP UNIX 11.0 10.2 Solaris 2.6 VMS WINDOWS NT

Languages: C/C++ SQL PL/SQL PROC SQLPLUS DEVELOPER 2000

Shells: BORN KORN C PERL AWK

Database: Oracle, VAX-RDBMS SQLLOADER SQLFORMS TSREORG SQLLAB

Machines: SUN E10K SUN ULTRA HP9000 NEXT IBM PC

References:

Will be furnished upon request

Contact this candidate