We provide IT Staff Augmentation Services!

Database Administrator - Sql Server Resume

AtlantA

SUMMARY:

  • Experienced Certified Microsoft Sql Server DBA with over 8 years’ experience in MS Sql Servers 2008, 2008R2 and 2012 in Production.
  • Proficient in Performance tuning, Replication, Failover Clustering, Data Migration, Disaster Recovery/High Availability, Database Security, Backup and Recovery.
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
  • Experience in troubleshooting and problem solving of SQL database Servers.
  • Maintenance and tuning of the databases.
  • Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
  • Experience in configuring HADR using SQL server 2008R2 and 2012.
  • Experience in improvement and maintenance of the databases to include release rollout and upgrades.
  • SQL Server Replication
  • Experience managing MS SQL server 2005, 2008, 2008r2 and 2012 RDBMS on web - based, transactions.
  • Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
  • Experience working with merge and transactional replication .
  • Experience with implementing Database Disaster Recovery and Planning
  • Proficient in performance of SQL Server software new installation and upgrades.
  • Proficient in Backup/recovery strategies implementation.
  • Proficient in maintaining and supporting SQL Server Transactional and Peer -Peer replication.
  • Expert in reviewing overall physical database structure for overall stability
  • Proficient in use of tools like SQL Server profiler and Windows performance monitor.
  • Proficient in SQL SERVER 2008 and 2008R2, 2012 database mirroring.
  • Experience with monitoring and troubleshooting 24x7 operations.

TECHNICAL SKILLS:

Databases: SQL 2005, 2008, 2008R2 and 2012

Languages: T-SQL

Tools: SQL Server, Integration Services, Microsoft Office (Access, Excel, Outlook, PowerPoint, Word).

OS and Hardware: Windows 2003/2008/2008 R2/Xp/Vista/7/8, Physical and Servers (DELL) Virtual

Operations support: 7x24, helpdesk, change management, configuration management, SLA management

PROFESSIONAL EXPERIENCE:

Database Administrator - SQL Server

Confidential, Atlanta

Responsibilities:

  • Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2008 R2/2012.
  • Experience in upgrading SQL Server from version 2008R2 to 2012.
  • Good experience with SQL Server 2005 online Indexing and Recoveries features.
  • Good experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
  • Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.
  • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
  • Experience in Data Migration Management.
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Recovering the databases from Backup in Disasters.
  • Scheduling of maintenance JOBS (Daily, Weekly, Monthly) as per the client request.
  • Administrating high availability solutions like Log shipping and Database Mirroring.
  • Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures and Profiler.
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
  • Experience in applying patches and service packs to keep the database at current patch level.
  • Experience in migrating packages from DTS to SSIS.
  • 24 X 7 Production Database on Call Support

Database Administrator - SQL Server

Confidential, Atlanta

Responsibilities:

  • Involved in setting up the backup strategy for production, test and development.
  • Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL Server 2008r2.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies
  • Experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Passive)
  • Participated in upgrading/Patching SQL Server 2005 to SQL Server 2008 servers.
  • Configured the SQL mail/DB Mail to send email alerts to the operators. Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.
  • Supported client and in-house SQL database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.
  • Created the maintenance plan for database optimization and integrity checks.
  • Experienced in Point-in-time restoring databases in production and in development servers.
  • Worked to ensure that changes to production environments were validated and thoroughly tested. This effort reduced the number of outages by over 25%.
  • Configured the log shipping in production environment to create the backup server.
  • Experienced with SQL Disaster recovery processes and documented the processes.
  • Experienced with improving databases performance using execution plan, index tuning wizards and SQL profilers.
  • Analyze SQL server deadlocking, locking and blocking and troubleshoot the root of those issue.
  • Experienced in securing the SQL Servers and assign the permissions to SQL Server users.
  • Actively involved and participated in team meetings and author how-to documents and knowledge base articles for various database related tasks

Database Administrator - SQL Server

Confidential

Responsibilities:

  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
  • Experience in trouble shooting Client connections, viewing error logs and application logs.
  • Hands on experience in DR processes including Log Shipping and Database Mirroring.
  • Proficiency in SQL Server Replication, Disaster recovery and planning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on Enterprise Manager for managing the database.
  • Troubleshoot performance problems and fine-tuning of databases.
  • Recovering the databases from backup in disasters.

Hire Now