Arul Thiru

***** ******** ****** ***** # ****

Houston, TX – 77065.

Phone: 501-***-****

acp2e3@r.postjobfree.com

PROFESSIONAL SUMMARY

Total 18 years of IT experience that includes SQL Database Administration, System Analysis, Design,

Development and Support of MS SQL Servers 2014,2012,2008R2,2005, 2000 and 7.0 in Production, QA,

Reporting Services, Development environments & Replication and Cluster Server Environments.

Experience in Installation, Configuration, Maintenance and Administration of SQL Server

2014/2012/2008/2005/2000.

Experience in upgrading SQL Server from version 2000 to 2005 /2008/2012/ 2014.

Have good experience with partitioned schemas, partitioned tables and indexes, creating File groups using

SQL Server 2008/20005.

Good experience with SQL Server 2005 online Indexing and Recover y features.

Good experience with implementing DR solution, High Availability of database servers using Database

mirroring and replications and Log Shipping.

Experience in Data Migration Management.

Experience in implementing SQL Server security and Object permissions like maintaining Database

authentication modes, creation of users, configuring permissions and assigning roles to users.

Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.

Extensive experience in writing Distributed Queries between SQL Servers by creating link servers and

federated servers.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional

on basis of business specification.

Experience in performing integrity checks. Methods include configuring the database maintenance plan

wizard and DBCC utilities.

Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index

tuning wizard.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running

queries and deadlocks.

Experience in applying patches and service packs to keep the database at current patch level.

Experience in migrating packages from DTS to SSIS.

Good experience with Analysis Services, Reporting Services, and SQL Server Clustering.

Experience in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005/2000.

Experience in client requirement Analysis, Physical, Logical design, development (using Erwin,

normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing,

Deployment, Support and Maintenance of business applications using SQL Ser ver 2008/2005/2000, DTS,

SSIS, SSAS and SSRS 2005/2008.

Experience in Installing, Upgrading and Configuring Microsoft SQL Server2014/ 2012/2008/2005/2000.

Expert in TSQL DDL/DML performs most of the SQL Server Enterprise Manager and Management Studio

functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non -clustered indexes and indexed

views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T -

SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services

(SSIS), DTS, Bulk Insert, BCP.

Expert in design and development of SQL Server Integration Services (SSIS) packages and using various

control flow task and data flow transformation.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous

sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS

such as Data Conversion, Conditional Split, Bulk Insert, merge and un ion all.

Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports,

Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP

databases.

Expert in designing complex reports like reports using Cascading parameters, Drill -Through Reports,

Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSR S)

based on client requirement.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehous ing and

data modeling concepts.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under

minimal direction and supervision.

Good understanding of Functional Knowledge in all kinds of business like Government, Health care,

Financial and Retail domains.

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003/2008 Server, Windows 95/98/XP/NT

Databases: MS SQL Server 7.0/2000/2005/2008/2012/2014, MYSQL, Oracle8/9i

Languages: T-SQL, PL/SQL, C, C++, and Core Java JDK 1.1

SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio

2008, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor,

OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard,

Index Tuning Wizard, SSIS, SSAS, SSRS, Microsoft Clustering Services

(MSCS)

Report Tools: MS Reporting Services, SAS

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Database Modeling & Other Tools: ERWIN 4.x, Quest Litespeed, Quest SQL Spotlight, Redgate SQL Compare,

SQL Trace

EDUCATION & CERTIFICATION

Masters in Computer Applications (MCA) – Bharathidasan University INDIA

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified IT Professional (MCITP) Database Administrator SQL Server 2008R2

Microsoft Certified IT Professional (MCITP) Database Developer SQL Server 2008R2

PROFESSIONAL EXPERIENCE

Organization Name Location Title Experience

Houston Police Department (HPD), Houston, TX System Support Analyst -IV 5 Months

City of Houston

Fiserv – ( Financial Services ) IRVING, TX Senior Database 11 Months

Administrator

Arkansas Department of Education Little Rock, AR SQL Database Administrator / 10 Years

Developer

Arkansas Department of Human Services Little Rock, AR SQL Server Data Architect 2 Years & 5

Months

Aztec Technology Partners Inc. Dallas, TX SQL Server DBA 6 Months

JK Industries Limited New Delhi, India Senior System Analyst 5 Years

Houston Police Department, City of Houston, TX From Nov 2014 To Present.

System Support Analyst – IV

Responsibilities:

Working on the Migration of HPD applications in High Availability Solutions like Failover Clustering (WFSC)

and Always on Availability Groups (AO) in SQL Server 2014.

Additional responsibilities include analyzing existing database applications for performance tuning, alerting &

monitoring, working with application developers to integrate efforts with relational databases, participate in

team or company projects as required, maintain state -of-the-art knowledge of existing best practices in

database administration, design, and implementation, capacity plan ning and provides on-call support.

From December 2013 – Nov 2014

Fiserv IRVING, TX

Senior Database Administrator (SQL)

Responsibilities:

Maintained Microsoft SQL databases, including all client -facing environments, database backup, support of

databases across internal and end-user applications and disaster recovery tests.

Responsibilities includes improvements of database integrity through quality ass urance and manages

change control processes related the SQL environment.

Additional responsibilities include analyzing existing database applications for performance tuning, alerting &

monitoring, working with application developers to integrate efforts wi th relational databases, participate in

team or company projects as required, maintain state -of-the-art knowledge of existing best practices in

database administration, design, and implementation, capacity planning and provides on -call support.

From August 2003 – Dec - 2013

Arkansas Department of Education Little Rock AR

SQL Server DBA / Developer

Responsibilities:

Performed Server installations and configuration of SQL server 2012/2008R2/2005/2000.

Applied patches and service packs to keep the database at current patch level.

Responsible for configuration of Microsoft Server/Client Products and implementation.

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules,

Defaults, user defined data types and functions.

Defined relationship between tables and enforced the referential integrity constraints. Created Clustered

and Non-Clustered Indexes.

Responsible for General Database Administration and Performance tuning.

Experience in resolving deadlock and blocking issues for concurrent users.

Worked with DTS packages to load the massaged data into Data warehousing system.

Administrated MySQL Databases. Supported the MySQL development team.

Data Migration from legacy to master tables using DTS-Import and Export wizard.

Developed Database Backup Scripts and automated this process .

Used MS Visual Source Safe 6.0 as a Version Control System.

Conducted detailed system study and analysis of software applications.

Worked in all phases of the lifecycle of software development.

Experience in support, applications and software development.

Responsible for Database support, troubleshooting, planning and migration.

Resource planning and coordination for application migrations with project managers, application and

web app teams. Project involved guidance and adherence to standardized procedures.

Monitoring of database size and disk space in Production, Staging & Development environments.

Attended various meetings and conferences with application teams to meet corporate mile stones for

database consolidation and data migration. Security and architectural planning issues met as well as

testing and training.

Performed installation of SQL Enterprise 2012 64bit version on Windows 2008 servers on Enterprise

systems of clustered and standalone Dell servers in enterprise Data Centers. Patch applications.

Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.

Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.

Configured Database mail, linked servers in SQL server 2005.

Good Knowledge of using SSRS (SQL Server Reporting Services).

Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SSIS

package conversions. Business Intelligence package design.

Created tables and performed data imports and restore d for successful migration. Scripting development

and troubleshooting for various security syncing scripts to new databases as well as creation of database

roles for granting Stored Procedure rights.

Performed Production support and on Call duties.

Created monitoring scripts to alert for production issues.

Upgraded databases from SQL Server 2000 to SQL Server 2005.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases in the

production environment using the Database Maintenance Plan Wizard.

Setup backup and restoration jobs for development and QA environments.

Implemented disaster recovery solution at the remote site for the production databases using Log

Shipping.

Setup Database Maintenance Plans to reorganize indexes, re -indexing and update the index statistics on

the production databases.

Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the

database server performance.

Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Used DBCC commands to troubleshoot issues related to database consistency.

Used Index tuning wizard to redesign and created the indexes for better performance.

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Streamlined the server/database level security by creating the Windows and SQL logins with the

appropriate server/db roles and object level permissions.

Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform

Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for

different data loading operations for application.

Worked on upgrading DTS packages to SSIS packages.

Implemented trigger and stored procedures and enforced business rules via checks and constraints.

Worked with various business groups while developing their applications, assisting in database design,

installing SQL Server clients, phasing from development to QA and to Production environment.

Created lots of MIS Reports for the department using Crystal Reports, SSRS.

Environment: SQL Server 2000 / 2005 / 2008 R2 / 2012, Windows 2003/2008 Servers, T-SQL, Erwin 4.1,

JavaScript, MS IIS Server 7.0/6.0/5.0, HTML/DHTML, XML, Visual Studio 2005/2008/2010 .

From March 2001 – August 2003

Arkansas Department of Human Services Little Rock AR.

SQL Server Data Architect / Developer

Responsibilities:

Performed server installation and configurations for SQL Server 2005 and SQL Server 2000.

Performed installation of SQL Server Service Packs.

Upgraded databases from SQL Server 2000 to SQL Server 2005.

Involved in capacity planning, sizing and database growth projections.

Scheduled Full and Transactional log backups for the user created and system databases in the

production environment using the Database Maintenance Plan Wizard.

Setup backup and restoration jobs for development and QA environments

Created transactional replication for the reporting applications.

Implemented disaster recovery solution at the remote site for the production databases using Log

Shipping.

Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on

the production databases.

Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the

database server performance.

Used SQL Server Profiler to monitor and record database activities of particular users and applications.

Used DBCC commands to troubleshoot issues related to database consistency.

Used Index tuning wizard to redesign and created the indexes for better performance.

Created Stored Procedures using Execution Plan in T-SQL for better performance.

Streamlined the server/database level security by creating the Windows and SQL logins with the

appropriate server/db. roles and object level permissions.

Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform

Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for

different data loading operations for application.

Worked on upgrading DTS packages to SSIS packages.

Implemented trigger and stored procedures and enforced busi ness rules via checks and constraints.

Worked with various business groups while developing their applications, assisting in database design,

installing SQL Server clients, phasing from development to QA and to Production environment.

Environment: W indows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript,

MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Visual Studio 2005, Crystal Reports 11

From September 2000 – March 2001

Aztec Technology Partners Inc. Dallas, TX.

SQL Server DBA

Responsibilities:

Responsible for General Database Administration and Performance.

Data Migration from legacy to master tables using DTS-import and Export wizard.

Trouble shooting Problems by using SQL server profiler.

Updating with latest service packs and security patches.

Created views to facilitate easy user interface implementation, and triggers to enforce Data and

referential integrity.

Created indexed views in T-SQL to increase the query performance.

Develop Backup & Restore scripts for SQL Server as needed.

Created reports using SQL Server Reporting services.

Has done DBCC checks to ensure the physical consistency of the database and objects.

Developed a baseline management plan to facilitate change control in a rapid application Environment.

Developed and documented DBA processes and best practice guidelines with an in -house

Technical writer, which helped the department with year -end deliverables and timelines.

Environment: W indows 2000 server, VB6.0, XML, SQL Server 2000, Erwin 4.0, T-SQL, SQL Server Reporting

services.

From November 1994 – August 2000

JK Industries New Delhi, India

Senior System Analyst

Responsibilities:

This is a subsidiary of JK Organization having ISO – 9002 certification, a top leading business house in INDIA. They

manufacture tyres for all types of automobile and also have diversifications in other areas like Textile, Paper and Agro

Genetic Industries. The group turnover is 1000 crores per annum.

Project1: Purchase Management System.

Responsible for the entire life cycle of the project using Visual Basic 6.0 and MS -SQL Server 7.0 on Windows NT 4.0:

The system includes indents, inquiries, quotations, compar isons, purchase order (Indigenous), purchase order

amendments, budget monitoring and other online enquiries which caters to the top management and financial experts

of the company with extensive query and report facility.

Studied User Specifications

Designed a prototype

Database Installation, configuration and maintenance

Monitored, troubleshoot and performance tune SQL Servers and applications

Developed Backup and Recovery procedures for Production and Database Servers

Wrote scripts to schedule in tasks in SQL Executive.

Created and maintained Backups

Restored Databases and devices

Created Triggers, Stored Procedures, Tables, Indexes, Rules and Defaults

Created user accounts, groups, privileges and access levels

Supported various application in production and production rollouts

Imported and Exported Data using BCP utilities

Monitored, troubleshoot and performance tune SQL Servers and applications

Created Databases, tables, Indexes, new logins and users

Load and extracted large data using BCP

Project2: Inventory Management System.

Responsible for the entire life cycle of the project using Visual Basic 5.0 and MS - SQL Server 6.5 on Windows NT

4.0: This system was highly useful for the company to keep track of more than 20,000 items of stores department. It

includes material receipts, issues, and adjustments maintaining stock ledgers and other online inquiries with excellent

report facilities. Some of the critical stock statements and inventory value reports are generated to monitor the full

control of the inventory holdings.

Installing and configuring the server.

Designed and creating Database.

Installed Client Utilities for Remote administration.

Created tables, views, indexes, stored procedures, triggers and constraints.

Designed Backup/Restore Strategy.

Set up and maintain snap shot replication server.

Suggested different plans for Replication.

Managed SQL Servers in development and production.

Tuning And optimizing SQL Server by using performanc e monitor.

Creating and managing schema objects such as tables, views, indexes, procedures, triggers.

Database and Log Backups and restoration, backup strategies, scheduling backups.

Managing the use of disk space, memory and connections. Running DBCC.

Monitoring MS SQL Server performance.

Security Implementation. Administering the MS SQL server by creating users logins with appropriate

roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the

Privileges to Users and Groups.

Tested of applications for performance, data Integrity.

Data transferred between various servers using DTS.

Created and run DTS Packages for Import and Export of Heterogeneous Data.

Fine Tuned the Server to achieve Best Performance.

Project3: Sales and Production System.

Responsible for the entire life cycle of the project using Visual FoxPro 5.0 and MS - SQL Server 6.5 on Windows NT

4.0: This system helped to find the finished goods inventory, production and daily, weekly, monthly and yearly sales

details of the company. Accounting sales and journal vouchers were also generated through this system. This

application was also integrated with excise documentation system.

Processed Text files and storing in the Database.

Allocated System storage and planned storage requirements

Database Tuning for E-Commerce

Designed and implemented a Model OLAP Database for E -commerce And Telecom System

Maintained a Backup, recovery and other Maintenance Plans for Eight Database Servers

Created Triggers, Stored Procedures, Tables, Indexes, Rules and Defaults

Created user accounts, groups, privileges and access levels

Imported and Exported Data using DTS package tool and BCP

Wrote Procedures to implement business logic as per Business requirement

Migrated of SQLServer OLTP Database 6.5 to 7.0

The data had been moved into Analysis Service in multi-dimensional structure.

The cubes had been accessed through Excel and I.E. Through Microsoft Office components.

Project4: Payroll and Human Resources System.

This is a Group project which consists of three programmers. The project was developed in Foxpro -2.6 and later it

was converted into Visual Basic 5.0 and ORACLE. The system captures personal information of the employees pay

details, overtime details, attendance data from card swiping machine and other relevant information. Human

Resource System is developed for HRD department to monitor the training programmers fixed for various categories

of employees. The system accepts various parameters and helps the head of the department to appraise the

performance of employees throught the year.

Actively involved in the design, coding and testing of the application.

Created Menu driven application, which is really useful for users to handle the applications

without any difficulties.

Utilized Crystal Reports 4.5 for generating more than 20 complex reports on Payment

details, Pre-printed pay slip, Reports of Accounting & HR department, bank statement etc.

High level of Security measures incorporated for data security.

Created stored procedures at the backend to interact with the front end application.

Extensively used exception handlers to control the errors generated by the application.

Extensively worked with Visual Data Manager for importing and exporting of data between FoxPro to MS

Access and vice versa.

Implemented the manipulation of Popup-menus dynamically.

Documented the specifications, high level design and detailed design.

Project5: Finance System.

Designed and developed many modules for the finance department. This system was developed in FoxPro – 2.6 on a

multiuser environment.

a) TDS Module:

This system calculates and prints TDS certificates for all suppliers, contractors and Employees Income Tax returns

etc. for a given period.

b) Fixed Asset Register Module:

Developed a system to monitor fixed asset registers . The system accepts various parameters like cost center, main

head, voucher number, equipment name, supplier name etc. enabling and accounts department to take various

reports.

C) Contractor Expenses detail module:

Developed, designed and implemented this module successfully. This handles the contractor detail in efficient way.

Very useful reports are generated using these systems which are really useful for the management to plan

accordingly.

Project6: Security Office System.

Actively involved in the analysis, design, development an d implementation of this project. The system was developed

in Foxpro–2.6. This application includes modules to monitor incoming and outgoing vehicles and personnel to various

departments and other online inquiries which cater to the security personnel of the company.

Environment: FoxPro 2.X / Novell Netware 4.X, Visual Basic 5 .0 / ORACLE 6.0 / Windows NT 4.0 Visual FoxPro

5.0 / MS SQL Server 6.5 / Windows NT 4.0 ASP, Visual InterDev 6.0, MS SQL Server 6.5 / 7.0, Windows NT 4.0.

Contact this candidate