Andrea Stewart
Colorado Springs,CO
Summary
Adept Database Administrator and Senior Technical Support Analyst with a proven track record at FedEx, where I enhanced database performance and system reliability. Skilled in Golden Gate, Dataguard, and Linux, my strategic capacity planning and exceptional problem-solving abilities ensured optimal operational efficiency and data security.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Database Administrator
FedEx
Colorado Springs, CO
02.2008 - 01.2025
- Created new tablespaces for applications to store their data in the database.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Performed daily backups of the databases using RMAN utility.
- Monitored performance of queries and tuned them as needed using Explain Plan tool.
- Implemented data replication between two different databases using DataGuard feature of Oracle Database Server.
- Implemented data replication between two different databases using Golden Gate.
- Tested application code changes before deploying them into production environment.
- Migrated existing databases from one platform to
- onanother with minimal downtime.
- Resolved customer queries related to database issues promptly and accurately.
- Ensured that all the stored procedures are optimized for better performance of the system.
- Provided technical support for developers by creating views and indexes as per their requirements.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Participated in capacity planning initiatives to forecast future resource needs based on current trends.
- Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
- Monitored database performance and implemented changes to improve response times.
- Conducted performance tuning of database systems to ensure optimal efficiency.
- Managed user access and privileges to secure sensitive data effectively.
- Installed, configured, and maintained Oracle 19c, 11g and 12c databases on Linux servers.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
Senior Technical Support Analyst
FedEx
Colorado Springs, CO
02.2024 - 02.2024
- Provided technical support for complex hardware and software problems.
- Analyzed system logs and identified potential issues.
- Performed root cause analysis on IT incidents to identify solutions.
- Monitored the health of all servers in the environment using various tools, such as Veritas Cluster Server (VCS) managed cluster.
- 1st and 2nd level support on SUN, HP-UX, AIX, UNIX, and Linux servers.
- Oversees and coordinates day-to-day scheduling for the 24x7 network and the enterprise computer systems.
Education
Master of Science - Computer And Information Systems
Regis University
Denver, CO05-2009
Bachelor of Science - Computer And Information Sciences
Regis University
Denver, CO05-1997
Skills
- Writing queries
- Golden Gate
- Dataguard
- Information systems management
- Database analysis
- Linux operating system
- Capacity planning
- Database backup
Certification
Certifications – August 30, 2004 earned the Solaris 9 UNIX System Administration certification.
September 3, 2002 earned the Solaris 8 Sun UNIX System Administration certification.
Timeline
Senior Technical Support Analyst
FedEx
02.2024 - 02.2024
Database Administrator
FedEx
02.2008 - 01.2025
Master of Science - Computer And Information Systems
Regis University
Bachelor of Science - Computer And Information Sciences
Regis University