Database Administrator

The Database Administrator will be responsible for the design, development, implementation, integration, and maintenance of multiple premium and core database management technologies, tools and utilities. This position provides technical, interpersonal and administrative skills in performing day-to-day work.

JOB QUALIFICATIONS AND TECHNICAL COMPETENCIES:

- Bachelor's degree in Computer Science, Mathematics, Business Administration, Engineering or a related field
- 6 years' experience in information systems/technology
- 4 - 6 YEARS\' EXPERIENCE AS AN ORACLE DBA REQUIRED
- 4 years relevant experience with support or management of multiple relational database technologies
- Proven administrator experience with several of the following technologies, tools, utilities or methodologies: Oracle RDBMS, RAC; MS SQL Server RDBMS, Clustering; Sybase RDBMS, Replication; DB2, IMS, Adabase, Datacom; UNIX, Windows, Linux, IBM Mainframe; SQL, PL/SQL, Transact SQL, Shell, Perl; Database connectivity/networking - clients, ODBC, Oracle Internet Directory/Names; Data Modeling, Case Tools; RUP, SDLC; Greenplum, PostgreSQL
- Ability to effectively adapt to rapidly changing technologies and methodologies and apply them to technological and/or business needs of significant scope
- Understands data modelling concepts and methodologies
- Understands application development concepts and methodologies
- Ability to analyze, diagnose and resolve complex technical problems and system coordination issues
- Ability to plan and manage his/her own work, as well as 1-2 other team members
- Ability to work well with business customers and IT partners
- Ability to lead and collaborate with multi-discipline teams for work efforts which includes estimating, coordinating, tracking progress, inspiring others to complete tasks on time, assisting with resolving issues and creating status reports
- Communicates clearly in a timely manner in both verbal and written communication. Develop and maintains effective relationships within the team and across teams
- Ability to interact comfortably with more senior managers and executives, without display of overt tension and nervousness

ESSENTIAL FUNCTIONS:

- Works with a team to utilize one or more of the following premium and core technologies: Oracle RDBMS, Oracle RAC, MS SQL Server RDBMS, MS SQL Server Clustering, Sybase RDBMS, Sybase Replication, UNIX, Windows, Linux, SAN, NAS
- Expected deliverables include, but are not limited to: requirements analysis, system design, implementation, testing, troubleshooting, upgrading, patching, monitoring, tuning, securing, recovery and documentation of database management technologies, tools and utilities
- Adheres to departmental policies, standards and procedures. Those include, but are not limited to; technical and architecture standards, production and operational processes, and software license compliance
- Delivers and maintains data and/or database management systems
- Plans and communicates server and storage capacity requirements
- Installs and configure database software
- Installs and configures appropriate or necessary software patch or upgrades
- Designs and configures database operational structures per application functional and operational requirements
- Configurse database backups per operational requirements
- Configures database with application and user security per policy and standards
- Monitors and tunes databases to meet operational performance and capacity requirements
- Monitors and tunes databases to meet backup and security requirements
- Follows all established policies, procedures, processes, standards, or guidelines
- Works with software vendors to resolve technical issues with database functionality
- Develops and maintains database operational support documentation
- Provides development and operational support services to two or more core and preferred database technologies
- Designs and implements highly complex database systems or solutions. Includes architecting the design of networks, hardware, software, backup & recovery, security, capacity, performance, or replication as it pertains database solutions
- Performs regular review of database environments, systems or applications to ensure system recoverability, performance, security and capacity adequately supports defined system requirements
- Develops clear, quality and maintainable data management policies, standards, processes, procedures, methodologies, guidelines and system support guides. Seeks to improve policies, standards, processes and procedures
- Provides consulting and communication to co-workers, customers and partners regarding appropriate use of established departmental policies, standards, practices and appropriate use and compliance with software licenses
- Ensures 7x24 availability of production systems by participating in rotating on-call assignments
- Assumes responsibility for problem/outage resolution and timely recovery or restart of database systems or applications
- Maintains inventory of departmental assets
- Maintains knowledge of departmental software license inventory and utilization agreements
- Participates in the evaluation of departmental tools or utilities used to provide automation or operational efficiencies
- Plans, coordinates and facilitates highly complex changes to production environments and systems within approved maintenance windows and with no unapproved impact to customers
- Assists the manager in performing technical interviews, assessing technical abilities and personal behaviors, and provides recommendation for hiring
- Provides consulting support for IT and Business partners by researching, identifying and resolving complex technical problems
- Develops, tracks and executes quality work plans
- Understands, directs and participates in deliverables required by approved Development Lifecycles
- Seeks new knowledge independently, creatively crafts own development.
- Provides leadership, training and mentoring on departmental technologies, standards and processes to co-workers
- May be required to travel periodically
- Will be required to provide on-call service