We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Richardson, TX

SUMMARY

  • Around 8 years of experience as Production DBA and Database Designer on SQL server 2014/2012/2008/2005/2000/7.0 with different environments.
  • Experience in supporting Very Large databases (VLDB) and troubleshooting the problems and also good experience with complex databases.
  • Involved in migrating and upgrading sql server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
  • Experience with SQL Server 2008 New concepts like Hot-Add CPU, Hot-Add Memory.
  • Familiar with SQL Server 2008 concepts like Data Compression, Backup stream compression.
  • Familiar with Sql server 2008 new index types like FILTERED indexes.
  • Familiar with Database Encryption and New Sql server 2008 Data types like Date, Time, GEOMETRY and GEOGRAPHY data types.
  • Experience in Installing and Configuring and supporting 2-node (A/A, A/P) and 4-node (A/A/A/P, A/A/P/P) Clustered Environment.
  • Implemented database Mirroring and Clustering as High availability techniques.
  • Experience in migrating DTS Packages to SSIS Packages.
  • Experience in enterprise-scale relational Data Models and Data Warehouse, including both relational and dimensional models and the use of standard data modeling tools, preferably ER/Win.
  • Used IBM Tivoli monitoring tool to check the Status of Jobs, Errors, Locks, SpaceUsage and Availability of Databases.
  • Involved in Authoring, deploying, delivering of reports using SSRS.
  • Implementing Transactional and Snapshot replication and Performed log shipping as Disaster recovery solutions.
  • Designed and visualized data mining models using SSAS.
  • Implemented Data portioning Technique which is newly introduced in Sql server2005.
  • Experience with other 2005 new concepts like DMV’S, DMF’S, and performance dash board.
  • Implemented 2005 new concepts like online indexing and DDL Triggers For Better performance.
  • Expertise in writing Complex Multi Dimensional Expression (MDX) Queries, Data Mining Extension (DMX) queries, XMLA Queries.
  • Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Configured and maintained more than 2GB ram on sql server 32 bit, 64 bit and 64I bit environments.
  • Extensively worked on 32 bit and 64 bit standalone server environments.
  • Handled up to 2TB size database with clustered and replication environment.
  • Expert in performance tuning and handling blocking situation and deadlock situations.
  • Experience in Query Optimization, Client/Server Connectivity, Database consistency checks and Index Tuning Wizard.
  • Experience in supporting huge databases, troubleshooting the problems and documenting Root cause analysis.
  • Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
  • Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
  • Good Experience in Database Backup, Recovery and Restoring as daily activities.
  • Used third party Quest tools like spot light and fog light and lite speed for backing up large databases.
  • In-depth knowledge of T-SQL (DDL, DML, and DCL).
  • Experience in writing and tuning Stored Procedures, User Defined Functions, Cursors and Triggers as application needs.
  • OLAP experience like Analysis Services, Business Intelligence.
  • Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
  • Generated and managed reports using SQL Server 2005 Reporting Services.
  • Developed packages through Sql Server Integration Services (SSIS).
  • Extensively Worked with Multi Dimensional objects Such as cubes.
  • Involved in various data loadings to cubes for reporting and analysis purpose.
  • 24/7 Production Database on Call Support.
  • Transferred data (ETL) to Data ware house Environment using SSIS.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database Administration of MS SQL Server 2012/2008/2005/2000/7.0/6.5.

Languages: Visual Basic 6/5, ASP, C, XML, HTML, SAS.

Database: SQL Server 2014/2008/2005/2000/7.0 , DB2 8x UDB, MSSQL, Access and, Sybase.

Tools: Visual Basic, PAL, Active X, IIS, SSIS, DTS, MTS, Redgate, litespeed, Spotlight, Crystal reports.

Operating System: Windows 2003/2000 Advanced Server, UNIX, NT & Windows 9x.

EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

  • SQL Server 2014/ 2012/2008/2005/2000 Database Administration.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Involved in the migration of SQL Server 2000 databases to SQL Server 2008.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.
  • Experience in Database security and integrity planning.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Configured more than 2 GB ram on 32 bit Environment.
  • Migrated DTS packages to SSIS packages.
  • Successfully implemented the Capacity planning for different servers.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Checking Database Health by using DBCC Commands and DMVS
  • Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
  • Created alerts and notifications for system errors, insufficient resources, and fatal database errors
  • Wrote scripts that extract data from database tables and write the data to text Files.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
  • Generated server side T-SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
  • Developed procedures and functions for business & data transactions with error handling
  • Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
  • Tuned stored procedures by adding the try catch blocks for error handling.
  • Created the documentation for issue diagnostics reports.
  • Managing the VERITAS net backups and Litespeed.

Environment: Windows 2003/2008, MS SQL Server 2000/2005/2008/2012/2014.

Confidential

MS SQL Server DBA

Responsibilities:

  • SQL Server 2012/2008/2005/2000 Database Administration.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Involved in the migration of SQL Server 2000 databases to SQL Server 2008.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.
  • Experience in Database security and integrity planning.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server 2003.

Confidential

MS SQL Server DBA

Responsibilities:

  • Served as a SQL Server DBA and P.O.C for an E-ordering Application.
  • Responsible for maintaining High availability servers like Clustering and transactional Replication.
  • Responsible for solving application related issues in all environments (Dev, Staging, production) like query timeouts.
  • Handled issues in Replication like Replication Agents Failure, Subscription failure etc.
  • Involved in Migration from SQL Server 2005 to SQL Server 2008.
  • Involved in migrating several DTS packages to SSIS Packages.
  • Responsible for Performance tuning like optimizing stored procedures which involves re-writing Some portion of code according to business and adding some indexes to base tables etc.
  • Developed and optimized database structures, stored procedures, Dynamic Management views , DDL triggers and user-defined functions
  • Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, filegroup Modifications and updating statistics in databases.
  • Implemented Data Partitioning Strategy for Better performance.
  • Responsible for Monitoring Daily running jobs like Data Loading jobs, Replication jobs.
  • Responsible for trouble shooting failed jobs and Replication Related issues etc.
  • Suggested better scheduling strategy for jobs to overcome blocking and dead locks.
  • Involved in Data archiving and purging process as a part of maintenance.
  • Traced long running queries and Stored Proc s using SQL Profiler to tune them as a part of Application enhancement.
  • Used Index tuning wizard for Tuning of indexes.
  • Implemented other new T-SQL features added in SQL Server 2005 Like Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
  • Developed, deployed and monitored SSIS Packages to automate several tasks.
  • Responsible for Deploying Code changes, code review and Code Releases in all Environments with respect to release deadlines.
  • Managing the clustering environment.
  • Using log shipping for synchronization of database.
  • Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
  • Suggest replication techniques to meet business needs.
  • Maintain transactional replication on production SQL Servers.
  • Set up transactional, snapshot replication and maintain the active replication(s).
  • Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings.
  • Performed daily backup and created named backup devices to backup the servers regularly.

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server 2003.

Confidential

SQL Server DBA

Responsibilities:

  • Installation & configuration 2005 enterprise Edition.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
  • Migrating SQL Server 2000 data bases into SQL Server 2008.
  • Converting DTS packages to SSIS packages.
  • Dynamic configuration for memory.
  • Designed the reporting databases by using Erwin.
  • Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
  • Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
  • Rebuilding the indexes at regular intervals for better performance.
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
  • Compare and synchronize your database schemas or data by using red gate
  • Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.
  • Managing the clustering environment.
  • Using log shipping for synchronization of database.
  • Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
  • Suggest replication techniques to meet business needs.
  • Maintain transactional replication on production SQL Servers.
  • Set up transactional, snapshot replication and maintain the active replication(s).
  • Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings.
  • Performed daily backup and created named backup devices to backup the servers regularly.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
  • Performance tuning and optimization of Query of SQL server.
  • Supporting programmers for moving objects to different environments.
  • Creating and maintaining user’s logins and Roles.
  • Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log.
  • Managed databases on multiple disks using Disk Mirroring and RAID technology.
  • Estimated space requirements for a database.
  • Worked on Clustering, DTS, Import and Export utility, BCP Utility and replication tool for transferring data. Planned and setup replication.
  • Converted and imported data from an Oracle Database to a SQL Server Database.
  • Worked in tune with strategic planning for improving the mapping and data migration.

Environment: Windows 2003, MS SQL Server 2000/2005/2008.

Confidential

MS SQL Server DBA

Responsibilities:

  • Handled up to 2 TB Size databases with clustered and replication environment
  • Relocation of Databases from one server to another server using attach and detach databases.
  • Migrated of databases from SQL Server 2000 to SQL Server 2005.
  • Extensively worked on Dynamic Management Views (DMV’s).
  • Server Integration Services (SSIS).
  • Converting DTS packages into SQL Server 2005 Integration Services.
  • Wrote the packages using SSIS IN SQL 2005
  • Developed, deployed and monitored SSIS Packages.
  • Export or Import data from other data sources like flat files using Import/Export through SSIS.
  • ETL experience with SSAS and SSIS.
  • Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Rebuilding the indexes at regular intervals for better performance
  • Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Monitoring the servers using idera third party software.
  • Maintaining the database consistency with DBCC at regular intervals
  • Used DTS packages to move logins and jobs from one server to another server.
  • Expertise in SQL Server Reporting Services(SSRS)
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Prepared the project management and technical documentation.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET,ASP, Microsoft Visio 2003

Confidential

SQL Server DB

Responsibilities:

  • To ensure trouble free access to SQL Server databases 24 hours a day.
  • Monitored health conditions of databases and performed a day to day task like taking backups and restoring them
  • Monitoring Log shipping/Replication and trouble shooting of errors.
  • Planning for and carrying out installation and upgrade of SQL Servers.
  • Security issues related to logins, database users, and application roles and linked Servers.
  • Performance Tuning of SQL queries and stored procedures using SQL profiler
  • Involved in trouble shooting and fine-tuning of databases
  • Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
  • Wrote scripts for generating Daily Backup Report, verifying completion of all routine backups, Log Space utilization monitoring etc.
  • Prepared schedule and template report for Database Health-check activities.
    Prepared Shift Handover Template to facilitate effective communication among team members.
  • Backups and Restoration of data/database using a Third Party Tool (SQL Litespeed).
  • Involved in Design and Development of Disaster Recovery Plan.

Environment: SQL Server 2000/7.0. Windows 2003/2000 Server and Lite Speed.

Hire Now