Computer Science Data

HEMAVATHI JOSHI

** **** *****, ******, ** *****, 732-***-****, ********@*****.***

OBJECTIVE

To obtain a software related position that includes software design, development, maintenance,

networking and testing with a focus on database design and administration to enhance my academic

and professional knowledge and skills in a dynamic workplace.

SKILLS

•Five years of experience as a Junior DBA

•Excellent knowledge and operation of ORACLE 11G with a professional certification

•Sound knowledge of Database Installation, Configuration, Operation, Tuning and Data Modeling

•Sound knowledge of C/C++, VISUAL BASIC, UNIX and Windows Operating System, Data

Structure and Algorithm, Debugging, Visual Studio, Shell Scripting, Dos batch programming,

Database Concepts and Design, MYSQL, MS-SQL, SQL, SQL*PLUS, ORACLE, SYBASE,

TCP/IP, LAN/WAN, NETWORKING, MS-OFFICE, Adobe Photoshop, HTTP, XML

• Experience in Data Modeling (Logical and Physical database design), normalization and referential

integrity constraints

• Nine years of formal education in core Computer Science with three years of teaching experience

• Excellent communication, analytical, technical and time management skills and detail oriented

EXPERIENCE

City University, New York, NY

Teaching/Research Assistant, January 2007 – May 2009

• Tutored students in Windows operating systems, C/C++ programming language, software

applications including MS tools, database concepts in both ORACLE and MS-SQL for basic

understanding of computer usage, data storage and retrieval and application development.

• Implemented DBMS prototype system using C++ in Master’s project as

• Data definition part: Created tables, Defined attributes, took user input for functional

dependencies, ignored trivial and weak dependencies, accepted user defined keys and ignored

keys reached by functional dependencies that were incompatible with user keys.

• Data manipulation part: Implemented database constraints, performed operations such as

cross join, natural join, union, intersection, difference, deletion, allowed user to add new

tuples that don’t violate functional dependencies, deleted tuples based on key values, found

attributes that satisfied conditions and group tuples based on chosen attributes.

Kathmandu College of Management, Kathmandu, Nepal

Faculty, Technician and DBA, Oct 2001 – Dec 2006

• Created, configured, installed, administered and managed college database system using

ORACLE 9i/ORACLE10G.

• Created roles, privileges to users as a junior DBA as per college needs.

• Good practical hands-on operation with hot backup and cold backup including logical backup using

export/import and Data Pump concept.

• Implemented, administered and maintained daily backups and archived data on tapes.

• Implemented recovery procedures for databases. Created backup copies of student data. Helped

students in their projects related to data storage, retrieval and usage.

• Performed database tuning regularly for efficient operation.

• Worked on data dictionaries and schemas and documented all troubleshooting steps for future

references.

• Provided technical support for database maintenance and disaster recovery to make sure data does not

get lost and is always recoverable and available even during emergency.

• Taught basic Computer Science Courses including Computer System and Applications, Operating

Systems, Microprocessor and offered regular support on technical, connectivity, telecommunication,

networking issues for hardware and software set up and installation.

• Served as a mentor in computer labs, trained students individually and in groups, provided computer

engineering and database administrative support to programming departments.

• Provided troubleshooting network assistance in CISCO related classes as a lab instructor.

• Assisted students for various SQL related queries.

Indian Institute of Computer Science, Bangalore, India

Research/Lab Assistant, June 1995 – May 1998

• Maintained online attendance using customized software

• Taught courses on Operating Systems, Discrete Mathematics, Computer System and Applications and

Procedural Programming.

• Worked as a Database Operator and Instructor

EDUCATION

• MS in Computer Science, May 2009, GPA 3.4/4.0

City University, City College, New York, NY

• BS in Computer Science, August 2001

Mysore University, Malnad College of Engineering, Karnataka, India

• Three years post High School Diploma in Computer Science, July 1997

Mysore University, M.E.I. Polytechnic, Bangalore, India

PROFESSIONAL CERTIFICATION

• Oracle Database Administration 11G, December 2012

New York University, New York, NY

RESIDENCY

• US Citizen

REFERENCES

• Furnish upon request

Contact this candidate