We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

Brentwood, TennesseE

SUMMARY

  • Around 8 years of experience in Database Administration for Very large and complex databases in SQL Server 2008R2, 2008, 2005 and 2000.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Excellent understanding of SQL Server architecture and Database storage structure.
  • Experience in implementing Business logic by using T - SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF).
  • Well experience in analyzing Performance, Query optimization and tuning, creating Indexes, writing stored procedures.
  • Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
  • Solid experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive)
  • Handful experience in installing SQL Server 2000, 2005, 2008 & 2008R2, applying service packs and patches on stand-alone and Cluster Environment and Configuring.
  • Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
  • Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
  • Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
  • Proficient with Database Recovery models.
  • Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
  • Experience in Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Experience in SQL Server up gradation from SQL Server 2000 to SQL Server 2005 and (Side by Side and in place) in 32bit to 64 bit architecture.
  • Experience in moving system databases and user databases when needed.
  • Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
  • Having Extensive knowledge in Clustering at both Windows and SQL Server levels and maintenance.
  • Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL Lite Speed, Commvault for performance Fog light for alerting Idera.
  • Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
  • Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.
  • Experience in Administrating Windows Server 2003\2008\2008R2.
  • Having knowledge on Active Directory in Windows Server 2003 & 2008R2
  • Configured IIS in Windows server 2003
  • Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: T-SQL, HTML, XML, C/C++

Operating Systems: Windows 98/2000/2003/2008/ XP/VISTA/7

Databases: MS-SQL Server 2008 R 2/2008/2005/2000

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS).

Reporting Tools: SSRS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, Tennessee

Sr. SQL server DBA

Responsibilities:

  • Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
  • Estimated data growth from past years history and allocated SAN Space. Managed gigantic databases across the multiple disks on SAN using the file groups.
  • Databases migrated as backup restore and loaded table’s data using SSIS packages.
  • Created backup strategies based on database size and scheduled Maintenance plans, automated DB refresh jobs in Test & Development environments.
  • Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
  • Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
  • Configured Database Mirroring with high performance and high availability mode.
  • Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle, Teradata and SAS using third-party RDBMS driver tools.
  • Involved in SQL Server Hardening.
  • Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
  • Created Operators and Configured Database Mail
  • Monitored the event logs and server logs for troubleshooting and problem solving
  • Used ETL packages to move logins and jobs from one server to another server.
  • Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
  • Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
  • Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
  • Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
  • Installed and configured SSRS. Deployed RDL files on report server and managed report’s security.
  • Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), RAID levels.
  • Responsible for SSIS, SSRS package executions and availability.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, Business Intelligence Development Studio - SSIS, SSRS, Performance Monitor

Confidential, Austin, TX

Sr. SQL SERVER DBA

Responsibilities:

  • Installation and Maintenance of SQL Server 2005/2008 R2 on Test, Development and Production Environments.
  • Created Logins and Roles with appropriate Permissions.
  • Implemented side by side Migration of databases from SQL Server 2005 to SQL Server 2008.
  • Usage of native tools like Data tuning advisor, Profiler and Activity monitor for performance analysis.
  • Worked with SQL Server 2008 new MERGE statement.
  • Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003.
  • Install, migrate SQL Server database and schemas into a physical and Virtual Machine environment.
  • Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection and Compressed Backups.
  • Migrated DTS packages to SSIS packages and maintained the archival data
  • Checking Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning
  • Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
  • Designed and implemented comprehensive Backup plan and disaster recovery
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
  • Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations.
  • Monitoring SQL server performance using profiler for identifying performance issues and deadlocks.
  • Create and Maintaining Database Maintenance Tasks, including Database Consistency Check, Re-Index Update Statistics and Backups.
  • Analyzing and Modifying Stored Procedures to improve execution process.
  • Identifying and Resolving Blocking Processes.
  • Create and Maintaining Databases across Development and Production Instances.
  • Performing Database Refresh from Production to Test, in part of monthly activities.
  • Analyzing and Monitoring Disk Space Issues, on Test and Production Servers.
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential, AZ

SQL server DBA

Responsibilities:

  • Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
  • Involved in Implementing 2008, 2008 R2 active-passive clustering on Windows 2008 Operating system with consolidated environment of three SQL server versions 2008/2005 and 2000.
  • Involved and set up of SQL Server 2008 Mirroring on production servers.
  • Involved in Migration of the Server SQL Server, SQL Server and DTS to SSIS, and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
  • Maintained servers with multiple instance of SQL Server 2000, 2005 and 2008 with 24 CPU having 100 GB Memory.
  • Configured Mirroring with Transaction Replication with principle and mirror at publisher.
  • Implemented Snapshot, Transactional, and Performed mirroring as Disaster Recovery Solutions.
  • Transactional replication, adding articles, and configuring with Mirroring.
  • Involved developing and implementing jobs for SQL server, and involved in various production releases.
  • Configured the RAID levels for data files, log files and TempDB at server level.
  • Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
  • Fixing data issues and writing various SQL scripts and procedures for migration process.
  • Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers and Online indexing.
  • Responsible for transferring packages using SSIS and transferring SQL Server Objects from QA to Production Using SSIS Packages.
  • Deployed Reports on Report Server.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
  • To setup, implement, and maintain industry standards in database management.
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
  • Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Trouble shooting SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
  • Planned the Complete backing up of Database and Restoring the Database from Disaster Recovery.
  • 24 X 7 Production Database on Call Support

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.

Hire Now