Anita A Verma
Sql / OracleServer DBA
314-229-6674(C) 
[Send email using form at bottom] 
Current Location: St. Louis(MO)
Current status: EAD
SUMMARY
3+ years of experience in Administration and Development of Database Design
using SQL server 2005 Servers in OLAP and OLTP environment. Also knowledge in
Oracle  10g/9i administration and development of database design.
Installation, Upgrade, Configuration and Administration
•	Hands on experience in installing, configuring, managing, upgrading,migrating,
monitoring and troubleshooting SQL Server  2005. 
•	Experience in upgrading SQL Server software to new versions and applying
service packs, hot fixes and unattended Installation. 
•	Experience in Installing and Configuring SQL Server Active/Passive clusters. 
•	Worked on SAN for SQL Server Databases and good understanding in Capacity
Planning. 
•	Experience in installation of Oracle 10g on server and clients.
•	Experience in upgradation of Oracle 10.2.0.1 to 10.2.0.2.
•	Experience in daily startup and shutdown of Oracle database.
•	Creating,managing of database users,privilages in sql 2005 and Oracle 10g.
Backup and Disaster Recovery
•	Implemented different types of Replication Models such as Transaction,
Snapshot and Merge in SQL Server 2005 in OLTP Environments. 
•	Implemented backups and restorations in Oracle 10g.
•	Implemented and successfully tested Database Mirroring in SQL Server 2005. 
•	Also implemented and successfully tested Log Shipping in SQL Server 2005. 
•	Implemented and configured Clustered Server in Active/Active mode and
Active/Passive mode. 
•	Experienced in Database backing using Database Maintenance Plan Wizard and
scheduling it in accordance with the management. 
SQL Server 2005 Services (SSIS, SSAS)
•	Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat
file, Oracle to MS SQL Server by using DTS and SSIS services. 
•	Experience in Designing, Building the Dimensions, cubes with star schema using
SQL Server Analysis Services (SSAS) 

Performance Monitoring and Tuning
•	Monitor the production server using tools like SQL Profiler, Performance
Counters and SQL server logs for Monitoring and Tuning SQL Server. 
•	Experience in Configuring and Managing Linked Servers, data transfer between
SQL Server and other heterogeneous relational database such as Oracle. 
•	Experience in MS SQL Server Configuration, Performance Tuning, Client-Server
Connectivity, Query Optimization, Database Maintenance Plans and Database
Consistency Check using DBCC commands. 
•	Created, altered, maintained system roles and permissions to users on various
database objects. 
•	Good debugging skills and the ability to solve complex problems. 
Stored Procedure, Functions, Views and Cursors
•	Experience in using T-SQL in SQL Server 2005 platform 
•	Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML
Triggers, Views, User defined data types, Cursors and Indexes using T-SQL
•	Implemented complex business logic into database design and maintained the
referential integrity via triggers and constraints 
Database Design and Implementation
•	Experience in using Data Modeling Tools like Erwin and Microsoft Visio. 
•	Experience in Database Capacity Plan 
•	Good knowledge in Normalizing and De-normalizing the tables and maintaining
Referential Integrity by using Triggers and Primary and Foreign Keys. 
•	Good knowledge of System Development Life Cycle (SDLC). 
•	Good in implementing SQL Server Security and Process Control. 
•	Experience in Creating Roles and Assigning Permissions to the users. 

Technical Skills:
Languages	T-SQL, PL/SL
RDBMS	MS SQL Server  2005,.
	
Web Technologies	XML 
	
Reporting Tools	SQL Server Reporting services (2005)
Web Server Technologies	IIS 5.1/6.0
Data Modeling Tool	Visio 2002
Operating System	Windows 2000 Advanced Server, Windows 2000 data center, Windows
NT, Windows 95/98/2000 XP  
Other Tools	 Quest spotlight, VMware,
Sql Plus, Sql *Loader, Toad, RMAN,OEM.
Hardware	EMC DMX & IBM Fast T 700 Storage Area Network (SAN), Compaq  Proliant
8000, 6500, 6000
Application Areas:
                   
•	Setting up Replication on MS SQL Server 2005 
Implemented Transactional Replication to synchronize the subscriber server with
the Publisher server. Have  ample experience in implementing peer to peer
replication in Microsoft SQL Server 2005.
•	Setting up Log Shipping 
Implemented Log Shipping technique for DR solution for Microsoft SQL Server
2005. Also solved and automated manual log shipping issues. 
•	Configuring Cluster Server 
Implemented and configured Clustered Server in Active/Passive mode.
•	Managing instances on cluster server 
Experience in managing instances on clustered servers though they are the part
of high availability solutions.
•	Troubleshooting and Performance tuning. 
Experience in using tools like SQL Profiler and Windows Performance Monitor for
monitoring and tuning the performance of MS SQL Server. 
•	DTS (Data Transformation Service) & SSIS (Integration Services) 
Experience in using DTS and SSIS for cleaning up the archive database and
transferring data from one SQL Server to others databases like Oracle, DB2 
  


PROFESSIONAL EXPERIENCE in USA:

Sprint Wireless, Kansas. 						 Aug 2007-Jun 2009Sql  Database Administrator

Project Requirement:
The project involved redesigning the existing MES (Manufacturing Execution
System) and moving its production line database from a legacy platform with
enterprise class database to Microsoft Windows 2000 Advanced Server and SQL
Server 2005 Enterprise Edition. 
Responsibilities:
•	Installed and configured 2-node Cluster Configuration (Active/Passive) in SQL
Server 2005. 
•	Tuned the Production server to get performance improvement by using SQL
Profiler,  Database Tuning Advisor and Performance Monitor. 
•	Designed New Indexes on tables and worked with developers to increase SQL
server performance. 
•	Ran DBCC consistency checks, and fixing data corruption in application
databases 
•	Configured and managed database maintenance plans for update statistics,
database integrity check and backup operations. 
•	Automated and enhanced daily administrative tasks, including space management,
object alteration, backup & recovery and performance monitoring. 
•	Designed cubes with star schema using SQL Server Analysis Services (SSAS). 
•	Experienced in creating complex SSIS packages using proper control and data
flow elements. 
•	Deployed packages on different servers by configuring it. 
•	Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS
Packages. 
•	Involved in upgrading the instance of development environment of SQL Server
2000 to 2005 
•	Partitioned tables to achieve better performance for access and writes. 
•	Resolved locking (Dead Locks) and Blocking issues. 
•	Created logins, groups, users, roles, database devices, databases.Checked for
database consistency, fixed DBCC  errors,  monitored error logs, database space
allocations, transaction log  space  allocations, fine tuning SQL performance. 
•	Used SQL Server 2005 Management Studio (SSMS) to develop, deploy and
troubleshoot databases. 
•	Tested and implemented Database Mirroring solution for Production critical
application. 
•	Implemented transactional replication for populating reporting database. 
•	Created new databases, tables, and fields for data entry, performed database
capacity planning. 
•	Analyzed various aspects of Stored Procedures and performed tuneing as needed
to increase productivity and reusability of code. 
•	Worked as a team member for 24X7 on call production support. 
•	Implemented transactional replication to enhance the failover capabilities
increased over all database manageability and improved performance. 
•	Developed  automated daily, weekly and monthly system maintenance tasks such
as database backup, replication verification, database integrity verification,
indexing and statistics updates. 
•	Created and managed schema objects such as Tables, Views, Indexes and
referential integrity depending on user requirements and converting them into
technical specifications 
•	Created complex stored procedures and functions to support efficient data
storage, Archiving, Purging and manipulation. 
•	Conducted root cause analysis of application availability and narrow down to
issues related to coding practices, database bottlenecks, hardware bottlenecks or
network latency. 
•	Daily support, troubleshooting, monitoring, optimization and tuning of server
and SQL server environments across entire system using diagnostic manager from
Idera. 
•	Performance tuning, and optimization of procedures and queries. 
•	Interacted with higher management for reporting root cause analysis and
suggested best practices to reduce the down time. 
•	24x7 Production support.

Intel , Portland,OR    	                                   	Mar  2006 to July
2007
Sql Databae Administrator

Responsibilities
•	Installation SQL Server 2005 with the latest service packs. 
•	Database capacity planning and space forecasting. 
•	Creating tables, indexes and designing constraints. 
•	Wrote several SQL Scripts such as finding long running queries, blocking
sessions, archiving data from production to archive server and populating
reporting data. 
•	Performance Monitoring with SQL Profiler, Windows System Monitor and using a
monitoring tool called Embarcadero DB Artisan and Performance Center. 
•	Prepared and documented Backup & Restore Plans. 
•	Extensively involved in designing the SSIS packages to export data of flat
file source to SQL Server database. 
•	   Migrate DTS packages from SQL Server 2000 to SQL Server 2005 Integration 
Services (SSIS) 
•	Designed, Build the Dimensions, cubes with star schema using SQL Server
Analysis Services 
•	Writing stored procedures for report generation in SQL Server2005 (SSRS). 
•	Successfully created and deployed reports in SQL Server 2005. 
•	Creating and Maintaining Database Maintenance Plans. 
•	Implemented Database Mirroring. 
•	Creation and maintenance of Databases, creating Roles and managing user
permissions, resolving Blocks and deadlocks. 
•	Helping Development Team in deploying and testing the application, which uses
SQL Server as a database. 
•	 Implemented Complex business logic with User-Defined-Functions, Index Views
and also created User Defined Data type, Clustered & Non-clustered Indexes. 
•	Written DDL / DML Triggers as per company policy. 
•	Managed for business continuity and disaster preparedness in all database
systems in multiple sites for storm coverage. 
•	Assisted clients with physical database modeling, data archiving strategies,
data purges and disaster recovery planning. 
      Degree:- B.E Elec from Baba Rao Bhim Rao Ambedker University,India