As a DBA Manager, efficiency and skill are top of mind when managing your team. DBAs come in all shapes and sizes and while there are myriad skills and abilities that span across the board, sometimes just a small trick, a new planning technique, or a revised implementation process can make a world of difference in the productivity of your employees.
Our Datavail DBAs work with hundreds of companies across the world and, as such, we’ve picked up a lot of skills, technical aptitudes, and platform shortcuts of which many DBAs are unaware. To help you give your team a little extra fire in their database engines, we’ve put our heads together to give you this 2-part series featuring webinars by Datavail’s Vice President and Practice Leader of Development, Tuning and Automation, Chuck Ezell. Part I covers the top four webinars that will make your DBAs smarter, and Part II covers the top four webinars that will make your DBAs more effective.
Simply share this post with your DBAs or click the links to watch the webinars yourself; you might be surprised at what you learn. And if you find yourself struggling with DBA staffing or searching for after hours, BI analytics, or applications support, contact us to discuss how our pool of more than 600 DBAs can supplement your existing team for performance improvement.
Webinar #1: A New Framework for Solving Database Performance Issues
If your organization relies on data, optimizing the performance of your database can increase your earnings and savings. Many factors large and small can affect performance, so fine-tuning your database is essential. Vice President and Practice Leader, Development, Tuning and Automation for Datavail, Chuck Ezell, sheds light on his 5S approach that helps you organize performance tuning so it can be measured, documented, affected, and improved.
Webinar #2: Tuning ETLs for Better BI
There are two main goals for tuning your ETLs for better performance: enhancing speed and increasing consistency. In this webinar, Datavail’s senior applications tuner, Chuck Ezell will discuss some techniques on how to find bottlenecks in your BI ETL jobs and how to tune slow SQL statements to improve the speed of nightly ETL jobs.
Webinar #3: Changing Your Approach, From Reactive to Proactive
Do you know every aspect of your Oracle database? From each parameter, to the database health, down to the data block level? Regular health checks are the best approach to ensure you are always prepared for the scenarios you might be reacting to on a regular basis today. This presentation will outline the tools to use to transition from defense to offense by working and planning proactively.
Webinar #4: All the Leaves Aren’t Brown: Many Ways to Profile Your Application Code
What are the right tools to use in the various circumstances you might face when profiling on both the server and client side? In this webinar, we’ll show you how profile your application code and see how the features compare from one profiler to the next.
Datavail, which acquired Art of BI, is the largest provider of data and database administration (DBA) services in North America with more than 600 DBAs, analysts, developers and consultants. We offer 24×7 managed services and project consulting in database administration, BI/Analytics, data warehousing, and enterprise performance management. Datavail’s expert consulting team specializes in integrations, implementations, and upgrades for applications across the Oracle stack, including Hyperion, OBIEE, OBA, GoldenGate, Weblogic and more. Founded in 2007, Datavail is based in Broomfield, Colo.
The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.
Which RAID should you use with SQL Server? Learn the differences between RAID 0, RAID 1, RAID 5, and RAID 10, along with best practices.
Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.