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.
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.
The information that I have learned in Introduction to the Doctoral Business Administration (DBA) course will help me to prepare for both the DBA program and my career. The first concept I learned was the proper use of APA format. The second concepts were the impact of the required books in this course that helped challenge my current form of thinking. Thirdly, was that the Introduction to the DBA online was a new experience. I had never attended an online course only traditional classroom setting.
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"
Regular performance monitoring ensures that administrators always have up-to-date information about how their servers are operating. When administrators have performance data for their systems that cover several activities and loads, they can define a range of measurements that represent normal performance levels under typical operating conditions for each server. This baseline provides a reference point that makes it easier to spot problems when, or before they occur. In addition, when troubleshooting system problems, performance data gives information about the behavior of the various system resources at the time the problem occurs.
• 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.
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.
“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.
The first SQA role is Information Gatherer, who looks across many projects to provide management with the information it needs to make decisions among economic, marketing, legal, quality, and scheduling conflicts.
The database application design can be improved in a number of ways as described below:
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.
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 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.