Post Job Free
Sign in

Sql Server Oracle Manager .Net Experience Management

Location:
8817
Posted:
May 18, 2010

Contact this candidate

Resume:

*********@*****.***

732-***-****

Summary

Over 5 years of experience in IT industry, including as DBA in

Production, development, test environment, full life-cycle database

implementation and management with Oracle 9i & 10g.

Experience in design/development and implementation of Client/Server

and Web based Applications and Windows application using .NET and SQL

Server.

. Good working experience with Oracle 10g on Linux and Windows

platforms.

. Installation of Oracle 9i/10g on Linux (RHEL4) and Windows platforms.

. Knowledge of creation, installation, upgrading, patching the database.

. General Production support and On-call 24x7 support

. Experience in creating users, roles and profiles, granting and

revoking privileges and access for database objects.

. Performing logical backups using exports and imports Utilities.

. Experience in Space and User Management.

. Responsible for Backup & recovery using Import / Export, Online,

Offline and RMAN.

. Undertake tasks related to managing changes to database schema,

database creation, and maintenance, database monitoring tasks.

. Knowledge of Upgradation and Migration of Oracle 10g to 11g.

. Knowledge of ASM (Automatic Storage Management), RAC (Real Application

Clusters) and Data guard.

. Import/export of data using Oracle Enterprise Manager [OEM].

. Experience in writing triggers, procedures, packages and functions

with PL/SQL.

. Worked strongly on SQL-Server 2000, SQL-Server 2005 databases.

. Worked on Normalization of database to create simpler database tables.

. Experience in Web development using ASP.NET, Visual C #, ADO.NET, XML,

JavaScript, SQL Server.

. Developed web application and windows applications for portal-using

ASP.NET, ADO.NET, and worked on multiple configuration files in .NET.

. Used JavaScript as client side scripting language in Visual Studio

.NET.

. Friendly, cooperative attitude, detail-oriented, analytical and self-

driven.

. Experience in Oracle Discoverer for creating reports.

Skills

Operating Systems : Windows xp/2000/2003, Red Hat Linux

4.0

GUI & IDE : Visual Studio.NET 2003/05/08

Languages : C#, SQL, T-SQL

Databases : SQL Server 2000/2005, Oracle 9i, 10g

Development Tools : Photoshop, Visio, SQL Query

Analyzer

Web Technologies : ASP.NET, JavaScript, XML

Versioning tools : Microsoft Visual Source Safe 6.0

Reporting : Crystal reports 9/10/XI

Other Tools : Windows Remote Desktop, Net meeting, WebEx.

Work Experience

Mariner Investments Group Inc., Mamaroneck, NY

Apr 2007 - till date

Oracle Database Administrator

Mariner Investment Group is a registered investment advisor with over $3.8

billion of assets under management, and is a leading manager of funds

focused on superior risk adjusted returns with low volatility and low

correlation to stock and bond markets. Mariner globally services and

manages funds for insurance companies, foundations and endowments as well

as plan sponsors and high-net worth individuals.

Roles and Responsibilities

. Installed and Configured Oracle 9i and 10g on Windows and Linux

environments.

. Actively monitor the database systems to ensure secure services with

minimum downtime.

. Designing and maintaining the database of the users in Oracle server.

. Responsible for online and offline backups and recoveries using RMAN.

. Import/export of data using Oracle Enterprise Manager [OEM].

. Create users and grant privileges according to the requirements to the

users.

. Responsible for administration and supporting Oracle 9i and 10g

databases

. Responsible for table space management.

. Taking the logical & physical backups.

. Providing support for the smooth functioning of the Database to

developers.

. Modifying parameters in PFILE as per requirements.

. Cloned the production database for reporting and testing purposes.

Environment: Red Hat Linux 4.0, Windows XP, Oracle 9i, TOAD, OEM, VPN

Frontline soft (fsl projects), India

Jan 2005 - Feb 2007

Doctor's website

Database Programmer Analyst/Designer

This is a website of a Doctor, with this website the patients can take

appointments online and then visit as scheduled. The website also provides

consultancy services i.e. patients can take prescriptions from the doctors

online just by sending their previous prescription details and pay small

amount through Pay pal Service. The appointment taken by the patient for

meeting the doctor in person is confirmed by the doctor through an email to

the email id provided by the patient at the time of taking the appointment.

Roles and Responsibilities

. Responsible for Requirement Analysis and detailed System Design.

. Responsible for Development, Testing and Implementation of the

Application.

. Responsible for creating the database using SQL server 2000.

. Responsible for writing the stored procedures in the SQL server to

pull the required data on the web pages.

. Designed and developed the pages for displaying the input entries

using ASP.NET and C#.NET for the logic to connect to the database.

. Responsible for retrieving the data from the SQL server database.

. Responsible for Troubleshooting and Debugging.

. Used Visual Source Safe for version control, used to sign in and sign

out the reports, pages and the stored procedures every time when we

make any changes.

Environment: Visual Studio 2003, SQL Server 2000, ASP.Net, C#, ADO.Net.

Education

. BS in Computer Science and Engineering

Certifications

. Microsoft Certified Professional in Developing and implementing web

applications with Microsoft Visual C#.Net & Microsoft Visual Studio

.Net

. Brain bench Certified Programmer for ASP.NET

Trainings

. Microsoft Certified System Engineer(MCSE)

. Microsoft Visual Studio .NET

. Microsoft SQL Server



Contact this candidate