Sql Server Manager
Resume:
Satya Murthy Chebole
************@*****.***
Senior SQL Server DBA
Houston, TX
H1B VISA
Summary
> 8+ years of IT experience in Database Administration, Design, Development
and Support of MS SQL Server 2012, MS SQL Server 2008, MS SQL Server
2005, MS SQL Server 2000, in Production, Test, Development, Replication &
Cluster Server Environments.
> Experience in Replication & Cluster Server Environments.
> Experience in High availability environments like active-active/active-
passive clustering, Database Mirroring, Replication (Snapshot, merge,
transactional), Log shipping.
> Working experience in installing, upgrading and configuring MS SQL
Server.
> Participated in database design, data modeling (physical and logical).
> Experience in Performance Tuning, Query Optimization, Client/Server
Connectivity.
> Experience in Troubleshooting Techniques and Resolving Issues On
Standalone and Clusters.
> Experience in resolving blocking and Deadlocks.
> Experience in transforming complex business logic into Database design
and modeling.
> Experience in SQL server security.
> Experience in Database Backup and Restore.
> Experience in DTS, SSIS, Bulk insert and BCP utilities.
> Experience in Normalization and Denormlizations.
> Experience in Creating Databases, Tables, Schema and Indexes.
> Experience in Clustering, Replication, Data Modeling (Physical and
Logical), Data Mapping.
> Experience in implementing Transactional Replication.
> Experience in creating packages using DTS and SSIS.
> Experience in deploying packages on servers.
> Experience in Scheduling Jobs using SQL Agent.
> Written skills in T-SQL language.
> Experience in writing stored procedures functions, views, triggers, and
cursors.
> Experience in Data Modeling using Erwin and Visio.
> Experience in SQL Server Integration Services (SSIS).
> Experience in SQL Server Reporting Services (SSRS).
> Experience in creating and maintenance of Databases, Roles and user
permissions.
> Hands on experience in Log shipping with SQL Server 2000/2005/2008.
> Comprehensive knowledge in providing suggestions of using best RAID
Technologies based on application requirement.
> Implemented different backup and recovery strategies for production
environment.
> Experience with very large SQL Server databases (over 2TB).
> Experience with SCOM installation, configuration and monitoring the
alerts.
> Excellent interpersonal, analytical and communication skills.
> Flexible, enthusiastic and project oriented team player with solid
communication and leadership skills to develop creative solution for
challenging client needs.
> Experience in developing data migration strategies.
> Experience in Documentation.
Education:
> Bachelor of Technology - Jawaharlal Nehru Technological University,
INDIA.
TECHNICAL SKILLS:
SQL Server Tools : Enterprise Manager, Configuration Manager, Profiler,
Query Analyzer,
Cluster Administrator, Veritas
Cluster Management, Export & Import,
DTS, SSIS, SSRS.
RDBMS : MS SQL Server 2012, 2008, 2005, 2000, 7.0, MS-Access, Oracle
Languages : C, C#, T-SQL, XML, HTML, PL/SQL, VB.Net, MS Visual
Basic
Front End : Java, .net, C#, MS Visual Basic.
Reporting Tools : MS Excel, SQL Server Reporting Services, Cognos BI
Data Modeling Tools : Erwin, MS Visio.
Operating Systems : Windows Server 2012/2008R2/2008/2003/2000, Windows
7/Vista/XP/2000/98.
Other Tools : MS Office, MS Project, MS SharePoint.
Professional Experience:
Hewlett-Packard, Houston, TX May 2012 to till
date
SQL Server DBA
Responsibilities:
. Installed, Upgraded and Configured from SQL Server 2008/2008R2 to SQL
server 2012 across various Production/Test/Development servers.
. Configuring various SQL Server high availability features such as
Database Mirroring, Log Shipping, Replication
. Installing patches and Service packs for SQL server 2008.
. Implementing Database backups and restores.
. Implementation of backup Strategies using full, differential,
transactional backup.
. Monitoring MS SQL Server performance using profiler and performance
monitor.
. Configured MS SQL Server 2008 log shipping from primary server to standby
server.
. Monitoring Disk space and file group alerts.
. Provide on-call support that includes SCOM monitoring, Incident
Management, escalations to make sure all the servers are up and running.
. Hands experience on SQL server clustering technology.
. Experience in working with very large SQL Server databases (over 2TB).
. Troubleshooting and resolving database performance problems
. Experience with MS SQL Server backup and recovery techniques
. Configure and manage database maintenance plans including integrity
checks, Reindex jobs, optimization jobs and backups.
. Supporting Transactional Replication.
. Proactively watching the SQL logs and Event viewer.
. Implementing SQL Server and Database security policies.
. Created DTS and SSIS Packages for ETL purposes.
. Working experience with SCOM to monitor the servers.
. Used DBCC commands to check physical and logical consistency of the
databases.
. Reviewed third party tools such to help automate routine tasks such as
monitoring blocking and consolidate status of scheduled jobs.
. Assist Application teams on various projects as required on daily basis
. Familiarity with MS SQL Server DTS
. Understanding of database design practices, including Database
normalization concepts
. Proven experience using Transact SQL
. Proven ability to work with limited supervision in a team environment
. Strong hands-on experience on DB Builds.
. Proactively work on performance issues with development groups on.
Environment: Microsoft SQL Server 2000/2005/2008/2012, Windows server
2012/2008R2/2008/2003, XML, Visual Studio 2012/2010/2008, MS SQL Server
2008 Reporting Services, MS SQL Server 2008 Integration Services, Service
Broker, Visual Basic, .NET.
Siemens, Mason, OH Dec 2010 to
May 2012
SQL Server DBA
Responsibilities:
. Experience in Installing, Upgrading and configuring SQL Server 2008.
. Strong hands-on experience on DB Builds.
. Implementing Database backups and restores.
. Implementation of backup Strategies using full, differential,
transactional backup.
. Monitoring MS SQL Server performance using profiler and performance
monitor.
. Configured MS SQL Server 2008 log shipping from primary server to standby
server.
. Monitoring Disk space and file group alerts.
. Configure and manage database maintenance plans including integrity
checks, Reindex jobs, optimization jobs and backups.
. Supporting Transactional Replication.
. Hands experience on SQL server clustering technology.
. Experience with very large SQL Server databases (over 2TB).
. Implemented Migrations and upgrades from SQL server 2005 to SQL server
2008.
. Implementing SQL Server and Database security policies.
. Installing the patches and Service packs for the SQL server 2005 and SQL
server 2008.
. Proactively watching the SQL logs and Event viewer.
. Used DBCC commands to check physical and logical consistency of the
databases.
. Reviewed third party tools such to help automate routine tasks such as
monitoring blocking and consolidate status of scheduled jobs.
. Created DTS and SSIS Packages for ETL purposes.
. Working experience with SCOM to monitor the servers.
. Proactively work on performance issues with development groups on.
Environment: Microsoft SQL Server 2000/2005/2008, Microsoft Windows
2000/2003, Windows server 2008,SQL Server 2000 Analysis Services, XML,
Visual Studio 2010/2008, MS SQL Server 2005 Reporting Services, SQL Server
2005 Integration Services, Service Broker, Visual Basic, .NET, SAP.
BG Group, Houston, TX Dec 2009 to Nov
2010
SQL Server DBA
Responsibilities:
. Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various
Production Servers.
. Migrating Databases from SQL Server 2005 to SQL Server 2008.
. Worked with table partitioning (SQL Server 2008) mechanism to allow the
SQL Server engine to escalate locks to the partition level before the
table level.
. Worked with Transparent Encryption, table compression, database
compression and merge statements using SQL server 2008.
. Extract Transform Load (ETL) development using SQL Server Integration
Services (SSIS).
. Used Policy Based Administration feature (SQL Server 2008).
. Created new database objects like Tables, Procedures, Functions, Indexes
and Views using T-SQL in Development and Production environment for SQL
Server 2008.
. Setting up and monitoring transactional replication, Database mirroring
on Production and QA servers.
. Worked in Active Cluster environment as a High availability solution.
. Tuning queries which are running slow using Profiler and Statistics I/O
by using different Methods in terms of evaluating joins, indexes,
updating Statistics and code modifications.
. Created complex stored Procedures, Triggers, Cursors, Tables and other
SQL Joins and Statements for Applications by using T-SQL.
. Expertise in Performance Tuning of the Stored Procedures.
. Checking Database Health by using DBCC Commands and DMVs
. Monitored and modified Performance using execution plans and Index
tuning.
. Expertise in Database security and integrity planning
. Used log shipping for synchronization of databases.
. Prepared Documentation for Disaster Recovery plan
. Designed Data Integrator jobs with Error Handling and email
notifications.
. Generated periodic reports based on the statistical analysis of the data
using SQL Server Reporting Services (SSRS).
. Daily routine DBA tasks like handling user's permissions and space issues
on Production and Semi-Production Servers and handling maintenance Jobs.
. Handled monthly Database Refresh in QA-Test environment for testing of
new Deployments and Build.
. Responsible for routine DBA jobs like Backups and Restores.
Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite
Software 5.0.0, Report Builder, BCP, SQL Profiler, Log Shipping,
Replication, Mirroring, Clustering Windows XP/2000 and Windows 2003
Server.
FedEx, Memphis, TN Jan 2009 to
Nov 2009
SQL Server DBA
Responsibilities:
. Monitoring MS SQL Server performance using profiler and performance
monitor.
. Implementing Database backups and restores.
. Implementation of backup Strategies using full, differential,
transactional backup.
. Monitoring Disk space and file group alerts.
. Configure and manage database maintenance plans including integrity
checks, optimization jobs and backups.
. Supporting Transactional Replication.
. Implemented Migrations and upgrades from SQL server 2000 to SQL server
2005.
. Implementing SQL Server and Database security policies.
. Installing the patches and Service packs for the SQL server 2000 and SQL
server 2005.
. Proactively watching the SQL logs and Event viewer.
. Created documentation for Database capacity planning and space
forecasting.
. Used DBCC commands to check physical and logical consistency of the
databases.
. Reviewed third party tools such to help automate routine tasks such as
monitoring blocking and consolidate status of scheduled jobs.
. Created DTS and SSIS Packages for ETL purposes.
. Proactively work on performance issues with development groups.
Environment: Microsoft SQL Server 2000/2005/2008, Microsoft Windows
2000/2003, XML, Visual Studio 2008/2005, MS SQL Server 2005 Reporting
Services, SQL Server 2005 Integration Services.
ING Vysya Bank, Hyderabad, India Feb 2008 to
Dec 2008
SQL Server DBA
Responsibilities:
. Developed Disaster Recovery plans and contingency systems including
evaluating and recommending appropriate backup and archival software,
hardware, and media, off site storage.
. Experienced in working Migration of data from Sybase to SQL Server 2005.
. Experience in working large environments and large Databases.
. Created documentation to install SQL Server, apply service pack, hot
fixes.
. Migrated data from SQL Server 2000 to SQL Server 2005.
. Implemented Database Mirroring in SQL Server 2005.
. Configured Transactional replication between primary server and read only
server, with separate Distributor server and experience in
troubleshooting replication problems.
. Experience in providing excellent 24X7 Production support.
. Configured MS SQL Server 2005 built-in log shipping from primary server
to standby server.
. Monitoring SQL server LOGS (Enterprise manager), Application logs (Event
Viewer) and analyzing the logs.
. Responsible for creating Databases, Tables, Cluster/Non-Cluster Index,
Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and
Defaults
. Created documentation for Database capacity planning and space
forecasting.
. Used Windows Performance monitor to monitor CPU & Memory usage and SQL
Server Profiler to monitor and record database activities of particular
users, applications
. Conducting the root cause analysis of application availability and narrow
down to issues related to coding practices, database bottlenecks, or
network latency.
. Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS
packages.
. Experience with very large SQL Server databases (over 1TB).
. Monitoring and troubleshooting performance during peak periods.
. Experience in Installing and configuring SQL Server Active/Active and
Active/Passive clusters.
. Documented disaster recovery plans and participated disaster recovery
drills.
. Helping Development Team in deploying and testing the application, which
uses SQL Server as a database.
. Involved in scheduling tasks and Setting Alerts, Managing Task
Scheduling, managing alerts, monitoring and tuning SQL Server, monitoring
and tuning memory and monitoring lock
Environment: SQL Server 2000/2005, Visual Basic, Windows 2000 data
centre/advance server, Windows 2003.
Birla Global Finance India Limited May
2005 to Jan 2008
SQL Server Developer/Associate DBA
Description: TINS Info is a global Information Technology company, which
provides technology solutions to over 1000 customers in more than 15
countries across 5 continents, spanning a range of verticals - Banking,
Insurance, Manufacturing, Contracting, Retail & Distribution and
Government. Offers a comprehensive range of software and IT solutions,
including packaged applications for the Banking, Financial Services &
Insurance (BFSI), Manufacturing, Contracting, and Retail & Distribution
industries.
Responsibilities:
. Review / test / apply all database changes to all environments including
QA, Development and Production Servers.
. Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate
Blocking & deadlocks, user counts and connections/locks etc.
. Worked with SQL server Profiler to generate traces.
. Monitored the database and alerts from Fog light application and also
performance monitor for the performance.
. Experience in taking the backups and schedule it according to the
environment, Recovery.
. Expert in Configuring, Managing and optimizing transactional replication.
. Develop some DTS packages to Message the data and put into others tables,
which are used for reporting.
. Creating and managing schema objects such as tables, views, clusters,
indexes, procedures, triggers & maintaining Referential Integrity.
. Server & Application fine-tuning & trouble shooting. Monitoring MS SQL
Server performance and network issues.
. Implemented built in log shipping with SQL Server 2000 for disaster
recovery server.
. Creating the Packages for running the jobs automatically for backup and
data transfer.
. Good in Implementing SQL Server security and process control
. Provided technical assistance and mentoring to staff for developing
conceptual and logical database design and physical database.
. Implemented and documented proactive monitoring scripts for production
databases.
. Preparing the reports for the day-to-day as well as weekly/monthly
purposes.
. Conducting root cause analysis of application availability and narrow
down to issues related to coding practices, database bottlenecks, or
network latency.
Environment: SQL Server 2000, Visual studio.net, Windows 2000 server, HP
net server LP1000r servers, Crystal Report 8.0.
Contact this candidate