AJAY MANIK
 

Tel:   510-551-6829 (cell)							     Email: a_manik@hotmail.com

Summary:
•	Over 12 years of experience in Oracle Database and Data Warehouse Design and
Administration on (24x7) VLDB production databases. 
•	Expert skills in Oracle RDBMS (10g/9i/8i) Installation, Capacity planning,
Database Creation, Performance Monitoring & tuning, Backup & Disaster Recovery
and Database maintenance procedures using PL/SQL programming and Shell scripts.
•	Strong Data modeling, Data Conversion, Data & Volumetric Analysis, Application
infrastructure & enterprise model management experience. 
•	Worked in Oracle 9i Real Application Cluster environment with Oracle
10gAS/9iAS interface. Extensive knowledge of Oracle functionality & internals. 
•	Worked with variety of clients in financial/public sector, federal/State
government and E-commerce based organizations.  
•	Good consulting and communication skills, with knowledge of
client-relationship building techniques and project methodologies with good team
building skills.

Technical Skills:						
OPERATING SYSTEMS:		Solaris 5.8, HP-UX, Linux, Windows NT/2003 Server.
DATABASES  		    	Oracle 10g/9.2.0.7/8i, Sybase 12.5, SQL Server 2000, Oracle
10gAS/9iAS
APPLICATIONS:		Oracle 11.0.3 Financials/HRMS, Siebel 6.3/7.8 eCommunications.
LANGUAGES       		Java, XML, SQL, PL/SQL, PERL/UNIX Shell/Awk.
TOOLS  			Erwin ERX 4.1.4, Informatica Power Center 6.2, DB Artisan 8.1.3
      				OEM 9.2.0.1.0/Database Grid Control, TOAD 8.6, Shareplex.
MR TOOLS			Clear Case, PVCS version management, MS Project 2000, Visual Source
Safe                                                  
HARDWARE        	     	Sun E-10000 (E10K), HP 9000, Unisys ES7000, Net Apps, EMC
SAN.  
                                             
Professional Experience

SAIC 				              						           Sep 2005 - Present
Project 1 - Securities and Exchange Commission (federal), Alexandria, VA	     	 
   August 2006 – Present
Team Lead for Database Administration
•	Production Database Support for Oracle 10g Release 2 and 9.2.0.7 databases on
Linux and Windows 2003 Advanced Server with CGI -Momentum Financial ERP package
as the front-end.
•	Install Oracle 10g/9i, Capacity planning, Disk/Volume layout, RAID definition
and Database creation for Strategic Acquisition Management  (BPM) and Network
Event tracking projects (2 tera bytes).
•	Installing Oracle FailSafe 3.4 and testing failover in 4 node cluster using
EMC SRDF for Disaster recovery.
•	Performance Monitoring and Tuning using 10g OEM tools AWR, Metric baselines
and ADDM.
•	Development team support for query tuning using SQL Tuning and Access
Advisors. 
•	Configuring RMAN backups using 10g OEM/scripts and configure with Veritas
Netbackup. 

Project 2 - General Services Administration (federal), Vienna, VA		       	     
  Sep 2005 - July 2006
Lead Database/System Administrator
•	Development and Production Database Support for Oracle 9.2.0.6 with Siebel
7.8.2 Call Center application on Windows 2003 Enterprise Edition and upgrade
pilot databases to 10g Rel 2.
•	System technical architecture definition, Capacity planning, SAN Disk Storage,
defining RAID levels for Production databases and data warehouse.  
•	Backup and Disaster Recovery configuration using  RMAN and Data Guard for
physical standby.
•	Configuring Oracle Fail Safe with MS Clusters for Active-Active db nodes.
•	Defining logical/physical data model using Erwin for Data migration/Data
warehouse. Schema analyze and Object sizing for yearly/monthly data loads.
•	Performance monitoring and tuning using STATSPACK, OEM and custom scripts.  
•	Supporting Rational tools administration and Siebel, Business Objects and
Informatica administration.

EBUSINESS APPLICATION SOLUTIONS				       Sep 2001 – Aug 2005
Project 1 - Pennsylvania State Police (Lockheed Martin), Harrisburg, PA		      
Jan 2005 – Aug 2005
Lead Production/Development DBA
The State Police is in the process for automating systems and processes with
third party developed application.
•	Production DBA for Oracle 9.2.0.5 databases (24x7support) 1.1 TB, on HP 9000
and Windows 2000 advanced servers.
•	Performance monitoring and tuning using Statspack reports and implementing DB
security procedures using User Roles classification and data encryption.
•	Backup and Disaster Recovery procedures implementation using BCV backups and
RMAN.
•	Oracle 10g (Enterprise Edition) installation and research available
methodologies for replicating data between MCD’s (Mobile Computing Device) and
Master DB server on Windows 2000 Advanced Server.
•	Re-architecture of current Oracle 9iAS Rel2 (Forms and Reports) configuration,
for load balancing (active-active) using Web Cache in a cluster based environment
(active-passive) and upgrade to 10gAS.
•	Maintaining the existing data model in ERwin to conform to the Standard naming
conventions and Abbreviations document. Mentoring other DBA's on Data modeling
techniques & principles.
•	Communication of issues/scope and requirements to Data warehousing/Reporting,
infrastructure teams and end-user groups. 
•	Implementing the Application drop procedures and the changes required for the
database and recompilation of the forms, reports and PL/SQL libraries. 
•	Oracle 10g Lite install and prototyope application for development and synch
operation on the MCD.

Project 2 - Pennsylvania Insurance Dept. (Deloitte Consulting), Harrisburg, PA	 
      Jan 2004 – Jan 2005
Lead Production DBA
The CAPS System at Pennsylvania Insurance Department (PID) centralizes the
administration of 2 public health insurance programs (CHIP and adultBasic) via
seven private health insurance contractors.
•	Production DBA for Oracle 8.1.7/9i and SQL Server 2000 databases
(installation, database creation and 24x7support), on HP/UX  11.5 and Windows
2000 advanced server.
•	Upgrade of Oracle 8.1.7 database to 9i and latest 9.2.0.5 patch set install
for the Oracle binaries. Defining the Database architecture and physical storage
design.
•	Maintaining  application data model/data dictionary using Erwin and synch with
physical database schema. 
•	Data Migration from SQL Server databases to Oracle tables using “Oracle
Safeswitch Data”.
•	Performance monitoring and tuning the Application (SQL, PL/SQL) code using
Explain Plan, TKPROF and Statspack reports.  Memory and database parameter
tuning.
•	Scheduling and maintaining regular backups for the Production/Test
environments.
•	Testing and implementing the Disaster Recovery strategy for building the TFP
environment.

Project 3 - AT&T Wireless Services (Deloitte Consulting), Seattle, WA	          
             Jul 2003 - Dec 2003
Lead Production/Development DBA
•	Production DBA for Oracle 9.2.0.4 databases (installation, database creation
and 24x7support), for Siebel 6.3 to Siebel 7.5 conversion on Sun Fire 15K
server.
•	Installing 9.2.0.4 patch for the Oracle binaries. Defining the Database
architecture and Capacity planning (RAID) for database over 2.5 terabytes, with
physical storage design (data file distribution). 
•	Object level space allocation & mapping large partitioned tables to locally
managed table spaces. 
•	Automation of daily database maintenance procedures using UNIX shell scripts.
Monitoring OS level performance for CPU and I/O waits.
•	Parallel DML/Query, Memory (database parameter) tuning and temp table space
configuration.
•	Performance tuning of Informatica ETL mappings (75GB tables) and Siebel EIM
(inserts/updates) with 20 concurrent processes; using Statspack report, Session
level trace and OEM.
•	BCV backups/restores for the databases on EMC SANs, using Vertias Net Backup
and RMAN.

Project 4 - Department of Children & Families (State of Florida)		       	     
May 2002 to Jul 2003
Production DBA
•	Oracle 8.1.5 installation & Data Base Creation on Sun E-10K’s, Windows 2000
server for Fire Wall based Child safety application based on J2EE/EJB and .NET
technologies.
•	Using Erwin to Lay out Logical and physical design of the Database server and
Creation of Database (approx. 710GB) using Oracle Installer on Sun Enterprise
10000 server (E10K).
•	Rollback and Undo Segment configuration in multi-instance database
configuration   
•	SQL, PL/SQL procedures, database triggers for application and data validation
and improving the query performance.  Used custom SQL’s and OEM for performance
monitoring.

Project 5 - UPS (ORACLE Corp.), Louisville, KY		                                
                Sep 2001 to Mar 2002 
Lead DBA
•	Database Operations Lead for managing the Development, Staging and Production
database environments under Oracle 8.1.5 and 9.0.1 on Windows 2000 server and Sun
E10K. 
•	Upgrading Oracle install to RAC Server installation and configuring the
SPFILE, UNDO management and TAF (transparent application fail over) on Sun E10K
servers.
•	Upgrading Oracle App. Server installation to Oracle 9iAS and configuring the
Fail over from production databases to the Local Databases in real time, with web
server switch over.
•	Communicating issues and changes in scope to DBA, testing and infrastructure
teams and end-user groups.  Performance tuning of Real Time Loads for 140K
transactions per hours.
•	Using Informatica (ETL) for the Enterprise Datawarehouse, Mapping Sources and
Targets, Populating the Data Mart while dealing with the Dirty/Missing Data.
•	Configuring UNIX shell scripts and PL/SQL procedures for automating the RMAN
backup’s and database maintenance procedures.  

DELOITTE CONSULTING					                      Oct 2000 – Aug 2001 
Team Lead for Database Administration
•	Implementation, administration and maintenance of Core technology Development
and Production Oracle 8.1.7 /8.1.6 and Sybase databases with Oracle 9iAS
front-end. 
•	Performance Monitoring and Tuning of the Siebel Call Center Application and
databases. 
•	Determining the scope, requirements & time frames for migrating Oracle 8i to
Oracle 9i. Communicating issues and changes in scope to DBA and infrastructure
teams. 
•	Oracle Installation and Production Databases (approx. 1.5 tera bytes) creation
for Deloitte ASP Data Center under Oracle 8.1.7/8.1.6 on Unix E4500/HP servers,
using Oracle Parallel server architecture and high availability features.  
•	Setting up Oracle Advanced Replication for Production systems using
SharePlex.
•	Installation and maintenance of Oracle 9iAS Application Server ver 1.02 and
report generation, maintenance using Oracle Portal 3.0.6.

INTELIANT Corp.								       May 1998 - Sep 2000
Project 1 - Kiracom Corp, San Francisco, CA                                     
                                   Dec 1999 to Sep 2000
Production DBA Lead
•	Physical Database Operations Lead for managing the Development, Staging and
Production database environments under Oracle 8.1.5 and 8.0.5.
•	Migrating Development databases currently under Oracle 8.0.5 to Oracle 8.1.6.

•	Resource planning, Disk Volume Analysis and Data/Index Segment Volumetric
analysis for Production  (65GB) / Warehouse (135GB) on NetAPP Filer F720, using
RAID 4 disk arrays. 
•	Planning, Implementing and documenting Backup/Recovery and Disaster Recovery
strategy for the Production environment. Automating UNIX shell scripts for backup
scheduling.
  
Project 2 – Bank Of America, Jacksonville, FL                                   
                   	       Oct 1998 to Oct 1999
Production DBA
•	Oracle Database and Data Warehouse Design and Administration for production
environment under Oracle 8.0.5 and working with a team of 7 other very senior and
experienced DBA’s.
•	Laying out physical design of the Database server and Creation of Data
warehouse (approx. 640GB) using Oracle Installer on Sun Enterprise 10000 server
(E10K). 
•	Planning, Designing and implementing a complete Backup and Disaster Recovery
strategy using Recovery Manager (RMAN). Automating the backup’s using Shell
scripts and CRON TAB.
•	Performance monitoring and tuning of the databases. Generating database
performance reports using UTLESTAT and UTLBSTAT scripts, EXPLAIN PLAN and TKPROF.
 

Project 3 - Document Authentication Systems, Baltimore, MD                     
		       Jun 1998 to Oct 1998
Production DBA
•	Oracle Database Administration of the Production Database. The images are
scanned and stored in a FILENET system, through the database of indexes, which is
in Oracle 8.0.4.	
•	Installation of Oracle 8.0.5 Enterprise on Solaris 2.5.1 and Database
Creation.
•	Upgrade and Migration of Database running under Oracle 7.3.4 to Oracle 8.0.5
using the Migration Utility.
•	Planning and Implementation of Multiple Instances into One Large Single
Instance. 
•	Setting up backup procedures for the Production using Archival log and
Recovery Manager (RMAN).

PTL, INDIA						 			     Nov 1995 to May 1998
Team Lead (DBA/Operations Lead)                		                               
 
•	Installation, Upgrade and Administration of Oracle 7.3/7.2/7.1/7.0, 6.0 on
Pentium - II server with UNIX SCO V Open Server. Managing a database of 60 GB
size (24x7).
•	Maintaining the logical and physical organization of the database, like
organization of database into different tablespaces & data files on different
disks to reduce disk contention.
•	Monitoring the performance, sessions, users, and tablespaces for the database
using Oracle Server Manager, SQL TRACE, UTLBSTAT and UTLESTAT, EXPLAIN PLAN.
•	Regular backups (different levels) & Recovery. Writing automated Regular daily
backup procedures. Performing regular backups using different utilities like
export, import for online backup/restore.

CROMPTON GREAVES LTD, INDIA 					       Jul 1994 to Nov 1995
Database Administration                                   	 
•	Team member for administration of financial database.
•	Maintaining the logical and physical organization of the database, creation of
tablespaces and datafiles, users and assigning them roles and privileges.
•	Tuning of the running and newly implemented applications and database.
•	Monitoring the system activity on the Operating System as well as Oracle
level.
Environment:   Oracle 6.0, Forms 3.0, Pro *C 1.2, AT&T UNIX

Education: 		                      						
•	Masters in Computer Applications (M.C.A) in 1994 from Punjabi University,
India.
•	BS (Mathematics) in 1991.

Certifications:
•	Certified OCP (Oracle 8 Certified Professional) in Database administration.
•	EMC Certified in Enterprise Storage Foundations.
•	CMMI Overview Certification.