Database Administrator

RESPONSIBILITIES

  • 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 11gR2 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

QUALIFICATIONS AND EDUCATION REQUIREMENTS

  • Bachelor Degree or equivalent degree in CS, IT, software or computer engineering, CIS, or any related field of study
  • 2+ years of experience AS DATABASE Administrator IN Oracle/MSSQL/Vertica

MUST HAVE SKILLS

  • 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
  • HIPAA regulations and PCI standards within the U.S. healthcare data management industry
  • OLTP and OLAP systems including, but not limited to, Oracle 10g/11g/12c, ASM, Oracle RAC, Oracle Grid Control, Data Pump, Data Guard, Oracle Streams, Oracle Directory Services, Oracle Enterprise Manager, Oracle Cloud Control.
  • MSSQL 2008 R2/2012/2014 Database administration including Always On Cluster
  • Vertica Database Administration
  • Should have knowledge of Linux and Windows OS.
  • Should have experience in PL/SQL in Oracle
  • Knowledge of Shell, Perl, bash Scripting language

PREFERABLE SKILLS

  • Knowledge of and demonstrable capability in scripting, experience in writing Python/PowerShell/Ruby and similar scripts; knowledge in Java is a plus.
  • Experience with Atlassian suite of tools (Jira, Confluence, Bamboo, Crucible)
  • Administer custom engineered Oracle EXADATA based Oracle Database software technologies

SOFT SKILLS

  • Ability to work independently or as part of a team
  • Persuasive in both written and verbal communication
  • US Healthcare experience would be added value

Deadline: 

Friday, December 29, 2017