We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume Profile

KS

SUMMARY

  • 10 years of IT experience in Database Administration, Design Development and Support of MS SQLServer 2012/2008R2/2008/2005/2000 in Production, Test, Development and Cluster ServerEnvironments.
  • Experience in RDBMS database design, performance tuning, optimization, backup and recovery inSQL Server 2000 and SQL Server 2005/2008/2012.
  • Experience in Disaster Recovery Planning, Execution and Testing at remote side.
  • Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Profiler and SQL Query Analyzer.
  • Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008 SQL Server 2008 to 2012.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Experience in Database administration activities for DB Security creating logins, users, roles, and assigning permission to them .
  • Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
  • Extensive use of DTS/SSIS in SQL Server, Performance Tuning Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
  • Good knowledge on Advanced features like MSDTC, and Full Text Indexing etc. Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server and failover clustering.
  • Good experience with SQL Server 2005/2008 Online Database Indexing and Recovery. Solid experience on high availability SQL Server solutions, including Replication Models Snapshot/Transactional and SQL Server clustering Active-Active, Active-Passive .
  • Expert in using Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2000/2005.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
  • Successfully Migrated SQL 2000 DTS packages to SSIS using DTS Xchange tool.
  • Made some server level changes for SSAS project.
  • Visual studio for DTS package inport/export.
  • Experience in using SSIS SQL Server Integration Services for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
  • Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
  • Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services SSRS .
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC Software Development Life Cycle .

TECHNICAL SKILLS

Databases

MS-SQL Server 2005/2008R2/20012, MS Access 2003

Languages

C, C , VB Script, Java Script, HTML, XML

SQL Server Tools

Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export Import,Precise i3 for SQL Server

Operating systems

Windows 2008 2003

Software Packages

MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio

EXPERIENCE

Confidential

Role: Sr. SQL Server DBA

Confidential Insuranceis one of the most highly respected crop insurance in Confidential of

Responsibilities:

  • SQL Server 2005/2008R2/2012 Database Administration
  • Installed, managed and administrated the MS SQL Server 2008R2/2012 Production and Non Production Servers
  • Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
  • Migration of SQL Server 2008R2 in place as well as side by side to MS SQL Server 2012
  • Worked on installation of ESM MSSQL Server Module on Production and Non Production Servers
  • Monitored Log shipping/Transactional Replication and trouble shooting of errors
  • Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
  • Worked on ESM Remediation removing, fixing violations using Windows ESM Console on Production and Non Production Servers
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan
  • Rebuilt indexes with different fill factors and update statistics manually
  • Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
  • Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
  • Used Database Consistency Checks - DBCC commands for database maintenance
  • Supported load and performance L P testing and suggested design fixes.
  • Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
  • Define DB scripts versioning system to keep track of database versions for all environments
  • Used SSRS to create reports that draw content from a variety of data sources
  • Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
  • Ensure all database environments Development, QA, UAT and Production are in sync DB Refresh when requested .
  • Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
  • Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP
  • Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases
  • Handled orphan users while moving databases.
  • Performed all aspects of database administration, including backups and recovery
  • Running Index Tuning wizard for optimal query performance
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes
  • Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies
  • Proactively monitored, determined and solved issues at SQL/database/server levels
  • Worked on documentation of the projects in the SharePoint
  • Used HP Service Manager system for managing and completing all service requests

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, OLTP OLAP environment that includes Production 24x7 , Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential

Role: Sr. SQL Server DBA

Confidential provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, and trust and payment service. This project involves loading different client's data, designing and developing various types of reports for the marketing group.

Responsibilities:

  • Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Design, document, and promote security best practices , policies, standards and protocols.
  • Migrating application code and objects from development/test environments to production.
  • Working with development and systems teams to perform application and database tuning.
  • In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
  • Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
  • Setup and maintenance of appropriate database and application monitoring.
  • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
  • Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
  • Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
  • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
  • Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Review of physical and logical database design Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
  • Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
  • Extract Transform Load ETL development using SQL Server Integration Services SSIS .
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
  • Worked in Active, Active Passive Cluster environment as a High availability solution.
  • Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
  • 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.
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Checking Database Health by using DBCC Commands.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Prepared Documentation for the Disaster Recovery plan
  • Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Responsible routine DBA jobs like Backups and Restores.
  • Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS, ReportBuilder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering ,Windows XP/2000 and Windows 2003/2008 Server.

Confidential

Role: SQL Server DBA

Confidential is a global provider of industrial automation, power, control and information solutions. Brands in industrial automation include Allen-Bradley and Rockwell Software.

Responsibilities:

  • Installed SQL Server 2008r2 on Standalone and Clustered Environments.
  • Upgraded /Migrated of SQL Server from version 2005 to 2008r2.
  • Installed Microsoft Service Packs/Patches/Hotfixes.
  • Configured and administered SQL Clusters Active/Passive, Active/Active , Database Mirroring, Replication and Log shipping.
  • Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
  • Performed Attach/ Detach, BCP, Import Exports and Copy Database Wizard.
  • Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
  • Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
  • Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
  • Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
  • Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
  • Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services DTS and SQL Server Integration Services SSIS .
  • Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
  • Created Reports using SSRS 2005/2008.
  • Utilized DMV's, Data partitioning and Performance Dashboards reports with SQL Server2005.
  • Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
  • Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
  • Created various Jobs, scheduled ran jobs and troubleshooted the failed jobs.
  • Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2005/2008/2008r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.

Confidential

Role: SQL Server DBA / Developer

Confidential is a chain of beauty superstores in the Confidential. Each store is outfitted with a full-service salon as well. Ulta carries a variety of cosmetics and skincare brands, men's and women's fragrances, and professionally licensed haircare products.

Responsibilities:

  • Installation of SQL Server 2005 with latest Service Packs.
  • Worked in Active/Passive Clustered Environment.
  • Writing stored procedures for report generation in migration process and replication.
  • Implemented the migration of SQL Server 2000 to 2005.
  • Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
  • Experience in monitoring software tools used to monitor the environment effectively.
  • Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
  • Maintain both DEVELOPMENT and PRODUCTION server in sync.
  • Involved in Log Shipping.
  • Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
  • Involved in Monitoring Performance of different production servers.
  • Worked in 24x7 production environment.
  • Working with the end user gathering requirements for the system.
  • Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
  • Creating Logins and Roles with appropriate permissions.
  • Prepared and documented Backup Restore Plans.
  • Creating and Maintaining Database Maintenance Plans.
  • Requirements gathering from the end-users.
  • Extensively involved in designing the SSIS packages to export data of flat file source to SQL Serverdatabase.
  • Involved in analyzing the system for setting up new server and server configuration.

Environment: Windows 2000/2003 server, MS SQL Server 2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.

Confidential

Role: SQL DBA

Responsibilities:

  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T-SQL.
  • Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
  • DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
  • Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
  • Migrated data to other databases and Created DTS Packages to import data from Excel spreadsheets and Implementing user training and providing technical support.
  • Designed the logical and physical databases and development of SQL Server Database and Database testing, maintaining the data and writing the procedure.

Environment: SQL Server 2000/2005 Enterprise Edition, Advanced Windows 2003 Server, SQL Query Analyzer, Enterprise Manager, IBM system x3650

Hire Now