- The database administration function provides in-depth technical expertise of database management systems, including database architecture, installation, and technical support of DBMS software.
- Provides technical support for data extraction, transformation, and load (ETL) tools, which are used to extract data from various database technologies, manipulate the data, and load to a new database environment.
- Provides in-depth technical expertise related to the ongoing maintenance and support of the database software. ( i.e.: Oracle, DB2, IDMS, SQL/SERVER).
Duties:
Responsible for compliance with applicable Corporate and Divisional Policies and procedures. Review, validate and enhance logical database designs. Define and implement physical databases. Perform database administration activities (e.g., modifications, enhancements, expansions). Conducts production database performance monitoring and capacity planning. Install, test and upgrade database releases and associated products. Assists in diagnosing database-related issues (e.g., database outages, application performance). Assist in developing database standards and procedures. Assist in the evaluation and recommendation of new database software, utilities, and tools. Responsible for compliance with applicable Corporate and Divisional Policies and procedures.
Required:
- At least two typically four years’ experience in Application Technology and/or 2-5 years in systems and/or network administration.
- Technical training including Database Administration, Performance and Tuning, and Backup and Recovery.
- Knowledge of the systems development life cycle preferred/a plus. Requires experience with file structures, design, retrieval and access methods, etc.
- Requires strong analytical and communication skills, as well as sound judgment and the ability to work effectively with client and IT management and staffs.
- Total combined experience: 7-10 years.
- Bachelor degree in Computer Science (or a related discipline).