Summary
Overview
Work History
Education
Skills
Professional Job Experience
Certification
Areas Of Experience Strength
Core Experience
Timeline
Generic

MARY OYE

Loganville,GA

Summary

With over seven years of hands-on expertise in MS-SQL SERVER Database Analysis and Administration across various sectors such as Insurance, Financial Institutions, retail, and high-tech domains, I have consistently demonstrated a progression of responsibilities. Notably, I have maintained a remarkable 10-minute MTTR SLA with our esteemed clients. I excel in effectively prioritizing and completing projects and tasks within specified budgetary and time constraints while remaining adaptable to handle multiple responsibilities simultaneously. As a dynamic DBA, I thrive on acquiring knowledge of new programs and methodologies. My collaborative nature makes me an asset to any team, as I am meticulous in my attention to detail and thrive in fast-paced environments. I possess exemplary oral and written communication skills, complemented by strong problem-solving and negotiation abilities.

Overview

9
9
years of professional experience
1
1
Certification

Work History

MS SQL Server DBA

WELLSFARGO BANK
Austin, Tx
12.2019 - Current
  • Database architecture and administration, installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery, and index maintenance in a very large high-transaction, and fast-paced environment
  • Managing the production, development, and testing of databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
  • Working closely with system administrators to assist with successful installation, upgrades, and patches
  • Cloning production databases for testing/ stress testing/patch management/ upgrades
  • Managing security using SQL Logins, Roles, and Security Modes for various users including permissions and auditing, penetration and vulnerability tests, and restricting SQL access
  • Confident in Configuring and Installing SQL Server on Linux
  • Monitoring the system’s health and performance
  • Day-to-day database maintenance tasks (Monitoring, Backups, space Management, resource utilization, capacity planning)
  • Implementing Disaster Recovery and High Availability of database servers using Database mirroring, replications, always-on, Clustering, and Log Shipping
  • MS-SQL 2008/2008r2/2012/2014/2016/2017/2019 administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery
  • Use both native and various 3rd party tools like SQL Sentry, SQL Save, SolarWinds, Idera SQL Diagnostic Manager, and also Ignite for database performance and T-SQL Tuning AQ`1
  • Develop and document SQL coding guidelines for SQL Server 2005, SQL Server 2008 R2, and SQL Server 2012
  • Generate the weekly, monthly, and quarterly reports by using SQL Standard Report
  • Experience in monitoring and troubleshooting 24x7 operations and providing on-call services to clients
  • Develop and modify stored procedures, queries, views, indexes, and functions to handle business rules, history data, and audit analysis
  • Use SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools to populate data from various data sources, creating packages for different data loading operations for application
  • Deploy, Configure, and Maintain Compute on Azure Cloud
  • Troubleshoot Azure-related issues and engage internal teams and Users/Vendor for issue resolutions
  • Configure and support SSIS, SSRS for SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2017 and 2019
  • Use Azure Data Factory (ADF) for Data transformation and scale-out serverless Data integration
  • Overall assignment of roles and permissions within the SQL Server environment
  • Creating and managing Azure SQL resources with the Azure portal
  • Backup and restore Azure SQL Databases
  • Provisioning new SQL Databases on the cloud
  • Researching and setting the appropriate permissions for each ID in the databases
  • Use HDInsight to perform interactive queries at petabyte scales over structured or unstructured data
  • Ability to store data directly in the Azure storage and capture data that is collected incrementally from various sources using HDInsight HBase cluster
  • Troubleshooting NoSQL databases and custom application issues
  • Building Applications that extract critical insights from data using HDInsight
  • Assisting in the design, coding, testing, and implementation of high-volume transactional (OLTP) SQL database instances
  • Assisting developers with complex query tuning through schema refinement
  • Managing SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Rebuilding the indexes on regular intervals and placing the huge tables/non-clustered index on the separate file group to improve the performance
  • Ability to employ tools that proactively identify database performance issues and bottlenecks.

MS SQL Server DBA

STATE AUTO INSURANCE COMPANIES
Marietta, GA
01.2017 - 11.2019
  • Supporting both Financial and Insurance services for the Organization
  • I worked closely with the cyber security and privacy team to ensure compliance with all applicable privacy legislation, including GDPR, CCPA, PCI, HIPPA, auditing, risk assessment, and emergency adjustments
  • Designing, Implementing, and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults, and complex SQL statements
  • I have used PowerShell to install and configure SQL Server both pre- and post-build
  • Ensure database performance monitoring and tuning are regularly accomplished
  • Implement security policy design for current and new applications
  • Responsible for maintenance, Backup (using both Idera Sql SAFE and Native backup) & Recovery, testing, alerts (job failures, database & server capacity, etc.), and database integrity checks
  • Review logs, update database statistics, and index management
  • Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading
  • Security, auditing, configuring, documenting, enhancement & corrective changes, and emergency changes
  • Participate in DBA On-call monthly and document environments and processes where applicable
  • Managed environment and system configuration changes and application of problem management upon available skills and experiences
  • Management and Implementation of Resources planning, operations, and cooperation on the application of projects for continual environment and procedure improvement
  • Designed backup and restore strategies and Disaster Recovery solutions to prevent data loss
  • Database maintenance, Manipulation, and Cleanup
  • MS-SQL 2008/2012/2014/2016/2019 administration including installation, migration, configuration, upgrades, capacity planning, performance tuning, backup, and recovery
  • Configuring and setting up of Database Replication, Mirroring, and Log Shipping and AlwaysOn
  • Extensive Monitoring of SQL Server with Third Party Tools like IDERA, REDGATE, and SolarWinds
  • I have successfully engaged in various DR (Disaster Recover) efforts for clients
  • I have remediated various SQL Vulnerabilities in my environment to secure our SQL infrastructure
  • Comparing and deploying SQL Server database schemas quickly and accurately using the Redgate tool.

DBA

Puckett EMS
Austell, GA
03.2015 - 01.2017
  • I managed the Backup and Restore status on applicable servers
  • Performs Windows analysis, acquisition, installation, maintenance, and upgrade of server/computer hardware, operating systems, and software utilities; Manage the deployment, upgrades, and maintenance of, servers, hardware, software, desktop operating systems, and printers
  • Administering Windows Server 2003, 2008r2, 2012
  • Performing server/client upgrades on Windows Server 2008, 2008r2 2012, and 2014
  • SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
  • Responsible for Windows troubleshooting of all incoming incidents and performing service requests
  • Managed environment and system configuration changes and application of problem management upon available skills and experiences
  • Worked with a team of 14 professionals (6 remote and 8 onsite) and coordinated them to achieve project goals and objectives
  • Import and export data (Dev to QA, QA to Production)
  • Ensuring Database performance monitoring and tuning is regularly accomplished
  • Creating database design for new project support and enhancing previous databases for free bottlenecks
  • SQL Server database physical model creation and implementation (data type, indexing, table design)
  • Responsible for setting up and scheduling various tasks by creating maintenance plans
  • Monitored and maintained appropriate disk storage requirements for the database
  • Implemented Database mirroring and transactional replication.

Education

BACHELOR OF SCIENCE -

01.2010

Skills

  • Planning
  • Analytical and Critical Thinking
  • Self-Directed
  • Analytical
  • Team Management
  • Project Planning
  • Leadership
  • Remote Office Availability
  • Dependable and Responsible

Professional Job Experience

  • WELLSFARGO BANK, MS SQL Server DBA, 12/2019, Present, Austin, Tx
  • AGILITY LOGISTICS CORP., DBA, 03/2015, 01/2017, IRVINE, CA
  • STATE AUTO INSURANCE COMPANIES, MS SQL Server DBA, 01/2017, 11/2019, Marietta, GA

Certification

  • Microsoft Certified Azure Administrator Associate
  • Microsoft Certified Security, Compliance, and Identity Fundamental
  • Microsoft Certified: DP 900 & 300 in-view
  • Microsoft Certified Solutions Associate (MCSA)
  • Microsoft Certified Database Administrator (MCDBA)
  • Scrum Master Accredited Certification
  • Diploma in Computer Information Technology (CIT)

Areas Of Experience Strength

  • Performed Windows Software installs/upgrades, monitoring/alert configuration
  • Experience in troubleshooting performance issues (Query Optimization, I/O bottleneck, Blocking, Deadlock, Memory, CPU) to maintain uptime for SQL Server.
  • Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity on SQL Server 2008 R2, 2012, and SQL Server 2014.
  • Table partitioning, file, and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
  • Design and implement 2005, 2008 R2, 2012, and MS SQL 2014, 2016, and 2019 databases for mission-critical business.
  • Experienced in Disk and Server configuration through Raid for SQL Server.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, 2012, 2014, 2016, and 2019.
  • Experienced in working with end users to define, implement, and maintain their reporting requirements.
  • Experienced in the design, coding, testing, and implementation of high-volume transactional (OLTP) SQL database instances.
  • Managing SQL Azure Databases and Replicating data from onsite Databases to Cloud.
  • Collaborating with developers to ensure new environments meet requirements and conform to best practices.
  • Automating deployment of T-SQL, PowerShell, and respective scripts, system configurations, and security settings.
  • Experienced in the Deployment of SSIS packages and SSRS Reports.
  • Generate the weekly, monthly, and quarterly reports by using SQL Standard Report.
  • Create reports that run daily for jobs running in SQL Server Agent.
  • Experienced with monitoring and troubleshooting in 24x7 operations.
  • Strong experience in Database Administration in SQL Server.
  • Installation, configuration, and upgrade of Microsoft SQL Server 2008r2 and 2012,2014, 2016, 2019.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc.
  • Configuring and setting up Windows Server Failover Clustering Environment Strong.
  • Ability to detect and troubleshoot SQL Server-related CPU, memory, I/O, disk space, and other resource contention.
  • Strong knowledge of backups, restores, recovery models, DBCC commands, Clustering, Log Shipping, Transactional Replication.
  • Execution of scripts on db2 servers using dB Beaver application.

Core Experience

  • Data Migration
  • Disaster Recovery
  • Integration Services
  • Performance Tuning
  • Reporting Services
  • Database Upgrades Patches
  • Backup and Recovery
  • Database Security
  • High Availability Solutions
  • Database Monitoring
  • Data Manipulation
  • SQL Installation
  • DevOps/Agility
  • Automation
  • Azure SQL Cloud

Timeline

MS SQL Server DBA

WELLSFARGO BANK
12.2019 - Current

MS SQL Server DBA

STATE AUTO INSURANCE COMPANIES
01.2017 - 11.2019

DBA

Puckett EMS
03.2015 - 01.2017

BACHELOR OF SCIENCE -

Similar Profiles

CREATE PROFILE
MARY OYE