Sql Server Manager
Resume:
Jayakrishna
****.******@*****.***
. 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