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, Los Angeles , Database Developer, Other , Orange, CA, California