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)
