Sql Server Maintenance
Resume:
JEEVITHA
**************@*****.***
Professional Summary
Seven+ years experience in SQL Server Database Administration, Development and T-SQL Scripting.Extensive experience in Installation, Configuration and Maintenance of MS SQL Server 2000, 2005 and 2008 R2 in Production and Development environment.Experience in designing and implementation of efficient Backup, Restore, Maintenance, Disaster Recovery & High Availability Strategies.Hands on experience and knowledge on High availability SQL Server solutions Clustering, Replication and Database mirroring.Hands on experience with planning and monitoring Log shipping.Extensive knowledge of Relational Database Management Systems with in depth knowledge of T-SQL.Good experience in Creating and maintaining databases and setting up securities (granting Permissions and assigning database roles and server Roles). Experience in developing conceptual, logical and physical data models.Experience in using Performance Monitor/Profiler to monitor and solve performance issues like Dead Locks and Long running queries. Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCPExperience in writing and debugging stored procedures, Triggers and Functions.Good Knowledge in SQL Server Analysis Services (SSAS) and SSRS.Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.Experience in Performance Monitoring and Tuning, Query Optimization, using DBCC Utilities and DMVs.Experience in security management including creating logins, configuring permissions and assigning roles.Experience in Scheduling jobs, Configuring Database Mail and operators.Good team player, strong interpersonal and communication skills.
Technical Skills
Operating Systems : Windows NT, Windows 2000/2003/2008
Languages : T-SQL, PL/SQL, VB.NET, C, C++
RDBMS : Oracle 9i, SQL Server 2000/2005/2008 R2, MS-Access
Reporting Tool : SQL Server Reporting Services
SQL Server Tools : SQL Profiler, DTS, SSIS
Work Experience
TIAA-CREF, Charlotte, NC March 2011-Till Date
Sr SQL Server DBA
Responsibilities:
Involved in daily monitoring & maintenance of MS SQL Servers in Production and Development.Participated in migration of the databases and managed the location of database files and their sizes.Migrated and validated users and logins in the new environment.Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2008 R2 databases.Experience in applying latest service packs.Transferred and created maintenance plans, scheduled jobs and SSIS packages.Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.Modified, and optimized complex queries for data retrieval and modificationCreated tables, views, indexes, functions and advanced queries for databases by using SQL Server Management Studio. Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)Optimized stored procedures and indexed query using Index Tuning WizardIncreased query performance after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizardScheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index de fragmentation.Monitored database status including CPU, memory, I/O, space, and dead locks using SQL Server Utilities.
Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2005, Microsoft SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio, Visual Studio 2005, Microsoft Office,
Department of Revenue, Raleigh, NC Jan 2010 – Feb 2011 SQL Server DBA
Responsibilities:
Installed SQL Server 2008 in production and development environmentsMigrated databases from SQL Server 2005 to SQL Server 2008.Involved in development and deployment of SSIS packages.Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.Created and maintained SQL jobs for various tasks, such as backup, maintenance, and various applications. Successfully implemented Database Mirroring for ensuring High Availability of database servers.Troubleshooting jobs and permission issues, analyzing stored procedures for performance issues.Involved in writing stored procedures and triggers, building indexes, and views.Performed Query Optimization, and Performance Tuning of procedures and queries.
Environment: MS SQL Server 2008/2005, Windows 2003, T-SQL, EXCEL, SSIS.
Eze Castle Software, Inc, Boston, MA Oct 2008 - Dec 2009
SQL Server DBA
Eze Castle is one of the largest trade order management firms in the financial industry. Its flexible and scalable service-oriented architecture creates a true real-time environment that enables you to optimize your workflow.
Responsibilities:
Responsible for Installation and configuration of SQL Server 2005.Installed SQL server 2005 over a clustered environment.Involved in daily monitoring & maintenance of MS SQL Servers in Production and Development.Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.Planned and modified the permission issues in the server. Managed Replication to synchronize the data between the different Servers.Participated in incorporating business logic in DTS while converting from Oracle and Text to SQL SERVER. Maintaining SQL Script for creation of Database Objects. Responsibilities as Developer: Created Stored Procedures, Triggers, Views and Functions for the Application. Extensive testing on the Performance of the Stored Procedures.
Environment: MS SQL Server 2000/2005, Windows 2000 Server, MS Office, T-SQL.
Oil and Natural Gas Commission Ltd., India Dec 2006 – Aug 2008
SQL Server DBA/Developer
This project involved mainly database administration and supporting highly critical production servers. The client engages in retail and electronic payment processing.
Responsibilities:
Installed and configured MS SQL Server 2000 Enterprise Edition.Creating and maintaining various databases for Production, and Development using SQL Server 2000. Creating procedures, functions, and triggers, handling database performance and tuning.SQL Server Installation and migration of databases.Creation of new databases, planning the location of data, index, and Transaction log files on disks. Involved in creation and management of SQL Server logins, database users and Roles.Data Transfers between various servers using DTS.Providing support to the Application developers on the application databases.Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups. Backing up system & user databases and restoring them when necessaryCarried out migration of data across different databases and different serversCarried out performance monitoring using windows performance monitor and SQL profiler of SQL server.Routine backups and restoration.
Environment: MS SQL Server 2000, Window NT 4.0
Essar Steel Limited, India Aug 2005 – Nov 2006
Junior SQL Server DBA/Developer
The database system was designed to monitor the inventory of the organization. This system recorded all store transactions like material receipt against purchase order, material issue, stock adjustment voucher, material returned to stores, material receipt/issue from/to production unit.
Responsibilities: Creation of Databases and managing security.Writing stored procedures, checking code for efficiency. Involved in developing conceptual, logical and physical data models along with the architectDefining and creating indexes for query optimization and revising scripts for optimal performance.Using Data Transformation Services (DTS) to populate data from various data sources.Testing stored procedures performance and path of execution using SQL Profiler Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities.
Environment: MS SQL Server 2000, Oracle9i, Windows 2000 Advanced Server
Contact this candidate