Stephen Abernethy Email & Phone Number

Christchurch

In my role as Senior Database Administrator, I have managed large-scale PostgreSQL, SQL Server, and MySQL databases across a wide range of AWS services, from EC2 to Aurora. Projects and responsibilities include:Custom Release Tool Development: Designed a custom release tool for deploying changes in a multi-master PostgreSQL environment.CI/CD Integration: Worked closely with the CI/CD team to integrate Mercurial into the database stack and the TeamCity platform for testing changes in the deployment pipeline. Additionally, collaborated with Git for managing both DDL and DML changes.SQL Guidelines Maintenance: Maintained and updated database SQL guidelines and best practices for writing and deploying DDL and DML changes to PostgreSQL databases.Database Upgrades: Led a major version upgrade of over 100 PostgreSQL databases with minimal customer impact.Aurora MySQL Migration: Managed the migration and upgrade of Aurora MySQL instances from development to production.Performance Optimization: Managed and optimized database performance, ensuing data integrity, and created tools for detecting and tuning PostgreSQL.Parameter Tuning: Tuned parameters for both PostgreSQL and MySQL to improve performance.AWS Services Management: Extensive experience in setting up and managing AWS services such as RDS, Aurora, and Redshift.Cross-Functional Collaboration: Worked with cross-functional teams and stakeholders to ensure seamless application integration within the database stack.Project Management: Utilized Jira to manage projects and developed Kanban layouts and processes for the efficient flow of tickets in an Agile/Scrum environment.Customer Support: Ensured timely handling of customer support cases and provided accurate information to the 3LS team to deliver satisfactory solutions.Through these efforts, I have helped drive operational efficiency, supported business growth, and ensured the stability and performance of critical database systems at Verizon Connect.