Sql Server Customer Service
Resume:
NARENDRA K. GARG
**************@*****.***
SUMMARY
. Experienced Sybase DBA using 11.x, 12.x, 12.5.x and 15.0.2,
replication server 12.x administration, Performance & tuning on Sun-
Solaris and HP-UX, database design & Application support.
. Experienced SQL DBA using SQL 2000/2005, Performance & tuning database
design & Application support.
. Experience with Oracle 8i installation, administration, Monitoring,
performance and tuning, Database backup & recovery
. Experience with Informix 9.30/9.40 installation, administration,
Monitoring, performance and tuning, Database backup & recovery on HP-
UX
. Experience in database design, replication administration and capacity
planning
. Excellent communication and interpersonal skills. Highly motivated
with strong commitment to quality and customer service
. Experience in Compliance for SOX related applications
Skills
Languages: TSQL, ISQL, PL/SQL, Bourne Shell, Korn Shell, Awk, VB 4.0
O/S: Sun Solaris 2.6,2.8, MS DOS, Windows NT, Windows 95, Windows 2000, HP-
UX-11.0
RDBMS: ASE 11.9.2, 12.0, 12.5, 12.5.x, 15.0.2 ASE Replication 12.0, 12.5,
SQL Server 7.0,2000, 2005
Oracle 8i
Informix 9.30 HC1 9.40 FC4
Tools: BMC Patrol, DBARTISAN, TOAD
Hardware: Sun E 45000/Ultra, HP9000-879, Windows 2000
CRM: Remedy (5.0)
Experience
Database Administrator June 09 to Dec 09 Bank Of America, DE
SYBASE DBA (Consultant)
. Installed and configured Adaptive Server ASE 15.0.2 and upgraded Adaptive
Server from 12.5 to 15.0.2 ESD#2
. Developed the script for deleting the old data stored in dbccdb database
on development, QA, UAT and production servers.
. Developed the script for modifying the ESM reports for database options
and file permissions on multiple servers for the auditing purpose.
. Developed the script for modifying the password expiration days of
multiple users from 30 to 90 days across all the servers of CARD
SERViCES DOMAIN.
. Added users and reset the password on multiple servers based on different
business lines.
. Worked on refreshing the databases by comparing and generating the DDLs
of the objects of all databases on Development and QA & report servers.
. Worked on generating the replication definitions and subscriptions for
the primary and reporting server setup of WARM STANDBY replication.
. Troubleshooting the production problems & replication.
. Provided the on call 24 x 7 production support.
Environment: ASE 12.5, 15.0.2, Hp-UX 11
Database Administrator Jan 08 to April 09 TIAA-CREF New York, NY
SYBASE DBA (Consultant)
. Installed and configured Adaptive Server ASE 15.0.2 and upgraded Adaptive
Server from 12.5 to 15.0.2 ESD#2
. Monitoring the disk space used by databases by getting the email alerts.
. Monitoring the maintenance activities including backup, restore, update
statistics & database consistency checking and index rebuild.
. Disaster recovery planning and implementation.
. Installed and configured Auditing for finding the DDL, DML & login
failures for SOX compliance.
. Perform backup and restore on demand.
. Warm Standby replication 12.5 setup and configuration.
. Implemented new releases on the Production servers with QA team and
developers
. Improved performance of poorly tuned stored procedures and queries
. Troubleshoot the production problems & replication
. Provided the on call production support 24x7.
Environment: ASE 12.5, 15.0.2, Sun Solaris 2.8
Database Administrator July 07 to Dec 07 AIG Jersey City NJ
SYBASE/SQL DBA (Consultant)
. Installed and configured Adaptive Server 12.0 and upgraded Adaptive
Server from 12.0 to 12.5.0.3.
. Developed the script for creating the SQL statements for create and alter
database & disk init for creating devices for the disaster recovery.
. Monitoring the free disk space available across all the Production
Servers.
. Implemented the new releases on the Production server with QA team and
developers.
. Assisted the developers with troubleshooting, debugging SQL and stored
procedures.
. Installed and configured SQL server 2000 on Windows 2000 server.
. Monitored the scheduled jobs.
. Worked with developers to implement the change requests & putting
the new releases on the Production server.
. Worked on performance and tuning the queries.
. Troubleshooting the production problems for SYBASE and SQL server.
. Restoring the databases as requested, Recover/Restore as necessary.
. Tested and implemented log shipping technique for disaster recovery.
. Provided on-call 24 x 7 production support for SYBASE and SQL server.
Environment: ASE 12.0, 12.5.0.3, SQL Server 2000, Sun Solaris 2.8
Windows 2000
Database Administrator Jun 05 to June 07 Espeed, Inc New York, NY
SYBASE DBA
. Installed & configured ASE 12.5 & Upgraded the Adaptive server from 12.5
to 12.5.4.
. Modified the stored procedure for generating the columns and their data
types & changing the columns data type from SYBASE to Informix and
Informix to SYBASE.
. Developed backup & recovery plan for the system & user databases.
. Troubleshooting the database problems and replication.
. Provided 24 X 7 on call Production Support.
. Developed the shell script for finding the difference in notional values
for the brokers across the two databases and generated the html report
. Developed the shell script for finding the Trans numbers for 1 ticket_ref
in the same month & year.
Informix
. Installed & configured IDS 9.40 TC8 on Windows 2003.
. Developed the shell script to calculate the disk space used and available
on Unix Box.
. Developed the shell script for checking the number of virtual processes
running in order to shut down the server gracefully.
. Modified the shell script to restart the server by making the several
retries and sending the email
. Modified the script to send the email for percentage of used and free
dbspace.
. Developed the documentation for the SETNET32 by capturing the screen
shots.
. Developed the Script for finding the size of 1 table and all tables in
the database.
. Implemented replication by defining replicate, primary & target
participant for the tables data to be replicated
. Automated the process of backing up logical logs & whole backup using on
tape.
. Troubleshooting the database & replication problems and provided 24x7 on
call production support.
Environment: Informix Dynamic Server 9.30 & 9.40, HP-UX, SYBASE 12.5.4, SUN
SOLARIS 2.8
Database Administrator Sep 04 to Feb 05 NAPSTER LLC New York, NY
SYBASE DBA (Consultant)
. Installed and configured adaptive server 12.0 and upgraded Adaptive
Server from 12.0 to 12.5.0.3.
. Implemented the plan for backing up & restoring the system table's data
for the recovery of Master database.
. Developed the script for checking the replication server status, sending
the email for any problem about stable queue size, any thread down and
latency period in data movement across the replication server.
. Installed and configured WARM standby Replication server 12.5 using
resource files.
. Developed the script to get the columns and their data type for the
tables.
. Backing and restoring the system, user databases on disk & tape using
NETBACKUP.
. Monitoring the CPU usages & free disk space across all the Production
Servers
. Monitoring the space used by databases using DBARTISAN.
. Worked with developers & QA testing group to put the new releases on the
Production server.
. Automated the database maintenance jobs
. Troubleshooting and provided the on call Production support 24x7.
Environment: Sybase ASE 12.0, 12.5.0.3, SYBASE Replication 12.5, Sun
Solaris 2.8, DBARTISAN
Database Administrator Mar 04 to Jun 04 JP Morgan Chase New York, NY
SYBASE DBA (Consultant)
. Responsible for installation, upgrade, disaster recovery, performance
tuning and troubleshooting ASE servers versions (12.0, 12.5)
. Installed and configured Warm Standby replication 12.x and rematerialized
the data using dump and load.
. Troubleshooting for the problems related to replication server.
. Provided the on call support for databases of Global Markets, Fixed
Derivatives & Equities
. Monitored the database activities and replication for Global Market
databases and fixed derivatives.
. Developed backup & recovery plan for the system & user databases.
. Implemented the new releases on the Production servers with QA team and
developers.
Environment: Sybase ASE 12.0, 12.5.0.3, SYBASE Replication 12.5, Sun
Solaris 2.8
Database Administrator Oct 03 to Feb 04 Instinet (Reuters Group), NY
SYBASE DBA (Consultant)
. Installed & configured Adaptive Server 11.9.2 & upgraded Adaptive Server
from 11.9.2 to 12.x.
. Installed & configured replication server 11.5 using replication
definitions & subscriptions.
. Supported production and UAT releases on the production servers.
. Troubleshoot Database problems and replication.
. Provided 24X7 on call Production Support.
Environment: Sybase ASE 11.9.2, 12.0, SYBASE Replication 11.5, Sun Solaris
2.6
Database Administrator Apr 03 to Sep 03 Keystone Mercy Health Plan,
Philadelphia, PA
SYBASE DBA
. Installed & configured adaptive Server 11.5 and upgraded Adaptive Server
from 11.5 to 11.9.2.
. Implemented index rebuild and update statistics weekly maintenance job.
. Automated the backup procedure for backing up & restoring the system &
user databases.
. Developed the Shell script for generating the SQL statement for creating
the Create database statement with Alter database statement and setting
the database options.
. Developed the Shell script for generating the SQL statement for creating
the devices using Disk Init.
. Developed the Shell script for finding out the locking scheme on the
tables.
. Developed the Shell script for finding out the index keys on the table
having multiple indexes.
. Developed the Shell script for finding out in the database, how many
tables have clustered & non clustered indexes.
. Installed and configured Warm Standby replication 11.5.
. Created Excel Spreadsheet for defining the ASE errors for the purpose of
Replication.
. Troubleshooting the production database and replication problems
. Provided 24x7 on call production support.
Environment: Sybase ASE 11.5, 11.9.2, SYBASE Replication 11.5, Sun Solaris
2.6
Database Administrator Oct 97 to Oct 02 Dow Jones & Co. Inc. S.Brunswick,
NJ
SQL DBA
. Develop and implement archiving, backup and recovery strategies
. Tuning and optimization of SQL queries.
. Troubleshooting the production problems
. Provided the on-call 24 X 7 support.
. Worked with developers to resolve query problems.
Environment: SQL SERVER 7.0 Windows NT 4.0
SYBASE DBA, Replication Server Administrator
SYBASE
. Creation of triggers as required enforcing referential integrity.
. Creation of rules & defaults and binding them to appropriate columns or
user defined data types.
. Creation of indexes using information contained in logical database in
order to achieve the fastest response time. Creation of views to simplify
access to the database, maintain derived information and serve as power
security mechanisms.
. Creation of stored procedures to reduce network traffic & improve
performance. Estimating the size of the database objects, ensuring that
application makes best use of the existing indexes. Initializing physical
devices for the storage of the databases & transaction logs, designating
default storage devices.
. Putting the transaction log on separate device to keep it from competing
with other database activities for space.
. Creating and using segments for database tuning by placing tables &
indexes on specific segments to improve the performance.
. Granting and revoking the User permissions, developing a backup &
recovery plan. Keeping track of database changes Scheduling backups of
master & user databases.
. Backing up & restoring the system & user databases. Transferring the data
to & from the server with bulk copy (bcp IN/OUT) utility.
. Developed shell scripts for database backup, restore, DBCC, server
shutdown & startup.
. Developed the script for generating the SQL code for creating Replication
definitions & subscriptions of the objects to be replicated and checking
their validity in the database.
. Troubleshooting the problems of the Databases and replication. Scheduling
the Jobs, maintaining Production Data Structure.
. Configured Adaptive Server to achieve best performance using NAMED
CACHES.
. Installed & configured SYBASE CENTRAL for managing the databases &
replication.
. Provided 24x7 on call Production Support for the Projects of Dow Jones
Industrial Averages & Global Indexes.
Environment: Sybase ASE 11.5, SYBASE Replication 11.5, Sun Solaris 2.6
ORACLE
. Installation and administration of Oracle data servers. Analysis & design
of logical database. Implementation of the relational database from a
logical database
. Performed the tuning analysis of the production databases & tuned the
parameters to improve the performance.
. Created database, users & roles, profiles and managed the rollback
segments, table spaces & Indexing.
. Performed Oracle (8 & 8i) client installations and configured the client
Workstations using NET8 to connect to the database.
. Performed the database upgrades from version 8.0.5 to 8.0.6 & 8.1.7.4
. Developed the shell script for purging the various logs and archive files
& script for creating the database metrics of in-house various projects
and populating the excel spreadsheet with the database information.
. Developed the script for finding out the table space & index
fragmentation.
. Created the DBA checklist, which included Daily checklist, the Weekly &
the monthly checklist for database maintenance & tuning.
. Setting up of WARM STANDBY servers for the Production Databases.
. Developed the shell scripts for taking the physical & the logical
database backups & restoring the database.
. Created the CRON jobs for taking the export dumps of the database (full,
table level) and analyzing the tables & indexes for validating their
structure.
. Developed the script for taking the backup & recovery of the database
using RMAN and scripts for hot & cold backup of the database.
. Installed & configured OEM on PC to monitor various instances of the
Production environment & troubleshooting the problems in the database.
. Developed the script for offline utility DBV for checking the block
corruption in the database.
. Provided the 24x7 on call Production Support for the project PAGINATION
of WALL STREET JOURNAL & BARRONS, EDITORIAL SYSTEMS & WSJ.COM
Environment: Oracle 8i, Sun Solaris 2.6
Database Administrator June 96 to Aug 97 Bacharach Inst for Rehabilitation
Pomona, NJ
SYBASE DBA
. Implemented the database migration from Sybase (4.0) to System 11.
. Developed SQL queries & Stored Procedures, Tables, Views, Triggers.
. Developed & modified the reports using Data workbench. Developed the
script for restoring the database remotely
. Developed the module Database Manager for table, Stored Procedure, views,
Triggers, DWB reports definitions & showing the proper joins among the
table columns using OMNIS 3.2 under UNIX environment
Environment: Sybase 4.0, ASE 11.0, Sun Solaris 2.6
Programmer (Consultant) Apr 96 to June 96 The Molloy Group Parsippany, NJ
. Developed the module for Intel LANDesk Management Reporting System using
the Btrieve database & VB under Windows environment.
Programmer Analyst (Consultant) Nov 95 to Apr 96 Computer Horizons
Consulting, Inc. Parsippany, NJ
. Developed & modified the queries and stored procedures, tables using SQL
Server 7.0.
. Developed the module for holiday calendar (Project Claims Reengineering)
. Modified the various programs of project Assignment Rules Maintenance,
segmentation first entry log
. Modified the stored procedures used for printing the reports using the
Crystal report.
Programmer (Consultant) Sept 95 to Nov 95 Allied Information Services
Somerset, NJ
. Developed & modified the queries & stored procedures, tables using the
SQL Server 7.0
Programmer (Consultant) July 94 to July 95 Chemical Bank, New York
. Designed database for FMR (Financial Management Reporting Systems) &
developed SQL queries and stored procedures, table using MS SQL Server.
. Developed the Admin utility under Windows environment for creating the
dept location File using VB 4.0.
. Developed the line items utility, which adds & removes the organizations
in FMR and compare with the current FMR & MSA records using VB 4.0.
. Developed the FMRCALC program which creates the job table for processing
all the department locations using VB 4.0.
. Developed the module for checking status of the program FMRCALCR
System Engineer Associate Dec 92 to June 94 U.S. Army Picattiny Arsenal, NJ
. Designed and developed the database application program using Sybase, JAM
(JYAACK APPLICATION MANAGER) for the Work Order Status report based on
performing cost centers under UNIX environment.
. Designed the database and developed the SQL queries using the Transact
SQL and generated in financial application & provided the user support &
the training.
. Developed the SQL queries & stored procedures & triggers using the
Transact SQL.
. Developed the program for printing the mailing labels using C & DB
libraries under UNIX environment.
. Developed the program for the Report Summary on Performing Cost Centers
using C & DB libraries
Programmer Jan. 87 to Nov. 88 Integrated Micro Solutions, Inc.
Houston, TX
. Developed, modified & implemented the application programs for customer
software Support using DBASE III plus.
Programmer Analyst Apr. 83 to Dec. 86 Modi Alkalis & Chemicals Ltd. New
Delhi, India
. Developed the application programs for accounts payable & receivable &
payroll, Order Entry, Inventory control using COBOL on PDP-11/70 under
RSX-11M
EDUCATION
MS Computer Science May 1994
New York Institute of Technology, NY
MS Mathematics
Lucknow University, Lucknow, India
SQL server 2005 training
REFERENCES:
Available upon request
Contact this candidate