MS Access DB Developer

Cenergy Rosemead , CA 91770

Posted 2 months ago

In this role, you will support company's Demand Response (DR) Team and support the development, implementation, and management of systems and technology that support the DR portfolio. You will develop complex requirements and expand the functionality of existing solutions. To succeed, you must have an aptitude for understand the business of company's DR programs and translating program changes to changes within the respective systems and technologies, strong data analytics and have a robust capability for problem solving. This role requires advance MS Access, MS SQL, and SAS skillset.

Job category

Branch

Pay rate

Posted date

3/19/2020

Job ID

Job type

  • MS Access Development (Required 5 Years)
  • Visual Basic for Applications (Required 5 Years)
  • MS Access SQL and Query design (Required 5 Years)
  • Experience splitting MS Access Databases into Front Ends and Back Ends (Required 3 Years)
  • Experience translating the business logic from macros/modules/queries to SQL (Required 4 Years)
  • Experience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server (Required 4 Years)
  • Experience converting MS Access Forms/ Reports to any Web based application (Required 4 Years)
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
MS Access Developer

Cenergy

Posted 2 months ago

VIEW JOBS 4/15/2020 12:00:00 AM 2020-07-14T00:00 In this role, you will be part of Demand Response (DR) Technical Operations team and support the development, implementation, and management of a MS Access front end database integrated with a MS SQL Server back end. This system has over 30 front end users and has automated processes that are utilized to integrate with multiple third party systems outside of network as well as main billing system. Job category Branch Pay rate Posted date 4/14/2020 Job ID Job type developing and deploying MS Access front-end systems, connecting to data warehouse utilizing ODBC to analyze millions of records and ensure data quality is accurate * Designing database tables and structures based on business process requirements in MS Access and MS SQL Server * Creating views, functions and stored procedure in MS SQL Sever to run daily, weekly, monthly automated jobs * Creating MS SQL Server and MS Access database triggers for use in automation * Experience and strong desire to invent new ways of approaching problems and developing innovative solutions to validate data * Experience creating databases with efficient structures (educational experience applies) * Demonstrated skills in writing optimized queries, views and triggers in MS Access, MS SQL Server, and SAS for integration with other applications Cenergy Rosemead CA

MS Access DB Developer

Cenergy