Oracle DBA with NoSQL

Location: Warren, NJ, us

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements, operational guidelines and protection 

- Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation 

- Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure 

- Act as liaison with customers 

- Tests designed applications 

- Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities 

- Research and evaluate alternatives and recommend solutions for business issues 

- Create ad-hoc reports utilizing various data sources 

- Maintain current knowledge of relevant technologies 

- Participates in continuous improvement efforts in enhancing performance and providing increased functionality 

Bachelors Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, or work experience 

Requires 2-5 years of related experience in the design, maintenance, and administration of NOSQL databases (Cassandra, Elastic Search) 

Requires 2-5 years of related experience in the design, maintenance, and administration of relational databases (Oracle, SQL*Server) 

Minimum of 5 years experience with developing software at the data layer in a SQL server environment using Transact-SQL 

Software development skills in object oriented programming including Microsoft ASP or .net, .net preferred 

SQL Server and Oracle database administration experience, experience with mission critical, OLTP applications preferred 

Knowledge of SQL Server performance tuning, backup and recovery methods 

Qualifications

Details: 

Plan, coordinate, and administer database systems, including base definition, structure, documentation, requirements, operational guidelines and protection 

- Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation 

- Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure 

- Act as liaison with customers 

- Tests designed applications 

- Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities 

- Research and evaluate alternatives and recommend solutions for business issues 

- Create ad-hoc reports utilizing various data sources 

- Maintain current knowledge of relevant technologies 

- Participates in continuous improvement efforts in enhancing performance and providing increased functionality 

Bachelors Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical training, or work experience 

Requires 2-5 years of related experience in the design, maintenance, and administration of relational databases 

Minimum of 5 years experience with developing software at the data layer in a SQL server environment using Transact-SQL 

Software development skills in object oriented programming including Microsoft ASP or .net, .net preferred 

SQL Server database administration experience, experience with mission critical, OLTP applications preferred 

Knowledge of SQL Server performance tuning, backup and recovery methods