Showing posts with label DBA. Show all posts
Showing posts with label DBA. Show all posts
Saturday, 19 March 2016
Thursday, 22 October 2015
Job Posting - Database Administrator
Job Title
Database Administrator
Positions Available
2
Company Profile
Education
Bachelor's degree in Computer Science or other
related fields required.
An advanced degree preferred.
Relevant Certification in Database Administration
preferred.
Job Requirements
Hands on Oracle database administrator with 3
years of experience installing, configuring, managing and troubleshooting
oracle 9i, 10g, and 11g database software.
Requires extensive experience with Oracle RAC and
multi-application environments. Requires solid understanding of server capacity
planning, performance analysis and tuning, and user management. Must work
closely with the server and storage engineers to design and implement
high-performance and highly available environments.
Must work closely with applications in order to
understand their specific requirements and guide them through the application
lifecycle.
Applicant must have Architect skills – (i.e.,
define architecture: concepts, design, build, detailed documentation before,
during and after task effort).
Applicant must be able to understand the various
technology areas affected and work with those technical SMEs in building
robust, stable systems
Applicant must have extensive knowledge of and
experience with the span of Oracle products (i.e., Oracle Data Base, OID, Grid
Control, Spatial, Partitioning, Application Server, and Data Guard).
Applicant provides basic technical writing to
describe daily operations (template provided) and security controls.
Applicant will be working in a Team environment
and must have excellent communication skills, both written and verbal.
Require experience working with servers
(Linux/Unix and Windows 2008).
Expert knowledge in shell scripting required.
Ability and willingness to learn new systems
required.
Required Documents
Resume
Cover Letter
Work Location
Lagos, Nigeria
Work Schedule
Full-Time
Posting Date
22-10-2015
Interested applicants should submit resume to
kenny_csc@yahoo.com
Wednesday, 14 October 2015
Who is a Database Administrator
This should actually be my first post... the reason I started the blog is to create a repository for solutions to issues I have encountered and resolved and also deem appropriate (legally/morally) for the public domain, hence the lack of an introductory post. So, this post will serve as an advise/reference for new IT professionals that are trying to make a choice about which field to specialize in and the ones that the Database Administration function has fallen upon.
Without any further ado let me introduce you to what we Database Administrators do and why big organisations need us regardless of their line of business.
In simple terms, a Database Administrator is responsible for performance, integrity, availability and security of business data of organisations. Database Administrator roles vary depending on the type of database, the processes they administer and the capabilities of the database management system (DBMS) in use. Every organisation has a corporate/core database which all or most of their applications interface with. Various industries have different names for this central database which acts as the heart of their business systems. In addition to this central database, ancillary applications usually have their own self contained databases which it's application specific data are stored.
Typical day-to-day duties of Database Administrators popularly called DBAs include;
- Implementing, supporting and managing the corporate database.
- Ensuring optimum performance of the database.
- Designing and configuring database objects such as tables, views, indexes functions and procedures.
- Ensuring data integrity, availability and security.
- Deployment and monitoring database servers.
- Designing and implementing backup and data archiving solutions.
- Planing and implementing solutions for disaster recovery.
- Analyse and report on corporate data to help shape business decisions.
- Produce entity relationship & data flow diagrams and database normalization schemata.
Although there are no hard and fast rules on the educational roadmap to becoming a DBA, typically a DBA should have a bachelor's degree in Computer Science or other related disciplines. Most employers favour those with professional certifications of some sorts from leading DBMS like Oracle Database, Microsoft SQL Server, IBM DB2, Sybase or MySQL. For senior DBAs it is desirable to have an MBA in Management Information Systems, MSc in Database Management/Computer Systems.
As a DBA, you have to continually improve on your skills and expand your areas of expertise because it is practically impossible to learn everything in this space. Let me put my premise in perspective - Oracle 11g Database has over 358 system parameters with each one having 4 properties that could have at least 2 possible values. I'm not going to leave you to do the math because you might not get my point. This implies that there are over (358^4)^2 different configuration options for an Oracle 11g database. I don't have a calculator capable of computing the actual value, but I know it is a very large number - ultimately no DBA knows it all.
Hope this helps!
Kehinde.
 |
| Typical DBA's desk. |
Without any further ado let me introduce you to what we Database Administrators do and why big organisations need us regardless of their line of business.
In simple terms, a Database Administrator is responsible for performance, integrity, availability and security of business data of organisations. Database Administrator roles vary depending on the type of database, the processes they administer and the capabilities of the database management system (DBMS) in use. Every organisation has a corporate/core database which all or most of their applications interface with. Various industries have different names for this central database which acts as the heart of their business systems. In addition to this central database, ancillary applications usually have their own self contained databases which it's application specific data are stored.
Typical day-to-day duties of Database Administrators popularly called DBAs include;
- Implementing, supporting and managing the corporate database.
- Ensuring optimum performance of the database.
- Designing and configuring database objects such as tables, views, indexes functions and procedures.
- Ensuring data integrity, availability and security.
- Deployment and monitoring database servers.
- Designing and implementing backup and data archiving solutions.
- Planing and implementing solutions for disaster recovery.
- Analyse and report on corporate data to help shape business decisions.
- Produce entity relationship & data flow diagrams and database normalization schemata.
Although there are no hard and fast rules on the educational roadmap to becoming a DBA, typically a DBA should have a bachelor's degree in Computer Science or other related disciplines. Most employers favour those with professional certifications of some sorts from leading DBMS like Oracle Database, Microsoft SQL Server, IBM DB2, Sybase or MySQL. For senior DBAs it is desirable to have an MBA in Management Information Systems, MSc in Database Management/Computer Systems.
As a DBA, you have to continually improve on your skills and expand your areas of expertise because it is practically impossible to learn everything in this space. Let me put my premise in perspective - Oracle 11g Database has over 358 system parameters with each one having 4 properties that could have at least 2 possible values. I'm not going to leave you to do the math because you might not get my point. This implies that there are over (358^4)^2 different configuration options for an Oracle 11g database. I don't have a calculator capable of computing the actual value, but I know it is a very large number - ultimately no DBA knows it all.
Hope this helps!
Kehinde.
Subscribe to:
Posts (Atom)