We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Woodbridge, VA

OBJECTIVE

A self-starting, innovative, constructive, and result oriented professional, seeking opportunity to work as a SQL Server DBA. I am looking for a position to a growing Company, Where I would found a unique opportunity to provide, invest, and prove my skills and expertise as a SQL Server Database Administrator.

Profile

Industry Focus: Information Technology, MS SQL Server, DBA
Job Title: SQL Server Database Administrator
Experience: 6 Years
Visa Status: U.S. Citizen
Security Clearance: Security Clearance is on the process.
References: Available upon request

Level of Education

  • Master’s in Science

Certificates

  • MCITP (Certified DBA): Microsoft Certified IT Professional (SQL Server 2008).
  • CompTIA A+

Summary of Qualification & Experience

Database Management----

  • Experience in Production, Test and Development Environment,
  • Installation & Administration MS SQL Server 2008/2005/2000,
  • Related experience with Windows Server 2003/2008,
  • Relational Database Design (Logical, Physical, Conceptual, Dimensional) ,
  • Monitoring, diagnosing problems,
  • Performance Tuning/Optimization,
  • SQL/T-SQL Tuning; Writing T-SQL and working with developers in writing queries and debugging codes,
  • Backup & Recovery,
  • Security Management,
  • Replication: Marge Replication, Snapshot Replication, Transactional Replication, Peer-to-Peer Transactional Replication,
  • Working experience with clustered database,
  • Working experience Database mirroring,
  • SQL Server Reporting Server/Services Installation and Administration; Reports Development using SQL Server Reporting Tool (SSRS),
  • Working knowledge with SQL Server Integration Service (SSIS),
  • Working knowledge with SQL Server Analysis Service (SSAS),
  • MS SQL Server LogShipping Admin/Installation,
  • Database Migration, upgrade; Migrated Oracle, MySQL Databases to SQL Server,
  • Virtualization: VMware, Microsoft Virtual Server

Operating Systems---

  • Good knowledge and working experience with Operating Systems (O/S) includes Windows Server 2008, 2003, 2000, Windows XP Professional, Windows7 Professional, Unix, Linux.

Programming----

  • T-SQL, Store Procedures, Trigger, Functions, ASP, ASP.NET, Cold Fusion, MS SharePoint.

Database Tools Used---
SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, SQL Configuration manager
Third-Party Tools: ERWin, Toad for SQL Server, Spotlight, Visio, Idera for SQL Doctor, patch Analyze, backup Analyze, quick indexing,
Microsoft Office 2003/2007/2010----Excel, Access, Outlook, Word, PowerPoint
Administrative Tasks---
Backing up and restoring data, Changing group membership, Creating user and group accounts, Resetting user passwords, Deploying and upgrading software, Installing and Setting up a DHCP server, Managing disks and volumes, Managing files and folders, Managing servers remotely, Managing services, Monitoring network traffic, Monitoring server performance, Scheduling Tasks, Setting up TCP/IP, Setting user group security

PROFESSIONAL STRENGTHS

  • 6 years of Database Management experience in different environments (Test, Development, Production, and Clustered)
  • Excellent in clients support
  • Ability to adapt to changing environments
  • Excellent ability to work as part of a team and independently;
  • Research new topics & quick, and continuous learner.
  • Detail-oriented, proactive in communicating progress and issues,
  • Able to manage time too effectively to meet deadlines and prioritize workload.
  • Ability to tailor a system to meet specific organizational needs.
  • Excellent analytical, interpersonal, problem-solving skills.
  • Experience covers all aspects and levels of database Administration.
  • Self-motivated,
  • Strong communication and documentation skills
  • Ability to independently manage projects and meet deadlines.
  • Ability to work under pressure in a fast-paced environment
  • Deadline-sensitive execution
  • Inspiriting organizational leadership
  • Sedulous appetite for innovation

PROFESSIONAL EXPERIENCE

Current Job---
Confidential
Confidential
Arlington, VA
Title: SQL Server Database Administrator
Information Technology: Operations
November, 2010 to Present

Responsibilities:

  • Working Experience in SQL Server High Availability 24x7 Clustered Environment
  • Installation, Configuration, Upgrade SQL Server 2000, 2005 & 2008,
  • Administration and Manage SQL Server 2000, 2005 & 2008 with Virtual/Enterprise Linux Environment,
  • Analyze current maintenance and configuration for databases to evaluate and adjust as required,
  • Installed and Configured Operating System, Windows Server (2003 & 2008),
  • Designs and builds high-volume relational databases for applications and systems,
  • Work with customers and developers to design data management, information life-cycle management, infrastructure design, security and data integrity controls,
  • Maintain database and application documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases,
  • Develops database documentation, procedures and policies. Works with the system administrator to manage user and application security levels for the database,
  • Responsible for the overall configuration management of the database technologies, including initial database installations, upgrades, and the installation of service packs,
  • Provide ongoing support for designated applications and databases,
    Maintains a deep understanding of relational principles, general DBA techniques and practices ,
  • Expert level of capacity planning,
  • Supports database platforms and helps define strategies for data acquisition, recovery, migration and archiving,
  • Data Modeling using SQL Server ER-Diagram (Logical & Physical, Backward & Forward Engineering),
  • Identify and address database performance issues and capacity issues,
  • Develop plans for and be able to execute disaster recovery for SQL server database systems,
  • Created Backup strategy for production and development environment,
  • Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements,
  • Performing and supports Cold/hot Backups & Recovery procedures,
  • Developed Database Maintenance Plan, Scheduled jobs,
  • Rebuild Servers (Restore & Recovered from tape/CD backup) from backup,
  • Rebuild master database (System Databases),
  • Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access,
  • Assist and review developer SQL queries (T-SQL) and stored procedures for optimization and security purposes,
  • Performance tunes and writes code for database access, modifications, and constructions including stored procedures, views and triggers,
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers,
  • Indexes---- Manage Missing Indexes, Duplicate Indexes, Hypothetical Indexes, Consolidate Indexes,
  • Monitor systems for optimum performance,
  • Monitors and analyzes database performance, producing reports and recommendations for improvements as needed,
    Troubleshoots and isolates performance problems in production databases,
    Migrated databases from SQL Server 2000 to 2005 and 2005 to 2008 in test and production environment,
  • Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,
  • Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel,
  • Configured and Maintained Replications,
  • Expert level of working experience in LogShipping, Database Mirroring,
  • Working Experience with SQL Server Replication: Transactional Replication, Peer-to-Peer Transactional Replication,
  • Implement policies related to compliance and information protection as they apply in the database environment,
  • Effectively articulate database requirements to non-database teams.

Job2---
Confidential
Alexandria, VA
SQL Server Database Administrator
Development & Operation
December, 2007- October, 2010
Responsibilities:

  • Working experience in development, test, and production environment,
  • Working experience in Fail-Over Cluster Servers,
  • Installed, Configured, Administration and Maintained SQL Server 2000, 2005 & 2008,
  • Installed and Configured Operating System, Windows Server (2000, 2003 & 2008),
  • Migrated databases from SQL Server 2000 to 2005 and 2005 to 2008 in Development, Test and production environment,
  • Capacity Planning For the Databases & Servers,
  • Disaster Recovery plan,
  • Created Backup strategy for production and development environment,
  • Developed Database Maintenance Plan, Scheduled jobs,
  • Writing T-SQL and Stored-Procedures, Triggers, Functions,
  • Assist SQL developers to optimize SQL queries and Stored Procedures,
  • Monitor Servers activity, solving problem,
  • Performance tuning & index tuning,
  • SQL Server Error Log, space usage,
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes,
  • Working experience in LogShipping, Database Mirroring,
  • Export & Import data from Oracle Database, MySQL, and Access Database including flat files like text, excel, and CSV files,
  • Experience in using DTS to import & export data from flat files, excel and MS Access to MS SQL Server databases,
  • Data Modeling,
  • Designed Logical & Physical Database, Backward & Forward Engineering,
  • Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints, Views, Stored Procedures, Triggers,
  • Migrated MS Access 2000/97 databases into MS SQL Server,
  • Migrated SQL Server 2000 to SQL Server 2005/2008,
  • Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,
  • Rebuild Servers (Restore & Recovered from tape/CD backup) from backup,
    Configured Log Shipping from Production to Standby Server (Running as Reporting Server),
  • Configured and Maintained Replications (Transactional),
  • Configured and Administration Database Mirroring.

Job3---
Confidential, Woodbridge, VA
E-Commerce and Data Processing
Title: DBA/Management
Woodbridge, VA
Nov, 2005 – 2007
Responsibilities:

  • Installed, Configured, Administration and Maintained SQL Server 2000, 2005 & 2008,
  • Installed and Configured Operating System, Windows Server (2000, 2003 & 2008),
  • Capacity Planning For the Databases & Servers,
  • Design, Implementation and Maintaining Company database,
  • Maintenance Plan, Scheduled jobs,
  • Created Backup strategy, Database Backup & Restore,
  • Monitor Servers activity, solving problem,
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes,
  • Help desk support for Clients,
  • Support employees’ documentation and managing their profile
  • Used report building tools such as SSRS for company’s various report presentation,
  • Setup and configure Database mail for notification Uploads and manage inventory,
  • Rebuild Servers (Restore & Recovered from tape/CD backup) from backup,
  • Rebuild master database (System Databases),
  • Manage Security Management: Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access,
  • Configure TCP/IP, Firewall,
  • Manage Remote Servers

Hire Now