We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Handling assignments to unfold career opportunities and manage projects involving technical challenges.
  • Treating every adversity as an opportunity, aspire to morph every opportunity to an achievement and work in an energetic way to boost the performance of the organization.
  • Having 3 years of IT experience on MS SQL Database Administration and Manual Testing
  • Managing and administrating MS SQL Server 2008R2/2008/2005 running on Windows platforms 2008R2/2008/2003
  • Worked on setting up and monitoring Transactional Replication with Push subscription on SQL Server 2008/2005 for reporting purposes
  • Installation, configuration and management of Database Mirroring with High Performance (Asynchronous mode) in SQL 2008 for disaster recovery
  • Involved in developing Backup and Restore strategy for production and development environment
  • Good experience in performing Database Backups (Full, Differential and T - log), Database Restores and Point-in-time Recovery of SQL Server databases
  • Performed Database Maintenance activities such as Performance monitoring, Server disk space and log space monitoring, ensuring the successful execution of maintenance jobs, CPU threshold, Disk I/O, Blockings, Database corruption and many more
  • Identifying Index fragmentation using DMVs and Reorganizing/Rebuilding the indexes at regular intervals for better performance based on the level of fragmentation
  • Identifying and resolving Blockings, CPU bottleneck, index usage and user connection issues using DMVs, DMFs
  • Involved in troubleshooting issues related to database consistency, statistics, deadlocks, long running transactions, disk space and log space using DBCC (Database Console Commands)
  • Involved in troubleshooting SQL Server connectivity and database connectivity issues
  • Monitoring the Windows event logs and SQL server error logs for troubleshooting errors
  • Used SQL Server Profiler to create traces and troubleshoot particular events, database activities of particular users and applications
  • Involved in troubleshooting databases for its performance and concurrency issues
  • Installation and configuration of MS SQL Server 2008R2/2008/2005 in clustered (active/passive) and standalone environments
  • Installed SCOM (System Centre Operations Manager) 2007 R2 Agent on SQL Servers for monitoring the SQL Agent jobs and sending alerts to the SCOM console incase of job failures
  • Deployment and Maintenance of SQL Server performance counters on SQL Server 2008/2005 instances
  • Worked with various application teams by assisting them in database design, installing SQL Server clients and migrating data from development to QA and to Production environment
  • Working closely with the management, developers and project managers to ensure successful project implementation and deliverables
  • SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) installation and configuration on Application servers
  • Have Good knowledge on Database architecture, Backup and Restore concepts, Database Recovery models, Transaction Isolation levels and Windows Server failover clustering for SQL server
  • Follow ITIL processes in incident, release and change managements and prepare technical documentation. Consulting, coordinating and implementing changes as per application and business requirements
  • Creating Windows and SQL logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups and managing object level permissions as a part of security policy
  • Involved in capacity planning, sizing and estimating database growth projections
  • Setup backup and restoration jobs for development, QA and production environments
  • Imported and exported data from Excel, CSV file to SQL Server Database 2005/2008 by using DTS Import/Export wizard
  • Performed Production support and On-Call duties
  • Hands-on experience in Functional Testing, Integration Testing, System Testing, Regression testing and Compatibility testing
  • Involved in Requirements understanding discussions with client, developers, stake holders and preparing Software Requirement Specification Document and Test Plan document for the project
  • Developed extensive Test Plans, Test Cases based on the Business Requirements and Functional Specifications
  • Identifying Test Scenarios and preparing/reviewing/executing of Test Cases
  • Bug reporting and tracking using Bugzilla
  • Defect Metrics preparation and maintenance
  • Responsible for Verification of Defect fixes and subsequent closure or re-opening of the defects
  • Good knowledge in STLC and Defect life Cycle
  • Good interpersonal skills in handling status update calls with developers, client and stake holders

TECHNICAL SKILLS:

DATABASES: MS SQL Server 2008R2/2008/2005

OPERATING SYSTEM: Windows Server 2008R2/2008/2003

DATABASE TOOLS/TECHNOLOGIES: SQL Server Management Studio, SQL Server Configuration Manager, SQL Server Profiler, Windows Performance Monitor (PerfMon), T-SQL, DBCC (Database Console commands), DMVs (Dynamic Management Views), DMFs (Dynamic Management Functions), Import/Export utility

REMOTE ACCESS TOOL: Net Support Manager, PC Duo

DEFECT TRACKING TOOL: Bugzilla

WORK HISTORY:

Confidential

MS SQL Server DBA

Operating System: Windows Server 2008R2/2008/2003

Responsibilities:

  • Managing and Administrating more than 1000 MS SQL Database Server instances on Production and Non-production servers, and supporting mission critical databases as large as 2TB in size
  • Implemented Asynchronous Database Mirroring between databases in two different datacenters on SQL Server 2008 environment for disaster recovery purpose
  • Worked on setting up Transactional Replication with Push subscription for the secondary database to be used for reporting purposes
  • Used DMVs, DMFs to troubleshoot Data and index fragmentation, blockings, index usage, CPU bottleneck, user connections and many more
  • Used DBCC to troubleshoot issues related to database consistency, statistics, disk space and log space, deadlocks and long running transactions
  • Performed Full Database backup, Differential database backup and Transaction log backups
  • Performed data refresh activities to refresh the data from production to test database servers
  • Restored and Recovered databases to a specific point in time
  • Worked with developers to create and modify application Schema (Database, Tables, Views and Indexes) and deploy various Transact-SQL statements, User Defined Functions and stored procedures as per the project requirements
  • Installed and configured Microsoft SQL Server 2005, 2008 and 2008R2 on Standalone and Clustered Windows 2003/2008R2 servers, applied security fixes
  • SCOM 2007 R2 Agent installation on SQL servers for monitoring job alerts
  • Troubleshooting and resolving issues related to database connectivity and SQL Server connectivity
  • Used SQL Server profiler to monitor and record the database activities of particular users and applications for troubleshooting
  • Following ITIL process while working on incident tickets and change requests and documenting the same in ITSM tool. Consulting, coordinating and implementing changes as per application and business requirements
  • Involved in troubleshooting disk I/O issues and performance related issues by filtering and analyzing the data collected from PerfMon
  • Involved in migrating databases from SQL Server 2005 to 2008 in development and Qual environment
  • Involved in capacity planning, sizing and database growth projections

Confidential

Manual Test Engineer, MSSQL DBA

Operating System: Windows Server 2008/2003

Responsibilities:

  • Performing Functional Testing, Integration Testing, System Testing, Regression testing and Compatibility testing
  • Understanding and analyzing the user requirements and preparing Software Requirement Specification Document and Test Plan document
  • Developing Test Plans and Test Cases based on the Requirements and Functional Specifications
  • Identifying Test Scenarios to prepare Test Cases, Reviewing the Test Cases and Test case Execution
  • Logging and Tracking of Defects in Bugzilla
  • Preparing and maintaining Defect Metrics on a daily basis and handing over the report to onshore team
  • Coordinating with the developers for defect analysis and performing Regression testing
  • Responsible for Verification of Defect fixes and subsequent closure or re-opening of the defects
  • Performing Compatibility Testing to ensure compatibility of the web based application with different types/ versions of browsers
  • Good knowledge in STLC and Defect life Cycle
  • Good interpersonal skills in handling status update calls with developers, client and stake holders
  • Performed Backup, restore and recovery of databases using T-SQL commands as well as SQL Server Management Studio
  • Day to day Database health checkup and taking the appropriate measures in advance
  • Database maintenance activities such as ensuring the successful execution of maintenance jobs, monitoring CPU usage, blockings, database log size, space in data drives and many more
  • Resolving Disk Space and Log space related issues
  • Monitoring the event logs and SQL Server error log for errors and taking proactive measures
  • Scheduling jobs using SQL Server Agent
  • Troubleshooting failed SQL Server Agent jobs using SQL Server Agent error logs
  • User Management: Creation of logins, database users and roles. Granting and revoking permissions to roles, managing database object permissions and removing orphan users
  • Deployed SQL Server performance counters on SQL Server 2005 instances for monitoring SQL performance
  • Importing and Exporting data from Excel, CSV file to SQL Server Database 2005/2008 by using DTS Import/Export wizard

We'd love your feedback!