Summary:
Performs scripting, design, analysis, installation, monitoring, administration, tuning, and upgrades for large-scale and complex database management systems (DBMS). Additionally, the Administrator manages all aspects of projects for various assigned initiatives; analyzes systems, evaluates business requirements and develops project plans from a set of written specifications. Generates solutions to technical issues and delivers results in a timely and efficient manner. The Sr. DBA researches and provides recommendations in support of procurement and development of database software and related tools.
Job Duties:
- Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems
- Designs and implements complex database solutions such as: clustering, mirroring, replication
- Acts as a project manager and leads cross functional teams on large corporate technology initiatives
- Creates and maintains database objects such as: tables, indexes, triggers, stored procedures
- Performs data analysis to provide management with timely and accurate information and predict future requirements
- Develops, implements and tests database backup and recovery policies and procedures
- Ensures databases have enough capacity for items such as: space, connections, memory, etc.
- Creates and maintains documentation for database policies, procedures, and processes
- Performs/schedules maintenance on databases to keep them running at peak performance
- Monitors database performance, availability, and capacity
- Participates in continuous business process redesign to improve internal operations
- Researches, evaluates, recommends, and implements database software and productivity tools
- Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
- Mentors and trains other DBAs in connection with their skill development objectives
- Interacts with software vendors to resolve issues
Skills and Qualifications:
- Strong knowledge of DBMS’s: Oracle, MS SQL Server, Sybase, or DB2 (LUW or Z/OS) preferred
- Strong knowledge of advanced database technologies: Sybase IQ, Sybase Replication Server, or DB2 PureScale preferred
- Must be able to design, implement, and support complex database implementations
- Knowledge of data modeling techniques
- Ability to work independently and in a team environment with minimal supervision
- Strong project management skills, including the ability to lead a cross functional team and drive results
- Must be self-motivated, a team player, and have a strong track record in customer satisfaction
- Strong database design and analysis skills
- Excellent written and verbal communication skills
- Ability to learn and apply new skills in a constantly changing technical environment
- Excellent analytical and problem-solving skills
- Strong working knowledge of SQL and SQL performance and tuning
- Strong knowledge of the UNIX operating systems
- In-depth knowledge and experience working with scripting languages: Korn, Perl, PowerShell, or Rexx preferred
- Ability to implement clustering technologies
- Ability to monitor and tune databases, instances, and the OS on which they reside
- Ability to maintain and monitor availability, security, and integrity of databases
- Must have in-depth knowledge of DBMS backup and recovery operations
- Ability to be a proponent and catalyst when adapting new software tools as they are acquired or adopted within IT
- Must be highly organized and detail-oriented
- Strong knowledge of relational database concepts and terminology
- Ability to work in a fast-paced, high volume work environment
- Ability to train and mentor other staff members
- Ability to multi-task and prioritize work
Education and Experience:
- Bachelor’s degree or equivalent experience and/or education
- 8 years of solid production support experience in two of the following databases: DB2 (LUW or Z/OS), Sybase, SQL Server or Oracle