Sql Server Data
Resume:
[pic] [pic]
[pic] [pic]
VENKAT
RAHUL
SQL SERVER
DBA
***********@****.***
Phone: 412-
Microsoft Certified IT Professional and a Microsoft Certified Technology
Specialist. Areas of certification include Database Administrator 2008,
Business Intelligence Developer 2008, SQL Server 2008_ Implementation and
Maintenance and SQL Server 2008_ Business Intelligence Development and
Maintenance
PROFESSIONAL SUMMARY:
8 (eight) years of experience as a SQL Server Database Administrator
CERTIFICATIONS:
Microsoft Certified IT Professional: Database Administrator 2008(MCITP_DBA
2008)
Microsoft Certified IT Professional: Business Intelligence Developer
2008(MCITP_BI 2008)
Microsoft Certified Technology Specialist: SQL Server 2008, Implementation
and Maintenance and SQL Server 2008(MCTS_DBA 2008)
Microsoft Certified Technology Specialist: Business Intelligence
Development and Maintenance (MCTS_BI 2008)
Expertise in:
. MS SQL SERVER 7/2000/2005/2008
. MS SQL SERVER Integration Services
. MS SQL SERVER Analysis Services
. MS SQL SERVER Reporting Services
. SQL Server BI Studio
. T- SQL
. MS Access
. Visual Basic
. C, C++
. UNIX
. Microsoft Active Directory Services
. Microsoft dynamics great plains(GP)
. Windows 9x/NT/SERVER 2000/XP/SERVER 2003/SERVER 2008
Employment History:
IBM/Walt Disney Company (April 2010_ till date)
Motorola (Jan 2009 - March 2010)
Citi Group (October 2007 - Dec 2008)
Bayer (November 2006 - September 2007)
GE Capital Life Assurance (July 2005 - September 2006)
Geisinger (May 2004 - July 2005)
HCL (August 2002 - March 2004)
TECHNICAL EXPERIENCE:
. Eight Years of working experience in SQL Server as Database
Administrator and Developer in IT, Pharmacy, Commercial and Finance
environments.
. As a SQL database administrator, performed End to End SQL Server
administrative tasks ranging from installing and configuring servers
to setup and administer clusters, replication, log shipping etc.
Designed, created and maintained databases in both development and
production environment.
. Experience supporting Great Plains development and SQL Server
production database instances
. Expert in designing VLDB (Very large databases) using design
methodologies like STAR Schema, Snowflake Schema.
. Experience with Business Intelligence Concepts like Data Reporting and
Data Analysis
. Experienced Microsoft BI Developer. Skilled in SQL Server
. Experience with tools like Index Tuning Wizard, SQL Profiler.
. Integration Services (SSIS), SQL Server Analysis Services (SSAS), and
SQL Server Reporting Services (SSRS).
. Strong knowledge and experience in Script-writing, performing
backups/recovery, database monitoring, and performance tuning using
SQL Profiler, SQL DBCC commands and Dynamic Management Views (DMVs),
and Windows Performance Monitor.
. Solid experience and outstanding knowledge of high availability SQL
Server concepts, such as Setting up and maintaining Log shipping,
Replication and SQL Server clustering.
. Experienced SQL BI developer. Strong Experience in package design and
maintenance using SQL Server Integration Services (SSIS) 2005 and
2008. Recent work includes Data transforms, database maintenance
tasks, custom field mapping etc.
. Experienced SQL Data Warehouse Designer with SQL Server Analysis
Service (SSAS) 2005 and 2008. Proficient in designing and
administering SQL data warehouse solutions and utilizing Analysis
Services tools such as Perspectives, Calculations, Actions, and
partitioning.
. Worked on SQL Server BI Studio for SSRS.
. Created SSIS packages for SQL 2005 data migrations and loads.
. Expert in understanding needs, focusing on the critical issues,
translating them into technical actions and implementing a resulting
database.
. Performance Monitor for maintaining performance.
. Hands on experience in troubleshooting database issues and database
backup and recovery procedures.
. Experience in working with Microsoft Active Directory Services
. Created multiple database platform reports with Crystal Reports.
. Experienced in sorting the data, defining subtotals for reports and
designing report layout.
. Excellent Report designer with SQL Server Reporting Service (SSRS)
2005 and 2008.
. Experience in SSRS interfacing with SharePoint
. Experienced with Microsoft Office Share Point Server 2007 and MS
Office Suite such as MS Access, Excel, and Office.
CAREER SUMMARY:
IBM/Walt Disney Company, Burbank, CA
April 2010_ till date
Role: Lead SQL SERVER DBA
IBM is a multi national company that has defined itself not by markets,
strategies, products or services, which come and go as the world changes,
but by fundamental values. The Walt Disney Company is a leading diversified
international family entertainment and media enterprise with four business
segments: media networks, parks and resorts, studio entertainment and
consumer products. The role was of a lead DBA to administer and monitor the
databases, provide the application support to databases. Was SME (Subject
matter expert) for the front end applications and to lead the teams present
onsite and offshore
Responsibilities
. Used Embarcadero Rapid SQL, Embarcadero DBArtisan for intuitive SQL
editing and debugging. Worked with the optimization tools to create
high performance SQL code
. Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of users
. Exclusively worked on informatica with the tools Power center
designer, Power center workflow monitor, Power center workflow manager
and Power center repository manager in creating the sessions,
mappings, workflows and work lets.
. Worked on Microsoft Active Directory Services
. Provided the application support 24/7 to the applications and
delivered enhancements and customizations.
. Identify and resolve database performance issues, database capacity
issues and other distributed data issues.
. Has performed the Backup and Restore using great plains DYNAMICS
database
. Has familiarity with great Plains tables architecture and performed
extensive Data querying with Microsoft great plains using the Report
Writer
. Maintaining the database consistency with DBCC at regular intervals
. Provided an estimation of the migration plan in terms of feasibility,
time duration and resources
. Ensure all database environments (Development, Staging, QA and
Production) are in sync. Defined db scripts versioning system to keep
track of database versions for all environments.
. Suggested and Developed database maintenance plan for Data warehouse
environment
. Maintained High Availability such as Log Shipping and Mirroring as a
database disaster recovery technique
. Made database back up using SQL Litespeed (Full, Differential, Log and
File group back up) and restore it
. Administer, maintain, develop and recommend policies and procedures
for ensuring the security and integrity of the company's databases
. Created Database Maintenance Plans for the Performance of SQL SERVER,
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
. Applied patches to the applications on the front end which had the ETL
tool informatica on the back end
. Scheduled jobs on SQL Server 2000
. Involved in extensive knowledge transfer sessions to know the database
recovery strategy used, the high availability solutions implemented
and successfully coordinated with the off shore team
. Upgraded the front end applications to the latest versions based on
the software provided by the vendor
. Gained the trust and confidence of the prestigious client Walt Disney
Environment: SQL Server 2000/2005/2008 with clustering (64/32 bit), T-SQL,
Windows 2003(x86/x64),Windows 2008, Enterprise manager, Query Analyzer,
Embarcadero Rapid SQL, Embarcadero DBArtisan, Informatica, MDX, Microsoft
Active Directory Services, Microsoft dynamics great plains, Unix, MS
access, Citrix servers, MySQL 5.1, .Net, Visual Studio, C#, VB and ASP.Net,
IIS, VERITAS Netback up, VSS, Rapid SQL, CMS .Net, MS Cluster
Service(MSCS), XML, HTML, MCS, MOM 2005, SAN Storage, Lotus Notes
Motorola, Schaumburg, IL
Jan 2009 - March 2010
Role: LEAD SQL SERVER DBA
Motorola creates numerous products for use of the government, public safety
officials, business installments, and the general public. These products
include Cell Phones, laptops, computer processors, and radio communication
devices. The role was to monitor the databases of the sales segment and
assign tasks to the junior DBA's
Responsibilities
. Designed and implemented comprehensive Backup plan and disaster
recovery strategies Implemented.
. Deployed and administered nearly 50 SQL 2005/2008 servers on 64-bit/32-
bit environment.
. Working and utilizing DMV's in SQL Server 2005 for tuning and
optimizing the servers.
. Experience in index tuning and performance optimization techniques.
. Creating new Documentation, schema designing, creating new ERD's using
ER Studio.
. Proactively monitor the Production Server and optimize stored
procedures for better performance. Resolve locking conflicts and
resource utilization.
. Administer, maintain, develop and recommend policies and procedures for
ensuring the security and integrity of the company's databases.
. Worked together with Architects and Technology specialists to design
database, clustering and migrations.
. Implemented various RAID levels on SAN Storage for file placements to
improve the performance of servers.
. Migrated DTS packages to SSIS packages. Built and developed SSIS
packages. Performed various transformations using SSIS.
. Manage/administer the file groups for data, index and read-only for
VLDB's.
. Installed, configured, authored, and managed reports using SQL Server
2005 Reporting Services
. Evaluated data storage considerations to store databases and
transaction logs. Created/Managed databases using SSMS, Database Wizard
and T-SQL Statements (Scripts).
. Developed and implemented Replication, Archiving, Backup and Recovery
strategies.
. Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
. Developed and optimized databases using stored procedures, DMVs,
Triggers, Full-Text Indexing, XQuery, XML and user-defined functions.
. Tuned, monitored, maintained & Scheduled SQL Server Jobs.
. Extensively worked on Microsoft Active Directory Services
. Designed, Built ETL procedures and a data warehouse to meet client
requirements using SQL Server Integration Services/Data Integrator.
. Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of users.
. Designed created, and visualized data mining models using SSAS.
. Expertise in creating OLAP Cubes, developed Multi-dimensional
Expression (MDX).
. Identified and resolved database performance issues, database capacity
issues and other distributed data issues.
. Managed over 50 Servers with hosting the databases sizes up to 500 GB.
. Setup MOM monitoring alerts for monitoring all SQL Server boxes.
. Worked with Linked Servers and OPENQUERY to retrieve the Oracle data
into SQL Server 2005.
. Maintaining the database consistency with DBCC at regular intervals
. Developed detailed data models and designs based on functional
requirements.
. Developed ETL Packages using SSIS from Oracle Source to SQL ODS and
from ODS to Data Warehouse using transformations such as Slowly
Changing Dimension, For Each Loop, Execute SQL task, Aggregate, Lookup,
Fuzzy Lookup, Conditional Split, Derived Column, Script Component, and
Row Count Etc.
. Migrated data from SQL Server 2005 to MySQL 5.1
. Monitor/Maintain the highly transactional servers that process 300
batches /sec on an average.
. Defined Data source, Data Source view and Created MOLAP/ROLAP Data Ware
house using SSAS 2005.
. Wrote complex SQL queries and Create Reports using SSRS 2005/2008 from
the Data Warehouse, Data Mart and Cube
. Create the Calculate member for Approved Capital using MDX Queries.
. Optimized cubes by Partitioning Cubes and Designing Aggregations.
Environment: SQL Server 2005/2008 with clustering (64/32 bit), T-SQL,
Windows 2003(x86/x64), SSIS/SSRS/SSAS, MDX, Microsoft Active Directory
Services, BO Data Integrator, Oracle 10G, Sybase ASE, MySQL 5.1, .Net,
Visual Studio, C#, VB and ASP.Net, IIS, VERITAS Netback up, VSS, ER Studio,
SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, ColdFusion MX 7.0,
MCS, MOM 2005, SAN Storage
Citi Group, Long Island, New York
October 2007 - Dec 2008
Role: SQL Server Database Administrator
Citigroup is a national bank and the role was to maintain the records and
back end the reports, maintaining terabyte databases as per company
requirements.
Responsibilities
. Collaborated with software engineers, architects, and Server Group to
design database, clustering, and migrations.
. Provided an estimation of the migration plan in terms of feasibility,
time duration and resources.
. Deployed and Administrated SQL 2005/2000 servers on 64-bit and 32-bit
production environment.
. Developed, implement and monitor a large-scale and time-sensitive
production loading processes
. Develop and implement Replication, Archiving, Backup and Recovery
strategies.
. Proactively monitor the Production Database and optimize stored
procedures for better performance. Resolve locking conflicts and
resource utilization.
. Administer, maintain, develop and recommend policies and procedures
for ensuring the security and integrity of the company's databases.
. Manage and Create database schemas for Relational Database Systems
(optimize index creation, table creation, storage allocations, etc)
. Ensure all database environments (Development, Staging, QA and
Production) are in sync. Define db scripts versioning system to keep
track of database versions for all environments.
. Problem solving and issue resolution on production SQL stand alone and
cluster databases.
. Design, review and implement production SQL Server database objects,
models and database designs (schema)
. Migration of SQL Server 2000 to SQL server 2005 (includes re-writing
the existing maintenance plans)
. Provide expertise in T-SQL for SQL Server
. Wrote optimized T-SQL stored procedure to improve performance,
preserve referential integrity and provide application functionality.
. Experience on SQL LiteSpeed.
. Expertise in working with SharePoint VLDBs size up to 600 GB.
. Good experience in setup/administer Log Shipping, Replication and
Clustering.
. Implemented merge replication-based solution over a WAN to maintain
warm backup servers in remote site, as well as for disaster recovery.
. Nightly merge replication of over 110 corporate centers using T-SQL
scripts.
. Operational support for SQL Server Report services (SSRS) and Analysis
Services (SSAS).
. Worked extensively on SSIS/DTS for Data Migration and Administration
tasks.
. Extensively used Script task and Script component task in SSIS to
perform custom tasks and data cleansing.
. Variables and expressions were used in the packages to generate custom
SQL code to make SSIS package tasks dynamic.
. Created tables using SSIS to load error data, error descriptions and
package execution diagnostics.
. Built & Deployed SSIS packages to SSIS Package Store & MSDB database.
. Created Tabular reports, Cross Tab Reports and Sub Reports.
. Built the data mart using Star/Snowflake Schemas for various business
Units.
. Identify and resolve database performance issues, database capacity
issues and other distributed data issues.
. Apply patches to SQL Server 2000/2005. Upgrade Servers from SQL Server
2000 to SQL Server 2005.
. Managing multiple Production and Development Oracle Applications
environments of different releases.
. Expertise on Microsoft Operations Management (MOM) to setup SQL Server
Alerts.
. Experience in capacity planning, RAID & MSCS Services.
Environment: SQL Server 2000/2005, SQL Analysis services/SSAS, SSIS, SSRS,
Oracle 9i, DB2 OS/390, Enterprise manager, Query Analyzer, ERWIN, SQL
Server 2005, DTS, BIDS, MS Project, MS Access 97 / 2000 & Windows Server
2003 x86/x64, ADO.NET, OLE/DB, MOM, SCOM.
Bayer, Pittsburg, PA
November 2006 - September 2007
Role: SQL Server Database Administrator
Bayer is one of the world's leading, innovative companies in the healthcare
and medical products industry. The Role was of a Database Administrator
. Provided an estimation of the migration plan in terms of feasibility,
time duration and resources.
. Migrated SQL Server 2000 to SQL Server 2005
. Migrated Data bases from SQL server 2000 to SQL Server 2005 in pre
production environment.
. Suggested and Developed database maintenance plan for Data warehouse
environment
. Developed database maintenance plans such as rebuild index, re-assign
index, full, differential and transactional backup, Database
consistence checks
. Maintained High Availability such as Replication (Transactional
replication) as far database disaster technique.
. Maintained High Availability such as Log Shipping and Mirroring as a
database disaster technique
. Made database back up using SQL Litespeed (Full, Differential, Log and
File group back up) and restore it
. Used DDL trigger for Data base Auditing.
. Used profiler and performance tuning to get better performance.
. Supported 24*7 production support and solved all kinds of critical
problems.
. Implemented SSRS reports into Share point.
. Created reports by using bar chart, pie chart to analyze critical data
in
. SSRS
. Designed and implemented comprehensive Backup plan and disaster
recovery strategies Implemented.
. Developed, implement and monitor a large-scale and time-sensitive
production loading processes.
. Migration of SQL Server 2000 to SQL server 2005 (includes re-writing
the existing maintenance plans)
. Worked and utilizing DMV's in SQL Server 2005 for tuning and
optimizing the servers.
. Administer, maintain, develop and recommend policies and procedures
for ensuring the security and integrity of the company's databases
. Actively participated in gathering of User Requirement and System
Specification.
. Created new database logical and physical design to fit new business
requirement and implemented new design into SQL SERVER 2000.
. Successfully migrated old data from legacy system into SQL SERVER 2000
using DTS Packages.
. Created Database Maintenance Plans for the Performance of SQL SERVER,
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
. Carried over Logins and Jobs from SQL Server 2000 to SQL Server 2005.
. Evaluated data storage considerations to store databases and
transaction logs. Created/Managed databases using SSMS, Database
Wizard and T-SQL Statements (Scripts).
. Tuned, monitored, maintained & Scheduled SQL Server Jobs.
. Apply patches to SQL Server 2005. Upgrade Servers from SQL Server 2000
to SQL Server 2005 and extensively used upgrade advisor utility
. Developed Store procedure and Triggers in T-SQL.
Environment: SQL Server 2000/2005, SQL Litespeed, SSMS, DTS, DMV, SSRS,
DDL, LOG SHIPPING, REPLICATION, T-SQL
GE Capital Life Assurance, Richmond, VA
July 2005 - September 2006
Role: SQL Server Database Administrator
GE Capital provides financing and services to business customers of all
sizes to help them grow
. Deployed and Administrated SQL 2000 server on production Environment.
. Develop and implement Replication, Archiving, Backup and Recovery
strategies.
. Proactively monitor the Production Database and optimize stored
. Procedures for better performance. Resolve locking conflicts and
resource utilization.
. Administer, maintain, develop and recommend policies and procedures
for ensuring the security and integrity of the company's databases.
. Operational support for SQL Server Report services (SSRS) and Analysis
Services (SSAS).
. Worked extensively on SSIS/DTS for Data Migration and Administration
tasks.
. Used DDL trigger for Data base Auditing.
. Manage and Create database schemas for Relational Database Systems
(optimize index creation, table creation, storage allocations, etc)
. Good experience in maintaining Log Shipping, Replication and
Clustering.
. Provide expertise in T-SQL for SQL Server
. Wrote optimized T-SQL stored procedure to improve performance,
preserve referential integrity and provide application functionality.
. Extensively worked on DBCC commands.
. Provided documentation of reports and the development process in order
to support the System
. Created Tabular reports, Cross Tab Reports and Sub Reports.
Environment: SQL Server 2000, Replication, Archiving, Backup and Recovery,
Stored Procedures, SSRS, SSAS, SSIS, DDL, LOG SHIPPING, REPLICATION,
Clustering, T_SQL, DBCC
Geisinger, Danville, PA
May 2004 - July 2005
Role: SQL Developer / Database Administrator
The role entails SQL Server 2000 development and support. The role requires
interaction with Business and consolidating the business requirements into
technical requirement and implementing them. Working in a team of other
DBA's to deliver the solutions.
Responsibilities
. Set up efficient monitoring of SQL Server jobs to ensure that failures
are reported immediately.
. Played a key role in business requirements analysis, architecture
design, physical and logical Data modeling, application development,
testing, training, production support and Project review with client
. Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of users
. Designed and implemented comprehensive Backup plan and disaster
recovery strategies Implemented.
. Designed and created databases, tables, views, store procedures and
triggers.
. Developed various views and functionalities for the Affinity
Compensation system department according to their specification.
. Suggest index tuning and performance optimization techniques.
. Work with teams across the country in different time zones to meet
their requirements. .
. Rebuilding the indexes at regular intervals for better performance
. Designed and implemented comprehensive Backup plan and disaster
recovery strategies Implemented.
. Designed and developed file loading process by creating complex stored
procedures, functions and bind them with DTS package for logical
execution.
. Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of users.
. Expertise and Interest include Administration, Database Design,
Performance Analysis, and Production Support for Large (VLDB) and
Complex Databases.
. Rebuilding the indexes at regular intervals for better performance
. Created DTS packages for migration of data from SQL Server to MS
Access or Oracle Databases.
. Wrote optimized T-SQL stored procedure to improve performance,
preserve referential integrity and provide application functionality.
. Worked extensively in Query analyzer and profiler for tuning queries
using variable for characteristics and query costs.
. Wrote optimized T-SQL stored procedure to improve performance,
preserve referential integrity and provide application functionality.
. Experience in Log shipping.
. Worked on cluster environment SAN, WAN
. Monitored and modified Performance using execution plans and Index
tuning
. Worked with Data warehouse team to build the OLAP Cubes.
. Monitoring SQL server performance using profiler to find performance
and dead locks and blockings.
Environment: Windows Server 2000/2003, SQL Server 2000, DTS, Analysis
Services, Data Marts, Profiler, T-SQL
HCL, Hyderabad, India
August 2002 - March 2004
Role: SQL Developer
Developed logical and physical data models, design data access strategies
and write SQL code to access and manipulate data stored in relational
databases.
SQL Developer
. Understanding Requirement Specification via interaction and writing
functional specification.
. Developed, tested and implemented Stores Procedures.
. Written Triggers to capture the date and id of the record last updated
on all the tables in the system.
. Tuned various SQL queries in the system for better performance.
. Developed User Interface Screens using Visual Basic 6.0.
. Development in Visual Basic 6, MS Access in Back-end Installation and
implementation of new software applications.
. Automated testing the user interface screens using SQA.
. Involved in Writing SQL Queries, Views and Stored Procedures on SQL
Server 2000.
. Designed databases for applications with requirements for large
numbers of transactions, heavy access and high availability.
. Optimized T- SQL code.
. Gathered user requirements, drafted specifications, designed,
documented and wrote test script for testing of all the report.
. Worked with Logical and physical models in Erwin (ETL).
. Expertise in forward and reverse engineering using Erwin (ETL).
. Developed and customized OMS according to client requirements, which
allow user to create and maintain the documents and general
administration.
. Extensively involved in designing and development of the application
for various features such as maintaining loan applicant details and
their documents, verifying the credit reports, enhanced search
facility to search his/her applicant documents very easily etc.
Environment: SQL Server 2000, Stored Procedures, Triggers, Visual Basic
6.0, MS Access, T-SQL, Erwin, ETL
EDUCATION:
Governors State University, University Park, Illinois
Master of Science (MS) in Computer Science Engineering.
S.L.N College of Engineering, Raichur, Karnataka, India
Bachelor of Engineering (BE) in Electronics and Communications
References
available upon request
Contact this candidate