Database Administrator II - BCB00369
DESCRIPTION/RESPONSIBILITIES:
Summary
A DBA works on all aspects for a project. We are consulted for the design, the build and the end reporting or use of the data. The DBA needs to have in depth knowledge of the database platform he is assigned. The DBA is to aid the develop and technical leads in order that the project is successful.
Departmental Requirements:
* A successful candidate will have a minimum of five years experience as a DBA on either a SQL Server or Oracle platform.
* The candidate must have the ability to read and understand explain or access plans as well as how to tune the queries.
* The candidate needs to understand and explain memory structures and how the settings can affect performance.
* Must have worked in a Very Large Database (>15 Tb) and understand how that much data changes the complexion of what we do.
* Must have experience writing functions, procedures and anonymous blocks. He must have a better than average grasp of SQL and Transact SQL or PL/SQL.
* Knowledge of database set up, table creation, roles and security as well as tablespace fundamentals.
Departmental Preferences:
* Experience as a developer in a large data warehouse environment. An understanding of Informatica ETL tools are a plus. Knowledge of data compression and its affects is desirable.
Corporate Requirements:
Design, install, maintain and upgrade the enterprise’s databases. Provide technical expertise in the use of database technology and are accountable for the overall performance of the enterprise’s database environment. Work on multiple projects as a team member or technical lead. Support multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data.
Plan and organize database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery. Work closely with business and system analysts and solution developers to define and resolve information flow and content issues-helping to transform business requirements into environment specific databases. Translate logical data models into physical database designs. Develop physical databases. Assist in the establishment of database system flows. Develop and provide database requirements to system administrators. Code, edit, and install and verify stored procedures and functions for accessing, maintaining, and populating databases, as needed. Recommend and implements database solutions to support data integrity efforts. Participate in projects that require testing and produces metrics and samples for further analysis. Monitor utilization for capacity planning. Troubleshoot and resolve application (ex., SQL) performance issues. Monitor, analyze database performance and calibrate DBMS parameters so that the database is tuned for optimal performance. Maintain development, production, and multiple testing environments. Perform upgrades of databases, adding new structures or elements. Plan and manage the migration of databases. Install, configure and maintain the database management systems software. Build scripts automating the daily operations of database management. Monitor transactions between application systems and the database for the purpose of identifying and improving inefficiencies. Implement database backup and recovery procedures. Control privileges and permissions to database users. Assure that appropriate information security is applied in all tasks. Provide production support / database access 24 hrs x 7 days a week. Conduct Level 2 and 3 support. Troubleshoot database accessibility, availability or operability problems. Determine the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions. Escalate / ommunicate issues when necessary. Support enterprise standards. Assist in establishing database methods and procedures. Stay abreast of service level agreement levels. Take steps to meet or exceed requirements. Evaluate future technologies.