Overview

The Senior Database Administrator performs high-complexity database management tasks, i.e. monitors and manages the integrity of all enterprise databases. He/she offers a high degree of expertise and specialized knowledge of data base management techniques which facilitate and expedite the usability, consistency, accuracy, integrity, security, timeliness and availability of enterprise data. The position performs ongoing and in-depth database analysis and is responsible to takes lead role in focused engagements and participates in multidisciplinary teams for new projects and troubleshooting of issues.

Responsibilities

• Works with vendors, users, applications developers and management to obtain information and develop an understanding of the needs of the organization and to overcome significant operational and/or technical issues or problems.
• Recommends potential solutions utilizing relational technology
• Recommends reviews and approves the design of physical data models and structures
• Provides advanced level database management, support and assistance
• Collaborates with and supports data architects and application developers in the physical design of databases
• Implements the physical database design and optimization strategies
• Leads database conversion and migration activities
• Analyzes, develops and supports disaster recovery plans
• Provides back-up and recovery procedures as needed for all production and test databases
• Provides technical consultation to the development staff and other IT organizations or groups
• Works with management and user committees in setting performance objectives
• Monitors and tunes database performance to meet performance objectives
• Manages and monitors storage capacity
• Evaluates, recommends, and participates in the installation of new storage media
• Supports operations staff with their production databases
• Works with programmers to tune data access codes
• Participates in IT committees to create standards for database utilization
• Maintains strong vendor relationships to keep apprised of new database products, versions, and releases
• Escalates intractable problems to the vendor
• Evaluates, recommends, and installs new versions and releases and new database tools
• Develops plans to install, maintain, enhance, test and migrates DBMS products and supporting software
• Coordinates with engineering staff to ensure consistency in planning and implementation efforts
• Works with application developers and other organizations within the enterprise to evaluate database requirements for application software packages under consideration
• Provides second level support to the database administrator
• Responds to and assists with other problem tickets as required
• Adheres to other defined SOPs as required
• Performs other duties as assigned

Qualifications

• Bachelor degree or equivalent work experience is required
• 7-10 years technical database administration experience or combination of training and experience is required
• 5-7 years’ experience in an IT organization and/or equivalent application or business experience is preferred
• Requires strong knowledge of logical design and physical implementation
• Requires knowledge of enterprise hardware and operations systems
• Exceptional interpersonal and communication skills with the ability to deal with a diverse range of people, which includes the upper levels of corporate management
• Self-sufficient, requiring limited supervision over job knowledge, expectations and successful project completion

Technical Skills:

• Knows how to use SSMS to monitor jobs, view history, set job notifications, set operators, enable and set Database Mail up
• Proficient with T-SQL
• Knows how to use SSMS to monitor access to the server and database
• Knows how to use SSMS to monitor the database server performance
  • Understands locking
  • Understands CPU time
  • Understands wait types
  • Understands physical reads and logical reads and writes
  • Understands sessions and requests
• Knows how to use SSMS and T-SQL to verify availability
  • Understands database states and user access options
• Knows how to operate and configure SQL Server services
• Understands Windows Clustering and other high availability solutions
• Knows T-SQL to troubleshoot errors
• Knows SSIS to troubleshoot errors
• Responds promptly to events
• Knows how to use SSMS and T-SQL to create logins and users, and to grant permissions
• Knows and uses System Management Views
• Understands SQL Server security architecture
• Knows how to use SSMS and T-SQL to create and modify databases
• Understands application needs before implementing the database
• Is familiar with Best Practices for database file structure, security, etc.
• Is familiar with pre-installation, installation and post-installation steps
• Is familiar with Best Practices as far as systems databases, security, etc.
• Knows how to use SSMS and T-SQL to run backups and recoveries
• Knowledge of Oracle Database is desirable. Version 10g and up.

• Knows how to connect
• Understands Oracle database architecture
• Knowledge of Oracle RAC is desirable
• Knows how to back up the database both online and offline
• Knows how to restore the database
• Knowledge of RMAN desirable
• Knowledge of UNIX and/or Linux bash shell.