Livecareer-Resume

Sql Server Database Administrator Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • , , 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Professional Summary

Detail-oriented Database Administrator with over 8 years of experience managing both SQL Server and Oracle databases in production environments. Maintained servers and systems to ensure smooth business operations, a passionate contributor to team success with a track record of empowering teams. A self-starter who is versatile with database technologies, always motivated to learn, grow and stay current

Skills
  • Installed SQL in standalone/Clustered
  • Installed Oracle standalone and RAC
  • RedHat/Linux system administration
  • Database migration to Microsoft Azure
  • Oracle Data guard & Golden Gate
  • Database Security, upgrade & Patching
  • DNS, GRID/ASM&RAC, configuration
  • Performance Monitoring & Tuning
  • Data Modeling & application Design
  • RMAN and DATA PUMP refreshes
  • Oracle Database, Multitenant 12c, 18c &19c
  • Azure, Network, Storage Disaster Recovery
  • Managed Instances, elastic pools, Azure VMs
  • Managed Azure compute and services
Work Experience
SQL Server Database Administrator, 05/2019 to Current
Genesis Consulting GroupWashington, DC,
  • Over 4 years of experience in Administering SQL Server databases in production environments, ranging from 2012 to 2019 versions.
  • Set up and controlled user-profiles and access levels for each database segment to protect essential data, Creating, granting and monitoring user access rights and privileges through roles and profiles
  • Migration of SQL Server Databases to Microsoft Azure hosted DBs and Managed instances
  • Comprehensive knowledge of SQL Server deployment, migration, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA) and Disaster Recovery (DR)).
  • Configured database backups and restoration, monitored and tuned database.
  • Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping
  • Performed Database Migration from On-Premises SQL environment to Azure Database in cloud
  • Manage database security and users in Active Directory, insure Database Integrity and setup maintenance plans via SQL Agent.
  • Involved in planning, setup and implementation of new servers across the entire enterprise
  • Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping
Oracle/SQL Server DBA, 03/2017 to 03/2020
Brink's IncorporatedWaco, TX,
  • Installation, configuration and update of Oracle 11g, 12c &19c using OUI, DBCA, DBUA, Backup & Recovery using RMAN, Golden Gate & Data Guard administered for High availability; Disaster Recovery, Database upgrade from 11g, 12c, 18c and 19c
  • On call 24/7 SQL Server and Oracle Production Database Administration, Support and Monitoring for proactive problem resolution.
  • Involved in planning, setup and implementation of new servers across entire enterprise
  • Minimized downtime by optimizing and monitoring High Availability for SQL Server, applying Database Mirroring, Log Shipping, Traditional Failover Clustering, and AlwaysOn Cluster methods
  • Install and configure SQL Server 2016 database in standalone/cluster environment with availability groups
  • Used Performance monitor and SQL Profiler to optimize queries and enhance performance of database servers
  • Implemented and maintained Database mirroring as DR solution
  • Provide DBA support and technical expertise for multiple applications in development, test and production SQL Server 2016,2017 environments
  • Implemented backup strategy following company SLA; both physical cold and hot (incremental), and logical using RMAN and DATAPUMP utilities, respectively. Used block change tracking (BCT) which reduced backup time from 7hrs down to optimum performance
  • Championed database upgrade from 11g to 12c using Oracle data pump and DBUA respectively
  • Used Oracle Transparent Data Encryption (TDE) to encrypt tables Tablespaces, also implemented "triple-A" (AAA) and database auditing policies
  • Configured Oracle GoldenGate on Unix/Linux platform for both Unidirectional and Bidirectional replication following oracles recommendations both for standalone and Multitenant architecture
  • Configured and administered DATA GUARD for high availability and disaster recovery solution
  • Installing; configuring and administrating RedHat, Oracle Linux and other Linux Operating Systems
  • Providing instance level performance monitoring and tuning for event waits, sessions, I/O, memory usage with AWR & ADDM reports
Oracle Database Administrator, 01/2013 to 01/2017
Alerus FinancialCity, STATE,
  • Database migration using Exp/Imp/Data pumps, Monitoring and performance tuning using Oracle enterprise manager OEM Console, SQL Developer, Explain Plan, AWR, ADRCI, ADDM, DRA,
  • Support and monitor over 150 development, TEST and PROD databases by proactively resolving issues and maintaining servers. Created and implemented database designs and data models, plan and implement security measures to safeguard business data.
  • Set up and controlled user-profiles and access levels for each database segment to protect essential data, maintained technical and functional specifications to document database intentions and requirements.
  • Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
  • Performed physical, logical full backup, incremental backups, media manager, archival backups, recovery files, compress and Encrypt RMAN backups
  • Managed tablespace and datafiles, creating, Altering and dropping tablespaces, moving and renaming online datafiles
Education and Training
Bachelor of Arts: , Expected in 05/2019
University of North Dakota - Grand Forks, ND
GPA:
Technical Expertise

Oracle Database Administrator

Azure Cloud administrator

SQL Server Database Administer

Linux system administrator

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

86Good

Resume Strength

  • Formatting
  • Length
  • Measurable Results
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended
  • University of North Dakota
Job Titles Held:
  • SQL Server Database Administrator
  • Oracle/SQL Server DBA
  • Oracle Database Administrator
Degrees
  • Bachelor of Arts