Sql Server Project
Resume:
SUDEEP KOSHY
Sr. SQL DBA/Developer
OVERVIEW
. Offers 8.5 years of experience as a Microsoft SQL Server 2000, 2005,
****, **** ** *** **** DBA including implementation of iWay Designer,
Service Manager and Transforms during support of iWay Production
System for clients (COTY) as well as development of Data Quality
Cleansing (DQC) plans for the purpose of Database cleansing and de-
duplication.
. Very good experience in installing, maintaining and implementing
Microsoft SQL Server 2000, 2005, 2008, 2008 R2 and 2012.
. Currently working as a DBA for SQL Server 2005, 2008 R2 and 2012
databases.
. Excellent backend skills in creating SQL objects like Tables, Stored
Procedures, Views, Indexes, Triggers, Rules, Defaults, User-defined
Data Types and Functions.
. Experience in Query Optimization & Performance Tuning using SQL
Profiler, Execution Plan, Performance Monitor and DBCC Commands.
. Experienced in Database Backup, Disaster Recovery Procedures and
Replication (Snapshot, Merge & Transactional).
. Has knowledge of Analysis Services, Integration Services & Reporting
Services, SQL Server Clustering and Log Shipping.
. Extensive experience in the creation of complex reports using Crystal
Reports.
. Worked on applying Fixes and Patches.
. Responsibilities undertaken include Security Analyst, Security
Administrator, Production Support, Upgrader and Migrater.
. Has very strong background in a disciplined software development life
cycle (SDLC) process and has excellent Analytical, Programming &
Problem Solving Skills.
. Has the ability to work in a fast paced environment, Good Team Player
and can work independently; helped database developers on technical
issues.
TECHNICAL SKILLS
. Development Tools: iWay Designer, iWay Transformer, iWay Integration
Tools and DQC Explorer.
. Reporting Tools: Crystal Reports.
. Administration Tools: iWay Service Manager, Security Administration
and Object Security, Application Server Administration and Web Server
Administration
. Data Management/Batch Processing: DB Visualizer and DTS.
. Operating Systems: UNIX, Solaris 2.6/2.7, Windows9x/NT/2000
/2003/2008/XP.
. Languages: C, C++, Java, SQR, People Code, T-SQL, PL/SQL.
. Database Systems: MS SQL Server 6.5/7.0/2000/2005/2008/R2/2012.
. Graphical User Interfaces: Visual Basic 6.0/5.0, Developer 2000.
. Web Tools: HTML, ASP, VBScript, JavaScript, XML (theoretical
knowledge).
CERTIFICATIONS
Microsoft Certified Technical Specialist (mcts) FOR Microsoft SQL Server
2008
EDUCATION
Masters in Electrical Engineering (MEE), University of Houston, TEXAS
Bachelor of Technology in Electrical and Electronics Engineering (B.Tech),
University of Calicut, INDIA
PROFESSIONAL EXPERIENCE
Rabobank International, New York, NY
(August 2013 - Present)
Role: Sr. SQL Server DBA
Responsibilities:
. Responsible for configuration of SQL Server 2005 and 2008 R2 databases
on Microsoft Windows 2003 and 2008 R2 servers respectively.
. Performed installation and configuration of SQL Server 2008 R2 and
2012 (Denali) databases on Microsoft Windows 2008 R2 servers.
. Performed required patching of 2005, 2008 and 2008 R2 servers to make
them SQL-compliant.
. Performed restores/refreshes from 2005 and 2008 R2 database backups to
facilitate ongoing product development and testing.
. Modified partitioning structure on existing partition scheme in order
to improve performance as well as split non-partitioned data.
. Implemented a customized automated Log Shipping alert job run through
BMC Control-M over several key environments in order to negate the
need for daily Log Shipping checks done manually.
. Implemented improved Index optimization for different environments as
current setup was unable to capture all high and medium fragmented
indexes with high page count.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Implemented Capacity Planning job to retrieve database size as well as
PowerShell script job to retrieve disk space usage in order to project
growth trends in databases across different environments.
. Implemented database standards and naming convention for the database
objects.
. Responsible for General Database Administration and Performance
tuning.
. Created and maintained users and user groups.
. Performed Database Consistency Checks.
Environments: SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Windows
Server 2003, Windows Server 2008 R2, Visual Studio 2010, Citrix/BMC Control-
M, T-SQL
OIG (Office of the Inspector General), Harrisburg, PA
(January 2013
- July 2013)
Role: Sr. SQL Server DBA
Responsibilities:
. Responsible for configuration of SQL server 2005 database on Microsoft
Windows 2003 server.
. Performed installation and configuration of SQL Server 2012 (Denali)
database on Microsoft Windows 2008 server.
. Created backups from 2005 database environment and restored them in
the 2012 environments in order to test compatibility of the older
version; made the necessary changes to various objects such as tables,
columns, related stored procedures to conform to the new version
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Implemented database standards and naming convention for the database
objects.
. Identified dead code (procedures and functions that are never invoked;
tables or views that are not written to nor read from, data types that
are not used).
. Evaluated cursors to determine if row-by-row processing is necessary
for the functions using them, and replaced them with a more efficient
method.
. Involved in creating Clustered and Non-Clustered Indexes.
. Responsible for General Database Administration and Performance
tuning.
. Created custom Database scripts that involved creation of all required
tables in the target Database while keeping the original settings of
the tables in the source Database.
. Tuned SQL Queries using SQL Profiler as well as tuning the Database.
. Created backup recovery schedules and backup scripts.
. Created and maintained users and user groups.
. Performed Database Consistency Checks.
. Documented all changes and maintained all SQL documents.
Environments: SQL Server 2005, SQL Server 2012, Windows Server 2003,
Windows Server 2008, ASP.NET, Visual Studio 2010, Visual Studio 2012, T-SQL
AgileMindz Technologies, New York, NY
(November 2010-December
2012)
Role: Integration Tech. Lead/DBA
Responsibilities:
. Responsible for installation and configuration of SQL server 2008 and
2008 R2 databases on Microsoft Windows 2003 server.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Implemented database standards and naming convention for the database
objects.
. Designed, deployed, executed and scheduled SSIS packages to extract,
transform and load data from different file based system to SQL Server
database.
. Designed multiple Data Quality Cleansing (DQC) plans for client
ProTrans in accordance with the cleansing/transformation rules
provided by the same.
. Extensively used regular expressions for the purpose of pattern
matching in order to capture valid portions of the values in the
Database columns whilst excluding the undesired variables or special
characters.
. Created custom Database scripts that involved creation of all required
tables in the target Database while keeping the original settings of
the tables in the source Database.
. Customized each object of all DQC plans created to account for the
different temporary variables/fields used during execution of each
plan.
. Created profiles of each plan that was executed in order to show a
comparison between the pre-cleansed and post-cleansed data which
included charts and frequency tables.
Environments: SQL Server 2008, SQL Server 2008 R2, Windows Server 2003,
Visual Studio 2008, T-SQL
LynchVal Systems Worldwide Inc., New York, NY
(June 2008 - October 2010)
Role: Integration Technician/DBA
Responsibilities:
. Designed and implemented the process workflow using the iterator and
SQL objects and publishing them to the repository.
. Responsible for installation and configuration of SQL server 2000
database on Microsoft Windows 2003 server.
. Provided 24x7 Production support for the database and application
issues.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Implemented database standards and naming convention for the database
objects.
. Developed SQL scripts for maintaining administration tasks.
. Involved in creating Clustered and Non-Clustered Indexes.
. Responsible for General Database Administration and Performance
tuning.
. Implemented Data Warehouse system that utilized SQL Server Reporting
Service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server
Integration Service (SSIS).
. Created multiple sub-processes for re-use in different processes as
well as updating the database using the SQL object.
. Created and deployed channels pertaining to the corresponding process
flows in addition to their inlets, routes and outlets.
. Successfully ran the deployed channels and provided the necessary
documentation.
. Successfully created mapping interfaces for COTY which included
transforming of data from SAP Idocs or to SAP Idocs.
. Created process flows and generic error routines for the different
interfaces for COTY and used the appropriate naming conventions;
created channels that were configured to run on the COTY development
server using the appropriate listener (SAP or MySAP listener for SAP
Outbound and File listener for SAP Inbound interfaces).
. Monitored processes under the various configurations for COTY
production support and performed 1st level support error handling on
the processes either with processes that were stuck or a problem with
the listener involved.
. Provided 2nd level support for the COTY production systems as well as
training for the 1st level support team.
. Implemented and deployed FTP and directory automation programs in
production which allowed automatic monitoring of different FTP servers
as well as folders that are present over the 7 production boxes being
monitored.
. Successfully migrated configurations and interfaces over different
servers on the COTY production systems and applied the necessary
packages/archives to implement updated functionality of the
interfaces.
. Created new configurations on the production system as specified by
the client in order to support new order/shipment transactions that
were being handled by the system.
. Provided documentation on the different procedures that are involved
in the successful monitoring and support of the COTY production
systems.
. Created Tivoli tickets for COTY in order to address production issues
which needed a 3rd party to be involved (resending of IDocs in status
12 by the SAP Commercial Helpdesk Team).
. Created new users with the appropriate permissions/access for running
the FTP, directory and File Maintenance programs through the windows
scheduler.
Environments: SQL Server 2000, Windows Server 2003, Visual Studio 2008, T-
SQL, HTML
United Nations Headquarters, New York, NY
(August 2007 - April 2008)
Role: SQL Server DBA
Responsibilities:
. Responsible for installation and configuration of SQL server 2005
database on Microsoft Windows 2003 server.
. Created complex crystal reports for tracking applicants' profiles
using respective Recruiting tables.
. Created various Roles, Permission Lists, and User Profiles and
maintained them.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Created and supported DTS/SSIS packages.
. Implemented Database Standards and Naming Conventions for the Database
Objects.
. Developed SQL scripts for maintaining administration tasks
. Tuned SQL Queries using SQL Profiler as well as tuning the Database.
. Developed Stored Procedures and Triggers for the application.
. Maintained all SQL documents including installation and data
conversion procedure documents.
Environments: SQL Server 2005, Windows Server 2003, Visual Studio 2005, T-
SQL, PL/SQL
AT & T, San Ramon, CA
(May 2006 - June 2007)
Role: SQL Server DBA
Responsibilities:
. Responsible for installation and configuration of SQL server 2005
database on Microsoft Windows 2003 server.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Implemented SQL standards in writing Stored Procedures, Views,
Triggers, SQL Functions and Locking Issues.
. Recommended security changes and upgrades to enhance security
efficiency and to meet functional end user needs.
. Applied patches and service packs to keep the database at current
patch level.
. Implemented database standards and naming convention for the database
objects.
. Tuned SQL Queries using SQL Profiler as well as tuning the Database.
. Responsible for General Database Administration and Performance
tuning.
. Utilized SSIS packages to import and export data.
. Provided 24x7 Production support for the database and application
issues.
. Defined relationship between tables; created Clustered and Non-
Clustered indexes.
. Created backup recovery schedules and backup scripts.
. Documented all changes and maintained all SQL documents.
. Created and maintained users and user groups.
Environments: SQL Server 2005, Windows Server 2003, T-SQL
Barry - Wehmiller Companies, St. Louis, MO
(January 2006 - March 2006)
Role: SQL Server DBA/Analyst Programmer
Responsibilities:
. Responsible for installation and configuration of SQL server 2000
database on Microsoft Windows 2003 server.
. Created and configured new permission lists, roles and user profiles.
. Acted as point of contact for help desk or programmers when security
changes were required to be made or system failures occurred that
related to security.
. Involved in Analysis & Design Documentation and User Requirements.
. Developed scripts for maintaining administration tasks.
. Designed, deployed, executed and troubleshot/tuned SSIS packages.
. Created Database Objects like Tables, Stored Procedures, Views,
Triggers, Rules, Defaults, user defined data types and functions for
this project.
. Interacted with users to troubleshoot problems involved with the
development of stored procedures.
. Defined relationship between tables; created Clustered and Non-
Clustered indexes.
. Responsible for General Database Administration and Performance
tuning.
. Documented all changes and maintained all SQL documents.
Environments: SQL Server 2000, Windows Server 2003, T-SQL
Smurfit - Stone Container Corporation, Alton, IL
(August 2005 - December 2005)
Role: SQL Server DBA/Analyst Programmer
Responsibilities:
. Responsible for installation and configuration of SQL server 2000
database on Microsoft Windows 2003 server.
. Involved in the Analysis and Design of the Database.
. Created and configured new Users and User Profiles; assigned
appropriate permissions for the same.
. Responsible for General Database Administration and Performance
tuning.
. Developed various T-SQL stored procedures/functions for the
application.
. Assisted the security administrators with various issues related to
giving access to users.
. Ensured all security issues were cleared in a timely manner and the
system functioned properly.
. Performed Database Consistency Checks.
. Interacted with users to troubleshoot problems involved with the
development of stored procedures.
. Documented all changes and maintained all SQL documents.
Environments: SQL Server 2000, Windows Server 2003, T-SQL
Contact this candidate