Distributed Database Administrator Specialist

Job Description

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 preforms testing of database software, utilities and patches within a test environment prior to production roll out and review 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 with various database configurations by creating database objects per specified business requirements and the necessary test environments and interpret business requirements and advise less experienced DBAs. Works in close liaison with application developers, identifying potential impacts and provide 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 the 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 forecast future storage requirements based on analysis results. Development of long-term capacity plans taking into account hardware lifecycles, current projects requirements and scheduled project 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, database design, and provide comprehensive recommendations for corrective actions. Applies routine and non-routine database tuning and optimization techniques, such as rebuilding indexes, determines when and creates additional indexes and performs 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 QualificationsBachelors DegreeRelevant Experience or Degree in: No degree specifiedTypically Minimum 6 Years Relevant ExpWith the Installation, Customization, Testing and Maintenance of database systems within a production environment.Preferred QualificationsBachelors DegreeIT related fieldTypically Minimum 8+ Years Relevant ExpAs 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 technologiesDBMS Utilities - Extensive Knowledge of multiple utilities utilized to manage, monitor and maintain database systemsDBMS Recovery - Extensive Knowledge of recovery technologies for local and geographically disperse systems,

Keyskills :
databases sql atabaseadministration musicmaking sqlserver servicelevel databasedesign issueresolution databasesystems datacompression