5+ years' experience in Responsible for designing, implementing, and supporting enterprise standard databases based on business area requirements. Identify, define, and implement database backup/recovery and security strategies. Install and support DBMS (Database Management Systems) software and tools. Perform various database activities which include monitoring, tuning, capacity planning, troubleshooting, and consulting.
Essential Responsibilities*: • Translate a logical data model or user specifications into a physical design. • Ensure the detailed physical design of data structures and database complies with enterprise standards, guidelines, policies, procedures, and processes. • Create physical database structures based on physical design for development, test, and production environments. • Coordinate with system engineers to configure servers for DBMS product installation and database creation. • Install, configure, and maintain DBMS product software on database and application servers. • Provide consultation to application development teams on DBMS product technical issues and techniques. • Provide on-call support for databases 7 X 24. • Responsible for database performance tuning, security, and database backup/recovery strategy. • Implement monitoring procedures to maximize availability and performance of the database, while meeting defined targets. • Investigate, troubleshoot, and resolve database problems. • Coordinate downtime with the application development teams and system engineers to implement approved changes.
*May perform other duties as assigned.
Basic Entry Requirements: • Bachelor's degree, preferably in a technical or scientific field, with five plus years applicable experience in IT or three plus years of in-depth experience in the design, implementation, administration, and support of a database. • Candidate will have the experience in the above related areas, in addition to experience with operating systems software, networking tools, application development, multidimensional tools, knowledge of relational databases, logical modeling, and data warehouse. Previous airline experience is ideal.
Major Skills and Competencies:
CORE COMPETENCIES: • Communication Skills - The ability to communicate verbally and in writing with all levels of employees and management, capable of successful formal and informal communication, speaks and writes clearly and understandably at the right level. • Integrity and Trust - Involves being widely trusted, being seen as a direct, truthful individual, can present the unvarnished truth in an appropriate and helpful manner, keeps confidences, admits mistakes, and doesn't misrepresent him/herself for personal gain. • Teamwork - Involves working well in a collaborative setting, supporting work team by volunteering for and completing assignments, acting as a positive team member by contributing to discussions, developing and maintaining both formal and informal relationships enterprise-wide, defines success in terms of the entire team through mentoring and knowledge transfer. • Technical Expertise - Involves demonstrating a commitment to increasing knowledge and skills in current technical/functional area, keeping up to date on technical developments, staying informed as to industry practices, knowing how to apply relevant technical processes to appropriate business needs.
JOB SPECIFIC: • Dedication - Involves demonstrating a desire to dedicate time and energy to accomplish goals, tasks, assignments, etc. Will do what it takes to get things done. • Functional Expertise - Involves demonstrating knowledge of policies, general practices, procedures, etc. relevant for the area in which he/she works. • Planning - Accurately scopes out length and difficulty of tasks and projects, breaks down work into the process steps, develops schedules, anticipates and adjusts for problems and roadblocks. • Problem Solving - Uses rigorous logic and methods to solve difficult problems with effective solutions, probes all fruitful sources for answers, can see hidden problems, is excellent at honest analysis, looks beyond the obvious and doesn't stop at the first answer. • Task Management - Delivers quality work on time, translates planning into action by following applicable established procedures or methodologies, proactively monitors and controls task status by collecting and analyzing task data to anticipate and address barriers, appropriately communicates and resolves or escalates any problems that arise.