Position: Senior Database Administrator (Recent Job)

Job Description

• Perform data modeling, database design, master data management, and data profiling in a large-scale OLTP and OLAP database environments
• Identify strategies to meet application availability, scalability and performance requirements and areas of opportunity for optimizing the Oracle, MSSQL and Vertica environment
• Conduct performance trending and backups across multiple Database instances and create new accounts as required
• Manage patch deployments and upgrades following best practices and provide capacity planning expertise using Oracle's OEM Cloud Control
• Provide administration of development database environments including UAT, Processing, Development and QA based Oracle RAC database
• Perform security implementation in both OS and Database level of production servers ensuring several standard policies and compliances (HIPAA, SOX, PHI)
• Support the business to provide logistic support to Analytics, Production Engineers, Project Managers, and Developers
• Working with a distributed team of IT and DBA resources to collaborate effectively with internal and external stakeholders to ensure that Vertica database platforms are highly available, optimally configured and efficiently managed
• Maintain Production servers and minimize downtime and tuning performance of database instances
• Perform short- and long-term system/database planning and analysis including capacity planning, storage performance, system performance and database performance using RMAN backup and recovery, Oracle 12C and RAC production environments 
• Daily use of SQL, PL/SQL, T-SQL performance tuning of Oracle, MS SQL & Vertica Database software installation, configuration, upgrade and maintenance activities
• High Availability (HA) and Disaster Recovery (DR) options