Responsibilities:
- Maintains Oracle, SQL Server, and Postgres data bases in support of the Day-to-Day maintenance, development and installation of new systems and enhancements to existing systems.
- Uses available tools and utilities to provide for necessary DBMS maintenance activities: data base reorganizations, backup and recovery, space management, performance and tuning, and change management.
- Assists application developers and other clients with data base usage and software development activities.
- Ensures that all software or systems for which they are responsible are monitored and tuned to ensure acceptable levels of performance and resource utilization, ensures that the software is utilizing all appropriate functions and features, timely and accurate reporting on performance, utilization and feature use as requested.
- Stays current in new IT technologies to maintain high level subject matter expertise.
- Performs installation of complex, clustered and high-availability software and hardware environments in a timely manner in keeping with current release levels.
- Follows and maintains all Corporate Change Control and Audit requirements.
- Creates and maintains schedules for software maintenance and upgrades.
- Researches and provides requirements for software compatibility within organizations Enterprise Architecture.
- Provides technical assistance to Operations, Applications, Business Clients and the Help Desk in order to resolve production schedules or problems.
- Provides 24x7 on call support for assigned systems and software. Uses available resources to research, resolve and recommend solutions for the most complex and critical systems.
- Participates in and contributes to technical discussion within their team and shares their technical expertise to other activities.
- Communicates between key IT groups and the customer community via participation in meetings and the creation of status reporting mechanisms (weekly, monthly, and quarterly).
- Participates in organisation Enterprise-Wide technology projects for most complex and critical technologies.
?
Requirements:
- Requires experience as an Oracle Data Base Administrator and experience as a SQL Server Data Base Administrator.
- Postgres Data Base Administrator experience a plus.
?
Knowledge, Skills and Abilities Proficiency:
- Proficient with SQL performance and tuning Advanced.
- High-level of analytical and troubleshooting skills Advanced.
- In-depth knowledge of Oracle, MS SQL Server and similar databases Advanced.
- Knowledge of structured query language (SQL) Advanced.
?