We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

0/5 (Submit Your Rating)

Hampton, VA

SUMMARY

  • SQL Server Database Administrator (DBA) with over eight years’ experience in SQL Server Database Administration with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server database administration, gathering and analyzing business requirement and Operating Systems.
  • I have solid working experience in managing large databases, backup/recovery, developing and managing reports using SQL Server Reporting Services (SSRS), Monitoring, and Performance Tuning, stored procedures, triggers, functions, constraints and views.
  • MS SQL Server 2012/2008R 2/ 2008/2005/2000 installation, configuration and Database Administration
  • Monitoring, diagnosing problems, Performance Tuning/Optimization
  • SQL/T - SQL queries and stored procedure Tuning
  • Writing T-SQL and working with developers in writing queries and debugging codes
  • Security (Creating logins, users, roles, and assigning permission to them)
  • Backup and Recovery
  • Log shipping, Replication, Server clustering Administration, Database mirroring
  • SQL Server Reporting Services Installation and Administration
  • MS SQL Server integration service Installation and SSIS package development, deployment and administration.
  • Database Migration, Upgrade from SQL Server /2008, from

TECHNICAL SKILLS

Database: MS SQL Server 2008R 2/ 2008/2005/2000 , MySQL 5.2, MS Access 2003/ 2000

Operating System: Windows Server 2008/2003/2000 Enterprise Edition

Languages: T-SQL, Stored Procedure, Trigger, Function, HTML, ASP, ASP.net

ETL Tools: SSIS/DTS,BCP

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS and DTS, Replication, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Upgrade Advisor, SQL Configuration manager and Service manager.

Reporting: MS SQL Server Reporting Services (SSRS) 2008/2005

Networking: Active Directory, TCP/IP,HTTP, LAN

Hardware/Storage: SAN, NAS, RAID

PROFESSIONAL EXPERIENCE

Confidential, Hampton, VA

SQL database Administrator

Responsibilities:

  • Provided operational DBA support for MS SQL Server and MySQL databases
  • Performed installation, configuration, patching/upgrading, security, access control, and capacity management
  • Worked with IT team to formulate policies, procedures, and standards relating to database management
  • Recommended solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
  • Proficient in optimizing database performance, Including instance and SQL tuning, assisting staff in optimizing SQL, hardware sizing, tuning, physical design, schema design, and troubleshooting
  • Created and managed required reports in response to business user needs
  • Participated in database backward engineering project using SQL Server native tools.
  • Worked closely with appropriate stakeholders and IT team members to design data models (database dictionaries including the description of data elements and its utilization).
  • Assisted third party parties on a data cleansing project.
  • Migrated cleansed data from UAT environment to Production.
  • Created SSIS project to import data from SQL server to web server and web server to SQL server.
  • Worked in parallel with other IT teams for backup/restore planning and execution.
  • Performed copy only backups when required by the business.
  • Rebuild indexes at regular intervals for better performance.

Confidential, Washington, DC

SQL Database Administrator

Responsibilities:

  • Installed, Configured, and Administered SQL Server 2012 & 2008/ 2008 R2 in development, test, and production environment
  • Deep understanding and working experience of SQL Server 2012/2008 R2/2008/2005
  • Strong working experience with the new features of SQL Server 2008 such as database mirroring, online indexing
  • Extensive knowledge on database Backups and Restoration
  • Experienced on Backing up databases to different medias such as Local Drive, Network Drive, File Server, TAPE Media
  • Experienced with point-in-time recovery
  • Installed, Configured and Managed Database Mirroring, Replication, Log Shipping and managed Fail-Over Cluster Servers in SQL Server 2008
  • Wrote SQL/T-SQL, Stored Procedure and triggers and assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers
  • Performed database monitoring, Performance tuning, index and statistics management
  • Monitor Servers activity, and worked with clients to solve different problems
  • Managed SQL Server Error Logs, space usage, growth pattern
  • Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/rebuilding, statistics
  • Managed Blocking and Dead Locking
  • Monitor SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, Windows Performance monitor
  • Created Backup jobs for different types of backups like FULL, Differential and Transaction Log
  • Created Jobs for database maintenance:- Index fragmentation, Index rebuilding, database statistics
  • Created and managed Index (Cluster/Non-Cluster) and Constraints
  • Created and Managed Logins, users, roles, data encryption and Security Auditing
  • Used ETL tools like DTS, SSIS, Import/Export, to import & export data from flat files and excel to MS SQL Server databases
  • Migrated MS Access 2003/2000/97 databases into MS SQL Server 2005 and 2008
  • Migrated MySQL database to MS SQL Server 2008
  • Imported data from MySQL, Oracle, Excel, Flat file, CSV file, ODBC/OLEDB Data sources to SQL Server
  • Created SSIS (SQL Server Integration Services) packages in SQL Server 2008, and 2005 Integration Services (SSIS) and migrated DTS packages of SQL Server 2000 to SSIS packages
  • Installed, Configured, and administered SQL Server Reporting Services (SSRS) 2005 and 2008, Developed, Deployed and Managed Reports security
  • Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers
  • Working experience with SAN and RAID

Confidential, Virginia Beach, VA

SQL Database Administrator

Responsibilities:

  • Installed, Configured, and Managed SQL Server 2008/2005/2000 in development, test, and production environment
  • Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008.
  • Configured Log Shipping as Standby database from Production database for Reporting purposes.
  • Configured and Maintained Replications (Transactional)
  • Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Ad-hoc Reports using Report Builder 3.0, 2.0
  • Database Upgraded: SQL Server
  • Database Migrated: MS Access 2003/2000/97 databases into MS SQL Server 2005
  • Applied SP (Service Pack) and HOT Fixes on SQL Server 2000, 2005
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
  • Performance monitoring using SQL Server Profiler, Database tuning advisor, Windows Performance Monitor and Query analyzer
  • Wrote T-SQL, Trigger, Stored-Procedures and assisted Database Developers to optimize SQL queries and Stored Procedures
  • Export & Import data from Flat file, CSV file, Oracle, Access to/from SQL Server Database using DTS and SSIS
  • Strong knowledge and working experience in Database Backup and Disaster Recovery.
  • Experienced with Point-in-Time Recovery.
  • Restored Database from backup
  • Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check) and Views
  • Monitor Server Activity, and solving problem as needed

Confidential, Virginia Beach, VA

Help Desk Support

Responsibilities:

  • Provided assistance by phone, email or using ticket management system
  • Monitored and responded quickly and effectively to requests received through the IT helpdesk to the end user’s satisfaction
  • Modified configurations, utilities, software default settings, etc. for the local workstations
  • Utilized and maintain the helpdesk tracking software
  • Assisted with on boarding of new users
  • Performed PC maintenance, upgrades and configurations tracked user account creation, change, deletion, right and permissions
  • Install, test and configure new workstations, peripheral equipment and software
  • Assign users and computers to proper groups in Active Directory
  • Log all help desk interactions
  • Informed management of recurring problems
  • Diagnosed and resolved technical hardware and software issues
  • Performed timely workstation hardware and software upgrades as required

We'd love your feedback!