Manager Quality Assurance

NITESH PATEL

**** ******* ***, *************, ** - 30044 Phone: 770-***-****(Home)

678-***-**** (cell)

E-mail: abl57s@r.postjobfree.com

Summary:

. Over years experience in Oracle Databases and Database Tools.

. Worked extensively in developing Stored Procedures and Packages,

Triggers using PL/SQL programming.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Unix, Sun, VERITAS Cluster on AIX, SUN, Windows

95/98,2000, XP & MS-Dos

RDBMS: ORACLE 10g, 9i, 8i, 7.x, SYBASE 11.9, 12.5,, Lotus

Notes

GUI: DEVELOPER 2000,Visual Basic 6.0. Forms 4.5 and 5.0 Reports 2.5 and

3.0, Crstal report 8

LANGUAGES: C++, C Programming, SQL, PL/SQL

INTERNET: Java

UTILITIES: Embarcadero (Rapid SQL, DBArtisan), Golden gate

SQL backtrack, MSOFFICE 2003, xp, Lotus 123,

Multimedia, Photoshop 4/

Education:

Bachelors Of Science Gujarat University INDIA.

CERTIFICATION

Certificate of Oracle 9i,

Diploma in Computer Application & Programming

Diploma in RDBMS in Oracle with Developer 2000

Advance Diploma in Multimedia and Programming

MS Visual Basic - 6

Java 2.

PROFESSIONAL EXPERIENCE

AT&T

November 2007 to Jan' 2010

Atlanta, Georgia

Database Administrator- Duties include implementation of database software,

managing database space requirements, troubleshooting, performance tuning,

backup/recovery, maintenance, and database architecture for non cluster and

VERITAS cluster. Provide 24x7x365 uptime for high availability production

systems. Upgrading Oracle from 9i to 10g and also from 9.2.0.4 to 9.2.0.8.

Installing Oracle CPU Patches on non cluster and VERITAS cluster server.

Software Quality Assurance- Perform data validation, unit, integration, end-

to-end, functional and regression testing. Troubleshoot applications and

monitor load testing. Support QA analysts in developing and validating test

plans.

Application Support- Involved in troubleshooting database interfacing

applications including batch jobs, shell scripts and web-based applications

both in QA and production environments. Work with development team to

identify and document application defects.

Responsibilities:

. Install, upgrade and maintain Oracle 9i and 10g databases.

. Responsible for data analysis and maintenance of Oracle databases

. Responsible for logical data modeling, physical database design, and

data dictionary maintenance

. Developed backup and recovery procedures (Cold backup & Hot Backup)

with UNIX Shell Scripts for the production databases and on UNIX.

Backup and Recovery using RMAN and SQL Backtrack.

. Managed Performance Tuning via OEM, STATSPACK for 9i. For

datawarehouse I/O Tuning via OEM, STATSPACK. Monitored and optimized

database performance.

. Configured Oracle Enterprise Manager (OEM).

. Perform as a Database Administrator providing DBA support to steady

state and project team.

. Interact with application teams, tech teams and client personnel on

technical issues.

. Develop procedures and scripts for continuous improvement, repeatable

processes and maintenance activities related to databases.

. Implement database change requests, patches, monitoring tools, and

resolve exceptions, alerts and issues

Accenture (Bellsouth A/c) January 2005 to

November 2007

Atlanta, Georgia

Database Administrator: Duties include install and maintain oracle and

oracle client and all patches. Duties also include trouble shooting, backup

and recovery, managing database and database tools. Provide 24X7 support to

database and database tools. Involve in providing support and direction for

installation, configuration, server upgrades and server migration.

Responsibilities:

. Installed and maintained Oracle 8i and 9i and 10g databases and

completed performance Tuning.

. Collect the real time data through Golden Gate.

. Maintained and complete performance and tuning for Datawarehouse that

include tablespace, table, data, etc.

. Managed Performance Tuning via OEM, STATSPACK for 9i. For

datawarehouse I/O Tuning via OEM, STATSPACK. Monitored and optimized

database performance.

. Developed backup and recovery procedures (Cold backup & Hot Backup)

with UNIX Shell Scripts for the production databases and on UNIX.

Backup and Recovery using RMAN and SQL Backtrack.

. Configured Oracle Enterprise Manager (OEM).

. Managed database design, creation and configuration, space management

and other database maintenance procedures in a multiple production and

development environments.

. Responsible for all Database Administration support activity.

. Database support through the project initialization, pilot to

production phase.

. Developed a procedure to add users, assigned privileges to roles and

created synonyms to database objects. Stream data between 2 nodes

through the use of Oracle Streams.

. Created storage structures and database objects. Controlled and

monitored user access.

. Management, Maintenance and Administration of Oracle Databases.

. Managed database user and security administration.

Electronic Data Systems (EDS) (Bellsouth A/c) January 2002 to December

2004

Atlanta, Georgia

Roll and Responsibility is identical to Bellsouth.net due to Transition to

EDS as a part of outsourcing.

Bellsouth.net October 2000 to December 2001

Application Support: Responsibility to run and maintain database interface

application like Bellsouth.net monthly and weekly Billing cycle includes

CBT, BUS and ADJ cycles. Also responsible for batch application job, shell

scripts like AAN, Hiway, Usage, Purge Account etc. Duties also include to

solve the problem of customer related data.

Database Administrator: Duties include implementation of database software,

managing database, trouble shooting, backup and recovery etc. Provide 24X7

supports to database and database tools. Involve in providing support and

direction for installation, configuration, server upgrades and server

migrations.

Contact this candidate