Resume of Database Engineering Leader

Title
Database Engineering Leader

Primary Skills
Senior Oracle DBA

Location
US-MA-Boston

Posted
May-31-07


OVERVIEW: I am a senior level Oracle DBA performing DBA tasks such
as database performance tuning, Oracle instance creation, Oracle upgrade to higher versions, database refresh with production data, logical and physical database design, data modeling, and data warehousing

EMPLOYMENT STATUS: U.S. Citizen

EDUCATION: Ph.D., mathematics, Lehigh University, Pennsylvania
M.Sc., mathematics, University of Toronto, Canada
M.A., mathematics, University of Calcutta, India
B.A. (Honors), mathematics, University of Calcutta

Oracle8 Database Administration
Oracle8 Performance Tuning Workshop
Implementing SQL Server 7 Database

ACADEMIC HONORS: Fullbright Scholarship, Government of U.S.A.
Commonwealth Scholarship, Government of Canada
Eshan Scholarship, University of Calcutta

MEMBERSHIP: Independent Oracle User Group (IOUG)

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, UNIX Shell Programming, C

Software: Relational DBMS - ORACLE, SQL Server, MS Access, INGRES,
LOGIX, UNIFY/ACCELL, SYSTEM 1022
Tools - ERwin (data modeling tool), Power Designer (CASE
tool), DB Artisan, Visual Source Safe, Visual Interdev, Visio (graphics), EXCEL, WORD, PROJECT

Hardware: Sun Microsystems (Solaris), Compaq Proliant (HP-UX), Digital Alpha
8400 (Digital UNIX), PC (MS-DOS, Windows NT)


Sitansu S. Mittra - Page 2

WORK EXPERIENCE:

CSC Inc., Cambridge, MA (Aug 01 -- Jan 07)
Database Engineering Leader
- Oracle DBA for 11 databases running on 10 different servers under Oracle 10.2.0.2
in a Solaris 8 environment for production, backup, test, development, and training
- upgraded Oracle RDBMS to 10.2.0.2 from 10.2.0.1, to 10.2.0.1 from 9.2.0.7, and to
9.2.0.7 from 8.1.7.4
- investigating the changes to be made to Oracle 10gR2 databases on servers and clients
to handle the impact of the upcoming Daylight Saving Time changes in 2007
- created instances and associated databases under Oracle 9i and Oracle 10g based on
functional requirements
- run the production database in ARCHIVELOG mode
- refresh non-production databases from production, as needed
- supervise weekly backups of production database via scripts and 'cron' jobs
- interface with users and customers regularly
- study and document needs for capacity planning and consolidation of servers to reduce
operational cost
- provide consultation on all database administration and performance tuning issues to
developers and testers across multiple projects and multiple databases
- use scripts, STATSPACK, and AWR/ADDM to track database performance
proactively and take remedial steps before problems appear
- perform tuning at the instance level via adjustment of init.ora parameters, sizing of the
SGA and other appropriate measures
- perform tuning of SQL queries at the database and application levels via optimal
indexing, use of tools such as EXPLAIN PLAN, SQLTRACE/TKPROF, and
AUTOTRACE, detection and correction of chaining of rows, etc.
- work with Configuration Manager for QA of application patches and install and
uninstall application software patches for databases, as needed
- prepare and update database design and description documents, as needed
- install, uninstall application software patches for databases
- mentor junior DBAs and developers on DBA tools and techniques
- Leader, Oracle SIG sessions, usually offered once a month
- Lead Technologist for Oracle, Technical Advisory Council, CSC Inc. at Cambridge
- Recipient of Outstanding Knowledge Leveraging Leadership award from CSC in 2003
and 2005 (no awards given in 2004)

Clark University, Computer Career Institute, Framingham , MA (Jun 01 -- Aug 01; limited time contract position)
Instructor, Oracle DBA Certificate Program
Courses taught: SQL and PL/SQL, Database Administration, Backup and Recovery, Performance Tuning, Network Administration

Sitansu S. Mittra - Page 3

Fidelity Investments, Boston, MA (Oct 99 - Jun 01)
Senior Oracle DBA and Data Architect
- DBA tasks to maintain 12 databases (7 OLTP, 5 reporting) of size about 90 GB each
- logical and physical data modeling to accommodate customer data needs
- installation of Oracle 8 and 8i under UNIX
- implementation of Oracle instances and databases under Oracle 8i
- upgrading an Oracle instance to a higher version
- periodic refreshing of non-production databases with production data using
transportable tablespaces
- set up snapshot replication between databases
- extensive performance monitoring and tuning of the databases
- tuning of SQL queries at the database and application levels via optimal
indexing, use of tools such as EXPLAIN PLAN, SQLTRACE/TKPROF, and
AUTOTRACE, detection and correction of chaining of rows, etc.
- supervise two DBAs

Edgewater Technology, Wakefield, MA (Mar 98 - Oct 99)
Database Project Manager
- capacity planning of databases during physical database design
- creation and implementation of Oracle instances under UNIX and Windows NT
- performance tuning at internal level for database applications
- UTLBSTAT/ESTAT utility reports to tune database performance
- query optimization using EXPLAIN PLAN and AUTOTRACE under Oracle8

Digital Equipment Corporation, Marlboro, MA (Nov 96 - Mar 98)
Database Development/Architecture Manager
- supervised and implemented a very large worldwide sales compensation application
using ORACLE 7, Digital UNIX, and Visual BASIC in client server mode
- used normalization, optimal index creation, referential integrity in database design
- tracked free space trend, fragmentation and chaining of tables, performance tracking
via computation of various hit ratios, sizing of SGA components, especially the DB
buffer cache and library cache

EBSCO Publishing Co., Ipswich, MA (Jun 95 - Oct 96)
Manager, MIS Manufacturing
- supervised and implemented the restructuring of a client server database
application from DOS/FoxPro to ORACLE7/Visual FoxPro platform;
- designed database using normalization, enforced referential integrity, and
optimized index creation
- planned and estimated tablespace size, data and index table size, extent size
- tracked storage use, free space availability, fragmentation, and chaining, and
took corrective action, as needed

Sitansu S. Mittra - Page 4

Digital Equipment Corporation, Stow, MA (Mar - June 1995: limited time contract position)
Senior Data Architect
- designed overall data architecture for MS Access application
- designed MS Access tables to import data from VAX/VMS/RDB database

CSC Inc., Lexington, MA (Oct 91 - Mar 95)
Manager, Software Maintenance, Configuration Management, and
Quality Assurance
- performed extensive data modeling and database design at both
logical and physical levels
- ensured high performance of application software in clustered
VAX/VMS/ORACLE environment through optimization at external,
conceptual, and physical levels of databases
- supervised a team of 12 information system professionals

Prior to 1991, I was employed as system analyst, senior system specialist, etc. in various organizations including System Development Corporation, Unisys, and Commonwealth of Pennsylvania.

PUBLICATIONS/PRESENTATIONS:

Books:
1. Database Performance Tuning and Optimization, Springer-Verlag, 2003
2. Principles of Relational Database Systems, Prentice-Hall,
1991
3. Structured Techniques of System Analysis, Design, and
Implementation, John Wiley & Sons, Inc., 1988
4. Decision Support Systems: Tools and Techniques, John Wiley &
Sons, Inc., 1986
Papers:
- Speaker at OracleWorld 2003 (International Oracle User Conference)
held in San Francisco, Sept 7 -- 11, 2003.
- Nearly 35 technical papers on information systems, database
systems, mathematical modeling, and statistics published in
various professional journals including Bulletin of Calcutta
Mathematical Society, Journal of Differential Geometry, Journal
of Systems Management, Journal of Software Maintenance, and
Oracle View. List can be furnished on request.
- Many invited addresses and presentations on databases and
software testing made at national and international conferences

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-MA-Boston »
View all resumes in US-MA »

View other Database Engineering Leader resumes, Database Administrator resumes