DB Administrator

Aileen Gregg

*** ** ********* **** ***’s Summit, MO 64081 913-***-****

************@*****.***

Aileen's LinkedIn Profile

Technical Skills

·SQL Server 2012/2014

·SQL Database 2008 R2 and 2014

·Windows Clustered Environment

·Experience in java scripts, VPN’s, Intranets, Firewalls, VNC’s, TCP/IP

·Knowledge in Remote Desktop session software's

·PowerShell scripting

·BI experience with SQL Integration Services (SSIS), SQL Reporting Services (SSRS), and SQL Server Analytic Services (SSAS)

·Diagnostic tools like RedGate and Idera.

·Performed DBA tasks in test and production environments for Data Recovery such as detach/attach databases, stop and restarting databases, dropping databases and running backup and restores

·Performed ETL with SQL Server Import/Export SQL Server

·SharePoint Server 2010 administrative and maintenance support

·Capable of performing a variety of roles to complete jobs in a timely manner.

·Self-starter and ability to work independently and meet deadlines and goals.

·Great oral and written skills.

·Excellent Customer Service skills

·Multilingual communication skills; English, Spanish and Italian

Experience

QA ANALYST COMPANION PROTECT JULY 2019– JULY 2019

·Develop test plans, test cases, test scripts and test reports on multiple projects of varying size.

·Perform testing on the software.

·Validate that user expectations are achieved during the testing process.

·Review user requirements documents to ensure that requirements are testable.

·Perform smoke tests during the deployment process

·Write-up bugs with repro steps

·Capture errors in software using LogRocket and Fidler

TECHNICAL SUPPORT LEAD/MANGER COMPANION PROTECT APRIL 2018 – JULY 2019

·Created the Technical Support Department

·Wrote the Technical Support Department Procedures

·Wrote the Technical Support Department Internal Training Guide

·Manage day-to-day operations of the Technical Support department and staff.

·Increased customer reviews from 2-star to 5-star customer satisfaction

·Decreased the time of resolution in the company’s metrics

·Decreased the number of bugs that were brought to the Developers finding and correcting issues

·Approve and coordinate time off for the Technical Support

·Submit electronic time cards to the Financial Department

·Manage direct reports effectively to drive continuous improvement through quality monitoring and coaching, addressing training needs and facilitating professional development.

·Train the Tech Support team on how to work in a team.

·Develop and implement initiatives and processes that improve client satisfaction and retention.

·Communicate across department lines to assist in issue resolution, account management, feature development, and product implementation.

·Create Stored Procedures for PowerApp applications to allow the team to run fixes.

·Write and execute queries to correct minor bugs

·Handle escalated client service and product-related escalations through resolution.

·Write repro steps and reproduced bugs found by the team.

·Work with HR to recruit and hire team members into the Technical Support Team.

·Attend Stand-up meetings and escalate higher issue bugs.

·Maintain bug board with updates and email clients with bug tickets

DATABASE ADMINISTRATOR COMPANION PROTECT SEPTEMBER 2017 – APRIL 2018

·Monitor performance of database systems resources and query throughput

·Optimize SQL Code as necessary

·Monitor and maintain database storage resources

·Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics

·SQL Server Installation, Upgrades, Migrations and Configuration

·Install database software service packs and cumulative updates as necessary

·Maintain database documentation as required

·Maintain and administer database security access

·Perform database backups and restores

·Troubleshoot and resolve database connectivity issues

·Follow Change Management processes to implement database configuration changes

·Follow Problem Management processes to troubleshoot and resolve recurring issues

·Proactively monitor and respond to MSSQL database Alerts.

·Import database from other shelter software into Connects database

·Report maintenance in Tableau

DATABASE ADMINISTRATOR KCPD APRIL 2017 – JUNE 2017

·Design, construct and maintain relational database systems, ensuring system scalability, security, performance, and reliability.

·Integrate new databases into existing infrastructure and refine system performance and functionality.

·Design and implement procedures, to include load-balancing processes, for backup, recovery, and security.

·Provide support and training for system analysis and programming personnel.

·Review project requests to identify database needs and estimate project time and work requirements.

·Develop database architectural strategies to complement department processes.

Create and enforce database development standards.

·Develop database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes.

·SQL performance analysis and tuning, log shipping and security, replication, SQL clustering, business continuity, scalability, reliability issues and written stored procedures

·Experience installing and configuring Microsoft SQL Server

·Optimizing stored procedures and indexes

·Working in a VM environment

·Deploying MS BI in Azure

DATABASE ADMINISTRATOR QC HOLDINGS, INC MAY 2016 – APRIL 2017

·Monitor and manage all database backups, logs, and journals.

·Responsible for installation, maintenance, and upgrades to database software; backups, restorations and/or recoveries of data as well as SQL Server migrations and configurations.

·Monitor relational databases to optimize database performance, resource use, and physical implementations of databases; addressing a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.

·Import and Export data from text files into MS SQL Server.

·Work with SQL Server running database queries and comparing output to conversion data store.

·Run and maintain indexing and log shipping in all databases.

PHARMACY PRODUCT SUPPORT SCRIPTPRO FEBRUARY 2015 – JANUARY 2016

·Work in Microsoft SQL Server 2008 – SSMS – Running TSQL queries against different database/warehouses to create specific reports and adhoc requests as needed.

·Perform regression tests by querying and analyzing database before and after snapshots of data from data warehouse in test environment prior to roll out to production.

·Helped Business Analysts to compare and convert data to existing query output to confirm all data in both sources matched and if different helped to determine what the issues were.

·Research and troubleshoot bugs and find workarounds and fixes for issues.

·Provide support for troubleshooting issues related to the database, data, reporting.

·Query database for drug barcode issues.

·Add and modify user access for remote access service

·Monitor and restore systems and backups

·Monitor, troubleshoot and update drivers for share printers in print management

·Verify system logs and events in event viewer to find root cause of problem

·Document and create troubleshooting steps for internal knowledge base

·Use of PC-Anywhere to perform remote installations

Education and Training

METROPOLITAN UNIVERSITY – UMET – SAN JUAN, PR MAY 1997

·Bachelor’s Degree in Computer Science and Information Systems Security

JOHNSON COUNTY COMMUNITY COLLEGE NOVEMBER 2016

·Continuing Education

·SQL Servers

·Advanced SQL

Certifications

·MCSE (Microsoft Certified System Engineer)

·Network +

·Microsoft Master Instructor

·Microsoft Office User Specialist

Contact this candidate