*********@*****.***
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