Database Administrator

Job Summary

Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.

Responsibilities

• Assists more experienced Database Administrators (DBAs) with the testing of database software, utilities and patches within a test environment. Assists in the migration of tested/approved database software, utilities, and patches to production. Begins to demonstrate a database administration acumen.
• Assists with the completion of authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or sets up scheduled database audit procedures to track the who/when changes are made or new items are created within the database environment.
• Assists in the scheduling of database back-up tasks. Observes and supports more experienced DBAs during a disaster recovery and/or recovery exercises to continue familiarization and knowledge of database recovery tasks.
• Assists more experienced DBAs with storage and capacity planning by executing established reports, gathering additional data and occasionally performing basic routine maintenance such as data compression or defragmentation.
• Participates in database tuning, optimizing, and monitoring tasks by assisting more experienced DBAs with the execution of routine tasks such as monitoring query performance and rebuilding inconsistent and/or corrupt indexes.
• Assists more experienced DBAs during application failures to further develop knowledge and application of troubleshooting techniques.
• Gathers data/reporting and assists with the production and maintenance of operational database documentation, such as SQL Disaster Recovery, SQL Recovery Presentation, Naming Standards, Performance and Tuning.

What Are We Looking For in This Role

Minimum Qualifications

• Bachelors Degree
• Relevant Experience or Degree in: No degree specified
• Typically Minimum 5 Years Relevant Exp
• With the Installation, Customization, Testing and Maintenance of database systems within a production environment.

Preferred Qualifications

• IT related field

What Are Our Desired Skills and Capabilities

• Skills / Knowledge - Developing professional expertise, applies company policies and procedures to resolve a variety of issues.
• Job Complexity - Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors. Exercises judgment within defined procedures and practices to determine appropriate action. Builds productive internal/external working relationships.
• Supervision - Normally receives general instructions on routine work, detailed instructions on new projects or assignments.
• DBMS Knowledge - Extensive Knowledge of multiple database disciplines and technologies like MSSQL and also having knowledge of open source of DB technologies will be preferred.
• DBMS Utilities - Extensive Knowledge of multiple utilities utilized to manage, monitor and maintain database systems
• DBMS Recovery - Extensive Knowledge of recovery technologies for local and geographically disperse systems

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.