Senior Applications Support Analyst

Responsibilities

• Act as team lead for day-to-day database operations including maintenance, monitoring, backup, and recovery
• Work with compliance and legal to determine data retention policies and execute retirement/purge parameters
• Define and implement security best practices to secure and maintain access to archived data
• Review application and database architecture to ensure high availability and scalability
• Perform application upgrades, installation, configuration, and troubleshooting for database infrastructure
• Coordinate with cross-functional teams to ensure appropriate backup schedules and data retrieval processes
• Develop data models for archive databases and execute data retirement processes
• Lead and coach junior DBAs in Oracle and SQL Server internals, RAC, RMAN, and Data Guard
• Monitor industry trends to identify opportunities for improved database archive operations

Requirements

• 5-10 years of experience in IBM-AIX, HP-UX, or Sun Solaris environments
• 5-10 years of experience as a DBA working with Oracle and SQL Server (including Oracle RAC and Data Guard)
• 5-10 years of experience with SQL Server 2005/2008
• Experience in large, 24x7 environments with multi-terabyte databases
• Proficiency in Shell, VB Script, T-SQL, and PL/SQL
• Experience with logical and physical data modeling
• Knowledge of Enterprise Archiving applications such as IBM Optim Infosphere
• Experience with Veritas Storage Foundations products
• Degree in Computer Science, Engineering, or Information Technology

Preferred Qualifications

• Knowledge of IBM Optim Data Archiving Tool
• Experience with telephony billing systems and related applications
• Expertise in database monitoring and tuning tools like OEM, Profiler, or Quest Spotlight