MSSQL Database Administrator
Resume:
MUNI MOHAN
*********@*****.***
SKILLS/TOOLS:
Software:
MSSQL Server 2008R2/2008/2005/2000, SSRS, MSSQL Replication, Mirror and
Cluster, Sybase ASE System 15.5/12.5/11/10, Sybase Replication server, Oracle
11g/9i, RAC, ASM, OEM Grid Control, Oracle Application Server, Report Server,
DBArtisan, SQL back track, Patrol SQL (monitor tool), ECS/Control-
M(scheduling tool), Autosys(scheduling tool) and Bradmark(monitoring tool)
Operating Systems:
Cluster/Non-cluster, UNIX, Linux, Windows 2000/XP/7.0
Hardware:
Windows, RS6000/AIX, Sun Spark’s, HP9000’s
PROFESSIONAL EXPERIENCE:
Consolidated Graphics
December 2011 to Dec 2012
Database administrator
Duties include Installing, configuring, mirroring, replication, supporting,
maintaining and migrating MSSQL server instances and SSRS. Configured
SSRS with NLB and Netscaler. Have scripted and provide audit reports. Since I
joined this company I have installed dozen clustered instances and have
migrated databases as many as 1500+ databases/Instance. All of this was
performed using T-SQl scripts from end to end. Maintenance jobs were created
using maintenance plan as well as T-SQL scripts where required. Very proficient
with performance tuning and disaster recovery planning and implementation.
Oracle11g and RAC hands on training completed.
Persistent Technologies
August 2011 to December 2011
Database Administrator
Client: Wells Fargo/Wachio
Administered Sybase database servers in clustered, non-clustered, Replication
and warm standby on SUN Solaris environment. Supporting infrastructure around
the Sybase environment. This includes Autosys, Bradmark tool, DBartisan etc.
Currently involved with coordinating with SA team for by-annual OS patching
which involves in checking compatibility of OS patch with Sybase versions
installed. Have been performing unit testing for Sybase in clustered and non-
clustered environment. Some replication and warm standby servers are also
involved in this testing and then final upgrade. Resolved security and connectivity
issues. Setting up and scheduling jobs for some instance which did not have
transaction log dumps.
IBM Global Services
July 2004 to April 2010
Database Administrator
Client: American Express / Ameriprise
Administered multiple databases and servers in a worldwide Windows and UNIX
environment. Was part of a team for creating and supporting a mix of SQL,
Sybase servers; database sizes varied up to 300GB
Duties included installation, configuration, maintenance, deployment, and
recovery of corrupt instances and databases; also, did troubleshooting of
performance issues and creating and installing various monitoring and
measurement tools
Installed and configured Patrol on Sybase and SQL servers
Unix scripts were created and tested for backup/restore, update stats, and dbcc
and log shipping in HA environment and non HA environment
Installed, managed, configured, troubleshoot replication server for American
Express
Tested failovers twice a year from active to standby and vice versa
Provided support in separation project of Ameriprise Group from American
Express. That included recommendations, project management, and installations
of new Sybase and MSSQL instances in UNIX and Windows 2000 in clustered
and non-clustered environment. Migrated databases. Did configuring and trouble
shooting of connectivity issues of ODBC and Tivoli monitoring
Provided support for Disaster Recovery for Sybase and SQL
Server databases. Assisted with the creation, testing and monitoring of DBMS
Infrastructure at mirror sites
Provided 24/7 support
Home grown tool was used by IBM for problem management and change
management tickets
Set up auditing and provided Sybase and MSSQL instance reports to the
auditors
Instructed SA’s with the raw device availability using SMIT for AIX and VERITAS
for Sun Solaris to make sure logs and data are not placed on same device.
Preferred OS mirroring OR RAID then Sybase Mirroring
Responsible for security and connectivity of the users
Client: Phillip Morris
Supported, installed and managed physical database instances for MSSQL
servers in clustered and non clustered environment
Created end to end solution for the conversion of Sybase to MSSQL
Created and performed Disaster Recovery exercise for MSSQL Instances at
Sterling Forest DR site
Installed, configured and managed Replication for PM account for MSSQL
instances
Provided 24/7 support
Williams Gas Pipeline, Houston, TX
April 1999 to June 2004
Senior Staff DBA
Supported and managed Common Financial System (CFS), Common Gas
Accounting (CGA) and O&E applications beyond the normal Sybase, Oracle and
MSSQL Server database support
Planned, developed and implemented disaster recovery for CFS (Sybase) and
CGA (Oracle) Systems in Denver Colorado IBM DR site
Scripted database downloads to refresh databases for Development, Test and
Training instances as needed using SQLbacktrack. Recovery was also done at
physical or logical level (database or individual table) if needed
Provided SA support for RS6000/AIX 4.3.3/5, SUN Solaris’s until Dec. 2004
Developed, implemented and supported security and critical data downloads to
history, data warehouse and non-production environments to reduce manual
security tasks
Developed and supported UNIX shell scripts for various DBA support functions
Conducted performance tuning - index analysis and implementation - lock
contention resolution - tempdb utilization
Installed, configured Sybase 12.5 on AIX Servers and migrated user databases
to new system
Installed, configured Oracle 9i on AIX and SUN Solaris’s
Supported the CFS Applications on Citrix Terminal Server Farm
Installed and configured Oracle Application Server, Report Server and migrated
web reports to upgraded version of Report Server for Gas Measurement System
Installed, configured, supported, and upgraded Control-M Enterprise and Control
Station.
Installed, configured, supported and upgraded SQL Backtrack for Sybase and
Oracle backups to TSM (Tivoli Storage Manager)
Installed, configured and deployed application tools and database administration
tools.
Installed, supported and managed Concur application (XMS, IIS, SQL Server
database)
Installed, supported and managed Document management application (Quillix
Imaging software, Panagon, IIS, SQL Server Database)
Maintained, enhanced and supported comprehensive migration tool for CFS,
CGA application and database objects
Developed and maintained the data interface from Common Financial system to
other systems, including XMS, Quillix, CGA, 1Line, Commodity Catalogue, Data
warehouse (for General Reporting System)
Developed and maintained the data interface for Common Gas Accounting
system to other systems, including CFS General Ledger, Accounts Receivables,
1Line and Gas Measurement Message Broker
Installed, supported, maintained and trouble-shoot CFS Job servers
Installed, supported and maintained mail Gateway on CFS Job servers
Communicated critical issues to vendors and work with support staff to determine
and implement problem resolutions
Supported and managed GEAC Smart Stream Job Scheduler, UNIX polls, and
ARPC poll on AIX
Remedy tool was used for problem tickets and change management
ENRON Capital and Trading, Houston, TX
March 1998 to Oct. 1998
Senior DBA
Responsible for administering Sybase, Oracle and MS SQL database for Capital
and Trading System
Installed, configured Sybase/Oracle servers, Sybase Replication Server and
replication agents for Oracle
Published and subscribed data from Oracle to Sybase and Sybase to Oracle
Installed and configured SQLbacktrack for backing up instances to Tivoli Storage
Manager
OXY/ MIDCO ENERGY, HOUSTON, TX
November 1996 to March 1998
Senior Database Administrator/ Technical Consultant
Responsible for overall administration of the Sybase Databases, SQL servers
and Replication servers for Midcon / NGPL
Migrated Sybase System 10 to System 11 on HP9000’s and RS6000/AIX 4.x, NT
and Sun Spark servers. Also, did new installation of Sybase System 11 and
Replication servers on HP9000’s, RS6000/AIX 4.x, NT and Sun Spark servers
Responsible for trouble-shooting problems with Sybase Server and Replication
Server. Created databases and logical devices and software mirroring. Also
responsible for backup/recovery of production (OLTP/DSS) servers
Created publication and subscriptions for data replication between Sybase on
UNIX servers and windows servers
Responsible for monitoring performance and tuning of Sybase Servers using
Sybase SQL-Monitor as well as replication servers
Implemented threshold procedures for logs and data to automatically monitor
databases and log space
I-NET / WANG TOOLKIT, HOUSTON, TX
April 1996 to November 1996
Database Administrator, Engineering Department
Responsible for installing/migrating, administering, managing, troubleshooting
Sybase Database servers for I-NET worldwide. Implemented thresholds
procedures and performed performance monitoring and tuning of Sybase
Servers using SQL-Monitor
Backup UNIX Administrator for the Sun Solaris System
CITY OF HOUSTON, HOUSTON, TX
September 1990 to March 1996
System Consultant, Controller Department
Responsible for Sybase Database Administration, Sun Solaris and Novell
Administration. Responsible for trouble shooting hardware/software problems
with servers and workstations. Also responsible for developing and maintaining
the overall Sybase Database including interface requirements to the mainframe
using SNA gateway to download the data. Developed and implemented data
backup strategies
Prior experience to 1990 available upon request
EDUCATION / CERTIFICATION:
M.S. Mathematics, University of Jammu, Jammu, India
B.S. Basic Sciences, Government College of Women, Kashmir, India
Certified Novell Administrator
Contact this candidate