|Reference # : ||17-04680
||Title : ||Database Administrator 3|
|Position Type : ||Contract|
|Experience Level : ||6 Years
||Start Date / End Date : ||10/23/2017 / 10/27/2018
| Description |
|Database Administrator 3
Note: See Additional Position Information document for specialized position requirements.
Position Overview: This position administers, tests, and implements computer databases, applying knowledge of database management systems. Coordinates changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases. The Database Administrator (DBA) may also perform enterprise level database administration using the Oracle tool suite to install databases, implement scripting, tuning, backups, monitoring, failover and data protection, recovery, security and integrity.
Education, Experience, Job Training:
NOTE: Education and Experience requirements are specific to this CWSD/position title, for use exclusively within BPA?s IT organization, and are not transferable to other BPA organizations. Managers may require more education and/or experience (see API document) for specific positions.
? Bachelor of Science in Information/Computer Technology or a related technical discipline is preferred.
? Level 3 requires 10+ years combination of education, certifications and/or work experience in Computer/ Information Technology or directly-related field. Applicable certifications (as defined in the API) will count towards 1 year of experience and each applicable college degree will count towards 2 years of experience.
? Experience working in a large production environment.
Typical Tasks may include but are not limited to:
? Test programs or databases, correct errors and make necessary modifications.
? Modify existing databases and database management systems or direct programmers and analysts to make changes.
? Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
? Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
? Train users and answer questions.
? Specify users and user access levels for each segment of database.
? Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
? Review project requests describing database user needs to estimate time and cost required to accomplish project.
? Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
? Conduct performance tuning for servers, databases, and SQL
? Provide recommendations for process improvements and technical solutions that can be integrated into existing environments.
? Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine).
? Write and debug PowerShell, VB and/or PERL scripts to automate DBA processes such as monitoring/alarming on volume growth, performance bottlenecks, batch scheduling, and connectivity failures.
? Utilize Windows based tools and knowledge of Windows internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Windows.
? Recommend SAN-based storage configuration, such as disk layout, to improve performance.
? Provide developer and end-user support for databases including maintaining existing SQL and PL/SQL code and troubleshooting database interoperability problems
? Perform routine database management from command line without the use of GUI Tools.
? Install and maintain appropriate database fail-over solutions
? Ability to use Graphical User Interface (GUI) tools for efficiency when appropriate and available
? Ability to install, configure, and monitor server infrastructure.
? Ability to utilize Perl modules Win32, DBI, & DBD and customize Perl module development.
? Ability to connect, navigate, troubleshoot and script in both the Windows and UNIX environments in a secure manner.
? Ability to navigate and troubleshoot Oracle issues on legacy servers.
? Ability to debug and extend functionality of current batch/automated processes.
? Work as part of a project team to coordinate database development and determine project scope and limitations.
Typical Work Activities may include any of the following:
? Interacting with Computers-Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
? Analyzing Data or Information ? Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
? Making Decisions and Solving Problems-Analyzing information and evaluating results to choose the best solution and solve problems.
? Getting Information-Observing, receiving, and otherwise obtaining information from all relevant sources.
? Processing Information -Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
? Documenting/Recording Information-Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.
? Organizing, Planning, and Prioritizing Work-Developing specific goals and plans to prioritize, organize, and accomplish work.
? Provide Consultation and Advice to Others ? Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
? Thinking Creatively-Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
Knowledge ? The specific position may require any or all of the following:
? Computers and Electronics ? Knowledge of electronic equipment and computer hardware and software, including applications and programming. Requires an understanding of the IT working environment sufficient to explain technical issues to a disparate range of technical and non-technical clients.
? Customer and Personal Service ? Knowledge of principles and processes for providing customer service. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
? Mathematics? Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
Skills - The specific position may require any or all of the following:
? Complex Problem Solving ? Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
? Critical Thinking ? Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
? Judgment and Decision Making ? Considering the relative costs and benefits of potential actions to choose the most appropriate one.
? Operations Analysis ? Analyzing needs and product requirements to create a design.
? Systems Analysis ? Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
? Monitoring ? Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
Abilities ? The specific position may require any or all of the following:
? Oral/Written Comprehension & Expression ? Ability to listen to, read and understand information and ideas presented through spoken words and sentences and in writing. Ability to communicate information and ideas in speaking or in writing so others will understand.
? Deductive Reasoning ? Ability to apply general rules to specific problems to produce answers that make sense.
? Problem Sensitivity ? Ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
? Inductive Reasoning ? Ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
? Information Ordering ? Ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
? Category Flexibility ? Ability to generate or use different sets of rules for combining or grouping things in different ways.
Desired Work Styles:
? Attention to Detail: Being careful about detail and thorough in completing work tasks.
? Analytical Thinking ? Analyzing information and using logic to address work-related issues and problems.
? Initiative: Demonstrated willingness to take on responsibilities and challenges
? Dependability: Being reliable, responsible, dependable, and fulfils obligations..
? Adaptability/Flexibility: Being open to change (positive or negative) & to considerable variety in the workplace.
? Persistence: Demonstrates persistence in the face of obstacles
? Achievement/Effort: Establishes & maintains personally challenging achievement goals and exerts effort toward mastering tasks.
? Stress Tolerance ? Accepting criticism and dealing calmly and effectively with high stress situations.
? Integrity: Being honest and ethical.
? Innovation ? Creativity and alternative thinking to develop new ideas for and answers to work-related problems.