Database Developer

Company: Kondaur Capital Corporation
Location: Orange, CA
Posted on: January 6, 2021

Job Description:

TITLE: Database Developer

REQUIREMENTS: Master of Science in Information Systems Engineering and Management, Cybersecurity or related field.

JOB DUTIES: Gather business objectives and the corresponding business requirements and prepare detailed design documents. Create databases, tables, views, stored procedures, Cluster/Non-Cluster Index, Constraints, Triggers and SQL agent jobs. Create relationships in data warehouse, ETL jobs and Reports. Perform database administrator duties such as server security, query optimization, storage management, indexing, backups, restores, monitoring production jobs. Maintain Batch logging, Error logging tables and handled errors using Event handlers. Create and Test SSIS packages to Export and Import data from SQL Server to Access, Text and Excel files and Configure SQL mail agent for sending automatic mails. Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and troubleshoot problems with SSIS packages. Develop reports using SSRS; manage deployments and subscription for business users. Create Various SSRS report models (Drilldown, Sub Reports, and Parameterized Reports). Deploy and upload the SSRS reports to Report Manager and SharePoint Server for the end users and involved in enhancements and modifications. Modify existing reports and create new reports with parameters, sub reports, cross tabs, using SAP Crystal Reports.

CONTACT: Please send resume/contact J. Zemanek for an appointment.

Kondaur Capital Corporation

333 S. Anita Dr., #400

Orange, CA 92868

Jobsite: Orange, CA (Full-time position)

Keywords: Kondaur Capital Corporation, Orange , Database Developer, Other , Orange, CA, California