1.0 DBA Roles:
DBA plays important role in every organization, they are the core part of Technology Team, based on Organization DBA roles vary but majority of their role are very critical due to impact, Architect, Quality Analyst, System Analyst and Developers everyone has to work with DBA during different development life cycles. DBA skills are hard to find majority of organization prefer DBA which are certified, and certification for DBA are hard to achieve.
Organization Expectation from DBA:
- DBA should have good understanding of Database and its tools.
- Knowledge and good understanding of SQL.
- Database Back Up and Recovery.
- Database Utilization Management.
- Database Performance Tuning and Monitoring.
- Database Security Management.
Above are just high level skills set which is expected from all DBA’s, and majority of DBA roles are derived based on these skillset, below are few important roles performed by DBA.
Database Maintenance/Design: -
This is the core role of every DBA, the word looks simple but it involved lot of things as DBA admin, starting from installation to patching and scheduling all the activities will be performed by DBA. Apart from these they also have to evaluate new features in Database, manage operating system and database changes.
Database Backup/Restore: -
Organization never wants loose there information and they depend on DBA’s for this, DBA another important role is to Backup and Restore the data. Majority of the time scheduler like features used here to take Backup of database. Space management is also important at this step and archiving like process also performed by DBA. Restore process is not often used but this is one of important part of DBA role.
Database Security Maintenance: -
Data is very important and to keep it secure is more important, DBA has to make sure that database has enough security, they need to keep track of all database access activity and denied permission to unauthorized users. This also involves creation of new User roles, application role and maintenance of these roles.
Database Support: -
Database is hart of every application and to keep it running 24*7 monitoring is required, DBA team has to support this Monitoring and handle issues occurred during this time, Majority of organization divide DBA team in to 3-4 teams to support different application, all the details with timing are shared with application and whenever required they reach out to available DBA for that time frame.
Database Monitoring: -
DBA has to monitor Database for several reasons like production traffic, performance, volume, traceability and security. Production environment need continues second eye of pair to track Active Sessions, DBA has to keep track of all these active session using tools like 12C.
Data governance (DG) is an emerging field within the healthcare industry that has coincided with the data explosion. A definitive definition of DG varies among the bodies of authority and education. Despite the differences between the nuances of the various definitions, they all contain the same core elements. Taking the common themes of the definitions into account, the definition of DG for St. Rita’s Hospital is: the system that establishes data asset management as an enterprise endeavor. As such, policies and procedures shall be put forth that protect, manage, and monitor the asset so that the data can be utilized and protected to benefit the organization in an optimized manner.
While it is obvious that most employees are against electronic monitoring, the use of electronic monitoring contributes to increased stress levels in employees. While the advantages derived from electronic monitoring far outweigh the disadvantages. Through the use of employee monitoring, companies can save money in overall operations cost by weeding out those employees who don't pull their weight, and cut down on employee theft. By monitoring employees, it is possible to measure their performance and see if they are meeting standards.
System performance is one of the most critical issues faced by companies dealing with vast amounts of data. Companies use database systems and their applications to store, retrieve and handle this data.
DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
Normalization, Integrity and Security are the important role for a DBA, Normalization helps to avoid data redundancy by reviewing data base structure at certain level. It helps to build an effective data model. Data Integrity provide some level of assurance over the information getting store and retrieved from database, DBA has to understand all DBMS features use them correctly for Data Integrity. Data Security is toughest part for DBA, auditing and multiple level security can protect data but none of them provide complete security, security can also be managed by encrypting and masking the organization data.
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
Probably the most common thought of career position within the information technology arena that garners the most OS-centric job description specifics is that of the system administrator or network administrator. A system administrator is a person employed to maintain and operate a computer system or network for a company or other organization. The duties of a system administrator are wide-ranging, and vary widely from one organization to another. Sysadmins are usually charged with installing, supporting, and maintaining servers or other computer systems, and planning for and responding to service outages and other problems. Other duties may include scripting or light programming, project management for systems-related projects, supervising or training computer operators, and being the equivalent of a handyman for computer problems beyond the knowledge of technical support staff.
“An Executive Dashboard is a visual representation, that gives executive a quick and easy way to view their company’s performance in real time”. Most of the organizations prefer dashboards for the great visibility and insights to know exactly what’s going on in business. One famous quotes “if u can’t measure it, you can’t improve it”. Dashboard helps in improving the performance of the any organization and leads to success. Tableau is the visual of analyzing the solution from the data which it allows the people to explore and analyze the data by the simple form of drag-and- drop operations. People at any skill level can understand and use to analyze the data. It is the one of the self-service and the business intelligence applications.
• Microsoft Access: I am conversant with Microsoft Access and have recently completed an Intermediate course. I can create databases; modify databases to include new fields, and complete queries and reports. • Microsoft Project: I use Microsoft Project and ARC Financial Management on a regular basis at an advanced level. • In have used Customer Record Manager (CRM ACT) and Sales Force Automation (CRM) in the past. • High level of competency in relation to writing Google AdWords and using Google Analytics to managing the performance of your individual AD written in Google search words.
The DBMS has a function that can be differentiate from the information retrieval system. The DBMS have the ability to store, update and retrieve the data. This is the main function of the DBMS because the database can be used if there is any record is being stored into the database. The record need to be retrieve first, then it can be change by the database administrator as it will be the record has been updated. The DBMS will protect the structure of the data structure.
A database management system in the main software tool of the database management approach because it controls the creation, maintenance, and use of the database of an organization and its users. The three major functions of a database management system are first to create new database and database application. Second to maintain the quality of the data in an organized database. And last to use the database of an organization to provide the information that its end users need. An example of a database management approach in a banking information system. Note how the savings, checking and installment loan programs use a database management system to share a customer database. Note also that the database management system allows a user to make direct, ad hoc interrogations of the database without using application programs.
The Administration Department The administration department also known as the services department provides important services for other departments within a business to help them function properly. Different companies have different uses for their administration department, like in a small business an administration department will be used to manage and take responsibility for departments like human resources or finance. In larger companies they require more departments such as marketing thus giving administration more responsibility over more departments in a business. Some examples of the work that the administration department are: * Clerical work, including filing and keeping records * Typing and other various secretarial duties * Organising meetings * Photocopying * Designing and producing forms * Reception and managing telephone calls * Dealing with queries * Collecting and distributing mail * Managing office resources The services which administration provide usually depends on the size of the business.
An administrative assistant that may work in a business type office will generally deal with the administrative assistant providing secretarial support to a staff of eight as well as providing assistance to the Executive Unit staff of five to six people. The administrative assistant will perform various duties that may include maintaining office information systems, legal files and forms, helping in preparing reports; updating legal materials in the agency or business' office library, recording and distributing incoming and outgoing mail, a ensuring that expenses related to incoming and/or outgoing mail are properly submitted to the fiscal department (http://www.careercruising.com/jobdetails_print.asp?LoginID=647926865110602&OccName=Administrative+Assistant, March 25 2004) The career of Administrative Assistance is a jam-packed employment field and is a position that is in demand.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.