SQL/Web Developer
Partnership HealthPlan of California · Fairfield, California, US
Overview To design, develop, and test data transformations processes and related process automation at Partnership. To work with the Manager of Web Applicati...
Job description
Overview To design, develop, and test data transformations processes and related process automation at Partnership. To work with the Manager of Web Application Development in the design, development, testing, maintaining and migrating the databases and its related processes. Works closely with web Development team to maintain databases and its documentation. Responsibilities: - Designs, develops, test, and supports web applications using ASP, ASP.NET, ADO.NET, JQuery and AJAX. - Develops intelligent applications to automate processes and to increase productivity. - Designs, develops, test and deploy data transformations using SQL Server SSIS. - Design, develop and document existing databases and its schemas. - Establish owners for existing databases. - Migrate existing SQL Server databases to its most current versions. - Play a key role in managing the existing databases and monitor the usage - Design and develop reports using SSRS - Program data tasks and ad-hoc jobs using SQL Server/ Oracle PL/SQL and stored procedures - Develop or convert existing DTS packages to SSIS packages. - Provide day-to-day monitoring, troubleshooting, and performance tuning of all databases. - Create an...