The candidate in this contract position 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.
ESSENTIAL FUNCTIONS
Works with a team to utilize one or more of the following premium and core technologies: Oracle RDBMS, Oracle RAC, Microsoft SQL Server RDBMS, Microsoft 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
Delivers and maintains data and/or database management systems
Plans and communicates server and storage capacity requirements
Installs and configures database software
Installs and configures appropriate or necessary software patch or upgrades
Designs and configures database operational structures per application functional and operational requirements
Configures 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 including: architecting the design of networks, hardware, software, backup and 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 24x7 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
Recognizes need to improve personal, interpersonal, and increase technical and leadership skills / behavior
Provides leadership, training and mentoring on departmental technologies, standards and processes to co-workers
QUALIFICATIONS AND TECHNICAL COMPETENCIES
Bachelor's degree in Computer Science, Mathematics, Business Administration, Engineering or a related field or equivalent experience
Six years' experience in information systems / technology
Four 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; Microsoft 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 modeling 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
Ability to communicate clearly in a timely manner in both verbal and written form
Ability to interact comfortably with more senior managers and executives
May be required to travel periodically
Will be required to provide on-call service
Meets established deadlines while maintaining a high level of quality
