What are the responsibilities and job description for the Oracle DBA with NoSQL position at Sonsoft Inc?
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