Sr.SQL DBA(at least 10 years exp)

The Senior DBA MUST be proactive in improving the database, technical processes and customer relationships.Specific tasks may include but are not limited to:

• Assist with the design of a highly available fault tolerant database infrastructure
• Assist with technical design activities, including optimizing data access for a web portal application, leveraging features in SQL to reduce latency, and providing insights that could improve application performance
• Creation and maintenance of Application objects (For ex. Type of tables and indexes, Partition types/keys, foreign keys/constraints, segment type and size etc.)
• Creation of processes to replicate production databases (de-normalized to normalized)
• Help with layout application schemas and tablespaces
• Define and maintain database roles and permissions for Application objects
• Develop and execute statistics collection plan for application objects depending on volume and type of queries (For ex. Timing of statistics collections, Lock statistics, enable/disable HISTOGRAM etc.)
• Review backup policy with System DBA and help suggest schedule/timings to avoid conflict with application processes
• Review SQL execution plans on critical application queries
• Help with Application code testing during application releases or DB upgrade/migration to avoid SQL performance issues
• Bulk data uploads
• Assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness, and reducing single points of failure.

  Knowledge of Ghost Imaging software will be a plus