Manage Database Team located in multiple locations
Handle projects driven by both Offshore & Onshore
Distribute Work and project tasks
Track projects and daily tasks
Manage patch deployments and upgrades following best practices and provide capacity planning expertise
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
Plan for System change and implement
Provide support to Business during Release process.
Perform short- and long-term system/database planning and analysis including capacity planning, storage performance, system performance and database performance
Daily use of SQL, PL/SQL,T-SQL performance tuning
software installation, configuration, upgrade and maintenance activities
High Availability (HA) and Disaster Recovery (DR) options
Requirements
Implementing and maintaining large scale OLTP and OLAP systems in mission critical environments
Information security standards including database system hardening, identity management and database access controls
Should have knowledge of MS SQL & Oracle
Should have knowledge of Linux and Windows OS.
Should have experience in SQL
Knowledge of Shell, Perl, bash Scripting language
Administer custom engineered Oracle ExaDATA based Oracle Database software technologies
