We provide IT Staff Augmentation Services!

Sql Server Dba Resume

2.00/5 (Submit Your Rating)

Alexandria, VA

SUMMARY

  • An accomplished Database administrator with demonstrated success designing, coding, testing, and supporting next - generation database solutions in SQL Server environments.
  • I am responsible for the performance, support operations and maintenance, integrity and security of a database which are likely to include planning, development, database failover clustering, database tuning, and troubleshooting. A self-motivated, responsible, and reliable team player.
  • Over 5 years of IT experience with all aspect of Design, implementing & Administration of SQL Server 2000/2005/2008/2012 databases size ranging from 8GBs to 10TBs in Government, and Financial Sectors
  • Expert in installing, configuring, managing, monitoring and troubleshooting SQL Server
  • Worked on design, migrate and upgrade from SQL Server 2000 to 2005, 2000/2005 to 2008, 2005/2008 to 2012
  • Solid experience and knowledge of SQL Server high availability solutions - Replication, Clustering, Mirroring, and Log Shipping
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
  • Experienced in Maintaining enterprise databases, Backup & Recovery and Security.
  • Administered Windows 64 bit 2008 Cluster Servers with Active/Passive nodes/ Servers
  • Experienced with T-SQL Scripts - Stored Procedures, Functions and Triggers.
  • Experienced in managing and maintaining Microsoft Windows based Networks and Active directory.
  • Programming languages: C++, Java, Visual Basic, Internet programming, and OOP.

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential - Alexandria, VA

Responsibilities:

  • Installed configure, upgrade/migrate, and manage SQL server 2012,2008,and 2005 Enterprise Edition
  • Performing backup and restore tasks using SQL Server 2005.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion,
  • Experience in Data center servers and handling up to 10 TB's of Databases and 100s of SQL Server Instances.
  • Deploying new code base release User Acceptance Testing( UAT) and Production Environments
  • Database High Availability: Installed, configured and manage Fail-Over Clustering (Active-Passive, Active-Active Cluster) using SQL server 2012, Database Mirroring in SQL Server 2008R2 and 2012, Log Shipping and Replication.
  • Report Development: Install, configure, and administer SQL Server Reporting Services (SSRS 2008 R2, 2012), Developed, Deployed, and managed Reports/Ad-hoc Reports and Export/ Import data.
  • Experienced with Data Modeling, Patching/Hotfix, and Database Performance Tuning using SQL Profiler and Windows Performance Monitor, and Index tuning Wizard.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Security: Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to users
  • Experienced in managing Alerts, Operators and Jobs through SQL Server Agent

DBA - Database Administrator

Confidential - Springfield, VA

Responsibilities:

  • Demonstrate extensive knowledge of all aspects Microsoft SQL Server including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services and Integration Services.
  • Install, configure, upgrade SQL Server 2005, 2008 & 2012, monitor and maintain databases in the production, development, and quality assurance environments.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention issues using both native tools and systems management products.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, database mirroring, and replication.
  • Configure database mail, alerts, and notifications.

Technical Support Specialist

Confidential - Selma, TX

Responsibilities:

  • Installing and providing technical support for PC, Printers, Network Card, MS Office, Wireless Network and maintaining and updating Company website
  • Installed, configured, and trouble shoot 2000, and 2005 in Development Environment
  • Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery SQL DBA for 24*7 Data Center.
  • Providing Data Export/Import Process and Databases Migrating.

Technical Database Administrator

Confidential

Responsibilities:

  • Perform business analysis, technical analysis, systems design, application software programming.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies implemented.

We'd love your feedback!