Tag: Database & Technology

Don't be afraid to look outside of your discipline. There is room to change and grow your career. Learn how Jonathan Gennick started as a programmer, became a database administrator, and ultimately decided to explore sales.

We’ve all been there. When the rubber meets the road, it seems like the database, operations and development teams are never quite in-sync. No matter how thoroughly executed, tested, documented and validated, something in the production environment is never quite the same as the lower environments – be it a hardware inconsistency, a code mismatch, or even the dreaded typoed command. To add insult to injury, code always seems to change between the time it leaves a developer’s laptop and when it is deployed to a mission-critical system.
Solving these issues is the primary motivator behind DevOps. Often misinterpreted as a buzzword endorsing development teams taking over platform and infrastructure roles, DevOps is all about development and operational modernization. Rather than operating as siloed, asynchronous teams as has been the norm for decades, DevOps represents a fundamental, holistic, organization-wide shift not only in processes and tools, but in people and culture.

As database environments evolve, so does the role of the database administrator (DBA). Take the movement to the cloud, for example. While it automates some tasks, like OS patching and backups, and frees up DBAs’ time, data governance, security and privacy become even more critical. And because businesses are demanding higher velocity at a lower risk, this ushers in a cultural change: DevOps, where developers and DBAs must collaborate more closely than before.

While migrating Oracle applications from physical to virtual OVM environments can be straightforward, it is important to take into consideration configuration issues regarding the interaction of the Operating System environment to the Virtual Environment. There are some gotchas that can complicate an installation despite assiduous attention to the installation and migration instructions. Figure 1 shows what a typical Oracle VM implementation may look like.

Over the coming weeks, SELECT and DBTA will be collaborating on a series of articles that have DevOps as their core theme. Like so many other buzz words in Information Technology today, there is no single agreed upon definition that has been set forth for DevOps, so the editors at SELECT decided that before we publish articles on DevOps, we should first describe what we view DevOps really means.

The concepts of Agile methodology and continuous delivery have become popular in software development, yet they are somewhat less mature among DBAs and database developers. Joyce Wells, editor at Database Trends and Applications (DBTA), spoke with Shay Shmeltzer, director of product management for Oracle Cloud Development Tools, to discuss how DBAs and SQL developers can take advantage of newer development approaches while also dealing with the unique challenges that exist in the world of database development.

Every now and again I come across the question: How can we lower latency and speed up data delivery? Irrespective of the target database, the desirable answer for the person responsible for implementing the data integration strategy may be to employ parallel processing. However, in many cases the decision to parallelize is the best answer only if better options have first been exhausted, and organizations don’t always explore those options.

Oracle introduced the autonomous database in the Oracle Cloud this past March of 2018. It is set up for data warehouse-type workloads and not yet for heavy transactional systems or even hybrid-type applications. As a Database Administrator (DBA), we know that most of our applications have hybrid to heavy transaction workloads, and of course a few data lakes or warehouses. Well, good news — on August 7, 2018, Oracle announced and made immediately available Oracle 18c autonomous database in the Oracle Cloud for transaction processing.

Check out this case study from Southern Utah University about how the university moved its entire infrastructure to the Cloud.

In an age where increased productivity is the gold standard, DBAs continuously seek new ways to become more efficient in their daily work. Amazon Web Services (AWS), an IOUG partner, recognizes this need and recently announced two new features to reduce and optimize vCPUs on the Amazon Relational Database Service (Amazon RDS) for Oracle Database.