We provide IT Staff Augmentation Services!

Database Engineer Resume

Irvine, CA

OBJECTIVE:

I am a certified Microsoft and Oracle Database Engineer looking to continue my career as a Database Engineer utilizing my strong technical and communication skills.

SUMMARY:

  • Six+ years of experience as a DBA in production and development environments
  • Administered SQL Server High Availability always on 2012/2014
  • Installed, upgraded and patched MS SQL 2005/2008/2012/ clusters
  • Responsible for Windows Server 2005/2008R2/2012 configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems
  • Implemented Performance Tuning including scheduled maintenance plans with DBCC CHECK DB, Index Reorganization and Update Statistics
  • Monitored data activities (i.e. database status, logs, space utilization, extents, checkpoints, locks and long transactions)
  • In - depth understanding of security and backup procedures to ensure database integrity
  • NetApp SAN administrator of six Filers in the United States and the United Kingdom
  • Created and administrated databases, tables, indexes, datasets and constraints using both Microsoft & Oracle databases

PROFESSIONAL EXPERIENCE:

Database Engineer

Confidential, Irvine, CA

Responsibilities:

  • SQL Server 2016 Always Encrypted including master and column level key administration.
  • Software Deployments weekly using Visual Studio 2012 with Team Foundation Server (TFS).
  • Standardize SQL Server environment including SAS Disks formatted to 64k, separating drives for system/user databases, TempDB and adding additional TempDB files based on virtual processors.
  • Create Performance Tuning standards (max memory, auto growth settings, DBCC Check commands, Index Tuning, Update statistics, SQL Agent errors 823, 824, 825 along with severity levels 19 through 25).
  • OLA scripts for backups and index maintenance as well as integrity checks for user and system databases.
  • Oracle 12c administration including Cloud Control and RMAN backups.
  • Oracle SQL Server Developer to assist with Oracle 12c administration of financial SBO databases.

Principal Database Administrator

Confidential, Huntington Beach, CA

Responsibilities:

  • Installed, upgrade and patch SQL Server 05/08/2012 Clusters.
  • Managed the migration of SAN Compellent storage to NetApp.
  • Assessment of SQL Environment for installation, configuration, storage, CPU, memory, IO and security.
  • Setup of jobs and alerts for Backup Restore, re-indexing, integrity checks, database shrinking, transaction log growth monitoring and routine database maintenance processes.
  • Expert in Installation, Configuration, Maintenance and Administration of SQL Server including always on SQL 2012/2014.
  • Experience in using SQL Server Native Tools (Profiler, SSMS, SSIS, SSRS, PerfMon, DMVs, DMFs) and third party DBA tools and applications (Ignite, Foglight, Nimsoft).
  • Monitored Databases for lock escalation, dead lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Capture long running SQL/runaway queries.
  • Controlled user access rights, and manage data security.

Database Administrator / SAN Administrator

Confidential, Denver, CO

Responsibilities:

  • Installed, upgrade and patch SQL Server 05/08/2012 Clusters.
  • Maintained company MS SQL 05/08/12 Databases on MS Windows platforms.
  • Set up and maintenance of SAN and SQL Disaster Recovery for three countries.
  • SAN Administration of NetApp Filers on data centers for East & West coast of United States.
  • Responsible for all backup jobs including over one hundred databases.
  • Estimated disk storage requirements for database software, files and administration needs.
  • Implemented & manage database clustering, failover and load balance technologies as per client requirement.
  • Installed & configured database software, associated tools and performance monitoring software.

Database Administrator / Technical Instructor

Confidential, Denver, CO

Responsibilities:

  • Assisted Networking team with Database Administration of SQL 05/08 Clusters on a MS Windows 2003 platform.
  • Implemented & manage database clustering, failover and load balance technologies.
  • Maintained individual service accounts for SQL Server services to raise security mark.
  • Created Linked Servers between SQL Server 2005 and 2008 R2.
  • Taught Microsoft SQL Database Administration courses.
  • Taught courses in Microsoft T-SQL as well as SSAS, SSIS, SSRS.
  • Presented multilevel classroom courses on Microsoft Excel/Outlook/Word using MOC.

Hire Now