Database Administrator Sql Server
Resume:
Gerald M. Manioci
North Bend, WA 425-***-**** *************@**********.*** LinkedIn Profile
Senior Database Administrator with 15+ years of experience in high-impact production operations, who brings expertise in providing creative solutions that solve operational challenges and reduces costs.
ACCOMPLISHMENTS
Saved approximately $2,500,000 on consulting fees during my tenure at Expedia in 2015.
During my work history, I have brought a track record of success in reducing unplanned downtime and performance degradation through database intervention.
During my tenure at Expedia and Zillow, I designed and implemented a custom monitoring and performance data collection platform to facilitate troubleshooting and reduce required administrator time.
Automated replacing EC2 nodes in high-availability clusters and performed typical administrative tasks to save time at Zillow.
Consistently championed the onboarding of NoSQL technology alternatives.
CORE COMPETENCIES
Microsoft SQL Server T-SQL Powershell C# AWS MongoDB ScyllaDB Performance Tuning Clustering Databases Data Administration Fiber channel SAN Data Warehousing Disaster Recovery Clustering Replication Database design Servers SSIS Linux Data Modeling Coaching & Mentoring Creative Problem Solving Cross- Functional Collaboration Executive Communication Research New Technologies Automation
LEADERSHIP PRINCIPLES
Invent and Simplify Ownership Deliver Results Deep Dive Have a Backbone; Disagree and Commit
RECOMMENDATIONS
"I count Jerry among the most talented and technically competent DBAs I've ever worked with. Jerry's command of one of the busiest and most complex database environments in the eCommerce space was no insignificant achievement. Jerry also served as a tremendously valuable technical resource for the NOC and other operations teams seeking to understand the database environment better. I would genuinely welcome any opportunity to work with Jerry again.”Chidi Alams Technology Leader Expedia, Inc. Colleague
...An expert in engineering, fine-tuning, and disaster recovery is but a few weapons in Jerry's SQL arsenal. Success is a requirement in today's e-commerce business, and it's been my pleasure to witness Jerry's
Keith Coulthurst Manager, IT Operations and Global Operation Center Expedia, Inc. Colleague
PROFESSIONAL WORK EXPERIENCE
Database Administrator Cognizant, Mesa, AZ (remote from North Bend, WA) Jan 2023 – Sep 2023
Database Code Management- 95% Research New Technologies- 5%
Reviewed and deployed database changes, maintained tools to document and track changes, and ensured the version of the database and their changes were correct for where they were deployed to Azure SQL Servers.
Studied the latest version of the SQL Server product and its relevance to the environments, worked with MongoDB to test archiving solutions and remove pressure from busy databases.
Senior Database Administrator Seattle Children’ s Hospital Seattle, WA Jan 2022 – Sep 2022
End-of-Life Appliance Management- 70% Code Deployment- 15% Performance Tuning- 15%
Worked with legacy on-premise IBM Netezza appliances to maintain production and disaster recovery operations while preparing for workload shift to the cloud.
Ticket processing and assisting developers with keeping the database objects current.
Identifying performance bottlenecks and making recommendations on database changes that could be made to help ensure SLAs were achieved.
Principal Database Administrator Zillow Group, Seattle, WA Apr 2018 – Jan 2022
Automation- 70% Performance Tuning- 10% Best Practices-10% New Platform Implementation-10%
Designing and building tools to perform database administrator functions and save time modifying or replacing AWS database nodes.
Reacting to alerts, participating in periodic on-call rotations, working with Developers on database code changes for implementing new features and improving performance in response to traffic demands.
Modified existing maintenance and built new functionality to protect data and ensure industry best practices were followed to prevent data loss and address corruption.
Set up a new VPC to deploy and maintain production database operations on a new NoSQL platform on ScyllaDB. Worked extensively with vendor on configurations for a successful outcome.
Principal Database Administrator Expedia, Inc, Bellevue, WA Jan 2011 – Apr 2018
Monitoring Development- 50% Performance Tuning- 30% New Platform Implementation-20%
Built tools to fill in gaps with monitoring and performance data collection to assist in rapid diagnosis of performance bottlenecks.
Worked with Developers, vendors and storage engineers to address short-term and longer-term issues in production environments. Scaled infrastructure as necessary while balancing spend.
Set up multiple highly available MongoDB clusters to handle change database workloads. Trained staff in implementation and support of new platform.
Database Administrator Full Tilt Poker Dublin, Ireland Dec 2009 – Jan 2011
Database Code Management- 80% Performance Tuning- 20%
Processed tickets to make changes to database code in response to changing business needs. Participated in periodic on-call rotations.
Identified and proposed changes to existing database structures to solve extreme growth issues.
EDUCATION AND PROFESSIONAL DEVELOPMENT
Master of Business Administration, Technology Management Nov 1999 – Jan 2001
University of Phoenix, Phoenix, AZ
Bachelor of Science, Packaging Science Apr 1994 – Nov 1996
Rochester Institute of Technology, Rochester, NY
MCSD – Microsoft Certified Solutions Developer June 2004
Database fundamentals, .Net topics and solutions architecture.
MongoDB March 2023
M101P: MongoDB for Developers (Version 3.2) M201: MongoDB Performance
M320: MongoDB Data Modeling
PUBLICATIONS
An Orders of Magnitude Problem (T-SQL Tuning)
https://www.sqlservercentral.com/articles/an-orders-of-magnitude-problem-t-sql-tuning
AWS re:invent 2017: Migrating Microsoft SQL Server Databases to AWS – Best Practices (WIN301 SQL - PASS Summit)
https://www.youtube.com/watch?v=9hUVcH48eLg
Contact this candidate