Homer McEwen
- Role
- Senior Sql Database Analyst at Veritiv
- Location
- Atlanta, GA, US
- LinkedIn followers
- 500 followers
Experience
Senior Sql Database Analyst
Mar 2021 — Present
Maintains integrity and performance for Microsoft SQL Server databases (versions 2008 – 2019) and Oracle RDBMS (version 19c Enterprise.) Managing database access, security, maintenance, backup/recovery and implements performance tuning enhancements. • Supports “Always On” for High Availability and Disaster Recovery environment • Implemented and created documentation for Installation of Oracle client 19c for 32 and 64-bit. • Creating tasks in AWS DMS for cloud migration loads and CDC to Amazon Redshift from Unify application in SQL Server. • Cohesity: Installation of agents to servers, upgrading software versions, backup and restoring. • Using SolarWinds’ Database Performance Analyzer (DPA) for database server visibility to performance and optimization/tuning advice. • Using JetBrains’s IDE Data Grip for queries, real-time analysis and schema navigation within Microsoft SQL Server and Amazon Redshift. • Generating CR tickets, tasks, and Incident within the SNOW ticketing system. • Automating tasks Database administration tasks with PowerShell. • Implemented SQL Server Replication technology in production environment. • Created daily report for all failed SQL Server agent jobs within 24hr period. • Providing on-call support and rotation within the DBA team. Key Achievements:*Migrating production data from on-premise to AWS cloud (RDS and Redshift) using DMS and enabling CDC replication.*Migrated Oracle on-premise to AWS PostgreSQL via AWS Schema Conversion Tool (SCT)*Experience with AWS services include: RDS, Amazon Redshift, DMS, S3, Lambda, CloudWatch IAM, Athena, EC2
Skills
- Active Directory
- Oracle Discoverer 10g
- T-Sql
- Transact-Sql (T-Sql)
- Troubleshooting
- Etl
- Informix
- Sharepoint
- Data Modeling
- Postgresql
- Unix Shell Scripting
- Sql
- Crm
- Problem Solving
- Windows Server
- Business Intelligence
- Os X
- Sql Server Reporting Services (Ssrs)
- Microsoft Sql Server
- Ssrs
- Customer Relationship Management (Crm)
- Crystal Reports
- Database Design
- People Skills
- Management
- Software Installation
- Oracle 9i
- Sdlc
- Performance Tuning
- Shell Scripting
- Data Warehousing
- Mac Os X
- Oracle
- Solaris
- Disaster Recovery
- Access
- Integration
- Databases
- Oracle Enterprise Manager
- Informix 4gl
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.