Sql Server DBA
Resume:
Suja James
Cary, NC
****.***********@*******.***
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