LiveCareer-Resume

sql server dba resume example with 10+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
  • :
Professional Summary

Continuous integration on testing automation Proactively used Tuning Advisory, Query Optimization plan and Query Execution plan in order to address Database locking, deadlocking and blocking issue. Experience in creating and maintaining Backup and Restore strategy, Replication and Log-Shipping strategy as a part of Disaster recovery. Excellent in Capacity Planning and storage management. Experience in supporting and troubleshooting huge databases performance as well as security problems. Expert in installing different Software both in Cluster and non-Clustered environment. Experience in Security auditing and managing performance monitoring tools. Experienced in Developing and Implementing Project plans in MS Project. Worked as both independently as well as in team-oriented environments. Excellent analytical and communication skills with 24/7 rotated support experience. Create and manage Logins, users, roles and add groups to windows and SQL server. Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues. Responsible to Monitor and troubleshooting Log Shipping.

Skills
  • TECHNICAL SKILLS:
  • RDMS:
  • MS SQL Server 2008R2/XXX2/XXX4/XXX6, MS Access XXX3/XXX6
  • Programming: SQL, T-SQL C, C++, Java, Java Script, COBOL, ASP, HTML
  • Operating Systems/Server: Windows 2008/XXX0, Workstation, Windows NT/XP/VISTA/98,
  • Applications: MS Office, MS Visio, Cute FTP, WS FTP and Paint Shop-Pro
  • Tools: LiteSpeed (Backup Tools), Diagnostic Manager (Idera), Compliance Manager (Idera) SQL native Monitoring tools, NT Performance monitor/System monitor, TSQL, Erwin, SQL Profiler and SQL Query Analyzer.
  • Department Of Justice (Active public trust)
  • Microsoft Visual C#.NET
  • Linux operating system
  • Database development
Work History
SQL server DBA, 01/XXX7 - Current
Qsronline.Com, Llc Corpus Christi, TX,
  • Installed, Configured, and Maintained SQL Server XXX9, XXX6, XXX4 and XXX2 in development, test, and production environment
  • Configured and Maintained Fail-Over Clustering using SQL Server XXX2
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Developed and deployed different types of Reports using different data sources like SQL Server, Excel, CSV files
  • Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
  • Worked in a fast-paced, dynamic team environment to provide basic administration for Microsoft SharePoint and other enterprise-level content management portals and manage organizational content to meet the needs across multiple project teams
  • Experience working in the Azure Cloud
  • Extensive hands-on experience implementing scalable solutions using Azure services: Azure SQL DB/DW, Azure storage
  • Maintain Azure database, migrate database to Azure
  • Azure backup and Restore databases
  • Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability
  • Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2008 R2 to XXX2
  • Migrated MS Access Databases into MS SQL Server XXX2 and XXX4/XXX6
  • Applied SP (Service Pack)/ hot fixes on SQL Server Instances to address security and upgraded related issues
  • Performed database and SQL/TSQL Performance Tuning
  • Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
  • Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification
  • Developed Different Maintenance Plans for database monitoring
  • Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
  • Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
  • Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like Erwin, Toad Data Modeler, and SQL Server Data Diagram
  • Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
  • Deployed SSIS packages to move data across server, move logins, load data from different data sources
  • Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
  • Manual, on Demand and setup jobs for Database Backup, and design backup strategy
  • Deployed and restored database including Point in Time Recovery
  • Monitor Server Activity, Error Log, space usage and solving problem as needed.
  • Produced high-standard database solutions to meet stability, reliability and performance metrics.
  • Analyzed business reports for prompt communication, follow-up and ongoing support.
SQL server DBA, 08/XXX6 - 12/XXX7
Qsronline.Com, Llc Corpus Christi, TX,
  • Upgrade, Install and support SQL servers including production, Test and developing servers
  • Installed and configure SQL server 2005/2008/2008R2/XXX2/XXX4 on standalone machine as well as on Cluster environment
  • Installed and reviewed SQL server patches as well as service packs
  • Design and configure Database, tables, indexes, store procedures, functions and triggers
  • Troubleshoot database status, performance, Replication, Log-shipping, Always On Availability as well as various errors on production, development and UAT servers
  • Configured and deployed Reporting Service
  • Create maintenance plan for Backup and Restore, performance tune up
  • Involved in setting up the backup strategy for production, test and development
  • Experienced in Point-in-time restoring databases in production and development servers
  • Export and import DTS/SSIS packages for source serve to destination server in all environments
  • Monitoring SQL servers for performance pro-actively
  • Support customer and application deployment round the clock
  • Manage and maintain database security and access
  • Create documents for deployment and troubleshot issue for references
  • Configured database mailing for notification services
SQL Server DBA, 02/XXX5 - 06/XXX6
Qsronline.Com, Llc Corpus Christi, TX,
  • (1s Level Support)
  • Responsibility
  • Act as a production support and upgrade DBA, maintained 36 SQL Servers including production, test and development servers
  • Participate in upgrading/Patching SQL Server 2005 servers and SQL 2008
  • Upgrade SQL server 2005 to 2008
  • Installed SQL Server 2005, 2008/2008R2, applied service packs and security fix for the servers installed on windows 2003, 2008R2 servers
  • Installed and configured the MS SQL Fail over clustering for production servers
  • Involved in setting up the backup strategy for production, test and development
  • Experienced in Point-in-time restoring databases in production and in development servers
  • Configured and deployed Reporting Service
  • Configured the log shipping in production environment to create the backup server
  • Experienced with SQL Disaster recovery processes and documented the processes
  • Configured the SQL mail/DB Mail to send email alerts to the operators
  • Created the maintenance plan for database optimization and integrity checks
  • Experienced in monitoring\capturing SQL Server performance issue by using Windows Performance Monitor\Task Manager\SQL native Monitor\SQL profiler
  • 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 involve and participate in team meetings and author how-to documents and knowledge base articles for various database related tasks
SQL Server DBA, 01/XXX2 - 10/XXX4
Qsronline.Com, Llc Corpus Christi, TX,
  • Worked in Active passive cluster environment
  • Used log shipping for synchronization of databases
  • SQL Server 2005 Database Administration
  • To handle the migration of SQL Server 2005 to SQL Server 2008
  • Responsible to Monitor and troubleshooting Log Shipping
  • Update statistics, database integrity check and Backup operation
  • Wrote and debugged Stored Procedures, Triggers and Functions as per client requirements
  • Daily tasks of Developer/DBA like space issues on Production and Test Servers and handling maintenance Jobs handling and user’s permissions
  • Designed and implemented comprehensive Backup plan and disaster recovery
  • Worked extensively in Query analyzer and profiler for tuning queries
  • Performed Performance Tuning of the Stored Procedures
  • Experience in trouble shooting database issues
  • Monitoring SQL server performance using profiler to find the performance and deadlocks.
Education
Bachelor of information science: , Expected in
-
- ,
GPA:
Status -
Certifications

AZURE Administrator Associate

scrum master certified

CompTIA security+ certification

Microsoft SQLServer2008/2008R2/XXX2/XXX4/XXX6Administration Training at Microsoft.

,
Additional Information
  • Experienced in Database Designing, Implementation and System Administration using Microsoft SQL Server 2008/2008R2/XXX2/XXX4/XXX6/XXX9. Strong experiences in Installing/Upgrading/Patching, Memory Configuration and security management. Microsoft Azure Cloud, Azure SQL Database including installation, configuration, backup/restore, security, AD groups, managing resource groups, storage blobs. Experience in SQL Clustering on different version of windows Servers. Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

Job Titles Held:

  • SQL server DBA
  • SQL server DBA
  • SQL Server DBA
  • SQL Server DBA

Degrees

  • Bachelor of information science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: