Nayna M. Vakharia H: 732-***-**** C: 973-***-****

** ******* **., ********, ** 08873 ac2it4@r.postjobfree.com

Summary

Oracle 11g and 10g Certified Professional (OCP) DBA with CompTIA Security+ certification.

Database Administrator using Oracle over nine years, MS SQL Server one year, and MS Access.

Configuration Management using Rational ClearQuest (CQ) / ClearCase (CC), Subversion, and Mantis.

A key founding member of the Database Administrator (DBA) and Configuration Management (CM) Team for a high-tech company that experienced torrid infrastructure growth. Developed, Deployed, Tracked, and Supported ongoing releases to customers on time.

Efficient with Oracle Database Server and OEM GC Installs, Upgrades, Quarterly Security Critical Patch Updates, and Migration, RDBMS v7, v8i, v10g, v10gR2, v11gR2, SQL*Plus, PL/SQL, Import, Export, Data pump, Oracle Enterprise Manager 10g and 11g Grid Control (OEM GC), DBCA, DBUA, DBVerify, and Recovery Manager (RMAN).

Configure and schedule jobs using OEM, used AWR / ADDM reports to debug performance issues.

OS: HP-UNIX, HP Tru64 UNIX, Sun Solaris 9, and Sun Solaris 10 Virtual Servers, Windows 7, XP, 2000, 2003 Server, and Vista.

Used Citrix Server, Putty, Exceed, telnet, ssh to connect to remote servers.

Effectively worked with Oracle and Rational tech support to resolve issues using SR on Metalink / TAR, Web Conference, email, and phone.

Worked with Security, Network, and SA team to evaluate ArcSight, netForensics, and Intellitactics for implementing Security Information Event Management system. Customer approved nFX SIMone, implemented the same. Worked with nFX tech support for updates, issues on Oracle database.

An additional fifteen years of experience as a go-to Administrator, in the high-tech manufacturing, Quality Assurance (QA) and civil administration arenas, facilitating efficient database analysis, reporting and decision support.

One year of experience with Telelogic Design Object Oriented Requirements System (DOORS) tool.

Working knowledge of Oracle Data Guard, RAC, and Partitioning, Rational ClearQuest and ClearCase Multisite, Unified Change Management (UCM), Telelogic Synergy, and Telelogic Tau. Working knowledge of Korn Shell, C Shell, CodeFusion, XML and Perl.

QA testing – using Agile SDC. Used Charles Proxy. Working knowledge of SoapUI

Creative at problem solving, energetic, multi-tasking, flexible, and a great communicator. Ability to work on multiple priorities under the pressure of scheduling constraints.

Technical qualifications

12/11 Oracle Golden Gate, Oracle University, LearnDBA

10/11 Oracle Database 11g RAC Administration on Linux, Oracle University, Learn DBA

02/11 Oracle Database 11g Administrator Certified Professional (OCP)

01/11 Oracle Database 10g Administrator Certified Professional (OCP)

12/10 CompTIA Security+ Certified

04/10 Oracle Database 11g New Features for Administrators, Oracle University.

12/06 Oracle Database 10g Administrator Certified Associate (OCA)

12/06 Oracle Enterprise Manager 10g Grid Control Release 2, Oracle University, Oracle Corporation, NJ

10/06 Oracle Database 10g: Administration Workshop II Release 2, Oracle University, Oracle Corporation, NJ

09/06 Oracle Database 10g: Administration Workshop I Release 2, Oracle University, Oracle Corporation, NJ

05/04 Using DOORS for Requirements Management, Telelogic, VA

10/03 Customizing DOORS with DXL, Telelogic, VA

06/03 DOORS Administration and Management, Telelogic, NJ

02/01 ClearCase Essentials for UNIX and NT, Island Training Solutions, Inc., NJ

02/00 Enterprise DBA, Architecture & Administration, Oracle University, Oracle Corporation, NJ

12/99 Introduction to Oracle: SQL and PL/SQL, Oracle University, Oracle Corporation, NJ

11/99 ISO 9000 Quality System Auditing, GHR Associates

07/99 ClearQuest Administration, Rational University, Rational Software Corporation, VA

06/97 Diploma Certificate Course in Oracle and VB 4.0, Comp-Quest Training Center, NJ

96-97 Continuing Education Units (CEU) in MS Access, Excel, Word, & PowerPoint, Calc Canterbury Institute, NJ

95-98 Earned Continuing Education Units (CEU) in Management skills for Administrative Assistants, Exceptional Assistant, Stress Management, Successful Communication skills for Women, Grammar and Usage, Powerful writing and presentation skills seminars.

Education

LL. B. Bachelor of Laws, General, M.S. University of Baroda, Faculty of Law, Baroda, India 1984

B. Sc. Bachelor of Science, Chemistry, University of Bombay, Bombay, India 1981

Experience

AT&T U-Verse and DirectvNow - Middletown, NJ, 06/2013 – 12/2016 QA Test Engineer

An active team member for an MRA project that uses Agile SDC with Subversion and Rally.

Working in a server test team that uses Oracle and SQLite database with application built using XML, JSON, JAVA and .net.

Install database server builds delivered from the development team on the test team servers. Test Oracle database install and rollback provided by development.

Working actively in testing API calls, verify XML and JSON responses, verifying XML logs, events generated by these calls, and data updates in the database. Perform functional, sanity, stability, and regression test and verification of defect, enhancement, and requirement fixes. Also test the application using device (iPad, iPhone) to verify the correct API responses on client.

Using SQL Developer and Oracle 11.2.0.3 database server on Linux.

Write comprehensive test cases with test scenarios including sqls for both sunny day and rainy day testing. Using JIRA, Trac, and Rally for user stories and Modification Request (MR) tracking and reporting defects.

Used REST client, Charles Proxy, and SoapUI for testing. Work closely with the developers and client test team.

Federal Aviation Administration (FAA) KITT Project – Iselin, NJ, 09/2011 - 06/2013 Database Administrator

Active team member for Production Deployment, database support, and UI testing for FAA Contract Information Tracking Tool (KITT) system.

Worked as an active team member and supported application developers, QA testers, DBAs, System admins, and management team.

Supported system security scan audit questionnaire and POAM response related to project servers.

Gather requirements and write use cases for the customer.

Used SubVersion for source control and JIRA and RTC Jazz for defect/issue/task tracking.

Supported oracle 10gR2, 3 node RAC db to 11gR2 3 node RAC DB along with datacenter DBA team to verify the process is flawless and the application works same as before upgrade.

Used TOAD for all data/procedure/packages/schema related tasks for dev/qa/beta/prod environments.

Managed Oracle database server and client installs on Windows, schema export backups, RMAN backups of local databases. FAA dbs are monitored by datacenter DBA team.

L-3 Communications/C2S2 - Eatontown, NJ 10/2004 – 08/2011 Database Administrator

Secret and IT-1 Security Clearance.

Coordinated and worked with the team to upgrade over 50 United States DoD (AF, Army, and Navy) enterprise sites from Oracle database server 8.1.7.3 to 10g on three different platforms; Solaris, HP-UX, and Tru64 using fully automated process with Korn Shell and SQL scripts for SW Engineering Center (SEC) at Fort Monmouth.

Lead the DBA effort to migrate and upgrade Oracle database server 10gR2 on HP Tru64, HP-UNIX, and Solaris to 11gR2 on Solaris 10 Virtual servers (Tech Refresh) for Air Force JCALS project.

Fully documented the upgrade and back out plan. Contributed to DR plan and COOP activities.

Install OEM GC 10g with Oracle Management Agent (OMA), upgrade to 11g using WebLogic Server and Java on Solaris 10 Virtual server. Installed OMA on each site. Scheduled Oracle Secured Backup and monitored AWR / ADDM reports. Configured and Monitored host, database, listener, and agent targets on GC.

Lead DBA effort with Oracle 10gR2/11gR2 upgrade process, research, planning, design, deployment, and support of JCALS Enterprise’s development, QA, and production servers. Tier II support for all sites throughout the country.

Review, research, plan, and design quarterly Oracle Critical Patch updates to enterprise servers to address IAVAs. Execute Database Server Security Scan and implement the fix as per DoD STIG requirement.

Installed database server using OUI, applied patches using OPatch, debug and analyze data corruption using dbverify, analyze, trace files, and alert logs.

Support nFX (netForensics) SIMone (Security Information Management) Oracle database on Windows server 2003 for database security scans / fixes quarterly CPUs, backup etc.

Wrote test cases for QA related to Oracle database and OEM components based on the requirement for each release.

Used SubVersion for source code, Mantis for defect tracking, and Remedy for tracking trouble tickets to manage and support the JCALS enterprise.

Used OTN and Oracle Metalink for SRs, OWC / telephonic communications with Oracle Support, download database server and OEM GC/Agent upgrade / CPU software and documentation.

Worked actively with Software Engineers, Security, Configuration Management, and Quality Assurance teams as a key project team member. Worked closely with SAs on OS requirements and changes for upgrade such as; kernel parameters, file system settings, shell limits, OS Patches etc.

Completed and followed L-3 Communications/C2S2 mandatory trainings and followed the complete Software / Testing life cycle from planning/Requirement to System Test during each release to meet CMMI requirements.

Telelogic - Mt Arlington, NJ 5/2004 - 10/2004 Customer Support Engineer

Customer Support Engineer for Telelogic DOORS - Requirements Management Tool, DOORSnet, and Other Integrations with DOORS for all global customers over phone and via e-mail.

With excellent time management, communication, and interpersonal skills, achieved ‘Best Support Personnel’ recognition from the Director and the Customer.

Eastman Kodak Company, Health Imaging, R&D - Allendale, NJ 4/2003 - 5/2004 Defect Tracking and Process Engineer

Implemented and administered Defect Tracking database using SQL Server and Rational ClearQuest on Windows 2000 to support 350+ Eastman Kodak’s Health Imaging global users including web clients across all Health Imaging sites including Engineering, Integration & System Test, Systems Engineering, Documentation, Service and Support, and Product Management organizations.

Accomplished ClearQuest Tool Validation to comply with 21CFR 11 and received recognition award for completing the task in the scheduled time limit.

Support all users 24/7 on call and during off hours. Worked with the CM team members on rotation to support nightly builds.

Installed, configured and maintained CQ Web server over Internet Information Server (IIS) and monitored performance of it. Defined and documented the CQ defect tracking process for CM. Implemented ClearQuest/ClearCase Integration for change tracking, reporting, and traceability of the software development lifecycle.

Used Domino.Doc system for Standard Operating Procedure (SOP) and other process documents for review and approval.

Conducted live and virtual training for new CQ users internationally and maintained user database.

Supported installing and upgrading DOORS, and DOORS user administration.

Worked for QA team to execute test cases and record the results.

Tellium, Inc. - Oceanport, NJ 2/1999 - 3/2003 Configuration Management Engineer

Installed and upgraded Oracle server and clients using OUI. Upgrade Oracle from v7.3.4 to v8.1.6 and from v8.1.6 to v8.1.7.4. Monitored, maintained, and tuned Oracle databases with OEM. Configured and implemented backup and recovery strategy using RMAN and OEM jobs. Restore and recover using re-do logs.

Used OTN and Oracle Metalink for SRs, OWC / telephonic communications with Oracle Support, download database server and OEM GC/Agent upgrade / CPU software and documentation.

Support software/hardware engineering development and QA testing teams 24/7 on call and during off hours. Worked with the CM team members on rotation to support nightly builds.

Implemented Modification Request (MR) and Action Request (AR) Tracking database using Oracle database and Rational ClearQuest on Windows 2000 to Support 300+ users including web clients through the complete Software and Hardware Engineering Lifecycle, across all organizations including Engineering, Integration & System Test, Systems Engineering, Chief Technology Office, Customer Support, and Product Management.

Installed and upgraded ClearQuest through CQ release 1.0 to release 2.0, 2001.03, and 2002.05, created CQ silent installs for all users using batch job techniques. Installed, configured and maintained CQ Web server over IIS and monitored the performance of it. Created, modified, and maintained CQ schemas, automated CQ related tasks using CQ API, Basics and Perl scripts. Implemented ClearQuest/ClearCase Integration for tracking software change with defects/issues.

Installed and upgraded ClearCase and other development tools such as Rational Rose, Purify, and Development Studio. Organized and documented Oracle, ClearQuest and ClearCase process related documentation.

Administered CQ user database and conducted training for CQ users.

February 1999 – February 2000 - As an Administrative Assistant, assisted Quality Assurance Director preparing SOP, training, and document control to achieve ISO 9001 for the company and achieved ISO 9001 certification in 2000. Designed, developed, and maintained Ms Access database tracking system for Supplier Quality Administration, Returned Material Authorization (RMA), and Product details. Designed weekly and monthly management reports for supplier quality performance and corrective action data.

KDI/Triangle Corporation, Inc. - Whippany, NJ 2/1995 - 2/1999 Administrative Process Analyst

Designed and implemented a tracking system for Returned Material Authorization (RMA) using Microsoft Access database.

Performed daily administrative task supporting QA Director. Analyzed data and provided management reports for Continuous Improvement Program.

Designed and implemented Supplier Quality Administration System using MS Access and MS Excel, involved capturing supplier quality performance and corrective action data and providing weekly and monthly management reports.

Assisted preparing SOP, training, and document control to achieve ISO 9001 for the company and achieved ISO 9001 certification in 1997.

Contact this candidate