Sql Server Manager
Resume:
[pic] [pic]
[pic]
Joseph Thadathil
E-mail: ********@*****.***
Phone: 917 - 442 - 6958
Summary
> Seven plus years of IT experience which includes six plus years in
Database Administration, System Analysis, Design, Development &
Support of MS SQL Server 2005/2000/7.0 in Production, Staging and
Development environments.
> Extensive experience in installing and troubleshooting SQL server in
Clustered environment
> Experience working with 24x7 Production support.
> Extensive knowledge of Relational Database Management Systems.
> Installed SQL Server 2008 & SQL Server 2008 R2 and upgraded SQL 2005
OLAP & OLTP server to SQL 2008
> Experience in Data Modeling using Visio and Erwin.
> Overall database design experience includes deciding the raid levels,
creating and mapping databases, Normalization, Security policies,
assigning proper indexes, creating stored procedures, functions,
triggers and data types.
> Experience in implementing different types of Replication Models such
as Transactional, Snapshot and Merge
> Experience in configuring and managing Linked Servers, data transfer
between SQL Server and other heterogeneous relational databases such
as Oracle
> Experience with Database Backup, Recovery and Disaster recovery
procedures.
> Experience in MS SQL Server installation, configuration, performance
tuning, client/server connectivity, query optimization, Database
Maintenance plans, Database Consistency Checks using DBCC.
> Experience in Migration of SQL Server current version (2005/2008) to
newer versions (2008/2012) in 32 and 64 bit Clustered/non-clustered
Environment.
> Experience in Supporting Large Databases, Troubleshooting and
documenting root cause analysis.
> Experience working with Window 2008/2008 R2/2003 Enterprise Server and
Windows server 2000..
> Implemented database mirroring with SQL Server 2005/2008.
> Implemented proactive monitoring scripts for production databases.
> Exposure in handling IIS web server files
> Experience in dealing network issues and other system administrative
tasks
> Experience in Extracting, Transforming and Loading (ETL) data using
SSIS Import/Export utility, BCP and DTS/SSIS Packages.
> Extensively used SQL LiteSpeed as Backup solution.
> Experience in using Veritas Netbackup to restore files especially
Database backup files.
> Experience in Implementing & designing SQL Server security policy as
per business requirement.
> Documented disaster recovery solution and participated in disaster
recovery drills.
> Experience installing Service Packs for SQL Server and OS in clustered
and non clustered environments.
> Experience in contacting Microsoft PSS and other vendors for product
and technical support.
> Worked with various ticketing system such as BMC service desk express,
BMC Remedy Tool.
Certificate of Excellence from Microsoft
> Microsoft SQL Server 2000 - Microsoft Certified Database Administrator
(MCDBA)
> Microsoft SQL Server 2005 - Microsoft Certified Technology Specialist
(MCTS)
> Microsoft SQL Server 2005 - Microsoft Certified IT Professional
(MCITP)
> Microsoft SQL Server 2008 - Microsoft Certified IT Professional
(MCITP)
TECHNICAL SKILLS:
Languages C, C++, T-SQL, XML, HTML Script, VB script, JavaScript,
PowerShell
RDBMS MS SQL Server 2012/2008/2008 R2, 2005, 2000,
7.0, MS-Access, Oracle
Ticketing Tools HP Service Manager, BMC service desk express 9.20,
BMC Remedy Tool
Quest Tools Spotlight, LiteSpeed 4.8, Foglight
Monitoring Tools Microsoft Operations Manager (MOM), Idera Diagnostic
Manager, Whatsup, Redgate SQL Reponse, Confio Ignite
Front End MS Visual Basic, MS Visual Studio 2012/2008/2005,
SharePoint 2007/2013
Operating Systems Windows NT, Windows 95/98/2000, Windows XP, Windows
Server 2003, Windows Server 2008 R2, Windows Server 2012
Education:
Master of Science in Computer Science, New York Institute of Technology,
Old Westbury, New York
Bachelor of Science in Computer Science, New York Institute of Technology,
Old Westbury, New York
PROFESSIONAL EXPERIENCE:
Boeing, Bellevue, WA August 2011 -
January 2015
SQL Server DBA
Description: Boeing is the world's largest aerospace company and leading
manufacturer of commercial jetliners and defense, space and security
systems. A top U.S. exporter, the company supports airlines and U.S. and
allied government customers in 150 countries.
Responsibilities:
> Respond to monitoring/maintenance jobs alerts, server as wells as
databases behavior and also to Sitescope alerts.
> Develop various SSIS/ETL packages for database
administration/maintenance purposes
> Designed SSRS reports for understanding database and server behavior
> Grant permissions to users/groups in production/TEST/DEV servers
according to Organization's SQL Server Server Policy through service
request
> Responsible for installing SQL patches and ensuring that supported
servers (clustered & non-clustered) have latest security hotfix.
> Perform third party clients (Oracle, teradata and IBM DB2 drivers) in
SQL Server database servers.
> Performs production deployment after normal business hours
> Acts as Shift Coordinator which manages and distributes workload
evenly among other shift members
> Involves in problem management process using ITIL system which
requires in performing root cause analysis (RCA) and permanent fix or
solution to a problem.
> Reviewed and revised Disaster recovery and backup policy in order to
ensure data are backed up as much as possible.
> Perform customer's request to restore data backups from remote server
using Netbackup tool
> Utilize SharePoint features to assign production deployment request to
rest of team members as wells as uploading process documentations
> Works on various projects/assignments as part of proactive measures to
improve database performance.
> Monitor server and database activities using third party tools like
Confio Ignite, Quest Foglight and also uses activity monitor, resource
monitor and windows Perfmon.
> Responsible for server build in SQL Server 2008 R2/SQL Server 2012 and
third party client installation in new servers and also documenting
those processes.
> Revise the maintenance plan in each supported servers in order to
reduce/eliminate the maintenance plan errors.
> Grant server level permissions to users/groups whenever needed
> Add and grant users to the windows global group in Active directory.
> Perform disk cleanup activity when disk is running out of space.
> Support Application team on migrating databases from SQL Server
2000/2005 to SQL 2008 and to SQL Server 2012.
> Provide recommendation to application developers in terms of SQL
server security as well as performance and tuning.
> Develop a SQL job status monitoring system for ticketing system
application.
> Works and coordinate with development team to enhance their
application performance.
> Pickup and works on various DBA tickets and its issue which comes in
team's queue.
> Manages and works on various Change management requests
> Provide 24x7 on-call production support in case it requires.
Environment: SQL Server 2012, SQL Server 2008 R2, SQL Server 2005, Windows
Server 2003,Windows Server 2008 R2, Visual Studio 2005/2008, SQL Litespeed,
Veritas Netbackup, Windows Perfmon, Confio Ignite, HP Service manager,
SharePoint 2007/2013
Wells Fargo Bank, San Leandro, CA October 2009
- July 2011
SQL Server DBA
Description: Wells Fargo & Company is a diversified financial services
company providing banking, insurance, investments, mortgage and consumer
and commercial finance through across North America and internationally.
Responsibilities:
> Assist in migrating SSIS packages which are the part of monthly ETL
process from SQL 2005 to SQL 2008.
> Designed SSRS reports for various business process for analytical
purposes
> Work with Change management team for proper approvals and auditing for
deployment and production changes.
> Respond to monitoring/maintenance jobs alerts, server as wells as
databases behavior.
> By using SQL monitoring jobs, Windows Perfmon, SQL Activity monitor,
server reports, almost all inbound and outbound database activities
are screened in timely manner.
> Provided Assistance/recommendation to Development team in identifying
and tuning/optimizing worst performance queries.
> Actively involved in failover from production environment to BCP
(Business Continuation Process) environment and coordinated with users
and related teams (Operation teams, Network teams, front-end
application team) in order to accomplish the BCP failover smoothly.
> Configured and monitored logshipping process from primary servers to
associated secondary servers.
> Assisted in configuring database mirroring in SQL Server 2008 for
multiple databases.
> Created SSIS packages for data transfer between different
environments.
> Develop SSIS packages and jobs in SQL 2008 for various ETL process as
wells as monitoring purposes.
> Installed and tested SQL Server 2008 R2 in development as well as
production servers.
> Responsible for Logical & Physical Database Design, Entity-
Relationship & Data flow designs.
> Revised the Disaster-Recovery Plans for having data loss minimally in
case it needs.
> Performed file management as part of DB administration tasks using
powershell scripts.
> Granted permissions to users in production/sandbox/UAT servers.
> Diagnosed and provided support in resolving various performance issues
in SSIS packages as part of ETL process
> Coordinated with development team to create hotfix for production
issues.
> Assist in designing and developing various databases application and
signing off in production environments.
> Responsible for auditing production deployment and changes to make
sure it went through proper change management process with approval.
> Provide 24x7 on-call production support in case it requires.
Environment: SQL Server 2008, SQL Server 2005, Windows Server 2003,Windows
Server 2008, Visual Studio 2005/2008, SQL Litespeed, BMC Remedy Tool,
Windows Perfmon
Intrans Group, Carle Place, NY March 09 -
August 09
SQL Server DBA
Description: InTrans Group is a leading ITS and Tolling Systems Integrator
headquartered in Long Island, NY with offices throughout the US, Caribbean
and North America. The project requirement is to resolve the performance
issues and support the new implementation as a part of their product
enhancement.
Responsibilities:
> Diagnosed and provided support in resolving various performance issues
like high CPU utilizations, I/O bottlenecks, query timeouts etc.
> Provided 24/7 (on-call) production support on rotation basis
> Helped development team in identifying and fixing poorly performing
queries, stored procedures and functions.
> Responsible for auditing production deployment and changes to make
sure it went through proper change management process with approval.
> Created stored procedures for automated security auditing.
> Identified and helped in creating the missing indexes and statistics
in various tables as part of the Performance tuning.
> Installed and configured SQL Litespeed for SQL Backup as a solution
for space management
> Re-designed back up policy and implemented backup process according to
new policy and created various maintenance plans
> Installed and configured Redgate SQL Response to monitor the system &
database behavior like index fragmentation, outdated statistics,
blocking/deadlock processes, high CPU utilization, heavy disk
read/write activities etc.
> Setup the replication (in SQL 2005) to report Servers in order to
minimize the load in production Servers.
> Installed and configured Reporting services.
> Created SSIS packages for data transfer between different
environments.
> Done capacity planning for SQL Server databases as per client's
requirement.
> Installed SQL Server 2008 and upgraded SQL 2005 OLAP server to SQL
2008.
> Used SQL Server 2008 Centralized management system for managing the
enterprise SQL Servers
Environment: SQL Server 2005, SQL Server 2008, SQL Profiler, Windows Server
2003, Visual Studio 2005, Redgate SQL Response
TownSports International, New York, NY February
08 - January 09
SQL Server DBA
Description: Town Sports International (TSI) health Club Company is the
largest in the Northeastern United States. TSI owns and operates the Sports
Clubs Network of clubs, which includes New York Sports Clubs, Boston Sports
Clubs, Washington Sports Clubs and Philadelphia Sports Clubs. Since 1974,
the Sports Clubs Network has since grown to include more than 135 health
and fitness facilities in four major metropolitan areas-New York, Boston,
Washington, D.C. and Philadelphia-with membership totaling more than
350,000. They have three locations in Switzerland also.
Responsibilities:
> Redesigned & updated data flow diagram of DSR (Daily Sales Reporting)
process using MS Visio.
> Provided 24/7 on-call support on rotation basis for production
support.
> Troubleshot various issues happened during DSR (Daily Sales
Reporting), MSR (Monthly Sales Reporting) jobs execution which in
turns push data to Cognos Reportnet interface to generate reports.
> Worked with Change management team for proper approvals and auditing
for deployment and production changes.
> Performed daily monitoring of the database performance and used
WhatsUp application for disk utilization & network issues.
> Re-designed back up plan and implemented backup process according to
updated backup plan and utilized SQL Litespeed features.
> Responsible for resolving and assigning tickets which are in DBA team
queue.
> Maintained and supported the databases dedicated to Kronos application
(application used to deal employee's timesheet).
> Upgraded SQL Server 2000 to SQL Server 2005 in 32 and 64 bit
Clustered/non-clustered Environment.
> Worked with system administrators for Creating/modifying user/group
accounts in Windows Active Directory in order to authenticate SQL
server users through domain group/user accounts.
> Created/modified users by assigning permissions on databases according
to security policy.
> Created SQL monitor jobs to ensure daily &weekly backup jobs and other
important jobs are running without failing.
> Create stored procedures, scripts, cursors for data transfer among
servers and designed various DTS/SSIS packages for daily sales
reports.
> Creating SSIS packages for archiving data and Data Migration.
> Automated the refreshing process of databases in test and UAT
environments from databases in production environment.
> Installed, configured and supported various servers in DEV/UAT
environments
Environment: MS SQL server 2005, MS SQL server 2000, Windows 2003, Windows
2000, SQL Litespeed, Kronos Workforce Central 5.1.9,
Cognos Reportnet 1.1, SQL profiler.
Microsoft Corporation, Redmond, WA February 07 -
January 08
SQL Server DBA
Description: Microsoft Corporation is a multinational computer technology
corporation that develops, manufactures, licenses, and supports a wide
range of software products for computing devices. Windows Live, a product
from Microsoft is the collective brand name for a set of services and
software products from Microsoft. A majority of these services are Web
applications, accessible from a browser.
Responsibilities:
> Daily monitoring of the database performance and network issues of the
Windows Live servers.
> Provided 24/7 on-call support on rotation basis for production support
for Windows Live operations.
> Conducted root cause analysis of application unavailability and narrow
down to issues related to coding practices, database bottlenecks, or
network latency.
> Monitored health of database and alerts from MOM (Microsoft Operation
Manager) application.
> Redesigned database architecture with help of Microsoft Database
development group and internal staff to increase application
concurrency and performance.
> Participated in Yukon (SQL Server 2005) migration process in 32 and 64
bit Clustered/non-clustered Environment.
> Modified stored procedures, scripts, cursors for the Bulk application,
tested them on the test servers and moved them to production servers
of Windows Live operations.
> Rebuilt indexes on various tables as part of query tuning and
optimization of procedures.
> Worked with system administrators for Creating/modifying user/group
accounts in Windows Active Directory in order to authenticate SQL
server users through domain group/user accounts.
> Created/modified users by assigning permissions on databases according
to security policy.
> Maintained both DEV and PRODUCTION servers in sync which are dedicated
to operations of Windows Live.
> Installed Database Management Software for SQL Server on the server
and client machines, provide connections and manage databases.
> Created various crystal reports and scheduled them as daily and
monthly reports.
> Created documentation to install SQL Server 2005, apply service pack,
hot fix and clustering installation.
> Helped Development Team in deploying and testing the application in
DEV/UAT environment.
> Performed troubleshooting of root cause/incident through custom made
ticketing system and assigned tickets to DBA team members.
> Applied SQL deployments to UAT & Production servers through Change
Management Request (CMR) process.
Environment: MS SQL server 2005, MS SQL server 2000, Windows 2003, Windows
2000, Microsoft
Operation Manager, SQL Litespeed, SQL
profiler.
Plugg Inc, South Hackensack, NJ October 2004 -
December 2006
SQL Server Developer
Description: Plugg Inc. is a multi-national wholesale clothing merchant.
"Plugg" one of the leading brand in Junior Girls fashion and Men's apparel
is a product of Plugg Inc. They have around 4000 customers located all over
the world. In US Macy's, JC Penney, Sears have deep routed business
relations with Plugg Inc.
Responsibilities
. Implemented the migration of SQL Server 2000 to 2005.
. Successfully implemented Database Mirroring in SQL Server 2005 for
high availability.
. Performance tuning, and optimization of procedures and queries.
. Rebuilding indexes on various tables.
. Resolving locking and blocking issues.
. Installed, configured and maintained transactional replication One
Publisher and 3 subscriber environment for production servers. These
subscribers are located in LA, NJ and NY.
. Responsible for Stored procedure optimization, Performance tuning.
. Involved in tuning the database and server performance. Worked with
Profiler to trace and tune the database.
. Partitioning tables to achieve better performance for access and
writes.
. Additionally, designed and implemented a disaster recovery system.
. Creating SSIS packages for archiving data and Data Migration.
. Creating Logins and Roles with appropriate permissions.
. Actively involved in Normalization (3NF) & De-normalization of
database.
. Designed security schemes
. Created documentation to install SQL Server 2005, apply service packs
and hot fix
Environment:
Microsoft Windows Server 2003, Microsoft SQL Server 2000,
Microsoft SQL Server 2005, Microsoft Visual Studio
Additional Information
Work Status: U.S. Citizen
Contact this candidate