Production DBAs take over after applications have been created, keeping the server running smoothly, backing it up, and planning for future capacity needs. Network administrators that want to become DBAs get their start by becoming the de facto DBA for backups, restores, and managing the server as an appliance. They decide what food to bring home and put in the chill chest, what should go into the fridge and what should go into the freezer.
Development DBAs focus on the creation process, working with programmers and architects to build solutions. Programmers that want to become DBAs usually get a head start on the development role because of their programming experience.
They end up doing the development DBA position by default when their team needs database work done. Database admins can cross those borders and know pieces of both sides, but generally, they fall into one of the two camps. Interestingly, the camp they pick tends to be driven by their past. Database theory is not necessarily a prerequisite for beginning database administration.
Instead, learn about the parts of database administration that call to you, things that you genuinely enjoy. If you like performance tuning, then read up about the Profiler and how indexes work. If you like designing tables, then read up about the different data warehouse application theories.
Great article Brent. I found it through another blog. Your wealth of advice on what to expect, best practices and related links is much appreciated. Please let me know. They have to know project management skills, team lead skills, and programming. Are you a production or a development dba… or a hybrid of both? Hope you have the time to answer my questions… and thank you very much!
I started in development and slowly moved over to production, but I still do some of both depending on the project. I would be really careful about generalizing who makes more. Hope that helps! I would like to become a Development DBA. So what sort of things should i do to become one of a DBA? Many database administrators opt to obtain certifications for different versions as different employers use varying releases.
To prepare for an Oracle exam, you can take a variety of online courses. DBAs need a variety of hard skills, including:. DBAs should also develop soft skills, such as:. Computer-system design companies employ the most DBAs, followed by other businesses and institutions that have large databases, such as universities and government departments.
These professionals also often work in telecommunications, banks, and the healthcare sector. DBAs typically work in an office setting. In some cases, they may need to perform work in a server room. They should be able to sit and work at a computer for extended periods of time. Most DBA positions are full time, and depending on the business, they may expect overtime hours. Companies may use contract DBAs for short periods to upgrade or migrate a database. Since a large number of duties are computer-based, many work remotely.
Some roles may require on-call availability for data emergencies. There are different paths you can pursue to become a DBA. For instance, if you have been working in the IT industry in another capacity, such as a computer or network administrator, you may have the opportunity to learn database administration skills.
In such a case, a company may employ you in a junior capacity based on your practical knowledge, after which you could pursue professional certification. We are looking for a junior database administrator to assist our database management team. Duties will include installing and configuring new database servers, monitoring system health and security, managing user accounts and monitoring and troubleshooting database performance. The individual will receive on-the-job training and will receive more responsibilities with time, which will include tasks like database design and implementation.
We prefer candidates with an Oracle 12c certification but will consider other applicants. As a result, they have a large scope of responsibilities that include the design, installation and maintenance of hardware and software systems. Network administrator : Network administrators ensure that the networks of companies and institutions are always functional. They install, configure and manage all network-related software and hardware systems and implement failover solutions to prevent network downtime in the event of system failure.
Find jobs. Company reviews. Globalization and e-business are driving many organizations to implement no-downtime, around-the-clock systems.
To manage in such an environment, the DBA must ensure data availability using non-disruptive administration tactics. Data, once stored in a database, is not static. The data may need to move from one database to another, from the DBMS into an external data set, or from the transaction processing system into the data warehouse. The DBA is responsible for efficiently and accurately moving data from place to place as dictated by organizational needs.
The DBA must implement an appropriate database backup and recovery strategy for each database file based on data volatility and application availability requirements. Without a backup and recovery strategy, system and user errors could render a database inoperable and useless.
Furthermore, the backup strategy must be developed with recovery time objectives in mind, so that data is not unavailable for long periods when problems inevitably occur. This is probably one of the — if not the absolute — most important database administration task. Part II of this post is coming soon and will cover the next 11 job responsibilities of DBAs to round out the list of Craig Mullins.
Includes step-by-step instructions, screenshots, and software script. Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox.
You can unsubscribe at any time. Where do you want to take your career? Explore exciting opportunities to join our team. Contact Us Questions?
0コメント