Sql Server Service
Resume:
Beena Shaik
*****.*****@*****.***
Tools/Methods relevant Experience
Management Studio Beena is an accomplished Microsoft Certified
SQL Profiler SQL Server DBA with 9 years of experience in
Enterprise Manager Design, Development & Supporting MS SQL
Query Analyzer Server's 2008, 2005 and 2000 in Production, QA
DTS/SSIS, SSAS, SSRS and Development Environments.
MS SQL Server
2008/2005/2000/7.0 Oracle, SKILLS INVENTORY
MS Access Excellent skills in creating Database Objects
T-SQL, C, C++, C# like Tables, Views, Triggers, Stored
ASP.NET, Visual Basic Procedures, User Defined Functions and writing
Windows Server 200 complex T-SQL queries.
Windows XP/2000/95/NT Good experience in Deploying SSIS packages in
Cognos 8, MS SQL Server 2005 and MS SQL Server 2008.
MS Word, Excel, Power Point Excellent experience in In-Place and
Side-by-side upgrades from SQL Server 2000 to
SQL Server 2005.
Excellent experience in installation and
configuration of MS SQL Server 2008, 2005 &
clients 2000 versions.
Hartford Hospitals Excellent experience in maintaining,
Blue Cross Blue Shield supporting, monitoring production and test
Sentara environments.
Dollar Tree Inc. Expertise in planning and implementing MS SQL
Ameri Group server security and database permissions.
AT&T Excellent working experience in Management
Anheuser-Busch Companies, Studio, Enterprise Manager and Query Analyzer.
Inc. Experience working with large databases and
BUSINESS ADVANTAGE Inc. experience in supporting multiple production
COMPLIANCE 11, Inc. database servers.
Great West HealthCare Sound knowledge on database driven application
Space Computers & Dev using Visual Basic, ASP in .NET framework.
Center Intensive experience in monitoring and tuning
SQL Server and database performance using SQL
Profiler, Index Tuning Wizard and Performance
Monitor.
EDUCATION Experience in Database Backup, Recovery and
Bachelor of Technology Disaster Recovery procedures.
(Electronics & Hands on experience in migrating DTS packages
Communications) India to SSIS packages.
Experience in supporting very large Databases
(Terabytes).
Experience in Data Modeling (Logical and
CERTIFICATION Physical Design) of Databases, Normalization
Microsoft Certification in and building Referential Integrity Constraints.
Implementation and
Maintenance SQL Server 2005 Experience in transforming data from one server
to other servers using tools like Bulk Copy
Program (BCP) and Data Transformation Services
(DTS) and SSIS.
Experience in SQL Server Reporting Services
(SSRS).
Hands on experience in maintenance of
Databases, creating roles and managing user
permissions, and resolving deadlocks.
Experience in investigating and applying
necessary SQL Server database service packs and
patches.
CHRONOLOGICAL SUMMARY OF EXPERIENCE
Senior SQL Server DBA
Hartford Hospitals, Hartford, CT
April 2013 - Present
Hartford Hospital is the major teaching hospital affiliated with the
University Of Connecticut Medical School, serving the New England region
including large employer groups, small business and individuals.
. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and
clustered environments and applied service pack.
. Involved in designing and creating Databases, Tables, Views, Stored
Procedures and Triggers.
. Hands on experience with developing reports using SSRS.
. Interacted with Developers in troubleshooting application and Report
Developing.
. Involved in writing the Scripts Using Automate.
. Involved in installing SQL Server 2005 on Development, Production and
WTC (Testing) machines.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Migrated data from Aria V7 to Aria V11.
. Developed a data cleansing and validating process.
. Developed message specification rules for HL7 interfaces and
transformation of batch flat file CSV-XML(CDA) interfaces to HL7 (e.g.
MDM) and parsing. Verify any XML "in-scope" document rendering process
for all systems.
. Design tactical solution for a conceptual & logical interoperable
Enterprise SQL Server database repository that is based on the Aria
Med Onc v11 application's data base structure.
. Monitoring and scheduled jobs on production and staging environment.
. Involved in troubleshooting all the performance issues for different
database applications.
Senior SQL Server DBA
Blue Cross Blue Shield, Chicago, IL
October 2012 - March 2013
Blue Cross and Blue Shield companies offer a variety of insurance products
to all segments of the population, including large employer groups, small
business and individuals. The Blues currently serve 85% of Fortune 100
companies and 76% of Fortune 500 companies.
. Installed SQL server 2008, 2005 and SQL Server 2000 and applied
service pack.
. Installed HP OVPI on different servers.
. Extensive experienced with HP OVPI (Open View Performance Insight) in
an HP OVPA environment.
. Management, monitoring, and implementation of a mutli-terrabyte HP
OVPI database structure (multiple satellites, central, and archive
servers).
. Building of complex HP OVPI reports.
. Customization of HP OVPI report packs.
. Building of complex HP OVPI reports.
. Integration of non-HP data into OVPI and the report packs (i.e. Remedy
CMDB).
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Transformed and manipulated the data by using SSIS transformations and
tasks.
. Responsible in Monitoring and Troubleshooting SQL Server Performance
issues.
. Involved in daily maintenance of SQL servers.
. Fixing Performance issues by Indexing, Query Optimization etc.
. Used database consistency checks using DBCC utilities.
. Scheduled Jobs and Alerting using SQL Server Agent.
. Involved in troubleshooting all the performance issues for different
database applications.
. Automated monitoring all the daily failed jobs in all the servers
using system database, DTS and SQL Mail.
. Monitoring and scheduled jobs on production and staging environment.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Performed data conversion from flat file into a normalized database
structure.
. Created DTS package to export and import data from SQL Server to text
files.
. Developed scripts for batch processing.
. Migrated data from Access 2003 to SQL server 2005.
. Created the DTS (SSIS) packages and scheduled them.
. Responsible for writing SQL Transactions, Creation and Enhancement of
Stored Procedures.
. Expert in Reporting Services.
. Generated reports using MS Reporting services.
Environment: MS SQL Server 2008/2005, MS Access 2003, SSIS, DTS.
Senior SQL Server DBA
Sentara, Virginia Beach, VA October
2011 - September 2012
Sentara Healthcare is an acknowledged leader in patient safety and quality
innovation. Founded in 1888 as the Retreat for the Sick in Norfolk,
Virginia, Sentara has ranked for more than a decade among the nation's top
integrated healthcare systems by Modern Healthcare magazine and is the #1
most integrated health care systems for the last two years.
. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and
clustered environments and applied service pack.
. Involved in designing and creating Databases, Tables, Views, Stored
Procedures and Triggers.
. Hands on experience with developing reports using SSRS.
. Interacted with Developers in troubleshooting application and Report
Developing.
. Involved in writing the Scripts Using Automate.
. Involved in installing SQL Server 2005 on Development, Production and
WTC (Testing) machines.
. Hands on experience with VBA.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Created and deployed SSIS packages and scheduled jobs on daily, weekly
and monthly basis.
. Interacted with concern application team in fixing the problems when
ever needed.
. Created logins and users with specific roles and permissions as per
security rules.
. Created daily database backup and recovery procedures for Development,
WTC (TESTING) and Production environments.
. Used ETL tools to maintain the quality of data and also to improve the
metadata capabilities.
. Monitoring all activities of the server including monitoring the daily
SQL jobs, SQL Server error logs and Windows error logs.
. Involved in setting up database mirroring for production server
. Configured replication methods like snapshot, transactional and merge
replications.
. Imported data from text files and excel spread sheets into SQL Server
2005 database using SSIS.
. Used the Execution Plan to improve the optimization of the T-SQL code.
. Resolving performance related issues to Blocking, Deadlocks and long
running queries
. Optimized Stored Procedures and long running queries using query-
optimization techniques.
. Provided 24 x 7 Production support for the database using VM Ware and
application issues.
Environment: Windows 2003 Server, MS SQL Server 2008/2005, MS SQL Server
2000, BIDS, SSIS, DTS.
Senior SQL Server DBA
Dollar Tree Inc., Chesapeake, VA June 2011
- October 2011
Dollar Tree is a national company with thousands of stores conveniently
located in shopping centers and malls in all 48 contiguous states.
. Installed SQL server 2008, 2005 and SQL Server 2000 and applied
service pack.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Transformed and manipulated the data by using SSIS transformations and
tasks.
. Responsible in Monitoring and Troubleshooting SQL Server Performance
issues.
. Involved in daily maintenance of SQL servers.
. Fixing Performance issues by Indexing, Query Optimization etc.
. Used database consistency checks using DBCC utilities.
. Scheduled Jobs and Alerting using SQL Server Agent.
. Involved in troubleshooting all the performance issues for different
database applications.
. Automated monitoring all the daily failed jobs in all the servers
using system database, DTS and SQL Mail.
. Monitoring and scheduled jobs on production and staging environment.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Performed data conversion from flat file into a normalized database
structure.
. Created DTS package to export and import data from SQL Server to text
files.
. Developed scripts for batch processing.
. Migrated data from Access 2003 to SQL server 2005.
. Created the DTS (SSIS) packages and scheduled them.
. Responsible for writing SQL Transactions, Creation and Enhancement of
Stored Procedures.
. Expert in Reporting Services.
. Generated reports using MS Reporting services.
Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing,
Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access
2003.
Senior SQL Server DBA
Ameri Group, Virginia Beach, VA
December 2010 - May 2011
Ameri Group health care system has problems. People are having trouble
getting the care they need to live full and independent lives. States are
trying to do more with less.
. Installed SQL server 2008, 2005 and SQL Server 2000 and applied
service pack.
. Interacted with application team at the time database migration from
SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server
2008.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2005, 2008.
. Involved in Deployment and Administration on SSIS packages with
Business Intelligence development studio and updated in Visual studio
2008.
. Developed, monitored and deployed SSIS packages.
. Involve in Migrating the data from MS Access to SQL server.
. Involved in claims department to load all claims and fix the problems
24*7.
. Interacted with Developers in troubleshooting application and database
issues mostly related to claims.
. Monitoring all activities of the server including monitoring the daily
SQL jobs, SQL Server error logs and Windows error logs.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Transformed and manipulated the data by using SSIS transformations and
tasks.
. Responsible in Monitoring and Troubleshooting SQL Server Performance
issues.
. Created and managed users, roles and groups and handled database
security.
. Created Triggers to enforce data and referential integrity.
. Created various Weekly and Monthly reports showing detailed
information.
. Used ETL tool to communicate with the many different relational
databases and read the various file formats used throughout in the
organization.
. Created SQL scripts for tuning and scheduling.
. Performed data conversion from flat file into a normalized database
structure.
. Created DTS package to export and import data from SQL Server to text
files.
. Developed scripts for batch processing.
. Developer scripts using VBA to create scripts for silent installation
of SQL Server 2005,2008.
. Migrated data from Access 2003 to SQL server 2005.
Environment: SQL Server 2008/2005/2000, SSIS, SSRS, Data Ware Housing,
Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access
2003.
SQL Server DBA
AT&T, Middletown, NJ
April 2010 - November 2010
AT&T is the largest provider of fixed telephony in the United States, and
also provides broadband and subscription television services. AT&T is the
second largest provider of mobile telephony service in the United States.
. Involved in designing and creating Databases, Tables, Views, Stored
Procedures and Triggers.
. Interacted with application team at the time database migration from
SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server
2008.
. Hands on experience using SDLC.
. Used SQL Server Profiler to trace the slow running queries and tried
to Optimize SQL queries for improved performance and availability.
. Used ETL tool to communicate with the many different relational
databases and read the various file formats used throughout in the
organization.
. Created SQL scripts for tuning and scheduling.
. Performed data conversion from flat file into a normalized database
structure.
. Created and managed users, roles and groups and handled database
security.
. Created Triggers to enforce data and referential integrity.
. Logical and Physical design of database for projects on basis of user
requirements using ERWIN.
. Created various Weekly and Monthly reports showing detailed
information.
. Responsible for creating the reports basing on the requirements using
SSRS 2005.
. Used ETL tools to maintain the quality of data and also to improve the
metadata capabilities.
. Created various Database Objects - Tables, Indexes, Views, and Roles.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Converting existing DTS Packages to Integration Service (SSIS)
Packages using DTS Xchanger tool.
. Troubleshooting various issues encountered while converting existing
DTS Packages to SSIS Packages.
. Created and deployed SSIS packages and scheduled jobs on daily, weekly
and monthly basis.
. Documented all the steps and procedures for future references.
. Interacted with concern application team in fixing the problems when
ever needed.
. Created logins and users with specific roles and permissions as per
security rules.
. Created daily database backup and recovery procedures for Development,
Testing and Production environments.
. Deploying database objects from development/testing environment to
production environment.
. Involved in setting up database mirroring for production server
. Configured replication methods like snapshot, transactional and merge
replications.
Environment: Windows 2003 Server, MS SQL Server 2008/2005/2000, ERWIN,
SSRS, SSIS, BIDS, SSIS, DTS.
SQL Server DBA
Anheuser-Busch Companies, Inc. St. Louis, MO
September 2009 - March 2010
Anheuser-Busch operates largest breweries in the United States. The company
brews the world's largest-selling beers, Budweiser and Bud Light. Anheuser-
Busch is a major manufacturer of aluminum cans and has been a leading
aluminum recycler for more than 30 years.
. Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and
clustered environments and applied service pack.
. Involved in designing and creating Databases, Tables, Views, Stored
Procedures and Triggers.
. Interacted with application team at the time database migration from
SQL Server 2000 to SQL Server 2005.
. Interacted with Developers in troubleshooting application and database
issues.
. Highly used T-SQL for developing complex Stored Procedures and
Triggers.
. Involved in installing SQL Server 2005 on Development, Production and
WTC (Testing) machines.
. Converting existing DTS Packages to Integration Service (SSIS)
Packages using DTS Xchanger tool.
. Troubleshooting various issues encountered while converting existing
DTS Packages to SSIS Packages.
. Deployed SSIS packages to MSDB database and file system using manifest
file and the wizard utility in SQL Server 2008.
. Created and deployed SSIS packages and scheduled jobs on daily, weekly
and monthly basis.
. Interacted with concern application team in fixing the problems when
ever needed.
. Created logins and users with specific roles and permissions as per
security rules.
. Created daily database backup and recovery procedures for Development,
WTC (TESTING) and Production environments.
. Used ETL tools to maintain the quality of data and also to improve the
metadata capabilities.
. Monitoring all activities of the server including monitoring the daily
SQL jobs, SQL Server error logs and Windows error logs.
. Involved in setting up database mirroring for production server
. Configured replication methods like snapshot, transactional and merge
replications.
. Monitoring and scheduled jobs on production and staging environment.
. Imported data from text files and excel spread sheets into SQL Server
2005 database using SSIS.
. Used the Execution Plan to improve the optimization of the T-SQL code.
. Resolving performance related issues to Blocking, Deadlocks and long
running queries
. Optimized Stored Procedures and long running queries using query-
optimization techniques.
. Provided 24 x 7 Production support for the database using VM Ware and
application issues.
Environment: Windows 2003 Server, MS SQL Server 2005, MS SQL Server 2000,
BIDS, SSIS, DTS.
SQL Server DBA
BUSINESS ADVANTAGE Inc. Memphis, TN
January 2008 - August 2009
. Actively participated in interaction with users, team lead, DBA's and
technical manager to fully understand the requirements of the system.
. Used Joins, correlated and non correlated sub-queries for complex
business queries involving multiple tables from different databases.
. Implemented Functions, views, triggers and stored procedures and
enforced business rules via checks and constraints.
. Created indexes on selective columns to speed up queries and analyses
in SQL Server Management Studio.
. Use the SQL Analyzer and Profiler for studying the SQL statements and
procedures.
. Use the SSAS to discover relationships and dependencies, finds
causation, and predicts likely outcomes based upon trends and
patterns.
. Used T-SQL for programming for stored procedures and queries.
. Manually copied and pasted the Active X script from DTS to SSIS.
. Used SSAS Cube to analyze data of related measures and dimensions.
. Used SQL Server Profiler to trace the slow running queries and tried
to Optimize SQL queries for improved performance and availability.
. Logical and Physical design of database for projects on basis of user
requirements using ERWIN.
. Generated reports using SSRS, Excel (Pivot) that could be used to send
information to diverse group of users, clients, and managers.
. Responsible for creating the reports basing on the requirements using
SSRS 2005.
. Used ETL tools to maintain the quality of data and also to improve the
metadata capabilities.
. Created various Database Objects - Tables, Indexes, Views, and Roles.
. Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
. Performed Full and Differential backup with bulk-logged recovery
models.
. Developed SSIS Templates which can be used to develop SSIS Packages
such a way that they can be dynamically deployed into Dev, Test and
Production Environments.
. Involved in extracting the data using SSIS from OLTP to OLAP.
. Executing data validation stored procedures in SSIS packages in
Business Intelligence Development Studio (BIDS).
. Migrated data from MS Access to SQL Server.
Environment: SQL Server 2008/2005, SSIS, SSRS, Data Ware Housing, Visual
studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.
SQL Server DBA
COMPLIANCE 11, Inc. Chicago, IL
December 2006 - December 2007
Compliance11 was founded to meet the needs of corporate and financial
compliance professionals. The Company is a leading supplier of software as
a service for the compliance industry. Compliance11's Supervisor Suite of
financial compliance products enables companies to automate and effectively
manage four critical regulatory compliance areas. The Major concept of this
project is to provide the Business support to the Client.
. Managed and maintained the entire release of the project.
. Involved in requirement gathering, analysis and design.
. Imported data into SQL Server 2005.
. Created databases, tables.
. Created the SSIS packages and scheduled them.
. Responsible for Design and Normalization of the database tables.
. Extensively used T-SQL queries to filter data.
. Wrote Triggers and Stored Procedures to capture updated and deleted
data from OLAP systems.
. Gathered user requirements.
. Used ETL tools to maintain the quality of data and also to improve the
metadata capabilities.
. Solid understanding of data warehousing, OLTP and OLAP concepts.
Performed data extracts.
. Development and implementation of experience in development and
implementation of Data Warehousing Applications using Cognos.
. Create alerts system in case of SQL server job failure.
. Performed database management, performance monitoring and tuning.
. Implemented database mirroring.
. Created SSIS packages to transfer the data and assigned the packages
to jobs and scheduled the jobs.
. Hardware and software troubleshooting/ upgrades.
. Setup Operations Reports using SQL Server Reporting Service (SSRS).
. Created reports and sub reports using report builder and wizard.
. Successfully completed QA.
Environment: SQL Server 2005, SSIS, SSRS, MS Visio 2007, Data Ware housing,
Enterprise Edition, XML, Web Services, JavaScript, MS Access 2003.
SQL Server DBA
Great West HealthCare, NY January 2006 -
October 2006
Great West Life and Annuity Insurance, a wholly owned subsidiary of Great
West Life co Inc., provides a wide range of healthcare, life, disability
insurance, annuities and retirement savings. This project deals with
maintaining member's information, Improving Secure Service on the Web site
and providing online access services around-the-clock to Great West
members.
. Gathered user requirements.
. Analyzed and designed of software and database solutions.
. Updated functional specification and technical design documents.
. Designed database objects, normalize data base objects using OLTP
. Developed stored procedures, functions and triggers.
. Developed scripts to move data from the flat files into the tables.
. Created DTS package to export and import data from SQL Server to text
files.
. Developed scripts for batch processing.
. Used ETL implementations to store an audit trail on positive and
negative process runs.
. Responsible for Query optimization and Performance tuning, tuned SQL
queries using Show Plans and Execution Plans.
. Used HIPAA Rule for personal health information held by covered
entities and gives patients an array of rights with respect to that
information.
. Created reports as per the requirement needs using Crystal reports.
. Created views as per design needs.
. Supported the front-end application developers with their queries.
. Responsible for tuning procedure and database objects.
Environment: MS SQL Server 2000, MS Access, SQL Query Analyzer, Enterprise
Manage, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5
SQL Server DBA
Space Computers & Development Center, India May
2004 - December 2005
Space Computers & Communication Center is an IT Training and Software
Development Centre established in1997 develops software products for the
clients and provides training in various certificate courses.
. Coordinating and synchronize with Management by working as a dev/admin
on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, scripts,
stored procedures and views).
. Worked as a developer in creating Stored Procedures, DTS packages,
triggers, cursors, tables, views and other SQL joins and statements
for applications.
. Developed T-SQL code for the application.
. Design and implementation of stored procedures and triggers for
automating tasks.
. Managing the security of the servers (Logins and users).
. Managing the changes and managing the service pack installation as
well as managing the server wide changes.
Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000
Server, Import & Export Data.
[pic]
Contact this candidate