• 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

• 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.