Suja James

**** ************ **,

Cary, NC

636-***-****

acn6cb@r.postjobfree.com

PROFESSIONAL SUMMARY

• Above 7 years of experience in Database Administration and Development for very large and

complex databases in SQL Server 2012/2008 R2/2008/2005/2000 comprising OLTP and OLAP

environments.

• 3 years of experience in MySql Database Administration, performance tuning and managing

upgradation and mastering the mysqladmin administrative client on version MySql 5.x

• Interested in working on NoSQL Environment like Apache Cassandra. Has undergone training from

Datastax Academy.

• Expertise in installing MS SQL Server 2012, 2008R2, 2008, 2005 and 2000, updating with latest

service packs, hot fixes and security patches.

• Dexterity in implementing different types of High Availability & Disaster Recovery scenarios like

Replication models (Snapshot, transactional), Log Shipping, Database Mirroring and Clustering on

SQL Server.

• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 as well as SQL

server 2005 into SQL server2008.

• Experience in working with SQL Server 32 bit and 64 bit environments.

• Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built

on SAN using RAID levels

• Proficient in SQL Server 2008 features like Merge Statement, Filtered Indexes, Policy Based

Management, Data Compression, Resource Governor, Performance Data Collector and Transparent

Data Encryption (TDE), Backup compression, Lock escalation and new data types.

• Implemented the SQL Server 2005 concepts like Data partitioning,Snapshot Isolation, Database

Mirroring, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, Online Restoring,

DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, Database Tuning Advisor, SQLCMD

• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query

Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities,

DMVs and DMFs.

• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent,

handling Backup(warm, hot and cold backups)/Recovery of databases, Replication, Linked Servers,

Database Maintenance Planning.

• Expert in using Native tools like SQL server profiler, database tuning advisor, perfmon.

1/6

SUJA JAMES SQL SERVER DBA

• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU,

I/O, Memory bottlenecks.

• Sound knowledge in writing complex SQL Queries, stored procedures, Normalization, Database

Design, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF),

Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and

update statistics in databases.

• Expertise in reading and understanding execution plan and fixing query to execute with low cost

using various operators depending on the scenario.

• Acquaintance in supporting Very Large databases (VLDB) 2TB and troubleshooting the problems in

OLTP Environment

• Expertise in extracting and transforming data using data transformation services like import/ export

wizard, BCP, Bulk insert, attach/detach.

• Prowess in planning and implementing Database Security by creating Logins, Users, Roles, and

assigning permissions to them.

• Expertise in working with Active Directory for user account management.

• Experience in tuning SQL Server Integration Services (Derivatives) packages, Analysis Services

(SSAS) cubes and Reporting Services (SSRS) reports and models.

• Proficient in high level design of ETL, DTS Packages and 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 Aggregate, Data Conversion, Conditional

Split, Bulk Insert

• Prior hands on experience in creating, maintaining and troubleshooting for Large Terabyte Databases

on MySQL environment

• Good working knowledge with stored procedures, triggers, functions, UNIX shell scripting,

partitioning, and indexesin MySQL

• Excellent experience in installations, configurations, administration, and performance tuning of

MySQL

• Experience using PowerShell (Windows and sql server), Unix shell scripting.

• Handled numerous Change Management requests on production servers

• Strong experience in writing documentation.

• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

SQL Server 2012, 2008/R2, 2005, 2000

Relational Databases

MySQL 5.x

Non-Relational Database Apache Cassandra

SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS,

Database Tools SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO,

ADO.NET, Business Intelligence Studio.

ITIL Tools Service Center, ICCM’s e-Service Desk, IBM’s Maximo Ticketing Tool

2/6

SUJA JAMES SQL SERVER DBA

Languages T-SQL, Unix Shell scripting, CQL

Operating Systems Windows 2008, Windows 2003, Windows 2000 server, 64bit & 32Bit

Non-Relational DBMS, Relational DBMS, Client-Server Architecture,

Architecture

Clustering, Replication, OLTP, OLAP

ETL SSIS, DTS

Microsoft Visual Studio 2003/2005, EMC Networker, PSS DIAG, IO

Other Tools

Stress

EDUCATION

Master of Computer Applications (MCA) Rajagiri College of social science affiliated to MG University

(2003-2006)

BSC Computer Science College of Applied Sciences (2000-2003)

COURSES

Datastax Academy: Installing and Configuring Apache Cassandra

Datastax Academy: Understanding the Apache Cassandra Architecture

Datastax Academy: Understanding the Read Path

Datastax Academy: Understanding the Write Path

Datastax Academy: Cassandra Query Language (CQL)

PROFESSIONAL EXPERIENCE

Quadratics Systems, India 10/2012Present

Senior SQL Server DBA

Quadratic Technology Solutions is a value added company that provides key IT consulting services,

specializing in providing business intelligence solutions to our clients. Founded in 1998, Quadratic has

provided clients un-surpassed quality and on-time delivery of all the projects and services undertaken.

Role and Responsibilities

• Installed and configured SQL Server 2005, SQL Server 2008, and SQL Server 2012 on WINDOWS

2003/2008 servers

• Applied service packs and security fixes in Clustered and Standalone environments

• Evaluate the peak and no peak usage pattern of the application; effectively distribute database

administration activities, such as full database backup and database defragmentation during no peak

hours.

Involved in maintenance and configuration of Database Servers to connect with SAN Storage

Environment.

SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution

Plans, used SQL Profiler for optimizing the store procedure

Developed SSIS packages to export data from OLTP database to OLAP database

• Responsible for Physical Storage Structures and Index Design and Tuning

• Setup and Maintain Always On feature

UST Global, India 09/2011 – 10/2012

1 year 1 month

Senior SQL Server DBA

3/6

SUJA JAMES SQL SERVER DBA

UST Global is a leading provider of end-to-end IT services and solutions for Global 1000 companies. A

client-centric Global Engagement Model that combines local, senior, on-site resources with the cost,

scale, and quality advantages of off-shore operations is used.

Role and Responsibilities

• SQL Server 2008/2012 installation, Patching and Upgradation

• Setup and Maintenance of Transactional, Peer-to-Peer and Merge Replication.

• SSIS, SSRS Installation and Configuration

• Creation of Maintenance plans for Backup and Recovery, Auto defragmentation

• Update Statistics, Recycling Error log and CheckDB

• Analyzing performance bottlenecks with the help of Performance Analysis and Tuning tools such as

PAL, SQL Profiler, Database Tuning Advisor

• Fixing job failures

• Performing daily health checks

• Used Dynamic Management Views (DMV) for most of the activities.

• Setup and Maintenance of Always-On

Tesco HSC, India 02/2010 – 09/2011

1 year 7 months

SQL Server DBA

Tesco Hindustan Service Centre (HSC) is the global services arm for Tesco worldwide.

The global service operations of Tesco HSC are involved in creating and executing strategic initiatives for

Tesco retail stores worldwide. These strategic initiatives cover the IT, Business, Financial and

Commercial aspects, among others, of Tesco operations. The operations cover all internal and external

platforms that drive Tesco's business, making it one of the world's most preferred retail stores.

Role and Responsibilities

• L2/L3 Support for SQL Server Databases

• SQL Server 2008 installation, Patching and Upgradation

• Building Monitoring Scripts for ensuring Healthy SQL Servers

• Managing 220+ SQL Servers and 4000+ SQL Servers which are used in Tesco Stores

• EMC Networker Tool used for SQL Server Backup and OS Backup

• Involved in Virtualization

• Performance Analysis and Tuning using PAL, SQL Profiler, Database Tuning Advisor

• Indexing

• Log Shipping

• Database Mirroring

• SQL Server Installation and Upgradation

• Database Mirroring and creation of Snapshots

• SQL Server Installation of 2008/R2 installation on Stand Alone and Cluster Server

• Standardization of Servers before taking into support

• Providing recommendations for improving the infrastructure after analysis

MySQL

• Develop and support MySQL database replication

• Optimize MySQL database performance

• Estimate MySQL database capacities; monitor database capacity and usage

• Establish mechanisms for data backup/restore of relational databases

• Provide restoration services as needed Problem identification, troubleshooting, resolution, and index

tuning databases. Server startup/shutdown

4/6

SUJA JAMES SQL SERVER DBA

• Mastering the mysqladmin administrative client

• Using the mysql interactive client

• Performance Analysis

GVS Solutions, India 11/2007 – 10/2009

1 year 11 months

SQL Server DBA

GVS Solutions is one of the fast growing Software consulting and web designing company situated at

Cochin. We are specialized in web design, web applications, software development, e-commerce Websites

with Secured payment Transactions, multilingual portals, web hosting and Client Server technologies.

Role and Responsibilities

• SQL Server 2005 installation, Patching and Upgradation

• SSIS, SSRS Installation and Configuration

• Package building and deployment

• Creation of Maintenance plans for Backup and Recovery, Auto defragmentation and

Update Statistics, Recycling Error log and CheckDB

• Analyzing Performance Bottlenecks

• Fixing job failures

• Performing daily health checks

MySql Responsibilities

• User account maintenance

• Log file maintenance

• Database backup/copying

• Multiple server setups

• Software updates and upgrades

• File system security

• Server security

• Repair and maintenance

• Crash recovery

• Preventive maintenance

• Understanding the mysqld server daemon

Birlasoft Ltd, India 08/2006 – 08/2007

1 year

SQL Server DBA

Birlasoft is a Global IT Services provider and part of the 150 year old, multi-billion dollar CK Birla

Group. With a global workforce of over 4000 employees, Birlasoft deploys a host of innovative solutions

and service architectures across the global Banking, Financial Services, and Insurance and Manufacturing

industries.

Role and Responsibilities

• Involved in Database and Application SupportQL Server Installation of 2000&2005 on standalone and

cluster server

• Upgrade from SQL Server 2000 to 2005

• Managing authentication and authorization

• Backup and Restore of Databases

• Basic trouble shooting of Log shipping

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

5/6

SUJA JAMES SQL SERVER DBA

• 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

TSQL 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.

• Experience in design and development of SQL Server Integration Services (SSIS) packages and using

various control flow task and data flow transformation.

6/6

SUJA JAMES SQL SERVER DBA

Contact this candidate