We provide IT Staff Augmentation Services!

Sql Server Dba Resume

St Paul, MinnesotA

SUMMARY

  • Over 7 years of IT Professional experience in Development, Client Analysis, Database Design, Testing and Support and presentation using SQL Server 2000/2005/2008.
  • Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.
  • Experience in an operational environment providing support, involving coordination wif release Management and Change management.
  • Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008 R2 on both Cluster and Stand - alone Environment.
  • Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases wif Point in Time Recovery.
  • Extensive experience in designing, implementation and administration SQL Server Relational Database / Data Modeling, Data Warehouse in small, medium and large organizations.
  • Transactional Replication, Snapshot Replication and Merge Replication.
  • Experience in Log Shipping (Configuration of source, Target and Monitor) Servers in SQL Server 2005.SQL Server Integration Services. Knowledge of SQL CLR, Service Broker and other new features in SQL Server 2005, SQL Server Reporting Services and SQL Server Analysis Services. Worked on various SSIS / DTS packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008.
  • Good understanding of High availability techniques Database Mirroring and Clustering.
  • Experience in SCOM reporting.
  • Extensive experience in Creating alerts for SQL Server Performance. Extensively worked on Active-Active and Active-Passive Clustering. Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.
  • Experience in working wif Linked Servers, Distributed Transactions, and Federated Databases.
  • Hands-on working experience wif analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.
  • Running of Traces using SQL Profiler tool, Performance Monitoring & Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.
  • Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.
  • Involved in implementing transactional replication in a high OLTP environment.
  • Experienced in configuring SQL Mail.
  • Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to teh project needs.
  • Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.
  • Used Indexes for improving query performance, lower storage and maintenance cost.
  • Excellent communication skills. Proactive, independent and easy-going.

TECHNICAL SKILLS

Languages: Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB,CC++, Java Script-SQL, PL/SQL.

Databases: MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access.

ETL tools: DTS, SSIS, Informatica.

Operating System: Windows 2000, 2003, XP, Vista.

Software Tools: Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel, Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer.

Other Tools: SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, St Paul, Minnesota

SQL Server DBA

Responsibilities:

  • Installation configuration and maintenance of teh new systems across all environments(Development, Test & Production)
  • Created Logins, users & rolesand involved in Daily User Maintenance.
  • Created Database Maintenance jobs to perform full & transaction log Backups and scheduled them wif teh SQL Server agent job scheduler.
  • Set up Transactional Replication and as well merge Replication between servers and troubleshoot teh issues
  • Monitor data base growth activities & Troubleshoot Transaction Log Issue.
  • Created and configured mirroring in case of Disaster Recovery problems
  • Installation on clustered environments and created clustered and non- clustered indexes
  • Worked closely wif teh Project team in clarification of requirements and communicated teh same to teh offshore team.
  • Providing weekly status information on all teh projects to Project Manager.
  • Worked wifPerformance Tuning/Query tuning,execution plans, trace flags and SQL Profiler
  • Installation ofService packsto all environments.
  • As a part of teh DBA team providing 24/7 production support to teh clients
  • Providing Design, Architecture & Engineering support as well as on-call support for SQL Server databases and servers using SQL Server 2000, 2005 and 2008
  • Performing DB backups, restores, clean-up & DB maintenance activities in a large like log file monitoring, statistics update, performance tuning, disaster recovery
  • Plan and design new SQL Server implementations, server-to-server migrations, and upgrades, including database definition, structure, documentation, and long-term hardware and storage requirement
  • Advanced level experience wif SSIS packages, T-SQL, SQL Reporting Services (SSRS)
  • Worked wif Net app tool and Red gate tool
  • Involved in taking backup of snap manager files wif .FBK extension
  • Working on daily backup reports and queuing teh BMC Patrol alerts

Environment: MS SQL Server 2008R 2/2008/2005/2000 , Windows 2000/2003 Server Operating systems, SSIS, SSRS, Clustering, Performance Tuning, MS SQL Reporting Services, Change Management System, Remote Desktop, MS Access.

Confidential Cincinnati OH

SQL Server DBA

Responsibilities:

  • Create and maintain various databases for Development and Testing Environment using SQL Server 2005/2008 and involve in actual Relational Database Design for high OLTP environment
  • Worked wif Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server
  • Created a database model by using Erwin 4.0 and also designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain teh consistency and data integrity
  • Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks
  • Physical Implementation and application of Schema changes to SQL Server database using Power Designer View
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language
  • Designed and developed parameterized reports, linked reports, matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS.
  • Good experience on working wif Extract, Avamar, Transform and Load (ETL) tool
  • Exposed to data conversion from different data sources to SQL server 2008 using SSIS
  • Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS
  • Experience in working wif teh Replication
  • Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports
  • Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions

Environment: SQL Server 2008, SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0, C#, Visual Basic.

Confidential, NYC, NY

SQL Database Administrator

Responsibilities:

  • Installing, Configuring and Administering SQL server 2005, 2008.
  • Developed backup strategies for Database Recovery.
  • Performing Database maintenance activities like Backups, Restoring.
  • Creating SSIS packages, Maintenance plans and jobs for automation of teh repetitive task.
  • As a part of teh DBA team providing 24/7 production support to teh clients
  • Monitoring teh Scheduled jobs
  • Monitoring teh Disk spaces on all teh servers
  • Monitoring teh sql servers that is having SCOM
  • Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options
  • Migration of SQL Server, 2008 and also side-by-side upgrade
  • Maintaining instance/database documentation and ensuring it is Up-to-date
  • Weekly status calls and also preparing Minutes of meeting
  • Good experience in resolving blocking/locking and dead lock Issues
  • Verifying Index Fragmentation and performing re-org and rebuild as per %
  • Troubleshooting Log shipping and Database Mirroring
  • Perform SQL Installations and configuration - SQL Server 2000, 2005 & 2008
  • Worked on rolling out teh latest security patches across all teh SQL servers in teh organization
  • Worked on migration from SQL 2000 to SQL 2005/2008 including databases, logins, users, jobs, DTS packages
  • Performing code reviews and approving before deploying to production
  • Code deployments to production servers
  • Worked on setting up Log Shipping using custom setup and lite speed setup
  • Working wif various vendors in implementing new projects
  • Worked on setting up backup jobs for OLAP databases
  • Monitor and resolved Log Shipping out of sync issues
  • Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation
  • Performing daily tasks like Backup & DBCC job verifications, check in failures
  • Onboard, Train and Lead new team members and coordinate wif India & US teams on daily basis

Environment: ASP.NET version2.0, SQL Server 2000, 2005,2008, SSIS, MS Outlook, FTP, TSQL,SAN

Confidential, Bridgewater, NJ

MS SQL DBA, SSRS, SSIS

Responsibilities:

  • Dealt wif requirements gathering, analysis, design, development, change management, deployment and user training.
  • Migration of database from SQL 2000 to SQL 2005 successfully.
  • Added logins, roles, groups to teh Window NT and MS SQL Server and maintained proper security procedures.
  • Designed ER diagrams (Physical and Logical using ERWIN) and mapping teh data into database objects.
  • Created, maintained, modified, and optimized SQL Server databases, database security and auditing
  • Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
  • Identified and worked wif Parameters using complex expressions for parameterized reports and managed report subscription in SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for teh reports.

Environment: SQL Server 2000 Enterprise Edition, MS Excel, T-SQL, MS Access 2000, SQL Reporting Services, ERWIN, C#, XML, Web Services, Windows NT4.0.

Confidential, NJ

SQL Server DBA

Responsibilities:

  • Create Databases, Tables, Indexes, Views, Triggers and Stored Procedures.
  • Testing Stored Procedures and tuning them for better performance.
  • Monitoring disk, log space and dumping transaction log when required.
  • Transferring teh data using DTS utility.
  • Created and populated summary tables based on teh existing data in teh reference tables from different databasesaccording to teh client requirements.
  • Extensively worked on stored procedures to select teh data from different databases for each and every summary table to be populated and to perform teh calculations for teh numeric fields and to extract teh values based on theclient requirements for character fields and insert them into teh summary tables.
  • Wrote scripts for text processing using PERL.
  • Created Views and Triggers for security purposes.
  • Assisting developers wif code enhancements, index tuning for better performance.
  • Tested teh performance of stored procedures on teh test server,modified teh code for better performance and successfully implemented on teh production server.
  • Used BCP utility to transfer teh data from summary tables to flat files.
  • Extensively worked on different Replication Models including Snapshot and Transactional Replications.

Environment: SQL Server 2000, T-SQL,MS Reporting Services, Windows 2000 Advanced Server.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Actively participated in gathering User Requirements and System Specifications.
  • Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
  • Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into teh database.
  • Created Reports from database onto excel spread sheet using DTS.
  • Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.
  • Created various reports using Crystal Reports after performing Data Analysis on teh various Views of Business Intelligence.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of teh server.
  • Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity.
  • Involved in fine Tuning Performance and Query optimization of teh Database as required by teh application.
  • Created Users and Roles, managed security and permissions of teh databases.
  • Maintained SQL Scripts for creation of Database Objects.

Environment: SQL Server 2000, Windows NT 4 Platform, EXCEL, Erwin 3.x, Crystal Reports 9.

Hire Now