Database Administrator

Dhwani Parikh

____________________________________________________________________________

Address Contact Citizenship

**** ******** *****, *****: 440-***-**** US Permanent Resident

Hilliard, OH, 43026 Email: ************@****.***

____________________________________________________________________________

Summary

3+ years of Comprehensive business and technical expertise in database administration, database development, data modeling and business intelligence

2+ years of Comprehensive business and technical expertise in software requirements analysis, design, development, testing and implementation of object-oriented solutions

Comprehensive knowledge of Oracle and Microsoft SQL Server

Expert in database development using Stored Procedures, Functions, Triggers, SQL, tables, indexes and views

Very strong communication skills, problem solving skills and work ethics

Quick learner, adaptive to emerging technologies and strong analytical capabilities

Experienced in developing ETL/ELT processes and scripts

Good understanding of Object-Oriented analysis, design and development

Experienced in developing applications using ASP.Net, C# and Java

____________________________________________________________________________

Technical Skills

Databases Oracle 9i/10g/11g, Microsoft SQL Server 2000/2005, Access

Languages PLSQL, SQL, T-SQL, Kron Shell Script, Java, C#, ASP.Net, VB.Net, XHTML, HTML, CSS, JavaScript, VBScript, XML, VBA, VB6, C++, C,

Database Technologies Oracle OLE, ADO.Net, ADO, JDBC, ODBC

Web Services SOAP, WSDL

Frame Works Microsoft .Net Framework 1.1/2.0/3.5

Development Tools Toad, SQL Developer, Eclipse, Microsoft SQL Server Management Studio, Microsoft Visual Studio.Net, JDeveloper, SQL Plus

App/Web Servers IIS

Environments Windows Server 2000/2003/2008, Windows 2000/XP/Vista, UNIX, Linux

Architectures N-tier, SOA

Monitoring Tools Oracle Enterprise Manager 10g/11g

____________________________________________________________________________

Experience

Technisource Columbus, OH

Database Administrator – Discover Financial, New Albany, OH Nov 2009 – Current

Provide Oracle 10g/11g database administration for production and production assurance databases

Develop, maintain and execute backup processes for various oracle databases using RMAN, Data Pump and Oracle export

Move database object changes to production assurance databases.

Monitor production assurance and production databases using Oracle Enterprise Manager

Maintain and execute various database administration, archival and cleanup scripts on production and production assurance database servers

Solve SQL and PL/SQL optimization issues for various applications

Create and maintain various database objects like tables, indexes, views, mviews, triggers, procedures, packages, functions, constraints, etc.

Create and maintain user access and database roles

Assist developing data models and provide optimization guideline to developers

Create and maintain database issues knowledge base and procedure documentation

Ohio Environmental Protection Agency Columbus, OH

Programmer (Internship) Jun 2009 – Oct 2009

Provided ad-hoc reporting support using Oracle and Microsoft SQL Server

Created and maintained various web pages for Ohio EPA internet and internet sites within open source content management system called DotNetNuke

Discussed various project requirements and business logic with various Stack holders and Management

Developed various ETL jobs using Oracle procedures, Functions and packages

Maintained user access intranet sites within DotNetNuke

Designed class diagram and data model for computer based learning system

Ocean Agro (I) LTD. (India) Vadodara, Gujarat, India

Programmer Oct 2004 – Oct 2006

Provided ad-hoc reporting support using Oracle, Microsoft SQL server and Access

Maintained and managed customer registration web application using ASP.Net and C#

Developed and maintained database stored procedure, functions, tables and views for various datamarts

Maintained customer registration client application using VB6 and helped migrating to web based application using ASP.Net and C#

Created Excel macros to speed up daily operation processes and reporting

University of Technology of Madhya Pradesh Bhopal, Madhya Pradesh, India

Computer Science Teaching Assistant Jun 2003 – Jun 2004

Conducted computer system architecture class through lectures and seminars

Assisted Junior students with class projects

Responsible for creating tutorial/teaching materials for various computer science classes

Installed and configured computer hardware, local and network printers, windows servers

Conducted various tutorial sessions for junior students to help them understand class materials

____________________________________________________________________________

Education

Master of Science in Computer Science 2010

Franklin University, Columbus, OH

Bachelor of Engineering in Computer Science and Engineering 2004

University of Technology of Madhya Pradesh, Bhopal, Madhya Pradesh, India

____________________________________________________________________________

References

Available upon request

Contact this candidate