Jayakrishna

972-***-****

acfwaq@r.postjobfree.com

. 10 + years of IT experience as Enterprise SQL Server Architect DBA

(2000, 2005, 2008 and 2008 R2, 2012) in Production, Development and

Test Environments.

. Good at system thinking where the moving parts of the system interact

with the whole infrastructure, with a knowledge of various / domain

business and lot of interpersonal and professional skills

collaboration,facilitation and negotiation skills very good

communication skills and written skills,

. Have extensive experience in Data Modeling, Relational Data Base

Architecture and Implementation, Systems Architecture and Development,

Database Administration and implementation of Administration Standards

& Practice using Sybase/MS SQL Server/Oracle/MySQL.

. I have been involved in large number of project development, managed

large number of Projects & been a DBA with large number of Data

Servers.

. Associated with financial services industry (Banking, Investment

Banking, Hedge Funds and some Insurance) and as well as Health and

Insurance industry, Pharmaceutical domain.

. I have a lot of liaison experience between technology, marketing,

operations and management. Very well versed in translating Business

requirements to Technology development/administration/maintenance.

. Well experienced in setting goals and priorities for technology to

reflect business needs and rules. I have been involved all facets of

Technology management and Business Liaison.

. Highly skilled in handling the enterprise level databases with

multiple terabytes of sizes, and mission critical DB's with proper

implementation of HA and DR.

. Expertise in Database Design, Administration, Implementation and

Application Development.

. Strong experience in designing implementing and supporting VLS data

warehouse DB's.

. Experienced in new OLAP database cache database.

. Worked on logical and physical database modeling with UML and ERWIN

tools.

. Database Evangelist for SQL/BI technology.

. Working closely with business and performing job duties and

responsibilities according to the organization's business systems

development methodology also its Systems Development Life Cycle (SDLC)

methodology.

. Experience in SQL Server 2005/2008 Installation, Configuration of

Stand-alone with multiple instance in Clustered and Non-Clustered

environments.

. Migration/upgrading of SQL Server 2005 to 2008 and applying Service

Packs.

. Migrating and new installations of SQL Server on Hyper-V & VMWARE

environments.

. Extensive experience in high availability SQL Server Solutions that

includes Mirroring and Clustering.

. Experience in creating Log Shipping and Replication (snapshot,

transactional (P2P) and merge) for various customers.

. Supporting the SQL Server instances, which are lying on the Windows

Hyper-V servers.

. Experience in evaluation of database performance, tuning, backup, and

restoring and disaster recovery of databases and enhancing the

Performance by table partitioning.

. Extensive experience in controlling the user privileges, roles,

monitoring the security and Audit issues.

. Worked with MySQL Environments for couple of clients with their

requirement for administration installation and configuration.

. Expertise in using various SQL Server Tools like Enterprise Manager,

Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS,

SSRS, SSAS and SSIS.

. Provided 24/7 support in monitoring, troubleshooting, optimization and

tuning of SQL Server environments and Good hands on performance and

tuning issues and developing and implementing emergency fixes,

resolving database problems.

. Monitored and tuned SQL Server performance using System Monitor, SQL

Profiler, Query Execution Plans and checking the consistency of

database using DBCC Utilities.

. Reviewed and optimized queries using index Tuning wizard, Database

Tuning Advisor to help dev teams to achieve better performance.

Documented solutions to database issues.

. Created maintenance plans to perform index de-fragmentation, re-

indexing and updating the index statistics. Expertise with Table

Design, Index Design and Performance Tuning, Table Partitioning.

. Involved in setting up SQL Jobs, Alerts, Database Mail and MOM.

. Good experience in SQL Server Programming, Integration Services and

Reporting Services.

. Migrating packages from SQL server 2005 to SQL Server 2008.

. Load data into ETL through different data sources like oracle,

Teradata, SAP.

. Experience in working with production and 24 x 7 on call environments.

. Strong mentor for serious workaholic.

. Creator and Owner of Social Group/Page in Facebook "SQLServer Labs",

this is just sharing my experience by trying to help community of

MSSQL, Oracle, MySQL DBA's. ( https://www.facebook.com/SQLServerlabs)

Education

Graduate in Electronics and Communication Engineering.

Technical Skills:

Database Versions: Microsoft SQL

Server, 2000, 2008 and 2008 R2, 2012,Oracle, Cache, Golden Gate, MySQL

Server 4, 4.5, 5+ Enterprise ( InnoDB)

Database Tools: SQL Server Management Studio, Enterprise Manager, SQL

Profiler, Query Analyzer, DTA, SSIS, SSAS, SSRS, Toad for SQL Server, RED

Gate Tool Belt.

Web Tools: MS-Front Page, Visual Studio 2008/2005, XML, CSS, HTML, and

IIS

O/S: Unix (Sun Solaris, IBM AIX, HP/UX), Linux (RHEL 4&5), OS/MVS,

VM/CMS, Windows XP, Windows 7, Server /2003/2008/ 2008 R2, VMware (VMware

Servers, Work Stations), Microsoft Hyper-V Servers

Hardware: Sun Servers, HP Servers, Wintel Workstations & Servers, IBM

Mainframe

Languages: Java, C#, C++, .Net, PL SQL, Shell Scripting, Perl

Tools: OLTP, OLAP, SQL Server Management Studio, DB Artisan, PowerBuilder,

Power Designer, RapidSql, Erwin Data Modeler, Oracle

SqlDeveloper, Toad for SQL Server, Toad for SQL Server,

Spotlight Enterprise, Fog Light Enterprise for SQL Server,

Oracle SqlLoader, NETIQ Plate Spin, Logic Monitor, SAN

Monitor

Professional Work Experience

PEPSI CO, Plano Texas

Sr. Database Architect & DBA

Duration: 2014 Feb

Description:

I was Database consultant for major migration project; I am responsible for

planning designing, requirement gathering, resource identification, pre and

post implementation and migration as well as administering the SQL Server

and oracle HA.

Responsibilities:

. Optimization of information management approaches through an

understanding of evolving business needs and technology capabilities.

. Work with solutions architect(s) to provide a consensus based

enterprise solution that is scalable, adaptable and in synchronization

with ever changing business needs.

. Management of the risks associated with information and IT assets

through appropriate standards and security policies.

. Direct or indirect involvement in the development of policies,

standards and guidelines that direct the selection, development,

implementation and use of Information Technology within the

enterprise.

. Primary responsibility as a Database consultant would be planning

designing and managing and requirement gathering, analyzing the

existing database systems and criticality.

. Planning the migration using various technologies like Plate Spin,

Replication, and Log Shipping & Mirroring depending on the criticality

of the application and database with minimum or no downtime.

. Designing and documenting the LLD's and HLD's and POC's where ever

required for smooth transition.

. Team coordination and resource onboarding as per requirement.

. Working closely with Client and business team to explain the migration

process and getting the feedback with the filling the bridge between

the Management and client.

. Preparing POC for the migration plan proposed.

The above listed roles and responsibilities are not limited above as

defined, work and responsibilities keep changing depending up on work and

assignment.

Alcon Laboratories, a Novartis company

SQL Server Database Administrator

Duration: 2013 Jan - Feb 2014

Description:

I have been involved in multiple projects implementation, maintenance and

Administration during my short period in Alcon Labs, I was the responsible

for implementation and administering the SQL Server. I have successfully

implemented and administrated many SQL Server technologies like and SQL

Server Mirroring, Clustering, Log Shipping, Data Archival process

Responsibilities:

. Installed, configured, administered and secured SQL Server

2012/2008/2005/ on Server and Clients.

. Gathering and Suggesting of Storage (SAN) with future analysis for top

notch performance and redundant.

. Managed Logins, Users, Roles and User permissions, and conducted

backup and recovery

. Involved in creating Schemas, Logins, Tables, Clustered and Non-

Clustered Indexes, Views, Functions and Stored Procedures.

. Installing TDP and Control-M agents for SQL Backup according to

the norms.

. Installed And configured cache database for vaccines and drugs

administration platform for unique requirement.

. Involved in General Database Administration, Query Performance

tuning, and validated some of the existing schema.

. New SQL Server 2008 R2 installations on VMware host servers and

Hypervisor environments.

. Developed administrative tasks of SQL Server of performing daily

Backups and recovery procedures

. Implemented high availability techniques mainly Replication, Log

shipping and involved in planning and monitoring Log Shipping.

. Optimizing VM I/O Performance is the number one concern for

running SQL Server on a VM. The bottleneck of most database servers is

I/O and not processing power. This is especially true for SQL Server

running on a VM.

. Created SAN storage replication with asynchronous type of replication

for one of the mission critical Pharmaceutical database, which is of

1.8 TB size data.

. Enhanced Performance of Database by implementing table partition

on multiple tables with hundreds of GB sizes, tuning by creating table

partition by date range, and also by creating multiple data file

groups for max utilization of I/O's.

. Performance monitoring and taking steps to improve the I/O

throughput is one of the most important factors when setting up SQL

Server VMs.

. Suggesting the rite hardware for hosting SQL Server on Hyper-V

like suggesting the different types of VHD's supporting Dynamic,

Virtual, and Pass through.

. Installed and Configured Transactional and Snapshot Replication

for production servers to other production servers available in remote

location and also to Reporting server.

. Successfully implemented Database Mirroring with High

Availability Mode in SQL 2005 and installed SQL Server in a cluster

Environment.

. Created alerts and notifications for system errors, insufficient

resources, and fatal database errors.

. Migrated from SQL Server 2005 to SQL Server 2008. And migration

of ETS packages to SQL Server 2008.

. Migrated SSRS Reporting Server from 2008 R2 to 2012 SQL Server.

. Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.

. Running DBCC Consistency Checks and fixing Data Corruption in

user databases.

. Helped developers team in developing and deploying SSRS packages.

. Scheduled and monitored all maintenance activities including

database consistency check, index defragmentation.

. Heavily used Transactional Replication, Configured between

Primary Server and three Read-Only servers and experience in

troubleshooting replication problems.

Environment:

SQL Server 2000, 2005 and 2008, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS) and SQL Server Analysis Services

(SSAS) and Windows 2000/2003/2008, and Toad Analyzer, Red Gate Tool Belt.

Michaels Stores Inc. Irving TX

SQL Server Database Administrator /MySQL Server DB.

Duration: 2010 Feb - 2012 Dec

Description:

I have been involved in multiple projects implementation, maintenance and

Administration during my tenure in Michaels Stores Inc., I was the Primary

person responsible for implementation and Administering the SQL Server. I

have successfully implemented and administrated many SQL Server

technologies like Merge Replication, Peer-to-Peer Replication, and SQL

Server Mirroring.

Responsibilities:

. Installed, configured, administered and secured SQL Server

2012/2008/2005/ on Server and Clients.

. Gathering and Suggesting of Storage (SAN) with future analysis for top

notch performance and redundant.

. Implementation of Merge Replication between Server and Client SQL

nodes.

. Installed MySQL 5 Community version and Configured and managed the 300

Gb database.

. Managed Logins, Users, Roles and User permissions, and conducted

backup and recovery.

. Worked with Netezza DB extracting and transforming data.

. Involved in creating Schemas, Logins, Tables, Clustered and Non-

Clustered Indexes, Views, Functions and Stored Procedures.

. Involved in General Database Administration, Query Performance

tuning, and validated some of the existing schema.

. New SQL Server 2008 R2 installations on VMware host servers and

Hypervisor environments.

. Developed administrative tasks of SQL Server of performing daily

Backups and recovery procedures

. Implemented high availability techniques mainly Replication, Log

shipping and involved in planning and monitoring Log Shipping.

. Implemented table partitioning depending on range.

. Optimizing VM I/O Performance is the number one concern for

running SQL Server on a VM. The bottleneck of most database servers is

I/O and not processing power. This is especially true for SQL Server

running on a VM.

. Performance monitoring and taking steps to improve the I/O

throughput is one of the most important factors when setting up SQL

Server VMs.

. Suggesting the rite hardware for hosting SQL Server on Hyper-V

like suggesting the different types of VHD's supporting Dynamic,

Virtual, and Pass through.

. Installed and Configured Transactional and Snapshot Replication

for production servers to other production servers available in remote

location and also to Reporting server.

. Successfully implemented Database Mirroring with High

Availability Mode in SQL 2005 and installed SQL Server in a cluster

Environment.

. Created alerts and notifications for system errors, insufficient

resources, and fatal database errors.

. Migrated from SQL Server 2005 to SQL Server 2008. And migration

of ETS packages to SQL Server 2008.

. Migrated SSRS Reporting Server from 2008 R2 to 2012 SQL Server.

. Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.

. Running DBCC Consistency Checks and fixing Data Corruption in

user databases.

. Helped developers team in developing and deploying SSRS packages.

. Scheduled and monitored all maintenance activities including

database consistency check, index defragmentation.

. Heavily used Transactional Replication, Configured between

Primary Server and three Read-Only servers and experience in

troubleshooting replication problems.

Environment:

SQL Server, 2005 and 2008, 2008 R2 SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis

Services (SSAS) and Windows /2003/2008, and Toad Analyzer, Red Gate Tool

Belt.

Deutsche Bank, Morrisville, NC

SQL Server Database Administrator

Duration: 2009 March - 2009 Dec

Responsibilities:

. Installed and configured SQL Server2005 /2008 in Production and

Development environments.

. Involved in upgrading MS SQL Server 2005 to 2008 on development and

test environments.

. Worked as an outsourced consultant solely responsible for designing,

developing and maintaining SQL Server databases containing customer

information.

. Design and implementation of database Logical and Physical

Schemas.

. Created Replication and Log Shipping for different customers.

. Implemented Log Shipping in SQL Server 2005 from Primary Server

to Standby Server.

. Responsible for creating, maintaining and monitoring mirrored

servers.

. Worked in failover cluster environment Active/Active and

Active/Passive nodes.

. Applied patches to SQL Servers in Cluster environment.

. Assist in developing Normalization.

. Estimation of Table sizes and Record sizes.

. Responsible for database tuning using normalization and

application tuning.

. Extensively involve in replication and implementation of

Snapshot, Transactional Replications.

. Successfully implemented Transactional replication, Clustering and

mirroring.

. Check Performance Tuning, Indexing, Query Optimization,

Integration of Third Party Databases.

. Used Performance Monitor/Profiler to solve Dead Locks/Long

running queries.

. Creation and maintenance of databases and objects like Tables,

Views, Indexes, Stored-Procedures, Triggers and Cursors, Users and

User Group creation and maintenance.

. Document disaster recovery plans and participate in disaster

recovery.

. Take different types of backup including transaction log, Perform

database consistency checks.

. Perform data migration between different environments and third

party databases.

. Interact with the users and troubleshoot the problems involved

with development.

. Schedule DBCC consistency checks.

. Good Knowledge on working with SSIS and SSRS. Helped dev team in

developing and deploying SSIS and SSRS Packages.

Environment:

SQL Server 2005 and 2008, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS) and SQL Server Analysis Services

(SSAS) and Windows /2003/2008, Tivoli.

State of Tennessee, Nashville, TN

SQL Server Database Administrator

Duration: 2008 March - 2009 Jan

Responsibilities:

. Installed, configured, administered and secured SQL Server 2005 on

Server and Clients tools. Maintained over 40+ SQL Servers in

Production, QA, Test and Development Environment.

. Designed, implemented, and administrated databases in SQL Server 2005,

2008.

. Managed Logins, Users, Roles and User permissions, and conducted

regular backup and recovery.

. Involved in creating Schemas, Logins, Tables, Clustered and Non-

Clustered Indexes, Views, Functions and Stored Procedures.

. Worked in failover Cluster environment Active\Active and

Active\Passive nodes.

. Applied patches to SQL servers in cluster environment.

. Implemented High availability techniques Mainly Replication, Log

shipping, Mirroring.

. Migrated SQL 32 bit version to 64-bit version on 2005 SQL Version.

. Involved in General Database Administration, Query Performance tuning,

and validated some of the existing schema.

. Installed, configured and maintained Reporting services boxes.

. Involved in supporting application team in production releases for

replication change and schema changes.

. Used SCOM and SQL Sentry to create alerts and notifications for system

errors, insufficient resources, and fatal database errors.

. Created SSIS Packages to migrate slowly changing dimensions

. Migrated packages from SQL Server 2000 to SQL Server 2005.

. Deployed SQL SERVER INTEGRATION SERVICES (SSIS) packages, Configured

Log shipping.

. Captured and analyzed the long running stored procedures using SQL

Server Profiler and tuned the same to optimize application and system

performance.

. Scheduled and monitored all maintenance activities including database

consistency check, and index defragmentation by DBDEFRAG and DBREINDEX

and statistics update.

. Helped application teams in query analyzing and its optimization.

Coordinating with users for downtime.

. Provided 24/7 in SQL production support.

Environment:

SQL Server /2000, Windows 2K/2003, SQL Profiler, Migration, ETL, DTS, T-

SQL, Litespeed, SCOM, SQL Sentry

Capitol One, Richmond, VA

SQL Server DBA

Duration: 2007 June - 2008 Jan

Responsibilities:

. Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.

. Monitored and tuned databases to meet the performance and availability

requirements of on-line systems and multiple applications.

. Implementing Automated Backup and Database Maintenance / Cleanup jobs

and high availability techniques.

. Managing the Clustering environment.

. Scheduled and monitored all maintenance activities of SQL Server 2005

including database consistency check, and index defragmentation by

DBDEFRAG and DBREINDEX.

. Monitored database status including CPU, memory, I/O, space, and dead

lock using SQL Server Utilities

. Modified DTS to SSIS packages to accomplish critical business logic.

. Defined Check constraints, Business Rules, Indexes, and Views.

. Configured Server for sending automatic mails to the respective people

when a SSIS process failure or success.

. Develop Data Warehouse ETL process using SSIS (Integration Service)

. Data migration (import & export - BCP) from Text to SQL Server.

. Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and

Networking).

. Used Erwin to reverse engineer the existing database design in MS SQL

Server 7.0

. Created Jobs to Automate & Scheduled many tasks.

. Created Multiple data file groups

. Used SQL Profiler for troubleshooting, monitoring, optimization of SQL

Server and non-production database code as well as T-SQL code from

developers.

. Worked on all phases of database management with application

development team and other vendors to maintain maximum availability.

. Had good experience in 24/7 in SQL production support.

Environment: SQL Server, Windows /NT, Excel, Access, SQL Profiler, SSIS,

Enterprise Manager, ETL, DTS, T-SQL, BCP.

Q-Fund, Hyderabad, India

SQL Server DBA/Developer

Duration: 2004 Feb - 2007 March

Responsibilities:

. Created DTS packages for the loading the data.

. Used the reporting services to create, schedule and publish the

reports required.

. Implemented and maintained database security. Administrator tasks like

managing users, roles, and profiles.

. Performed Database backups (operating system, flat file backups &

export/import).

. Used Snapshot replication for creating multiple instances of a

database for distributing the workload.

. Configured Snapshot Replication (Creating Distribution Databases,

updating Publishers, creating & managing Publications, managing

Replication monitors).

. Tuned SQL statements and SQL Procedures.

. Combined a few simple, unrelated Database Accesses to improve

performance.

. Used Query Analyzer to optimize SQL Queries.

. Maintained the physical Databases by monitoring Performance, Space

utilization and Physical integrity.

. Coded Procedures & User defined Functions in TSQL.

. Established and documented a complete Disaster Recovery Plan for the

Database servers.

. Rebuilding indexes on various tables.

Environment: Microsoft SQL Server, Windows /XP, Microsoft SQL Server

Enterprise Manager, Crystal Enterprise, DTS, SQL Profiler.

Contact this candidate