What are the responsibilities and job description for the Database Developer position at Cloud9 Technologies?
Job Description
The primary responsibility of the Database Developer will be to provide technical support and expertise in the design, implementation, query support, and maintenance of core database management systems and databases that support the data analysis, research, and reporting. This includes designing and developing databases, and processing large volumes of data using databases and data from disparate HUD data systems. The developer will also provide perform Extract, Transform, and Load (ETL) processes and run ad-hoc queries against databases and generate ad-hoc reports.
Experience Requirements:
Perform data analysis; Create and update complex SQL queries to support data analysis using industry standard databases like MS Sqlserver, Oracle and MS Access
Database programming, data processing functions, and Software/System Development Life Cycle Methodology. Ability to lead a task and automate work processes.
Designing and developing relational databases in a production environment preferably HUD, based on interviews with customers and translation of very general requirements; a thorough knowledge of the syntax, capabilities, and limitations of a programming language such as T-SQL, PL/SQL as well as responsibility for implementation of the database.
Analyze, design and code stored procedures; packages and triggers; and creating design documents for customer-specific implementation and enhancement requests.
Extraction, transformation, and loading of large volumes of data, including automation of batch processes to reduce manual processing needs.
Proficiency with Oracle Database Server (SQL) 11g/12c, Oracle Database administration, including database backups and restore, user creation, and role administration.
Tool development using access or web a plus
Manage large volume data securely
Build tools to enable client to perform self-service Adhoc reports
Business intelligence tool experience is a plus
Create documentation and other system artifacts Requirements and design documents, Standard operating procedures (SOP), and test documents like test plan/test scripts.
Bachelor's degree in Computer Science, Mathematics, Information Systems, Engineering, or other related discipline.