We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Louisville, KY

SUMMARY:

  • A self - motivated SQL Server Database Administrator who possesses strong analytical and problem solving skills.
  • My experience includes SQL Servers (2005/2008/2012/2014/2016 ), SSIS, Clustering, DB mirroring, Clustered environments and High Availability solutions.
  • I am proficient in Database Backup, Recovery, Performance Tuning, Maintenance tasks, Security and Troubleshooting.

TECHNICAL SKILLS:

  • SQL Server Installation and Implementation.
  • Database Security
  • High Availability
  • Database Upgrade patches.
  • Disaster Recovery
  • Backup and Restore
  • Data Migration
  • Strategic Planning
  • ServiceNow
  • Performance Tuning
  • Replication
  • Database Maintenance
  • T-SQL

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

  • Part of a team of 3 DBAs supporting client and in-house SQL Server database systems on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.
  • Interfacing with developers and clients to help them understand their needs based on budget and licensing cost.
  • Applied Cumulative Updates during scheduled maintenance window.
  • Management of users including creation/alteration, granting of system/DB roles and permissions on various database objects.
  • Experience in creating tables, views, indexes, stored procedures and more.
  • Environment transition planning {Development, Test, Stage, Production}.
  • Setting up and managing transactional replication, mirroring, and log shipping.
  • Familiar with Virtualization and managing SQL databases in a virtual environment.
  • Assisting in the resolution of complex problems in support of production; including on call support.
  • Proactively monitoring the database systems to ensure secure services with minimum downtime.
  • Flexible, adaptable, and able to manage multiple tasks in a dynamic environment.

ConfidentiaL

DBA/Technical Specialist

Responsibilities:

  • Imaging, staging and migrating new and existing PCs and building and supporting Windows servers.
  • Delivered the equipment to the end user location in a timely fashion to meet the deployment schedule.
  • Deployed new servers and client computers.
  • Created and maintained virtual machines.
  • Assists in writing and documenting SOP’s describing procedures and processes.
  • Locating PCs and peripherals for scheduled users and moving from secure storage to staging area, ensuring that the system hardware, operating and software systems adhere to the organization’s standards and objectives.
  • Providing technical support, development, customization and maintenance of systems that support daily operations.
  • Supporting and maintaining and monitoring the performance of programs after implementation.
  • Using Active Directory to resolve issues as needed. SCCM, Office, Skype for Business and SharePoint Administration.
  • Responding to Help Desk requests.
  • Develop and create stored procedures, advanced queries, triggers, views, indexes and functions for databases.
  • Migrated databases from SQL Server 2000/2005, SQL Server 2005/2008 and SQL Server 2008R2 to 2012.
  • Responsible for supporting the SQL Server databases and ensuring their performance, availability, and security.
  • Managing the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
  • Managing SQL Server database security by granting permissions securable to the principals and automating various routine maintenance tasks like backups, index reorganization, index rebuilds on all production databases
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Hardware related errors.
  • Using Data availability solutions like Online Restore, Online index operation, Database Snapshot and Fast Recovery.
  • Pro-actively monitored the database systems to ensure secure services with minimum downtime.

Confidential, Louisville KY

Database Administrator

Responsibilities:

  • Supporting the SQL Server Databases including database performance tuning, installing and upgrading SQL Server and its databases, clustering, monitoring database health, co-ordinating with storage teams on capacity planning and storage distribution, backing up and restoring databases, maintenance of database users and security, database development, data transfer and replication, mirroring, and server diagnostics and analysis.
  • Building out new clusters to handle mission-critical databases.
  • Automated the process of monitoring technologies entire inventory of SQL Servers to ensure good backups of all servers using T-SQL Scripts.
  • Worked as a Primary DBA on several projects including High Availability DR project tied to the company's Active Directory structure accessed by the company's 100,000+ employees.
  • Created new database logins and users as required.
  • Applying necessary SQL Server database patches and installing service packs.
  • Also part of a team that provided 24x7 on-call support for Production Databases.
  • Developed and optimized stored procedures, triggers.
  • Designed the backup and recovery strategies for SQL Server databases to meet our customer SLA requirements.
  • Responsible for driving the consolidation and upgrade efforts of all database systems into SQL Server 2012.
  • Performing frequent health checks for all backups and mission-critical production databases.
  • Standardize processes for the DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
  • Revised current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure. .
  • Ensured availability of instance and databases via clustering and mirroring.
  • Create reports that ran daily for jobs running in SQL Server Agent.

Confidential

Database Administrator/Analyst

Responsibilities:

  • Worked with a team of 8 that manages over 1200 databases of 250GB to 2TB.
  • Proactively monitored and ensured high database performance and availability.
  • Identified and troubleshoot any Blockings, Deadlocks, or hung Jobs.
  • Identified and troubleshoot any CPU or Memory spikes.
  • Monitored table and disk utilization and database fragmentation and created trace files and validate any issues on the database in question.
  • Worked with team to ensure appropriate hardware resources are allocated and worked with users to develop and optimize their SQL Server queries.
  • Designed and performed various disaster recovery procedures and database maintenance.
  • Performed and automated database backups and restores.
  • Configure log shipping, as well as schedule various jobs and design, create and schedule various maintenance plans
  • Perform routine tasks such as purging old files and checking disk space.
  • Performed various standard DBA and ad-hoc tasks.

Hire Now