|
 |
 Database Administrationr
Core Job Description
|
| Small, uniform site |
|
50 computers, all running the same operating system, and 20 or fewer users. (A computer used only by the administrator does not qualify as a site.) |
|
| Complex site |
|
Up to 100 computers, running more than two different operating systems, and up to 100 users. |
|
| Large, complex site |
|
100 computers, potentially running more than one operating system, and more than 100 users. |
|
|
|
| Positions |
|
| Junior Database Administrator |
| Qualification |
 |
A degree or certificate in computer science or a related field. |
|
Previous experience in customer support, computer operations, database administration, or another related area. |
|
Motivated to advance in the profession. |
|
| Job skills and Responsibilities |
|
Acts as a front-line interface to users, accepting trouble reports and dispatching them to appropriate database administrators.
|
|
Assist on consulting or engineering projects or the administration of a systems facility
|
|
Performs routine tasks under the direct supervision of senior administrator. |
|
Strong interpersonal and communication skills, capable of explaining simple procedures in writing or verbally. |
|
Familiarity with most basic Database administration tools and processes, for example, installation of RDBMS software, Shutdown and startup of Database, add and remove user accounts, use backup utilities like exp/imp and maintain Database related files (init-parameter, Control-files, DB logfiles and trace files), create database based on the inputs provided by seniors database administrator.
|
|
Familiarity with networked/distributed computing environment concepts, for example, Configuration of network services or administer remote access service, add a database link.
|
|
Fundamental understanding of an operating system, for example, understands job control, soft and hard links or shortcuts, distinctions between the kernel and the user environment.
|
|
Familiar with an operating system and its commands/utilities at a user level; can edit files, issue commands, find users home directories, navigate through the file system, and use I/O redirection.
Is able to follow instructions well.
|
|
| Apply for this job position at careers@softenger.com |
| Intermediate Database Administrator |
| Qualification |
|
One to three years of Database administration experience. |
|
A degree in computer science or a related field. |
|
Motivated to advance in the profession. |
|
| Job skills and Responsibilities |
|
Strong interpersonal and communication skills, capable of training users in applications and RDBMS fundamentals and writing basic documentation.
|
|
High skill with most RDBMS commands/utilities.
|
|
Ability to write scripts in administrative language (Perl, shell). |
|
Programming experience in any applicable language. |
|
Has a solid understanding of RDBMS concepts, Tuning Pack, Diagnostics Pack. |
|
Handles Server Responsibilities include installation, updates/patches/upgrades, tuning, backups,security, user management and resource management |
|
Can create backup plans based on the customers need |
|
Creating installation scripts and base installation scripts to create the tables, indexes, stored procedures and initial data. This also includes planning for any upgrades and Controlling the database builds. |
|
Writes, tunes and modifies the stored procedures. Assist development team in tuning complex queries. |
|
Administers a small, uniform site alone or assists in the administration of a larger system. |
|
Independent problem-solving, self-direction. |
|
Works under the general supervision of a Senior Database administrator or computer systems manager. |
|
Carry out more complex tasks with some independence and discretion regarding how to carry out the tasks. |
|
| Apply for this job position at careers@softenger.com |
| Senior Database Administrator |
| Qualification |
|
Three to five years of Database administration experience. |
|
Should have had an exposure to working at a large site |
|
Has a programming background in any applicable language. |
|
| Job skills and Responsibilities |
|
Strong interpersonal and communication skills; capable of writing purchase justifications, training users in complex topics, making presentations to an internal audience, and interacting positively with upper management.
|
|
Comfortable with most aspects of Database administration; for example, installation and configuration of RDBMS, fundamentals of security and provide inputs for capacity planning.
|
|
Work with the security department, the development DBA and the product planners to determine how much access the application will need to the database. The production DBA is the gatekeeper of this access typically
|
|
Tunes the physical layer of the database. He may choose to do this by tuning the file structure and organization, scheduling index rebuilds, and any hardware-related decisions.
|
|
Performs regular random drills to test the backup plan and to test the integrity of the company's backups. Needless to say, a backup configuration should be as good as your ability to recovery from it. |
|
Maintain relationship with Oracle and act as first point of contact regarding technical and licensing issues. |
|
Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of all Oracle databases. |
|
Ability to write scripts in administrative language (Perl, shell). |
|
Receive general instructions for assignments from manager and work with independence and discretion regarding how to carry out tasks. |
|
Administers a complex site alone or assists in the administration of a larger site. |
|
Initiates some new responsibilities and helps to plan for the future of the site/network. |
|
Manage the work of junior database administrators, operators, engineers, or consultants. |
|
Evaluates and/or recommends purchases, has strong influence on purchasing process. |
|
Familiar with HA concepts, SAN Storages and should have had exposure to system integration with prevalent third part products. |
|
| Apply for this job position at careers@softenger.com |
| Database consultant |
|
| Qualification |
|
Strong interpersonal and communications skills, capable of writing proposals or papers, acting as a vendor liaison, making presentations to customers or client audiences or professional peers, and working closely with upper management
|
|
Ability to solve problems quickly and automate processes.
|
|
A solid understanding of RDBMS, understands paging and swapping, inter-process communications, devices and what device drivers do, filesystem concepts (inode, clustering, logical partitions), can use performance analysis to tune systems.
|
|
A solid understanding of networking/distributed computing environment concepts, understands principles of routing, client/server programming, the design of consistent network-wide filesystem layouts.
|
|
Leadership role in the architecture, implementation and support of an enterprise wide data warehouse and data marts. |
|
Handles the performance tuning at the query and index level. Can do this by running Profiler to determine where poorly running queries are and provide any assistance in rewriting the query. He must also look at execution plans to determine where indexes can be built to improve performance.
|
|
Ability to program in an administrative language (Tk, Perl, VBScript, a shell), to port C programs from one platform to another, and to write small C or C# programs.
|
|
Design and manage the computing infrastructure or manage the larger more complex consulting or engineering projects. Work under general direction from senior management
|
|
Manages a large, co |
|
|
|
|
|
