The Database Administrator II (DBA II) is directly responsible for the performance, integrity and security of multiple databases. The DBA II will be involved in the planning and development of new databases as well as troubleshooting issues on existing databases on behalf of users.

In this role, the DBA II will be primarily responsible for supporting the Oracle database environment with extended responsibilities for PostgreSQL.  The DBA II will take ownership of all aspects of managing a database environment.

Required Skills

Database Management – Knowledge of the principles, procedures, and tools of data management, such as modeling techniques, data backup, data recovery, data dictionaries, data warehousing, data mining, data disposal, and data standardization processes.

• Install, configure, upgrade, administer, monitor and maintain database.
• Develop and design database strategies for system monitoring, improving database performance and capacity 
• Use database analysis skills to optimize applications
• Support backup and recovery activities
• Performance tuning for Oracle and PostgreSQL environments
• Capacity planning
• Documentation of physical data model

SUPPLEMENTAL DUTIES & RESPONSIBILITIES

• Pursues training and development opportunities; strives to continuously build knowledge and skills
• Assist personnel in other RTS departments to resolve technical and/or application issues
• Occasionally may require an adjusted work schedule -evening/weekend hours in order to meet project deadlines or to access the computer system to support 2nd/3rd shift users
• Other duties as requested

COMPETENCIES

Problem Solving - Ability to problem solve through problem identification (what is the problem), solution assessment (what can be done), problem documentation (document for future) and problem response (implementing a solution).

   Able to:

• Frame problems before trying to solve them
• Break down problems and identify all of their components
• Provide insight into the root-causes of problems
• Generates a range of solutions and courses of action with benefits, costs, and risks associated with each.
• Anticipate problems and is proactive in addressing them
• Document and disseminate identification and resolution of problems to avoid future redundant work efforts

Decision making - Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals.

   Able to:

• Gather data and others' input when making decisions
• Consider lessons learned from experience, differing needs, and the impact of the decision on others
• Escalate decisions when appropriate
• Weigh pros and cons of each option before making a decision and moving forward.

 Customer Service - Ability to develop and maintain strong relationships with customers by listening, understanding and responding to their needs.

   Able to:

• Provide service to internal and external customers to satisfy their needs and expectations
• Listen to concerns and resolve reported issues effectively and promptly
• Deliver high quality solutions
• Commit to continuous improvement
• Ensure and comply to customer response timeline (SLAs) based on the severity of reported issues including documenting concise and accurate status information in the Service Now ticketing system

Company Business Knowledge - Understands the company, its products and the business processes.

     Able to:

• Understands various business functions and how technologies can support business processes.
• Know and apply specific business knowledge pertinent to job responsibilities
• Develop Reliance specific business knowledge.

Building Collaborative Relationships - Develops, maintains, and strengthens partnerships with others inside or outside the organization.

Able to:

• Establish rapport with co-workers easily
• Encourage and facilitate cooperation, pride, trust and group identity
• Foster commitment and team spirit
• Work with others to achieve goals
• Listen and respond constructively to other team members' ideas
• Offer support for others' ideas and proposals
• Be open with other team members about his/her concerns
• Share his/her expertise with others

Accountability - Holds self-accountable for measurable high-quality, timely, and cost-effective results.

Able to:

• Collaborate between own functional area and areas below or above in the work stream as needed
• Set well-defined and realistic goals
• Comply with established policies and procedures
• Allocate work where applicable
• Accept responsibility for mistakes
• Persistently push self and others for results
• Display a high level of initiative, effort, and commitment towards completing assignments
• Take ownership of successful outcome of work assignments/projects through collaborative efforts with team
• Minimize re-work
• Seek out learning opportunities
• Identify training needs and take action to obtain knowledge
• Provide consistency between projects

Communication - Ability to communicate effectively across all levels to support departmental and organizational objectives.

Able to:

• Clearly express information considering audience and nature of the information (for example, non-technical, sensitive, and controversial)
• Ask questions and summarize what was heard to prevent miscommunication
• Present information in a concise and focused manner
• Listen to others
• Communicate written information (for example, facts, ideas, or messages) in a succinct and organized manner
• Produce written information, which may include technical material that is appropriate for the intended audience

Leadership – Displays effort and commitment in carrying out the department’s goals and objectives.

Able to:

• Act in a proactive and achievement-oriented manner
• Treat co-workers in a fair and equitable manner
• Empower others by sharing information
• Actively listen and clarify information as needed
• Foster an atmosphere of open communication
• Behave in a tactful, compassionate, and sensitive manner

Required Experience

• Bachelor’s Degree or equivalent work experience in a related field required
• Must be self-motivated and able to work independently, with minimal supervision and as part of a team
• Detail oriented with excellent interpersonal communication skills
• Excellent customer service skills
• Strong organizational skills and ability to multi-task in an enterprise business environment
• 5+ years of experience as an Oracle DBA building and maintaining Real Application Clusters (RAC) as well as standalone Oracle instances required
• 3+ years of experience in data modeling required
• Strong knowledge of PL/SQL and SQL tuning required
• Good knowledge of shell, Perl or equivalent scripting language required
• Experience with MSSQL Databases a plus
• Experience in a data warehouse environment a plus
• Experience with Informix Databases a plus
• Strong written, verbal and presentation communication skills and ability to communicate at all levels within an organization

Database Management – Knowledge of the principles, procedures, and tools of data management, such as modeling techniques, data backup, data recovery, data dictionaries, data warehousing, data mining, data disposal, and data standardization processes.

• Install, configure, upgrade, administer, monitor and maintain database.
• Develop and design database strategies for system monitoring, improving database performance and capacity 
• Use database analysis skills to optimize applications
• Support backup and recovery activities
• Performance tuning for Oracle and PostgreSQL environments
• Capacity planning
• Documentation of physical data model

SUPPLEMENTAL DUTIES & RESPONSIBILITIES

• Pursues training and development opportunities; strives to continuously build knowledge and skills
• Assist personnel in other RTS departments to resolve technical and/or application issues
• Occasionally may require an adjusted work schedule -evening/weekend hours in order to meet project deadlines or to access the computer system to support 2nd/3rd shift users
• Other duties as requested

COMPETENCIES

Problem Solving - Ability to problem solve through problem identification (what is the problem), solution assessment (what can be done), problem documentation (document for future) and problem response (implementing a solution).

   Able to:

• Frame problems before trying to solve them
• Break down problems and identify all of their components
• Provide insight into the root-causes of problems
• Generates a range of solutions and courses of action with benefits, costs, and risks associated with each.
• Anticipate problems and is proactive in addressing them
• Document and disseminate identification and resolution of problems to avoid future redundant work efforts

Decision making - Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals.

   Able to:

• Gather data and others' input when making decisions
• Consider lessons learned from experience, differing needs, and the impact of the decision on others
• Escalate decisions when appropriate
• Weigh pros and cons of each option before making a decision and moving forward.

 Customer Service - Ability to develop and maintain strong relationships with customers by listening, understanding and responding to their needs.

   Able to:

• Provide service to internal and external customers to satisfy their needs and expectations
• Listen to concerns and resolve reported issues effectively and promptly
• Deliver high quality solutions
• Commit to continuous improvement
• Ensure and comply to customer response timeline (SLAs) based on the severity of reported issues including documenting concise and accurate status information in the Service Now ticketing system

Company Business Knowledge - Understands the company, its products and the business processes.

     Able to:

• Understands various business functions and how technologies can support business processes.
• Know and apply specific business knowledge pertinent to job responsibilities
• Develop Reliance specific business knowledge.

Building Collaborative Relationships - Develops, maintains, and strengthens partnerships with others inside or outside the organization.

Able to:

• Establish rapport with co-workers easily
• Encourage and facilitate cooperation, pride, trust and group identity
• Foster commitment and team spirit
• Work with others to achieve goals
• Listen and respond constructively to other team members' ideas
• Offer support for others' ideas and proposals
• Be open with other team members about his/her concerns
• Share his/her expertise with others

Accountability - Holds self-accountable for measurable high-quality, timely, and cost-effective results.

Able to:

• Collaborate between own functional area and areas below or above in the work stream as needed
• Set well-defined and realistic goals
• Comply with established policies and procedures
• Allocate work where applicable
• Accept responsibility for mistakes
• Persistently push self and others for results
• Display a high level of initiative, effort, and commitment towards completing assignments
• Take ownership of successful outcome of work assignments/projects through collaborative efforts with team
• Minimize re-work
• Seek out learning opportunities
• Identify training needs and take action to obtain knowledge
• Provide consistency between projects

Communication - Ability to communicate effectively across all levels to support departmental and organizational objectives.

Able to:

• Clearly express information considering audience and nature of the information (for example, non-technical, sensitive, and controversial)
• Ask questions and summarize what was heard to prevent miscommunication
• Present information in a concise and focused manner
• Listen to others
• Communicate written information (for example, facts, ideas, or messages) in a succinct and organized manner
• Produce written information, which may include technical material that is appropriate for the intended audience

Leadership – Displays effort and commitment in carrying out the department’s goals and objectives.

Able to:

• Act in a proactive and achievement-oriented manner
• Treat co-workers in a fair and equitable manner
• Empower others by sharing information
• Actively listen and clarify information as needed
• Foster an atmosphere of open communication
• Behave in a tactful, compassionate, and sensitive manner