Sql Server Manager
Resume:
SREENIVAS REDDY BORA
Email: *********@*****.***
Cell: 201-***-****
PROFESSIONAL EXPERIENCE:
Title: SQL Server DBA
Client: Verizon Wireless, Warren, New Jersey
Duration: Oct 2011 - Till Now
Project Name: Customer Service Business Efficiency Team (CSBEST) & (CCP)
DR & HA Solutions Log Shipping, MSCS Fail over Clustering and
Database Mirroring
Load Balancing Tools Transactional Replication
ETL Tools SQL Server Integration Services (SSIS)
Reporting Tools SQL Server Reporting Services (SSRS)
Monitoring Tools: SQL Idera Diagnostic Manager
Compression Tools Native SQL Compression, SQL Litespeed
Responsibilities:
. As a lead resource, involved & responsible for Datacenter
migration of CSBEST & CCP databases.
. Upgrade the TDC environment from SQL Server 2005 to SQL Server
2008 R2 and most critical applications.
. Install, maintain and support of SQL Server 2008 R2 on Windows
2008 R2 Cluster and non clustered environments.
. Administrate and managing of SQL server Agent jobs across the
enterprise.
. Created Application Roles, assign required permissions to roles;
assign to database Users as per app needs.
. Auditing the Security checks on QA\PRD servers as per application
security standards
. Implemented security standards to ensure individual DB id for all
users. User ID Audits with App teams.
. Implemented password expiration, authentication policies.
Audit/Log all transactions by database users.
. Implemented and maintained separate service accounts (Proxy) for
SQL services and Clusters.
. Created Linked Servers for retrieving data for distributed
databases and between SQL Server 2008 R2 & Oracle 10g
And Teradata and samba clients.
. Involved in creating Litespeed compression Backup & Restore
strategy for all environments of SQL servers.
. Running of DBCC command for checking database consistency as part
of SQL Maint plans.
. Involved in creation of Maintenance jobs such as Rebuild Index,
Reorg and Update stats on all databases.
. Implemented DR solution with Log shipping & Database mirroring between 2
data centers and HA solution using 2 node clusters.
. Manage, Setup and Support, Troubleshooting of SSIS package(s)
jobs on regular basis
. Hands on experience on data transformation Services, Batch
Processes, Import/Export, BCP tool
. Implemented Transactional Replication for load balancing and maintain
real time data between the multiple subscribers.
. Resolved Blocking & Deadlocks and High CPU spikes on servers.
Troubleshooting of Performance Issue
like Long Running / High Insensitive Queries using SQL Idera
tool.
. Using SQL Profiler and Tuning Queries to improve performance and
used Index tuning Wizard.
. Experience in troubleshooting SQL issues by using SQL Tools,
execution plans, Trace, statistics and DMVs
. Design & Implemented data archival procedures and partitioning
large tables and indexes
. Install and setup SQL Server Instances and maintain servers as
per client requirements on clustered and non-clustered servers.
. Idera Diagnostic Manager to monitor of 40 SQL servers and 250+
databases to analyze and manage system including job management,
space utilization and system performance including current usage
and db growth forecasting
. Analyzing and providing db metrics summarized reports for overall
application performance and system health.
. Monitoring of Disk space on all PROD drives and collecting the db
metrics and preparing db growth analysis.
. Experience with BIDS (SSRS, SSAS, SSIS) and data warehousing
concepts like ETL, Dimensions, Facts, Cubes
. Experienced with SQL Litespeed, a 3rd party tool for faster &
compressed backups.
. Good experience on configuration of Tempdb files and Disks
configured.
. Resolving Service Requests on daily Priority basis and scheduling
PROD changes during weekends.
. Preparation and maintain SQL Server standard documentation (IQs and OQs)
and Troubleshoot guides and solutions.
. Coordination with other business units (SAs and application
teams) to implement Service packs on OS and SQL Server (SP2) and
Quest Litespeed & Dell SQL Idera Monitoring tool Upgrades on
Clustered and non cluster.
. 24 * 7 Production database on Call Support
Title: SQL Server DBA
Client: CBS Corporation, New York
Duration: Mar 2011 - Sep 2011
Disaster Recover Tools Log Shipping, MSCS Fail over Clustering and Database
Mirroring
HP Matrix DB Polyserve for SQL Server 2005/2008
Load Balancing Tools SQL Server Transactional Replication
ETL Tools SQL Server Integration Services
Reporting Tools SQL Server Reporting Services and
Crystal reports
Monitoring Tools: Net Cool Alerts, SCOM Alerts
Compression Tools Native SQL Compression, HyperBac (Red gate
tools)
Backup Tools: Commvault
Storage (SAN) Tools: Netapp snap manager and 3Par for storage
3rd Party Tools DBArtisan 8.1.1, SQL LiteSpeed, Red gate, Lumigent 5.1
for Auditing
SQL Diagnostic Manager, SOX Compliance
Responsibilities:
. Involved in creating Backup & Restore strategy on PROD servers
into SAN locations.
. Setup, administrating & Monitoring of Log shipping between NY and
CA servers to support HA.
. Setup, administrating & Monitoring of Transactional Replication
for critical projects.
. Setup SQL Server 2005 Database Mirroring to minimize the downtime
of PROD databases
. Implemented Snapshot databases for Reporting users to access the
Mirror databases.
. Implemented DR plans to reduce downtime of SQL Server using Log
shipping and mirroring.
. Migration and Support, monitor & Troubleshooting of SSIS
package(s) jobs on regular basis
. Hands on experience on data transformation Services, Batch
Processes, Import/Export, BCP tool
. Good experience on configuration of Tempdb files and Disks
configured.
. Created Application Roles, assign required permissions to roles;
assign to database Users as per app needs.
. Work closely with Development partners to optimize SQL queries,
establish coding best practices, educating Developers on optimal
SQL coding techniques
. Routine Hourly, daily, weekly database backups, rebuilding
indexes and update statistics on databases.
. Running of DBCC command for checking database consistency as part
of SQL Maint plans.
. Resolved Blocking & Deadlocks and High CPU spikes on servers.
Troubleshooting of Performance Issue like Long Running / High
Insensitive Queries using SQL Idera tool.
. Monitoring Server Performance and Activities using Lumigent audit
db Tool.
. Monitor and Troubleshooting of Performance Issue like Long
Running / High Insensitive Queries
. Monitoring Server Performance and Activities. Tuning Queries,
created necessary indexes.
. Install, maintain and support of SQL Server on clustered & non
clustered Production servers.
. Experienced with SQL LiteSpeed, a 3rd party tool for faster &
compressed backups.
. Hands on experience on upgrade of SQL 2000 to SQL 2005 and SQL
2005 to SQL 2008 Enterprise servers.
. Work closely with Infra structure, storage, and network team to
optimize SQL Server infrastructure.
. Created Linked Server for retrieving data for distributed database
. Auditing the Security checks on QA\PRD servers as per application
security standards
. Using SQL Profiler and Tuning Queries to improve performance and
used Index tuning Wizard.
. Resolving Service Requests & Magic/Remedy tickets on daily
Priority basis.
. Implementation of Work Orders and Change Management Plans during
the Week ends.
. Coordination with other Business units to implements the Weekend
server maintenance works.
. Preparing the documentation for DR Run books as per build standards
and operating procedures
. Providing 24 * 7 Production Support for SQL Server Prod servers.
Environment: SQL Server 2000/2005/2008/2008 R2, SSIS, SSRS, DB Engine
Tuning Advisor, Surface Area Configuration, SQL
Profiler, Windows 2008 R2/2003, VMWare5, Crystal
Reports 10.x
Title: SQL Server DBA
Client: New York Department of Education (NYCDOE), Brooklyn, New
York
Duration: FEB 2009 - FEB 2011
Responsibilities:
. Involved in creating Backup & Restore strategy on PROD servers
into SAN locations.
. Hands on experience on upgrade of SQL 2000 to SQL 2005 and SQL
2005 to SQL 2008 Enterprise servers.
. Setup, administrating & Monitoring of Transactional Replication
for critical projects to support Load Balancing.
. Setup SQL Server 2005 Database Mirroring to minimize the downtime
of PROD databases
. Implemented Snapshot databases for Reporting users to access the
Mirror databases.
. Implemented Disasters Recovery (DR) plans to reduce downtime of
SQL Server using Log shipping and mirroring.
. Migration and Support, monitor & Troubleshooting of ETL Tools
like SSIS package(s) on regular basis
. Configured SSIS packages on Clustered environment as part of High
availability Plans.
. Hands on experience on data transformation Services, Batch
Processes, Import/Export, BCP tool
. Good experience on configuration of Tempdb files and Disks
configured.
. Created Application Roles, assign required permissions to roles;
assign to database Users as per app needs.
. Work closely with Development partners to optimize SQL queries,
establish coding best practices, educating Developers on optimal
SQL coding techniques
. Routine Hourly, daily, weekly database backups, rebuilding
indexes and update statistics on databases.
. Running of DBCC command for checking database consistency as part
of SQL Maint plans.
. Resolved Blocking & Deadlocks and High CPU spikes on servers.
Troubleshooting of Performance Issue like Long Running / High
Insensitive Queries using SQL Idera tool.
. Monitoring Server Performance and Activities using Lumigent audit
db Tool.
. Monitor and Troubleshoot of Performance Issue like Long Running /
High Insensitive Queries using and SCOM alerts
. Monitoring Server Performance and Activities. Tuning Queries,
created necessary indexes.
. Install, maintain and support of SQL Server on clustered & non
clustered environments for Prod servers.
. Experienced with SQL LiteSpeed, a 3rd party tool for faster &
compressed backups.
. Work closely with Infra structure, storage, and network team to
optimize SQL Server infrastructure.
. Created Linked Server for retrieving data for distributed database
. Auditing the Security checks on QA\PRD servers as per application
security standards
. Using SQL Profiler and Tuning Queries to improve performance and
used Index tuning Wizard.
. Resolving Service Requests & Magic/Remedy tickets on daily
Priority basis.
. Implementation of Work Orders and Change Management Plans during
the Week ends.
. Coordination with other Business units to implements the Weekend
server maintenance works.
. Preparing the documentation for DR Run books as per build standards
and operating procedures
Environment: SQL Server 2000/2005/2008, SSIS, DB Engine Tuning
Advisor, Surface Area Configuration, SQL Profiler, Windows
2000/XP/2003, VMWare5, SSRS 2005 & Crystal Reports 10.x
Oracle 11g on Linux 5.0 & Windows environments and DB2 9.x
ETL Tools: IBM Data Stage 7.x, EMC Replication. DBArtisan 8.1.1, SCOM
Title: SQL Server DBA
Client: Medidata Solutions Inc New York / New Jersey / Texas
(www.mdsol.com)
Duration: MAY 2007 - DEC 2008
Environment: SQL Server 2005, SSIS,SQL Server Management
Studio, DB Engine Tuning Advisor, Surface Area
Configuration, SQL Server 2000, DTS, BCP, OSQL, Index
Tuning Wizard and SQL Profiler, Windows 2000/XP/2003,
Visual Studio .Net and MS Access, Excel
Period: FEB 2006 - APR 2007
Client Name: Alliance Bernstein, New York
Role: MS-SQL Server Production Support DBA
Environment: SQL Server 2000, DTS, Client tools / SQL server
2005, SSIS, Surface area Configuration, BCP, OSQL,
Database Engine Tuning Advisor, BCP and Bulk Load,
Windows 2003, Reporting Services, Analysis Services,
Windows 2000/XP/2003, Control-M Jobs, Microsoft
Outlook 2000, Sybase 12.5 Client tools, Oracle 10g
Client
3rd Party Tools: DBArtisan 8.1.1, SQLLite Speed, MKS Tool kit 86,
Lumigent 5.1 for Auditing, SQL H2, and Red gate Tools,
BMC Patrol
Period: APR 2005 - DEC 2005
Client Name: Maximus Inc, Little Falls, New York
Role: MS-SQL Server Production Support DBA
Environment: SQL Server 2000, DTS, VBScript, Profiler, Index Tuning
Wizard, ER-Win 4.0, Windows 2003, Excel (Pivot Tables), Crystal Reports
9.0, Excel
Period: February 2004 - March 2005
Client Name: Microsoft Corporation, Redmond, WA (From Satyam Computer
Service, India)
Role: MS-SQL Server Production Support DBA
Environment: SQL Server 2000, SQL Profiler, ETL, DTS, VBScript,
OLAP, Windows XP/2003
Period: March 2000 - Feb 2004
Client Name: Axsys Technology Ltd, Clydebank, Scotland
(www.axsys.co.uk)
Role: MS-SQL Server Application DBA & Sr Developer
Environment: SQL Server 2000 Enterprise Edition, Windows 2000
Data Center
Responsibilities:
. Installing of SQL servers Tools on Windows 2000 Data Center
Servers for Dev/Test/UAT/Production.
. Created new database as per the requirements such as Size and
Recovery model and default settings
. Creation of Tables, views, stored procedures, UDFs, Trigger
according to the User requirements.
. Created Clustered/Non-Clustered Indexes on columns as per
requirements.
. Assigned Table Level, Column Level, DML, Execute permissions
assign to Users.
. Written Triggers to store the data for Audit maintenance
. Created SQL server Job task on production server that will be
used to perform transaction log backups.
. Each job will include multiple steps with scripts that will
perform the backups, copy the files from production server to
standby servers, and execute the stored procedures used to
restore the backup and log.
. Monitoring the Log shipping process from standby server by
using Profiler for fault tolerance.
. Created Application Roles, assign required permissions to
roles. Assign roles to database Users
. Created Linked Server for retrieving data for distributed
database
. Performing regular Backups (Full/Differential/Transaction Log
Backups into Tapes, Disks)
. Scheduling SQL Server Agent Tasks to periodically running of
tasks.
. Implemented disasters recovery plans to reduce the downtime of
the SQL Server.
. Monitoring Server Performance and Activities. Tuning Queries,
created necessary indexes.
. Query Optimization, Performance Tuning by using SQL Profiler
and Index Tuning Wizards.
. Used BCP Command line tools to Import/export the table data
into Flat Files and Flat files to tables. With oSQL Tool to
Run the Batch Execution of Queries/SP to perform it's
operations.
. Setup and maintain Adhoc Reports DB for development as well as
for Testing Environment.
Period: Oct 96 - Jan 2000
Client Name: Oil & Natual gas Corporation Ltd
Project Name: Personal Information System
Role: Oracle 7.x/8, PL/SQL Developer and Form 4.5, Reports 2.1 and
Visual Basic 4.0 Developer
A major Database application developed for the management of
Personnel Information in the organization. Up to date information
is obtained from this project for proper monitoring. This system
involves details for each employee, such as Bio-data, designation,
department, Leave, leave orders, pension scheme, employee
nominations, employee qualifications, suspensions - penalties,
transfers, promotion, Training-history (TIRC) etc., System
Analysis and Design Documents, Writing the code for forms
TECHNICAL SKILLS:
Operating Systems: Windows 2012 / 2008 R2 / 2003 EE. Linux Enterprise
5.0, UNIX Sun Solaris V8
RDBMS Tools & Services SQL Server 2012, 2008 (R2)/2005/2000, Oracle 11g /
9i on Linux & Windows environments SSIS, SSRS, BIDS,
SQL Profiler, Performance Monitor, Index Tuning, DTS,
BCP, SQL plus, PL/SQL, DBCA, EXPDP & IMPDB
Disaster Recover Tools Log Shipping, MSCS Fail over Clustering and
Database Mirroring
Load Balancing Tools SQL Server Transactional Replication and EMC
Replication
ETL Tools SQL Server Integration Services (SSIS)
Reporting Tools SQL Server Reporting Services
(SSRS) and Crystal reports 10.x
Programming/Scripting VB Script, xml, html 4.0, T-SQL, PL/SQL, VB 6,
VB.Net, Shell scripting
3rd Party Tools DBArtisan 8.1.1, MKS Tool kit 86, Toad for
SQL Server V 5
Monitoring Tools SQL IDERA 7.1, SCOM Alerts, Spotlight, Lumigent
5.1 Auditing, BMC Patrol
Compression Tools Native SQL Compression, HyperBac (Red gate
tools), SQL Litespeed 6.1
Storage (SAN) Tools Netapp snap manager and 3Par for storage
EDUCATION QUALIFICATION & CERTIFICATIONS:
. Master of Computer Applications M.C.A
. Brain Bench Certification in SQL (ANSI) (ID: 1852737)
. Microsoft Certified Database administrator M.C.D.B.A -
Yr: 20
[pic]
Contact this candidate