Sql Server Data
Resume:
Gopal Ramamoorthy
Chesterfield, VA. 23832.
Email: ********@*****.***
Cell # 804-***-****
Summary of SQL Server Expertise:
. Providing 24x7 production support
. Setting up of new MS SQL SERVERS, maintaining and troubleshooting of
databases.
. Involved in setting up SQL Server Clustering
. Scheduling and Planning for backup of databases
. Performing Database Recovery and Fixing Data corruption
. Developed many Stored Procedures and Triggers
. Extensively used Replication and DTS to transfer data from Remote
Databases.
. Granting Security permissions and managing the users
. Designing and creating table structures. Creating schema objects,
creation of user defined data-types and indexes
. Performance monitoring and database tuning.
. Worked on Data Migration Project using SSIS.
. Data Model Tool ER Studio and ERWIN
. Developed several reports using SSRS.
Experience:
Role: SQL Server DBA/Developer
Environment: SQL Server 2008 R2, SSIS, SSRS, ER Studio
Date: 11/2011 - 01/2013
In the last 15 months, I have been working on Data Migration project for
converting the legacy system to the new system. The new system is
currently developed on C# with SQL Server 2008 R2 Enterprise Edition. My
Responsibilities on this project includes:
. Data modeling for creating Logical and Physical Design of
Database and ER Diagrams using multiple data modeling tools like
ERWIN, ER Studio.
. Worked extensively on forward and reverse engineering processes.
Created DDL scripts for implementing Data Modeling changes.
Created ER Studio reports in HTML, RTF format depending upon the
requirement, published Data model in model mart, created naming
convention files, co-coordinated with other DBAs to apply the
data model changes.
. Extensive experience in writing functional specifications,
translating business requirements to technical specifications,
created/maintained/modified data base design document with
detailed description of logical entities and physical tables.
. Possess strong Documentation skill and knowledge sharing among
Team, conducted data modeling review sessions for different user
groups, participated in requirement sessions to identify
requirement feasibility.
. Experience in backend programming including schema and table
design, stored procedures, Triggers, Views, and Indexes.
. Excellent analytical, inter-personal and communication skills
with a strong technical background.
Role: SQL Server Production DBA
Environment: SQL Server 2008/2005/2000, Oracle 11g/10g
Date: 02/2003 - 10/2011
Responsibilities:
As a DBA, my primary responsibilities includes the following:
. Providing 24x7 production support
. Setting up of new MS SQL SERVERS, maintaining, and
troubleshooting of databases
. Setting up SQL Server Clustering
. Setting up and managing Log shipping between Production
Server and Hot site Server.
. Scheduling and Planning for backup of databases
. Performing Database Recovery and Fixing Data corruption
. Providing assistance to developers in creation of Stored
Procedures and Triggers
. Have extensively worked on SSIS Package for a Data
conversion project.
. Have developed database several reports for monitoring the
database servers using SSRS.
. Granting Security permissions and managing the users
. Performance monitoring and database tuning
. Upgrading and upsizing databases from earlier versions to
the latest versions.
. Security updates for SQL Server and Oracle servers within
the timeframes set by the IT security to eliminate the
vulnerability.
. Performing re-indexing/rebuilding of fragmented tables in
order to keep the Production Server running smoothly.
. Setup SQL Jobs, Database mail configuration and alerts for
database related issues.
Oracle Database Server:
. Working on Oracle database server to support HP PPM third
party application.
. Installed, upgraded and configured Oracle database servers
as required.
. Upgraded to Oracle 11g from version 10.2.0.4.
. Refresh Dev and TIP Database instance from Production
backup using Oracle Export Data Pump utility.
. Move Data between Oracle servers as required.
. Provide ongoing support to the PPM Team for database
related issues
EXPERIENCE 5/1998 - Department of Public Harrisburg,
12/2002 Welfare PA
Project: ChildLine System
Role: SQL Server DBA
Environment: SQL Server 7.0/2000, DTS, Replication, Stored
Procedures, Triggers, Visual Basic, Crystal Reports.
This System is developed in SQL Server 7.0 with Visual Basic
as the Front-end. This System is used to record the Child /
Student Abuses. This system is developed for Department of
Public Welfare, PA. When a Phone Call comes from the Public
/ County about abuses, the information is recorded in the
Main Office. The data is transmitted to the county for
investigation. Once the investigation is done, again the
data is transferred back to the Main Office. The Main Office
(State) maintains all the data and it is expunged as per the
State Laws.
My primary responsibilities in this project include:
Database design and data modeling using ERWIN.
Installation of SQL Server in the Server and Client PC's.
Maintenance of SQL Server Databases.
Creation of Stored Procedures, Functions, and Triggers.
Creation of users, assigning privileges and tuning up of
system performances
Transferring data's to the counties through Replication.
Involved in Conversion of data from old system. The data is
loaded into the SQL Server database by Data Transformation
Services.
Performance monitoring and database tuning.
Prepare and execution of Disaster Recovery plan
Generating adhoc reports for internal customers using Query
Analyzer.
Review, test and deploying new application releases.
Involved in the development of reports in Crystal Reports
8.5 both for internal and external customers.
Triggers are used to enforce security authorizations and
also to keep an audit trial of a table. This project also
involves conversion of data from Old System. The data is
loaded into the SQL Server Database by DTS. Created
Necessary scripts to load the data into the SQL Server
Database.
Most of the reports are done through Crystal Report. In all
the modules, the user has an option to view the report on
the Screen or to print the report. The User can even print
selected pages of the report. The User can even download
the report data into any format like PDF, Word etc. I have
developed some of the reports in HTML Format. This gives
the user additional features by scrolling the report back
and forth. All the modules are totally Menu-driven and all
changes to the system are recorded in the audit table.
10/1995 - 4/1998 Spinneys AbuDhabi AbuDhabi, UAE
Software Engineer
Project: Core Accounting System
Environment: Powerbuilder, Informix
Duration: Jan 1997 - April 1998
Involved in the development and maintenance of Core
Accounting System for in-house department automation. The
modules involved in this system are: Purchase Order
Processing, Sales Order Processing, Inventory Control, Cash
Management, Accounts Receivables, Accounts Payable and
General Ledger. Involved in training the user. Developed
system documentation.
Project: Oracle OLAP
Environment: Oracle OLAP
Duration: June 1992 - April 1996
As a Software Engineer, I was responsible for the following:
Involved in the installation and development of Oracle OLAP
in Spinneys Abu Dhabi.
Installed and set up Oracle OLAP at each workstation.
Developed interface module in PCEXPRESS to load the data into
Custom Module in Oracle.
Developed necessary analytical reports based on the user
requirements.
Developed new OLAP modules and added new functionalities
according to the growing user needs.
Trained the user and developed system documentation
Employment Status: US Citizen
EDUCATION 6/1992 Master of Computer India-Chennai-Coi
Application mbatore
Master's Degree
Attended Master of Computer Application. The program is for 3
years. Some of the major subjects are: Database Management
System, Computer Networking, Artificial Intelligence, and
Programming Languages (C, C
Technical Environment
OPERATING SYSTEMS Windows 2008/2003, UNIX
SOFTWARE ER Studio, Crystal Reports, ASP, HTML
DATABASES SQL Server 2008/2005/2000, Oracle 11g/10g
Contact this candidate