We provide IT Staff Augmentation Services!

Database Administrator Resume

5.00/5 (Submit Your Rating)

Smyrna, GA

SUMMARY

  • A Microsoft SQL Server Database Administrator (DBA) with over Seven years of progressive professional working experience in all aspects of SQL Server edition and versions (2000, 2005, 2008, 2008 R2, 2012, 2014, 201 and 2019), including installation,configurations and databases high availability solutions (mirroring environment, log shipping, replication, AlwaysOn, and failover cluster).Proven ability in managing large databases in a 24/7 processing.
  • Strong knowledge of database backup, disaster recovery, and point - in indexes -time recovery through database restoration. Proficient in using DBCC to check database conditions-integrity checks-, rebuilding (Cluster/Non-Cluster). Developing maintenance plans for monitoring and server activities and resolving troubleshooting questions as needed. Desire and willingness to learn new tools, techniques, concepts, and methodologies
AREAS OF EXPERTISE
  • Knowledge of SQL application software installation and configuration.
  • Experience with cloud AZURE
  • Experience in Setting up Always ON HADR Solution.
  • Administration of SQL Server Replication.
  • Strong working knowledge of Microsoft Office.
  • Experience working with SentryOne, Nagio, Red-Gate, Splunk, Service Now
  • Experience with T-SQL
  • Performance Tuning
  • Backup and Restore
  • Experience with database Encryption
  • Database Migration
  • Database Upgrade Patches
  • Experience in maintaining and supporting database applications and database servers.
  • Experience with SQL Server 2005, 2008R2, 2012, 2014. 2016, 2017,2019
  • Knowledge of SSRS, SSIS, SSAS reporting
  • Experience with Windows Server

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Smyrna, GA

Responsibilities:

  • Interact extensively with IT department members to optimize system availability and proactively address emergent concerns.
  • Installed, configured and administered SQL Servers 2008, 2008R2, 2012, 2014, 2016, 2017,2019 in production, development, test, cluster and replication server environment, updating with the latest cumulative updates.
  • Perform patching to maintain current versions of SQL Server.
  • Experienced in setting up clustered High Availability environments: AlwaysOn Availability Groups, Failover Geo-Clustering with 2 and 3 nodes (multi-subnets).
  • Experience working in Active/Active and Active/Passive cluster environments. Documented HA and DR strategies.
  • Implemented Database Mirroring, Replication (snapshot, merge, transactional) and Log Shipping to keep data alive.
  • Experienced in planning and executing disaster recovery (DR) exercise on the DR servers, as well as point-in-time recovery.
  • Implemented new processes for allocating database space, resized production data files, deliver requirements to the storage team, and created alerts for future needs.
  • Monitor database health, disk space and backup verification and SQL Server error logs.
  • Monitor CPU usage, IO statistics, memory usage to identify OS level performance killers. If needed, enable database level trace for performance test.
  • Collaborated with application development teams during application upgrades, coordinating downtime.
  • Database Migration: SQL Server to SQL Server different versions of SQL Server.
  • Implement SQL logins, roles and authentication modes as part of security policies for various categories of users.
  • Oversaw rollout of weekly application updates, performance test run into QA environment checking for failed scripts, scheduling primary run, and organizing long-term submissions.
  • Installed, configured and administered SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Assist data warehouse developers in minimizing performance bottlenecks of reporting databases, as well as troubleshooting problems.
  • Created mail profile and set alerts using SQL mail for job alerts.
  • Provide 24x7 support for out-of-hours, as well as overnight report processing.
  • Minimize database downtime and manage parameters to provide fast query responses.
  • Provide proactive and reactive data management support and training to users.
  • Continuous operational improvements.
  • Ongoing change requests for design and implementations.
  • Third party tools: Idera, SQL Sentry.

Database Administrator

Confidential, Atlanta, GA

Responsibilities:

  • Database upgrades, installation, and configuration.
  • Schema/table verification and data ingestion.
  • Orchestrated data migrations.
  • Pre-deployment testing.
  • Deployment to production services.
  • Thorough evaluation of existing environment to gauge systems' health and stability.
  • Capacity planning.
  • Capacity, performance, and security audits.
  • 24/7 monitoring, problem resolution, and root-cause analysis.
  • Configuration management.
  • Performance tuning, high availability testing, and disaster recovery.
  • Design and implement a database in accordance with the end user's information needs and views.
  • Use high-speed transaction recovery techniques and backup data.
  • Design and implement a database in accordance with the end user's information needs and views.
  • Determine, enforce and document database policies, procedures and standards.
  • Perform tests and evaluations regularly to ensure data security, privacy and integrity.
  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Supported customer service databases which are more than 2TB.
  • Coordinated with project management staff on database development timelines and project scope.
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

We'd love your feedback!