Summary
Description
Summary of This Role
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.
What Part Will You Play?
* Coordinates and performs testing of database software, utilities and patches within a test environment prior to production roll out and reviews testing results to make a Go/No-Go recommendation. Assists less experienced Database Administrators (DBAs) with issue resolution during testing. Coordinates the migration of tested/approved software, utilities, and patches to the production environment. Develops various database configurations by creating database objects per specified business requirements and the necessary test environments, and interprets business requirements and advises less experienced DBAs. Works in close liaison with application developers, identifying potential impacts and providing insightful guidance/issues resolution to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Coaches/mentors less experienced DBAs as they begin to perform routine/basic database administration tasks.
* Completes authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or sets up a scheduled database audit procedure to track who/when changes are made or new items are created. Recommends and performs appropriate corrective actions based on audit results.
* Ensures the proper scheduling of database back-up tasks and the completion of scheduled tasks. Coordinates database recovery tasks during a disaster recovery and/or disaster recovery exercise to ensure compliance with Service Level Agreements (SLAs) recovery requirements.
* Monitors current usage levels of database storage, identifies and analyzes growth trends, and forecasts future storage requirements based on analysis results. Develops long-term capacity plans taking into account hardware lifecycles, current project requirements, and scheduled projects to be developed. Oversees and performs routine maintenance such as data compression and defragmentation.
* Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, and database design, and provides comprehensive recommendations for corrective actions. Applies routine and non-routine database tuning and optimization techniques, such as rebuilding indexes, determining when to create additional indexes, and performing in-depth reviews of queries to maintain database performance. Performs and reviews database statistic reporting on a regularly scheduled basis and provides recommendations to improve performance. Ensures the high availability of the supported database(s).
* Liaises with the Applications Team while performing troubleshooting to determine the source of application failures. Acts as a point of escalation for unresolved or complex failures. Recommends and develops solutions to minimize the potential of future application failures and assists in the implementation.
* Produces and reviews operational database documentation, such as SQL Disaster Recovery, SQL Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.
* Provides training and familiarization to less experienced DBAs regarding company policies and procedures, techniques, and current server/database configurations.
What Are We Looking For in This Role?
Minimum Qualifications
* Bachelor's Degree
* Relevant Experience or Degree in: No degree specified
* Typically Minimum 6 Years Relevant Experience
* With the Installation, Customization, Testing and Maintenance of database systems within a production environment.
Preferred Qualifications
* Bachelor's Degree
* IT related field
* Typically Minimum 8+ Years Relevant Experience
* As a technical lead, including the mentoring of less experienced DBAs.
What Are Our Desired Skills and Capabilities?
* Skills / Knowledge - Having wide-ranging experience, uses professional concepts and company objectives to resolve complex issues in creative and effective ways. Some barriers to entry exist at this level (e.g., dept./peer review).
* Job Complexity - Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results. Networks with key contacts outside own area of expertise.
* Supervision - Determines methods and procedures on new assignments and may coordinate activities of other personnel (Team Lead).
* DBMS Knowledge - Extensive Knowledge of multiple database disciplines and technologies.
* 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 dispersed systems.
#J-18808-Ljbffr