| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
Tel PHONE NUMBER AVAILABLE, Cell PHONE NUMBER AVAILABLE
Email- EMAIL AVAILABLE
==========================================================
Objectives:
I am a Microsoft Certified SQL Server Database Administrator and seeking a SQL
DBA position to an organization that will allow me to utilize and develop my academy
education and experiences and skills.
Industry: Information Technology, MS SQL Server, DBA
Job Title: Database Administrator
Experience: 5 Years
Visa Status: U.S. Citizen
Security Clearance: Clearable
Education Level: Master s in Arts.
Certificate: MCITP (Certified DBA): Microsoft Certified IT Professional (SQL Server 2008)
AREAS OF EXPERTISE:
5 years of Database Management experience in different environments
Excellent in customer service or clients support
Ability to adapt to changing environments
Excellent ability to work with team and quick learner
Development and maintenance of reports using SQL Server Reporting Services
Attention to detail
Proven record of liabilities and responsibilities
Excellent organization skills
Skills in a fast-paced environment
Excellent written and verbal communication skills
Professional Skills
Database Management:
Strong knowledge and working experiences as Database Administrator of
MS SQL Server ( 2000, 2005, 2008 )
SQL Server Upgrade to later version
SQL Server Database Migration one server to another.
Strong working experience and knowledge with SQL Server Log shipping,
Database Mirroring,
Performance Tuning,
Database Backup/Recovery,
Query Optimization
Security Management
Tools
SQL Server
SQL Configuration manager
SQL Server Management Studio (SSMS),
Enterprise Manager (EM)
Activity Monitor,
Query Editors
Query Analyzer,
SQL Profiler,
Database Tuning Advisor (DTA)
Business Intelligence Development Studio (BIDS),
Reporting Services Configuration manager
Third Party Tools
Toads for Data Modeling
Spotlight for Performance Monitoring
Operating Systems:
Windows Server 2008, 2008 R2, 2003,
Windows XP Professional,
Windows 7 Professional
Windows 8
Programming:
SQL,
T-SQL,
Trigger,
Functions,
ASP, ASP.NET.
************************************************************************
Current Job
Kforce,
Washington, DC January 2012 to Present
Responsibilities:
Performs and recommends capacity planning and management of database environments.
Responsible for the overall configuration management of the database technologies,
including database installations, upgrades to new product releases and the installation of
service packs.
Apply patches for Systems and SQL Servers.
Provide ongoing support for designated applications and databases.
Experience with SQL Server Upgrade to later version
Manage the deployment, monitoring, maintenance, development, upgrade, and support of
all Database system.
Monitors and analyzes database performance, producing reports and recommendations
for improvements as needed.
Performs database tuning for diagnosing issues and optimal database performance.
Manage security procedures for specific user, user applications, access to secure
databases.
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.
Designs, develops, monitors and maintains complex database management systems and
related components underlying business applications.
Provide technical direction for Logical/Physical database design, maintenance, and
administration.
Review developer SQL queries and stored procedures for optimization and security
purposes
Used DBCC to check physical and logical consistency of database.
Working experience with T-SQL, Trigger, Function, Indexes, Constraints, File & File
Group.
Implement and Configured Log Shipping from Production to Standby Server (Running as
Reporting Server)
Experience with ODBC Connection
Implement and Configured Database Mirroring for High Availability solution.
Export & Import data from Oracle Database, MySQL, and Access Database including flat
files like text, excel.
Write and maintain database and application documentation, including data standards,
procedures, definitions for the data dictionary and logical and physical models of the
databases.
*****************************************************************************
*
Job 2
Data Group USA,
Alexandria, VA March, 2009 to December 2011
Title: Database Administrator,
Responsibilities:
Performed capacity planning for SQL Server Instance & Database.
Installed and Configure SQL Server 2000, 2005 & 2008R2 in development, test,
and production environment
Experience in Operating System, Windows Server (2000, 2003 & 2008).
Experience with SQL Server Upgrade to later version
Migrated databases within SQL Servers in test and production environment.
Identify and address database performance issues and capacity issues.
Strong experience in operational monitoring and management of databases to
ensure maximum uptime and performance, Monitor Servers activity.
Tune and solve performance problems.
Experience SQL Server Error Log, space usage, DBCC Command,
Write T-SQL and Stored-Procedures. Assist SQL developers to optimize SQL
queries and Stored Procedures.
Strong working experience in backup, restore and recovery procedures. Scheduled
jobs
Strong working experience Maintenance Plan.
Export & Import Databases.
Experience with Data Modeling: Designed Logical & Physical Database, Backward
& Forward Engineering.
Involved in creating and modifying tables, Index (Cluster/Non-Cluster),
Constraints, Views, Stored Procedures, Triggers
Rebuild Servers (Restore & Recovered from tape/CD backup) from backup
Configured Log Shipping from Production to Standby Server (Running as
Reporting Server)
Configured Database Mirroring
Writing documents for Server and databases.
|
