KRISHNAKANT KHETAN
[Send email using form at bottom]
__________________________________________________________________

QUALIFICATIONS PROFILE

Solutions-oriented Lead Oracle Database Administrator with a proven track record
of success in the analysis, design, development, and support of robust
database-driven applications that directly support bottom-line business needs. 
      Exceptional leadership and motivational skill; lead team of 5 to 7
DBA’s to provide development, disaster recovery and 24 X 7 mission critical
production support.
   Dynamic database design, architecture development, and integration
talents, resulting in stable, scalable, and secure database-driven systems.
      Highly adept at promptly and thoroughly mastering new technologies
and adapting to existing corporate infrastructures, producing results immediately
on hire in cross-functional IT roles.
      Well-refined analytical and troubleshooting skills, providing
direct support to users at all levels of computer proficiency.
 Exceptional interpersonal and customer relationship skills; serve as
liaison between business representatives, client management, and users.
 
CORE COMPETENCIES:

		Database Planning, Design and Engineering		 	Team Management
	   	Performance Tuning and Release Management			Customer
Support
	  	Application and Report Development			 	Project Management

TECHNICAL SKILLS

Operating Systems: 	UNIX(Solaris, HP-UX, Ultrix), Windows 2000/NT
Databases: 		Oracle(10g,9I,8I),  Sybase,  SQL Server
Development Tools: 	Oracle Discover, PowerBuilder, Crystal Report, Oracle
Transparent Gateway, 
Actuate e.Report Designer
DBA Tools: 		Oracle OEM Grid, Oracle Enterprise Manager,Toad, Quest Shareplux,
ERWin, 
PVCS, Sybase Central, Cast Workbench, Quest Central for Oracle, 
Datamart Tool: 	Redbrick 6.0
BI Tool: 		Microstrategy 
ETL Tool: 		Informatica PowerCenter, Informatica PowerConnect

CERTIFICATION

 Certified Associate in Project Management (CAPM) – First step to PMP
 Oracle Certified DBA
 Sybase Certified DBA




PROFESSIONAL EXPERIENCE

MERCHANTLINK LLC, Unit Of JP Morgan Chase.
Lead Database Engineer (Jun 2004 – Present)

 Providing project management and technical leadership to the DBA team.
 Install and Configure Oracle OEM Grid for the monitoring of production
and development databases.
 Responsible for several projects that required working with the UNIX,
networking, application and disk storage groups. Also defined complete Oracle
departmental standards and designed and implemented a system for problem
tracking.
 Review project request for scope, timeline for deployment, resources
and priority
 Provide input for projections of hardware/software requirements and
professional resources
 Manage various infrastructure projects like Data center move, server
migration and replacement.
 Manage various security audit projects like Payment Card Industry
(PCI), SAS-70 that successfully led to corporate compliance and certification.
 Work with the release manager in implementing database change control
procedures, policies, software releases, installs, and implementations   
 Plan and implement security auditing policies and procedures for all
user activity
 Develop and implement procedures for backup, recovery and disaster
recovery of the Oracle databases (OLTP & Data Warehouse) using Oracle RMAN.
 Proactively researched Oracle 10g Streams Replication for Unix;
identified numerous potential liabilities in environment.
 Configured High Availability Database environment for all our critical
applications using Oracle Streams Bi-directional replication.

MAGELLAN HEALTHCARE SVCS.
Lead DBA (Dec 2001 – June 2004)

 Hands-on Lead DBA responsible for a number of critical, high profile
development initiatives.
 Provide leadership and guidance to database administrator team of 5 to
7 DBA’s to provide development and production support to the corporate
applications.
 Managing Oracle licensing, recommending purchases and upgrades to third
party software.
 Participate in the capture of system requirements, risk assessment,
system development and configuration management
 Install, configure and implement Oracle 9i RAC in the development
environment. Proactively researched application of RAC along with Oracle Streams
and identified some potential issues with the configuration. Worked with Oracle
Technical Support to resolve the issues.
 Developed the on call procedure’s and policy’s that included service
level agreements for support and response times
 Participate and provide technical and troubleshooting support to the
Datawarehouse user community, operations, developers and testing groups
 Responsible for upgrade, support, design, installation, establishment,
creation and tuning of the Oracle 9I and 8I databases for the Datawarehouse
system of the company.
 Proactively researched application of Oracle 9i Data Guard logical &
physical standby configuration for Unix; identified numerous potential
liabilities in environment.
 Successfully diagnosed and resolved Oracle tool problem of development
database during time-sensitive benchmarking phases.
 





HITACHI INNOVATIVE SOLUTIONS CORPORATION  (SEP 1998 – NOV 2001)

Worked at the below clients through Hitachi:

CLIENT: WINSTAR INC.
Senior Oracle & Redbrick DBA (April 2000 – April 2001)

 Recognized as Oracle Database Administration expert, offering
assistance in all day-to-day Oracle administration efforts.
 Selected as lead DBA for key database development and production
environments, coordinating efforts of DBA, Systems Administration, and
Application Development teams throughout project lifecycle.
 Reviewed project request for scope, timeline for deployment, resources
and priority
 Successfully maintained day-to-day functionality and reliability of
major database applications supporting core business activities, managing
terabyte-sized production databases.
 Volunteered to participate in 24X7 on-call support rotation with staff
DBAs, minimizing downtime of databases throughout United States.
 Run SQL Trace and TKPROF to tune existing queries. Run Explain plan and
SQL hints wherever necessary. Run STATSPACK and UTILBSTAT/UTIESTAT for database
health check.
 Installed and configured Informatica PowerCenter 5.0 Client, Server and
Repository on Dell server running Windows 2000.
 Installed Informatica PowerConnect 5.0 Client for Siebel and created
Informatica mappings to transform data from Siebel OLTP into a SQL Server
datamart containing dimension and fact tables.

CLIENT: E.SPIRE COMMUNICATION INC.
Oracle DBA (April 1999 – April 2000)

 As a member of Oracle Arbor/Eastland reporting team, analyzed and
refined users' reporting requirement.
 Developed Seagate Crystal Reports per user defined format with proper
permission and security consideration.
 Performed analysis and designed the logical & physical data model for
Call Detail Record (CDR) application using PowerDesigner DataArchitect.
 Created oracle stored procedures, packages, triggers and some other
database objects.
 Maintained, supported, and fine-tuned the database as a DBA.

CLIENT:  IRIDIUM
Oracle DBA (Sep 1998 – March 1999)

 As a member of the Oracle DBA team, provided database support to
development and production environment 
 Wrote Korn shell scripts to monitor the performance of Oracle servers,
for carrying out various tasks and monitoring the performance of front-end
applications.
 Responsible for backing up all databases using RMAN from Production
environment and loading onto the Disaster Recovery environment for Disaster
environment testing.
 Installed new Oracle 8i servers in the testing environment to evaluate
its new functionality and test the existing application on the new server.








BIRLA CONSULTANCY & SOFTWARE SERVICES (BCSS)
Oracle / Sybase DBA (JUL 1993 - SEP 1998)

Worked at the below clients through BCSS:

CLIENT:  WELLSPRING RESOURCES

 Performed analysis and designed a logical data model using
PowerDesigner DataArchitect.
 Performed schema change impact analyses using Cast Workbench 3.6.
 Analyzed performance and throughput of applications, identified
bottlenecks using Oracle Utilities.
 Provided DBA support for the development group.
 Wrote UNIX shell scripts and stored procedures to perform data
validations and inserts.
 Synchronized and maintained the database schema, stored procedures, and
triggers 

CLIENT:  CAMBRIDGE TECHNOLOGY PARTNERS

 Designed logical data model with team members using ERWin 3.0.
 Created additional tables and database objects to support the existing
Siebel database.
 Created operational procedures and installation scripts to create the
database and relevant database objects, and to execute the stored procedures that
load the Oracle database from the legacy system.
 Fine tuned Oracle instance and SQL queries by analyzing server related
throughput and bottlenecks

CLIENT:  BIRLA GLOBAL FINANCE LTD.

 Led a team of seven to analyze, develop and conduct performance tuning
on the Hire and Purchase application in a Sybase 11, PowerBuilder4.0, and Windows
NT environment.
 Analyzed existing applications on the FoxBASE environment, identified
entity relationships, and designed a data model using ERWin case tool.
 Analyzed and made recommendations such as splitting databases across
different controllers and disks, normalizing and de-normalizing tables based on
the application.

CLIENT:  THAI RAYON COMPANY

 Led a team of four developers and analysts in the development of
various applications for the client including a sales & marketing system and a
production reporting system.
 Reviewed and recommended changes for corporate-wide Sybase standards
for device usage based on database sizes and expected performance from the
dataserver and applications, mirroring Sybase devices, expected 'recovery
interval' for different environments in case operating system crash and sizing of
data and procedure caches.
 Analyzed stored procedures and queries for performance tuning using
Sybase features: forced indexing, showplan, and statistics time.

CLIENT:  PAN CENTURY EDIBLE OILS SDN. BHD.

 Assisted DBA in creating physical databases and writing scripts to
automate dump/load of databases.
 Created stored procedures for data validation and insert/update of the
tables.
 Wrote scripts to automate bcp of data from development server to test
server.
 Analyzed disk and memory usage for efficient performance of the
applications.

EDUCATION

Bachelor of Engineering, Birla Institute of Technology & Science, India