Sql Dba Resume Profile
Summary:
- 8 years of IT experience as a MS SQL Server Database Administrator 2008R2/2008/2005/ 2000.
- Strong knowledge working with all phase of Software Development Life Cycle SDLC .
- Expert in installation, upgrade, configuration and administration of MS SQL Server 2008R2, 2008, 2005 2000 in clustered and standalone environments.
- Worked in collaborative team environment with other developers, business analysts, and a project management team.
- Extensive knowledge of maintaining SQL authenticated and Windows authenticated logins/users and grant proper privilege.
- Strong experience in capacity planning, implementing backup and recovery strategy for application and database.
- Expertise in implementing Database Mirroring in SQL Server 2005, 2008 and 2008R2 for high availability.
- Successfully tested and implemented Log Shipping Technique used for warm standby solution for MS SQL Server 2005/08databases.
- Experience in implementing Snapshot and Transactional replication models.
- Successfully Implemented TDE Transparent Data Encryption to secure data at rest and document the process.
- Extensive experience in MS SQL Server 2008/2005/2000, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services.
- Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perfmon Counters and Spotlight.
- Extensive knowledge of configuring Database mail in SQL Server 2008R2, 2008 and 2005.
- Good Knowledge of SQL Server Dynamic Management Views as well as third party tools like Spotlights, Diagnostic Manager from Idera for Monitoring performance and maintenance of MS SQL Server.
- Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/ Sybase databases.
- Stronger experience in logical and physical database design and development, normalization, data modeling and SQL server Enterprise Manager/SQL Server Management Studio.
- Expert in using tools like MS SQL Profiler, Index tuning wizard, Windows performance for monitoring and tuning SQL server performance.
- Extensive experience in using T-SQL for developing complex stored procedures, triggers, tables, views, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
- Experience in implementing the new features of MS SQL Server 2008 such as Policy Based Management, Backup Compression and Transparent Data Encryption.
- Knowledge of new features in SQL server 2012.
- Experience working with 24x7 Production support for 2008R2, 2008, 2005 and 2000 SQL Server.
OTHER SKILLS:
- Team player Ability to work in teams
- Ability to carry out tasks independently
- Strong oral and written communication skills
- Excellent Management skills
Databases | MS SQL Server 2008, 2005, 2000, MS Access. |
Programming languages | T-SQL, C, C , Visual Studio 2008 |
Microsoft Office | Word, PowerPoint, Excel, Outlook, Notepad |
Operating Systems | Windows 2000 server, Windows 2003 server, Windows 2008 server, Windows XP Home/Professional, Windows Vista, Windows 7 |
BI Skills | SQL Server Integration Services ETL-SSIS , SQL Server Reporting Services SSRS |
Third-Party Tools | MS Visio 2007/2003, Lite speed, Quest Performance Analyzer, Spotlight, Idera |
Microsoft Certified Technology Specialist: SQL Server 2008, Database Development MCTS Development | |
PROFESSIONAL EXPERIENCE: Confidential Senior SQL DBA Responsibilities: |
- Install and configure SQL server 2008R2, 2008 and 2005.
- Migrating and upgrading SQL instances from SQL 2005 to 2008 and 2008R2.
- Planned, installed, configured and maintained the SQL Server 2008 in Environment of Active/Passive Cluster.
- Experienced in implementing Database Mirroring for disaster recovery.
- Optimization and Performance tuning using SQL Profiler and Performance Monitor.
- Extensively used Filtered indexes to improve query performance and lower storage and maintenance costs.
- Optimization of Stored procedures, Slow running Queries and indexes.
- Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging
- Successfully Implemented TDE Transparent Data Encryption to secure data at rest and document the process.
- Schedule SQL Agent jobs in shrinking fast growing log files, deleting junk records or old logins, updating statistics, and checking integrity of databases.
- Worked with Development team to modify the migrated complex SSIS packages.
- Experience in connecting to remote SQL Servers as Linked Servers.
- Prepared high-level documentation for the Database Design, Database objects Security and Rules.
- Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
- Worked on Database and Transaction log backups restoration, backup strategies, scheduling the backups.
- Experience in contacting Microsoft and other vendors for product and technical support.
- Created deployment scripts, including rollback scripts, for all SQL Server changes.
- Experience in providing 24X7 Production support.
Environment:
Windows Server 2008/2003, MS SQL Server 2000/2005/2008/2008R2, Microsoft SQL Server Reporting Services, Quest Performance Analyzer
Confidential
Senior SQL DBA
Responsibilities:
- Migrating databases and database objects between multiple servers across production and development platforms.
- Designing and implementing Disaster Recovery Procedures like Log Shipping.
- Configured and maintained Transactional Replication in SQL Server 2008/2005 in different domains as business requirement.
- Troubleshooting, monitoring, and tuning SQL server and databases performance using SQL Profiler, Performance monitor and DMVs
- Verifying and maintaining database backups, integrity checks, and scheduled jobs.
- Hands on experience and outstanding knowledge of high availability SQL Server solutions like SQL Server clustering.
- Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance using System Monitor, SQL Profiler, and DBCC utilities
- Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users
- Analyzing potential problems, e.g., response delay, locking, server down time, login issues etc, for optimization of performance
- Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
- Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
- Creating and managing schema objects such as tables, views, indexes, procedures, and triggers
- Expertise in Security Issues such as creation and granting permissions on various Objects.
- Preparing the reports for the day-to-day as well as weekly/monthly purposes.
Environment:
MS SQL Server 2005/2008, Windows Server 2003 Enterprise, Query Analyzer, SSMS.
Confidential
SQL DBA
Responsibilities:
- Involved in upgrading the instance of SQL Server 2000 to SQL Server 2008 in testing and production environment.
- Created and managed Users/Logins.
- Configured a 'warm standby' by implementing Log Shipping as a fault tolerance mechanism for the critical operational databases.
- Involved in optimization and performance tuning of SQL Server using SQL Server Profiler and Idera's diagnostic manager.
- Used Idera's Diagnostic Manager and Performance monitor for monitoring SQL Server Activities and keep a real time check on health, availability and performance of SQL Server.
- Actively involved in configuring and managing 2 node Failover Cluster set up in Active/Passive Environment as a 'High Availability' mechanism to avoid downtime because of unintentional/intentional failure/shutdown of primary server.
- Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
- Successfully converted DTS packages to SSIS packages during migration.
- Extensively documented all the databases, database objects, jobs and the changes made to the database.
- Studied system requirements by analyzing real time business needs.
- Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity, rebuild of indexes, update statistics etc.
- Successfully worked on data extraction, transforming and loading ETL data using SQL Server Integration Services SSIS and DTS.
- Responsible for creating SSRS reports using the wizard, list reports and prepared reports for the day-to-day as well as weekly/monthly purposes.
Environment:
MS SQL Server 2000/2005, Windows 2000 data centre/advance server, SSMS, SSRS, SSIS, Idera's Diagnostic Manager, and Enterprise Manager.
Confidential
SQL DBA
Responsibilities:
- Installation and Configuration of SQL Server 2005.
- Review / test / apply all database changes to all environments including QA, Development and Production Servers. Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking deadlocks.
- Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
- Actively participated in Logical design phase of new database. Worked on MS Visual Studio to draw data model.
- Worked on Linked Servers to run distributed queries between SQL server and other data sources using Drivers.
- Implemented built in log shipping as disaster recovery server.
- Solved issues related to server performance and disk space.
- Resolved issues related to query optimization, database optimization and index tuning.
- Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers maintaining Referential Integrity.
- Written visual basic scripts to monitor the application and for sending mails in case of any discrepancy.
- Creating and running DTS Packages for Import and Export of Heterogeneous Data.
- Used Idera's Diagnostic Manager and Performance monitor for monitoring SQL Server Activities and keep a real time check on health, availability and performance of SQL Server.
- Involved in writing stored procedures for different tasks.
- Provide 24X7 on-call technical supports and help desk.
Environment:
MS SQL Server 2005, Visual studio.net, Windows 2003 server, SSMS, SSIS, SSRS, Query Analyzer, MS Visual Studio.