Database Administrator

JOB SUMMARY
Responsible for the implementation and maintenance of production databases in compliance with application specifications and company policies, standards and procedures. Manages and maintains all production and non-production databases. You will be responsible for resolving the technical issues from beginning through completion for database security on the Imperva suite of database security tools.

MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience

• Performs installations and configurations of grid infrastructure, databases, clients etc
• Maintains standards and design of physical data storage, maintenance, access and security administration
• Creates/maintains backup and recovery strategies on Database Management Systems
• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data
• Installs, configures and maintains High Availability (RAC, RAC One Node, Data Guard etc.) server solutions
• Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. Performs database performance tuning tasks
• Utilizes OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues
• Implements multiple projects along with the Production Support
• Coordinate and automate SOX/PCI internal and external audits
• Monitor Kenna application for OS vulnerabilities. Create ServiceNow tickets to supporting teams for TOP fixes.
• Audit internal databases for user access and revoke/disable processes
• Handling level 1 support cases, working directly with Imperva vendor and Charter internal partners to achieve a resolution
• Monitor Imperva SecureSphere dashboard and analyze trends and anomalies

REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge

• Ability to read, write, speak and understand English
• Knowledge of Database Architecture and its implementation
• Knowledge of Imperva database security tools such as Counterbreach and SecureSphere
• Good knowledge of PL/SQL and ANSI SQL programming language
• Good knowledge of Instance, database and query tuning to improve the performance of the database/application
• Good understanding of Disaster Recovery (DR) methodologies
• Good understanding of SAN technologies related to database disk layouts
• Good knowledge of Windows/Linux/Solaris operating systems and shell scripting
• Good understanding of Change Management procedures
• Ability to communicate orally and in writing in a clear and straightforward manner
• Ability to communicate with all levels of management and company personnel
• Ability to handle multiple projects and tasks
• Ability to make decisions and solve problems while working under pressure
• Ability to prioritize and organize effectively
• Ability to show judgment and initiative and to accomplish job duties
• Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.)
• Ability to work independently
• Ability to work with others to resolve problems, handle requests or situations
• Ability to effectively consult with department managers and leaders

Education
BA/BS in Information Technology, Computer Science, or related field or equivalent work experience

Related Work Experience
3 to 6 years of experience working with Oracle/MS SQL/Teradata database management systems in testing, implementation, maintenance and administration in a multiple platform environment

WORKING CONDITIONS
Office environment
24x7 on-call support